HBP_STMT_HAR_DETAIL

Description: |
This table stores the hospital accounts that are associated with a given Hospital Billing statement print record.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HBP_PRINT_ID | NUMERIC | No |
The unique identifier for the bill print 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 | HSP_ACCOUNT_ID | NUMERIC | No |
The hospital account ID.
4 | ADMIT_DATE | DATETIME | No |
The admit date.
5 | DISCH_DATE | DATETIME | No |
The discharge date.
6 | FIRST_STMT_DATE | DATETIME | No |
The first statement date.
7 | NUM_PREV_STMTS_SENT | INTEGER | No |
The number of previous statements sent.
8 | PRIM_DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
9 | PREV_STMT_DATE | DATETIME | No |
The previous statement balance.
10 | PREV_BAL | NUMERIC | No |
The previous balance.
11 | PREV_INS_BAL | NUMERIC | No |
The previous insurance balance.
12 | TOT_CHG_AMT | NUMERIC | No |
The total charge amount.
13 | NEW_CHG_AMT | NUMERIC | No |
The new charge amount since the last statement.
14 | NEW_PAT_CHG_AMT | NUMERIC | No |
The new patient charge amount.
15 | NEW_INS_CHG_AMT | NUMERIC | No |
The new insurance charge amount.
16 | TOT_PMT_AMT | NUMERIC | No |
The total payment amount.
17 | NEW_PMT_AMT | NUMERIC | No |
The new payment amount since the last statement.
18 | NEW_PAT_PMT_AMT | NUMERIC | No |
The new patient payment amount.
19 | NEW_INS_PMT_AMT | NUMERIC | No |
The new insurance payment amount.
20 | TOT_ADJ_AMT | NUMERIC | No |
The total adjustment amount.
21 | NEW_ADJ_AMT | NUMERIC | No |
The new adjustment amount since the last statement.
22 | NEW_PAT_ADJ_AMT | NUMERIC | No |
The new patient adjustment amount.
23 | NEW_INS_ADJ_AMT | NUMERIC | No |
The new insurance adjustment amount.
24 | CURR_INS_BAL | NUMERIC | No |
The current insurance balance.
25 | CURR_BAL | NUMERIC | No |
The current balance on the hospital account.
26 | CURR_PAT_LIABILITY_AMT | NUMERIC | No |
The current patient liability amount.
27 | PAT_LIAB_SPLIT_UP | VARCHAR | No |
The patient liability split-up.
28 | PMT_PLAN_INIT_BAL | NUMERIC | No |
The initial balance on the payment plan.
29 | PMT_PLAN_REMAINING_BAL | NUMERIC | No |
The remaining balance on the payment plan.
30 | BUCKET_ID | NUMERIC | No |
The liability bucket ID.
31 | IS_INFORMATIONAL_YN | VARCHAR | No |
Indicates whether or not the hospital account is on an informational statement.
May contain organization-specific values: No
Category Entries:
No
Yes
32 | CLAIM_PRINT_ID | NUMERIC | No |
The claim print ID.
33 | SELFPAY_STATUS_C_NAME | VARCHAR | No |
The self-pay status.
May contain organization-specific values: No
Category Entries:
Full Self-Pay Due
Review
Payment Plan
Pre-collection
Bad Debt
Prorated
34 | SP_LEVEL_C_NAME | VARCHAR | No |
The self-pay follow-up level.
May contain organization-specific values: No
Category Entries:
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
Level 7
Level 8
Level 9
Level 10
35 | FOLLOW_UP_LEVEL | INTEGER | No |
The follow-up level.
36 | COLLECTION_STATUS_C_NAME | VARCHAR | No |
The collection status.
May contain organization-specific values: No
Category Entries:
Active AR
External AR
Bad Debt
Outsourced
Received Self-Pay Active AR
Received Self-Pay External AR
Received Self-Pay Bad Debt
37 | COLL_AGENCY_ID | NUMERIC | No |
The collection agency.
38 | COLL_AGENCY_ID_COLL_AGENCY_NAME | VARCHAR | No |
The name of the collection agency.
39 | IS_OUTSOURCED_YN | VARCHAR | No |
Indicates whether or not the hospital account has been outsourced.
The category values for this column were already listed for column: IS_INFORMATIONAL_YN