Dx Date: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 17: Line 17:
It is '''not collected''' for [[Admit Diagnosis]] and [[Comorbid Diagnosis]].
It is '''not collected''' for [[Admit Diagnosis]] and [[Comorbid Diagnosis]].


== Proposed change ==
== Moves ==
{{TT
{{DxPxDateTime Instructions}}
* Like [[Px Date]] '''time''', we may need a time '''only for CC and days where there is a [[Boarding Loc]] move'''. Since for Dxs it is often less clear when exactly they occur, the proposed rule would be that wherever not clear, use no time, i.e. it will be assigned to first unit. Do collectors see a problem with this? [[User:Ttenbergen|Ttenbergen]] 11:32, 2021 September 22 (CDT)
** Was discussed at [https://ccmdb.kuality.ca/index.php?title=Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2021#ICU Database Task Group Meeting – September 23, 2021 Task] and Tina needs to implement. [[User:Ttenbergen|Ttenbergen]] 12:11, 2021 October 13 (CDT)
}}


== Data Integrity Checks ==
== Data Integrity Checks ==
* [[Query check ICD10 date]]
{{Data Integrity Check List}}
* [[Query check ICD10 date]]


== Related Articles ==
== Related Articles ==

Latest revision as of 14:33, 2021 October 20

Data Element (edit)
Field Name: Dx_Date
CCMDB Label: Date/unknown
CCMDB tab: ICD10
Table: L ICD10 table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 4

The date/time of an ICD10 diagnosis.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


The Dx Date is coded as part of the ICD10 collection. It contains the date that an Acquired Diagnosis / Complication was made.

This is a mandatory field for Acquired Diagnosis / Complication diagnoses. If a date is not available, Dx Date unknown must be checked.

It is not collected for Admit Diagnosis and Comorbid Diagnosis.

Moves

For Critical Care data collection

In order to still be able to associate dxs, procedures and TISS entries with the location where they happen under PatientFollow Project, we use the time component of the Date to link the Dx/Px to a Boarding Loc.

For a patient who moves on the day of the procedure or diagnosis, enter the date that corresponds to the Boarding Loc where the pt was at the time of the procedure:

  • if pt is in a location where they were already yesterday, or for the only Boarding Loc that day, use 0:00
  • for a procedure that happened while at a new location that day, enter as Px Date the same DtTm as used for the current Boarding Loc
    • if pt is at third location that day, use the third location's Boarding Loc, etc

For Medicine Data Collection

Enter the appropriate date, but leave the time as 0:00

Data Integrity Checks

Data Integrity Checks (automatic list)

 AppStatus
Query check ICD10 dateCCMDB.accdbimplemented

Related Articles

Related articles: