HSP_ACCT_ICDPX_ALT
Description:
This table contains the hospital account alternate ICD procedures from the hospital account (HAR) master file. Alternate ICD procedures 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 ICD_PX_ALT_ID VARCHAR No
The alternate ICD procedures stored in the hospital account.
4 ICD_PX_ALT_ID_ICD_PX_NAME VARCHAR No
The name of the ICD procedure record.
5 ICD_PX_ALT_DATE DATETIME No
The alternate ICD procedure service date.
6 ICD_PX_ALT_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
7 ICD_PX_ALT_EVNT_NUM INTEGER No
The alternate ICD procedure event link number.
8 ICD_PX_ALT_EXCLD_YN VARCHAR No
The alternate ICD procedure exclude from clinical reporting data.
May contain organization-specific values: No
Category Entries:
Yes
No
9 ICD_PX_ALT_AFSOI_YN VARCHAR No
The alternate ICD procedure affects severity of illness data.
The category values for this column were already listed for column: ICD_PX_ALT_EXCLD_YN
10 ICD_PX_ALT_AFROM_YN VARCHAR No
The alternate ICD procedure affects risk of mortality data.
The category values for this column were already listed for column: ICD_PX_ALT_EXCLD_YN