Table: dbo.Client_Onvio_Payroll_Integration_Status
Status types specifically for a Client that are used to signify the stages of operations related to Onvio Payroll.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe foreign key used for identifying the client the status applies to.
event_time_utcdatetime (8, 3)NOT NULLThe UTC time when the status came into effect.
onvio_payroll_integration_status_KEYint (4)NOT NULLThe foreign key used for onvio client status.
error_detailnvarchar (-1)Used to store error details related to an error event related to the associated client.
Primary key
NameColumnsDescription
PK_Client_Onvio_Payroll_Integration_Status$client_KEY$event_time_utcclient_KEY, event_time_utc
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Onvio_Payroll_Integration_Status__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Onvio_Payroll_Integration_Status__Onvio_Payroll_Integration_Status__onvio_payroll_integration_status_KEYonvio_payroll_integration_status_KEYOnvio_Payroll_Integration_Status (onvio_payroll_integration_status_KEY)

Schema diagram