HSP_ACCOUNT_3
Description:
This table contains hospital account information from the Hospital Accounts Receivable (HAR) master file. This third hospital account table has the same basic structure as HSP_ACCOUNT and HSP_ACCOUNT_2, but was created as a third table to prevent the other tables from getting any larger. This table will exclude professional billing hospital account records 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 ISS_TRAUMA INTEGER No
The trauma "Injury Severity Score" (1-75)
3 ADMIT_TYPE_EPT_C_NAME VARCHAR No
Admit type as stored on patient record.
May contain organization-specific values: Yes
4 PAT_STS_EPT_C_NAME VARCHAR No
Patient Status as stored on patient record.
May contain organization-specific values: Yes
5 PMTPLN_EST_INIT_BAL NUMERIC No
This column stores the initial estimated payment plan balance for the hospital account.
6 IP_ADMIT_DATE_TIME DATETIME No
This column indicates the inpatient admission date and time that has been stored in the hospital account. This may differ from the admission date and represents the date a patient was admitted with an IP base class.
7 NEW_CANCER_YNU VARCHAR No
This column stores a yes/no/unknown record of whether or not a patient's cancer is new.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
8 HYPERALIMENT_DAYS INTEGER No
This column stores the number of days that a patient received hyperalimentation therapy.
9 BAD_DEBT_FLAG_YN VARCHAR No
Bad Debt Flag. This flag determines if an account's non-prebilled balance is in bad debt. This is only used if account-based bad debt is used.
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
10 PAT_HOUSE_NUM VARCHAR No
House number in the address in patient demographic information on a hospital account. Added to support international address formats.
11 FAC_TRANS_FROM_C_NAME VARCHAR No
The facility the patient was transferred from prior to their stay.
May contain organization-specific values: Yes
No Entries Defined
12 FAC_TRANS_TO_C_NAME VARCHAR No
The facility the patient was transferred to after their stay.
The category values for this column were already listed for column: FAC_TRANS_FROM_C_NAME
13 TISSUE_REMOVED_YN VARCHAR No
This item represents if tissue was removed during surgery.
May contain organization-specific values: No
Category Entries:
No
Yes
14 READMIT_RLTD_YN VARCHAR No
This item represents if the patient was readmitted for a related reason.
The category values for this column were already listed for column: TISSUE_REMOVED_YN
15 WNDCARE_PRVD_YN VARCHAR No
This item represents if wound care was provided during this visit.
The category values for this column were already listed for column: TISSUE_REMOVED_YN
16 OSHPD_ADM_SITE_C_NAME VARCHAR No
The OSHPD admission site category number for this hospital account. This data is populated by coders in the abstracting activity. The abstracting activity must be configured to include this field to use this.
May contain organization-specific values: Yes
No Entries Defined
17 OSHPD_LIC_SITE_C_NAME VARCHAR No
The OSHPD licensure of site category number for this hospital account. This data is populated by coders in the abstracting activity. The abstracting activity must be configured to include this field to use this.
May contain organization-specific values: Yes
No Entries Defined
18 OSHPD_RTE_ADM_C_NAME VARCHAR No
The OSHPD route of admission category number for this hospital account. This data is populated by coders in the abstracting activity. The abstracting activity must be configured to include this field to use this.
May contain organization-specific values: Yes
No Entries Defined
19 OSHPD_TYP_CARE_C_NAME VARCHAR No
The OSHPD patient's type of care category number for this hospital account. This data is populated by coders in the abstracting activity. The abstracting activity must be configured to include this field to use this.
May contain organization-specific values: Yes
No Entries Defined
20 HAS_OPEN_OVRP_BD_YN VARCHAR No
Indicates whether the hospital account has open overpayment records.
The category values for this column were already listed for column: TISSUE_REMOVED_YN
21 EBC_BIRTH_DT_TM DATETIME No
The date and time of birth on the electronic birth certificate for the child that is associated with this hospital account.
22 HH_HSB_ID NUMERIC No
This column stores the unique identifier for the home health summary block that is associated with this hospital account.
23 SELF_PAY_YN VARCHAR No
Indicates whether this hospital account is self-pay.
The category values for this column were already listed for column: TISSUE_REMOVED_YN
24 EBC_LAST_MENSES_FT VARCHAR No
The date of the mother's last normal menses prior to the birth.
25 SBO_SPLIT_HAR_ID NUMERIC No
This column stores the unique identifier for a mixed hospital account used with splits in shared-mode single billing office. This will be populated on professional billing-only hospital accounts that were created as the result of splitting a mixed hospital account.
26 BILL_DRG_QLFR_C_NAME VARCHAR No
This column stores the additional diagnosis-related group (DRG) qualifier for the billing DRG type and code.
May contain organization-specific values: Yes
Category Entries:
HAC Dx Included
Analyzed DRG
Admission DRG
PPC DRG
PPC Admit DRG
27 ACTUAL_COPAY_AMT NUMERIC No
For all insurance buckets of the last coverage in the filing order, the total copay specified by insurance on payments.
28 ACTUAL_COINS_AMT NUMERIC No
For all insurance buckets of the last coverage in the filing order, the total coinsurance specified by insurance on payments.
29 ACTUAL_DED_AMT NUMERIC No
For all insurance buckets of the last coverage in the filing order, the total deductible specified by insurance on payments.
30 SBO_BILL_AREA_ID NUMERIC No
Save the bill area associated with HAR. Currently it is only set when the one PB HAR per bill area logic is used.
31 SBO_BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
32 MYC_LST_ST_VW_DTTM DATETIME (UTC) No
This column stores the date and time when this Hospital Billing statement was last viewed in MyChart for this hospital account. If you are using hospital account-level statements, this field will be updated when that specific hospital account statement is viewed in MyChart. If you are using guarantor-level statements, then this field will be updated when a guarantor statement that includes this hospital account is viewed in MyChart. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
33 MYC_LST_DB_VW_DTTM DATETIME (UTC) No
This column stores the date and time when a Hospital Billing detail bill was last viewed in MyChart for this hospital account. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
34 MYC_LST_LTR_VW_DTTM DATETIME (UTC) No
This column stores the date and time when a Hospital Billing letter was last viewed in MyChart for this hospital account. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
35 CDI_SPECIALIST_ID VARCHAR No
Stores the person responsible for the CDI process.
36 CDI_SPECIALIST_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
37 CDI_START_DATE DATETIME No
Stores the date the CDI review started.
38 CDI_LAST_RVW_DATE DATETIME No
Stores the last date the CDI review was done.
39 CDI_DRG_CHANGED_YN VARCHAR No
This column indicates whether the clinical documentation improvement (CDI) queries resulted in a DRG change.
May contain organization-specific values: No
Category Entries:
Yes
No
40 CDI_INITIAL_DRG_ID VARCHAR No
Stores the initial DRG before the CDI review is complete.
41 CDI_INITIAL_DRG_ID_DRG_NAME VARCHAR No
The name of the Diagnoses Related Group name.
42 CDI_INITIAL_REIMB NUMERIC No
Stores the expected reimbursement based on the initial DRG.
43 CDI_INITIAL_DRG_WT NUMERIC No
Stores the initial DRG weight.
44 CDI_WORKING_DRG_ID VARCHAR No
Stores the working DRG assigned by the CDI specialist.
45 CDI_WORKING_DRG_ID_DRG_NAME VARCHAR No
The name of the Diagnoses Related Group name.
46 CDI_WORKING_REIMB NUMERIC No
Stores the expected reimbursement based on the working DRG.
47 CDI_WORKING_DRG_WT NUMERIC No
Stores the working DRG weight.
48 CDI_PRIMARY_DX_ID NUMERIC No
Stores the primary diagnosis identified by the CDI specialist.
49 CDI_DRG_MATCH_YN VARCHAR No
Indicates whether the final DRG selected by the coder matches the working DRG specified by the CDI specialist.
The category values for this column were already listed for column: CDI_DRG_CHANGED_YN
50 BP_DIASTOLIC NUMERIC No
Diastolic Blood Pressure
51 PULSE NUMERIC No
The pulse for the patient on the hospital account. This is an abstracting item. The data can be configured to copy from the first pulse taken on the primary contact.
52 BP_SYSTOLIC NUMERIC No
Systolic Blood Pressure
53 PRELIM_COD_DX_ID NUMERIC No
This item contains the Preliminary Cause of Death as entered by a coder.
54 COD_RECORD_ID NUMERIC No
This column stores the unique identifier for the coding record for CDI that is associated with the hospital account.
55 CMS_OP_ESRD_STRT_DT DATETIME No
This column stores the date the patient started to receive maintenance dialysis treatments for end-stage renal disease (ESRD).
56 CMS_OP_ESRD_DX_G_DT DATETIME No
The first date that the acute comorbidity of gastrointestinal bleeding was present during maintenance dialysis treatments for ESRD.
57 CMS_OP_ESRD_DX_B_DT DATETIME No
This column stores the first date the acute comorbidity of bacterial pneumonia was present during maintenance dialysis treatments for end-stage renal disease (ESRD).
58 CMS_OP_ESRD_DX_P_DT DATETIME No
The first date that the acute comorbidity of pericarditis was present during maintenance dialysis treatments for ESRD.
59 BILLING_DRG_SRC_C_NAME VARCHAR No
This virtual item displays the source code set of the billing DRG.
May contain organization-specific values: No
Category Entries:
Primary Code Set
Alternate Code Set
60 NYS_PROC_STRT_DTTM DATETIME No
The start date and time that the ambulatory surgery patient entered the operating room exclusive of pre-op (preparation) and post-op (recovery) time. This is used for New York SPARCS reporting.
61 NYS_PROC_END_DTTM DATETIME No
The end date and time that the ambulatory surgery patient left the operating room exclusive of pre-op (preparation) and post-op (recovery) time. This is used for New York SPARCS reporting.