S LocationData table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 29: | Line 29: | ||
}} | }} | ||
{{ | {{TT | | ||
* I added some sample data to this table. I will eventually add the pulling into CFE of this table to automation CFE, but if you want to test how this data would work in your queries for now, you can link it in manually and work with the sample data in there. Processes to get data in there and all that still to come. [[User:Ttenbergen|Ttenbergen]] 13:45, 2022 February 10 (CST) | * I added some sample data to this table. I will eventually add the pulling into CFE of this table to automation CFE, but if you want to test how this data would work in your queries for now, you can link it in manually and work with the sample data in there. Processes to get data in there and all that still to come. [[User:Ttenbergen|Ttenbergen]] 13:45, 2022 February 10 (CST) | ||
** No longer applicable, we discussed today that we will need multiple start and end dates and that it maybe should be stored on wiki. Taking off Julie's list in any case. [[User:Ttenbergen|Ttenbergen]] 15:59, 2022 June 22 (CDT) | |||
}} | }} | ||
Revision as of 15:59, 2022 June 22
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, 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 |
End_DtTm | date | when this location-attribute-value combination stops |
End_DtTm is not needed for complete info, and in fact could become inconsistent, but it will make it easier to use this data in queries. Since updates will be rarer than use we decided to include the End_DtTm explicitly.
|
|
Related articles
Related articles: |