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
| Locations Master File |
| Location SubGrp 2 | Location Subgrouping 2
| 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 |
| 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
| Providers Master File |
| Provider SubGrp 2 | Provider Subgrouping 2
| Providers Master File |
| Addtl Prov | Additional Provider
| 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 | |
| CCBHC Qual Enc | CCBHC Qualifying Encounter Indicator | |
| Client Def 1 - 14 | Enterprise Client Defined 1 - 14 Fields
| |
| Pat Prov UD 1 - 12 | Patient Provider User Defined 1 - 12 Fields
| |
| 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
|
| Ethnicity | Ethnicity | Patient Information
|
| 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
| 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
|
| Ethnicity Category | Ethnicity Category | Ethnicity Category Mapping Master File
|
| 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
Totals
Use columns to sub-total and total data on the report. Column total options include the following:
- Sum
- Average
- Count
- Totals