Query check tmp AHC: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 17: Line 17:
* dttms must be chronological for groupings linked by int_var
* dttms must be chronological for groupings linked by int_var
* if there is an option entry the consult can not be "never addressed"
* if there is an option entry the consult can not be "never addressed"
{{DL| others? }}
{{DL| * if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|Lisa Kaita]] 11:31, 7 August 2025 (CDT) }}
{{DJ| others? }}
{{DJ| others? }}



Revision as of 11:31, 7 August 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, 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

  • must have an entry to send
  • 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"
  • if there is referral sent there must be a referral received entry and a consult dealt with entryLisa Kaita 11:31, 7 August 2025 (CDT)
  • 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: