Table: dbo.Contact_Address_Ste_Location_Code_History
Table which holds residency history for employees - the lack of a record in this table indicates the current employee address is the only one.
Columns
Name | Type | Constraints | Description
contact_address_ste_location_code_history_KEY | int (4) | NOT NULL | Primary key column
contact_address_KEY | int (4) | NOT NULL | Contains the value from the contact address table associated with this record.
ste_location_code | nvarchar (70) | NOT NULL | Contains the value from the STE location code table associated with this record.
residency_start_date | smalldatetime (4) | NOT NULL | Date this location was added as the employee residence.

Primary key
Name | Columns | Description
PK_Contact_Address_Ste_Location_Code_History | contact_address_ste_location_code_history_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Contact_Address_Ste_Location_Code_History__Contact_Address__contact_address_KEY | contact_address_KEY | Contact_Address (contact_address_KEY) |
FK_Contact_Address_Ste_Location_Code_History__Ste_Location_Code__ste_location_code | ste_location_code | Ste_Location_Code (ste_location_code) |