Query check CCI Picklist unfilled: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
| DIC_summary = CCI Picklist entry with missing [[Px_Type]], [[Px_Date]], [[Px_Count]]
| DIC_summary = [[CCI Picklist]] entry with missing [[Px_Type]], [[Px_Count]], [[Px_Date]] if acquired
| DIC_related_concepts = [[CCI Picklist]], [[Px Type]], [[Dx_Priority]], [[No Dx Entered]]
| DIC_related_concepts = [[CCI Picklist]], [[Px Type]], [[Px_Date]], [[Px_Count]]
| DIC_firmness = hard check  
| DIC_firmness = hard check  
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.mdb
| DIC_app = CCMDB.mdb
| DIC_coding = query ''check CCI Picklist unfilled''
| DIC_coding = query ''check CCI Picklist unfilled''
| DIC_status = needs review
| DIC_status = ready to implement
| DIC_implementation_date =  
| DIC_implementation_date =  
}}
}}


only some need date, only some need count (only once ones don't...)


== Related articles ==
== Related articles ==

Revision as of 15:55, 2018 October 14

Data Integrity Checks
Summary: CCI Picklist entry with missing Px_Type, Px_Count, Px_Date if acquired
Related: [[CCI Picklist, Px Type, Px_Date, Px_Count]]
Firmness: hard check
Timing: complete
App: CCMDB.mdb
Coding: query check CCI Picklist unfilled
Uses L Problem table: not relevant for this app
Status: ready to implement
Implementation Date:
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. Property "DICRelatedConcepts" (as page type) with input value "CCI Picklist]], Px Type, Px_Date, [[Px_Count" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.
  • Categories:  
  • form:


Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_Picklist_unfilled&oldid=121014"