Query check tmp AHC: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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..."
 
No edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=For patients with [[Previous Location]] ER at same site there should be a [[Boarding Loc]] ER.  
|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_related_concepts=Project AHC; Site; SentDtTm; Admit DtTm (Admit_DtTm); Dispo DtTm (Dispo_DtTm)
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=complete
|DIC_coding=query ''check_tmp_AHC''
|DIC_coding=query ''check_tmp_AHC''
|DIC_implementation_date=
|DIC_status=needs review
|DIC_status=
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=
|DIC_backlogged=No
}}
}}
Cross-checks for [[Project AHC]].  
Cross-checks for [[Project AHC]].  



Revision as of 01:08, 20 July 2025

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
  • 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: