Eliminating a diagnosis from collection

These are the instructions to use when we eliminate / inactivate / retire a diagnosis or procedure from collection.

We need to accommodate any instances of it that are in our data; this is true for all records, but especially so for incomplete ones.

Follow the instructions in Collection stop instructions to keep things coherent.

Tables affected

• dropdown / s-tables: s_ICD10 table / s_CCI_1 table / s_CCI_2 table / s_CCI_Picklist table
• data / L-tables: L_ICD10 table / L_CCI_Component table / L_CCI_Picklist table
• to some degree this applies to other dropdown tables as well, but most of the others don't have start and end dates

Actual steps to retire the value

In CCMDB.accdb

Dxs in ICD10/CCI are available in dropdowns only if the current date is after the " active_start" and before the " active_end" in s_ICD10 table. So, adding a StopDate for the dx in the s_ICD10 table will make it no longer available for collection.

1. find the code in the relevant s-table
2. change the Stop_date to today's date
3. roll out change as usual

wiki

Edit the dx's page with "edit with form" and add the StopDate;

On the wiki

1. remove any {{CCI category| xxx}} / {{ICD10 category| xxx}} calls from the page
   • This is not necessarily the best way to do it, since it will no longer show the entry to someone wanting to review legacy data for that code, but I can't think of a viable alternative for now;
2. put reason for retiring the code under == Additional Info ==
3. change the <code>| StopDate = to today's date
   • this will automatically make the page show the legacy template and hide collection instructions. Make sure you still edit the page as per Collection stop instructions, since any users of the data would need to be able to make sense of the explanations behind the expanded legacy template.
   • the change in date and removal of category will change how the the CCI/IDC10 templates work; the following templates:
     • Template:ICD10 dx
     • Template:CCI PickList Procedure
     • Template:CCI 1 Procedure component
     • Template:CCI 2 Procedure component
     • possibly other templates and ad-hoc queries as they get added; these will be somewhat hard to track but a Special:ReplaceText search for a query looking for the affected table will show a list with many false positives but pretty much all true positives
   • will behave as follows for retired codes
     • add them to category Category:Retired Code
     • hide the page content under the Template:LegacyContent

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