Table: dbo.Contact_Address_Payroll_Information
Columns
NameTypeConstraintsDescription
contact_address_KEYint (4)NOT NULLcontact_address_KEY
school_district_codenvarchar (100)NOT NULLThe school district code that is a part of the ste_tax_code from Symmetry. If this needs to be modified Client_Tax_Item.ste_tax_code may need the updating also.
school_district_descriptionnvarchar (100)NOT NULLschool_district_description
municipality_codenvarchar (100)NOT NULLThe municipality code that is a part of the ste_tax_code from Symmetry. If this needs to be modified Client_Tax_Item.ste_tax_code may need the updating also.
municipality_descriptionnvarchar (100)NOT NULLmunicipality_description
Primary key
NameColumnsDescription
PK_Contact_Address_Payroll_Information$contact_address_KEYcontact_address_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Contact_Address_Payroll_Information__Contact_Address__contact_address_KEYcontact_address_KEYContact_Address (contact_address_KEY)

Schema diagram