CPT/HCPCS Invalid Code Analysis Scripts
The CPT®/HCPCS invalid code analysis scripts analyze 26 different locations within a client database in the NextGen® KBM where an invalid and/or revised CPT/HCPCS Code will reside. The result will be 26 different query results that can be copied or exported from Microsoft®Query Analyzer/SQL Server® Management Studio and used to indicate where customizations are required on the client’s NextGen KBM.
There are no restrictions on any version of the NextGen® Ambulatory EHR or NextGen KBM. The scripts will work on any version. No data will change as a result of implementing this process. This is strictly an analysis tool. The scripts search different areas within the templates to find the hard-coded CPT/HCPCS codes.
These data points include:
Checking for a string (SQL “like”)
- Trigger parameters (type 1)
- Trigger parameters (type 2)
- Template field default values and field lists
- Regular picklists
- Trigger conditions
- Alert triggers
- Stored procedure codes
- Template and patient variables default values
Checking for exact values:
- Service Item Master table
- Patient procedure codes
- Stored procedure cross reference triggers
- Upload extended data triggers (actcode and medAdminCPT)
- Templates using service categories
- Service categories
- Data within a system or practice template
- Dermatology tables (derm_proc_bx_destruct, derm_proc_excision, derm_proc_mohs and derm_proc_repair)
- File Maintenance > EHR > dbpicklist manager tables (only for non-NextGen Ambulatory EHR tables)
- CARD_ProcedureCategory table
- Medical necessity triggers
- DBPicklist triggers
- SP grid (sp_control_xref table) check
For more information regarding the CPT and HCPCS invalid code analysis scripts, please go to the NextGen Knowledge Exchange 2.0 to read the article called NextGen KBM Hide Invalid CPT/HCPC Codes Package – 2015. The link for this package:https://knowledge.nextgen.com/pe/action/km/viewelement?portalPageId=10118719&channelID=10171444&id=10183099
For more information or a list of additional services provided by the NextGen Healthcare Client Support team, please log into the Client Support Center at https://magic.nextgen.com/helpdesk/prelogin.asp.
Notice:
Microsoft, SQL Server, Windows, Windows Vista, Internet Explorer, Office, Word, Excel and Outlook are registered trademarks of Microsoft Corporation in the United States and/or other countries. Although a Microsoft trademark may appear in certain images within this document, Microsoft Corporation is not responsible for warranty support on the NextGen® software products.