Table: dbo.Ste_Location_Code
Table which holds the super-type STE location codes. STE location codes are defined by the Symmetry Tax Engine (ste). This super type holds the complete location code for any location needed by the system.
Columns
NameTypeConstraintsDescription
ste_location_codenvarchar (70)NOT NULLPrimary key column
Primary key
NameColumnsDescription
PK_Ste_Location_Code$ste_location_codeste_location_code
Unique constraints
NameColumnsDescription
UK_Ste_Location_Code$ste_location_codeste_location_code
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ste_State_Code__Ste_Location_Code__ste_location_codeste_location_codeSte_State_Code
FK_Ste_County__Ste_Location_Code__ste_location_codeste_location_codeSte_County
FK_Contact_Address_Ste_Location_Code_History__Ste_Location_Code__ste_location_codeste_location_codeContact_Address_Ste_Location_Code_History
FK_Ste_Feature_Code__Ste_Location_Code__ste_location_codeste_location_codeSte_Feature_Code
FK_Employee__Ste_Location_Code__ste_location_codeste_location_codeEmployee

Schema diagram