| Data Integrity Checks
|
| Summary:
|
Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Arrive_DtTm<Dx_Date<Dispo_DtTm
|
| Related:
|
ICD10 Diagnosis, Acquired Diagnosis, Admit Diagnosis, Comorbid Diagnosis, Dx Type, Dx Date, Dx Date unknown, Dispo DtTm field, Accept DtTm field
|
| 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
- 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.
Related articles