HSP_ACCT_ADMDX_ALT
Description:
This table contains the hospital account alternate admission diagnoses from the hospital account (HAR) master file. Alternate admission 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 ADMIT_DX_ALT_ID_DX_NAME VARCHAR No
The name of the diagnosis.
4 ADMIT_DX_ALT_CMT VARCHAR No
The alternate admission diagnosis comments.