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.