Table: dbo.Employee_Self_Service_1095_Queue
Table which persists employee 1095 pdf forms until they are transmitted to the Employee Self-Service portal
Columns
Name | Type | Constraints | Description
employee_self_service_1095_queue_KEY | int (4) | NOT NULL | Primary key column
web_services_transmit_queue_KEY | int (4) | NOT NULL | Foreign key to the Web_Services_Transmit_Queue table
employee_KEY | int (4) | NOT NULL | Foreign key to the Employee table
form_year | int (4) | NOT NULL | Four-digit year assocaited with the 1095 form
pdf_file | varbinary (-1) | NOT NULL | Embedded employee 1095 PDF file; a byte array of the pdf file contents

Primary key
Name | Columns | Description
PK_Employee_Self_Service_1095_Queue | employee_self_service_1095_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Self_Service_1095_Queue__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Self_Service_1095_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |