STMT_HSP_ACCT_DETAIL
Description:
This table contains information about hospital accounts that are associated with a given statement.

Primary Key
Column Name Ordinal Position
PRINT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PRINT_ID NUMERIC No
The unique identifier (.1 item) for the statement print or detail bill 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 HB_PREV_PAT_BAL NUMERIC No
The hospital account previous patient balance.
5 HB_NEW_CHG_AMT NUMERIC No
The hospital account new charge amount.
6 HB_NEW_PMT_AMT NUMERIC No
The hospital account new payment amount.
7 HB_NEW_ADJ_AMT NUMERIC No
The hospital account new adjustment amount.
8 HB_TOT_CHG_AMT NUMERIC No
The hospital account total charge amount.
9 HB_TOT_PMT_AMT NUMERIC No
The hospital account total payment amount.
10 HB_TOT_ADJ_AMT NUMERIC No
The hospital account total adjustment amount.
11 HB_CURR_PAT_BAL NUMERIC No
Stores the Hospital Billing outstanding self-pay balance for the hospital account.
12 HB_CURR_AMT_DUE NUMERIC No
Stores the Hospital Billing amount due for the hospital account. It is usually the self-pay outstanding balance, but will be zero for accounts on a payment plan (since the payment plan amount due is really at the guarantor level unless sending hospital account level statements).
13 HB_PAT_LIAB_SPLIT_UP VARCHAR No
The hospital account patient liability split-up.
14 HB_ADMIT_DATE DATETIME No
The hospital account admit date.
15 HB_DISCHARGE_DATE DATETIME No
The hospital account discharge date.
16 HB_PRIM_DX_ID NUMERIC No
The hospital account primary diagnosis.
17 HB_SP_STATUS_C_NAME VARCHAR No
The hospital account self-pay status.
May contain organization-specific values: No
Category Entries:
Full Self-Pay Due
Review
Payment Plan
Pre-collection
Bad Debt
Prorated
18 HB_FIRST_STMT_DATE DATETIME No
The hospital account first statement date.
19 HB_PREV_STMT_DATE DATETIME No
The hospital account previous statement date.
20 HB_SENT_STMT_CNT INTEGER No
The number of statements sent for a hospital account.
21 HB_IS_INFORMATIONAL_YN VARCHAR No
The hospital account-level storage of whether this particular hospital account had a patient balance.
May contain organization-specific values: No
Category Entries:
No
Yes
22 HB_PREV_INS_BAL NUMERIC No
The hospital account-level previous insurance balance.
23 HB_NEW_INS_CHG_AMT NUMERIC No
The new insurance charges at the hospital account level.
24 HB_NEW_INS_PMT_AMT NUMERIC No
The new insurance payments for this hospital account.
25 HB_NEW_INS_ADJ_AMT NUMERIC No
The new insurance adjustments on this hospital account.
26 HB_CURR_INS_BAL NUMERIC No
The current insurance balance on this hospital account.
27 PB_PREV_PAT_BAL NUMERIC No
Previous professional patient balance on the hospital account.
28 PB_NEW_CHG_AMT NUMERIC No
New professional charges on the hospital account.
29 PB_NEW_PMT_AMT NUMERIC No
New professional payments on the hospital account.
30 PB_NEW_ADJ_AMT NUMERIC No
New professional adjustments on the hospital account.
31 PB_TOT_CHG_AMT NUMERIC No
Total professional charges on the hospital account.
32 PB_TOT_PMT_AMT NUMERIC No
Total professional payments on the hospital account.
33 PB_TOT_ADJ_AMT NUMERIC No
Total professional adjustments on the hospital account.
34 PB_CURR_PAT_BAL NUMERIC No
Stores the Professional Billing outstanding self-pay balance for the hospital account.
35 PB_CURR_AMT_DUE NUMERIC No
Stores the Professional Billing amount due for the hospital account. It is usually the self-pay outstanding balance, but will be zero for accounts on a payment plan (since the payment plan amount due is really at the guarantor level unless sending hospital account level statements).
36 PB_PREV_INS_BAL NUMERIC No
Previous professional insurance balance on the hospital account.
37 PB_NEW_INS_CHG_AMT NUMERIC No
The new professional charges for which an insurance payment is expected.
38 PB_NEW_INS_PMT_AMT NUMERIC No
The new professional payments that have been applied to the insurance portion of charges and debit adjustments.
39 PB_NEW_INS_ADJ_AMT NUMERIC No
The amount of new adjustment applied to the insurance portion of the hospital account.
40 PB_CURR_INS_BAL NUMERIC No
The current professional insurance balance.
41 PB_TOT_PAT_PMT_AMT NUMERIC No
Stores the total Professional Billing patient payments for a hospital account.
42 PB_TOT_PAT_ADJ_AMT NUMERIC No
Stores the total Professional Billing patient adjustments for a hospital account.
43 PB_TOT_INS_PMT_AMT NUMERIC No
Stores the total Professional Billing insurance payments for a hospital account.
44 PB_TOT_INS_ADJ_AMT NUMERIC No
Stores the total Professional Billing insurance adjustments for a hospital account.
45 HB_NEW_PAT_CHG_AMT NUMERIC No
Stores the new patient charges for a hospital account.
46 HB_NEW_PAT_PMT_AMT NUMERIC No
Stores the new patient payments for a hospital account.
47 HB_NEW_PAT_ADJ_AMT NUMERIC No
Stores the new patient adjustments for a hospital account.
48 HB_PMT_PLAN_INIT_BAL NUMERIC No
Stores the Hospital Billing hospital account-level initial payment plan balance.
49 HB_PMT_PLAN_REMAIN_BAL NUMERIC No
Stores the Hospital Billing hospital account-level remaining payment plan balance.
50 HB_COLLECTION_STATUS_C_NAME VARCHAR No
Stores the hospital account's 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
51 HB_COLL_AGENCY_ID NUMERIC No
Stores the outsource agency for the hospital account.
52 HB_COLL_AGENCY_ID_COLL_AGENCY_NAME VARCHAR No
The name of the collection agency.
53 HB_IS_OUTSOURCED_YN VARCHAR No
Stores if the hospital account has been outsourced.
The category values for this column were already listed for column: HB_IS_INFORMATIONAL_YN
54 HB_FOLLOW_UP_CYCLE_LEVEL INTEGER No
Follow-up cycle level for this hospital account.
55 HB_SP_FOLLOW_UP_LEVEL_C_NAME VARCHAR No
Stores the hospital account 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
56 HB_PMT_PLAN_DUE NUMERIC No
Stores the Hospital Billing hospital account-level payment plan due.
57 HB_PMT_PLAN_MONTHLY_AMT NUMERIC No
Stores the Hospital Billing hospital account-level payment plan monthly amount.
58 HB_STATEMENT_TYPE_C_NAME VARCHAR No
The Hospital Billing hospital account statement type.
May contain organization-specific values: No
Category Entries:
Full Self-pay
Prorated / Estimated Payment Plan
Informational
Has Payment Plan Discrepancy
59 HB_SP_AGING_DATE DATETIME No
This item stores the date for aging the self-pay balances.
60 HB_PREV_STMT_END_BATCH_DATE DATETIME No
Stores the end system batch date of the last statement generated for the hospital account.
61 HB_PREV_STMT_PRINT_ID NUMERIC No
Stores the previous statement generated for the hospital account.
62 HB_TOT_PAT_PMT_AMT NUMERIC No
Stores the total Hospital Billing patient payments for a hospital account.
63 HB_TOT_PAT_ADJ_AMT NUMERIC No
Stores the total Hospital Billing patient adjustments for a hospital account.
64 HB_TOT_INS_PMT_AMT NUMERIC No
Stores the total Hospital Billing insurance payments for a hospital account.
65 HB_TOT_INS_ADJ_AMT NUMERIC No
Stores the total Hospital Billing insurance adjustments for a hospital account.
66 HB_PMT_PLAN_OVERDUE_AMT NUMERIC No
Stores the hospital account-level payment plan overdue amount.
67 HB_PMT_PLAN_PAID_AHEAD_AMT NUMERIC No
Stores the hospital account-level payment plan paid ahead amount.
68 HB_ADVBILL_ESTIMATE_ID NUMERIC No
Stores the advance bill estimate on the hospital account.
69 HB_NEW_CONTESTED_CHG_AMT NUMERIC No
Sum of new contested Hospital Billing charges for the hospital account.
70 HB_NEW_CONTESTED_PMT_AMT NUMERIC No
Sum of new contested Hospital Billing payments for the hospital account.
71 HB_NEW_CONTESTED_ADJ_AMT NUMERIC No
Sum of new contested Hospital Billing adjustments for the hospital account.
72 HB_NEW_CONTESTED_INS_PMT_AMT NUMERIC No
Sum of new contested Hospital Billing insurance payments for the hospital account.
73 HB_NEW_CONTESTED_INS_ADJ_AMT NUMERIC No
Sum of new contested Hospital Billing insurance adjustments for the hospital account.
74 HB_CONTESTED_CHG_AMT NUMERIC No
Sum of all contested Hospital Billing charges for the hospital account.
75 HB_CONTESTED_PMT_AMT NUMERIC No
Sum of all contested Hospital Billing payments for the hospital account.
76 HB_CONTESTED_ADJ_AMT NUMERIC No
Sum of all contested Hospital Billing adjustments for the hospital account.
77 HB_CONTESTED_INS_PMT_AMT NUMERIC No
Sum of all contested Hospital Billing insurance payments for the hospital account.
78 HB_CONTESTED_INS_ADJ_AMT NUMERIC No
Sum of all contested Hospital Billing insurance adjustments for the hospital account.
79 HB_CONTESTED_BAL NUMERIC No
Total contested balance for the hospital account.