Dispo DtTm field

From CCMDB Wiki
(Redirected from Dispo DtTm)
Jump to navigation Jump to search
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

Collection Instruction

For each discharged patient enter the date and time when the patient left the unit as found in Cognos2 Ender.

Discharge at midnight

If the patient is discharged at 24:00/midnight, use 23:59 hours as the discharge time.

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

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
Check duplicate patientCCMDB.accdbimplemented
Query check tmp BedHeldCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check CCI vs LOS count days picklistCCMDB.accdbimplemented
Query check CCI vs LOS count days componentCCMDB.accdbimplemented
Query check transfer DtTm during admissionCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Function long LOS()CCMDB.accdbneeds review
Query check long transfer delayCCMDB.accdbneeds review
Function Dispo Chronological()CCMDB.accdbretired
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 missing daysTISS28.accdbretired
Query TISS Errors TISS date out of admissionTISS28.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: