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
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The foreign key used for identifying the client the status applies to.
event_time_utc | datetime (8, 3) | NOT NULL | The UTC time when the status came into effect.
onvio_payroll_integration_status_KEY | int (4) | NOT NULL | The foreign key used for onvio client status.
error_detail | nvarchar (-1) |  | Used to store error details related to an error event related to the associated client.

Primary key
Name | Columns | Description
PK_Client_Onvio_Payroll_Integration_Status$client_KEY$event_time_utc | client_KEY, event_time_utc |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Onvio_Payroll_Integration_Status__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Onvio_Payroll_Integration_Status__Onvio_Payroll_Integration_Status__onvio_payroll_integration_status_KEY | onvio_payroll_integration_status_KEY | Onvio_Payroll_Integration_Status (onvio_payroll_integration_status_KEY) |