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