HSP_ACCOUNT_2
Description:
This table contains hospital account information from the Hospital Accounts Receivable (HAR) master file. This second hospital account table has the same basic structure as HSP_ACCOUNT, but was created as a second table to prevent HSP_ACCOUNT from getting any larger. This table will exclude professional billing HARs created by visit filing order in non-single billing office service areas.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the hospital account.
2 HH_AGENCY_C_NAME VARCHAR No
The home health agency associated with the hospital account.
May contain organization-specific values: Yes
3 EXPIRATION_REASON VARCHAR No
The reason for expiration (anesthesia, operation, etc.). If the discharge disposition is not "expired," this field will not be populated.
4 DECEASED_DT DATETIME No
Date of patient's death.
5 DECEASED_TIME DATETIME No
The date and time for the death of the patient that is associated with this hospital account.
6 DURATIONS_HYPERAL NUMERIC No
This column stores the number of days patient is on Hyperal. Hyperal is the same as Total Parenteral Nutrition (TPN) regarding diet and nutrition management.
7 OPEN_DENIAL_BDC_YN VARCHAR No
This column stores whether the hospital account has an open denial record.
May contain organization-specific values: No
Category Entries:
No
Yes
8 OPEN_RMK_BDC_YN VARCHAR No
This column stores whether the hospital account has an open remark record.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
9 OPEN_COR_BDC_YN VARCHAR No
This column stores whether the hospital account has an open correspondence record.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
10 ECMO NUMERIC No
This column stores the number of days the patient has been using the ECMO (extracorporeal membrane oxygenation) equipment.
11 MECHANICAL_VENT NUMERIC No
The number of days the patient has been using the mechanical ventilator.
12 ARCHIVE_ID VARCHAR No
This column stores the unique identifier for the archive record of the hospital account.
13 ARCHIVE_DT DATETIME No
The date the hospital account was archived.
14 REC_CREATE_USER_ID VARCHAR No
This column stores the unique identifier for the user who created the hospital account.
15 REC_CREATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
16 REGIONAL_STUDY_1 VARCHAR No
This column stores the Regional study 1, which is one of the coding info items.
17 REGIONAL_STUDY_2 VARCHAR No
This column stores the Regional study 2, which is one of the coding info items.
18 FACILITY_STUDY_A VARCHAR No
Facility study A is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
19 FACILITY_STUDY_B VARCHAR No
Facility study B is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
20 DECUBITIS_C_NAME VARCHAR No
Decubitis is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
May contain organization-specific values: Yes
Category Entries:
One
Two
Three
Four
21 TRAUMA_C_NAME VARCHAR No
Trauma is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
May contain organization-specific values: No
Category Entries:
One
Two
Three
Four
Five
Six
Seven
Eight
Nine
Ten
22 GEST_AGE_DAYS NUMERIC No
Gestational age days is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
23 GEST_AGE_BABY_DAYS NUMERIC No
Gestational (baby) age days is one of the coding info items. The abstract info tab in account maintenance can be configured to display these items.
24 ESOP_PAYOR_C_NAME VARCHAR No
This column stores the expected source of payment payer, which is a coding info item that stores the payer that is expected to pay for the services. This item is necessary for regulatory reporting in some states. The abstract info tab in account maintenance can be configured to display this item.
May contain organization-specific values: Yes
25 ESOP_PLAN_NAME_C_NAME VARCHAR No
Expected source of payment plan name is one of the coding info items. It stores the plan that is expected to pay for the services. This item is necessary for regulatory reporting in some states. The abstract info tab in account maintenance can be configured to display coding items.
May contain organization-specific values: Yes
26 ESOP_PLAN_TYPE_C_NAME VARCHAR No
Expected source of payment plan type is one of the coding info items. It stores the type of plan that is expected to pay for the services. This item is necessary for regulatory reporting in some states. The abstract info tab in account maintenance can be configured to display coding items.
May contain organization-specific values: Yes
27 CODING_USER VARCHAR No
This column stores the unique identifier for the user who last changed the coding status of the hospital account. This is frequently used to join to the CLARITY_EMP table.
28 CODING_USER_NAME VARCHAR No
The name of the user record. This name may be hidden.
29 APGAR_10_MIN FLOAT No
The Apgar score at ten minutes for the newborn associated with the hospital account. This is an abstracting item.
30 FRST_PRO_STMT_DT DATETIME No
This field contains the date of the first non-demand enterprise statement to be sent with a self-pay proration balance.
31 LST_PRO_STMT_DT DATETIME No
This field contains the date of the most recent non-demand enterprise statement to be sent with a self-pay proration balance.
32 NUM_PRO_STMTS INTEGER No
This field contains the total number of non-demand enterprise statements sent with a self-pay proration balance.
33 FRST_PRO_D_STMT_DT DATETIME No
This field contains the date of the first demand enterprise statement to be sent with a self-pay proration balance.
34 LST_PRO_D_STMT_DT DATETIME No
This field contains the date of the most recent demand enterprise statement to be sent with a self-pay proration balance.
35 NUM_PRO_D_STMTS INTEGER No
This field contains the total number of demand enterprise statements sent with a self-pay proration balance.
36 FRST_FULL_STMT_DT DATETIME No
This field contains the date of the first non-demand enterprise statement to be sent where the remaining account balance is completely self-pay.
37 LST_FULL_STMT_DT DATETIME No
This field contains the date of the most recent non-demand enterprise statement to be sent where the remaining account balance is completely self-pay.
38 NUM_FULL_STMTS INTEGER No
This field contains the total number of non-demand enterprise statements sent where the remaining account balance is completely self-pay.
39 FST_FULL_D_STMT_DT DATETIME No
This field contains the date of the first demand enterprise statement to be sent where the remaining account balance is completely self-pay.
40 LST_FULL_D_STMT_DT DATETIME No
This field contains the date of the most recent demand enterprise statement to be sent where the remaining account balance is completely self-pay.
41 NUM_FULL_D_STMTS INTEGER No
This field contains the total number of demand enterprise statements sent where the remaining account balance is completely self-pay.
42 FIRST_SELF_PAY_DT DATETIME No
This field contains the date of the first self-pay balance for this account.
43 FIRST_FULL_SP_DT DATETIME No
This field contains the first date when the self-pay balance equaled the full account balance for this account.
44 STILLBORN_YN VARCHAR No
Indicates whether a pregnancy resulted in a stillbirth. This is an abstracting item.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
45 NUM_LIVE_BIRTHS INTEGER No
This column contains the abstracted number of children that were born alive for the hospital account encounter.
46 FIRST_INFO_STMT_DT DATETIME No
This field contains the date of the first non-demand enterprise statement to be sent with no self-pay balance (only insurance balance).
47 LAST_INFO_STMT_DT DATETIME No
This field contains the date of the most recent non-demand enterprise statement to be sent with no self-pay balance (only insurance balance).
48 LAST_D_INFO_STM_DT DATETIME No
This field contains the date of the most recent demand enterprise statement to be sent with no self-pay balance (only insurance balance).
49 NUM_D_INFO_STMTS INTEGER No
This field contains the total number of demand enterprise statements sent with no self-pay balance (only insurance balance).
50 FARM_ACCIDENT_YN VARCHAR No
This column stores whether or not the hospital account was abstracted as a farm accident. 0-No or 1-Yes.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
51 EXTERN_AR_FLAG_YN VARCHAR No
External A/R Flag. This flag determines if an account's A/R is to be counted as belonging to an external agency (i.e., as bad debt). This flag is set by a collections action and can be unset by another action. This flag is only used if external agency A/R has been enabled.
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
52 PRIMARY_CONTACT VARCHAR No
This column stores the primary contact date (DAT) of the hospital account. It's used in many places, such as in determining the admission/discharge date of the account.
53 NUM_STILLBORNS INTEGER No
This column contains the abstracted number of stillborns for the hospital account.
54 HOSP_INFECTION_YN VARCHAR No
Indicates whether the patient developed a hospital infection during the hospital account encounter.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
55 RAPID_RESP_TEAM_YN VARCHAR No
Indicates whether a rapid response team was needed during the hospital account encounter.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
56 RETURN_TO_OR_YN VARCHAR No
Indicates whether the patient was returned to operating room. This is an abstracting item.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN
57 NONCVRD_SNF_STAY_YN VARCHAR No
This column stores whether the Skilled Nursing Facility (SNF) stay billed on this account is non-covered due to not having a prior qualifying inpatient stay.
The category values for this column were already listed for column: OPEN_DENIAL_BDC_YN