Table: dbo.Onvio_Payroll_Integration_Queue
This table stores data for Onvio Payroll Integration that need to be processed by Cron tasks.
Columns
Name | Type | Constraints | Description
onvio_payroll_integration_queue_KEY | int (4) | NOT NULL | The primary key used for identifying a record in the Onvio Payroll Integration Queue.
client_KEY | int (4) | NOT NULL | Used for identifying the client for the queue item.
onvio_payroll_integration_data_type_KEY | tinyint (1) | NOT NULL | Used for identifying the Onvio integration data type for the queue item.
onvio_payroll_integration_action_KEY | tinyint (1) | NOT NULL | Used for identifying the Onvio integration operation type for the queue item.
enqueued_time_utc | datetime (8, 3) | NOT NULL | Used to store the time when the row is added to the queue. Avoiding the DAL reserved column name of create_date_utc.
user_session_guid | uniqueidentifier (16) |  | The user session guid associated with the Cron task that is locking and processing a queue record.
status_url | nvarchar (-1) |  | status_url is the URL which the poll operation will query.
not_before_utc | datetime (8, 3) |  | not_before_utc is the time before which the system should not perform a poll operation. Check constraint for 1900-2078 is ommitted on purpose.
client_contact_payroll_administrator_KEY | int (4) |  | For operations on onvio_payroll_integration_data_type of Contact Payroll Administrator, and only that type,["BR"] the key of the entry in the table which promotes a particular contact to payroll administrator. NULL for other data type operations.

Primary key
Name | Columns | Description
PK_Onvio_Payroll_Integration_Queue | onvio_payroll_integration_queue_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Onvio_Payroll_Integration_Queue__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Onvio_Payroll_Integration_Queue__Onvio_Payroll_Integration_Data_Type__onvio_payroll_integration_data_type_KEY | onvio_payroll_integration_data_type_KEY | Onvio_Payroll_Integration_Data_Type (onvio_payroll_integration_data_type_KEY) |
FK_Onvio_Payroll_Integration_Queue__Onvio_Payroll_Integration_Action__onvio_payroll_integration_action_KEY | onvio_payroll_integration_action_KEY | Onvio_Payroll_Integration_Action (onvio_payroll_integration_action_KEY) |
FK_Onvio_Payroll_Integration_Queue__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |
FK_Onvio_Payroll_Integration_Queue__Client_Contact_Payroll_Administrator__client_contact_payroll_administrator_KEY | client_contact_payroll_administrator_KEY | Client_Contact_Payroll_Administrator (client_contact_payroll_administrator_KEY) |