HSP_GUAR_STMT_HX
Description:
This table contains hospital guarantor statement history information.

Primary Key
Column Name Ordinal Position
GUAR_ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 GUAR_ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the guarantor account 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 STMT_HX_HBP_ID NUMERIC No
This column stores the unique identifier for the statement history print record.
4 STMT_FLWUP_LEVEL INTEGER No
This column stores the statement follow-up level.
5 STMT_DATE DATETIME No
The date of the statement or detail bill.
6 STMT_BATCH_DATE DATETIME No
statement batch date
7 STMT_FORM VARCHAR No
The form on which this statement or detail bill was sent.
8 STMT_PROR_PART NUMERIC No
This column stores the proration part amount from the statement.
9 STMT_PREV_BALANCE NUMERIC No
statement previous balance amt
10 STMT_NEW_CHGS NUMERIC No
This column stores the statement new charge amount.
11 STMT_NEW_PMTS NUMERIC No
This column stores the statement new payment amount.
12 STMT_NEW_ADJS NUMERIC No
This column stores the statement new adjustment amount.
13 STMT_AMOUNT_DUE NUMERIC No
statement amount due
14 STMT_TOT_CHGS NUMERIC No
statement total charges
15 STMT_TOT_PMTS NUMERIC No
statement total payments
16 STMT_TOT_ADJS NUMERIC No
statement total adjustments
17 STMT_CUR_BALANCE NUMERIC No
statement current balance
18 STMT_IS_DEMAND_YN VARCHAR No
This column indicates whether the statement is a demand statement.
May contain organization-specific values: No
Category Entries:
Yes
No
19 STMT_PREV_DUE NUMERIC No
Previous statement due amt
20 STMT_PLAN_TOTAL NUMERIC No
This column stores the statement payment plan total amount.
21 STMT_PLAN_BALANCE NUMERIC No
This column stores the statement payment plan balance.
22 STMT_PLAN_MONTH NUMERIC No
This column stores the statement payment plan monthly amount.
23 STMT_PREV_INS_BAL NUMERIC No
This column stores the previous insurance balance for hospital billing statements.
24 STMT_CUR_INS_BAL NUMERIC No
This column stores the hospital billing current insurance balance for hospital billing statements.
25 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
26 STMT_HX_IS_INFO_YN VARCHAR No
Indicates whether the statement was informational for this statement. Y means informational, N means not informational, blank means not informational.
May contain organization-specific values: No
Category Entries:
No
Yes
27 STMT_EB_PRNT_ID NUMERIC No
Stores the link to the statement print (SBP) record.
28 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
29 STMT_FST_VW_DTTM DATETIME (UTC) No
This column stores the date and time when this Hospital Billing statement was first viewed in MyChart by this guarantor. 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.
30 STMT_LST_VW_DTTM DATETIME (UTC) No
This column stores the date and time when this Hospital Billing statement was last viewed in MyChart by this guarantor. 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.
31 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
32 STMT_PRNT_INV_NUM VARCHAR No
This is the invoice number for the statement.
33 INV_NUM_BASE VARCHAR No
This is the base for the invoice number.
34 INV_NUM_SEQ INTEGER No
This is the sequence for the invoice number.
35 INV_NUM_ASGN_DT DATETIME No
This is the date the statement print invoice number was assigned.
36 STMT_HX_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: STMT_HX_IS_INFO_YN
37 HB_STMTHX_CNTST_BAL NUMERIC No
Stores the contested balance on the statement.
38 HB_STMT_HX_TOT_SCH NUMERIC No
The total amount of all scheduled payments on the statement.
39 HB_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.