A table to hold Box 14 other items for employees. This allows Box 14 items without association to a pay item |
employee_w2_box_14_other_item_KEY | int (4) | NOT NULL | Primary key for this table |
employee_KEY | int (4) | NOT NULL | The employee key for this Box 14 item. This field combined with the processing_year and the description fields must be unique |
description | nvarchar (50) | NOT NULL | The description displayed for this Box 14 item. This field combined with the processing_year and the employee_KEY fields must be unique |
processing_year | int (4) | NOT NULL | The year that this Box 14 item is valid. This field combined with the employee_KEY and the description fields must be unique |
amount | decimal (9, 2) | NOT NULL | The amount for this Box 14 item |