Query check CCI vs LOS count days component: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 10: Line 10:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
This uses [[Function LOS()]].
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.
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 ==
== Log ==
* 2022-05-11 - changed from using [[Function LOS()|Function LOS()]] to using [[Function LOS int()|Function LOS int()]]
* 2022-02-10 - implemented
* 2022-02-10 - implemented



Latest revision as of 09:46, 2022 May 11

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: