Table: dbo.Employee_W2_In_Process_Rendering_Queue
This table acts as a queue of employees which are in the process W2 document rendering. It provides the ability to roll the employees back into the Employee_W2_Rendering_Queue table if the w2 rendering user session dies, or the cron task is cancelled.
Columns
NameTypeConstraintsDescription
employee_KEYint (4)NOT NULLPrimary key for the employee that is in the process of W2 document rendering.
Primary key
NameColumnsDescription
PK_Employee_W2_In_Process_Rendering_Queue$employee_KEYemployee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W2_In_Process_Rendering_Queue__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram