FIN_ASST_CASE_LNKD_TRKR

Description:

This table contains information on how financial assistance program trackers are linked to each other in a financial assistance case.

Primary Key

Column Name	Ordinal Position
FIN_ASST_CASE_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FIN_ASST_CASE_ID	NUMERIC	No
	The unique identifier for the financial assistance case record.
2	GROUP_LINE	INTEGER	No
	The line number of the group of the linked financial assistance trackers in the financial assistance case record. Together with FIN_ASST_CASE_ID, this forms the foreign key to the FIN_ASST_CASE_ASSOC_TRKR table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple financial assistance trackers associated with the financial assistance case from the FIN_ASST_CASE_ASSOC_TRKR table.
4	LINKED_FIN_ASST_TRACKER_ID	NUMERIC	No
	The unique ID of the financial assistance tracker that is part of a linked group. The financial assistance trackers in a linked group are edited as if they are one by the financial counselor. Updating one tracker will mean updating all the trackers in the linked group.