Table: dbo.Workforce_Hub_Punch_Category_Queue
This table contains the pay items and accruable benefit items that have been queued from ACS to send to Swipeclock WorkforceHub (Advanced) and WorkforceHub (Plus) as punch categories.
Columns
NameTypeConstraintsDescription
workforce_hub_punch_category_queue_KEYint (4)NOT NULLPrimary key
web_services_transmit_queue_KEYint (4)NOT NULLIndicates which Web_Services_Transmit_Queue this row is associated with.
client_payroll_item_KEYint (4)If a pay item exists that does not have an accruable benefit item with the exact same description, only the client_payroll_item_KEY value will be set.
client_benefit_KEYint (4)If an accruable benefit item exists that does not have a pay item with the exact same description, only the client_benefit_KEY value will be set.
Primary key
NameColumnsDescription
PK_Workforce_Hub_Punch_Category_Queueworkforce_hub_punch_category_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workforce_Hub_Punch_Category_Queue_web_services_transmit_queue_web_services_transmit_queue_KEYweb_services_transmit_queue_KEYWeb_Services_Transmit_Queue (web_services_transmit_queue_KEY)
FK_Workforce_Hub_Punch_Category_Queue__client_payroll_item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Workforce_Hub_Punch_Category_Queue__client_benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)

Schema diagram