Difference between revisions of "Arrive DtTm field"

From CCMDB Wiki
Jump to navigationJump to search
Line 57: Line 57:
[[Category:2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category:Data Collection Guide]]

Latest revision as of 14:42, 2020 July 17

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 ( Service Location) or in a Boarding location.

Collection Instruction

For each patient enter the date and time when the patient physically arrived on the unit ( Service Location) or in a Boarding location.

Consider the Boarding Loc instructions when you enter decide what this field needs to be.

sources for Arrive DtTm

EPR Reports

To find the arrive date & time when using EPR Reports:

  • Go to "transfer Register" and enter all criteria ie. facility site, date parameters, unit/ward parameters, to or from location, filter for between unit transfers only, sort as desired, generate a report, the Arrive DtTm will be in the Transfer/Date/Time column

First set of vital signs

The first set of vital signs is used as ArriveDtTm in ICU collection, if it is different from the EPR Admit DtTm. The ADT Unit arrive DtTm will still show up in EPR Admit DtTm field if the patient was entered using one of the integrators.

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)

Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Function long LOS()CCMDB.accdbimplemented
Query s tmp Boarding Loc no borrow but entryCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check ER Delay not too bigCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Function Dispo Chronological()CCMDB.accdbimplemented
Check CCI CXR vs LOSCCMDB.accdbneeds review
Check Function Panelling admit transfer sameCCMDB.accdbretired
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Link suspect transfer ready before arrive dateCentralized data front end.accdbimplemented
Query NDC CLI unacceptable dateCentralized data front end.accdbretired
Query NDC VAP unacceptable dateCentralized data front end.accdbretired


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: