STREET_ADDRESS_CHANGE_VAL

Description:

This table contains a list of street address lines used to store the street address changes for a patient.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	GROUP_LINE	INTEGER	No
	The line number of the associated street address change in this patient record. Together with PAT_ID, this forms the foreign key to the STREET_ADDRESS_CHANGE_HX table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple street address lines that are associated with the patient and the address change from the STREET_ADDRESS_CHANGE_HX table.
4	STREET_ADDRESS	VARCHAR	No
	Audit trail item used to store the previous street address when a new street address is entered or if the current primary address is edited.