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_DX_NAME | VARCHAR | No |
The name of the diagnosis.
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