Get the list of HOPWA providers using the following query:

Select *

From cw_domain

Where dmn_useHOPWA = '1'  

Disable HOPWA for all providers using the following query:

UPDATE cw_domain 

SET dmn_useHOPWA = '0'  

Restart the CAREWare Business Tier

Drop the following column for custom subforms by running this query:

ALTER TABLE cw_custom_subform

DROP COLUMN F9db40e4e906a4c3a9e47287916c41afb

Add the contract item called HOPWA to the contract called HOPWA for the provider HOPWA

Enable HOPWA for the provider HOPWA