HSP_ACCT_CONS_SP_CHG
Description:
The HSP_ACCT_CONS_SP_CHG table contains information about the charge documentation lines associated with a received self-pay hospital account. As a partial example, this includes common charge information like the service date, description, revenue code, quantity, and amount.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
The unique identifier (.1 item) for the hosp acct record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CHG_UNIQUE_IDENT VARCHAR No
An identifier unique to this charge documentation line related group at the HAR level. No other charge documentation lines on the same HAR should share this identifier.
4 CHG_SERVICE_DATE DATETIME No
The service date for a consolidated self-pay charge. This date is when the service occurred in the source system.
5 CHG_POST_DATE DATETIME No
The original post date for a consolidated self-pay charge. This date is when the charge was posted in the source system.
6 CHG_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
7 CHG_DESCRIPTION VARCHAR No
A description of a consolidated self-pay charge. Can be supplied by the source system as an override for the procedure description.
8 CHG_REV_CODE_ID NUMERIC No
The revenue code for a consolidated self-pay charge. If this was not supplied by the source system, it should be set to the procedure code's alternate revenue code.
9 CHG_REV_CODE_ID_REVENUE_CODE_NAME VARCHAR No
The name of the revenue code.
10 CHG_HCPCS_CODE VARCHAR No
The HCPCS or CPT code for a consolidated self-pay charge.
11 CHG_MODIFIER VARCHAR No
A comma delimited string of modifiers on a consolidated self-pay charge.
12 CHG_QUANTITY NUMERIC No
The quantity for a consolidated self-pay charge.
13 CHG_AMOUNT NUMERIC No
The credit or debit amount for a consolidated self-pay charge.
14 CHG_NDC_CODE VARCHAR No
The NDC code for a consolidated self-pay charge.
15 CHG_SERV_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
16 CHG_REVERSAL_DATE DATETIME No
The date that this charge documentation line was reversed. This date is set to the day the documentation line was marked as reversed by the source system. If this item is blank, then the charge has not been reversed.
17 CHG_ORIG_IDENT VARCHAR No
An identifier for a received self-pay charge used by the source. If this is from another system, this is the ID the source system uses. If this is from the same system, this is the original transaction ID for the source service area (HTR for HB transaction, ETR for PB).
18 CHG_UPDATE_DATE DATETIME No
The date that this charge documentation line was consolidated. This date is set to the day the documentation line was first imported from the source system.
19 CHG_CONS_SP_DOCLN_STS_C_NAME VARCHAR No
The current active status of the documentation line.
May contain organization-specific values: No
Category Entries:
Pending
Active
Pending Reversal
Inactive