This table is required for employee payroll items that are of garnishment type Federal levy. It holds information about the federal levy |
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. |