STMT_PRINT
Description:
The STMT_PRINT table contains 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 GUAR_ACCT_ID NUMERIC No
This column stores the unique identifier for the guarantor account that received this statement print or detail bill.
3 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
4 INVOICE_NUMBER VARCHAR No
The master invoice number for a statement print or detail bill.
5 INV_NUM_ASGN_DT DATETIME No
The date on which the invoice number was generated.
6 IS_DEMAND_STMT_YN VARCHAR No
Whether this is a demand statement.
May contain organization-specific values: No
Category Entries:
No
Yes
7 STMT_END_BATCH_DATE DATETIME No
End system batch date for the statement. Only transactions posted on or before this date can be included on the statement.
8 STMT_PROC_DATE DATETIME No
The date statement data was populated into this print record.
9 BILL_HOME_PHONE VARCHAR No
Home phone of the guarantor.
10 BILL_WORK_PHONE VARCHAR No
Work phone of the guarantor.
11 RESPONSIBLE_PARTY_NAME VARCHAR No
Addressee of the statement. This is usually guarantor's name.
12 BILL_HOUSE_NUM VARCHAR No
House number of the guarantor.
13 BILL_DISTRICT_C_NAME VARCHAR No
District of the guarantor.
May contain organization-specific values: Yes
14 BILL_CITY VARCHAR No
The city of the guarantor.
15 BILL_COUNTY_C_NAME VARCHAR No
County of the guarantor.
May contain organization-specific values: Yes
16 BILL_STATE VARCHAR No
The state of the guarantor.
17 BILL_COUNTRY_C_NAME VARCHAR No
Country of the guarantor.
May contain organization-specific values: Yes
18 BILL_ZIP VARCHAR No
The zip code of the guarantor.
19 BILL_DELIV_POINT VARCHAR No
The billing delivery point is a two digit extension to the nine digit US zipcode, with values from 00 to 99. This is typically not seen in human readable format. This can be used when printed as a bar code on a letter to obtain a bulk mail discount.
20 START_SERVICE_DATE DATETIME No
If specified, professional transactions with service date before this date and hospital accounts with discharge date before this date will be excluded from statement.
21 END_SERVICE_DATE DATETIME No
If specified, professional transactions with service date after this date and hospital accounts with discharge date after this date will be excluded from statement.
22 BILL_RUN_TYPE_C_NAME VARCHAR No
The type of this enterprise bill print.
May contain organization-specific values: No
Category Entries:
Statement
Hospital Account Detail Bill
Guarantor Detail Bill
Claim Detail Bill
Client Statement
23 PAT_ENC_CSN_ID INTEGER No
Stores the linked patient serial number of the patient on the statement. If the guarantor is a patient in the system, this will be the patient for the guarantor. Otherwise if there is only one patient on the statement, it will be that patient. If there are multiple patients on the statement, this item will be blank.
24 IS_MYCHART_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
25 HSP_BUCKET_ID NUMERIC No
The liability bucket record ID that requested this bill print record.
26 CLAIM_PRINT_ID NUMERIC No
The claim print record ID that requested this bill print record.
27 ROI_ID VARCHAR No
The release of information record ID that requested this bill print record.
28 ROI_DATE DATETIME No
The contact date of the release of information record that requested this bill print record.
29 ROI_DOC_KEY VARCHAR No
The document reference key for the release of information record that requested this bill print record.
30 COMMUNICATION_TOPIC_SETTING_ID NUMERIC No
Stores the topic that will be used for sending the relevant communication.
31 COMMUNICATION_TOPIC_SETTING_ID_SETTING_NAME VARCHAR No
Setting record name.
32 STMT_SCENARIO_C_NAME VARCHAR No
Stores the scenario the statement falls under. It can be used by PDF statements to build content to match what the guarantor would eventually receive in the notification.
May contain organization-specific values: No
Category Entries:
Due - Eligible for payment plan
Due - Ineligible for payment plan
Due - On payment plan
Due - On payment plan with balance not on plan
Due - On auto pay payment plan, scheduled payment does not cover due
Due - On auto pay payment plan with balance not on plan
Due - Scheduled payment does not cover due
Due - No action needed, on auto pay payment  plan
Informational Only
Overdue - Eligible for payment plan
Overdue - Ineligible for payment plan
Overdue - On payment plan
Overdue - On payment plan with balance not on plan
Overdue - On payment plan with suspended auto pay
Final Notice - Eligible for payment plan
Final Notice - Ineligible for payment plan
Final Notice - On payment plan
Final Notice - On payment plan with balance not on plan
Final Notice - On payment plan with suspended auto pay