Table: dbo.Ste_County
Columns
NameTypeConstraintsDescription
ste_county_KEYint (4)NOT NULLPrimary key.
ste_state_code_KEYnvarchar (4)NOT NULLForeign key link to Ste_State_Code record having state name and postal code.
countynvarchar (50)NOT NULLCounty name. The Symmetry calculation engine is the source of the county names.
ste_county_codenvarchar (6)NOT NULLSTE County code. The Symmetry calculation engine is the source of the county code.
ste_location_codenvarchar (70)NOT NULLContains the complete ste location code associated with given county code.
Primary key
NameColumnsDescription
PK_Ste_Countyste_county_KEY
Unique constraints
NameColumnsDescription
UK_Ste_County$ste_location_codeste_location_code
UK_Ste_County$ste_state_code_KEY$countyste_state_code_KEY, county
UK_Ste_County$ste_state_code_KEY$ste_county_codeste_state_code_KEY, ste_county_code
Foreign keys
NameColumnsReferenced tableDescription
FK_Ste_County__Ste_Location_Code__ste_location_codeste_location_codeSte_Location_Code (ste_location_code)
FK_Ste_County__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ste_Feature_Code__Ste_County__county__ste_location_codecounty__ste_location_codeSte_Feature_Code
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Ste_County__ste_county_KEYste_county_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Creditor_Garnishment_Order__Ste_County__ste_county_KEYste_county_KEYCreditor_Garnishment_Order
FK_Child_Support_Order__Ste_County__ste_county_KEYste_county_KEYChild_Support_Order
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Ste_County__ste_county_KEYste_county_KEYPayroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Ste_County__ste_county_KEYste_county_KEYPayroll_Check_Payroll_Item_Distribution_Child_Support_Detail

Schema diagram