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_DX_NAME | VARCHAR | No |
The name of the 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
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.
80 | HB_NEW_PAT_DISCNT_CHARITY_ADJ | NUMERIC | No |
Stores the new HB patient discounts for this specific HAR that occurred since the last statement.
81 | HB_TOT_PAT_DISCNT_CHARITY_ADJ | NUMERIC | No |
Stores the total HB patient discount amount for this particular HAR on the current statement.
82 | HB_NEW_PAT_RFND | NUMERIC | No |
Stores the new HB patient refund amount for this specific HAR that occurred since the last statement.
83 | HB_TOT_PAT_RFND | NUMERIC | No |
Stores the total HB patient refund amount for this particular HAR on the current statement.
84 | HB_NEW_PAT_OTHER_ADJ | NUMERIC | No |
Stores the new HB patient other adjustment amount for this specific HAR that occurred since the last statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
85 | HB_TOT_PAT_OTHER_ADJ | NUMERIC | No |
Stores the total HB patient other adjustment amount for this specific HAR on the current statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
86 | PB_NEW_PAT_RFND | NUMERIC | No |
Stores the new PB patient refund amount for this specific HAR that occurred since the last statement.
87 | PB_TOT_PAT_RFND | NUMERIC | No |
Stores the total PB patient refund amount for this particular HAR on the current statement.
88 | PB_NEW_PAT_DISCNT_CHARITY_ADJ | NUMERIC | No |
Stores the new PB patient discount amount for this specific HAR that occurred since the last statement.
89 | PB_TOT_PAT_DISCNT_CHARITY_ADJ | NUMERIC | No |
Stores the total PB patient discount amount for this particular HAR on the current statement.
90 | PB_NEW_PAT_OTHER_ADJ | NUMERIC | No |
Stores the new PB patient other adjustment amount for this specific HAR that occurred since the last statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
91 | PB_TOT_PAT_OTHER_ADJ | NUMERIC | No |
Stores the total PB patient other adjustment amount for this specific HAR on the current statement. Patient other adjustments are any patient adjustments that are not refunds or discounts.
92 | DISCOUNT_OFFER_AMT | NUMERIC | No |
The proposed discount amount for this specific HAR.
93 | PAY_NOW_AMT | NUMERIC | No |
The due amount for this HAR including the proposed discount.
94 | DISCOUNT_OFFER_PCT | NUMERIC | No |
The percent discount proposed for this HAR.
95 | PB_HAR_EXPRESS_CLAIM_YN | VARCHAR | No |
Indicates if the visit HAR qualifies as an Express Claim visit. For a visit HAR to qualify as an Express Claim visit, the following conditions must be true: - All active charges on the HAR should have been sent on an outbound express claim and received a "payment expected" response from the insurance payer. - An actual payment transaction has not yet been received from the insurance payer.
The category values for this column were already listed for column: HB_IS_INFORMATIONAL_YN