Query check ICD10 date
| 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 |
| 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.