S level of care table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (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 20: | Line 20: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: PatientFollow Project]] | [[Category:PatientFollow Project]] | ||
Latest revision as of 12:05, 30 July 2025
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 |