This table stores data for Onvio Payroll Integration that need to be processed by Cron tasks. |
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. |