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 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 |
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 (Local) | No |
This column indicates the inpatient admission date and time associated with the hospital account. This can differ from the admission date and time and represents the date and time 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 |
The bill area associated with the PB HAR. When set this indicates we are splitting PB HARs by bill area.
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_DX_NAME | VARCHAR | No |
The name of the diagnosis.
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_DX_NAME | VARCHAR | No |
The name of the diagnosis.
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.