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 NUMERIC No
The system ID number of a final diagnosis code stored in the hospital account.
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