AVOIDABLE_DAYS_CMT

Description:

This table contains the avoidable days comment. The primary key for the avoidable days comment table is Referral ID.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique ID of the referral record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated coverage in this patient's referral record. Together with REFERRAL_ID, this forms the foreign key to the REFERRAL_CVG_BED table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple comments that are associated with the coverage and the referral from the REFERRAL_CVG_BED table.
4	PADS_COMMENT	VARCHAR	No
	The coverage level PADS comment.