Refunds by Transaction Report Columns

The following columns are available on the Daily by Transaction Refunds report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Location Name	Charge Posting
Location SubGrp 1	Location Subgrouping 1 Note: Subgrouping name is from Enterprise PreferencesGeneral tab.	Locations Master File
Location SubGrp 2	Location Subgrouping 2 Note: Subgrouping name is from Enterprise PreferencesGeneral tab.	Locations Master File
Post Date	Day transaction was posted	Transaction Detail
Proc Dt	Day transaction was processed	Transaction Detail
Ovr Proc Dt	Override process date	Transaction Detail
Bt Dt	Batch date	Batch Header
Bt Nbr	Batch number	Batch Header
Bt Desc	Batch description	Batch Header
Track Desc	Tracking Description	Payment Entry
E/I/A/B	Encounter Invoice Account Budget	Transaction Detail
Dtl E/I/A/B	Details for: Encounter Invoice Account Budget	Transaction Detail This column shows the encounter number(s) of where an account payment was spread. Account level transactions are linked to information at the encounter level.
Src Type	The Source type can be: Encounter Invoice Account Budget	Transaction Detail
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Addr1	Address 1	Patient Information
Addr2	Address 2	Patient Information
City	City	Patient Information
Zip	Zip Code	Patient Information
County	County	Patient Information
Sex	Sex at Birth	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Insured Name	Insured Name	Insurance Maintenance
Pat Type	Patient type	Encounter Maintenance
Collection Agency	Collection Agency	Encounter Maintenance
Case Nbr	Case Management Number	Patient Information
Case Desc	Case Management Description	Patient Information
Case Sts	Case Management Status	Patient Information
Case Emp	Case Management Employer	Patient Information
Billed Amt	Billed amount	Charge Posting
Aprv Amt	Approved amount	Transaction Detail
Alwd Amt	Allowed Amount	Transaction Detail
Tran Dt	Transaction Date	Transaction Detail
Tran Cd	Transaction Code	Transaction Detail
Ref Amt	Refund Amount	Transaction Detail
Tran Status	Transaction Status	Transaction Detail
Rsn Cds	Transaction Reason Code	Transaction Detail
Crt Dt	Create Date	Patient Information
Created By	Created By	Patient Information
Mod Dt	Last Modified Date	Patient Information
Modified By	Last Modified By	Patient Information
Pat Age in Years	Patient Age in Years	Patient Information
Pat Age in Months	Patient Age in Months	Patient Information
Pat Age in Years (DOS)	Patient Age in Years on the Date of Service	Patient Information
Pat Age in Months (DOS)	Patient Age in Months on the Date of Service	Patient Information
Mrkt Plan Name	Marketing Plan Name	Encounter Maintenance
Mrkt Plan Type	Marketing Plan Type	Encounter Maintenance
Mrkt Desc	Marketing Plan Description	Encounter Maintenance
Homeless Status	Homeless Status	Patient Information
Migrant Worker Status	Migrant Worker Status	Patient Information
Language Barrier	Language Barrier	Patient Information
Primary Med Cov	Primary Medical Coverage	Patient Information
Race	Race	Patient Information Note: Multiple entries are separated by commas.
Ethnicity	Ethnicity	Patient Information Note: Multiple entries are separated by commas.
Tribal Affiliation	Tribal Affiliation	Patient Information
Blood Quantum	Blood Quantum	Patient Information
Veteran Status	Veteran Status	Patient Information
School Based Hlth Care	School Based Health Care	Patient Information
Public Housing Primary	Public Housing Primary Care	Patient Information
Descendancy	Descendancy	Patient Information
IHS Eligibility Status	IHS Eligibility Status	Patient Information
Classification Beneficiary	Classification Beneficiary	Patient Information
Community Code	Community Code	Patient Information
Consent to Treat Ind	Consent to Treat Indicator	Patient Information
Consent to Treat Date	Consent to Treat Date	Patient Information
Enc Homeless Status	Encounter Homeless Status	Encounter Maintenance
FQHC Qual Enc	FQHC Qualifying Encounter Indicator	Encounter Maintenance > Claims
CCBHC Qual Enc	CCBHC Qualifying Encounter Indicator	Encounter Maintenance > Encounter Specifics
Refund to	Refund To	Payment Entry
Ref Addr Line 1	Refund Address Line 1	Payment Entry
Ref Addr Line 2	Refund Address Line 2	Payment Entry
Ref City	Refund City	Payment Entry
Ref State	Refund State	Payment Entry
Ref Zip	Refund Zip Code	Payment Entry
Ref County	Refund County	Payment Entry
Vendor Matching UD1	Vendor Matching UD1	Payment Entry
Vendor Matching UD2	Vendor Matching UD2	Payment Entry
Vendor Matching UD3	Vendor Matching UD3	Payment Entry
Vendor Matching UD4	Vendor Matching UD4	Payment Entry
Vendor Matching UD5	Vendor Matching UD5	Payment Entry
Vendor Matching UD6	Vendor Matching UD6	Payment Entry
Vendor Matching UD7	Vendor Matching UD7	Payment Entry
Vendor Matching UD8	Vendor Matching UD8	Payment Entry
Vendor Matching UD9	Vendor Matching UD9	Payment Entry
Vendor Matching UD10	Vendor Matching UD10	Payment Entry
Contracted Ind	Contracted Payer Indicator	Payers Master File
Claim/Resub #	Claim/Resubmission #	Encounter Maintenance
Batch Transaction Category	Batch Transaction Category Note: Field name is from Enterprise Preferences > General tab.	Batch Maintenance
Guar Name	Guarantor Name	Guarantor Information
Guar Addr 1	Guarantor Address 1	Guarantor Information
Guar Addr 2	Guarantor Address 2	Guarantor Information
Guar City	Guarantor City	Guarantor Information
Guar State	Guarantor State	Guarantor Information
Guar Zip	Guarantor Zip Code	Guarantor Information
Race Category	Race Category	Race Category Mapping Master File Note: Multiple entries are separated by commas.
Ethnicity Category	Ethnicity Category	Ethnicity Category Mapping Master File Note: Multiple entries are separated by commas.

Filter 1

Use parameters to filter data on the report:

Post Date: Include refunds posted within a date range.
Process Date: Include refunds processed within a date range.
Transaction Date: Include refunds with a transaction date within a date range.
Transaction Type: Include/exclude refunds by type. Select Encounter, Invoice, Account and/or Budgets.
Unposted Transactions: Include/exclude unposted refund transactions. Select either Only or Exclude (default).
In Progress: Include/exclude refunds on In Progress encounters. Select either Only, Exclude (default), or Include All.

Filter 2

Use columns to filter data on the report. Column filter options include the following:

Between
Equals
Not Equals
Greater Than
Less Than
Like

Additional Filters

Use additional filters to filter data on the report. Additional filters include the following:

Creator
Financial Classes
Location Subgrouping 1
Location Subgrouping 2
Locations
Marketing Plan Type
Patient Types
Provider Subgrouping 1
Provider Subgrouping 2
Reason Code Subgrouping 1
Reason Code Subgrouping 2
Reason Codes
Referring Providers
Refund Transaction Codes
Rendering Providers

Sorting

Use columns to sort and group 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 'n/a'.

Totals

Use columns to sub-total and total data on the report. Column total options include the following:

Sum
Average
Count
Totals

Note: Columns that are not available for totals are indicated by 'n/a'.

Refunds by Transaction Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Refunds by Encounter Report Columns

Payments by Encounter Report Columns

Adjustments by Encounter Report Columns

Payments by Line Item Report Columns