Query s tmp ACP: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "| DIC_app" to "| DIC_timing = complete always | DIC_app"
m Text replacement - "DIC_timing = complete always" to "DIC_timing ="
Line 3: Line 3:
| 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 = complete always
| DIC_timing =
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.mdb
| DIC_coding = query ''s_tmp_ACP ''
| DIC_coding = query ''s_tmp_ACP ''

Revision as of 12:00, 2018 September 25

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:
App: CCMDB.mdb
Coding: query s_tmp_ACP
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2015-12-03T13:11:02
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 
  • 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: