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 |