Table: dbo.Federal_Levy_Exemption_Amount
This table stores federal levy exemption values that will be updated via schema update when tax laws change these values. These values determine how much of an employees pay is exempt from federal levies.
Columns
Name | Type | Constraints | Description
federal_levy_exemption_amount_KEY | int (4) | NOT NULL | Primary key.
starting_effective_date | smalldatetime (4) | NOT NULL | Date when the deduction became valid.
federal_levy_exemption_type_KEY | int (4) | NOT NULL | Foregin key to the federal levy exemption type table.
amount | decimal (9, 2) | NOT NULL | The deduction amount.

Primary key
Name | Columns | Description
PK_Federal_Levy_Exemption_Amount | federal_levy_exemption_amount_KEY |
Unique constraints
Name | Columns | Description
UK_Federal_Levy_Exemption_Amount$starting_effective_date$federal_levy_exemption_type_KEY | starting_effective_date, federal_levy_exemption_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Federal_Levy_Exemption_Amount__Federal_Levy_Exemption_Type__federal_levy_exemption_type_KEY | federal_levy_exemption_type_KEY | Federal_Levy_Exemption_Type (federal_levy_exemption_type_KEY) |