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
30 | REV_SPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
31 | REV_SUBSPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name