S level of care table

From CCMDB Wiki
Jump to navigationJump to search

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

Related articles

Related articles: