Table: dbo.Ste_County
Columns
Name | Type | Constraints | Description
ste_county_KEY | int (4) | NOT NULL | Primary key.
ste_state_code_KEY | nvarchar (4) | NOT NULL | Foreign key link to Ste_State_Code record having state name and postal code.
county | nvarchar (50) | NOT NULL | County name. The Symmetry calculation engine is the source of the county names.
ste_county_code | nvarchar (6) | NOT NULL | STE County code. The Symmetry calculation engine is the source of the county code.
ste_location_code | nvarchar (70) | NOT NULL | Contains the complete ste location code associated with given county code.

Primary key
Name | Columns | Description
PK_Ste_County | ste_county_KEY |
Unique constraints
Name | Columns | Description
UK_Ste_County$ste_location_code | ste_location_code |
UK_Ste_County$ste_state_code_KEY$county | ste_state_code_KEY, county |
UK_Ste_County$ste_state_code_KEY$ste_county_code | ste_state_code_KEY, ste_county_code |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ste_County__Ste_Location_Code__ste_location_code | ste_location_code | Ste_Location_Code (ste_location_code) |
FK_Ste_County__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ste_Feature_Code__Ste_County__county__ste_location_code | county__ste_location_code | Ste_Feature_Code |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Ste_County__ste_county_KEY | ste_county_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Creditor_Garnishment_Order__Ste_County__ste_county_KEY | ste_county_KEY | Creditor_Garnishment_Order |
FK_Child_Support_Order__Ste_County__ste_county_KEY | ste_county_KEY | Child_Support_Order |
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_County__ste_county_KEY | ste_county_KEY | Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail |
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Ste_County__ste_county_KEY | ste_county_KEY | Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail |