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 |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''s_level_of_care table''' in [[CCMDB.accdb]] contains | {{DISPLAYTITLE:s_level_of_care table}}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 == | ||
| Line 10: | Line 10: | ||
|| '''boarding_loc_item''' || Text(50) || link to [[L TmpV2 table]] [[Boarding Loc]] item entry | || '''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 | || '''boarding_log_comment''' || Text(50) || '''link''' to [[L TmpV2 table]] [[Boarding Loc]] comment entry (don't put comments there) | ||
|- | |- | ||
|| '''level_of_care''' || single || care level, arbitrary value to show level relative to others | || '''level_of_care''' || single || care level, arbitrary value to show level relative to others | ||
|- | |||
|| '''boarding''' || boolean || true if this is a boarding location, ie physical location details would be in comment; used for filtering convenience | |||
|} | |} | ||
Latest revision as of 15:26, 17 May 2023
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 (don't put comments there) |
| level_of_care | single | care level, arbitrary value to show level relative to others |
| boarding | boolean | true if this is a boarding location, ie physical location details would be in comment; used for filtering convenience |