A table to hold Box 12 other items for employees. This allows Box 12 items without association to a pay item |
employee_w2_box_12_other_item_KEY | int (4) | NOT NULL | Primary key for this table |
employee_KEY | int (4) | NOT NULL | The employee key for this Box 12 item. This field combined with the processing_year and the w2_compensation_code_type_KEY fields must be unique |
w2_compensation_code_type_KEY | int (4) | NOT NULL | The w2 compensation code type for this Box 12 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 12 item is valid. This field combined with the employee_KEY and the w2_compensation_code_type_KEY fields must be unique |
amount | decimal (9, 2) | NOT NULL | The amount for this Box 12 item |