DETAIL_BILL_HX

Description: |
Hospital account based detail bill history for the guarantor.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
This column stores the unique identifier for the guarantor record.
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 | HB_PRINT_ID | NUMERIC | No |
This column stores the unique identifier for this hospital detail bill in detail bill history.
4 | EB_PRINT_ID | NUMERIC | No |
This column stores the unique identifier for this enterprise detail bill record in detail bill history.
5 | BILL_RUN_TYPE_C_NAME | VARCHAR | No |
The run type for this 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_DB_YN | VARCHAR | No |
Flag to indicate whether this detail bill was produced on demand or as part of the batch.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | ACCEPT_DT | DATETIME | No |
The date the detail bill record was created.
8 | END_BATCH_DT | DATETIME | No |
The batch date of the detail bill.
9 | DB_DVRY_MTHD_C_NAME | VARCHAR | No |
Stores 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 | USER_ID | VARCHAR | No |
The user who created the detail bill.
11 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | TOTAL_CHG_AMT | NUMERIC | No |
The sum of all charges on the detail bill.
13 | TOTAL_PMT_AMT | NUMERIC | No |
The sum of all payments on the detail bill.
14 | TOTAL_ADJ_AMT | NUMERIC | No |
The sum of all adjustments on the detail bill.
15 | CUR_INS_BAL_AMT | NUMERIC | No |
The total amount of the detail bill that is currently with insurance.
16 | CUR_PAT_BAL_AMT | NUMERIC | No |
The total amount of the detail bill that is currently in self-pay.
17 | TOTAL_AMT_DUE | NUMERIC | No |
The total amount due for this detail bill.
18 | DB_IS_MYC_NOTIF_YN | VARCHAR | No |
Stores if the detail bill notification was sent via MyChart.
The category values for this column were already listed for column: IS_DEMAND_DB_YN
19 | DB_PAPER_RSN_C_NAME | VARCHAR | No |
Stores the reason why the detail bill was sent via paper.
May contain organization-specific values: No
Category Entries:
Paperless Billing is disabled for the service area
User specified
Forced to paper because of self-pay follow-up level
Forced to paper because of guarantor rule
Forced to paper because of hospital account rule
Guarantor declined paperless billing
Financial Assistance Program Not Allowed In MyChart
Not self-pay correspondence
Form is not allowed to be displayed in MyChart
Guarantor missing associated patient or MyChart account
Guarantor is not MyChart active
Guarantor is not available in MyChart
No access to billing features in MyChart
MyChart tickler could not be sent
Professional billing letter not marked as Sent
Patient is not active on MyChart
Queued for printing based on estimate rule
Patient is deceased
Forced to paper because the authorized user copy is always sent as a physical copy
20 | INVOICE_NUMBER | VARCHAR | No |
Invoice number for a detail bill.