HSP_ACCT_CPT_ASSOC_DX

Description:

This table stores the diagnoses that are linked to a coded Current Procedural Terminology (CPT)/Healthcare Common Procedure Coding System (HCPCS) code on a hospital account.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	ACCT_ID	NUMERIC	No
	The unique identifier for the hospital account record.
2	GROUP_LINE	INTEGER	No
	The line number of the CPT©/HCPCS code stored on the hospital account to which the diagnoses are linked.
3	VALUE_LINE	INTEGER	No
	The line number of an associated diagnosis linked to a specific CPT©/HCPCS code on a hospital account.
4	CPT_LINKED_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.