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
NameTypeConstraintsDescription
employee_self_service_1095_queue_KEYint (4)NOT NULLPrimary key column
web_services_transmit_queue_KEYint (4)NOT NULLForeign key to the Web_Services_Transmit_Queue table
employee_KEYint (4)NOT NULLForeign key to the Employee table
form_yearint (4)NOT NULLFour-digit year assocaited with the 1095 form
pdf_filevarbinary (-1)NOT NULLEmbedded employee 1095 PDF file; a byte array of the pdf file contents
Primary key
NameColumnsDescription
PK_Employee_Self_Service_1095_Queueemployee_self_service_1095_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Self_Service_1095_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Self_Service_1095_Queue__Web_Services_Transmit_Queue__web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)

Schema diagram