FIN_ASST_CASE_RLA_UPD_HX

Description:

This table contains information about the patient contacts that are on a financial assistance case at the time of each update. Each row represents one patient contact associated with a single update on the 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 (.1 item) for the financial assistance case record.
2	GROUP_LINE	INTEGER	No
	The line number of the update in the financial assistance case record. Together with FIN_ASST_CASE_ID, this forms the foreign key to the FIN_ASST_CASE_UPDATE_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple patient contacts associated with the financial assistance case record and the update from the FIN_ASST_CASE_UPDATE_HX table.
4	UPDATED_PAT_RELATIONSHIP_ID	NUMERIC	No
	The unique ID of the patient contact record for the patient contact on the case after an update was made.