Patient Insurance Report Columns

The following columns are available on the Patient Insurance report:

Column Name	Description	Data Populates From
Practice Name	Practice Name	Practice associated with the patient's insurance
Payer Name	Payer Name	Payers Master File
Payer SubGrp 1	Payer Subgrouping 1 Note: Subgrouping name is from Enterprise PreferencesGeneral Tab.	Payers Master File
Payer SubGrp 2	Payer Subgrouping 2 Note: Subgrouping name is from Enterprise PreferencesGeneral Tab.	Payers Master File
Contracted Ind	Contracted Payer Indicator	Payers Master File
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Ins Name	Insured Name	Insurance Maintenance
Relation	The name that displays in this column displays the name of the person who responsible for the patient insurance and what the relationship is.	Insurance Maintenance
Enc COB	Encounter Coordination of Benefits	Encounter Maintenance
Addr1	Address 1	Patient Information
Addr2	Address 2	Patient Information
City	City	Patient Information
Country	Country	Patient Information
County	County	Patient Information
Hm Phone	Home Phone	Patient Information
Day Phone	Day Phone	Patient Information
Alt Phone	Alternate Phone	Patient Information
Sec Hm Phone	Secondary Home Phone	Patient Information
Cell Ph	Cell Phone	Patient Information
Sex Code	Sex at Birth Abbreviation (M/F/U)	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Cont	Emergency Contact	Patient Information
Cont Phone	Emergency Contact Name	Patient Information
Contact Fax	Emergency Contact Fax number	Patient Information
Email Addr	Email Address	Patient Information
Lst Enc	Date of the patient last encounter.	Encounter Maintenance
Lst Enc Dt	The last billable date for the encounter.	Encounter Maintenance
Act	Active patient indicator	Patient Information
Avail	Include/Exclude Indicator	Include/Exclude list in System Admin Module
Co Amt	Co-pay Amount	Insurance Maintenance
Ded Amt	Deductible Amount	Insurance Maintenance
Co Type	Co-Pay Type	Insurance Maintenance
Co Perc	Co-Pay Percentage	Insurance Maintenance
Fr Ins Cd	Front of Insurance Card	Patient Information
Bck Ins Cd	Back of Insurance Card	Patient Information
Pol Eff	The date that the insurance policy is in effect.	Insurance Maintenance
Pol Nbr	Insurance policy number Note: If you override the policy number on the Insurance Maintenance window, it displays here instead of the original policy number.	Insurance Maintenance
Pol Exp	Policy Expiration	Insurance Maintenance
Plan #	Insurance plan number	Insurance Maintenance
Not	Notification Indicator	Patient Information
Ver	Verification Indicator	Patient Information
Auth	Authorization Pre-certification indicator	Insurance Maintenance
Group Name	Insurance group name	Insurance Maintenance
Group #	Insurance group number	Insurance Maintenance
MSP	Medicare Secondary Payer Reason	Patient Chart
Medi #	Medi Gap ID number Medicare supplemental plan (better known as “Medi-Gap” plans for picking up the “gaps” in Medicare Parts A, B and C).	Patient Chart
Sig	Sig Events Source description	Patient Information
Orig Payer Name	Original Payer Name	Payers Master File
Med Cv	Medical Coverage Indicator	Patient Information
Dent Cv	Dental Coverage Indicator	Patient Information
Pres Cv	Prescription Coverage Indicator	Patient Information
Eye Cv	Vision Coverage Indicator	Patient Information
Workers Cv	Workman's Compensation Indicator	Patient Information
Def COB	Default Coordination of Benefits	Patient Information
Emp	Employer Name	Patient Information
Def Pay Dt	Default Payer date	Payers Master File
NDex	County Code	Patient Information
Claim Type	Claim Type	Patient Information
Ins Type	Insurance Type	Patient Information
BCBS	Blue Cross Blue Shield Plan Code	Payers Master File
KP	Kenpak Indicator KenPAK is a Kentucky Medicaid Plan.	Payers Master File
Note	Note Indicator	Patient Chart
NEIC/Pyr#	NEIC/Payer number	Payers Master File
Addr1	Payer address line 1	Payers Master File
Addr2	Payer address line 2	Payers Master File
City, State, Zip	Payer city, state, Zip	Payers Master File
Country	Payer country	Payers Master File
County	Payer country	Payers Master File
Payer Email Addr	Payer email address	Payers Master File
National Plan ID	National Plan ID number	Payers Master File
MP	MediPass Indicator	Payers Master File
Edt	No Edit Indicator	Payers Master File
Crs	ERA Crossover Flag indicator	Payers Master File
OPN	Display override policy number indicator	Payers Master File
Hid	Hidden indicator	Payers Master File
Fin Class	Financial Class	Payers Master File
Def Pay Trans	Default payment transaction description	Payers Master File
Def Adj Trans	Default adjustment transaction description	Payers Master File
Sub Lib	Submitter Profile Library indicator	Submitter Profile Library
UB Sub Lib	UB Submitter Profile	Submitter Profile Library
Trans ID	Transaction ID	Payers Master File
UB Trans ID	UB Transaction ID	Payers Master File
Med	Media type description	Payers Master File
Sec Med	Secondary Media Type	Payers Master File
Ter Med	Tertiary Media Type	Payers Master File
Mgd Care Cont	Managed care contract indicator	Payers Master File
Rsn Cd Lib	Reason Code Library	Practice Preferences
Place of Serv	Place of Service	Charge Posting
UB	UB Field 52	Payers Master File
User Defined	User Defined Fields 1-10	Enterprise Practices
Pro	Pro-rate indicator	Payers Master File
Co Resp	Co-pay responsibility	Payers Master File
Form Temp	Form template description	Form Templates Master
CE Lib	Claim Edit Library description	Claim Edit Library
Nt Tmp	Note template indicator	Payers Master File
Nt Tmp Desc	Note template description	Payers Master File
Enc Co	Encounter co-pay required indicator	Encounter Maintenance
Addtl Tran1-6	Transaction descriptions for transaction codes 1-6	Transaction Master
Co Perc	Co-pay percentage indicator	Payers Master File
Clm Sub	Claim Submitter type	Claim Submitter Library
Ref Auth	Referral authorization required	Payers Master File
Ref Frm	Referral indicator	Payers Master File
Lab Fac	Laboratory Facility used indicator	Charge Posting
Rad Fac	Radiology Facility used indicator	Charge Posting
Diag Code	Diagnosis Code indicator	Charge Posting
Accept Asn	Default Accept Assignment indicator	Payers Master File
Def Deduct	Default deductible Amount	Payers Master File
Plan Type	Plan Type	Payers Master File
Max Chg	Maximum claim charges	Payers Master File
GA B Hlth	Georgia Better Health indicator	Payers Master File
Req Pol Nbr	Policy number required indicator	Payers Master File
Pol Nbr Frmt	Policy format indicator	Payers Master File
Req Grp Nbr	Group number required indicator	Payers Master File
Crt Dt	Create Date The date the record was created.	Insurance Maintenance, Who/When, Modification Information
Created By	Created By The user that created the record.	Insurance Maintenance, Who/When, Modification Information
Mod Dt	Last Modified Date The date the record was last modified.	Insurance Maintenance, Who/When, Modification Information
Modified By	Last Modified By The user that last modified the record.	Insurance Maintenance, Who/When, Modification Information
Enc Rate Lib	Encounter Rate Billing Library	Encounter Rate Billing Library.
Pat Age	Patient Age	Patient Information
Pat Age in Years	Patient Age in Years	Patient Information
Pat Age in Months	Patient Age in Months	Patient 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.
Source of Payment Topology	Source of Payment Topology	Payers Master File > System
Practice Source of Payment Topology	Practice Source of Payment Topology	Payers Master File > Practice
Medicare Replacement	Payer Medicare Replacement Indicator	Payers Master File

Filter 1

Use parameters to filter data on the report:

Policy Effective Date: Include insurances with an effective date within a date range.
Policy Expiration Date: Include insurances with an expiration date within a date range.
Person Create Date: Include persons created within a date range.
Encounter Date: Include encounters within a date range.
Active: Include/exclude active insurances. Select either Only, Exclude, or Include All (default).

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:

Payer Subgrouping 1
Payer Subgrouping 2
Practices
Primary Payers

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'.

Patient Insurance Report Columns

The following columns are available on the Patient Insurance report:

Column Name	Description	Data Populates From
Practice Name	Practice Name	Practice associated with the patient's insurance
Payer Name	Payer Name	Payers Master File
Payer SubGrp 1	Payer Subgrouping 1 Note: Subgrouping name is from Enterprise PreferencesGeneral Tab.	Payers Master File
Payer SubGrp 2	Payer Subgrouping 2 Note: Subgrouping name is from Enterprise PreferencesGeneral Tab.	Payers Master File
Contracted Ind	Contracted Payer Indicator	Payers Master File
Name	Patient Name	Patient Information
Per Nbr	Person Number	Patient Information
Ins Name	Insured Name	Insurance Maintenance
Relation	The name that displays in this column displays the name of the person who responsible for the patient insurance and what the relationship is.	Insurance Maintenance
Enc COB	Encounter Coordination of Benefits	Encounter Maintenance
Addr1	Address 1	Patient Information
Addr2	Address 2	Patient Information
City	City	Patient Information
Country	Country	Patient Information
County	County	Patient Information
Hm Phone	Home Phone	Patient Information
Day Phone	Day Phone	Patient Information
Alt Phone	Alternate Phone	Patient Information
Sec Hm Phone	Secondary Home Phone	Patient Information
Cell Ph	Cell Phone	Patient Information
Sex Code	Sex at Birth Abbreviation (M/F/U)	Patient Information
Birth Dt	Birth Date	Patient Information
Pat Age	Patient Age	Patient Information
Cont	Emergency Contact	Patient Information
Cont Phone	Emergency Contact Name	Patient Information
Contact Fax	Emergency Contact Fax number	Patient Information
Email Addr	Email Address	Patient Information
Lst Enc	Date of the patient last encounter.	Encounter Maintenance
Lst Enc Dt	The last billable date for the encounter.	Encounter Maintenance
Act	Active patient indicator	Patient Information
Avail	Include/Exclude Indicator	Include/Exclude list in System Admin Module
Co Amt	Co-pay Amount	Insurance Maintenance
Ded Amt	Deductible Amount	Insurance Maintenance
Co Type	Co-Pay Type	Insurance Maintenance
Co Perc	Co-Pay Percentage	Insurance Maintenance
Fr Ins Cd	Front of Insurance Card	Patient Information
Bck Ins Cd	Back of Insurance Card	Patient Information
Pol Eff	The date that the insurance policy is in effect.	Insurance Maintenance
Pol Nbr	Insurance policy number Note: If you override the policy number on the Insurance Maintenance window, it displays here instead of the original policy number.	Insurance Maintenance
Pol Exp	Policy Expiration	Insurance Maintenance
Plan #	Insurance plan number	Insurance Maintenance
Not	Notification Indicator	Patient Information
Ver	Verification Indicator	Patient Information
Auth	Authorization Pre-certification indicator	Insurance Maintenance
Group Name	Insurance group name	Insurance Maintenance
Group #	Insurance group number	Insurance Maintenance
MSP	Medicare Secondary Payer Reason	Patient Chart
Medi #	Medi Gap ID number Medicare supplemental plan (better known as “Medi-Gap” plans for picking up the “gaps” in Medicare Parts A, B and C).	Patient Chart
Sig	Sig Events Source description	Patient Information
Orig Payer Name	Original Payer Name	Payers Master File
Med Cv	Medical Coverage Indicator	Patient Information
Dent Cv	Dental Coverage Indicator	Patient Information
Pres Cv	Prescription Coverage Indicator	Patient Information
Eye Cv	Vision Coverage Indicator	Patient Information
Workers Cv	Workman's Compensation Indicator	Patient Information
Def COB	Default Coordination of Benefits	Patient Information
Emp	Employer Name	Patient Information
Def Pay Dt	Default Payer date	Payers Master File
NDex	County Code	Patient Information
Claim Type	Claim Type	Patient Information
Ins Type	Insurance Type	Patient Information
BCBS	Blue Cross Blue Shield Plan Code	Payers Master File
KP	Kenpak Indicator KenPAK is a Kentucky Medicaid Plan.	Payers Master File
Note	Note Indicator	Patient Chart
NEIC/Pyr#	NEIC/Payer number	Payers Master File
Addr1	Payer address line 1	Payers Master File
Addr2	Payer address line 2	Payers Master File
City, State, Zip	Payer city, state, Zip	Payers Master File
Country	Payer country	Payers Master File
County	Payer country	Payers Master File
Payer Email Addr	Payer email address	Payers Master File
National Plan ID	National Plan ID number	Payers Master File
MP	MediPass Indicator	Payers Master File
Edt	No Edit Indicator	Payers Master File
Crs	ERA Crossover Flag indicator	Payers Master File
OPN	Display override policy number indicator	Payers Master File
Hid	Hidden indicator	Payers Master File
Fin Class	Financial Class	Payers Master File
Def Pay Trans	Default payment transaction description	Payers Master File
Def Adj Trans	Default adjustment transaction description	Payers Master File
Sub Lib	Submitter Profile Library indicator	Submitter Profile Library
UB Sub Lib	UB Submitter Profile	Submitter Profile Library
Trans ID	Transaction ID	Payers Master File
UB Trans ID	UB Transaction ID	Payers Master File
Med	Media type description	Payers Master File
Sec Med	Secondary Media Type	Payers Master File
Ter Med	Tertiary Media Type	Payers Master File
Mgd Care Cont	Managed care contract indicator	Payers Master File
Rsn Cd Lib	Reason Code Library	Practice Preferences
Place of Serv	Place of Service	Charge Posting
UB	UB Field 52	Payers Master File
User Defined	User Defined Fields 1-10	Enterprise Practices
Pro	Pro-rate indicator	Payers Master File
Co Resp	Co-pay responsibility	Payers Master File
Form Temp	Form template description	Form Templates Master
CE Lib	Claim Edit Library description	Claim Edit Library
Nt Tmp	Note template indicator	Payers Master File
Nt Tmp Desc	Note template description	Payers Master File
Enc Co	Encounter co-pay required indicator	Encounter Maintenance
Addtl Tran1-6	Transaction descriptions for transaction codes 1-6	Transaction Master
Co Perc	Co-pay percentage indicator	Payers Master File
Clm Sub	Claim Submitter type	Claim Submitter Library
Ref Auth	Referral authorization required	Payers Master File
Ref Frm	Referral indicator	Payers Master File
Lab Fac	Laboratory Facility used indicator	Charge Posting
Rad Fac	Radiology Facility used indicator	Charge Posting
Diag Code	Diagnosis Code indicator	Charge Posting
Accept Asn	Default Accept Assignment indicator	Payers Master File
Def Deduct	Default deductible Amount	Payers Master File
Plan Type	Plan Type	Payers Master File
Max Chg	Maximum claim charges	Payers Master File
GA B Hlth	Georgia Better Health indicator	Payers Master File
Req Pol Nbr	Policy number required indicator	Payers Master File
Pol Nbr Frmt	Policy format indicator	Payers Master File
Req Grp Nbr	Group number required indicator	Payers Master File
Crt Dt	Create Date The date the record was created.	Insurance Maintenance, Who/When, Modification Information
Created By	Created By The user that created the record.	Insurance Maintenance, Who/When, Modification Information
Mod Dt	Last Modified Date The date the record was last modified.	Insurance Maintenance, Who/When, Modification Information
Modified By	Last Modified By The user that last modified the record.	Insurance Maintenance, Who/When, Modification Information
Enc Rate Lib	Encounter Rate Billing Library	Encounter Rate Billing Library.
Pat Age	Patient Age	Patient Information
Pat Age in Years	Patient Age in Years	Patient Information
Pat Age in Months	Patient Age in Months	Patient 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.
Source of Payment Topology	Source of Payment Topology	Payers Master File > System
Practice Source of Payment Topology	Practice Source of Payment Topology	Payers Master File > Practice
Medicare Replacement	Payer Medicare Replacement Indicator	Payers Master File

Filter 1

Use parameters to filter data on the report:

Policy Effective Date: Include insurances with an effective date within a date range.
Policy Expiration Date: Include insurances with an expiration date within a date range.
Person Create Date: Include persons created within a date range.
Encounter Date: Include encounters within a date range.
Active: Include/exclude active insurances. Select either Only, Exclude, or Include All (default).

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:

Payer Subgrouping 1
Payer Subgrouping 2
Practices
Primary Payers

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'.

Patient Insurance Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Recommendations

Policy Holder Report Columns

Payments by Line Item Report Columns

Adjustments by Line Item Report Columns

Aging Analysis by Encounter Report Columns

Adjustments by Transaction Report Columns

Adjustments by Encounter Report Columns

Patient Insurance Report Columns

Filter 1

Filter 2

Additional Filters

Sorting

Totals

Policy Holder Report Columns

Payments by Line Item Report Columns

Adjustments by Line Item Report Columns

Aging Analysis by Encounter Report Columns

Adjustments by Transaction Report Columns

Adjustments by Encounter Report Columns