Dispo DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m No longer part of minimal data set
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,597 edits
Line 17: Line 17:
=== Discharge at midnight ===
=== Discharge at midnight ===
If the patient is discharged at '''24:00/midnight''', use 23:59 hours as the discharge time.
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.
{{DJ
| 
* This wouldn't be [[Minimal Data Set]], actually. I don't think it is checked at all any more, when it's done it's done. So do we still need this rule? It was initially set up when these were two separate fields, and before we had Cognos - there should no reason to ever have a date and no time now.
}}


=== [[Deceased patients]] ===
=== [[Deceased patients]] ===

Revision as of 18:01, 8 February 2022

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)

 AppStatus
Query TISS Errors NrTISSDays NE LOSCCMDB.accdbdeclined
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysCCMDB.accdbdeclined
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check_Project_OT_PT_ConsultsCCMDB.accdbimplemented
query check_Project_Consults_dataCCMDB.accdbimplemented
Query check ACP Status Collection for LAUCCMDB.accdbimplemented
Query check LAU collection readmission dataCCMDB.accdbimplemented
Query check tmp BedHeldCCMDB.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 check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check long transfer delayCCMDB.accdbneeds review
Function long LOS()CCMDB.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 TISS date out of admissionTISS28.accdbretired
Query TISS Errors missing daysTISS28.accdbretired

Legacy

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Dispo_DtTm_field&oldid=154480"