HSP_TX_DIAG

Description:

This table contains hospital account transaction diagnoses from the Hospital Permanent Transactions (HTR) master file.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	This column stores the unique identifier for the hospital billing transaction.
2	LINE	INTEGER	No
	The line number in the results of a query. Because multiple diagnosis codes can be associated with one charge, each diagnosis will have a unique line number.
3	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account associated with the hospital billing transaction.
4	POST_DATE	DATETIME	No
	The post date of a transaction.
5	SERV_AREA_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
6	DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
7	DX_QUAL_HA_C_NAME	VARCHAR	No
	A qualifier entered with a diagnosis code in charge entry. May contain organization-specific values: Yes Category Entries: Active Inactive Acute Chronic Temporary