Third-Party Demographic Transactions Report (CSV)

Description: This report displays client information, transaction details and associated exceptions that have been exported to a third-party interface during a selected date range.

Use: This report can be used to quickly locate exceptions associated with clients for resolution to return their visits to billable status.

Limitations: N/A

This report can be filtered by:

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

Each column of the report displays:

Field	Description
Datetime_Inserted	The date and time of the export to the interface.
Invalid_Data	Any incorrect data associated with the transaction.
Exception_Messages	The exception associated with the transaction.
Trans_ID	The transaction ID.
Transaction_Status	The transaction status.
Payor_ID	The payer ID.
Patient_ID	The patient ID.
Admission_ID	The admission ID.
Client Other ID	The client’s alternate Medicaid ID.
adChartID	The adChart ID.
First_Name	The client’s first name.
Middle_Name	The client’s middle name.
Last_Name	The client’s last name.
MR_Number	The client’s MR number.
oldMRN	The client’s old MR number.
Gender	The client’s gender.
Date_Of_Birth	The client’s date of birth.
Priority_Code	The priority code.
Medicaid_Number	The client’s Medicaid ID number.
Address1	The client’s address.
City	The client’s city.
State	The client’s state.
Zip	The client’s zipe code.
Phone1	The client’s phone number.
Phone2	The client’s secondary phone number.
Emerg1_Name	The client’s first emergency contact’s name.
Emerg1_Phone2	The client’s first emergency contact’s phone number.
Emerg2_Name	The client’s second emergency contact’s name.
Emerg2_Phone1	The client’s second emergency contact’s phone number.
Emerg2_Phone2	The client’s second emergency contact’s secondary phone number.
Start_Of_Care_Date	The client’s start of care date.
Patient_Status	The client’s patient status.
Discharge_Date	The client’s discharge date.
Payer_Coordinator	The client’s assigned coordinator.
Source_Of_Admission	The client’s source of admission.
Team	The client’s assigned team.
Filename	The file name of the associated export.
Coordinator	The client’s coordinator if the Payer_Coordinator field is empty.