Dispo DtTm field

From CCMDB Wiki
(Redirected from Dispo DtTm)
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..

  • SMW

Legacy implementation right in the table

  • Cargo

  • Categories
  • Forms

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 (automatic list)

Query TISS Errors NrTISSDays NE LOSCCMDB.accdbdeclined
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Function Dispo Chronological()CCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query check transfer DtTm during admissionCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI CXR vs LOSCCMDB.accdbneeds review
Query check long transfer delayCCMDB.accdbneeds review
Function long LOS()CCMDB.accdbneeds review
Query check CCI vs LOS count daysCCMDB.accdbready to implement
Link suspect negative transit time queryCentralized data front end.accdbimplemented
Link suspect transfer ready greater than dispoCentralized data front end.accdbretired
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.accdbretired
Query TISS Errors missing daysTISS28.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: