NextGen Knowledge Center

Contractual Analysis Report Columns

The following columns are available on the Contractual Analysis report:
Column NameDescriptionData Populates From
Prac NamePractice NamePractice associated with the patient's encounter
Loc NameService Location NameEncounter Maintenance
Location SubGrp 1Location Subgrouping 1 Locations Master File
Location SubGrp 2Location Subgrouping 2 Locations Master File
Payer NamePayer NameEncounter Insurance
Payer SubGrp 1Payer Subgrouping 1 Payers Master File
Payer SubGrp 2Payer Subgrouping 2 Payers Master File
Fin ClassFinancial ClassPayers Master File
ContractContractContract Library
Contract ExContract ExceptionContract Library
RenderingRendering ProviderCharge Posting
Provider SubGrp 1Provider Subgrouping 1 Providers Master File
Provider SubGrp 2Provider Subgrouping 2 Providers Master File
ParParticipating Provider IndicatorContract Library
Sv ItService Item NumberCharge Posting
Sv It DescService Item DescriptionCharge Posting
CPT4CPT4 CodeService Items Library
CPT4 DescCPT4 Code DescriptionService Items Library
Mod 1-4Modifier 1 - 4Charge Posting
Diag 1-4Diagnosis Codes 1-4Charge Posting
Diag Desc 1-4Diagnosis Description 1-4Diagnosis Master File
CountCountCharge Posting
Unit PriceUnit PriceCharge Posting
Chg AmtCharge AmountCharge Posting
Pmt PostedPayment PostedPayment Entry
OvrOverride (Y/N)Charge Posting
Act Pay AmtActual Payment AmountPayment Entry
Cont Pay AmountContract Payment AmountContract Library
Diff Adj AmtDifference Adjustment AmountCalculated

[Contract Adj - Actual Adj = Difference Adj]

Act Adj AmtActual Adjustment AmountCharge Posting
Contract Adj AmtContract Adjustment AmountContract Library
Ln Itm AmtLine Item Amount of the chargeCharge Posting
Tran StatusTransaction StatusTransaction Detail
Rsn CdsReason CodesTransaction Detail
E/I
  • Encounter
  • Invoice Number
Transaction Detail
STAbbreviated Source TypeTransaction Detail
Source TypeCharge Type: Encounters and/or InvoicesTransaction Detail
Dt of SvcDate of ServiceCharge Posting
End Dt of SvcEnd Date of ServiceCharge Posting
NamePatient NamePatient Information
Per NbrPerson NumberPatient Information
Birth DtBirth DatePatient Information
Pat AgePatient AgePatient Information
Md RcMedical Record NumberPatient Chart
Addr1Address 1Patient Information
Addr2Address 2Patient Information
CityCityPatient Information
ZipZip CodePatient Information
CountyCountyPatient Information
SexSex at BirthPatient Information
Pat TypePatient TypeEncounter Maintenance
Place of ServPlace of ServiceCharge Posting
FacilityFacilityEncounter Maintenance
AdmittingAdmitting ProviderEncounter Maintenance
Fst ConsultFirst ConsultingEncounter Maintenance
Sec ConsultSecond ConsultingEncounter Maintenance
SupervisorSupervising ProviderEncounter Maintenance
Enc ReferringEncounter Referring ProviderEncounter Maintenance
Chg ReferringCharge Referring ProviderCharge Posting
PADefault column heading labeled as Mid-Level.Practice Preferences
Seq#Sequence Number (#)Charge Posting
Bt InfoBatch InformationBatch Header
DepartmentService Item DepartmentService Items Library
ModalityService Item ModalityService Items Library
ComponentService Item Component:

Global, Professional, Technical

Service Items Library
Rv CdService Item Revenue CodeService Items Library
Aft CareService Item After Care DaysService Items Library
NotesNotesCharge Posting
Ovr Proc DtOverride Process DateCharge Posting
Policy #Policy NumberInsurance Maintenance
Client Def 1 - 14Enterprise Client Defined 1 - 14 Fields Patient Information > Client Defined
Base UnitBase Unit (Anesthesia)Service Items Library
Beg TmBegin TimeCharge Posting
End TmEnd TimeCharge Posting
Tot TmTotal TimeCharge Posting
Anesthesia Alt CodeAnesthesia Alternate CodeCharge Posting
Crt DtCreate DateCharge Posting
Created ByCreated ByCharge Posting
Mod DtModified DateCharge Posting
Modified ByModified ByCharge Posting
Proc DtProcess DateCharge Posting
Cob1 AmtCOB1 AmountBalance Control
Cob2 AmtCOB2 AmountBalance Control
Cob3 AmtCOB3 AmountBalance Control
Pat Age in YearsPatient Age in YearsPatient Information
Pat Age in MonthsPatient Age in MonthsPatient Information
Pat Age in Years (DOS)Patient Age in Years on the Date of ServicePatient Information
Pat Age in Months (DOS)Patient Age in Months on the Date of ServicePatient Information
Diag 1 - 12 CatDiagnosis 1 - 12 CategoryDiagnosis Categories Master File
Diag 1 - 12Diagnosis Code 1 - 12Charge-Level: Codes 1-4

Encounter-Level: Codes 5-12

Diag 1 - 12 DescDiagnosis 1 - 12 DescriptionDiagnosis Codes Library
Diag 1 - 12 Risk IndDiagnosis 1 - 12 Risk IndicatorICDCM Codes Master File
Diag 1 - 12 EOCDiag 1 - 12 Episode of CareICDCM Codes Master File
Diag 1 - 12 Sub1 Grp 1Diagnosis 1 - 12 Sub Grouping 1Diagnosis Codes Library
Diag 1 - 12 Sub2 Grp 2Diagnosis 1 - 12 Sub Grouping 2Diagnosis Codes Library
Diag 1 - 12 TypeDiagnosis 1 - 12 TypeICDCM Codes Master File
RVU 1Relative Value Unit 1Service Items Library
RVU Total 1Relative Value Unit Total 1Service Items Library
RVU 2Relative Value Unit 2Service Items Library
RVU Total 2Relative Value Unit Total 2Service Items Library
RVU 3Relative Value Unit 3Service Items Library
RVU Total 3Relative Value Unit Total 3Service Items Library
RVU 4Relative Value Unit 4Service Items Library
RVU Total 4Relative Value Unit Total 4Service Items Library
RVU 5Relative Value Unit 5Service Items Library
RVU Total 5Relative Value Unit Total 5Service Items Library
RVU 6Relative Value Unit 6Service Items Library
RVU Total 6Relative Value Unit Total 6Service Items Library
RVU 7Relative Value Unit 7Service Items Library
RVU Total 7Relative Value Unit Total 7Service Items Library
RVU 8Relative Value Unit 8Service Items Library
RVU Total 8Relative Value Unit Total 8Service Items Library
Homeless StatusHomeless StatusPatient Information > UDS
Migrant Worker StatusMigrant Worker StatusPatient Information > UDS
Language BarrierLanguage BarrierPatient Information > UDS
Prim Dental Prov NamePrimary Dental Provider NamePatient Information
Prim Enc Rate SIMPrimary Encounter Rate Service ItemEncounter Maintenance
Prim Enc Rate AmtPrimary Encounter Rate AmountEncounter Maintenance
Sec Enc Rate SIMSecondary Encounter Rate Service ItemEncounter Maintenance
Sec Enc Rate AmtSecondary Encounter Rate AmountEncounter Maintenance
Ter Enc Rate SIMTertiary Encounter Rate Service ItemEncounter Maintenance
Ter Enc Rate AmtTertiary Encounter Rate AmountEncounter Maintenance
RaceRacePatient Information
Race CategoryRace CategoryRace Category Mapping Master File
EthnicityEthnicityPatient Information
Ethnicity CategoryEthnicity CategoryEthnicity Category Mapping Master File
Tribal AffiliationTribal AffiliationPatient Information > UDS
Blood QuantumBlood QuantumPatient Information > UDS
Veteran StatusVeteran StatusPatient Information
School Based Hlth CareSchool Based Health CarePatient Information > UDS
Public Housing PrimaryPublic Housing Primary CarePatient Information > UDS
DescendancyDescendancyPatient Information > UDS
IHS Eligibility StatusIHS Eligibility StatusPatient Information > UDS
Classification BeneficiaryClassification BeneficiaryPatient Information > UDS
Community CodeCommunity CodePatient Information
Consent to Treat IndConsent to Treat IndicatorPatient Information > UDS
Consent to Treat DateConsent to Treat DatePatient Information > UDS
Enc Homeless StatusEncounter Homeless StatusEncounter Maintenance
CPT EOCCPT Episode of CareCPT4 Codes Master File
APG CodeAPG Code 
Rate CodeAPG Rate Code 
Pmt %APG Payment Percentage 
WeightAPG Weight 
Add-OnAPG Add-On Amount 
Expected Reimb AmtAPG Expected Reimbursement Amount 
MessageAPG Message 
APG DateAPG Response Date 
APG Diff Pay AmtAPG 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

Totals

Use columns to sub-total and total data on the report. Column total options include the following:
  • Sum
  • Average
  • Count
  • Totals
Contractual Analysis Report Columns