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
NameTypeConstraintsDescription
federal_levy_exemption_amount_KEYint (4)NOT NULLPrimary key.
starting_effective_datesmalldatetime (4)NOT NULLDate when the deduction became valid.
federal_levy_exemption_type_KEYint (4)NOT NULLForegin key to the federal levy exemption type table.
amountdecimal (9, 2)NOT NULLThe deduction amount.
Primary key
NameColumnsDescription
PK_Federal_Levy_Exemption_Amountfederal_levy_exemption_amount_KEY
Unique constraints
NameColumnsDescription
UK_Federal_Levy_Exemption_Amount$starting_effective_date$federal_levy_exemption_type_KEYstarting_effective_date, federal_levy_exemption_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Federal_Levy_Exemption_Amount__Federal_Levy_Exemption_Type__federal_levy_exemption_type_KEYfederal_levy_exemption_type_KEYFederal_Levy_Exemption_Type (federal_levy_exemption_type_KEY)

Schema diagram