Applies to:
NovoPath360
Description:
If a client is using the special procedures under NovoPath Admin Options in NP360 and you are unable to delete the procedure names from the UI, please follow these steps.
Steps:
1. Login to the client's DB by accessing the environment through RD.
2. Open up SQL and once it loads click connect.
3. Once connected click on New Query in the toolbar and in the box under the New Query window, change it to "NovoPath."
4. Paste the following script into the query window and ensure the prefixes are updated to the appropriate prefixes you are using. Either press execute or "F5" on your keyboard:
Script:
To look at current special procedures:
select * from novopathOptions where optionname like '%SpecialProcedure%'
To update special procedures:
Update novopathOptions
set optionvalue = 'Excision|Mohs Debulking|Nail Matrix, Punch Biopsy|Nail Matrix, Shave Biopsy|Nail, Avulsion|Nail, Clipping|Punch Biopsy|Shave Biopsy|'
where optionname ='SpecialProcedure'