Query check ICD10 date: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
|DIC_summary=[[Acquired Diagnosis / Complication]] must have [[Dx Date]] or [[Dx Date unknown]], other [[Dx Type]] must have neither, and must be [[ | |DIC_summary=[[Acquired Diagnosis / Complication]] must have [[Dx Date]] or [[Dx Date unknown]], other [[Dx Type]] must have neither, and must be [[Admit DtTm]]<[[Dx_Date]]<[[Dispo_DtTm]] | ||
|DIC_related_concepts=ICD10 Diagnosis; Acquired Diagnosis; Admit Diagnosis; Comorbid Diagnosis; Dx Type; Dx Date; Dx Date unknown; Dispo DtTm field; Service tmp entry | |DIC_related_concepts=ICD10 Diagnosis; Acquired Diagnosis; Admit Diagnosis; Comorbid Diagnosis; Dx Type; Dx Date; Dx Date unknown; Dispo DtTm field; Service tmp entry; Admit DtTm | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_timing=complete | |DIC_timing=complete | ||
| Line 14: | Line 14: | ||
== Log == | == Log == | ||
* 2022-03-31 - updated to use first [[Service tmp entry]] instead of | * 2022-03-31 - updated to use first [[Service tmp entry]] instead of "Accept DtTm" | ||
* 2020-10-15 - changed start limit from [[Arrive DtTm]] to [[Accept DtTm]] since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away. | * 2020-10-15 - changed start limit from [[Arrive DtTm]] to [[Accept DtTm]] since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away. | ||
Revision as of 14:32, 19 April 2022
| Data Integrity Checks | |
| Summary: | Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Admit DtTm<Dx_Date<Dispo_DtTm |
| Related: | ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date, Dx Date unknown, Dispo DtTm field, Service tmp entry, Admit DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_ICD10_date |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | 2018-10-01 |
| Backlogged: | No |
If this check changes, consider whether Query check CCI Date should be changed the same way.
Log
- 2022-03-31 - updated to use first Service tmp entry instead of "Accept DtTm"
- 2020-10-15 - changed start limit from Arrive DtTm to Accept DtTm since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away.