GUAR_ACCT_STMT_HX
Description:
This table contains statement history information for the guarantor account.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
The unique identifier for the 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_STMT_DATE DATETIME No
The date on which statement was generated.
4 STMT_HX_INVOICE_NUM VARCHAR No
The invoice number of the invoice that was sent to the guarantor on this date.
5 STMT_HX_NEW_CHARGE NUMERIC No
The original amount of all new charges on this invoice. New charges are those that were not on the last invoice sent.
6 STMT_HX_NEW_BALANCE NUMERIC No
The new balance on the statement.
7 STMT_HX_TTL_PMT NUMERIC No
Total payment amount on the statement.
8 STMT_HX_TTL_DB_ADJ NUMERIC No
Total debit adjustment amount on the statement.
9 STMT_HX_TTL_CR_ADJ NUMERIC No
Total credit adjustment amount on the statement.
10 STMT_HX_TTL_AMT_HLD NUMERIC No
Total amount held on the statement.
11 STMT_HX_TTL_AMT_VD NUMERIC No
Total amount voided since last statement.
12 STMT_HX_DVRY_MTHD_C_NAME VARCHAR No
The statement delivery method category ID for the guarantor.
May contain organization-specific values: No
Category Entries:
Paper, No Electronic Notification
Paperless, No Electronic Notification
Paper and Electronic Notification
Paperless, Electronic Notification
13 STMT_HX_LST_VW_DTTM DATETIME (UTC) No
Last date/time when the statement was most recently access from MyChart.
14 STMT_HX_1ST_VW_DTTM DATETIME (UTC) No
The date/time when the statement was first accessed from MyChart.
15 STMT_HX_WHY_2_PR_C_NAME VARCHAR No
Reason type why the paperless statement is forced to paper statement.
May contain organization-specific values: No
Category Entries:
Paperless statement disabled
Guarantor type not included
Guarantor excluded by rule
Lack of payments
Statement not shown in MyChart