TX_DIAG

Description:

This table contains information about the diagnoses associated with transactions. Since one transaction may be associated with multiple diagnoses, each row in this table represents one diagnosis and is identified by the transaction ID and line number. The first six diagnosis IDs associated with a transaction are recorded in the CLARITY_TDL table in the columns DX_ ONE_ID through DX_ SIX_ID. This table allows you to easily identify transactions with a specific diagnosis code or range of diagnosis codes. The data for this table is extracted using a KB_SQL query.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique accounts receivable transaction record ID.
2	LINE	INTEGER	No
	Line number to identify each row of diagnosis data associated with an individual transaction. Line 1 identifies the primary diagnosis of the charge.
3	POST_DATE	DATETIME	No
	The post date of the charge transaction
4	SERV_AREA_ID	NUMERIC	No
	The ID of the service area associated with the transaction identified by TX_ID.
5	DX_ID	NUMERIC	No
	The diagnosis associated with the charge transaction. This diagnosis is from the primary codeset.
6	DX_QUALIFIER_C_NAME	VARCHAR	No
	Diagnosis Qualifier for the diagnosis associated with this charge May contain organization-specific values: Yes