Table: dbo.Onvio_Payroll_Integration_Status
This is the union of all statuses (for client, employee, pay schedule, contact, etc.) that an operation may have with regard to Onvio. Each such table using these statuses should both foreign key into this table as well as check constraint to ensure they only record status for which they are prepared to handle.
Columns
Name | Type | Constraints | Description
onvio_payroll_integration_status_KEY | int (4) | NOT NULL | The primary key used for identifying Onvio Payroll Integration Status.
description | nvarchar (40) | NOT NULL | The description of the Onvio Payroll Integration Status.
developer_note | nvarchar (-1) | NOT NULL | Used to store a definition of a particular status.

Primary key
Name | Columns | Description
PK_Onvio_Payroll_Integration_Status | onvio_payroll_integration_status_KEY |
Unique constraints
Name | Columns | Description
UK_Onvio_Payroll_Integration_Status$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Onvio_Payroll_Integration_Status__Onvio_Payroll_Integration_Status__onvio_payroll_integration_status_KEY | onvio_payroll_integration_status_KEY | Client_Onvio_Payroll_Integration_Status |