Contractual Analysis Report Columns

The following columns are available on the Contractual Analysis report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Service Location Name	Encounter Maintenance
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
Payer Name	Payer Name	Encounter Insurance
Payer SubGrp 1	Payer Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Payers Master File
Payer SubGrp 2	Payer Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Payers Master File
Fin Class	Financial Class	Payers Master File
Contract	Contract	Contract Library
Contract Ex	Contract Exception	Contract Library
Rendering	Rendering Provider	Charge Posting
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
Par	Participating Provider Indicator	Contract Library
Sv It	Service Item Number	Charge Posting
Sv It Desc	Service Item Description	Charge Posting
CPT4	CPT4 Code	Service Items Library
CPT4 Desc	CPT4 Code Description	Service Items Library
Mod 1-4	Modifier 1 - 4	Charge Posting
Diag 1-4	Diagnosis Codes 1-4	Charge Posting
Diag Desc 1-4	Diagnosis Description 1-4	Diagnosis Master File
Count	Count	Charge Posting
Unit Price	Unit Price	Charge Posting
Chg Amt	Charge Amount	Charge Posting
Pmt Posted	Payment Posted	Payment Entry
Ovr	Override (Y/N)	Charge Posting
Act Pay Amt	Actual Payment Amount	Payment Entry
Cont Pay Amount	Contract Payment Amount	Contract Library
Diff Adj Amt	Difference Adjustment Amount	Calculated [Contract Adj - Actual Adj = Difference Adj]
Act Adj Amt	Actual Adjustment Amount	Charge Posting
Contract Adj Amt	Contract Adjustment Amount	Contract Library
Ln Itm Amt	Line Item Amount of the charge	Charge Posting
Tran Status	Transaction Status	Transaction Detail
Rsn Cds	Reason Codes	Transaction Detail
E/I	Encounter Invoice Number	Transaction Detail
ST	Abbreviated Source Type	Transaction Detail
Source Type	Charge Type: Encounters and/or Invoices	Transaction Detail
Dt of Svc	Date of Service	Charge Posting
End Dt of Svc	End Date of Service	Charge Posting
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Md Rc	Medical Record Number	Patient Chart
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
Pat Type	Patient Type	Encounter Maintenance
Place of Serv	Place of Service	Charge Posting
Facility	Facility	Encounter Maintenance
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting	Encounter Maintenance
Sec Consult	Second Consulting	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Enc Referring	Encounter Referring Provider	Encounter Maintenance
Chg Referring	Charge Referring Provider	Charge Posting
PA	Default column heading labeled as Mid-Level.	Practice Preferences
Seq#	Sequence Number (#)	Charge Posting
Bt Info	Batch Information	Batch Header
Department	Service Item Department	Service Items Library
Modality	Service Item Modality	Service Items Library
Component	Service Item Component: Global, Professional, Technical	Service Items Library
Rv Cd	Service Item Revenue Code	Service Items Library
Aft Care	Service Item After Care Days	Service Items Library
Notes	Notes	Charge Posting
Ovr Proc Dt	Override Process Date	Charge Posting
Policy #	Policy Number	Insurance Maintenance
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Subgrouping name is from Enterprise Preferences > General Tab.	Patient Information > Client Defined
Base Unit	Base Unit (Anesthesia)	Service Items Library
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Anesthesia Alt Code	Anesthesia Alternate Code	Charge Posting
Crt Dt	Create Date	Charge Posting
Created By	Created By	Charge Posting
Mod Dt	Modified Date	Charge Posting
Modified By	Modified By	Charge Posting
Proc Dt	Process Date	Charge Posting
Cob1 Amt	COB1 Amount	Balance Control
Cob2 Amt	COB2 Amount	Balance Control
Cob3 Amt	COB3 Amount	Balance Control
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
Diag 1 - 12 Cat	Diagnosis 1 - 12 Category	Diagnosis Categories Master File
Diag 1 - 12	Diagnosis Code 1 - 12	Charge-Level: Codes 1-4 Encounter-Level: Codes 5-12
Diag 1 - 12 Desc	Diagnosis 1 - 12 Description	Diagnosis Codes Library
Diag 1 - 12 Risk Ind	Diagnosis 1 - 12 Risk Indicator	ICDCM Codes Master File
Diag 1 - 12 EOC	Diag 1 - 12 Episode of Care	ICDCM Codes Master File
Diag 1 - 12 Sub1 Grp 1	Diagnosis 1 - 12 Sub Grouping 1	Diagnosis Codes Library
Diag 1 - 12 Sub2 Grp 2	Diagnosis 1 - 12 Sub Grouping 2	Diagnosis Codes Library
Diag 1 - 12 Type	Diagnosis 1 - 12 Type	ICDCM Codes Master File
RVU 1	Relative Value Unit 1	Service Items Library
RVU Total 1	Relative Value Unit Total 1	Service Items Library
RVU 2	Relative Value Unit 2	Service Items Library
RVU Total 2	Relative Value Unit Total 2	Service Items Library
RVU 3	Relative Value Unit 3	Service Items Library
RVU Total 3	Relative Value Unit Total 3	Service Items Library
RVU 4	Relative Value Unit 4	Service Items Library
RVU Total 4	Relative Value Unit Total 4	Service Items Library
RVU 5	Relative Value Unit 5	Service Items Library
RVU Total 5	Relative Value Unit Total 5	Service Items Library
RVU 6	Relative Value Unit 6	Service Items Library
RVU Total 6	Relative Value Unit Total 6	Service Items Library
RVU 7	Relative Value Unit 7	Service Items Library
RVU Total 7	Relative Value Unit Total 7	Service Items Library
RVU 8	Relative Value Unit 8	Service Items Library
RVU Total 8	Relative Value Unit Total 8	Service Items Library
Homeless Status	Homeless Status	Patient Information > UDS
Migrant Worker Status	Migrant Worker Status	Patient Information > UDS
Language Barrier	Language Barrier	Patient Information > UDS
Prim Dental Prov Name	Primary Dental Provider Name	Patient Information
Prim Enc Rate SIM	Primary Encounter Rate Service Item	Encounter Maintenance
Prim Enc Rate Amt	Primary Encounter Rate Amount	Encounter Maintenance
Sec Enc Rate SIM	Secondary Encounter Rate Service Item	Encounter Maintenance
Sec Enc Rate Amt	Secondary Encounter Rate Amount	Encounter Maintenance
Ter Enc Rate SIM	Tertiary Encounter Rate Service Item	Encounter Maintenance
Ter Enc Rate Amt	Tertiary Encounter Rate Amount	Encounter Maintenance
Race	Race	Patient Information Note: Multiple entries are separated by commas.
Race Category	Race Category	Race Category Mapping Master File Note: Multiple entries are separated by commas.
Ethnicity	Ethnicity	Patient Information Note: Multiple entries are separated by commas.
Ethnicity Category	Ethnicity Category	Ethnicity Category Mapping Master File Note: Multiple entries are separated by commas.
Tribal Affiliation	Tribal Affiliation	Patient Information > UDS
Blood Quantum	Blood Quantum	Patient Information > UDS
Veteran Status	Veteran Status	Patient Information
School Based Hlth Care	School Based Health Care	Patient Information > UDS
Public Housing Primary	Public Housing Primary Care	Patient Information > UDS
Descendancy	Descendancy	Patient Information > UDS
IHS Eligibility Status	IHS Eligibility Status	Patient Information > UDS
Classification Beneficiary	Classification Beneficiary	Patient Information > UDS
Community Code	Community Code	Patient Information
Consent to Treat Ind	Consent to Treat Indicator	Patient Information > UDS
Consent to Treat Date	Consent to Treat Date	Patient Information > UDS
Enc Homeless Status	Encounter Homeless Status	Encounter Maintenance
CPT EOC	CPT Episode of Care	CPT4 Codes Master File
APG Code	APG Code
Rate Code	APG Rate Code
Pmt %	APG Payment Percentage
Weight	APG Weight
Add-On	APG Add-On Amount
Expected Reimb Amt	APG Expected Reimbursement Amount
Message	APG Message
APG Date	APG Response Date
APG Diff Pay Amt	APG Differences in Payment Amounts

