ACCT_EB_STMT_HIST
Description:
This table contains enterprise statement history information.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the guarantor record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ACCEPT_DT DATETIME No
Enterprise statement acceptance date.
4 END_BATCH_DT DATETIME No
End batch date for the enterprise statement.
5 PRINT_RECORD_ID NUMERIC No
This column stores the unique identifier for the Statement Print record.
6 IS_DEMAND_STMT_YN VARCHAR No
Whether the statement was a demand statement.
May contain organization-specific values: No
Category Entries:
No
Yes
7 FOLLOW_UP_CYC_LVL NUMERIC No
Enterprise guarantor follow up cycle level. This is used for looking up follow up cycle level message to be printed on statement.
8 PREV_BALANCE_AMT NUMERIC No
Previous non-demand statement balance.
9 PREV_DUE_AMT NUMERIC No
Previous non-demand statement amount due.
10 NEW_CHARGES_AMT NUMERIC No
New charges since last non-demand statement.
11 NEW_PAYMENTS_AMT NUMERIC No
New payments since last non-demand statement.
12 NEW_ADJS_AMT NUMERIC No
New adjustments since last non-demand statement.
13 TOTAL_CHARGES_AMT NUMERIC No
Total charges amount on the statement.
14 TOTAL_PAYMENTS_AMT NUMERIC No
Total payments amount on the statement.
15 TOTAL_ADJS_AMT NUMERIC No
Total adjustments amount on the statement.
16 CUR_BALANCE_AMT NUMERIC No
Current statement balance.
17 CUR_DUE_AMT NUMERIC No
Current statement amount due
18 PROC_PROF_YN VARCHAR No
Whether this statement contains balance from billing system Professional Billing. This will be YES if billing system Professional Billing is using enterprise statement in the guarantor's service area.
The category values for this column were already listed for column: IS_DEMAND_STMT_YN
19 PROC_HOSP_YN VARCHAR No
Whether this statement contains balance from billing system Hospital Billing. This will be YES if billing system Hospital Billing is using enterprise statement in the guarantor's service area.
The category values for this column were already listed for column: IS_DEMAND_STMT_YN
20 INVOICE_NUMBER VARCHAR No
Invoice number for the statement.
21 HB_PREV_BAL_AMT NUMERIC No
Hospital portion of the previous statement amount due.
22 HB_PREV_DUE_AMT NUMERIC No
This column stores the hospital portion of the previous statement amount due.
23 HB_NEW_CHARGES_AMT NUMERIC No
Hospital portion of the new charges.
24 HB_NEW_PAYMENT_AMT NUMERIC No
Hospital portion of the new payments.
25 HB_NEW_ADJS_AMT NUMERIC No
Hospital portion of the new adjustments.
26 HB_TOT_CHARGES_AMT NUMERIC No
Hospital portion of the total charges.
27 HB_TOT_PAYMENT_AMT NUMERIC No
Hospital portion of the total payments.
28 HB_TOT_ADJS_AMT NUMERIC No
Hospital portion of the total adjustments.
29 HB_CUR_BALANCE_AMT NUMERIC No
Hospital portion of the current balance.
30 HB_CUR_DUE_AMT NUMERIC No
Hospital portion of the current amount due.
31 HB_PMTPLAN_TOT_AMT NUMERIC No
Hospital billing payment plan original balance.
32 HB_PMTPLAN_BAL_AMT NUMERIC No
Hospital billing payment plan current balance.
33 HB_PMTPLAN_DUE_AMT NUMERIC No
Hospital billing payment plan current amount due.
34 HB_PRORATION_AMT NUMERIC No
This is the prorated self-pay balance contributed to the hospital portion of current balance.
35 PREV_INS_BAL NUMERIC No
This column stores the previous insurance balance that was shown on the statement.
36 CUR_INS_BAL NUMERIC No
This column stores the current insurance balance from the statement.
37 IS_INFO_STMT_YN VARCHAR No
Indicates whether the statement is informational. This item is "1" if the statement was informational, and "0" or " if not. A statement is informational if no self-pay balance was due for the guarantor.
The category values for this column were already listed for column: IS_DEMAND_STMT_YN
38 PB_PREV_INS_BAL NUMERIC No
This column stores the previous insurance balance for professional billing.
39 PB_CUR_INS_BAL NUMERIC No
This column stores the current insurance balance for professional billing.
40 HB_PREV_INS_BAL NUMERIC No
This column stores the previous insurance balance for hospital billing.
41 HB_CUR_INS_BAL NUMERIC No
This column stores the current insurance balance for hospital billing.
42 STMT_SP_LEVEL_C_NAME VARCHAR No
The guarantor self-pay follow-up level for the statement.
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
43 STMT_DVRY_MTD_C_NAME VARCHAR No
Stores how the statement was delivered.
May contain organization-specific values: No
Category Entries:
Paper, No Electronic Notification
Paperless, No Electronic Notification
Paper and Electronic Notification
Paperless, Electronic Notification
44 STMT_FST_VW_DTTM DATETIME (UTC) No
This column stores the instant the statement was first viewed in MyChart. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
45 STMT_LST_VW_DTTM DATETIME (UTC) No
This column stores the instant the statement was last viewed in MyChart. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
46 STMT_PAPER_RSN_C_NAME VARCHAR No
Stores the reason why the statement was sent via paper.
May contain organization-specific values: No
Category Entries:
Paperless Billing is disabled for the service area
User specified
Forced to paper because of self-pay follow-up level
Forced to paper because of guarantor rule
Forced to paper because of hospital account rule
Guarantor declined paperless billing
Financial Assistance Program Not Allowed In MyChart
Not self-pay correspondence
Form is not allowed to be displayed in MyChart
Guarantor missing associated patient or MyChart account
Guarantor is not MyChart active
Guarantor is not available in MyChart
No access to billing features in MyChart
MyChart tickler could not be sent
Professional billing letter not marked as Sent
Patient is not active on MyChart
Queued for printing based on estimate rule
Patient is deceased
47 EB_PMT_PLAN_TOT_AMT NUMERIC No
Enterprise payment plan total. This is the total amount this payment was created to capture.
48 EB_PMT_PLAN_BAL_AMT NUMERIC No
Enterprise payment plan balance. This is how much remains to be paid for this payment plan.
49 EB_PMT_PLAN_DUE_AMT NUMERIC No
Enterprise payment plan due. This is how much was due for the next payment under this plan for each line in the history.
50 PB_HELD_AMT NUMERIC No
Professional billing held amount. This is the amount that is held from the patient statement due to some or all of the charges being with insurance at the time the statement is sent.
51 PB_VOID_TRANS_AMT NUMERIC No
Professional billing void/transfer amount. This is the amount of the balance that was voided or transferred since the previous statement.
52 STMT_HIST_IS_MYC_NOTIF_YN VARCHAR No
Stores if the statement/detail bill notification was sent via MyChart.
The category values for this column were already listed for column: IS_DEMAND_STMT_YN
53 STMT_HX_CNTST_BAL NUMERIC No
Stores the contested balance on the statement.
54 STMT_HX_TOT_SCH_PMT NUMERIC No
The total amount of all scheduled payments on the statement.
55 STMT_HX_PAY_NOW NUMERIC No
The pay now amount on the statement. This is the amount due subtracted by the total scheduled payment amount.
56 PB_CUR_DUE_AMT NUMERIC No
The professional portion of the current statement amount due.
57 PB_CUR_BALANCE_AMT NUMERIC No
The professional portion of the current statement balance.
58 PB_NEW_ADJS_AMT NUMERIC No
The total new professional adjustment amount posted since last statement.
59 PB_NEW_CHARGES_AMT NUMERIC No
The total new professional charge amount posted since last statement.
60 PB_NEW_PAYMENT_AMT NUMERIC No
The total new professional payment amount posted since last statement.
61 PB_PMTPLAN_BAL_AMT NUMERIC No
The professional payment plan balance.
62 PB_PMTPLAN_DUE_AMT NUMERIC No
The professional payment plan amount due.
63 PB_PMTPLAN_TOT_AMT NUMERIC No
The professional payment plan total amount.
64 PB_PREV_DUE_AMT NUMERIC No
The previous professional portion statement amount due.
65 PB_TOT_ADJS_AMT NUMERIC No
The total professional adjustment amount.
66 PB_TOT_CHARGES_AMT NUMERIC No
The total professional charge amount.
67 PB_TOT_PAYMENT_AMT NUMERIC No
The total professional payment amount.