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.