HSP_ACCT_ECDDX_ALT
Description:
This table contains the hospital account alternate external cause of injury diagnoses from the hospital account (HAR) master file. Alternate external cause of injury 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 ECD_DX_ALT_ID NUMERIC No
The alternate external cause of injury diagnoses stored in the hospital account.
4 ECD_DX_ALT_EXCLD_YN VARCHAR No
The alternate external cause of injury diagnosis exclude from clinical reporting data.
May contain organization-specific values: No
Category Entries:
Yes
No
5 ECD_DX_ALT_POA_C_NAME VARCHAR No
The alternate external cause of injury diagnosis present on admission data.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Unknown
Clinically Undetermined
Exempt from POA reporting
6 ECD_DX_ALT_CC_C_NAME VARCHAR No
The alternate external cause of injury diagnosis complication / comorbidity data.
May contain organization-specific values: No
Category Entries:
CC
No
MCC
7 ECD_DX_ALT_HAC_YN VARCHAR No
The alternate external cause of injury diagnosis hospital acquired condition data.
May contain organization-specific values: No
Category Entries:
No
Yes
8 ECD_DX_ALT_AFDRG_YN VARCHAR No
The alternate external cause of injury diagnosis affects DRG data.
The category values for this column were already listed for column: ECD_DX_ALT_EXCLD_YN
9 ECD_DX_ALT_SOI_C_NAME VARCHAR No
The alternate external cause of injury 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 ECD_DX_ALT_ROM_C_NAME VARCHAR No
The alternate external cause of injury diagnosis risk of mortality data.
The category values for this column were already listed for column: ECD_DX_ALT_SOI_C_NAME
11 ECD_DX_ALT_AFSOI_YN VARCHAR No
The alternate external cause of injury diagnosis affects severity of illness data.
The category values for this column were already listed for column: ECD_DX_ALT_EXCLD_YN
12 ECD_DX_ALT_AFROM_YN VARCHAR No
The alternate external cause of injury diagnosis affects risk of mortality data.
The category values for this column were already listed for column: ECD_DX_ALT_EXCLD_YN