|
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 |
|
|
|
|
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. |
|
|