Understanding the Auditing reports

This topic explains what the data fields on the Auditing reports correspond to in Dentrix Ascend and how the measures are calculated for the Auditing reports.

Analysis Audit Reports

The following reports use the same data fields and measures:

  • Audit Report

  • Analysis Audit Report Builder

Data Fields and Measures (click here to show/hide)

  • Account Enabled

    • Enabled - The active status of a Dentrix Ascend user's account.

  • Date and Time

    • Date and Time - The date and time of a change. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy). Uses a standard time format (hh:mm AM/PM, based on a 12-hour clock).

  • Date.Date (ISO)

    • Date - The date of a change. Uses the international date format (yyyy-mm-dd).

  • Date.Date (YMD)

    • Year - The year of a change. Uses the four-digit identifier (yyyy).

    • Month - The month of a change. Uses an abbreviated name (Jan, Feb, Mar, and so forth).

    • Day - The day of the month of a change.

  • Date.Date (local)

    • Date - The date of a change. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

  • Description

    • Type - The type of change.

    • Action - The action taken for a change.

    • Description - The description of a change.

    • Additional Information - Additional information about a change.

  • Location

    • Time Zone - The time zone of the location where a change was made.

    • Location - The name of a location in your organization. Only the locations that you have access to are available.

    • Website - The website address of a location in your organization.

  • Measures

    • Entry Count - The number of distinct changes on the report.

    • User Count - The number of distinct users on the report.

  • Name

    • Name - The name of a Dentrix Ascend user who has made a change. Uses a "Last name, First name" format.

  • Organization

    • Organization Type - Indicates whether the organization is real or for testing purposes only.

    • Customer ID - Your organization's customer ID (which can be used to log in).

    • Organization Name - The name of your organization (or the organization log-in ID).

  • Patient

    • Ortho Patient - Whether a patient is flagged as an orthodontic patient ("Y" if yes; "N" if no).

    • Chart Number - The chart number of a patient.

    • Discount Plan - The discount plan assigned to a patient.

    • Gender - The gender of a patient.

    • State - The state of a patient.

    • City - The city of a patient.

    • Postal Code - The ZIP Code/postal code of a patient.

    • Next Appointment Date - The date of a patient's next appointment. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • External ID - The external ID of a patient.

    • Ascend Patient ID - The ID of a patient in Dentrix Ascend.

    • Patient Status - The status of a patient (such as active or inactive).

    • Preferred Location - The preferred location for a patient.

    • Primary Contact Email - The email address of a patient's primary contact.

    • Primary Contact Name - The name of a patient's primary contact. Uses a "Last name, First name" format..

    • Primary Contact Phone - The phone number of a patient's primary contact.

    • Primary Prov - The short name of a patient's primary provider (the ID that appears throughout Dentrix Ascend to identify him or her).

    • Primary Provider - The name of a patient's primary provider. Uses a "Last name, First name" format.

    • Patient - The name of a patient. Uses a "Last name, First name" format.

  • Patient.Birth Date

    • Birth Date - The birth date of a patient.

  • Patient Demographics

    • Ethnicity Code - The CDC code used for the ethnicity of a patient.

    • Ethnicity - The CDC description used for the ethnicity of a patient.

    • Race Code - The CDC code used for the race of a patient.

    • Race - The CDC description used for the race of a patient.

  • Patient Primary Ins

    • Pat. Prim. Plan - The name of an insurance plan.

    • Pat. Prim. Carrier - The name of an insurance carrier.

    • Prim. Subscriber ID - The ID of the subscriber of an insurance plan.

  • Patient Secondary Ins Plan

    • Pat. Sec. Plan - The name of an insurance plan.

    • Pat. Sec. Carrier - The name of an insurance carrier.

    • Sec. Subscriber ID - The ID of the subscriber of an insurance plan.

  • Username

    • Username - The user name of a Dentrix Ascend user who has made a change.

Interactive Audit Report Builder

Data Fields (click here to show/hide)

  • Audit

    • Type - The type of change.

    • Action - The action taken for a change.

    • AdditionalInfo - Additional information about a change.

    • Description - The description of a change.

    • TimeZone - The time zone of the location where a change was made.

    • DateTime - The date and time of a change. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy). Uses a standard time format (hh:mm AM/PM, based on a 12-hour clock).

    • Date - The date of a change. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

  • User

    • Email - The email address of a user.

    • Enabled - Indicates whether a user is active or inactive.

    • User - The name of a user. Uses a "Last name, First name" format.

    • FirstName - The first name of a user.

    • LastName - The last name of a user.

    • Phone1 - The primary phone number of a user.

    • Phone2 - The secondary phone number of a user.

    • Username -The user name (which is used to log in) of a user.

    • OrganizationID -The organization ID of a user.

    • FailedAttempts - The number times a user has attempted to log in but failed.

    • DateLocked - The date the account of a user was locked due to too many failed log-in attempts. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • AccountLocked - Indicates whether the account of a user is locked.

  • Organization

    • CustomerID - Your organization's customer ID (which can be used to log in).

    • Organization - The name of your organization (or the organization log-in ID).

  • Location

    • Location - The name of a location in your organization. Only the locations that you have access to are available.

  • Patient

    • Patient - The name of a patient. Uses a "Last name, First name" format.

    • Last Procedure Date - The date of the procedure that was performed most recently on a patient. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • Status - The status of a patient (such as active or inactive).

    • Email - The email address of a patient's primary contact person.

    • Phone - The first phone number listed for the primary contact person for a patient.

    • Address - The address of the primary contact person for a patient.

    • Time Zone -The time zone where the primary contact person for a patient lives.

    • First Visit - The date of a patient's first visit. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • Last Visit - The date of a patient's most recent visit. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • Next Appointment Date - The date of a patient's next appointment. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • PatientKey - The name of the primary contact for a patient.

    • First Name - The first name of a patient.

    • Last Name - The last name of a patient.

    • Middle Name - The middle name of a patient.

    • Preferred Name - The preferred name or nickname of a patient.

    • Gender - The gender of a patient.

    • Date Of Birth - The date of birth of a patient. Uses the date format for your region (such as mm/dd/yyyy or dd/mm/yyyy).

    • Address Line 1 - The street address of a patient's primary contact person.

    • Address Line 2 - The second line of the street address of a patient's primary contact person.

    • City - The city of a patient's primary contact person.

    • State - The state of a patient's primary contact person.

    • ZIP Code - The ZIP Code/postal code of a patient's primary contact person.

    • Chart Number - The chart number of a patient.

    • Ascend Patient ID - The ID of a patient in Dentrix Ascend.

    • Eternal ID - The external ID of a patient.

  • Patient Primary Ins Plan

    • Pat. Prim. Fee Schedule - The fee schedule associated with an insurance plan.

    • Pat. Prim. Plan - The name of an insurance plan.

    • Pat. Prim. Carrier - The name of an insurance carrier.

  • Patient Secondary Ins Plan

    • Pat. Sec. Fee Schedule - The fee schedule associated with an insurance plan.

    • Pat. Sec. Plan - The name of an insurance plan.

    • Pat. Sec. Carrier - The name of an insurance carrier.