Anesthesia Contractual Analysis Report Columns

The following columns are available on the Anesthesia Contractual Analysis report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice Associated with the patient's encounter
Loc Name	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
Rendering	Charge 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
Prov Spec	Provider Specialty	Providers Master File
Sv It	Service Item ID	Charge Posting
Sv It Desc	Service Item Description	Service Items Library
CPT4	CPT4	Service Items Library
CPT4 Desc	CPT4 Description	Service Items Library
Mod 1	Modifier 1	Charge Posting
Mod 2	Modifier 2	Charge Posting
Mod 3	Modifier 3	Charge Posting
Mod 4	Modifier 4	Charge Posting
Diag Cat 1	Diagnosis Category 1	Diagnosis Codes Library
Diag Cat 2	Diagnosis Category 2	Diagnosis Codes Library
Diag Cat 3	Diagnosis Category 3	Diagnosis Codes Library
Diag Cat 4	Diagnosis Category 4	Diagnosis Codes Library
Diag 1	Diagnosis Code 1	Charge Posting
Diag 2	Diagnosis Code 2	Charge Posting
Diag 3	Diagnosis Code 3	Charge Posting
Diag 4	Diagnosis Code 4	Charge Posting
Diag Desc 1	Diagnosis Description 1	Diagnosis Codes Library
Diag Desc 2	Diagnosis Description 2	Diagnosis Codes Library
Diag Desc 3	Diagnosis Description 3	Diagnosis Codes Library
Diag Desc 4	Diagnosis Description 4	Diagnosis Codes Library
Diag Sub1 Grp 1	Diagnosis Sub1 Grouping 1	Diagnosis Codes Library
Diag Sub2 Grp 1	Diagnosis Sub2 Grouping 1	Diagnosis Codes Library
Diag Sub1 Grp 2	Diagnosis Sub1 Grouping 2	Diagnosis Codes Library
Diag Sub2 Grp 2	Diagnosis Sub2 Grouping 2	Diagnosis Codes Library
Diag Sub1 Grp 3	Diagnosis Sub1 Grouping 3	Diagnosis Codes Library
Diag Sub2 Grp 3	Diagnosis Sub2 Grouping 3	Diagnosis Codes Library
Diag Sub1 Grp 4	Diagnosis Sub1 Grouping 4	Diagnosis Codes Library
Diag Sub2 Grp 4	Diagnosis Sub2 Grouping 4	Diagnosis Codes Library
Diag Type 1	Diagnosis Type 1	ICDCM Codes Master File
Diag Type 2	Diagnosis Type 2	ICDCM Codes Master File
Diag Type 3	Diagnosis Type 3	ICDCM Codes Master File
Diag Type 4	Diagnosis Type 4	ICDCM Codes Master File
Count	Count	Charge Posting
Unit Price	Charge Unit Price	Charge Posting
Chg Amt	Charge Amount	Charge Posting
Pmt Pst	Payment Posted	Transaction Detail
Pat Payment	Patient Payment on Charge	Transaction Detail
Ln Itm Amt	Line Item Amount	Balance Control
Cur Ln Itm Amt	Real Time Line Item Amount (not affected by date filter)	Balance Control
Cob1 Amt	COB1 Amount	Balance Control
Cob2 Amt	COB2 Amount	Balance Control
Cob3 Amt	COB3 Amount	Balance Control
Pat Amt	Patient Responsibility Amount	Balance Control
Tran Status	Transaction Status	Transaction Detail
Rsn Cds/Remarks	Reason/Remark Codes	Transaction Detail
Zero Pmt Rsn Codes	Zero Payment Reason Codes	Transaction Detail
E/I	Source Number	Encounter Maintenance
ST	Source Type Abbreviation	E/A/I/B
Src Type	Source Type	Encounter/Account/Invoice/Budget
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
Med Rec	Medical Record Number	Patient Chart
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 Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Enc Referring	Encounter Referring Provider	Encounter Maintenance
Chg Referring	Charge Referring Provider	Charge Posting
Seq#	Charge Sequence Number	Charge Posting
Bt Info	Charge Batch Information	Charge Posting
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
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Subgrouping name is from Enterprise Preferences > Client Defined tab.	Patient Information > Client Defined
Base Unit	Base Unit	Charge Posting
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Policy #	Policy Number	Insurance Information
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
Proc Dt	Process Date	Charge Posting
Diag1 Rsk Ind	Diagnosis 1 Risk Indicator	ICDCM Codes Master File
Diag2 Rsk Ind	Diagnosis 2 Risk Indicator	ICDCM Codes Master File
Diag3 Rsk Ind	Diagnosis 3 Risk Indicator	ICDCM Codes Master File
Diag4 Rsk Ind	Diagnosis 4 Risk Indicator	ICDCM Codes Master File
Expected Reimb	Anes Expected Reimburse Amt	Transaction Detail
Act TP Pay Amt	Actual Payment from Third Party	Transaction Detail
Anes Diff Pay Amt	Anesthesia Difference Pay Amt	Transaction Detail
Charge MDA	Charge MDA	Charge Posting
Units	Total Anes Units	Charge Posting
Pat Copay	Insurance/Contract Copay Amount	Insurance Information
Contract Allowed Amt	Contract Allowed Extended Price	Calculated during Concurrency Audit / Applied during Convert In Progress to Unbilled process (Contract Allow Unit X Total Units = Contract Allow Amt)
Surgical CPT4	Surgical Procedure	Charge Posting
Surgical CPT4 Desc	Surgical Procedure Description	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.

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.
Override Process Date: Include charges with an Override Process Date within a date range.

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:

Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Location Subgrouping 1
Location Subgrouping 2
Locations
Payer Subgrouping 1
Payer 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'.

