HSP_ACCT_DETAIL_BILL_HX

Description: |
This table contains the history of hospital billing detail bills for a given hospital account.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
The hospital account ID.
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 | HBP_PRINT_ID | NUMERIC | No |
The hospital billing print record ID.
4 | EB_PRINT_ID | NUMERIC | No |
The enterprise statement/detail bill ID.
5 | BILL_RUN_TYPE_C_NAME | VARCHAR | No |
The run type of the detail bill.
May contain organization-specific values: No
Category Entries:
Statement
Hospital Account Detail Bill
Guarantor Detail Bill
Claim Detail Bill
Client Statement
6 | IS_DEMAND_YN | VARCHAR | No |
Flag to indicate whether this detail bill was produced on demand instead of as part of a batch.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | ACCEPT_DATE | DATETIME | No |
The date the detail bill was accepted.
8 | BATCH_DATE | DATETIME | No |
The batch date of the detail bill.
9 | DELIVERY_METHOD_C_NAME | VARCHAR | No |
How the detail bill 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
10 | CREATION_USER_ID | VARCHAR | No |
The user who created the detail bill.
11 | CREATION_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | TOT_CHG_AMT | NUMERIC | No |
The sum of all charges on the detail bill.
13 | TOT_PMT_AMT | NUMERIC | No |
The sum of all payments on the detail bill.
14 | TOT_ADJ_AMT | NUMERIC | No |
The sum of all adjustments on the detail bill.
15 | INSURANCE_BALANCE | NUMERIC | No |
The total amount of the detail bill that is currently with insurance.
16 | PATIENT_BALANCE | NUMERIC | No |
The total amount of the detail bill that is currently in self-pay.
17 | PATIENT_AMOUNT_DUE | NUMERIC | No |
The total amount due for this detail bill.