ARPB_VISITS
Description:
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.

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.