Query check CCI from OR no CCI: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check | DIC_summary = If from OR or PACU, must have at least 1 CCI Procedure | DIC_related_concepts = CCI Procedure, Previous Location | DIC_firmn..."
 
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]]
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]] - '''IS THAT REASONABLE?'''
| DIC_related_concepts = [[CCI Procedure]], [[Previous Location]]
| DIC_related_concepts = [[CCI Procedure]], [[Previous Location]]
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
| DIC_firmness = hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)

Revision as of 16:14, 14 October 2018

Data Integrity Checks
Summary: If from OR or PACU, must have at least 1 CCI Procedure - IS THAT REASONABLE?
Related: [[CCI Procedure, Previous Location]]
Firmness: hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table)
Timing:
App: CCMDB.mdb
Coding: how to find this in containing program, eg. SAS file, function name, query name...
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW
"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "CCI Procedure]], [[Previous Location" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:
  • is this actually a reasonable cross-check? What would be a false positive for this?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: