HSP_ACCOUNT_5
Description:
This table contains hospital account information from the Hospital Accounts Receivable (HAR) master file. It excludes Professional Billing HARs created by visit filing order in non-single billing office service areas. This fifth hospital account table has the same basic structure as HSP_ACCOUNT, HSP_ACCOUNT_2, HSP_ACCOUNT_3, and HSP_ACCOUNT_4.

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 hospital account record.
2 AR_CLASSIFICATION_C_NAME VARCHAR No
This column stores the A/R classification of this account.
May contain organization-specific values: No
Category Entries:
Active AR
External AR
Bad Debt
Outsourced
Received Self-Pay Active AR
Received Self-Pay External AR
Received Self-Pay Bad Debt
3 INITIAL_EXPECTED_ALLOWED_AMT NUMERIC No
The sum of the expected allowed amounts for the primary claims initially sent.
4 CURRENT_EXPECTED_ALLOWED_AMT NUMERIC No
The sum of the expected allowed amounts for the primary claims last sent.
5 CHANGE_IN_EXPECTED_ALLOWED_AMT NUMERIC No
The difference between the sums of the expected allowed amounts of the primary claims initially sent and of the primary claims last sent.
6 INITIAL_CLM_CLASS_C_NAME VARCHAR No
The claim class used when sending the initial primary claims. Represented with a patient class category ID for the hospital account.
May contain organization-specific values: Yes
7 INITIAL_CLM_BASE_CLASS_C_NAME VARCHAR No
The claim base class used when sending the initial primary claims. Represented with an account base class category ID for the hospital account.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
Emergency
8 CUR_CLM_CLASS_C_NAME VARCHAR No
The claim class used for currently sent or closed primary claims. Represented with a patient class category ID for the hospital account.
The category values for this column were already listed for column: INITIAL_CLM_CLASS_C_NAME
9 CUR_CLM_BASE_CLASS_C_NAME VARCHAR No
The claim base class used for currently sent or closed primary claims. Represented with an account base class category ID for the hospital account.
The category values for this column were already listed for column: INITIAL_CLM_BASE_CLASS_C_NAME
10 DAYS_FROM_INIT_TO_CUR_CLM_ACPT INTEGER No
The maximum of the number of days between the accept dates for the first and last claim sent on each payer billing thread for this hospital account. Null for any account without multiple claims sent on the same payer billing thread.
11 PAYER_DOWNGRADE_TYPE_C_NAME VARCHAR No
The payer downgrade request type category ID for the hospital account. This category is the type of downgrade requested when the primary payer tries to dispute the level of care of the HAR. NULL if no such attempt was made.
May contain organization-specific values: No
Category Entries:
No Downgrade
Inpatient to Observation
12 PAYER_DOWNGRADE_OUTCOME_C_NAME VARCHAR No
Whether the primary payer's attempt to lower the level of care of the account was appropriate and whether it was overturned or led to a downgrade. NULL if no such attempt was made by the Primary Payer.
May contain organization-specific values: No
Category Entries:
Downgrade Accepted – Agree with Payer
Downgrade Overturned
Downgrade Accepted – Disagree with Payer
13 PAYER_DOWNGRADE_BDC_ID NUMERIC No
The unique ID of the follow-up record that is the primary payer's attempt to lower the level of care of the account. NULL if no such attempt was made by the primary payer. This column is frequently used to link to the BDC_INFO table.
14 LAST_SP_LEVEL_UPDATE_DATE DATETIME No
Retrieves the last date when the self-pay follow-up cycle was updated.
15 OVER_TIME_CODING_RECORD_ID NUMERIC No
The COD record used for Coding Over Time on the account.