Table: dbo.Onvio_Payroll_Integration_Queue
This table stores data for Onvio Payroll Integration that need to be processed by Cron tasks.
Columns
NameTypeConstraintsDescription
onvio_payroll_integration_queue_KEYint (4)NOT NULLThe primary key used for identifying a record in the Onvio Payroll Integration Queue.
client_KEYint (4)NOT NULLUsed for identifying the client for the queue item.
onvio_payroll_integration_data_type_KEYtinyint (1)NOT NULLUsed for identifying the Onvio integration data type for the queue item.
onvio_payroll_integration_action_KEYtinyint (1)NOT NULLUsed for identifying the Onvio integration operation type for the queue item.
enqueued_time_utcdatetime (8, 3)NOT NULLUsed to store the time when the row is added to the queue. Avoiding the DAL reserved column name of create_date_utc.
user_session_guiduniqueidentifier (16)The user session guid associated with the Cron task that is locking and processing a queue record.
status_urlnvarchar (-1)status_url is the URL which the poll operation will query.
not_before_utcdatetime (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_KEYint (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
NameColumnsDescription
PK_Onvio_Payroll_Integration_Queueonvio_payroll_integration_queue_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Onvio_Payroll_Integration_Queue__Client__client_KEYclient_KEYClient (client_KEY)
FK_Onvio_Payroll_Integration_Queue__Onvio_Payroll_Integration_Data_Type__onvio_payroll_integration_data_type_KEYonvio_payroll_integration_data_type_KEYOnvio_Payroll_Integration_Data_Type (onvio_payroll_integration_data_type_KEY)
FK_Onvio_Payroll_Integration_Queue__Onvio_Payroll_Integration_Action__onvio_payroll_integration_action_KEYonvio_payroll_integration_action_KEYOnvio_Payroll_Integration_Action (onvio_payroll_integration_action_KEY)
FK_Onvio_Payroll_Integration_Queue__User_Session__user_session_guiduser_session_guidUser_Session (user_session_guid)
FK_Onvio_Payroll_Integration_Queue__Client_Contact_Payroll_Administrator__client_contact_payroll_administrator_KEYclient_contact_payroll_administrator_KEYClient_Contact_Payroll_Administrator (client_contact_payroll_administrator_KEY)

Schema diagram