Eliminating a diagnosis from collection

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

CCMDB.accdb

A dx is active only if the field s_AllDiagnoses table.collection_allowed is true. Setting it to false for the eliminated diagnosis will result in:

dx no longer available in dropdown
any previously entered instances turn "blank"
record can not be set to "complete", ie can't be sent
Function TmpChecker runs a test to ensure any record that is already set to complete is also caught

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

	Will need to confirm that all the checks from the old system will apply to the new one.

The process uses the query Check eliminated dx.