Table: dbo.Tax_Code_Type
This table stores the various tax code types in the system that serve as tax categories. This table also stores the FAKE tax code types. Those FAKEs are added in to serve as placeholders that signify multiple tax code types and the multiple types are defined in the code. Local_Tax_Exemption_Type basically has a one to one relationship with Tax_Code_Type in the database and for certain exemption selections this needs to be one-to-many and the FAKEs allow the many to be specified in the code.
Columns
Name | Type | Constraints | Description
tax_code_type_KEY | int (4) | NOT NULL | Primary key for this table
tax_code | nvarchar (20) | NOT NULL | Tax code
description | nvarchar (100) | NOT NULL | Description
long_description | nvarchar (100) | NOT NULL | Long description

Primary key
Name | Columns | Description
PK_Tax_Code_Type | tax_code_type_KEY |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Local_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEY | employee__tax_code_type_KEY | Local_Tax_Exemption_Type |
FK_Local_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEY | employer__tax_code_type_KEY | Local_Tax_Exemption_Type |
FK_State_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEY | employee__tax_code_type_KEY | State_Tax_Exemption_Type |
FK_State_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEY | employer__tax_code_type_KEY | State_Tax_Exemption_Type |
FK_Federal_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEY | employee__tax_code_type_KEY | Federal_Tax_Exemption_Type |
FK_Federal_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEY | employer__tax_code_type_KEY | Federal_Tax_Exemption_Type |