Query check CCI from OR no CCI: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m top: substance cleanup
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = If from OR or PACU, must have at least 1 [[CCI Procedure]] - '''IS THAT REASONABLE?'''
| 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)
| DIC_timing =
| DIC_timing =

Revision as of 23:07, 26 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. 
  • Categories:  
  • form:
  • is this actually a reasonable cross-check? What would be a false positive for this?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: