HBP_STMT_PRINT

Description: |
This table stores information about Hospital Billing statement print records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HBP_PRINT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HBP_PRINT_ID | NUMERIC | No |
The HB print record ID.
2 | BILL_RUN_TYPE_C_NAME | VARCHAR | No |
The type of bill print record.
May contain organization-specific values: Yes
Category Entries:
Hospital Account Detail Bill
Statement
Guarantor Detail Bill
Claim Detail Bill
3 | IS_DEMAND_BILL_YN | VARCHAR | No |
Indicates whether or not this is a demand bill.
May contain organization-specific values: No
Category Entries:
Yes
No
4 | CURR_AMOUNT_DUE | NUMERIC | No |
The current amount due.
5 | BILLED_DATE | DATETIME | No |
The billed date.
6 | STMT_DATE | DATETIME | No |
The statement date.
7 | ACCT_ID | NUMERIC | No |
The guarantor account ID.
8 | RESP_PARTY | VARCHAR | No |
The responsible party.
9 | BILL_CITY | VARCHAR | No |
The billing city of the guarantor.
10 | BILL_STATE_C | VARCHAR | No |
The billing state of the guarantor.
11 | BILL_ZIP | VARCHAR | No |
The billing zip of the guarantor.
12 | PREV_BAL | NUMERIC | No |
The previous balance.
13 | PREV_AMT_DUE | NUMERIC | No |
The previous amount due.
14 | PREV_INS_BAL | NUMERIC | No |
The previous insurance balance.
15 | CURR_BAL | NUMERIC | No |
The current balance.
16 | GUAR_INS_DUE | NUMERIC | No |
The insurance due amount on the guarantor.
17 | PMT_PLAN_MONTHLY_AMT | NUMERIC | No |
The monthly amount on the payment plan.
18 | PMT_PLAN_TOT | NUMERIC | No |
The total amount on the payment plan.
19 | PMT_PLAN_BAL | NUMERIC | No |
The payment plan balance.
20 | TOT_CHG_AMT | NUMERIC | No |
The total charge amount.
21 | GUAR_PMT_PLAN_AMT_DUE | NUMERIC | No |
The amount due on the guarantor's payment plan.
22 | GUAR_PMT_PLAN_TOT | NUMERIC | No |
The total amount on the guarantor's payment plan.
23 | GUAR_PMT_PLAN_BAL | NUMERIC | No |
The balance on the guarantor's payment plan.
24 | GUAR_PMT_PLAN_PAT_PORTION | NUMERIC | No |
The patient portion on the guarantor's payment plan.
25 | NEW_CHG_AMT | NUMERIC | No |
The new charge amount.
26 | NEW_PAT_CHG_AMT | NUMERIC | No |
The new patient charge amount.
27 | NEW_INS_CHG_AMT | NUMERIC | No |
The new insurance charge amount.
28 | TOT_PMT_AMT | NUMERIC | No |
The total payment amount.
29 | NEW_PMT_AMT | NUMERIC | No |
The new payment amount.
30 | NEW_PAT_PMT_AMT | NUMERIC | No |
The new patient payment amount.
31 | NEW_INS_PMT_AMT | NUMERIC | No |
The new insurance payment amount.
32 | TOT_ADJ_AMT | NUMERIC | No |
The total adjustment amount.
33 | NEW_ADJ_AMT | NUMERIC | No |
The new adjustment amount.
34 | NEW_PAT_ADJ_AMT | NUMERIC | No |
The new patient adjustment amount.
35 | NEW_INS_ADJ_AMT | NUMERIC | No |
The new insurance adjustment amount.
36 | IS_INFORMATIONAL_YN | VARCHAR | No |
Indicates whether or not this is an informational statement.
May contain organization-specific values: No
Category Entries:
No
Yes
37 | REC_CREATE_DATE | DATETIME | No |
The creation date for this record.
38 | PMT_PLAN_AMT_OVERDUE | NUMERIC | No |
The amount overdue on the payment plan.