S LocationData table: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 10: | Line 10: | ||
|| '''location_name''' || text || unique ID, name of the location in [[s_dispo table]] and [[Boarding Loc]] and on this wiki | || '''location_name''' || text || unique ID, name of the location in [[s_dispo table]] and [[Boarding Loc]] and on this wiki | ||
|- | |- | ||
|| ''' | || '''attribute_name''' || text || name of the attribute, e.g. "bed count"; there should be a wiki page for each of these to explain how they are used and how they tie into queries and reports | ||
|- | |- | ||
|| ''' | || '''attribute_value''' || text || value of the attribute, e.g. "15" in case of bed number | ||
|- | |- | ||
|| '''Start_DtTm''' || date || when this location-attribute-value combination becomes active | || '''Start_DtTm''' || date || when this location-attribute-value combination becomes active | ||