Table: dbo.Ste_State_Code
The Symmetry Tax Engine code to designate a county. This is a sub-type table of Ste_Location_Code. The contents of this table are pre-populated with all defined codes.
Columns
NameTypeConstraintsDescription
ste_state_code_KEYnvarchar (4)NOT NULLPrimary key for this table. Value provided by Symmetry.
namenvarchar (130)NOT NULLName of state / province (unique).
postal_codenvarchar (14)NOT NULLPostal abbreviation (unique).
countrynvarchar (40)NOT NULLCountry the state / province is in.
ste_location_codenvarchar (70)NOT NULLContains the complete ste location code associated with a given state code.
Primary key
NameColumnsDescription
PK_Ste_State_Codeste_state_code_KEY
Unique constraints
NameColumnsDescription
UK_Ste_State_Code$ste_location_codeste_location_code
UK_Ste_State_Code$namename
UK_Ste_State_Code$postal_codepostal_code
Foreign keys
NameColumnsReferenced tableDescription
FK_Ste_State_Code__Ste_Location_Code__ste_location_codeste_location_codeSte_Location_Code (ste_location_code)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Worker_Compensation_Class_Code_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYWorker_Compensation_Class_Code_Detail
FK_Tax_Form__Ste_State_Code__ste_state_code_KEYste_state_code_KEYTax_Form
FK_Tax_Agent__Ste_State_Code__ste_state_code_KEYste_state_code_KEYTax_Agent
FK_Suta_Supplemental_Type__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSuta_Supplemental_Type
FK_Ste_County__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_County
FK_Ste_Feature_Code_By_County__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_Feature_Code_By_County
FK_State_Definition__Ste_State_Code__ste_state_code_KEYste_state_code_KEYState_Definition
FK_Withholding_Deposit_Schedule__Ste_State_Code__ste_state_code_KEYste_state_code_KEYWithholding_Deposit_Schedule
FK_Ste_State_Misc_Parameter_Droplist_Item__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Misc_Parameter_Droplist_Item
FK_Minimum_Wage__Ste_State_Code__ste_state_code_KEYste_state_code_KEYMinimum_Wage
FK_Employee_Other_State_Setting_Type__Ste_State_Code__ste_state_code_KEYste_state_code_KEYEmployee_Other_State_Setting_Type
FK_STE_Filing_Status_State__Ste_State_Code__denormalized__ste_state_code_KEYdenormalized__ste_state_code_KEYSTE_Filing_Status_State
FK_STE_State_Misc_Parameter_Usage__Ste_State_Code__state_id__ste_state_code_KEYstate_idSTE_State_Misc_Parameter_Usage
FK_Tax_Form_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYTax_Form_Override
FK_Client_W2_State_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYClient_W2_State_Override
FK_Client_1099_State_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYClient_1099_State_Override
FK_Ste_Feature_Code__Ste_State_Code__state__ste_location_codestate__ste_location_codeSte_Feature_Code
FK_Firm__Ste_State_Code__new_hire_electronic_filing__ste_state_code_KEYnew_hire_electronic_filing__ste_state_code_KEYFirm
FK_Tax_Jurisdiction__Ste_State_Code__ste_state_code_KEYste_state_code_KEYTax_Jurisdiction
FK_Firm_Electronic_Filing_Information__Ste_State_Code__ste_state_code_KEYste_state_code_KEYFirm_Electronic_Filing_Information
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYBenefit_Item_Worker_Compensation_Exemption_Detail
FK_Client_Tax_Item__Ste_State_Code__denormalized__ste_state_code_KEYdenormalized__ste_state_code_KEYClient_Tax_Item
FK_Garnishment_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYGarnishment_Order
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_allowances__ste_state_code_KEYstate_allowances__ste_state_code_KEYImport_Template_Column_Employee_Data
FK_Import_Template_Column_Employee_Data__Ste_State_Code__state_filing_status__ste_state_code_KEYstate_filing_status__ste_state_code_KEYImport_Template_Column_Employee_Data
FK_Employee_W2_Rendered_Document__Ste_State_Code__ste_state_code_KEYste_state_code_KEYEmployee_W2_Rendered_Document
FK_Employee_W4_Setting__Ste_State_Code__ste_state_code_KEYste_state_code_KEYEmployee_W4_Setting
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYPayroll_Item_Worker_Compensation_Exemption_Detail
FK_Creditor_Garnishment_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYCreditor_Garnishment_Order
FK_Child_Support_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYChild_Support_Order
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYPayroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYPayroll_Check_Payroll_Item_Distribution_Child_Support_Detail
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYPayroll_Check_Payroll_Item_Distribution_Garnishment_Detail

Schema diagram