Arrive DtTm field

From CCMDB Wiki
Jump to navigation Jump to search
Data Element (edit)
Field Name: Arrive_DtTm
CCMDB Label: Arrive DtTm
CCMDB tab: Dispo
Table: L Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 2016-07-01
End Date: 2300-01-01
Sort Index: 45

First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.

Collection Instruction

For each patient enter the First non-ER Boarding Loc date and time as Arrive DtTm field. Follow the instructions at Boarding Loc.

This means the Arrive DtTm field should be equal to the first Boarding Loc DtTm.

Planned elimination of this field

see Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc

Data Integrity Checks (automatic list)

 AppStatus
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmCCMDB.accdbdeclined
Query TISS Errors NrTISSDays NE LOSCCMDB.accdbdeclined
Check duplicate patientCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Function Dispo Chronological()CCMDB.accdbimplemented
Query check ER Delay not too bigCCMDB.accdbimplemented
Check Sub PharmCheckCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Function long LOS()CCMDB.accdbneeds review
Query check CCI CXR vs LOSCCMDB.accdbneeds review
Check Function Panelling admit transfer sameCCMDB.accdbretired
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Query NDC VAP unacceptable dateCentralized data front end.accdbretired
Query NDC CLI unacceptable dateCentralized data front end.accdbretired
Link suspect transfer ready before arrive dateCentralized data front end.accdbretired
Query TISS Errors missing daysTISS28.accdbretired
Query TISS Errors TISS date out of admissionTISS28.accdbretired

Legacy

Click to see legacy info   
  • For Medicine this concept is related to old ER Wait date an time.
  • From June 1, 2011 to June 30, 2016, the Arrive_DtTm in Medicine was in the Tmp project ER Wait and was migrated into the Arrive_DtTm field.
  • For ICU this concept is related to the old Admit date and time. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.

Related Articles

Related articles: