Query s tmp ACP: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=Check using old DX coding schema
|successor=[[Query check cooling vs arrest]]
|content=
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = error if [[ACP Status collection in ICU]] is missing part of the entry.
|DIC_summary=error if [[ACP Status collection in ICU]] is missing part of the entry.
| DIC_related_concepts = ACP Status collection in ICU
|DIC_related_concepts=ACP Status collection in ICU
| DIC_firmness = hard check  
|DIC_firmness=hard check
| DIC_timing =
|DIC_coding=query ''s_tmp_ACP ''
| DIC_app = CCMDB.mdb
|DIC_implementation_date=2015-12-03T13:11:02
| DIC_coding = query ''s_tmp_ACP ''
|DIC_status=retired
| DIC_status = implemented
|DIC_LProblem=No
| DIC_implementation_date = 2015-12-03T13:11:02
|DIC_app=CCMDB.accdb
}}
}}
approximate implementation date
approximate implementation date
Line 25: Line 30:
{{Related Articles}}
{{Related Articles}}


[[Category:Tmp check]]
}}

Latest revision as of 11:01, 2019 September 22

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: