Third-Party Authorization Transactions Report (CSV)

Description: This report displays all exported transactions occurring on a client’s authorization over a selected date range. Included are daily, weekly, and monthly totals and the file name of the associated export.

Use: This report can be used to reference exported client visit activity for comparison to their remaining authorization amounts or to locate the export with the associated visit information.

Limitations: N/A

This report can be filtered by:

Field	Description
Company	The selected company.
Location	The selected location.
Payor	The selected payer.
Client	The selected client.
Coordinator	The selected coordinator.
Exception Message	The selected exception message.
Date From	The starting date in the selected range.
Date To	The ending date in the selected range.

Each column of the report displays:

Field	Description
Datetime_Inserted	The date and time of the visit.
Invalid_Data
Exception_Messages	The visit’s exception.
ClientName	The client’s name.
Client Other ID	The client’s alternate Medicaid ID.
adChartID	The
Trans_ID	The transaction id number.
Transaction_Status_ID	The transaction status id.
Payor_ID	The payer ID.
Patient_ID	The patient ID.
Admission_ID	The admission ID.
Authorization_ID	The authorization ID.
Authorization_Number	The client’s authorization number.
Modified_Date	The authorization’s last modified date.
From_Date	The authorization’s starting date.
To_Date	The authorization’s ending date.
Authorization_Type	The authorization’s type.
Hours_Per_Week	Authorization hours used per week.
Hours_Per_Month	Authorization hours used per month.
Hours_Per_Auth_Period	Authorization hours used per period.
Sat_Hours	Authorization hours used on Saturdays.
Sun_Hours	Authorization hours used on Sundays.
Mon_Hours	Authorization hours used on Mondays.
Tues_Hours	Authorization hours used on Tuesdays.
Wed_Hours	Authorization hours used on Wednesdays.
Thu_Hours	Authorization hours used on Thursdays.
Fri_Hours	Authorization hours used on Fridays.
Service_Type	The service being performed.
Billing_Service_Code	The billing service code.
Is_Deletion
Filename	The file name of the export associated with the visit.
Coordinator	The assigned coordinator.