Query check CCI Date

From CCMDB Wiki
Revision as of 12:47, 23 August 2018 by Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check | DIC_summary = Px Date must be sensible when compared to Arrive_DtTm and Dispo_DtTm | DIC_related_concepts = Px Date, Arrive_DtTm,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Integrity Checks
Summary: Px Date must be sensible when compared to Arrive_DtTm and Dispo_DtTm
Related: [[Px Date, Arrive_DtTm, Dispo_DtTm]]
Firmness: hard check
Timing: always
App: CCMDB.mdb
Coding:
Uses L Problem table: not relevant for this app
Status: needs review, ready to implement, implemented, not feasible
Implementation Date:
Backlogged: true
  • Cargo


  • SMW

"needs review, ready to implement, implemented, not feasible" is not in the list (needs review, ready to implement, implemented, not entered, not feasible, declined, retired) of allowed values for the "DICStatus" property. "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 "Px Date]], Arrive_DtTm, [[Dispo_DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

  • Categories:  
  • form:


Px Type#CCMDB Data Integrity Checks Same as for Dx Date