Arrive DtTm field

From CCMDB Wiki
(Redirected from Arrive DtTm)
Jump to navigationJump 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

Date and time when the patient physically arrived on unit. As in, arrived at (Service/Location field).

Collection Instruction

For each patient enter the date and time when the patient physically arrived on the ward. For off ward patients,

  • if the patient does arrive on your unit, then the Arrive DtTm will be the physical arrival on the unit, while the Accept DtTm will be when the service accepted care of the patient

sources for Arrive DtTm


To find the arrive date & time when using electronic patient record (epr):

  • clicking on Registration (on top left bar)
  • then Visit Location, then Location History
  • A new Location History window will pop up that will tell you the date & time that the patient arrived at a particular location.

First set of vital signs

The first set of vital signs can be used as ArriveDtTm if data in EPR is not good.

Accept DtTm > Arrive DtTm

If the Accept DtTm > Arrive DtTm, make accept = arrive.

pt never arrives on your unit

Data Use

Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)

Minimal Data Set

This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.

Data Integrity Checks

Data Integrity Checks (SMW)

Query check minimal data set incompleteCCMDB.mdbimplemented
Query check ER Delay not too bigCCMDB.mdbimplemented
Function long LOS()CCMDB.mdbimplemented
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmCCMDB.mdbimplemented
Query check ICD10 dateCCMDB.mdbimplemented
Function Dispo Chronological()CCMDB.mdbimplemented
Query check CCI DateCCMDB.mdbimplemented
Check CCI CXR vs LOSCCMDB.mdbready to implement
Check Function Panelling admit transfer sameCCMDB.mdbretired
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Query NDC CLI unacceptable dateCentralized data front end.accdbretired
Query NDC VAP unacceptable dateCentralized data front end.accdbretired
Query TISS Errors TISS date out of admissionTISS28.mdbimplemented
Query TISS Errors missing daysTISS28.mdbimplemented
Query TISS Errors NrTISSDays NE LOSTISS28.mdbimplemented


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: