Eliminating a diagnosis from collection

When we eliminate a diagnosis or procedure from collection we need to accommodate any instances of it that are in our data.

CCMDB.accdb

Dxs in ICD10/CCI are active only if the current date is after the " active_start" and before the " active_end" in s_ICD10 table is

Data Integrity Checks (automatic list)

	App	Status
Query check eliminated CCI Comp	CCMDB.accdb	implemented
Query check eliminated CCI Pick	CCMDB.accdb	implemented
Query check eliminated ICD10	CCMDB.accdb	implemented
Check eliminated dx	CCMDB.accdb	retired