Author: Jennifer Eggerton
Last updated: Sep 22, 2026
947
views
|
Purpose
|
Add and activate selected ICD9 Diagnosis Definition codes for a CAREWare provider.
|
|
Who should do this
|
CAREWare database administrators or other authorized IT staff.
|
|
Use this guide when you need to
|
Use this guide when an ICD9 code must be added or activated for a provider.
|
|
Main warning
|
This process changes the CAREWare database. Only authorized IT staff should run it.
|
|
Quick path
Create the stored procedure in the CAREWare database > Run one EXEC call for each code you need to add and activate.
|
|
Important: Centers for Medicare & Medicaid Services (CMS) mandated the switch to ICD-10-CM/PCS for medical diagnoses and inpatient procedures. ICD-9 codes were retired as of September 30, 2015, and ICD-10 codes began on October 1, 2015. ICD-9 codes can be added to CAREWare when needed to accommodate historical diagnoses records.
|
|
Important: If the Diagnosis Definition already exists, the procedure creates the provider mapping. If the mapping already exists, the procedure makes no change.
|
Before You Begin
- CAREWare does not have built-in functionality to update or activate ICD9 codes.
- ICD10 diagnoses can be updated and activated under Clinical Setup.
- This process adds selected ICD9 Diagnosis Definition codes and activates them for a selected provider.
Activate ICD9 diagnosis codes
Step 1. Create the SQL Server stored procedure in the CAREWare database. The procedure adds selected Diagnosis Definition codes and activates them for the selected provider.
Download the script to create the stored procedure here.
Step 2. Run one EXEC call for each Diagnosis Definition you need to add and activate. Use this format:
|
EXEC dbo.AddAndActivateDiagnosisDefinition 'DiagnosisName', 'ICD9Code', 'DomainName'
|
Example
To add ICD9 code 097.9 for Syphilis, Unspecified, run:
|
EXEC dbo.AddAndActivateDiagnosisDefinition 'Syphilis, Unspecified', '097.9', 'MyImportDomain'
|
How to confirm it worked
● The SQL script runs without error.
● ICD9 diagnoses codes are available for adding to client records.
Troubleshooting and common questions
There was an error after running the SQL script. What should I do?
Verify that the entire script was copied and pasted. Also, check for any line breaks that may cause an error when running the script.
How do I run the queries/scripts?
Queries/scripts are run in SQL Server Management Studio.
Related References
