Dispo DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "Category: L_Log table" to ""
 
(32 intermediate revisions by 8 users not shown)
Line 4: Line 4:
| CCMDB_tab = Dispo
| CCMDB_tab = Dispo
| element_description = Date and time when the patient changed status from what is documented in [[Service/Location field]] to [[Dispo field]]..
| element_description = Date and time when the patient changed status from what is documented in [[Service/Location field]] to [[Dispo field]]..
| in_table = L_Log
| in_table = L_Log table
| data_type = date
| data_type = date
| program_collecting = Med and CC
| program_collecting = Med and CC
Line 12: Line 12:
}}
}}


See also [[Service/Location field]] and [[Dispo field]].
== Collection Instruction ==
For each discharged patient enter the date and time when the patient left the unit as found in [[Cognos2 Ender]].


== Collection Instruction ==
=== Discharge at midnight ===
For each patient enter the date and time when the patient left the unit as written in the '''unit logbook''', EPR, nursing note or chart whichever is more accurate at your site.  
If the patient is discharged at '''24:00/midnight''', use 23:59 hours as the discharge time.


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.
=== [[Deceased patients]] ===
See [[Deceased patients#General instructions for deceased patients]]


=== discharge at midnight ===
=== [[Visits to temporary locations]] ===
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.


===Expired===
=== [[AMA]] ===
Use time of death as [[Dispo DtTm]]. However, for '''[[Organ Donor]]s''' patients see that article.


== Data use ==
== Data use ==
Among other things, the times are used to generate statistics about  
Among other things, the times are used to generate statistics about  
* [[:Category: Length of stay | LOS]]
* [[:Category: Length of stay|LOS]]
* [[Multiple Encounter]]  
* [[Multiple Encounter]]  
* [[Transfer Delay]]
* [[Transfer Delay]]
* [[bed occupancy]]
* [[bed occupancy]]


== {{CCMDB Data Integrity Checks}} ==
{{Data Integrity Check List}}
* [[Function Dispo Chronological()]]
* [[Function long LOS()]]


== Legacy ==
== Legacy ==
Line 41: Line 38:
Similar to the old [[Discharge date and time]] resp the fields L_Log.R_DisDate and L_Log.R_DisTime.
Similar to the old [[Discharge date and time]] resp the fields L_Log.R_DisDate and L_Log.R_DisTime.


[[Category: 2016 Time and Place changes]]
== Related Articles ==
[[Category: Admit/Discharge]]
{{Related Articles}}
 
[[Category:2016 Time and Place changes]]
[[Category:Admit/Discharge]]
[[Category:Dispo]]
[[Category:Length of stay]]
[[Category:End-of-life related data]]
[[Category:Data Collection Guide]]

Latest revision as of 15:12, 8 December 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
Data Dependencies(Reports/Indicators/Data Elements):

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

AMA

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 check LAU collection readmission dataCCMDB.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
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI vs LOS count days componentCCMDB.accdbimplemented
Query check CCI vs LOS count days picklistCCMDB.accdbimplemented
Query check tmp BedHeldCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
query check_Project_Consults_dataCCMDB.accdbimplemented
Query check_Project_OT_PT_ConsultsCCMDB.accdbimplemented
Query check ACP Status CollectionCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query check_tmp_AHCCCMDB.accdbneeds review
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 missing daysTISS28.accdbretired
Query TISS Errors TISS date out of admissionTISS28.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=158056"