Table: dbo.Employee_Federal_Levy_Information
This table is required for employee payroll items that are of garnishment type Federal levy. It holds information about the federal levy
Columns
NameTypeConstraintsDescription
employee_payroll_item_KEYint (4)NOT NULLPrimary key and foregin key to the Employee Payroll Item table for garnishment types of Federal levy.
federal_levy_exemption_type_KEYint (4)NOT NULLForegin key to a subset the federal levy exemption type table. Filing status values are only valid.
order_datesmalldatetime (4)Optional date when this levy should start being deducted from pay. If null deduct from pay.
personal_exemptionsint (4)NOT NULLPersonal exemptions this employee has. This relates to how much pay is exempt from the federal levy.
additional_standard_deductionsint (4)NOT NULLAdditional standard deductions this employee has. This relates to how much pay is exempt from the federal levy.
Primary key
NameColumnsDescription
PK_Employee_Federal_Levy_Information$employee_payroll_item_KEYemployee_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Federal_Levy_Information__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Employee_Federal_Levy_Information__Federal_Levy_Exemption_Type__federal_levy_exemption_type_KEYfederal_levy_exemption_type_KEYFederal_Levy_Exemption_Type (federal_levy_exemption_type_KEY)

Schema diagram