HSP_ACCT_ADMIT_DX

Description:

This table contains hospital account admit diagnoses 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. As multiple admission diagnoses can be stored in one hospital account, each diagnosis will have a unique line number.
3	ADMIT_DX_ID	NUMERIC	No
	This column stores the unique identifier for admission diagnosis stored in the hospital account.
4	ADMIT_DX_TEXT	VARCHAR	No
	A text description of an admission diagnosis stored in the hospital account.