S level of care table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
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. | {{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, 2023 May 17
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 |