HSP_ACCT_SBO
Description:
This table contains the single billing office (SBO) balances on the hospital account (HAR). The information is only populated in Enterprise SBO mode. SBO 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 combined total balance of Hospital Billing (HB) and Professional Billing (PB) transactions on the hospital account, including charges, payments and adjustments in all statuses (single billing office (SBO) mode only).
3 SBO_TOTAL_CHARGES NUMERIC No
Combined Hospital Billing (HB) and Professional Billing (PB) charges on the hospital account in all statuses (single billing office (SBO) mode only).
4 SBO_TOTAL_PAYMENTS NUMERIC No
Combined Hospital Billing (HB) and Professional Billing (PB) payments on the hospital account in all statuses (single billing office (SBO) mode only).
5 SBO_TOTAL_ADJ NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) adjustments on the hospital account in all statuses (single billing office (SBO) mode only).
6 SBO_PREBILL_BALANC NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) prebilled balances including charges, payments and adjustments (single billing office (SBO) mode only).
7 SBO_INS_BALANCE NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) insurance balances including charges, payments and adjustments (single billing office (SBO) mode only).
8 SBO_UND_BALANCE NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) undistributed balances. (single billing office (SBO) mode only).
9 SBO_SP_BAL NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) self pay balances including charges, payments and adjustments (single billing office (SBO) mode only).
10 SBO_BAD_DEBT_BAL NUMERIC No
Contains combined Hospital Billing (HB) and Professional Billing (PB) bad debt balances including charges, payments and adjustments (single billing office mode only).