STMT_EB_DETAIL
Description:
This table contains Enterprise 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 enterprise billing outstanding self-pay balance for the guarantor from the previous statement.
3 PREV_AMT_DUE NUMERIC No
The enterprise billing amount due for the guarantor from the previous statement. It is a combination of the payment plan amount due plus any outstanding balances not on a payment plan.
4 NEW_CHG_AMT NUMERIC No
The enterprise billing new charge amount.
5 NEW_PMT_AMT NUMERIC No
The enterprise billing new payment amount.
6 NEW_ADJ_AMT NUMERIC No
The enterprise billing new adjustment amount.
7 TOT_CHG_AMT NUMERIC No
The enterprise billing total charge amount.
8 TOT_PMT_AMT NUMERIC No
The enterprise billing total payment amount.
9 TOT_ADJ_AMT NUMERIC No
The enterprise billing total adjustment amount.
10 CURR_PAT_BAL NUMERIC No
The enterprise billing outstanding self-pay balance for the guarantor.
11 CURR_AMT_DUE NUMERIC No
The enterprise billing amount due for the guarantor. It is a combination of the payment plan amount due plus any outstanding balances not on a payment plan.
12 FOLLOW_UP_CYCLE_LEVEL INTEGER No
The enterprise billing follow-up cycle level for this statement.
13 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
14 PREV_INS_BAL NUMERIC No
The enterprise billing previous insurance balance.
15 NEW_INS_CHGS NUMERIC No
The enterprise billing new insurance charge amount.
16 NEW_INS_PMTS NUMERIC No
The enterprise billing new insurance payment amount.
17 NEW_INS_ADJS NUMERIC No
The enterprise billing new insurance adjustment amount.
18 CURR_INS_BAL NUMERIC No
The enterprise billing current insurance balance.
19 NEW_PAT_CHGS NUMERIC No
The enterprise billing new patient charge amount.
20 NEW_PAT_PMTS NUMERIC No
The enterprise billing new patient payment amount.
21 NEW_PAT_ADJS NUMERIC No
The enterprise billing new patient adjustment amount.
22 PMT_PLAN_TOT NUMERIC No
Total amount of payment plan.
23 PMT_PLAN_BAL NUMERIC No
Total amount of enterprise payment plan balance.
24 PMT_PLAN_DUE NUMERIC No
Amount due per period of the payment plan.
25 SP_FOLLOW_UP_LEVEL_C_NAME VARCHAR No
The guarantor self-pay follow-up level.
May contain organization-specific values: No
Category Entries:
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
Level 7
Level 8
Level 9
Level 10
26 PMT_PLAN_MONTH_AMT NUMERIC No
The monthly amount of enterprise payment plan.
27 TOT_PAT_PMT_AMT NUMERIC No
The total patient payments for a guarantor.
28 TOT_PAT_ADJ_AMT NUMERIC No
The total patient adjustments for a guarantor.
29 TOT_INS_PMT_ADJ NUMERIC No
The total insurance payments for a guarantor.
30 TOT_INS_ADJ_AMT NUMERIC No
The total insurance adjustments for a guarantor.
31 PMT_PLAN_OVERDUE_AMT NUMERIC No
The overdue amount on the payment plan.
32 AUTOPAY_CARD_ID NUMERIC No
The payment method that is used for guarantor's Auto Pay.
33 AUTOPAY_DATE DATETIME No
Date to charge the payment method for this specific statement if its guarantor is on Auto Pay.
34 AUTOPAY_NXT_PMT_AMT NUMERIC No
The amount that the system calculates as the next payment amount. This amount is based on the current scheduled payment plus the next monthly due amount. It also takes into account the system definition settings regarding whether auto pay should collect overdue amounts or be reduced by other patient payments. This amount will be charged to the payment method for this specific statement if its guarantor is on Auto Pay.
35 PMT_PLAN_PAID_AHEAD_AMT NUMERIC No
The paid ahead amount on the payment plan.
36 TOT_CONTESTED_BAL NUMERIC No
The total contested balance for the guarantor.
37 PROP_PMT_PLAN_MONTH_AMT NUMERIC No
If the guarantor can sign up for a payment plan, then this is the proposed monthly amount that will be shown if they were to sign up in MyChart.
38 PROP_PMT_PLAN_NUM_PMTS INTEGER No
If the guarantor can sign up for a payment plan, then this is the proposed number of payments that will be shown if they were to sign up in MyChart.
39 TOT_SCHED_PMTS NUMERIC No
The total scheduled payments on the statement.
40 PAY_NOW_AMT NUMERIC No
The amount the patient should pay now. This is calculated by subtracting scheduled payments from the statement due amount.
41 PMT_PLAN_LN INTEGER No
The payment plan line on the guarantor. This gives additional details about the payment plan.
42 IS_AUTOPAY_SUSPENDED_YN VARCHAR No
Indicates whether or not the Auto Pay is currently suspended for the payment plan.
The category values for this column were already listed for column: IS_INFORMATIONAL_YN
43 AUTOPAY_DECLINE_DATE DATETIME No
The date Auto Pay was suspended because of a declined payment.
44 STMT_DUE_DATE DATETIME No
The due date of the statement.
45 PMT_PLAN_TRACKER_SCHED_PMT_ID NUMERIC No
The unique ID of the payment plan expected payment tracker record when the statement was generated.
46 PMT_PLAN_DEFER_MONTHS INTEGER No
The number of months that the payment plan was deferred when the statement was generated.
47 PMT_PLAN_HARS_BAL_NOT_ON_PLAN NUMERIC No
The total balance not on a payment plan for the hospital accounts that are on the payment plan that generated this statement.
48 PMT_PLAN_INITIAL_EST_BAL NUMERIC No
The initial balance of all the pre-service estimates on the payment plan that generated this statement.
49 PMT_PLAN_REMAINING_EST_BAL NUMERIC No
The remaining balance of all the pre-service estimates on the payment plan that generated this statement.
50 PMT_PLAN_PMT_NOT_APPLY_AMT NUMERIC No
Total of payment plan payments not yet applied to charges.
51 NEW_PAT_DISC_ADJ NUMERIC No
Stores the new patient discount amount that occurred since the last statement.
52 TOT_PAT_DISC_ADJ NUMERIC No
Stores the total patient discount amount on the current statement.
53 NEW_PAT_REF NUMERIC No
Stores the new patient refund amount that occurred since the last statement.
54 TOT_PAT_REF NUMERIC No
Stores the total patient refund amount on the current statement.
55 NEW_PAT_OTH_ADJ NUMERIC No
Stores the new patient other adjustment amount that occurred since the last statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
56 TOTAL_PAT_OTH_ADJ NUMERIC No
Stores the total patient other adjustment amount on the current statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.