Query check tmp AHC

Revision as of 00:08, 20 July 2025 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=For patients with Previous Location ER at same site there should be a Boarding Loc ER. |DIC_related_concepts=Project AHC; Site; SentDtTm; Admit_DtTm; Dispo_DtTm |DIC_firmness=hard check |DIC_coding=query ''check_tmp_AHC'' |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb |DIC_backlogged= }} Cross-checks for Project AHC. == Consistency Checks == * dttms within admission * dttms must be chronological for groupin...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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, Dispo_DtTm
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_tmp_AHC
Uses L Problem table: not relevant for this app
Status:
Implementation Date:
Backlogged:
  • Cargo


  • SMW


  • Categories:  
  • form:

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?

  • SMW


  • Cargo


  • Categories
 

others?

  • SMW


  • Cargo


  • Categories

Log

  • 2025-07-20 - preliminary data review and initial cross check definitions
  • 2025-07-02 - collection started

Related articles

Related articles: