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
Name | Type | Constraints | Description
workforce_hub_punch_category_queue_KEY | int (4) | NOT NULL | Primary key
web_services_transmit_queue_KEY | int (4) | NOT NULL | Indicates which Web_Services_Transmit_Queue this row is associated with.
client_payroll_item_KEY | int (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_KEY | int (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
Name | Columns | Description
PK_Workforce_Hub_Punch_Category_Queue | workforce_hub_punch_category_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workforce_Hub_Punch_Category_Queue_web_services_transmit_queue_web_services_transmit_queue_KEY | web_services_transmit_queue_KEY | Web_Services_Transmit_Queue (web_services_transmit_queue_KEY) |
FK_Workforce_Hub_Punch_Category_Queue__client_payroll_item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Workforce_Hub_Punch_Category_Queue__client_benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |