HSP_ACCT_CONS_SP_BAL
Description:
The HSP_ACCT_CONS_SP_BAL table contains information about Received Self-Pay HARs as well as some total balance amounts. As a partial example, this includes core information such as the balance type, visit location, type of visit as well as total balance information such as total charges, insurance payments etc.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
The unique identifier (.1 item) for the hosp acct record.
2 CONS_SP_BAL_TYPE_C_NAME VARCHAR No
The type of balance for a self-pay target account.
May contain organization-specific values: No
Category Entries:
Hospital
Professional
3 CONS_SP_VISIT_LOC VARCHAR No
Stores a string description of the visit location or department for display in patient facing communication. Typically this will be a department for outpatient encounters and a location for inpatient or emergency encounters.
4 CONS_SP_VISIT_DESC_OVRIDE VARCHAR No
Stores a string description of the visit for display in patient facing communication.
5 CONS_SP_VISIT_TYPE_C_NAME VARCHAR No
The type of visit for the self-pay target account.
May contain organization-specific values: Yes
Category Entries:
Admission
Appointment
Emergency Visit
Surgery
Hospital Outpatient Visit
Hospital Visit
6 CONS_SP_BAL_WTHDRW_RSN_C_NAME VARCHAR No
This item contains the reason a self-pay target HAR was withdrawn or marked for withdrawal.
May contain organization-specific values: Yes
Category Entries:
Created in Error
Account Combine
Sent to PB bad debt in non-SBO AR Service Area.
Conversion Utility
7 CONS_SP_BAL_WTHDRW_STS_C_NAME VARCHAR No
This item contains the status of a self-pay target HAR that has been withdrawn or marked for withdrawal.
May contain organization-specific values: No
Category Entries:
Pending
Withdrawn
8 CONS_SP_TOT_CHG NUMERIC No
Total amount of self-pay charges on this self-pay target account.
9 CONS_SP_TOT_INS_PMT NUMERIC No
Total amount of insurance payments on this self-pay target account.
10 CONS_SP_TOT_INS_RFND NUMERIC No
Total amount of insurance refunds on this self-pay target account.
11 CONS_SP_TOT_INS_ADJ NUMERIC No
Total amount of insurance adjustments on this self-pay target account.
12 CONS_SP_TOT_SP_PMT NUMERIC No
Total amount of payments on this self-pay target account.
13 CONS_SP_TOT_SP_RFND NUMERIC No
Total amount of self-pay refunds on this self-pay target account.
14 CONS_SP_TOT_SP_ADJ NUMERIC No
Total amount of self-pay adjustments on this self-pay target account.
15 CONS_SP_TOT_INS_BAL NUMERIC No
The outstanding insurance amount on this self-pay target account.
16 CONS_SP_VISIT_SETTING_C_NAME VARCHAR No
The visit setting for the consolidated self-pay target account.
May contain organization-specific values: No
Category Entries:
In Person
Video
Telephone
Clinic to Clinic Video
E-Visit
Patient Not Present