S LocationData table

From CCMDB Wiki
Revision as of 10:27, 2022 February 10 by Ttenbergen (talk | contribs) (Created page with "The '''s_LocationData''' table in CCMDB.accdb contains the possible values for the metadata for locations. See Location metadata storage. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''location_name''' || text || unique ID |- || '''attribute''' || text || name of the attribute, e.g. "bed count" |- || '''value''' || text || value of the attribute, e.g. "15" in case of bed number |- || '''Start_DtTm''' || date ||...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The s_LocationData table in CCMDB.accdb contains the possible values for the metadata for locations. See Location metadata storage.

Data Structure

field type description
location_name text unique ID
attribute text name of the attribute, e.g. "bed count"
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
Etart_DtTm date when this location-attribute-value combination stops


Related articles

Related articles:

*

Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_LocationData_table&oldid=154591"