HSP_ACCOUNT_5

Description: |
This table contains hospital account information from the Hospital Accounts Receivable (HAR) master file. It excludes Professional Billing accounts in classic PB self-pay 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.
16 | PMT_DISCNT_PROMOTION_ID | NUMERIC | No |
Stores the active discount offer that a visit account qualifies for.
17 | PMT_DISCNT_PROMOTION_ID_PROMOTION_NAME | VARCHAR | No |
The promotion record name.
18 | PMT_DISCNT_OFFER_STS_C_NAME | VARCHAR | No |
The status of the payment-based discount offer
May contain organization-specific values: No
Category Entries:
Active
Ineligible
Applied
Expired
19 | PMT_DISCNT_INELIG_RSN_C_NAME | VARCHAR | No |
The reason this hospital account is ineligible for a discount offer.
May contain organization-specific values: No
Category Entries:
Expired - Self-Pay Follow-Up Level
Expired - Outside of Date Range
Excluded by Rule
Manually Adjusted
Payment Plan
Visit Auto Pay
Filtered From MyChart
No Discountable Balance
Discount Amount is Greater than Account Balance
Contested
With Agency
Policy Not Active
Not Patient Responsibility
20 | REV_SPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
21 | REV_SUBSPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name