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
NameTypeConstraintsDescription
contact_address_ste_location_code_history_KEYint (4)NOT NULLPrimary key column
contact_address_KEYint (4)NOT NULLContains the value from the contact address table associated with this record.
ste_location_codenvarchar (70)NOT NULLContains the value from the STE location code table associated with this record.
residency_start_datesmalldatetime (4)NOT NULLDate this location was added as the employee residence.
Primary key
NameColumnsDescription
PK_Contact_Address_Ste_Location_Code_Historycontact_address_ste_location_code_history_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Address_Ste_Location_Code_History__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address (contact_address_KEY)
FK_Contact_Address_Ste_Location_Code_History__Ste_Location_Code__ste_location_codeste_location_codeSte_Location_Code (ste_location_code)

Schema diagram