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
Name | Type | Constraints | Description
ste_location_code | nvarchar (70) | NOT NULL | Primary key column
feature_code | nvarchar (60) | NOT NULL | Feature code for this specific location.
state__ste_location_code | nvarchar (70) | NOT NULL | Contains the value from the Ste_State_Code table for the state related to this feature.
county__ste_location_code | nvarchar (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
Name | Columns | Description
PK_Ste_Feature_Code$ste_location_code | ste_location_code |
Unique constraints
Name | Columns | Description
UK_Ste_Feature_Code$ste_location_code | ste_location_code |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ste_Feature_Code__Ste_County__county__ste_location_code | county__ste_location_code | Ste_County (ste_location_code) |
FK_Ste_Feature_Code__Ste_Location_Code__ste_location_code | ste_location_code | Ste_Location_Code (ste_location_code) |
FK_Ste_Feature_Code__Ste_State_Code__state__ste_location_code | state__ste_location_code | Ste_State_Code (ste_location_code) |