Table: dbo.Client_Contact_Payroll_Administrator
This table contains the details of Payroll Administrator checkbox selected in Additional Contacts.
Columns
Name | Type | Constraints | Description
client_contact_payroll_administrator_KEY | int (4) | NOT NULL | Primary key.
client_KEY | int (4) | NOT NULL | Client Key.
contact_KEY | int (4) | NOT NULL | Contact Key.
onvio_contact_payroll_id | nvarchar (64) |  | Onvio contact payroll admin identifier

Primary key
Name | Columns | Description
PK_Client_Contact_Payroll_Administrator | client_contact_payroll_administrator_KEY |
Unique constraints
Name | Columns | Description
UK_Client_Contact_Payroll_Administrator$contact_KEY | contact_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Contact_Payroll_Administrator__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Contact_Payroll_Administrator__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Onvio_Payroll_Integration_Queue__Client_Contact_Payroll_Administrator__client_contact_payroll_administrator_KEY | client_contact_payroll_administrator_KEY | Onvio_Payroll_Integration_Queue |