Welcome Guest, Login


Quick Search

If ART medications are showing as 0 ARV ingredients or are not showing up in custom reports, or clients with ART medications are not showing up in performance measures that use ARV counts, then the medications may have to be updated with the latest medication file and/or CAREWare may need to be prompted to update the cw_available_medications table for ARV counts. Make sure the latest medication file is in the RW CAREWare Client Tier folder. http://hab.hrsa.gov/program-grants-management/careware has the latest medication files at the bottom of the page. The ARV count is listed in the cw_available_medication table in the database, in the column avl_md_arv_count. CAREWare can be triggered to update the medications using the data tier update in the business tier.

To verify the ARV ingredient count in the medications import file:

  1. Right click on the medications import file
  2. Click Edit
  3. Press CTR-F
  4. Type the name of the medication in the search field
  5. Click Find Next


To check the cw_available_medications table on the database using SQL Server Management Studio:

  1. Open SQL Server Management Studio
  2. Connect to the database instance using Windows Authentication
  3. Expand Databases
  4. Expand CW_Data
  5. Expand Tables
  6. Right click cw_available_medications
  7. Click Select Top 1000 Rows


Verify that the medication is listed as having 1 or more ARV ingredient(s) in the database.

Here are instructions for resolving the ARV count issue.

Run a data tier update for 88.3 using the CW Admin utility. Create a new medication regimen in a provider domain. This can be deleted as soon as it is created. This will prompt the business tier to update the ARV counts.

The CW Admin Utility is located by default at: C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier.

  1. Right click CW Admin
  2. Click Run as Administrator
  3. Click Stop Server
  4. Click Common Storage Settings
  5. Click the box in the row for UpdateToRun in the column cmm_st_number
  6. Change the value to 88.3
  7. Click any other box to save the change
  8. Click Server Settings
  9. Click Start Server

To add a regimen follow these instructions:

  1. Log into the provider domain
  2. Click Administrative Options
  3. Click Regimen Setup
  4. Click Add
  5. Type in a Regimen Name
  6. Click the drop down list for Line
  7. Click First, Second, or Third
  8. Click Add Medication
  9. Click the drop down list for Medication (choose any medication)
  10. Complete the form including Options
  11. Click Save

Once the regimen has been created and deleted, try running the performance measure or custom report, or check the cw_available_medications table using SQL Server Management Studio to see if that the ARV counts were updated.  

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.