HSP_ACCT_COND_HAR

Description:

This table contains hospital account claim condition codes from the Hospital Account Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACCT_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. Because multiple condition codes can be stored in one hospital account, each condition code will have a unique line number.
3	CONDITION_CODE_C_NAME	VARCHAR	No
	A condition code used for claims associated with the hospital account. May contain organization-specific values: Yes