Refunds by Line Item Report Columns

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

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Service Location Name	Charge Posting
Location SubGrp 1	Location Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General tab.	Locations Master File
Location SubGrp 2	Location Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General tab.	Locations Master File
Post Date	Post Date	Transaction Detail
Proc Dt	Process date	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	Transaction Detail
E/I/A/B	Encounter Account Invoice Budget	Transaction Detail
Src Type	Source Type	Transaction Detail
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Addr 1	Address 1	Patient Information
Addr 2	Address 2	Patient Information
City	City	Patient Information
County	County	Patient Information
State	State	Patient Information
Zip	Zip Code	Patient Information
Sex	Sex at Birth	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Insured Name	Insured’s Name	Insurance Maintenance
Pat Type	Patient Type	Encounter Maintenance
Billed Amt	Billed Amount	Charge Posting
Collection Agency	Collection Agency	Encounter Maintenance
Aprv Amt	Approved Amount	Transaction Detail
Tran Dt	Transaction Date	Transaction Detail
Tran Cd	Transaction Code	Transaction Detail
Adj Amt	Adjustment Amount	Transaction Detail
Rsn Cds	Transaction Reason Code	Transaction Detail
Rsn Cds Desc	Reason Code Description	Reason Code Library
Diag 1 - 12	Diagnosis Code 1 - 12	Charge-Level: Codes 1-4 Encounter-Level: Codes 5-12
Diag 1 - 12 Cat	Diagnosis 1 - 12 Category	Diagnosis Categories Master File
Diag 1 - 12 Desc	Diagnosis 1 - 12 Description	Diagnosis Codes Library
Diag 1 - 12 EOC	Diagnosis 1 - 12 Episode of Care	ICDCM Codes Master File
Diag 1 - 12 Risk Ind	Diagnosis 1 - 12 Risk Indicator	ICDCM Codes Master File
Diag 1 - 12 SubGrp 1	Diagnosis 1 - 12 Sub Grouping 1	Diagnosis Codes Library
Diag 1 - 12 SubGrp 2	Diagnosis 1 - 12 Sub Grouping 2	Diagnosis Codes Library
Diag 1 - 12 Type	Diagnosis 1 - 12 Type	ICDCM Codes Master File
Payer Name	Payer (Insurance) Name associated with the Payment	Insurance Information for Payer associated with Payment
Fin Class	Financial Class	Payers Master File
Rendering	Rendering Provider	Encounter Maintenance
Provider SubGrp 1	Provider Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Provider SubGrp 2	Provider Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Addtl Prov	Additional Provider Note: Field name is from Practice Preferences > Charge Entry.	Charge Posting
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Encounter Referring	Encounter Referring Provider	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Fst Bill Dt	First Bill Date	Encounter Maintenance
Lst Bill Dt	Last Bill Date	Encounter Maintenance
FQHC Qual Enc	FQHC Qualifying Encounter Indicator	Encounter Maintenance > Claims
CCBHC Qual Enc	CCBHC Qualifying Encounter Indicator	Encounter Maintenance > Encounter Specifics
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Pat Prov UD 1 - 12	Patient Provider User Defined 1 - 12 Fields Note: Patient Provider names are from Practice Preferences > Providers.	Patient Information > Providers
Crt Dt	Create Date	Modification Information
Created By	Created By	Modification Information
Mod Dt	Last Modified Date	Modification Information
Modified By	Last Modified By	Modification 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
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
Prim Dental Prov Name	Primary Dental Provider Name	Patient Information
Batch Transaction Category	Batch Transaction Category Note: Field name is from Enterprise Preferences > General Tab.	Batch Maintenance
CC Vendor Processor	Credit Card Vendor Processor	Encounter Maintenance
CC Merchant ID	Credit Card Merchant ID	Encounter Maintenance
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
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
Claim/Resub #	Claim/Resubmission #	Encounter Maintenance
Time Based Units	Time Units	Service Items Library
Mod Units	Modifier Units	Service Items Library
Tot Units	Total Units	Charge Posting
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Base Unit	Base Unit	Service Items Library
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.
CPT EOC	CPT Episode of Care	CPT4 Codes Master File

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.
Outsource Date: Include refunds on line items outsourced 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).
Unapplied Transactions: Include/exclude unapplied credits. Select either Exclude or Include All (default).
Outsource: Include/exclude refunds on outsourced line items. Select either Only, Exclude, or Include All (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
Department
Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Financial Classes
Location Subgrouping 1
Location Subgrouping 2
Locations
Marketing Plan Type
Patient Types
Payer Subgrouping 1
Payer Subgrouping 2
Primary Payers
Provider Subgrouping 1
Provider Subgrouping 2
Referring Providers
Refund Transaction Codes
Rendering Providers
Service Items

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 Line Item Report Columns

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

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Service Location Name	Charge Posting
Location SubGrp 1	Location Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General tab.	Locations Master File
Location SubGrp 2	Location Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General tab.	Locations Master File
Post Date	Post Date	Transaction Detail
Proc Dt	Process date	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	Transaction Detail
E/I/A/B	Encounter Account Invoice Budget	Transaction Detail
Src Type	Source Type	Transaction Detail
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Addr 1	Address 1	Patient Information
Addr 2	Address 2	Patient Information
City	City	Patient Information
County	County	Patient Information
State	State	Patient Information
Zip	Zip Code	Patient Information
Sex	Sex at Birth	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Insured Name	Insured’s Name	Insurance Maintenance
Pat Type	Patient Type	Encounter Maintenance
Billed Amt	Billed Amount	Charge Posting
Collection Agency	Collection Agency	Encounter Maintenance
Aprv Amt	Approved Amount	Transaction Detail
Tran Dt	Transaction Date	Transaction Detail
Tran Cd	Transaction Code	Transaction Detail
Adj Amt	Adjustment Amount	Transaction Detail
Rsn Cds	Transaction Reason Code	Transaction Detail
Rsn Cds Desc	Reason Code Description	Reason Code Library
Diag 1 - 12	Diagnosis Code 1 - 12	Charge-Level: Codes 1-4 Encounter-Level: Codes 5-12
Diag 1 - 12 Cat	Diagnosis 1 - 12 Category	Diagnosis Categories Master File
Diag 1 - 12 Desc	Diagnosis 1 - 12 Description	Diagnosis Codes Library
Diag 1 - 12 EOC	Diagnosis 1 - 12 Episode of Care	ICDCM Codes Master File
Diag 1 - 12 Risk Ind	Diagnosis 1 - 12 Risk Indicator	ICDCM Codes Master File
Diag 1 - 12 SubGrp 1	Diagnosis 1 - 12 Sub Grouping 1	Diagnosis Codes Library
Diag 1 - 12 SubGrp 2	Diagnosis 1 - 12 Sub Grouping 2	Diagnosis Codes Library
Diag 1 - 12 Type	Diagnosis 1 - 12 Type	ICDCM Codes Master File
Payer Name	Payer (Insurance) Name associated with the Payment	Insurance Information for Payer associated with Payment
Fin Class	Financial Class	Payers Master File
Rendering	Rendering Provider	Encounter Maintenance
Provider SubGrp 1	Provider Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Provider SubGrp 2	Provider Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Providers Master File
Addtl Prov	Additional Provider Note: Field name is from Practice Preferences > Charge Entry.	Charge Posting
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Encounter Referring	Encounter Referring Provider	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Fst Bill Dt	First Bill Date	Encounter Maintenance
Lst Bill Dt	Last Bill Date	Encounter Maintenance
FQHC Qual Enc	FQHC Qualifying Encounter Indicator	Encounter Maintenance > Claims
CCBHC Qual Enc	CCBHC Qualifying Encounter Indicator	Encounter Maintenance > Encounter Specifics
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Client Defined names are from Enterprise Preferences > Client Defined Tab.	Patient Information > Client Defined
Pat Prov UD 1 - 12	Patient Provider User Defined 1 - 12 Fields Note: Patient Provider names are from Practice Preferences > Providers.	Patient Information > Providers
Crt Dt	Create Date	Modification Information
Created By	Created By	Modification Information
Mod Dt	Last Modified Date	Modification Information
Modified By	Last Modified By	Modification 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
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
Prim Dental Prov Name	Primary Dental Provider Name	Patient Information
Batch Transaction Category	Batch Transaction Category Note: Field name is from Enterprise Preferences > General Tab.	Batch Maintenance
CC Vendor Processor	Credit Card Vendor Processor	Encounter Maintenance
CC Merchant ID	Credit Card Merchant ID	Encounter Maintenance
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
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
Claim/Resub #	Claim/Resubmission #	Encounter Maintenance
Time Based Units	Time Units	Service Items Library
Mod Units	Modifier Units	Service Items Library
Tot Units	Total Units	Charge Posting
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Base Unit	Base Unit	Service Items Library
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.
CPT EOC	CPT Episode of Care	CPT4 Codes Master File

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.
Outsource Date: Include refunds on line items outsourced 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).
Unapplied Transactions: Include/exclude unapplied credits. Select either Exclude or Include All (default).
Outsource: Include/exclude refunds on outsourced line items. Select either Only, Exclude, or Include All (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
Department
Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Financial Classes
Location Subgrouping 1
Location Subgrouping 2
Locations
Marketing Plan Type
Patient Types
Payer Subgrouping 1
Payer Subgrouping 2
Primary Payers
Provider Subgrouping 1
Provider Subgrouping 2
Referring Providers
Refund Transaction Codes
Rendering Providers
Service Items

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 Line Item Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Refunds by Line Item Report Columns

Adjustments by Transaction Report Columns

Adjustments by Transaction Report Columns

Adjustments by Line Item Report Columns

Adjustments by Line Item Report Columns

Payments by Line Item Report Columns

Refunds by Line Item Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Refunds by Line Item Report Columns

Adjustments by Transaction Report Columns

Adjustments by Transaction Report Columns

Adjustments by Line Item Report Columns

Adjustments by Line Item Report Columns

Payments by Line Item Report Columns