|
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 |
NUMERIC |
No |
|
|
|
This column stores the unique identifier for the service area of this statement print or detail bill. |
|
|
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. |
|
|