Query check tmp AHC
| Data Integrity Checks | |
| Summary: | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Related: | Project AHC, Site, SentDtTm, Admit DtTm (Admit_DtTm), Dispo DtTm (Dispo_DtTm) |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_tmp_AHC |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | not entered |
| Backlogged: | No |
Cross-checks for Project AHC.
Consistency Checks
- dttms within admission
- dttms must be chronological for groupings linked by int_var
- if there is an option entry the consult can not be "never addressed"
|
others? |
|
others? |
Log
- 2025-07-20 - preliminary data review and initial cross check definitions
- 2025-07-02 - collection started
Related articles
| Related articles: |