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, and 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
Multi-Instance Inventory
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