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
NameTypeConstraintsDescription
onvio_payroll_integration_status_KEYint (4)NOT NULLThe primary key used for identifying Onvio Payroll Integration Status.
descriptionnvarchar (40)NOT NULLThe description of the Onvio Payroll Integration Status.
developer_notenvarchar (-1)NOT NULLUsed to store a definition of a particular status.
Primary key
NameColumnsDescription
PK_Onvio_Payroll_Integration_Statusonvio_payroll_integration_status_KEY
Unique constraints
NameColumnsDescription
UK_Onvio_Payroll_Integration_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Onvio_Payroll_Integration_Status__Onvio_Payroll_Integration_Status__onvio_payroll_integration_status_KEYonvio_payroll_integration_status_KEYClient_Onvio_Payroll_Integration_Status

Schema diagram