CCU Service Tracking: Difference between revisions
Ttenbergen (talk | contribs) m →does this still happen in CICU?: According to Lois via Laura we don't need to worry about this in CICU |
Ttenbergen (talk | contribs) |
||
| Line 16: | Line 16: | ||
=={{CCMDB Data Integrity Checks}}== | =={{CCMDB Data Integrity Checks}}== | ||
* each STB_MICU pt has to have at least one | * query ''s_tmp_CCU_Service_missing'' - each STB_MICU pt has to have at least one | ||
* no pt not STB_MICU can have any | * query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | ||
* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | |||
* can't have two entries that are the same (ie same service and time) | * '''not yet''' query ''s_tmp_CCU_Service_'' - Same service in consecutive sequence should not be allowed . | ||
== What if there is more than one == | == What if there is more than one == | ||