HSP_ACCOUNT_5

Description: |
This table contains hospital account information from the Hospital Accounts Receivable (HAR) master file. This fifth hospital account table has the same basic structure as HSP_ACCOUNT, HSP_ACCOUNT_2, HSP_ACCOUNT_3, and HSP_ACCOUNT_4, but was created as a fifth table to prevent the other tables from getting any larger. It excludes Professional Billing accounts in classic PB self-pay service areas.

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. Doesn't include any expected reimbursement from interim claims.
4 | CURRENT_EXPECTED_ALLOWED_AMT | NUMERIC | No |
The sum of the expected allowed amounts for the primary claims last sent. Doesn't include any expected reimbursement from interim claims.
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. Doesn't include any expected reimbursement from interim claims.
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 for each primary payer for this hospital account.
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
DRG
Emergency Visit Level
Upcoded DRG
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
Ineligible Guarantor Type
20 | REV_SPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
21 | REV_SUBSPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
22 | CHANGE_EAR_FLAG_YN | VARCHAR | No |
Indicates whether the HAR’s coverage list originated from a source guarantor as a result of change guarantor. When set, retro processes will bypass the HAR.
May contain organization-specific values: No
Category Entries:
No
Yes
23 | RECUR_POST_TYPE_C_NAME | NUMERIC | No |
Indicates whether this HAR’s trust account transactions are routed by deposit date or by post date. The item is set based on the trust hospital billing profile configuration in I HSD 24007
May contain organization-specific values: No
Category Entries:
No
Yes by Service Date
Yes by Post Date