S level of care table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The '''s_level_of_care table''' in CCMDB.accdb contains identifiers of the laptops used to collect data. Equivalent to the data backup locations. This is '''not the name o..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The '''s_level_of_care table''' in [[CCMDB.accdb]] contains | The '''s_level_of_care table''' in [[CCMDB.accdb]] contains [[Level of care hierarchy]] values that map to [[Boarding Loc]] data decide which [[Boarding Loc]] entry to combine with which [[Transfer Ready DtTm tmp entry]] to calculate [[Transfer Delay]]. See [[Transfer Delay]] for details. | ||
== Data Structure == | == Data Structure == | ||
Revision as of 16:38, 15 October 2020
The s_level_of_care table in CCMDB.accdb contains Level of care hierarchy values that map to Boarding Loc data decide which Boarding Loc entry to combine with which Transfer Ready DtTm tmp entry to calculate Transfer Delay. See Transfer Delay for details.
Data Structure
| field | type | description |
|---|---|---|
| boarding_loc_item | Text(50) | link to L TmpV2 table Boarding Loc item entry |
| boarding_log_comment | Text(50) | link to L TmpV2 table Boarding Loc comment entry |
| level_of_care | single | care level, arbitrary value to show level relative to others |