Issue 11: April 15, 2015

2015 CPT/HCPCS Invalid Code Analysis Scripts

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”)

  1. Trigger parameters (type 1)
  2. Trigger parameters (type 2)
  3. Template field default values and field lists
  4. Regular picklists
  5. Trigger conditions
  6. Alert triggers
  7. Stored procedure codes
  8. Template and patient variables default values

Checking for exact values:

  1. Service Item Master table
  2. Patient procedure codes
  3. Stored procedure cross reference triggers
  4. Upload extended data triggers (actcode and medAdminCPT)
  5. Templates using service categories
  6. Service categories
  7. Data within a system or practice template
  8. Dermatology tables (derm_proc_bx_destruct, derm_proc_excision, derm_proc_mohs and derm_proc_repair)
  9. File Maintenance > EHR > dbpicklist manager tables (only for non-NextGen Ambulatory EHR tables)
  10. CARD_ProcedureCategory table
  11. Medical necessity triggers
  12. DBPicklist triggers
  13. 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 athttps://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.

Comments are closed.