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