ProfessionalBillingVisits

This table contains Professional Billing visit information stored in the Hospital Accounts Receivable (HAR) master file. It doesn’t include HAR records created for Hospital Billing and Single Billing Office.

Column Name	Type	Description
ProfessionalBillingVisitPatientIdentification	VARCHAR	Stores the patient associated with the PB visit.
ProfessionalBillingVisitSelfPayBalance	NUMERIC	Contains the self-pay balance on the Professional Billing visit.
SelfPayResponsibilityAfterDiscount	NUMERIC	The self-pay responsibility after any self-pay or financial assistance discounts are posted on the self-pay bucket.
ProfessionalBillingRevenueLocationIdentifier	NUMERIC	The revenue location of the Professional Billing visit.
FirstDayOfServicePrimaryPayerIdentifier	NUMERIC	The visit account's primary payer at the end of the first day of service. The first day of service is the minimum charge service date.
IsPlaceholderExpectedVisitAccount	VARCHAR	Stores a flag indicating whether the HAR was created as a placeholder expected visit account.
FirstBillingDayPrimaryCoverageIdentifier	NUMERIC	The visit account's primary coverage at the end of the first day of billing. The first day of billing for an account is the first insurance claim accept date, the start date of the first self-pay follow-up cycle or the first full self-pay statement date.
IsSelfPayVisit	VARCHAR	Indicates whether the Professional Billing visit is self-pay.
PrimaryPayerAtBillingCommencement	NUMERIC	The visit account's primary payer at the end of the first day of billing. The first day of billing for an account is the first insurance claim accept date, the start date of the first self-pay follow-up cycle or the first full self-pay statement date.
ZeroBalancePrimaryPlanIdentifier	NUMERIC	The visit account's primary plan at the end of the first day the account's active AR balance reaches zero. The first day an account's active AR balance reaches zero is the first date the account balance is sent to collections or the first date the account's balance reaches zero.
PrimaryCoverageAtZeroAccountReceivableBalance	NUMERIC	The visit account's primary coverage at the end of the first day the account's active AR balance reaches zero. The first day an account's active AR balance reaches zero is the first date the account balance is sent to collections or the first date the account's balance reaches zero.
FirstProfessionalBillingChargeTransactionIdentifier	NUMERIC	Contains the first valid Professional Billing charge on the Professional Billing visit.
ProfessionalBillingStatusCategoryIdentifier	INTEGER	This column stores the Professional Billing status category ID for the visit.
ProfessionalBillingFinancialClassCategoryIdentifier	VARCHAR	The financial class category ID for the Professional Billing visit.
SelfPayBalanceAfterInsurance	NUMERIC	The balance transferred to self-pay after insurance is taken into account. This does not include any self-pay discount, financial assistance, or pre-payments.
FirstAcceptedClaimSubmissionDate	DATETIME	The first date an insurance claim was sent, that is accepted, for this visit account.
ProfessionalBillingPrimaryCoverageIdentification	NUMERIC	The primary coverage on the Professional Billing visit.
PostedNotBilledRuleType	INTEGER	This item stores Posted Not Billed rule type for the account. If there are multiple rules for the charges, this item will store the error type if available, otherwise it'll be warning type. This item will also be indicator that account has charge in Posted Not Billed status.
ProfessionalBillingVisitServiceAreaIdentification	NUMERIC	The service area of the Professional Billing visit.
DoNotBillInsuranceIndicator	VARCHAR	Indicates whether the Professional Billing visit has the Do Not Bill Insurance flag set.
ProfessionalBillingUndistributedBalance	NUMERIC	Contains undistributed balances on the PB visit.
ProfessionalBillingFilingOrderOverrideState	INTEGER	This column indicates whether the Professional Billing filing order has been overridden by a user.
ProfessionalBillingVisitSplitKey	VARCHAR	This item will store a unique string that will indicate the HAR should not be reused for other charges, unless that unique string is passed in.
ProfessionalBillingSplitReferenceDate	DATETIME	Records the beginning service date of the date range used to split PB HARs. Calculated based on the inpatient stay's admission date.
HospitalAccountRecordType	INTEGER	Stores the HAR record type for a PB visit.
PrimaryEncounterContactSerialNumber	NUMERIC	The contact serial number associated with the primary patient contact on the Professional Billing visit.
ProfessionalBillingInsuranceBalanceAmount	NUMERIC	Contains insurance balance on the PB visit.
ConfidentialPatientRealName	VARCHAR	Some patients don't wish to be known by their real name and will be known by a pseudonym instead. This column will always hold the real name and HAR .2 will have the pseudonym. This item can only be accessed by users with appropriate Shared security.
LastZeroBalancePayerIdentifier	NUMERIC	The visit account's primary payer at the end of the first day the account's active AR balance reaches zero. The first day an account's active AR balance reaches zero is the first date the account balance is sent to collections or the first date the account's balance reaches zero.
FirstDayOfServicePrimaryPlanIdentifier	NUMERIC	The visit account's primary plan at the end of the first day of service. The first day of service is the minimum charge service date.
VisitParentLocationIdentification	NUMERIC	The location stored in the visit account. Location is only stored in visit accounts if you are assigning hospital account IDs by location instead of service area.
ProfessionalBillingTotalPayments	NUMERIC	The total payments on the PB visit.
FirstDayOfServicePrimaryCoverageIdentifier	NUMERIC	The visit account's primary coverage at the end of the first day of service. The first day of service is the minimum charge service date.
ProfessionalBillingVisitRecordCreationUserIdentifier	VARCHAR	The user who created the Professional Billing visit record.
ProfessionalBillingVisitIdentifier	NUMERIC	The unique identifier for the Professional Billing visit.
PatientNameOnHospitalAccount	VARCHAR	The name of the patient associated with the hospital account.
FirstDayOfServiceFinancialClass	VARCHAR	The visit account's financial class at the end of the first day of service. The first day of service is the minimum charge service date.
ProfessionalBillingVisitTotalCharges	NUMERIC	The total charges on the PB visit.
BillingPrimaryBenefitPlanIdentifier	NUMERIC	The visit account's primary plan at the end of the first day of billing. The first day of billing for an account is the first insurance claim accept date, the start date of the first self-pay follow-up cycle or the first full self-pay statement date.
LastBillingFinancialClass	VARCHAR	The visit account's financial class at the end of the first day of billing. The first day of billing for an account is the first insurance claim accept date, the start date of the first self-pay follow-up cycle or the first full self-pay statement date.
IsFullSelfPayBalanceIndicator	VARCHAR	This item shows whether the balances for this hospital account are in full self-pay.
LastCharge	DATETIME	Stores the most recent charge service date on the PB visit.
IntraconnectCommunityInstanceOwnerIdentifier	VARCHAR	The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
RecordSourceCommunityIdentifier	VARCHAR	The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
SpecialVisit	INTEGER	Indicates the special visit type that should prevent transactions that match its type from the HAR.
ProfessionalBillingVisitCreationDate	DATETIME	Record creation date for the PB visit.
AtZeroAccountsReceivableFinancialClass	VARCHAR	The visit account's financial class at the end of the first day the account's active AR balance reaches zero. The first day an account's active AR balance reaches zero is the first date the account balance is sent to collections or the first date the account's balance reaches zero.
ProfessionalBillingEarliestChargeServiceDate	DATETIME	Stores the earliest charge service date on the PB visit.
ProfessionalBillingVisitTotalAdjustments	NUMERIC	Contains total adjustments on the PB visit.