HSP_ACCT_SBO

Description: |
This table contains the balances on the hospital account (HAR). These balances are always populated for Hospital Billing HARs. They are also populated for Professional Billing HARs in service areas using the Enterprise Self-Pay platform.
For legacy mixed hospital accounts the balances are the combined Hospital Billing and Professional Billing transaction balances on each HAR.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
The hospital account ID with associated single billing office information.
2 | SBO_TOT_BALANCE | NUMERIC | No |
Contains the total balance of Hospital Billing (HB) or Professional Billing (PB) transactions on the hospital account, including charges, payments and adjustments in all statuses.
3 | SBO_TOTAL_CHARGES | NUMERIC | No |
Hospital Billing (HB) or Professional Billing (PB) charges on the hospital account in all statuses.
4 | SBO_TOTAL_PAYMENTS | NUMERIC | No |
Hospital Billing (HB) or Professional Billing (PB) payments on the hospital account in all statuses.
5 | SBO_TOTAL_ADJ | NUMERIC | No |
Contains Hospital Billing (HB) or Professional Billing (PB) adjustments on the hospital account in all statuses.
6 | SBO_PREBILL_BALANC | NUMERIC | No |
Contains Hospital Billing (HB) prebilled balances including charges, payments and adjustments.
7 | SBO_INS_BALANCE | NUMERIC | No |
Contains Hospital Billing (HB) or Professional Billing (PB) insurance balances including charges, payments and adjustments.
8 | SBO_UND_BALANCE | NUMERIC | No |
Contains Hospital Billing (HB) or Professional Billing (PB) undistributed balances.
9 | SBO_SP_BAL | NUMERIC | No |
Contains Hospital Billing (HB) or Professional Billing (PB) self pay balances including charges, payments and adjustments.
10 | SBO_BAD_DEBT_BAL | NUMERIC | No |
Contains Hospital Billing (HB) or Professional Billing (PB) bad debt balances including charges, payments and adjustments.