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
Name | Type | Constraints | Description
employee_payroll_item_KEY | int (4) | NOT NULL | Primary key and foregin key to the Employee Payroll Item table for garnishment types of Federal levy.
federal_levy_exemption_type_KEY | int (4) | NOT NULL | Foregin key to a subset the federal levy exemption type table. Filing status values are only valid.
order_date | smalldatetime (4) |  | Optional date when this levy should start being deducted from pay. If null deduct from pay.
personal_exemptions | int (4) | NOT NULL | Personal exemptions this employee has. This relates to how much pay is exempt from the federal levy.
additional_standard_deductions | int (4) | NOT NULL | Additional standard deductions this employee has. This relates to how much pay is exempt from the federal levy.

Primary key
Name | Columns | Description
PK_Employee_Federal_Levy_Information$employee_payroll_item_KEY | employee_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Federal_Levy_Information__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Employee_Federal_Levy_Information__Federal_Levy_Exemption_Type__federal_levy_exemption_type_KEY | federal_levy_exemption_type_KEY | Federal_Levy_Exemption_Type (federal_levy_exemption_type_KEY) |