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