Table: dbo.Ste_Feature_Code
The Symmetry Tax Engine code for a tax region other than a state or county. This is a sub-type table of Ste_Location_Code. Rows are added to this table as needed, using data retrieved from the STE.
Columns
NameTypeConstraintsDescription
ste_location_codenvarchar (70)NOT NULLPrimary key column
feature_codenvarchar (60)NOT NULLFeature code for this specific location.
state__ste_location_codenvarchar (70)NOT NULLContains the value from the Ste_State_Code table for the state related to this feature.
county__ste_location_codenvarchar (70)Contains the value from the Ste_County table for the county related to this feature unless the county code is 000 then null.
Primary key
NameColumnsDescription
PK_Ste_Feature_Code$ste_location_codeste_location_code
Unique constraints
NameColumnsDescription
UK_Ste_Feature_Code$ste_location_codeste_location_code
Foreign keys
NameColumnsReferenced tableDescription
FK_Ste_Feature_Code__Ste_County__county__ste_location_codecounty__ste_location_codeSte_County (ste_location_code)
FK_Ste_Feature_Code__Ste_Location_Code__ste_location_codeste_location_codeSte_Location_Code (ste_location_code)
FK_Ste_Feature_Code__Ste_State_Code__state__ste_location_codestate__ste_location_codeSte_State_Code (ste_location_code)

Schema diagram