HSP_ACCT_FINDX_ALT
Description:
This table contains the hospital account alternate final diagnoses from the hospital account (HAR) master file. Alternate final diagnoses will be specified if hospital accounts are coded with two sets of ICD codes.

Primary Key
Column Name Ordinal Position
ACCT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCT_ID NUMERIC No
The unique identifier for the hospital account record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 FIN_DX_ALT_ID NUMERIC No
The alternate final diagnoses stored in the hospital account.
4 FIN_DX_ALT_EXCLD_YN VARCHAR No
The alternate final diagnosis exclude from clinical reporting data.
May contain organization-specific values: No
Category Entries:
Yes
No
5 FIN_DX_ALT_POA_C_NAME VARCHAR No
The alternate final diagnosis present on admission data.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Unknown
Clinically Undetermined
Exempt from POA reporting
6 FIN_DX_ALT_CC_C_NAME VARCHAR No
The alternate final diagnosis complication / comorbidity data.
May contain organization-specific values: No
Category Entries:
CC
No
MCC
7 FIN_DX_ALT_HAC_YN VARCHAR No
The alternate final diagnosis hospital acquired condition data.
May contain organization-specific values: No
Category Entries:
No
Yes
8 FIN_DX_ALT_AFDRG_YN VARCHAR No
The alternate final diagnosis affects DRG data.
The category values for this column were already listed for column: FIN_DX_ALT_EXCLD_YN
9 FIN_DX_ALT_SOI_C_NAME VARCHAR No
The alternate final diagnosis severity of illness data.
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
10 FIN_DX_ALT_ROM_C_NAME VARCHAR No
The alternate final diagnosis risk of mortality data.
The category values for this column were already listed for column: FIN_DX_ALT_SOI_C_NAME
11 FIN_DX_ALT_AFSOI_YN VARCHAR No
The alternate final diagnosis affects severity of illness data.
The category values for this column were already listed for column: FIN_DX_ALT_EXCLD_YN
12 FIN_DX_ALT_AFROM_YN VARCHAR No
The alternate final diagnosis affects risk of mortality data.
The category values for this column were already listed for column: FIN_DX_ALT_EXCLD_YN