Query check CCI Picklist unfilled: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
Line 5: Line 5:
| DIC_timing = complete
| DIC_timing = complete
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check CCI Picklist unfilled''
| DIC_coding = query ''check_CCI_Picklist_unfilled''
| DIC_status = implemented
| DIC_status = implemented
| DIC_implementation_date = 2018-10-14
| DIC_implementation_date = 2018-10-14
Line 11: Line 11:


This check is the counterpart of [[Query check CCI Component unfilled]].
This check is the counterpart of [[Query check CCI Component unfilled]].


== Log ==
== Log ==

Latest revision as of 11:13, 2023 November 25

Data Integrity Checks
Summary: CCI Picklist entry with missing px, Px_Type or Px_Count
Related: CCI Picklist, Px Type, Px_Count
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_Picklist_unfilled
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

This check is the counterpart of Query check CCI Component unfilled.

Log

  • 2023-02-08 - records with blank type are still making it through, why?
  • 2021-01-20 - confirmed that the query works

Related articles

Related articles: