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
33 | AUTH_BILL_USER_MYPT_ID | VARCHAR | No |
Stores the authorized billing user if the statement is a copy generated for that for that user upon request.
34 | ORIGINAL_STMT_PRINT_ID | NUMERIC | No |
If the current statement is a copy generated for the authorized user, this item will point to the original statement sent to the guarantor.
35 | RECIPIENT_NAME | VARCHAR | No |
Name of the person receiving the statement. If it is an authorized user copy, then this would be the name of that user. Otherwise, this will usually be the guarantor's name.