Query check CCI vs LOS count days component

From CCMDB Wiki
Data Integrity Checks
Summary: Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS.
Related: LOS, Dispo DtTm, Service tmp entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_vs_LOS_count_days_component
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2022-02-10
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

As of 2022-02-10 there currently aren't any component entries with CCI collect count days but I only realized it after I built the query.

Log

Related articles

Related articles: