STMT_HB_DETAIL
Description:
This table contains Hospital Billing information about your statement print and detail bill records.

Primary Key
Column Name Ordinal Position
PRINT_ID 1

Column Information
Name Type Discontinued?
1 PRINT_ID NUMERIC No
The unique identifier (.1 item) for the statement print or detail bill record.
2 PREV_PAT_BAL NUMERIC No
The Hospital Billing outstanding self-pay balance for the guarantor from the previous statement.
3 PREV_AMT_DUE NUMERIC No
The Hospital Billing amount due for the guarantor from the previous statement. It only includes outstanding self-pay balances not on a payment plan.
4 NEW_CHG_AMT NUMERIC No
The Hospital Billing new charge amount.
5 NEW_PMT_AMT NUMERIC No
The Hospital Billing new payment amount.
6 NEW_ADJ_AMT NUMERIC No
The Hospital Billing new adjustment amount.
7 TOT_CHG_AMT NUMERIC No
The Hospital Billing total charge amount.
8 TOT_PMT_AMT NUMERIC No
The Hospital Billing total payment amount.
9 TOT_ADJ_AMT NUMERIC No
The Hospital Billing total adjustment amount.
10 CURR_PAT_BAL NUMERIC No
The Hospital Billing outstanding self-pay balance for the guarantor.
11 CURR_AMT_DUE NUMERIC No
The Hospital Billing amount due for the guarantor. It only includes outstanding self-pay balances not on a payment plan.
12 PMT_PLAN_TOT NUMERIC No
The Hospital Billing payment plan total amount.
13 PMT_PLAN_BAL NUMERIC No
The Hospital Billing payment plan balance.
14 PMT_PLAN_DUE NUMERIC No
The Hospital Billing payment plan due amount.
15 INS_PORTION_AMT NUMERIC No
The Hospital Billing insurance portion amount.
16 PAT_PORTION_AMT NUMERIC No
The Hospital Billing patient portion amount.
17 FOLLOW_UP_CYCLE_AGING_DATE DATETIME No
The Hospital Billing follow-up cycle aging date.
18 IS_INFORMATIONAL_YN VARCHAR No
Indicates whether or not this is informational (meaning the amount due is zero).
May contain organization-specific values: No
Category Entries:
No
Yes
19 PREV_INS_BAL NUMERIC No
The Hospital Billing previous insurance balance.
20 NEW_INS_CHG_AMT NUMERIC No
The Hospital Billing new insurance charge amount.
21 NEW_INS_PMT_AMT NUMERIC No
The Hospital Billing new insurance payment amount.
22 NEW_INS_ADJ_AMT NUMERIC No
The Hospital Billing new insurance adjustment amount.
23 CURR_INS_BAL NUMERIC No
The Hospital Billing current insurance balance.
24 NEW_PAT_CHG_AMT NUMERIC No
The Hospital Billing new patient charge amount.
25 NEW_PAT_PMT_AMT NUMERIC No
The Hospital Billing new patient payment amount.
26 NEW_PAT_ADJ_AMT NUMERIC No
The Hospital Billing new patient adjustment amount.
27 PMT_PLAN_MONTH_AMT NUMERIC No
The Hospital Billing payment plan monthly amount.
28 AUTOPAY_CARD_ID NUMERIC No
The payment method that is used for the guarantor's Auto Pay.
29 AUTOPAY_DATE DATETIME No
Date to charge the payment method for this specific statement if its guarantor is on Auto Pay.
30 AUTOPAY_AMT_DUE NUMERIC No
The amount to be charged to the payment method for this specific statement if its guarantor is on Auto Pay.
31 NEW_PAT_DISC_ADJ NUMERIC No
Stores the new HB patient discount amount that occurred since the last statement.
32 TOT_PAT_DISC_ADJ NUMERIC No
Stores the total HB patient discount amount on the current statement.
33 NEW_PAT_REF NUMERIC No
Stores the new HB patient refund amount that occurred since the last statement.
34 TOT_PAT_REF NUMERIC No
Stores the total HB patient refund amount on the current statement.
35 NEW_PAT_OTH_ADJ NUMERIC No
Stores the new HB patient other adjustment amount that occurred since the last statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
36 TOT_PAT_OTH_ADJ NUMERIC No
Stores the total HB patient other adjustment amount on the current statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.