Difference between revisions of "Dispo DtTm field"

From CCMDB Wiki
Jump to navigationJump to search
Line 51: Line 51:
[[Category:Length of stay]]
[[Category:Length of stay]]
[[Category:End-of-life related data]]
[[Category:End-of-life related data]]
[[Category:Data Collection Guide]]

Latest revision as of 15:02, 2020 July 17

Data Element (edit)
Field Name: Dispo_DtTm
CCMDB Label: Dispo 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: 46

Date and time when the patient changed status from what is documented in Service/Location field to Dispo field..

See also Service/Location field and Dispo field.

Collection Instruction

For each patient enter the date and time when the patient left the unit as found in EPR (under patient information tab, demographics) Or by using EPR reports "discharge register"

We track Dispo DtTm field for patients as part of our Minimal Data Set, i.e. this his high-priority data that needs to be collected ASAP.

discharge at midnight

If the patient is discharged at 24:00/midnight, use 23:59 hours as the discharge time. This is so that Minimal Data Set can check for date being entered properly even if time is not yet available.

Deceased patients

See Deceased patients#General instructions for deceased patients

Visits to temporary locations]

Data use

Among other things, the times are used to generate statistics about

Date Integrity Checks

Data Integrity Checks (SMW)

Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Check duplicate patientCCMDB.accdbimplemented
Function Dispo Chronological()CCMDB.accdbimplemented
Function long LOS()CCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query s tmp Boarding Loc no borrow but entryCCMDB.accdbimplemented
Query check long transfer delayCCMDB.accdbneeds review
Check CCI CXR vs LOSCCMDB.accdbneeds review
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Link suspect transfer ready greater than dispoCentralized data front end.accdbimplemented
Query NDC VAP unacceptable dateCentralized data front end.accdbretired
Query NDC CLI unacceptable dateCentralized data front end.accdbretired


This field is part of the 2016 Time and Place changes. Similar to the old Discharge date and time resp the fields L_Log.R_DisDate and L_Log.R_DisTime.

Related Articles

Related articles: