Query s tmp ACP

From CCMDB Wiki
Revision as of 09:00, 11 June 2025 by Ttenbergen (talk | contribs) (Text replacement - "ACP Status collection in ICU" to "ACP Status Collection in ICU")
Jump to navigation Jump to search

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Data Integrity Checks
Summary: error if ACP Status Collection in ICU is missing part of the entry.
Related: ACP Status Collection in ICU
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query s_tmp_ACP
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: 2015-12-03T13:11:02
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

approximate implementation date

Complete and Incomplete patients

  • ACP entries must be paired
  • there has to be a status entry
  • there has to be a source entry
  • if there is a date, it can't be after the Dispo DtTm

Complete patients

  • unless source item = "not documented" there has to be a date
  • unless status item = "not documented" there has to be a date
  • source and status items can't be null, "" or "enter"
  • source and status integers have to be present

Related articles

Related articles: