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.