HSP_ACCT_DX_LIST
Description:
This table contains hospital account final diagnosis list information from the Hospital Accounts Receivable (HAR) master file.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
The ID number of a hospital account.
2 LINE INTEGER No
The line number in the results of a query. Since multiple final ICD diagnoses can be stored in one hospital account, each diagnosis will have a unique line number. The record associated with line 1 represents the principal final coded diagnosis.
3 DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
4 DX_AFFECTS_DRG_YN VARCHAR No
Specifies if the diagnosis affects the diagnosis-related group (DRG) associated with the hospital account. 1-yes, 2-no
May contain organization-specific values: No
Category Entries:
Yes
No
5 DX_COMORBIDITY_YN VARCHAR No
Specifies if the diagnosis is a non-complication/comorbidity ("N"), complication/comorbidity ("Y"), or major complication/comorbidity ("Y"). Note that this column is extracted as an explicit "N" or "Y", where "Y" is used for both CC and MCC. The updated column DX_COMORBIDITY_C can be used to distinguish between CC and MCC diagnoses.
May contain organization-specific values: No
Category Entries:
CC
No
MCC
6 FINAL_DX_SOI_C_NAME VARCHAR No
Stores the final diagnosis severity of illness
May contain organization-specific values: No
Category Entries:
Refinement not possible
Minor
Moderate
Major
Extreme
Principal Dx Used for SOI/ROM Calc
Excluded
Duplicate Diagnosis
Excluded Complication of Care
7 FINAL_DX_ROM_C_NAME VARCHAR No
Stores the final diagnosis risk of mortality
The category values for this column were already listed for column: FINAL_DX_SOI_C_NAME
8 FINAL_DX_EXCLD_YN VARCHAR No
Stores whether the final diagnosis should be excluded from clinical reporting
The category values for this column were already listed for column: DX_AFFECTS_DRG_YN
9 FNL_DX_AFCT_SOI_YN VARCHAR No
Stores whether the diagnosis affects severity of illness.
The category values for this column were already listed for column: DX_AFFECTS_DRG_YN
10 FNL_DX_AFCT_ROM_YN VARCHAR No
Stores whether the diagnosis affects risk of mortality.
The category values for this column were already listed for column: DX_AFFECTS_DRG_YN
11 FINAL_DX_POA_C_NAME VARCHAR No
Specifies whether each diagnosis was present on admission.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Unknown
Clinically Undetermined
Exempt from POA reporting
12 DX_COMORBIDITY_C_NAME VARCHAR No
Specifies if complication / comorbidity exists for each diagnosis on the hospital account.
The category values for this column were already listed for column: DX_COMORBIDITY_YN
13 DX_HAC_YN VARCHAR No
Specifies if the diagnosis contributed to a Hospital Acquired Condition.
May contain organization-specific values: No
Category Entries:
No
Yes
14 DX_COF_C_NAME VARCHAR No
The COF (Condition Onset Flag) for the diagnosis. This item describes whether the diagnosis is onset during the episode (on) or outside of the timeframe of the episode (not).
May contain organization-specific values: No
Category Entries:
Onset during the episode
Not arising during the episode
15 DX_COMPLEXITY_LVL INTEGER No
The diagnosis complexity level - the complexity weight assigned to the diagnosis in relation to the DRG.
16 COMPLEX_DX_C_NAME VARCHAR No
The complex diagnosis indicator for the diagnosis code.
May contain organization-specific values: No
Category Entries:
Complex Diagnosis
17 DX_CLASS_C_NAME VARCHAR No
The diagnosis classification.
May contain organization-specific values: Yes
Category Entries:
Autopsy Report
Cause of Death
Complication
New Case
Nosocomial
Other Hospital Acquired
Primigravida
Primary C-Section
Rule-Out
18 CAUSE_DEATH_YN VARCHAR No
This field indicates whether the diagnosis is a cause of death for the patient.
The category values for this column were already listed for column: DX_HAC_YN
19 DX_CLUSTER VARCHAR No
This item stores the diagnosis cluster identifier.