DM Audit Log Report Columns

Column Name	Description
Prac Name	Practice Name
Description	Error Description
Encounter	Source Number
Table Name	Table Affected
Field Name	First Field Changed
Before	Previous Value
After	Current Value
Field Name	Second Field Changed
Before	Previous Value
After	Current Value
Field Name	Third Field Changed
Before	Previous Value
After	Current Value
Process Date	Process Date
Date Changed	Date of Correction
Report Fix	Errors fixed by PM

Help Guide for NextGen® Enterprise PM 8

DM Audit Log Report

The Data Maintenance Audit Log report is a report that shows you what errors were auto-corrected by the Data Integrity Miscellaneous report and/or the Data Maintenance SQL job. You can filter the report by the date the error was corrected and/or by process date. The columns are described below The Data Maintenance Audit Log report displays data recorded for all corrections from miscellaneous data integrity errors only. To access the report in NextGen® Enterprise PM, select the Reports menu and select System, then select Data Maintenance, and then select DM Audit Log. From the Report Filter window, select the Info button to view the following information about the report: Logic: This report shows what errors were auto-corrected by the Data Maintenance Miscellaneous report. Filtering Info: Can be filtered by the date the error was corrected and/or by Process Date. Common Uses: To see a list of encounters/invoices that were auto-corrected by the Miscellaneous Data Maintenance report. Bala

Help Guide for NextGen® Enterprise PM 8

Miscellaneous Report Columns

The following columns are available on the Miscellaneous report: Column Name Description Data Populates From Prac Name Practice Name Practice Master File Error Description Error Description NA Record ID Source Number Various Table Name Table Name Various Enc ID Encounter ID Encounter Maintenance Process Date Process Date Encounter Maintenance Transaction Amt Transaction Amount Encounter Maintenance Parent topic: Miscellaneous Report

Help Guide for NextGen® Enterprise PM 8

Data Maintenance Reports

The Data Maintenance reports verify the reliability of the data in your database. These reports are run to check for conditions in the data that could cause problems. In addition, the Data Maintenance reports show any potential data problems due to the application. There are four available Data Maintenance reports: DM Audit Log History/Non-History Status Miscellaneous Unassigned Benefit Info Records Each report concentrates on a specific area of data. The columns include Practice Name, Error Description, Record ID, and database Table Name where the record is located. CAUTION: Data Maintenance reports are database intensive and should be run after hours when no users are actively working on the system. Auto-correcting Data Maintenance Reports DM Audit Log Report History/Non-History Status Report Miscellaneous Report Unassigned Benefit Info Records Reports Transfer of Liability Validation Report Parent topic: System Reports

Help Guide for NextGen® Enterprise PM 8

Transfer of Liability Validation Report Columns

The following columns are available on the Transfer of Liability Validation report: Column Name Description Data Generates From Prac ID Practice ID Practices Master File Pract Name Practice Name Practices Master File Record ID Record ID Charges.charge_id CPT4 Code ADA, CPT, HCPC Charge table (cpt4_code_id) Proc Dt Process Date transfer_of_liability_log.process_date Error Description Error Description Compares the charge table to the transfer_of_liability_log Table Name Table Name Charges, transfer_of_liability_log Encounter ID Encounter ID Encounter Maintenance EncNbr Encounter Number Encounter Maintenance CreateDate Create Date charges, transfer_of_liability_log (create timestamp) Charge COB1 Amt Charge COB1 Amt Balance Control > Ins1 Amt Transfer of log COB1 Amount Transfer of log COB1 Amount transfer_of_liability_log Charge COB2 Amt Charge COB2 Amt Balance Control > Ins2 Amt Transfer of log COB2 Amount Transfer of log COB2 Amount transfer_of_liability_log Charge COB3 Amt Charge COB3

System Administrator Help

Auditing in System Administrator

The audit log typically includes the following information. Enterprise name Practice name Field name Old value New value Modification date User who made the modification Message Action type Parent topic: Advanced Auditing

Help Guide for NextGen® Enterprise PM 8

History/Non-History Status Report Columns

The following columns are available on the History/Non-History Status report: Column Name Description Data Populates From Prac Name Practice Name Practice associated with the encounter. Data Maintenance Type Data Maintenance Type Displays one of the following: History Non-History Encounter Number Encounter Number Encounter number associated with the error. Error Description Error Description Description of the error. Record ID Source Number ID number for the encounter in the SQL database. Table Name Table Name Name of the table in the SQL database. For example, "patient_encounter". Filter 2 Columns can be used as a filter for data on the report. Column filter options include the following: Between Equals Not Equals Greater Than Less Than Like Sorting Columns can be used in the sorting and grouping of data on the report. Column sorting options include the following: Ascending Descending Group By Page Break Note: Columns that are not available for Group By or Page Break are indicated by

DM Audit Log Report Columns

Recommendations

DM Audit Log Report

Miscellaneous Report Columns

Data Maintenance Reports

Transfer of Liability Validation Report Columns

Auditing in System Administrator

History/Non-History Status Report Columns

DM Audit Log Report

Miscellaneous Report Columns

Data Maintenance Reports

Transfer of Liability Validation Report Columns

Auditing in System Administrator

History/Non-History Status Report Columns