Anesthesia Contractual Analysis Report Columns

The following columns are available on the Anesthesia Contractual Analysis report:

Column Name	Description	Data Populates From
Prac Name	Practice Name	Practice Associated with the patient's encounter
Loc Name	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
Rendering	Charge 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
Prov Spec	Provider Specialty	Providers Master File
Sv It	Service Item ID	Charge Posting
Sv It Desc	Service Item Description	Service Items Library
CPT4	CPT4	Service Items Library
CPT4 Desc	CPT4 Description	Service Items Library
Mod 1	Modifier 1	Charge Posting
Mod 2	Modifier 2	Charge Posting
Mod 3	Modifier 3	Charge Posting
Mod 4	Modifier 4	Charge Posting
Diag Cat 1	Diagnosis Category 1	Diagnosis Codes Library
Diag Cat 2	Diagnosis Category 2	Diagnosis Codes Library
Diag Cat 3	Diagnosis Category 3	Diagnosis Codes Library
Diag Cat 4	Diagnosis Category 4	Diagnosis Codes Library
Diag 1	Diagnosis Code 1	Charge Posting
Diag 2	Diagnosis Code 2	Charge Posting
Diag 3	Diagnosis Code 3	Charge Posting
Diag 4	Diagnosis Code 4	Charge Posting
Diag Desc 1	Diagnosis Description 1	Diagnosis Codes Library
Diag Desc 2	Diagnosis Description 2	Diagnosis Codes Library
Diag Desc 3	Diagnosis Description 3	Diagnosis Codes Library
Diag Desc 4	Diagnosis Description 4	Diagnosis Codes Library
Diag Sub1 Grp 1	Diagnosis Sub1 Grouping 1	Diagnosis Codes Library
Diag Sub2 Grp 1	Diagnosis Sub2 Grouping 1	Diagnosis Codes Library
Diag Sub1 Grp 2	Diagnosis Sub1 Grouping 2	Diagnosis Codes Library
Diag Sub2 Grp 2	Diagnosis Sub2 Grouping 2	Diagnosis Codes Library
Diag Sub1 Grp 3	Diagnosis Sub1 Grouping 3	Diagnosis Codes Library
Diag Sub2 Grp 3	Diagnosis Sub2 Grouping 3	Diagnosis Codes Library
Diag Sub1 Grp 4	Diagnosis Sub1 Grouping 4	Diagnosis Codes Library
Diag Sub2 Grp 4	Diagnosis Sub2 Grouping 4	Diagnosis Codes Library
Diag Type 1	Diagnosis Type 1	ICDCM Codes Master File
Diag Type 2	Diagnosis Type 2	ICDCM Codes Master File
Diag Type 3	Diagnosis Type 3	ICDCM Codes Master File
Diag Type 4	Diagnosis Type 4	ICDCM Codes Master File
Count	Count	Charge Posting
Unit Price	Charge Unit Price	Charge Posting
Chg Amt	Charge Amount	Charge Posting
Pmt Pst	Payment Posted	Transaction Detail
Pat Payment	Patient Payment on Charge	Transaction Detail
Ln Itm Amt	Line Item Amount	Balance Control
Cur Ln Itm Amt	Real Time Line Item Amount (not affected by date filter)	Balance Control
Cob1 Amt	COB1 Amount	Balance Control
Cob2 Amt	COB2 Amount	Balance Control
Cob3 Amt	COB3 Amount	Balance Control
Pat Amt	Patient Responsibility Amount	Balance Control
Tran Status	Transaction Status	Transaction Detail
Rsn Cds/Remarks	Reason/Remark Codes	Transaction Detail
Zero Pmt Rsn Codes	Zero Payment Reason Codes	Transaction Detail
E/I	Source Number	Encounter Maintenance
ST	Source Type Abbreviation	E/A/I/B
Src Type	Source Type	Encounter/Account/Invoice/Budget
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
Med Rec	Medical Record Number	Patient Chart
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 Provider	Encounter Maintenance
Sec Consult	Second Consulting Provider	Encounter Maintenance
Enc Referring	Encounter Referring Provider	Encounter Maintenance
Chg Referring	Charge Referring Provider	Charge Posting
Seq#	Charge Sequence Number	Charge Posting
Bt Info	Charge Batch Information	Charge Posting
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
Client Def 1 - 14	Enterprise Client Defined 1 - 14 Fields Note: Subgrouping name is from Enterprise Preferences > Client Defined tab.	Patient Information > Client Defined
Base Unit	Base Unit	Charge Posting
Beg Tm	Begin Time	Charge Posting
End Tm	End Time	Charge Posting
Tot Tm	Total Time	Charge Posting
Policy #	Policy Number	Insurance Information
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
Proc Dt	Process Date	Charge Posting
Diag1 Rsk Ind	Diagnosis 1 Risk Indicator	ICDCM Codes Master File
Diag2 Rsk Ind	Diagnosis 2 Risk Indicator	ICDCM Codes Master File
Diag3 Rsk Ind	Diagnosis 3 Risk Indicator	ICDCM Codes Master File
Diag4 Rsk Ind	Diagnosis 4 Risk Indicator	ICDCM Codes Master File
Expected Reimb	Anes Expected Reimburse Amt	Transaction Detail
Act TP Pay Amt	Actual Payment from Third Party	Transaction Detail
Anes Diff Pay Amt	Anesthesia Difference Pay Amt	Transaction Detail
Charge MDA	Charge MDA	Charge Posting
Units	Total Anes Units	Charge Posting
Pat Copay	Insurance/Contract Copay Amount	Insurance Information
Contract Allowed Amt	Contract Allowed Extended Price	Calculated during Concurrency Audit / Applied during Convert In Progress to Unbilled process (Contract Allow Unit X Total Units = Contract Allow Amt)
Surgical CPT4	Surgical Procedure	Charge Posting
Surgical CPT4 Desc	Surgical Procedure Description	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.

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.
Override Process Date: Include charges with an Override Process Date within a date range.

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:

Diagnosis Category
Diagnosis Codes
Diagnosis Subgrouping 1
Diagnosis Subgrouping 2
Location Subgrouping 1
Location Subgrouping 2
Locations
Payer Subgrouping 1
Payer 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'.

Anesthesia Contractual Analysis Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Contractual Analysis Report Columns

Collections Follow Up Report Columns

Payments by Transaction Report Columns

Change in AR w/o Enc Rate Report Columns

Adjustments by Transaction Report Columns

Provider Productivity by RVU Report Columns

Anesthesia Contractual Analysis Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Contractual Analysis Report Columns

Collections Follow Up Report Columns

Payments by Transaction Report Columns

Change in AR w/o Enc Rate Report Columns

Adjustments by Transaction Report Columns

Provider Productivity by RVU Report Columns