HSP_ACCT_EXTINJ_CD
Description:
This table contains hospital account external injury codes 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
This column stores the unique identifier for the hospital account.
2 LINE INTEGER No
This column stores the line number in the results of a query. Because multiple external injury codes can be stored in one hospital account, each code will have a unique line number.
3 EXT_INJURY_DX_ID NUMERIC No
This column stores the system identifier of a external injury code stored in the hospital account.
4 EXT_INJURY_POA_YNU VARCHAR No
This column specifies whether each External Cause of Injury Code diagnosis was present on admission. ** Note: this column was deprecated in the Spring 2008 release.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Unknown
Clinically Undetermined
Exempt from POA reporting
5 EXT_COMORBIDITY_YN VARCHAR No
This column specifies whether the External Cause of Injury Code 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 complication or comorbidity (CC) and major complication or comorbidity (MCC). The updated column EXT_COMORBIDITY_C can be used to distinguish between CC and MCC diagnoses.
May contain organization-specific values: No
Category Entries:
CC
No
MCC
6 EXT_DX_AFF_DRG_YN VARCHAR No
This column specifies whether the External Cause of Injury Code diagnosis affects the diagnosis-related group (DRG) associated with the hospital account. A null value for this column indicates no.
May contain organization-specific values: No
Category Entries:
Yes
No
7 ECODE_DX_SOI_C_NAME VARCHAR No
External Cause of Injury Code 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
8 ECODE_DX_ROM_C_NAME VARCHAR No
External Cause of Injury Code diagnosis risk of mortality
The category values for this column were already listed for column: ECODE_DX_SOI_C_NAME
9 ECODE_DX_EXCLD_YN VARCHAR No
External Cause of Injury Code diagnosis exclude from clinical reporting
The category values for this column were already listed for column: EXT_DX_AFF_DRG_YN
10 ECD_DX_AFCT_SOI_YN VARCHAR No
External Cause of Injury Code diagnosis affects severity of illness
The category values for this column were already listed for column: EXT_DX_AFF_DRG_YN
11 ECD_DX_AFCT_ROM_YN VARCHAR No
External Cause of Injury Code diagnosis affects risk of mortality
The category values for this column were already listed for column: EXT_DX_AFF_DRG_YN
12 ECODE_DX_POA_C_NAME VARCHAR No
This column stores whether each External Cause of Injury Code diagnosis was present on admission. This column links to category table ZC_DX_POA.
The category values for this column were already listed for column: EXT_INJURY_POA_YNU
13 EXT_COMORBIDITY_C_NAME VARCHAR No
Specifies if complication/comorbidity exists for each External Cause of Injury Code diagnosis on the hospital account.
The category values for this column were already listed for column: EXT_COMORBIDITY_YN
14 ECD_HAC_YN VARCHAR No
Specifies if the External Cause of Injury Code diagnosis contributed to a Hospital Acquired Condition.
May contain organization-specific values: No
Category Entries:
No
Yes