Table to track employee w2 forms pending transmission to ESS |
employee_self_service_w2_queue_KEY | int (4) | NOT NULL | Primary Key; queue of employee w2 forms pending transmission to ESS |
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key; queue of all data pending transmission to Web Services |
employee_KEY | int (4) | NOT NULL | Foreign key; related employee PK |
form_year | int (4) | NOT NULL | Year associated with the W2 form |
w2_file | varbinary (-1) | NOT NULL | Embedded employee w2 PDF file. Null only for w2s generated before 2010.3.7 update. |