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) |