Filter 1

Use parameters to filter data on the report:

Create Date: Include charges with a Create Date within a date range.
Process Date: Include charges with a Process Date within a date range.
Service Date: Include charges with a Service Date within a date range.
Transaction Post Date: Include transactions with a Post Date within a date range.
Transaction Process Date: Include transactions with a Process Date within a date range.
Transaction Date: Include transactions with a Transaction Date within a date range.
Run Using: Run as if a selected [Contract] was attached to the payer.
Include: Include Payers without attached contracts.

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:

Contracts
Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Location Subgrouping 1
Location Subgrouping 2
Locations
Payer Subgrouping 1
Payer Subgrouping 2
Payers
Provider Specialty
Provider Subgrouping 1
Provider Subgrouping 2
Referring Providers
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'.

Contractual Analysis Report Columns

The following columns are available on the Contractual Analysis report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice associated with the patient's encounter
Loc Name	Service Location Name	Encounter Maintenance
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
Payer Name	Payer Name	Encounter Insurance
Payer SubGrp 1	Payer Subgrouping 1 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Payers Master File
Payer SubGrp 2	Payer Subgrouping 2 Note: Subgrouping name is from Enterprise Preferences > General Tab.	Payers Master File
Fin Class	Financial Class	Payers Master File
Contract	Contract	Contract Library
Contract Ex	Contract Exception	Contract Library
Rendering	Rendering Provider	Charge Posting
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
Par	Participating Provider Indicator	Contract Library
Sv It	Service Item Number	Charge Posting
Sv It Desc	Service Item Description	Charge Posting
CPT4	CPT4 Code	Service Items Library
CPT4 Desc	CPT4 Code Description	Service Items Library
Mod 1-4	Modifier 1 - 4	Charge Posting
Diag 1-4	Diagnosis Codes 1-4	Charge Posting
Diag Desc 1-4	Diagnosis Description 1-4	Diagnosis Master File
Count	Count	Charge Posting
Unit Price	Unit Price	Charge Posting
Chg Amt	Charge Amount	Charge Posting
Pmt Posted	Payment Posted	Payment Entry
Ovr	Override (Y/N)	Charge Posting
Act Pay Amt	Actual Payment Amount	Payment Entry
Cont Pay Amount	Contract Payment Amount	Contract Library
Diff Adj Amt	Difference Adjustment Amount	Calculated [Contract Adj - Actual Adj = Difference Adj]
Act Adj Amt	Actual Adjustment Amount	Charge Posting
Contract Adj Amt	Contract Adjustment Amount	Contract Library
Ln Itm Amt	Line Item Amount of the charge	Charge Posting
Tran Status	Transaction Status	Transaction Detail
Rsn Cds	Reason Codes	Transaction Detail
E/I	Encounter Invoice Number	Transaction Detail
ST	Abbreviated Source Type	Transaction Detail
Source Type	Charge Type: Encounters and/or Invoices	Transaction Detail
Dt of Svc	Date of Service	Charge Posting
End Dt of Svc	End Date of Service	Charge Posting
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Md Rc	Medical Record Number	Patient Chart
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
Pat Type	Patient Type	Encounter Maintenance
Place of Serv	Place of Service	Charge Posting
Facility	Facility	Encounter Maintenance
Admitting	Admitting Provider	Encounter Maintenance
Fst Consult	First Consulting	Encounter Maintenance
Sec Consult	Second Consulting	Encounter Maintenance
Supervisor	Supervising Provider	Encounter Maintenance
Enc Referring	Encounter Referring Provider	Encounter Maintenance
Chg Referring	Charge Referring Provider	Charge Posting
PA	Default column heading labeled as Mid-Level.	Practice Preferences
Seq#	Sequence Number (#)	Charge Posting
Bt Info	Batch Information	Batch Header
Department	Service Item Department	Service Items Library
Modality	Service Item Modality	Service Items Library
Component	Service Item Component: Global, Professional, Technical	Service Items Library
Rv Cd	Service Item Revenue Code	Service Items Library
Aft Care	Service Item After Care Days	Service Items Library
Notes	Notes	Charge Posting
Ovr Proc Dt	Override Process Date	Charge Posting
Policy #	Policy Number	Insurance Maintenance
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Subgrouping name is from Enterprise Preferences > General Tab.	Patient Information > Client Defined
Base Unit	Base Unit (Anesthesia)	Service Items Library
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Anesthesia Alt Code	Anesthesia Alternate Code	Charge Posting
Crt Dt	Create Date	Charge Posting
Created By	Created By	Charge Posting
Mod Dt	Modified Date	Charge Posting
Modified By	Modified By	Charge Posting
Proc Dt	Process Date	Charge Posting
Cob1 Amt	COB1 Amount	Balance Control
Cob2 Amt	COB2 Amount	Balance Control
Cob3 Amt	COB3 Amount	Balance Control
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
Diag 1 - 12 Cat	Diagnosis 1 - 12 Category	Diagnosis Categories Master File
Diag 1 - 12	Diagnosis Code 1 - 12	Charge-Level: Codes 1-4 Encounter-Level: Codes 5-12
Diag 1 - 12 Desc	Diagnosis 1 - 12 Description	Diagnosis Codes Library
Diag 1 - 12 Risk Ind	Diagnosis 1 - 12 Risk Indicator	ICDCM Codes Master File
Diag 1 - 12 EOC	Diag 1 - 12 Episode of Care	ICDCM Codes Master File
Diag 1 - 12 Sub1 Grp 1	Diagnosis 1 - 12 Sub Grouping 1	Diagnosis Codes Library
Diag 1 - 12 Sub2 Grp 2	Diagnosis 1 - 12 Sub Grouping 2	Diagnosis Codes Library
Diag 1 - 12 Type	Diagnosis 1 - 12 Type	ICDCM Codes Master File
RVU 1	Relative Value Unit 1	Service Items Library
RVU Total 1	Relative Value Unit Total 1	Service Items Library
RVU 2	Relative Value Unit 2	Service Items Library
RVU Total 2	Relative Value Unit Total 2	Service Items Library
RVU 3	Relative Value Unit 3	Service Items Library
RVU Total 3	Relative Value Unit Total 3	Service Items Library
RVU 4	Relative Value Unit 4	Service Items Library
RVU Total 4	Relative Value Unit Total 4	Service Items Library
RVU 5	Relative Value Unit 5	Service Items Library
RVU Total 5	Relative Value Unit Total 5	Service Items Library
RVU 6	Relative Value Unit 6	Service Items Library
RVU Total 6	Relative Value Unit Total 6	Service Items Library
RVU 7	Relative Value Unit 7	Service Items Library
RVU Total 7	Relative Value Unit Total 7	Service Items Library
RVU 8	Relative Value Unit 8	Service Items Library
RVU Total 8	Relative Value Unit Total 8	Service Items Library
Homeless Status	Homeless Status	Patient Information > UDS
Migrant Worker Status	Migrant Worker Status	Patient Information > UDS
Language Barrier	Language Barrier	Patient Information > UDS
Prim Dental Prov Name	Primary Dental Provider Name	Patient Information
Prim Enc Rate SIM	Primary Encounter Rate Service Item	Encounter Maintenance
Prim Enc Rate Amt	Primary Encounter Rate Amount	Encounter Maintenance
Sec Enc Rate SIM	Secondary Encounter Rate Service Item	Encounter Maintenance
Sec Enc Rate Amt	Secondary Encounter Rate Amount	Encounter Maintenance
Ter Enc Rate SIM	Tertiary Encounter Rate Service Item	Encounter Maintenance
Ter Enc Rate Amt	Tertiary Encounter Rate Amount	Encounter Maintenance
Race	Race	Patient Information Note: Multiple entries are separated by commas.
Race Category	Race Category	Race Category Mapping Master File Note: Multiple entries are separated by commas.
Ethnicity	Ethnicity	Patient Information Note: Multiple entries are separated by commas.
Ethnicity Category	Ethnicity Category	Ethnicity Category Mapping Master File Note: Multiple entries are separated by commas.
Tribal Affiliation	Tribal Affiliation	Patient Information > UDS
Blood Quantum	Blood Quantum	Patient Information > UDS
Veteran Status	Veteran Status	Patient Information
School Based Hlth Care	School Based Health Care	Patient Information > UDS
Public Housing Primary	Public Housing Primary Care	Patient Information > UDS
Descendancy	Descendancy	Patient Information > UDS
IHS Eligibility Status	IHS Eligibility Status	Patient Information > UDS
Classification Beneficiary	Classification Beneficiary	Patient Information > UDS
Community Code	Community Code	Patient Information
Consent to Treat Ind	Consent to Treat Indicator	Patient Information > UDS
Consent to Treat Date	Consent to Treat Date	Patient Information > UDS
Enc Homeless Status	Encounter Homeless Status	Encounter Maintenance
CPT EOC	CPT Episode of Care	CPT4 Codes Master File
APG Code	APG Code
Rate Code	APG Rate Code
Pmt %	APG Payment Percentage
Weight	APG Weight
Add-On	APG Add-On Amount
Expected Reimb Amt	APG Expected Reimbursement Amount
Message	APG Message
APG Date	APG Response Date
APG Diff Pay Amt	APG Differences in Payment Amounts

Filter 1

Use parameters to filter data on the report:

Create Date: Include charges with a Create Date within a date range.
Process Date: Include charges with a Process Date within a date range.
Service Date: Include charges with a Service Date within a date range.
Transaction Post Date: Include transactions with a Post Date within a date range.
Transaction Process Date: Include transactions with a Process Date within a date range.
Transaction Date: Include transactions with a Transaction Date within a date range.
Run Using: Run as if a selected [Contract] was attached to the payer.
Include: Include Payers without attached contracts.

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:

Contracts
Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Location Subgrouping 1
Location Subgrouping 2
Locations
Payer Subgrouping 1
Payer Subgrouping 2
Payers
Provider Specialty
Provider Subgrouping 1
Provider Subgrouping 2
Referring Providers
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'.

Contractual Analysis Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Anesthesia Contractual Analysis Report Columns

Payments by Transaction Report Columns

Adjustments by Transaction Report Columns

Collections Follow Up Report Columns

Change in AR w/o Enc Rate Report Columns

Payments by Line Item Report Columns

Contractual Analysis Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Anesthesia Contractual Analysis Report Columns

Payments by Transaction Report Columns

Adjustments by Transaction Report Columns

Collections Follow Up Report Columns

Change in AR w/o Enc Rate Report Columns

Payments by Line Item Report Columns