Table: dbo.Employee_Political_Subdivision_Code_Override
This table stores override values for employee political subdivision codes. The employee can have at most one override for each client tax item.
Columns
NameTypeConstraintsDescription
employee_KEYint (4)NOT NULLThe key to the employee. This along with the client_tax_item_KEY make up the primary key
client_tax_item_KEYint (4)NOT NULLThe client tax item key associated to the ste tax code for this political subdivision code. This along with the employee_KEY make up the primary key
political_subdivision_code_overridevarchar (6)The value for the political subdivision code override.
employee_political_subdivision_code_override_KEYint (4)NOT NULLThe primary key to the table.
Primary key
NameColumnsDescription
PK_Employee_Political_Subdivision_Code_Overrideemployee_political_subdivision_code_override_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Political_Subdivision_Code_Override$employee_KEY$client_tax_item_KEYemployee_KEY, client_tax_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Political_Subdivision_Code_Override__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Employee_Political_Subdivision_Code_Override__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram