ARPB_VISITS
Description:
This table contains Professional Billing visit information stored in the Hospital Accounts Receivable (HAR) master file. It only includes PB HAR records created in classic PB self-pay service areas.

Primary Key
Column Name Ordinal Position
PB_VISIT_ID 1

Column Information
Name Type Discontinued?
1 PB_VISIT_ID NUMERIC No
The unique identifier for the Professional Billing visit.
2 PB_BILLING_STATUS_C_NAME VARCHAR No
This column stores the Professional Billing status category ID for the visit.
May contain organization-specific values: No
Category Entries:
Open
Billed
Voided
Closed
3 PB_FO_OVRRD_ST_C_NAME VARCHAR No
This column indicates whether the Professional Billing filing order has been overridden by a user.
May contain organization-specific values: No
Category Entries:
Matches the default
Overridden by user
Not matching default after rejection
4 PB_FO_MSPQ_STATE_C_NAME VARCHAR No
This column indicates whether the filing order for the Professional Billing visit has been verified by Medicare Secondary Payer Questionnaire logic.
May contain organization-specific values: No
Category Entries:
MSPQ does not apply
Validated by MSPQ responses
Overridden by user
5 PB_VISIT_NUM VARCHAR No
This column stores the PB visit number.
6 PRIM_ENC_CSN_ID NUMERIC No
The contact serial number associated with the primary patient contact on the Professional Billing visit.
7 GUARANTOR_ID NUMERIC No
Stores the guarantor ID associated with the Professional Billing visit.
8 COVERAGE_ID NUMERIC No
The primary coverage on the Professional Billing visit.
9 SELF_PAY_YN VARCHAR No
Indicates whether the Professional Billing visit is self-pay.
May contain organization-specific values: No
Category Entries:
No
Yes
10 DO_NOT_BILL_INS_YN VARCHAR No
Indicates whether the Professional Billing visit has the Do Not Bill Insurance flag set.
The category values for this column were already listed for column: SELF_PAY_YN
11 ACCT_FIN_CLASS_C_NAME VARCHAR No
The financial class category ID for the Professional Billing visit.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
12 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
13 REVENUE_LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
14 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
15 PB_TOTAL_BALANCE NUMERIC No
Contains the combined total balance of transactions on the PB visit.
16 PB_TOTAL_CHARGES NUMERIC No
The total charges on the PB visit.
17 PB_TOTAL_PAYMENTS NUMERIC No
The total payments on the PB visit.
18 PB_TOTAL_ADJ NUMERIC No
Contains total adjustments on the PB visit.
19 PB_INS_BALANCE NUMERIC No
Contains insurance balance on the PB visit.
20 PB_UND_BALANCE NUMERIC No
Contains undistributed balances on the PB visit.
21 PB_SELFPAY_BALANCE NUMERIC No
Contains the self-pay balance on the Professional Billing visit.
22 PB_BAD_DEBT_BALANCE NUMERIC No
Contains the bad debt balance on the Professional Billing visit.
23 REC_CREATE_USER_ID VARCHAR No
The user who created the Professional Billing visit record.
24 REC_CREATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
25 FIRST_PB_CHG_TX_ID NUMERIC No
Contains the first valid Professional Billing charge on the Professional Billing visit.
26 BAL_FULL_SELF_PAY_YN VARCHAR No
This item shows whether the balances for this hospital account are in full self-pay.
The category values for this column were already listed for column: SELF_PAY_YN
27 PRIMARY_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
28 PRIMARY_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
29 CHANGE_EAR_FLAG_YN_NAME VARCHAR No
Indicates whether the HAR’s coverage list originated from a source guarantor as a result of change guarantor. When set, retro processes will bypass the HAR.
The category values for this column were already listed for column: SELF_PAY_YN