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.