Deputy integration summary

Stitch’s Deputy integration replicates data using the Deputy API. Refer to the Schema section for a list of objects available for replication.

Deputy feature snapshot

A high-level look at Stitch's Deputy (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on September 26, 2019

Supported by

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-deputy

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Deputy

Step 1: Add Deputy as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Deputy icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Deputy” would create a schema called stitch_deputy in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Authorize Stitch to access Deputy

In this step, you’ll grant Stitch access to the Deputy organization you want to connect.

  1. When finished, click Authorize. You’ll be prompted to sign into your Deputy account if you aren’t already.
  2. After you log into Deputy, a screen with a list of your Deputy organizations will display. Select the organization you want to connect to Stitch and click Authorize.
  3. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  4. Click All Done.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Deputy integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Deputy’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Deputy integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Deputy integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Deputy, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Deputy table reference

addresses

The addresses table contains info about addresses.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join addresses with on
companies
addresses.Id = companies.Address
addresses.Creator = companies.Creator
employee_history
addresses.Id = employee_history.MainAddress
addresses.Id = employee_history.PostalAddress
addresses.Id = employee_history.EmergencyAddress
addresses.Creator = employee_history.EmployeeId
addresses.Creator = employee_history.Creator
operational_units
addresses.Id = operational_units.Address
addresses.Creator = operational_units.Creator
categories
addresses.Creator = categories.Creator
comments
addresses.Creator = comments.Creator
company_periods
addresses.Creator = company_periods.Creator
contacts
addresses.Creator = contacts.Creator
countries
addresses.Creator = countries.Creator
custom_app_data
addresses.Creator = custom_app_data.Employee
addresses.Creator = custom_app_data.Creator
custom_field_data
addresses.Creator = custom_field_data.Creator
custom_fields
addresses.Creator = custom_fields.Creator
employee_agreement_history
addresses.Creator = employee_agreement_history.Creator
employee_agreements
addresses.Creator = employee_agreements.EmployeeId
addresses.Creator = employee_agreements.Creator
employee_appraisal
addresses.Creator = employee_appraisal.Creator
addresses.Creator = employee_appraisal.Employee
employee_availability
addresses.Creator = employee_availability.Employee
addresses.Creator = employee_availability.Creator
employee_contract_leave_rules
addresses.Creator = employee_contract_leave_rules.Creator
employee_contracts
addresses.Creator = employee_contracts.Creator
employee_paycycle_returns
addresses.Creator = employee_paycycle_returns.Creator
employee_paycycles
addresses.Creator = employee_paycycles.EmployeeId
addresses.Creator = employee_paycycles.Creator
employee_roles
addresses.Creator = employee_roles.Creator
employee_salary_opunit_costing
addresses.Creator = employee_salary_opunit_costing.Employee
addresses.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
addresses.Creator = employee_workplaces.EmployeeId
addresses.Creator = employee_workplaces.Creator
employment_conditions
addresses.Creator = employment_conditions.Creator
events
addresses.Creator = events.Creator
geo
addresses.Creator = geo.Creator
journal
addresses.Creator = journal.EmployeeId
addresses.Creator = journal.Creator
kiosks
addresses.Creator = kiosks.Creator
leave_accruals
addresses.Creator = leave_accruals.Employee
addresses.Creator = leave_accruals.Creator
leave_pay_lines
addresses.Creator = leave_pay_lines.Creator
leave_rules
addresses.Creator = leave_rules.Creator
leaves
addresses.Creator = leaves.Employee
addresses.Creator = leaves.Creator
memos
addresses.Creator = memos.Creator
pay_periods
addresses.Creator = pay_periods.Creator
pay_rules
addresses.Creator = pay_rules.Creator
public_holidays
addresses.Creator = public_holidays.Creator
roster_opens
addresses.Creator = roster_opens.Employee
addresses.Creator = roster_opens.Creator
roster_swaps
addresses.Creator = roster_swaps.Employee
addresses.Creator = roster_swaps.Creator
rosters
addresses.Creator = rosters.Employee
addresses.Creator = rosters.ConfirmBy
addresses.Creator = rosters.Creator
sales_data
addresses.Creator = sales_data.Employee
addresses.Creator = sales_data.Creator
schedules
addresses.Creator = schedules.Creator
sms_logs
addresses.Creator = sms_logs.Creator
states
addresses.Creator = states.Creator
stress_profiles
addresses.Creator = stress_profiles.Creator
system_usage_balances
addresses.Creator = system_usage_balances.Creator
system_usage_tracking
addresses.Creator = system_usage_tracking.Creator
task_group_setups
addresses.Creator = task_group_setups.Creator
task_groups
addresses.Creator = task_groups.Creator
task_opunit_configs
addresses.Creator = task_opunit_configs.Creator
task_setups
addresses.Creator = task_setups.Creator
tasks
addresses.Creator = tasks.Creator
teams
addresses.Creator = teams.LeaderEmployee
addresses.Creator = teams.Creator
timesheet_pay_returns
addresses.Creator = timesheet_pay_returns.Creator
timesheets
addresses.Creator = timesheets.Employee
addresses.Creator = timesheets.Creator
training_modules
addresses.Creator = training_modules.Creator
training_records
addresses.Creator = training_records.Employee
addresses.Creator = training_records.Creator
webhooks
addresses.Creator = webhooks.Creator

City

STRING

ContactName

STRING

Country

INTEGER

Created

DATE-TIME

Creator

INTEGER

Format

INTEGER

Id

INTEGER

Modified

DATE-TIME

Notes

STRING

Phone

STRING

PoBox

STRING

Postcode

STRING

Saved

BOOLEAN

State

STRING

Street1

STRING

Street2

STRING

StreetNo

STRING

SuiteNo

STRING

UnitNo

STRING

categories

The categories table contains info about categories.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join categories with on
employee_contracts
categories.Id = employee_contracts.EmploymentCategory
categories.Creator = employee_contracts.Creator
employment_conditions
categories.Id = employment_conditions.EmploymentCategory
categories.Creator = employment_conditions.Creator
addresses
categories.Creator = addresses.Creator
comments
categories.Creator = comments.Creator
companies
categories.Creator = companies.Creator
company_periods
categories.Creator = company_periods.Creator
contacts
categories.Creator = contacts.Creator
countries
categories.Creator = countries.Creator
custom_app_data
categories.Creator = custom_app_data.Employee
categories.Creator = custom_app_data.Creator
custom_field_data
categories.Creator = custom_field_data.Creator
custom_fields
categories.Creator = custom_fields.Creator
employee_agreement_history
categories.Creator = employee_agreement_history.Creator
employee_agreements
categories.Creator = employee_agreements.EmployeeId
categories.Creator = employee_agreements.Creator
employee_appraisal
categories.Creator = employee_appraisal.Creator
categories.Creator = employee_appraisal.Employee
employee_availability
categories.Creator = employee_availability.Employee
categories.Creator = employee_availability.Creator
employee_contract_leave_rules
categories.Creator = employee_contract_leave_rules.Creator
employee_history
categories.Creator = employee_history.EmployeeId
categories.Creator = employee_history.Creator
employee_paycycle_returns
categories.Creator = employee_paycycle_returns.Creator
employee_paycycles
categories.Creator = employee_paycycles.EmployeeId
categories.Creator = employee_paycycles.Creator
employee_roles
categories.Creator = employee_roles.Creator
employee_salary_opunit_costing
categories.Creator = employee_salary_opunit_costing.Employee
categories.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
categories.Creator = employee_workplaces.EmployeeId
categories.Creator = employee_workplaces.Creator
events
categories.Creator = events.Creator
geo
categories.Creator = geo.Creator
journal
categories.Creator = journal.EmployeeId
categories.Creator = journal.Creator
kiosks
categories.Creator = kiosks.Creator
leave_accruals
categories.Creator = leave_accruals.Employee
categories.Creator = leave_accruals.Creator
leave_pay_lines
categories.Creator = leave_pay_lines.Creator
leave_rules
categories.Creator = leave_rules.Creator
leaves
categories.Creator = leaves.Employee
categories.Creator = leaves.Creator
memos
categories.Creator = memos.Creator
operational_units
categories.Creator = operational_units.Creator
pay_periods
categories.Creator = pay_periods.Creator
pay_rules
categories.Creator = pay_rules.Creator
public_holidays
categories.Creator = public_holidays.Creator
roster_opens
categories.Creator = roster_opens.Employee
categories.Creator = roster_opens.Creator
roster_swaps
categories.Creator = roster_swaps.Employee
categories.Creator = roster_swaps.Creator
rosters
categories.Creator = rosters.Employee
categories.Creator = rosters.ConfirmBy
categories.Creator = rosters.Creator
sales_data
categories.Creator = sales_data.Employee
categories.Creator = sales_data.Creator
schedules
categories.Creator = schedules.Creator
sms_logs
categories.Creator = sms_logs.Creator
states
categories.Creator = states.Creator
stress_profiles
categories.Creator = stress_profiles.Creator
system_usage_balances
categories.Creator = system_usage_balances.Creator
system_usage_tracking
categories.Creator = system_usage_tracking.Creator
task_group_setups
categories.Creator = task_group_setups.Creator
task_groups
categories.Creator = task_groups.Creator
task_opunit_configs
categories.Creator = task_opunit_configs.Creator
task_setups
categories.Creator = task_setups.Creator
tasks
categories.Creator = tasks.Creator
teams
categories.Creator = teams.LeaderEmployee
categories.Creator = teams.Creator
timesheet_pay_returns
categories.Creator = timesheet_pay_returns.Creator
timesheets
categories.Creator = timesheets.Employee
categories.Creator = timesheets.Creator
training_modules
categories.Creator = training_modules.Creator
training_records
categories.Creator = training_records.Employee
categories.Creator = training_records.Creator
webhooks
categories.Creator = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

Modified

DATE-TIME

SortOrder

INTEGER

Stafflog

BOOLEAN

System

BOOLEAN

category

STRING

group

STRING

comments

The comments table contains info about comments.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join comments with on
addresses
comments.Creator = addresses.Creator
categories
comments.Creator = categories.Creator
companies
comments.Creator = companies.Creator
company_periods
comments.Creator = company_periods.Creator
contacts
comments.Creator = contacts.Creator
countries
comments.Creator = countries.Creator
custom_app_data
comments.Creator = custom_app_data.Employee
comments.Creator = custom_app_data.Creator
custom_field_data
comments.Creator = custom_field_data.Creator
custom_fields
comments.Creator = custom_fields.Creator
employee_agreement_history
comments.Creator = employee_agreement_history.Creator
employee_agreements
comments.Creator = employee_agreements.EmployeeId
comments.Creator = employee_agreements.Creator
employee_appraisal
comments.Creator = employee_appraisal.Creator
comments.Creator = employee_appraisal.Employee
employee_availability
comments.Creator = employee_availability.Employee
comments.Creator = employee_availability.Creator
employee_contract_leave_rules
comments.Creator = employee_contract_leave_rules.Creator
employee_contracts
comments.Creator = employee_contracts.Creator
employee_history
comments.Creator = employee_history.EmployeeId
comments.Creator = employee_history.Creator
employee_paycycle_returns
comments.Creator = employee_paycycle_returns.Creator
employee_paycycles
comments.Creator = employee_paycycles.EmployeeId
comments.Creator = employee_paycycles.Creator
employee_roles
comments.Creator = employee_roles.Creator
employee_salary_opunit_costing
comments.Creator = employee_salary_opunit_costing.Employee
comments.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
comments.Creator = employee_workplaces.EmployeeId
comments.Creator = employee_workplaces.Creator
employment_conditions
comments.Creator = employment_conditions.Creator
events
comments.Creator = events.Creator
geo
comments.Creator = geo.Creator
journal
comments.Creator = journal.EmployeeId
comments.Creator = journal.Creator
kiosks
comments.Creator = kiosks.Creator
leave_accruals
comments.Creator = leave_accruals.Employee
comments.Creator = leave_accruals.Creator
leave_pay_lines
comments.Creator = leave_pay_lines.Creator
leave_rules
comments.Creator = leave_rules.Creator
leaves
comments.Creator = leaves.Employee
comments.Creator = leaves.Creator
memos
comments.Creator = memos.Creator
operational_units
comments.Creator = operational_units.Creator
pay_periods
comments.Creator = pay_periods.Creator
pay_rules
comments.Creator = pay_rules.Creator
public_holidays
comments.Creator = public_holidays.Creator
roster_opens
comments.Creator = roster_opens.Employee
comments.Creator = roster_opens.Creator
roster_swaps
comments.Creator = roster_swaps.Employee
comments.Creator = roster_swaps.Creator
rosters
comments.Creator = rosters.Employee
comments.Creator = rosters.ConfirmBy
comments.Creator = rosters.Creator
sales_data
comments.Creator = sales_data.Employee
comments.Creator = sales_data.Creator
schedules
comments.Creator = schedules.Creator
sms_logs
comments.Creator = sms_logs.Creator
states
comments.Creator = states.Creator
stress_profiles
comments.Creator = stress_profiles.Creator
system_usage_balances
comments.Creator = system_usage_balances.Creator
system_usage_tracking
comments.Creator = system_usage_tracking.Creator
task_group_setups
comments.Creator = task_group_setups.Creator
task_groups
comments.Creator = task_groups.Creator
task_opunit_configs
comments.Creator = task_opunit_configs.Creator
task_setups
comments.Creator = task_setups.Creator
tasks
comments.Creator = tasks.Creator
teams
comments.Creator = teams.LeaderEmployee
comments.Creator = teams.Creator
timesheet_pay_returns
comments.Creator = timesheet_pay_returns.Creator
timesheets
comments.Creator = timesheets.Employee
comments.Creator = timesheets.Creator
training_modules
comments.Creator = training_modules.Creator
training_records
comments.Creator = training_records.Employee
comments.Creator = training_records.Creator
webhooks
comments.Creator = webhooks.Creator

Comment

STRING

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

IgnorePermission

BOOLEAN

InFeed

BOOLEAN

Modified

DATE-TIME

Orm

STRING

RecId

INTEGER

companies

The companies table contains info about companies.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join companies with on
addresses
companies.Address = addresses.Id
companies.Creator = addresses.Creator
employee_history
companies.Address = employee_history.MainAddress
companies.Address = employee_history.PostalAddress
companies.Address = employee_history.EmergencyAddress
companies.Id = employee_history.Company
companies.ParentCompany = employee_history.Company
companies.Creator = employee_history.EmployeeId
companies.Creator = employee_history.Creator
operational_units
companies.Address = operational_units.Address
companies.Contact = operational_units.Contact
companies.Creator = operational_units.Creator
company_periods
companies.Id = company_periods.Company
companies.ParentCompany = company_periods.Company
companies.Creator = company_periods.Creator
employee_workplaces
companies.Id = employee_workplaces.Company
companies.ParentCompany = employee_workplaces.Company
companies.Creator = employee_workplaces.EmployeeId
companies.Creator = employee_workplaces.Creator
kiosks
companies.Id = kiosks.Company
companies.ParentCompany = kiosks.Company
companies.Creator = kiosks.Creator
leaves
companies.Id = leaves.Company
companies.ParentCompany = leaves.Company
companies.Creator = leaves.Employee
companies.Creator = leaves.Creator
system_usage_tracking
companies.Id = system_usage_tracking.CompanyId
companies.ParentCompany = system_usage_tracking.CompanyId
companies.Creator = system_usage_tracking.Creator
contacts
companies.Contact = contacts.Id
companies.Creator = contacts.Creator
categories
companies.Creator = categories.Creator
comments
companies.Creator = comments.Creator
countries
companies.Creator = countries.Creator
custom_app_data
companies.Creator = custom_app_data.Employee
companies.Creator = custom_app_data.Creator
custom_field_data
companies.Creator = custom_field_data.Creator
custom_fields
companies.Creator = custom_fields.Creator
employee_agreement_history
companies.Creator = employee_agreement_history.Creator
employee_agreements
companies.Creator = employee_agreements.EmployeeId
companies.Creator = employee_agreements.Creator
employee_appraisal
companies.Creator = employee_appraisal.Creator
companies.Creator = employee_appraisal.Employee
employee_availability
companies.Creator = employee_availability.Employee
companies.Creator = employee_availability.Creator
employee_contract_leave_rules
companies.Creator = employee_contract_leave_rules.Creator
employee_contracts
companies.Creator = employee_contracts.Creator
employee_paycycle_returns
companies.Creator = employee_paycycle_returns.Creator
employee_paycycles
companies.Creator = employee_paycycles.EmployeeId
companies.Creator = employee_paycycles.Creator
employee_roles
companies.Creator = employee_roles.Creator
employee_salary_opunit_costing
companies.Creator = employee_salary_opunit_costing.Employee
companies.Creator = employee_salary_opunit_costing.Creator
employment_conditions
companies.Creator = employment_conditions.Creator
events
companies.Creator = events.Creator
geo
companies.Creator = geo.Creator
journal
companies.Creator = journal.EmployeeId
companies.Creator = journal.Creator
leave_accruals
companies.Creator = leave_accruals.Employee
companies.Creator = leave_accruals.Creator
leave_pay_lines
companies.Creator = leave_pay_lines.Creator
leave_rules
companies.Creator = leave_rules.Creator
memos
companies.Creator = memos.Creator
pay_periods
companies.Creator = pay_periods.Creator
pay_rules
companies.Creator = pay_rules.Creator
public_holidays
companies.Creator = public_holidays.Creator
roster_opens
companies.Creator = roster_opens.Employee
companies.Creator = roster_opens.Creator
roster_swaps
companies.Creator = roster_swaps.Employee
companies.Creator = roster_swaps.Creator
rosters
companies.Creator = rosters.Employee
companies.Creator = rosters.ConfirmBy
companies.Creator = rosters.Creator
sales_data
companies.Creator = sales_data.Employee
companies.Creator = sales_data.Creator
schedules
companies.Creator = schedules.Creator
sms_logs
companies.Creator = sms_logs.Creator
states
companies.Creator = states.Creator
stress_profiles
companies.Creator = stress_profiles.Creator
system_usage_balances
companies.Creator = system_usage_balances.Creator
task_group_setups
companies.Creator = task_group_setups.Creator
task_groups
companies.Creator = task_groups.Creator
task_opunit_configs
companies.Creator = task_opunit_configs.Creator
task_setups
companies.Creator = task_setups.Creator
tasks
companies.Creator = tasks.Creator
teams
companies.Creator = teams.LeaderEmployee
companies.Creator = teams.Creator
timesheet_pay_returns
companies.Creator = timesheet_pay_returns.Creator
timesheets
companies.Creator = timesheets.Employee
companies.Creator = timesheets.Creator
training_modules
companies.Creator = training_modules.Creator
training_records
companies.Creator = training_records.Employee
companies.Creator = training_records.Creator
webhooks
companies.Creator = webhooks.Creator

Active

BOOLEAN

Address

INTEGER

BusinessNumber

STRING

Code

STRING

CompanyName

STRING

CompanyNumber

STRING

Contact

INTEGER

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

IsPayrollEntity

BOOLEAN

IsWorkplace

BOOLEAN

Modified

DATE-TIME

ParentCompany

INTEGER

PayrollExportCode

INTEGER

Portfolio

INTEGER

TradingName

STRING

company_periods

The company_periods table contains info about company periods.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join company_periods with on
companies
company_periods.Company = companies.Id
company_periods.Company = companies.ParentCompany
company_periods.Creator = companies.Creator
employee_history
company_periods.Company = employee_history.Company
company_periods.Creator = employee_history.EmployeeId
company_periods.Creator = employee_history.Creator
employee_workplaces
company_periods.Company = employee_workplaces.Company
company_periods.Creator = employee_workplaces.EmployeeId
company_periods.Creator = employee_workplaces.Creator
kiosks
company_periods.Company = kiosks.Company
company_periods.Creator = kiosks.Creator
leaves
company_periods.Company = leaves.Company
company_periods.Creator = leaves.Employee
company_periods.Creator = leaves.Creator
system_usage_tracking
company_periods.Company = system_usage_tracking.CompanyId
company_periods.Creator = system_usage_tracking.Creator
employee_paycycles
company_periods.Id = employee_paycycles.PeriodId
company_periods.Creator = employee_paycycles.EmployeeId
company_periods.Creator = employee_paycycles.Creator
addresses
company_periods.Creator = addresses.Creator
categories
company_periods.Creator = categories.Creator
comments
company_periods.Creator = comments.Creator
contacts
company_periods.Creator = contacts.Creator
countries
company_periods.Creator = countries.Creator
custom_app_data
company_periods.Creator = custom_app_data.Employee
company_periods.Creator = custom_app_data.Creator
custom_field_data
company_periods.Creator = custom_field_data.Creator
custom_fields
company_periods.Creator = custom_fields.Creator
employee_agreement_history
company_periods.Creator = employee_agreement_history.Creator
company_periods.PayPeriod = employee_agreement_history.PayPeriod
employee_agreements
company_periods.Creator = employee_agreements.EmployeeId
company_periods.Creator = employee_agreements.Creator
company_periods.PayPeriod = employee_agreements.PayPeriod
employee_appraisal
company_periods.Creator = employee_appraisal.Creator
company_periods.Creator = employee_appraisal.Employee
employee_availability
company_periods.Creator = employee_availability.Employee
company_periods.Creator = employee_availability.Creator
employee_contract_leave_rules
company_periods.Creator = employee_contract_leave_rules.Creator
employee_contracts
company_periods.Creator = employee_contracts.Creator
employee_paycycle_returns
company_periods.Creator = employee_paycycle_returns.Creator
employee_roles
company_periods.Creator = employee_roles.Creator
employee_salary_opunit_costing
company_periods.Creator = employee_salary_opunit_costing.Employee
company_periods.Creator = employee_salary_opunit_costing.Creator
employment_conditions
company_periods.Creator = employment_conditions.Creator
events
company_periods.Creator = events.Creator
geo
company_periods.Creator = geo.Creator
journal
company_periods.Creator = journal.EmployeeId
company_periods.Creator = journal.Creator
leave_accruals
company_periods.Creator = leave_accruals.Employee
company_periods.Creator = leave_accruals.Creator
leave_pay_lines
company_periods.Creator = leave_pay_lines.Creator
leave_rules
company_periods.Creator = leave_rules.Creator
memos
company_periods.Creator = memos.Creator
operational_units
company_periods.Creator = operational_units.Creator
pay_periods
company_periods.Creator = pay_periods.Creator
company_periods.PayPeriod = pay_periods.Id
pay_rules
company_periods.Creator = pay_rules.Creator
public_holidays
company_periods.Creator = public_holidays.Creator
roster_opens
company_periods.Creator = roster_opens.Employee
company_periods.Creator = roster_opens.Creator
roster_swaps
company_periods.Creator = roster_swaps.Employee
company_periods.Creator = roster_swaps.Creator
rosters
company_periods.Creator = rosters.Employee
company_periods.Creator = rosters.ConfirmBy
company_periods.Creator = rosters.Creator
sales_data
company_periods.Creator = sales_data.Employee
company_periods.Creator = sales_data.Creator
schedules
company_periods.Creator = schedules.Creator
sms_logs
company_periods.Creator = sms_logs.Creator
states
company_periods.Creator = states.Creator
stress_profiles
company_periods.Creator = stress_profiles.Creator
system_usage_balances
company_periods.Creator = system_usage_balances.Creator
task_group_setups
company_periods.Creator = task_group_setups.Creator
task_groups
company_periods.Creator = task_groups.Creator
task_opunit_configs
company_periods.Creator = task_opunit_configs.Creator
task_setups
company_periods.Creator = task_setups.Creator
tasks
company_periods.Creator = tasks.Creator
teams
company_periods.Creator = teams.LeaderEmployee
company_periods.Creator = teams.Creator
timesheet_pay_returns
company_periods.Creator = timesheet_pay_returns.Creator
timesheets
company_periods.Creator = timesheets.Employee
company_periods.Creator = timesheets.Creator
training_modules
company_periods.Creator = training_modules.Creator
training_records
company_periods.Creator = training_records.Employee
company_periods.Creator = training_records.Creator
webhooks
company_periods.Creator = webhooks.Creator

Company

INTEGER

Created

DATE-TIME

Creator

INTEGER

DateEnd

DATE

DateStart

DATE

End

INTEGER

Id

INTEGER

Modified

DATE-TIME

PayPeriod

INTEGER

Start

INTEGER

contacts

The contacts table contains info about contacts.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join contacts with on
companies
contacts.Id = companies.Contact
contacts.Creator = companies.Creator
operational_units
contacts.Id = operational_units.Contact
contacts.Creator = operational_units.Creator
addresses
contacts.Creator = addresses.Creator
categories
contacts.Creator = categories.Creator
comments
contacts.Creator = comments.Creator
company_periods
contacts.Creator = company_periods.Creator
countries
contacts.Creator = countries.Creator
custom_app_data
contacts.Creator = custom_app_data.Employee
contacts.Creator = custom_app_data.Creator
custom_field_data
contacts.Creator = custom_field_data.Creator
custom_fields
contacts.Creator = custom_fields.Creator
employee_agreement_history
contacts.Creator = employee_agreement_history.Creator
employee_agreements
contacts.Creator = employee_agreements.EmployeeId
contacts.Creator = employee_agreements.Creator
employee_appraisal
contacts.Creator = employee_appraisal.Creator
contacts.Creator = employee_appraisal.Employee
employee_availability
contacts.Creator = employee_availability.Employee
contacts.Creator = employee_availability.Creator
employee_contract_leave_rules
contacts.Creator = employee_contract_leave_rules.Creator
employee_contracts
contacts.Creator = employee_contracts.Creator
employee_history
contacts.Creator = employee_history.EmployeeId
contacts.Creator = employee_history.Creator
employee_paycycle_returns
contacts.Creator = employee_paycycle_returns.Creator
employee_paycycles
contacts.Creator = employee_paycycles.EmployeeId
contacts.Creator = employee_paycycles.Creator
employee_roles
contacts.Creator = employee_roles.Creator
employee_salary_opunit_costing
contacts.Creator = employee_salary_opunit_costing.Employee
contacts.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
contacts.Creator = employee_workplaces.EmployeeId
contacts.Creator = employee_workplaces.Creator
employment_conditions
contacts.Creator = employment_conditions.Creator
events
contacts.Creator = events.Creator
geo
contacts.Creator = geo.Creator
journal
contacts.Creator = journal.EmployeeId
contacts.Creator = journal.Creator
kiosks
contacts.Creator = kiosks.Creator
leave_accruals
contacts.Creator = leave_accruals.Employee
contacts.Creator = leave_accruals.Creator
leave_pay_lines
contacts.Creator = leave_pay_lines.Creator
leave_rules
contacts.Creator = leave_rules.Creator
leaves
contacts.Creator = leaves.Employee
contacts.Creator = leaves.Creator
memos
contacts.Creator = memos.Creator
pay_periods
contacts.Creator = pay_periods.Creator
pay_rules
contacts.Creator = pay_rules.Creator
public_holidays
contacts.Creator = public_holidays.Creator
roster_opens
contacts.Creator = roster_opens.Employee
contacts.Creator = roster_opens.Creator
roster_swaps
contacts.Creator = roster_swaps.Employee
contacts.Creator = roster_swaps.Creator
rosters
contacts.Creator = rosters.Employee
contacts.Creator = rosters.ConfirmBy
contacts.Creator = rosters.Creator
sales_data
contacts.Creator = sales_data.Employee
contacts.Creator = sales_data.Creator
schedules
contacts.Creator = schedules.Creator
sms_logs
contacts.Creator = sms_logs.Creator
states
contacts.Creator = states.Creator
stress_profiles
contacts.Creator = stress_profiles.Creator
system_usage_balances
contacts.Creator = system_usage_balances.Creator
system_usage_tracking
contacts.Creator = system_usage_tracking.Creator
task_group_setups
contacts.Creator = task_group_setups.Creator
task_groups
contacts.Creator = task_groups.Creator
task_opunit_configs
contacts.Creator = task_opunit_configs.Creator
task_setups
contacts.Creator = task_setups.Creator
tasks
contacts.Creator = tasks.Creator
teams
contacts.Creator = teams.LeaderEmployee
contacts.Creator = teams.Creator
timesheet_pay_returns
contacts.Creator = timesheet_pay_returns.Creator
timesheets
contacts.Creator = timesheets.Employee
contacts.Creator = timesheets.Creator
training_modules
contacts.Creator = training_modules.Creator
training_records
contacts.Creator = training_records.Employee
contacts.Creator = training_records.Creator
webhooks
contacts.Creator = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

Email1

STRING

Email1Type

STRING

Email2

STRING

Email2Type

STRING

Fax

STRING

Id

INTEGER

Im1

STRING

Im1Type

STRING

Im2

STRING

Im2Type

STRING

Modified

DATE-TIME

Notes

STRING

Phone1

STRING

Phone1Type

STRING

Phone2

STRING

Phone2Type

STRING

Phone3

STRING

Phone3Type

STRING

PrimaryEmail

INTEGER

PrimaryPhone

INTEGER

Saved

BOOLEAN

Web

STRING

countries

The countries table contains info about countries.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join countries with on
geo
countries.Id = geo.Country
countries.Creator = geo.Creator
states
countries.Id = states.Country
countries.Creator = states.Creator
addresses
countries.Creator = addresses.Creator
categories
countries.Creator = categories.Creator
comments
countries.Creator = comments.Creator
companies
countries.Creator = companies.Creator
company_periods
countries.Creator = company_periods.Creator
contacts
countries.Creator = contacts.Creator
custom_app_data
countries.Creator = custom_app_data.Employee
countries.Creator = custom_app_data.Creator
custom_field_data
countries.Creator = custom_field_data.Creator
custom_fields
countries.Creator = custom_fields.Creator
employee_agreement_history
countries.Creator = employee_agreement_history.Creator
employee_agreements
countries.Creator = employee_agreements.EmployeeId
countries.Creator = employee_agreements.Creator
employee_appraisal
countries.Creator = employee_appraisal.Creator
countries.Creator = employee_appraisal.Employee
employee_availability
countries.Creator = employee_availability.Employee
countries.Creator = employee_availability.Creator
employee_contract_leave_rules
countries.Creator = employee_contract_leave_rules.Creator
employee_contracts
countries.Creator = employee_contracts.Creator
employee_history
countries.Creator = employee_history.EmployeeId
countries.Creator = employee_history.Creator
employee_paycycle_returns
countries.Creator = employee_paycycle_returns.Creator
employee_paycycles
countries.Creator = employee_paycycles.EmployeeId
countries.Creator = employee_paycycles.Creator
employee_roles
countries.Creator = employee_roles.Creator
employee_salary_opunit_costing
countries.Creator = employee_salary_opunit_costing.Employee
countries.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
countries.Creator = employee_workplaces.EmployeeId
countries.Creator = employee_workplaces.Creator
employment_conditions
countries.Creator = employment_conditions.Creator
events
countries.Creator = events.Creator
journal
countries.Creator = journal.EmployeeId
countries.Creator = journal.Creator
kiosks
countries.Creator = kiosks.Creator
leave_accruals
countries.Creator = leave_accruals.Employee
countries.Creator = leave_accruals.Creator
leave_pay_lines
countries.Creator = leave_pay_lines.Creator
leave_rules
countries.Creator = leave_rules.Creator
leaves
countries.Creator = leaves.Employee
countries.Creator = leaves.Creator
memos
countries.Creator = memos.Creator
operational_units
countries.Creator = operational_units.Creator
pay_periods
countries.Creator = pay_periods.Creator
pay_rules
countries.Creator = pay_rules.Creator
public_holidays
countries.Creator = public_holidays.Creator
roster_opens
countries.Creator = roster_opens.Employee
countries.Creator = roster_opens.Creator
roster_swaps
countries.Creator = roster_swaps.Employee
countries.Creator = roster_swaps.Creator
rosters
countries.Creator = rosters.Employee
countries.Creator = rosters.ConfirmBy
countries.Creator = rosters.Creator
sales_data
countries.Creator = sales_data.Employee
countries.Creator = sales_data.Creator
schedules
countries.Creator = schedules.Creator
sms_logs
countries.Creator = sms_logs.Creator
stress_profiles
countries.Creator = stress_profiles.Creator
system_usage_balances
countries.Creator = system_usage_balances.Creator
system_usage_tracking
countries.Creator = system_usage_tracking.Creator
task_group_setups
countries.Creator = task_group_setups.Creator
task_groups
countries.Creator = task_groups.Creator
task_opunit_configs
countries.Creator = task_opunit_configs.Creator
task_setups
countries.Creator = task_setups.Creator
tasks
countries.Creator = tasks.Creator
teams
countries.Creator = teams.LeaderEmployee
countries.Creator = teams.Creator
timesheet_pay_returns
countries.Creator = timesheet_pay_returns.Creator
timesheets
countries.Creator = timesheets.Employee
countries.Creator = timesheets.Creator
training_modules
countries.Creator = training_modules.Creator
training_records
countries.Creator = training_records.Employee
countries.Creator = training_records.Creator
webhooks
countries.Creator = webhooks.Creator

Active

BOOLEAN

Code

STRING

CodeA3

STRING

Country

STRING

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

Modified

DATE-TIME

PhoneDisplayPreg

STRING

Region

STRING

SortOrder

INTEGER

ZipVAlidatePreg

STRING

custom_app_data

The custom_app_data table contains info about custom app data.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join custom_app_data with on
addresses
custom_app_data.Employee = addresses.Creator
custom_app_data.Creator = addresses.Creator
categories
custom_app_data.Employee = categories.Creator
custom_app_data.Creator = categories.Creator
comments
custom_app_data.Employee = comments.Creator
custom_app_data.Creator = comments.Creator
companies
custom_app_data.Employee = companies.Creator
custom_app_data.Creator = companies.Creator
company_periods
custom_app_data.Employee = company_periods.Creator
custom_app_data.Creator = company_periods.Creator
contacts
custom_app_data.Employee = contacts.Creator
custom_app_data.Creator = contacts.Creator
countries
custom_app_data.Employee = countries.Creator
custom_app_data.Creator = countries.Creator
custom_field_data
custom_app_data.Employee = custom_field_data.Creator
custom_app_data.Creator = custom_field_data.Creator
custom_fields
custom_app_data.Employee = custom_fields.Creator
custom_app_data.Creator = custom_fields.Creator
employee_agreement_history
custom_app_data.Employee = employee_agreement_history.Creator
custom_app_data.Creator = employee_agreement_history.Creator
employee_agreements
custom_app_data.Employee = employee_agreements.EmployeeId
custom_app_data.Creator = employee_agreements.EmployeeId
custom_app_data.Employee = employee_agreements.Creator
custom_app_data.Creator = employee_agreements.Creator
employee_appraisal
custom_app_data.Employee = employee_appraisal.Creator
custom_app_data.Creator = employee_appraisal.Creator
custom_app_data.Employee = employee_appraisal.Employee
custom_app_data.Creator = employee_appraisal.Employee
employee_availability
custom_app_data.Employee = employee_availability.Employee
custom_app_data.Creator = employee_availability.Employee
custom_app_data.Employee = employee_availability.Creator
custom_app_data.Creator = employee_availability.Creator
employee_contract_leave_rules
custom_app_data.Employee = employee_contract_leave_rules.Creator
custom_app_data.Creator = employee_contract_leave_rules.Creator
employee_contracts
custom_app_data.Employee = employee_contracts.Creator
custom_app_data.Creator = employee_contracts.Creator
employee_history
custom_app_data.Employee = employee_history.EmployeeId
custom_app_data.Creator = employee_history.EmployeeId
custom_app_data.Employee = employee_history.Creator
custom_app_data.Creator = employee_history.Creator
employee_paycycle_returns
custom_app_data.Employee = employee_paycycle_returns.Creator
custom_app_data.Creator = employee_paycycle_returns.Creator
employee_paycycles
custom_app_data.Employee = employee_paycycles.EmployeeId
custom_app_data.Creator = employee_paycycles.EmployeeId
custom_app_data.Employee = employee_paycycles.Creator
custom_app_data.Creator = employee_paycycles.Creator
employee_roles
custom_app_data.Employee = employee_roles.Creator
custom_app_data.Creator = employee_roles.Creator
employee_salary_opunit_costing
custom_app_data.Employee = employee_salary_opunit_costing.Employee
custom_app_data.Creator = employee_salary_opunit_costing.Employee
custom_app_data.Employee = employee_salary_opunit_costing.Creator
custom_app_data.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
custom_app_data.Employee = employee_workplaces.EmployeeId
custom_app_data.Creator = employee_workplaces.EmployeeId
custom_app_data.Employee = employee_workplaces.Creator
custom_app_data.Creator = employee_workplaces.Creator
employment_conditions
custom_app_data.Employee = employment_conditions.Creator
custom_app_data.Creator = employment_conditions.Creator
events
custom_app_data.Employee = events.Creator
custom_app_data.Creator = events.Creator
geo
custom_app_data.Employee = geo.Creator
custom_app_data.Creator = geo.Creator
journal
custom_app_data.Employee = journal.EmployeeId
custom_app_data.Creator = journal.EmployeeId
custom_app_data.Employee = journal.Creator
custom_app_data.Creator = journal.Creator
kiosks
custom_app_data.Employee = kiosks.Creator
custom_app_data.Creator = kiosks.Creator
leave_accruals
custom_app_data.Employee = leave_accruals.Employee
custom_app_data.Creator = leave_accruals.Employee
custom_app_data.Employee = leave_accruals.Creator
custom_app_data.Creator = leave_accruals.Creator
leave_pay_lines
custom_app_data.Employee = leave_pay_lines.Creator
custom_app_data.Creator = leave_pay_lines.Creator
leave_rules
custom_app_data.Employee = leave_rules.Creator
custom_app_data.Creator = leave_rules.Creator
leaves
custom_app_data.Employee = leaves.Employee
custom_app_data.Creator = leaves.Employee
custom_app_data.Employee = leaves.Creator
custom_app_data.Creator = leaves.Creator
memos
custom_app_data.Employee = memos.Creator
custom_app_data.Creator = memos.Creator
operational_units
custom_app_data.Employee = operational_units.Creator
custom_app_data.Creator = operational_units.Creator
pay_periods
custom_app_data.Employee = pay_periods.Creator
custom_app_data.Creator = pay_periods.Creator
pay_rules
custom_app_data.Employee = pay_rules.Creator
custom_app_data.Creator = pay_rules.Creator
public_holidays
custom_app_data.Employee = public_holidays.Creator
custom_app_data.Creator = public_holidays.Creator
roster_opens
custom_app_data.Employee = roster_opens.Employee
custom_app_data.Creator = roster_opens.Employee
custom_app_data.Employee = roster_opens.Creator
custom_app_data.Creator = roster_opens.Creator
roster_swaps
custom_app_data.Employee = roster_swaps.Employee
custom_app_data.Creator = roster_swaps.Employee
custom_app_data.Employee = roster_swaps.Creator
custom_app_data.Creator = roster_swaps.Creator
rosters
custom_app_data.Employee = rosters.Employee
custom_app_data.Creator = rosters.Employee
custom_app_data.Employee = rosters.ConfirmBy
custom_app_data.Creator = rosters.ConfirmBy
custom_app_data.Employee = rosters.Creator
custom_app_data.Creator = rosters.Creator
sales_data
custom_app_data.Employee = sales_data.Employee
custom_app_data.Creator = sales_data.Employee
custom_app_data.Employee = sales_data.Creator
custom_app_data.Creator = sales_data.Creator
schedules
custom_app_data.Employee = schedules.Creator
custom_app_data.Creator = schedules.Creator
sms_logs
custom_app_data.Employee = sms_logs.Creator
custom_app_data.Creator = sms_logs.Creator
states
custom_app_data.Employee = states.Creator
custom_app_data.Creator = states.Creator
stress_profiles
custom_app_data.Employee = stress_profiles.Creator
custom_app_data.Creator = stress_profiles.Creator
system_usage_balances
custom_app_data.Employee = system_usage_balances.Creator
custom_app_data.Creator = system_usage_balances.Creator
system_usage_tracking
custom_app_data.Employee = system_usage_tracking.Creator
custom_app_data.Creator = system_usage_tracking.Creator
task_group_setups
custom_app_data.Employee = task_group_setups.Creator
custom_app_data.Creator = task_group_setups.Creator
task_groups
custom_app_data.Employee = task_groups.Creator
custom_app_data.Creator = task_groups.Creator
task_opunit_configs
custom_app_data.Employee = task_opunit_configs.Creator
custom_app_data.Creator = task_opunit_configs.Creator
task_setups
custom_app_data.Employee = task_setups.Creator
custom_app_data.Creator = task_setups.Creator
tasks
custom_app_data.Employee = tasks.Creator
custom_app_data.Creator = tasks.Creator
teams
custom_app_data.Employee = teams.LeaderEmployee
custom_app_data.Creator = teams.LeaderEmployee
custom_app_data.Employee = teams.Creator
custom_app_data.Creator = teams.Creator
timesheet_pay_returns
custom_app_data.Employee = timesheet_pay_returns.Creator
custom_app_data.Creator = timesheet_pay_returns.Creator
timesheets
custom_app_data.Employee = timesheets.Employee
custom_app_data.Creator = timesheets.Employee
custom_app_data.Employee = timesheets.Creator
custom_app_data.Creator = timesheets.Creator
training_modules
custom_app_data.Employee = training_modules.Creator
custom_app_data.Creator = training_modules.Creator
training_records
custom_app_data.Employee = training_records.Employee
custom_app_data.Creator = training_records.Employee
custom_app_data.Employee = training_records.Creator
custom_app_data.Creator = training_records.Creator
webhooks
custom_app_data.Employee = webhooks.Creator
custom_app_data.Creator = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

Data

STRING

Deleted

BOOLEAN

DocumentId

STRING

Employee

INTEGER

Id

INTEGER

KeyInt

INTEGER

KeyString

STRING

Label

STRING

Modified

DATE-TIME

OperationalUnit

INTEGER

Permission

STRING

custom_field_data

The custom_field_data table contains info about custom field data.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join custom_field_data with on
timesheets
custom_field_data.Id = timesheets.CustomFieldData
custom_field_data.Creator = timesheets.Employee
custom_field_data.Creator = timesheets.Creator
addresses
custom_field_data.Creator = addresses.Creator
categories
custom_field_data.Creator = categories.Creator
comments
custom_field_data.Creator = comments.Creator
companies
custom_field_data.Creator = companies.Creator
company_periods
custom_field_data.Creator = company_periods.Creator
contacts
custom_field_data.Creator = contacts.Creator
countries
custom_field_data.Creator = countries.Creator
custom_app_data
custom_field_data.Creator = custom_app_data.Employee
custom_field_data.Creator = custom_app_data.Creator
custom_fields
custom_field_data.Creator = custom_fields.Creator
employee_agreement_history
custom_field_data.Creator = employee_agreement_history.Creator
employee_agreements
custom_field_data.Creator = employee_agreements.EmployeeId
custom_field_data.Creator = employee_agreements.Creator
employee_appraisal
custom_field_data.Creator = employee_appraisal.Creator
custom_field_data.Creator = employee_appraisal.Employee
employee_availability
custom_field_data.Creator = employee_availability.Employee
custom_field_data.Creator = employee_availability.Creator
employee_contract_leave_rules
custom_field_data.Creator = employee_contract_leave_rules.Creator
employee_contracts
custom_field_data.Creator = employee_contracts.Creator
employee_history
custom_field_data.Creator = employee_history.EmployeeId
custom_field_data.Creator = employee_history.Creator
employee_paycycle_returns
custom_field_data.Creator = employee_paycycle_returns.Creator
employee_paycycles
custom_field_data.Creator = employee_paycycles.EmployeeId
custom_field_data.Creator = employee_paycycles.Creator
employee_roles
custom_field_data.Creator = employee_roles.Creator
employee_salary_opunit_costing
custom_field_data.Creator = employee_salary_opunit_costing.Employee
custom_field_data.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
custom_field_data.Creator = employee_workplaces.EmployeeId
custom_field_data.Creator = employee_workplaces.Creator
employment_conditions
custom_field_data.Creator = employment_conditions.Creator
events
custom_field_data.Creator = events.Creator
geo
custom_field_data.Creator = geo.Creator
journal
custom_field_data.Creator = journal.EmployeeId
custom_field_data.Creator = journal.Creator
kiosks
custom_field_data.Creator = kiosks.Creator
leave_accruals
custom_field_data.Creator = leave_accruals.Employee
custom_field_data.Creator = leave_accruals.Creator
leave_pay_lines
custom_field_data.Creator = leave_pay_lines.Creator
leave_rules
custom_field_data.Creator = leave_rules.Creator
leaves
custom_field_data.Creator = leaves.Employee
custom_field_data.Creator = leaves.Creator
memos
custom_field_data.Creator = memos.Creator
operational_units
custom_field_data.Creator = operational_units.Creator
pay_periods
custom_field_data.Creator = pay_periods.Creator
pay_rules
custom_field_data.Creator = pay_rules.Creator
public_holidays
custom_field_data.Creator = public_holidays.Creator
roster_opens
custom_field_data.Creator = roster_opens.Employee
custom_field_data.Creator = roster_opens.Creator
roster_swaps
custom_field_data.Creator = roster_swaps.Employee
custom_field_data.Creator = roster_swaps.Creator
rosters
custom_field_data.Creator = rosters.Employee
custom_field_data.Creator = rosters.ConfirmBy
custom_field_data.Creator = rosters.Creator
sales_data
custom_field_data.Creator = sales_data.Employee
custom_field_data.Creator = sales_data.Creator
schedules
custom_field_data.Creator = schedules.Creator
sms_logs
custom_field_data.Creator = sms_logs.Creator
states
custom_field_data.Creator = states.Creator
stress_profiles
custom_field_data.Creator = stress_profiles.Creator
system_usage_balances
custom_field_data.Creator = system_usage_balances.Creator
system_usage_tracking
custom_field_data.Creator = system_usage_tracking.Creator
task_group_setups
custom_field_data.Creator = task_group_setups.Creator
task_groups
custom_field_data.Creator = task_groups.Creator
task_opunit_configs
custom_field_data.Creator = task_opunit_configs.Creator
task_setups
custom_field_data.Creator = task_setups.Creator
tasks
custom_field_data.Creator = tasks.Creator
teams
custom_field_data.Creator = teams.LeaderEmployee
custom_field_data.Creator = teams.Creator
timesheet_pay_returns
custom_field_data.Creator = timesheet_pay_returns.Creator
training_modules
custom_field_data.Creator = training_modules.Creator
training_records
custom_field_data.Creator = training_records.Employee
custom_field_data.Creator = training_records.Creator
webhooks
custom_field_data.Creator = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

F01

STRING

F02

STRING

F03

STRING

F04

STRING

F05

STRING

F06

STRING

F07

STRING

F08

STRING

F09

STRING

F10

STRING

F11

STRING

F12

STRING

F13

STRING

F14

STRING

F15

STRING

F16

STRING

Id

INTEGER

Modified

DATE-TIME

System

STRING

custom_fields

The custom_fields table contains info about

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join custom_fields with on
addresses
custom_fields.Creator = addresses.Creator
categories
custom_fields.Creator = categories.Creator
comments
custom_fields.Creator = comments.Creator
companies
custom_fields.Creator = companies.Creator
company_periods
custom_fields.Creator = company_periods.Creator
contacts
custom_fields.Creator = contacts.Creator
countries
custom_fields.Creator = countries.Creator
custom_app_data
custom_fields.Creator = custom_app_data.Employee
custom_fields.Creator = custom_app_data.Creator
custom_field_data
custom_fields.Creator = custom_field_data.Creator
employee_agreement_history
custom_fields.Creator = employee_agreement_history.Creator
employee_agreements
custom_fields.Creator = employee_agreements.EmployeeId
custom_fields.Creator = employee_agreements.Creator
employee_appraisal
custom_fields.Creator = employee_appraisal.Creator
custom_fields.Creator = employee_appraisal.Employee
employee_availability
custom_fields.Creator = employee_availability.Employee
custom_fields.Creator = employee_availability.Creator
employee_contract_leave_rules
custom_fields.Creator = employee_contract_leave_rules.Creator
employee_contracts
custom_fields.Creator = employee_contracts.Creator
employee_history
custom_fields.Creator = employee_history.EmployeeId
custom_fields.Creator = employee_history.Creator
employee_paycycle_returns
custom_fields.Creator = employee_paycycle_returns.Creator
employee_paycycles
custom_fields.Creator = employee_paycycles.EmployeeId
custom_fields.Creator = employee_paycycles.Creator
employee_roles
custom_fields.Creator = employee_roles.Creator
employee_salary_opunit_costing
custom_fields.Creator = employee_salary_opunit_costing.Employee
custom_fields.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
custom_fields.Creator = employee_workplaces.EmployeeId
custom_fields.Creator = employee_workplaces.Creator
employment_conditions
custom_fields.Creator = employment_conditions.Creator
events
custom_fields.Creator = events.Creator
geo
custom_fields.Creator = geo.Creator
journal
custom_fields.Creator = journal.EmployeeId
custom_fields.Creator = journal.Creator
kiosks
custom_fields.Creator = kiosks.Creator
leave_accruals
custom_fields.Creator = leave_accruals.Employee
custom_fields.Creator = leave_accruals.Creator
leave_pay_lines
custom_fields.Creator = leave_pay_lines.Creator
leave_rules
custom_fields.Creator = leave_rules.Creator
leaves
custom_fields.Creator = leaves.Employee
custom_fields.Creator = leaves.Creator
memos
custom_fields.Creator = memos.Creator
operational_units
custom_fields.Creator = operational_units.Creator
pay_periods
custom_fields.Creator = pay_periods.Creator
pay_rules
custom_fields.Creator = pay_rules.Creator
public_holidays
custom_fields.Creator = public_holidays.Creator
roster_opens
custom_fields.Creator = roster_opens.Employee
custom_fields.Creator = roster_opens.Creator
roster_swaps
custom_fields.Creator = roster_swaps.Employee
custom_fields.Creator = roster_swaps.Creator
rosters
custom_fields.Creator = rosters.Employee
custom_fields.Creator = rosters.ConfirmBy
custom_fields.Creator = rosters.Creator
sales_data
custom_fields.Creator = sales_data.Employee
custom_fields.Creator = sales_data.Creator
schedules
custom_fields.Creator = schedules.Creator
sms_logs
custom_fields.Creator = sms_logs.Creator
states
custom_fields.Creator = states.Creator
stress_profiles
custom_fields.Creator = stress_profiles.Creator
system_usage_balances
custom_fields.Creator = system_usage_balances.Creator
system_usage_tracking
custom_fields.Creator = system_usage_tracking.Creator
task_group_setups
custom_fields.Creator = task_group_setups.Creator
task_groups
custom_fields.Creator = task_groups.Creator
task_opunit_configs
custom_fields.Creator = task_opunit_configs.Creator
task_setups
custom_fields.Creator = task_setups.Creator
tasks
custom_fields.Creator = tasks.Creator
teams
custom_fields.Creator = teams.LeaderEmployee
custom_fields.Creator = teams.Creator
timesheet_pay_returns
custom_fields.Creator = timesheet_pay_returns.Creator
timesheets
custom_fields.Creator = timesheets.Employee
custom_fields.Creator = timesheets.Creator
training_modules
custom_fields.Creator = training_modules.Creator
training_records
custom_fields.Creator = training_records.Employee
custom_fields.Creator = training_records.Creator
webhooks
custom_fields.Creator = webhooks.Creator

ApiName

STRING

Created

DATE-TIME

Creator

INTEGER

Default

STRING

DeputyField

STRING

Helptext

STRING

Id

INTEGER

Modified

DATE-TIME

Name

STRING

SortOrder

INTEGER

System

STRING

Type

INTEGER

Validation

STRING

ValueList

STRING

employee_agreement_history

The employee_agreement_history table contains info about

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_agreement_history with on
addresses
employee_agreement_history.Creator = addresses.Creator
categories
employee_agreement_history.Creator = categories.Creator
comments
employee_agreement_history.Creator = comments.Creator
companies
employee_agreement_history.Creator = companies.Creator
company_periods
employee_agreement_history.Creator = company_periods.Creator
employee_agreement_history.PayPeriod = company_periods.PayPeriod
contacts
employee_agreement_history.Creator = contacts.Creator
countries
employee_agreement_history.Creator = countries.Creator
custom_app_data
employee_agreement_history.Creator = custom_app_data.Employee
employee_agreement_history.Creator = custom_app_data.Creator
custom_field_data
employee_agreement_history.Creator = custom_field_data.Creator
custom_fields
employee_agreement_history.Creator = custom_fields.Creator
employee_agreements
employee_agreement_history.Creator = employee_agreements.EmployeeId
employee_agreement_history.Creator = employee_agreements.Creator
employee_agreement_history.Id = employee_agreements.HistoryId
employee_agreement_history.AgreementId = employee_agreements.Id
employee_agreement_history.Contract = employee_agreements.Contract
employee_agreement_history.PayPeriod = employee_agreements.PayPeriod
employee_agreement_history.SalaryPayRule = employee_agreements.SalaryPayRule
employee_appraisal
employee_agreement_history.Creator = employee_appraisal.Creator
employee_agreement_history.Creator = employee_appraisal.Employee
employee_availability
employee_agreement_history.Creator = employee_availability.Employee
employee_agreement_history.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_agreement_history.Creator = employee_contract_leave_rules.Creator
employee_agreement_history.Contract = employee_contract_leave_rules.ContractId
employee_agreement_history.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule1
employee_agreement_history.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule2
employee_agreement_history.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule3
employee_contracts
employee_agreement_history.Creator = employee_contracts.Creator
employee_agreement_history.Contract = employee_contracts.Id
employee_agreement_history.SalaryPayRule = employee_contracts.BasePayRule
employee_history
employee_agreement_history.Creator = employee_history.EmployeeId
employee_agreement_history.Creator = employee_history.Creator
employee_paycycle_returns
employee_agreement_history.Creator = employee_paycycle_returns.Creator
employee_agreement_history.SalaryPayRule = employee_paycycle_returns.PayRule
employee_paycycles
employee_agreement_history.Creator = employee_paycycles.EmployeeId
employee_agreement_history.Creator = employee_paycycles.Creator
employee_agreement_history.Id = employee_paycycles.EmployeeAgreementHistoryId
employee_agreement_history.AgreementId = employee_paycycles.EmployeeAgreementId
employee_roles
employee_agreement_history.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_agreement_history.Creator = employee_salary_opunit_costing.Employee
employee_agreement_history.Creator = employee_salary_opunit_costing.Creator
employee_agreement_history.AgreementId = employee_salary_opunit_costing.EmployeeAgreement
employee_workplaces
employee_agreement_history.Creator = employee_workplaces.EmployeeId
employee_agreement_history.Creator = employee_workplaces.Creator
employee_agreement_history.AgreementId = employee_workplaces.Agreement1
employee_agreement_history.AgreementId = employee_workplaces.Agreement2
employee_agreement_history.AgreementId = employee_workplaces.Agreement3
employment_conditions
employee_agreement_history.Creator = employment_conditions.Creator
events
employee_agreement_history.Creator = events.Creator
geo
employee_agreement_history.Creator = geo.Creator
journal
employee_agreement_history.Creator = journal.EmployeeId
employee_agreement_history.Creator = journal.Creator
kiosks
employee_agreement_history.Creator = kiosks.Creator
leave_accruals
employee_agreement_history.Creator = leave_accruals.Employee
employee_agreement_history.Creator = leave_accruals.Creator
leave_pay_lines
employee_agreement_history.Creator = leave_pay_lines.Creator
employee_agreement_history.AgreementId = leave_pay_lines.EmployeeAgreement
leave_rules
employee_agreement_history.Creator = leave_rules.Creator
leaves
employee_agreement_history.Creator = leaves.Employee
employee_agreement_history.Creator = leaves.Creator
memos
employee_agreement_history.Creator = memos.Creator
operational_units
employee_agreement_history.Creator = operational_units.Creator
pay_periods
employee_agreement_history.Creator = pay_periods.Creator
employee_agreement_history.PayPeriod = pay_periods.Id
pay_rules
employee_agreement_history.Creator = pay_rules.Creator
employee_agreement_history.SalaryPayRule = pay_rules.Id
public_holidays
employee_agreement_history.Creator = public_holidays.Creator
roster_opens
employee_agreement_history.Creator = roster_opens.Employee
employee_agreement_history.Creator = roster_opens.Creator
roster_swaps
employee_agreement_history.Creator = roster_swaps.Employee
employee_agreement_history.Creator = roster_swaps.Creator
rosters
employee_agreement_history.Creator = rosters.Employee
employee_agreement_history.Creator = rosters.ConfirmBy
employee_agreement_history.Creator = rosters.Creator
sales_data
employee_agreement_history.Creator = sales_data.Employee
employee_agreement_history.Creator = sales_data.Creator
schedules
employee_agreement_history.Creator = schedules.Creator
sms_logs
employee_agreement_history.Creator = sms_logs.Creator
states
employee_agreement_history.Creator = states.Creator
stress_profiles
employee_agreement_history.Creator = stress_profiles.Creator
system_usage_balances
employee_agreement_history.Creator = system_usage_balances.Creator
system_usage_tracking
employee_agreement_history.Creator = system_usage_tracking.Creator
task_group_setups
employee_agreement_history.Creator = task_group_setups.Creator
task_groups
employee_agreement_history.Creator = task_groups.Creator
task_opunit_configs
employee_agreement_history.Creator = task_opunit_configs.Creator
task_setups
employee_agreement_history.Creator = task_setups.Creator
tasks
employee_agreement_history.Creator = tasks.Creator
teams
employee_agreement_history.Creator = teams.LeaderEmployee
employee_agreement_history.Creator = teams.Creator
timesheet_pay_returns
employee_agreement_history.Creator = timesheet_pay_returns.Creator
employee_agreement_history.SalaryPayRule = timesheet_pay_returns.PayRule
timesheets
employee_agreement_history.Creator = timesheets.Employee
employee_agreement_history.Creator = timesheets.Creator
employee_agreement_history.AgreementId = timesheets.EmployeeAgreement
training_modules
employee_agreement_history.Creator = training_modules.Creator
training_records
employee_agreement_history.Creator = training_records.Employee
employee_agreement_history.Creator = training_records.Creator
webhooks
employee_agreement_history.Creator = webhooks.Creator

Active

BOOLEAN

AgreementId

INTEGER

CompanyName

STRING

Contract

INTEGER

ContractFile

INTEGER

Created

DATE-TIME

Creator

INTEGER

EmpType

INTEGER

Id

INTEGER

Modified

DATE-TIME

PayPeriod

INTEGER

PayPoint

INTEGER

PayrollId

INTEGER

SalaryPayRule

INTEGER

StartDate

DATE

employee_agreements

The employee_agreements table contains info about employee agreements.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_agreements with on
addresses
employee_agreements.EmployeeId = addresses.Creator
employee_agreements.Creator = addresses.Creator
categories
employee_agreements.EmployeeId = categories.Creator
employee_agreements.Creator = categories.Creator
comments
employee_agreements.EmployeeId = comments.Creator
employee_agreements.Creator = comments.Creator
companies
employee_agreements.EmployeeId = companies.Creator
employee_agreements.Creator = companies.Creator
company_periods
employee_agreements.EmployeeId = company_periods.Creator
employee_agreements.Creator = company_periods.Creator
employee_agreements.PayPeriod = company_periods.PayPeriod
contacts
employee_agreements.EmployeeId = contacts.Creator
employee_agreements.Creator = contacts.Creator
countries
employee_agreements.EmployeeId = countries.Creator
employee_agreements.Creator = countries.Creator
custom_app_data
employee_agreements.EmployeeId = custom_app_data.Employee
employee_agreements.Creator = custom_app_data.Employee
employee_agreements.EmployeeId = custom_app_data.Creator
employee_agreements.Creator = custom_app_data.Creator
custom_field_data
employee_agreements.EmployeeId = custom_field_data.Creator
employee_agreements.Creator = custom_field_data.Creator
custom_fields
employee_agreements.EmployeeId = custom_fields.Creator
employee_agreements.Creator = custom_fields.Creator
employee_agreement_history
employee_agreements.EmployeeId = employee_agreement_history.Creator
employee_agreements.Creator = employee_agreement_history.Creator
employee_agreements.HistoryId = employee_agreement_history.Id
employee_agreements.Id = employee_agreement_history.AgreementId
employee_agreements.Contract = employee_agreement_history.Contract
employee_agreements.PayPeriod = employee_agreement_history.PayPeriod
employee_agreements.SalaryPayRule = employee_agreement_history.SalaryPayRule
employee_appraisal
employee_agreements.EmployeeId = employee_appraisal.Creator
employee_agreements.Creator = employee_appraisal.Creator
employee_agreements.EmployeeId = employee_appraisal.Employee
employee_agreements.Creator = employee_appraisal.Employee
employee_availability
employee_agreements.EmployeeId = employee_availability.Employee
employee_agreements.Creator = employee_availability.Employee
employee_agreements.EmployeeId = employee_availability.Creator
employee_agreements.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_agreements.EmployeeId = employee_contract_leave_rules.Creator
employee_agreements.Creator = employee_contract_leave_rules.Creator
employee_agreements.Contract = employee_contract_leave_rules.ContractId
employee_agreements.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule1
employee_agreements.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule2
employee_agreements.SalaryPayRule = employee_contract_leave_rules.LoadingPayRule3
employee_contracts
employee_agreements.EmployeeId = employee_contracts.Creator
employee_agreements.Creator = employee_contracts.Creator
employee_agreements.Contract = employee_contracts.Id
employee_agreements.SalaryPayRule = employee_contracts.BasePayRule
employee_history
employee_agreements.EmployeeId = employee_history.EmployeeId
employee_agreements.Creator = employee_history.EmployeeId
employee_agreements.EmployeeId = employee_history.Creator
employee_agreements.Creator = employee_history.Creator
employee_paycycle_returns
employee_agreements.EmployeeId = employee_paycycle_returns.Creator
employee_agreements.Creator = employee_paycycle_returns.Creator
employee_agreements.SalaryPayRule = employee_paycycle_returns.PayRule
employee_paycycles
employee_agreements.EmployeeId = employee_paycycles.EmployeeId
employee_agreements.Creator = employee_paycycles.EmployeeId
employee_agreements.EmployeeId = employee_paycycles.Creator
employee_agreements.Creator = employee_paycycles.Creator
employee_agreements.HistoryId = employee_paycycles.EmployeeAgreementHistoryId
employee_agreements.Id = employee_paycycles.EmployeeAgreementId
employee_roles
employee_agreements.EmployeeId = employee_roles.Creator
employee_agreements.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_agreements.EmployeeId = employee_salary_opunit_costing.Employee
employee_agreements.Creator = employee_salary_opunit_costing.Employee
employee_agreements.EmployeeId = employee_salary_opunit_costing.Creator
employee_agreements.Creator = employee_salary_opunit_costing.Creator
employee_agreements.Id = employee_salary_opunit_costing.EmployeeAgreement
employee_workplaces
employee_agreements.EmployeeId = employee_workplaces.EmployeeId
employee_agreements.Creator = employee_workplaces.EmployeeId
employee_agreements.EmployeeId = employee_workplaces.Creator
employee_agreements.Creator = employee_workplaces.Creator
employee_agreements.Id = employee_workplaces.Agreement1
employee_agreements.Id = employee_workplaces.Agreement2
employee_agreements.Id = employee_workplaces.Agreement3
employment_conditions
employee_agreements.EmployeeId = employment_conditions.Creator
employee_agreements.Creator = employment_conditions.Creator
events
employee_agreements.EmployeeId = events.Creator
employee_agreements.Creator = events.Creator
geo
employee_agreements.EmployeeId = geo.Creator
employee_agreements.Creator = geo.Creator
journal
employee_agreements.EmployeeId = journal.EmployeeId
employee_agreements.Creator = journal.EmployeeId
employee_agreements.EmployeeId = journal.Creator
employee_agreements.Creator = journal.Creator
kiosks
employee_agreements.EmployeeId = kiosks.Creator
employee_agreements.Creator = kiosks.Creator
leave_accruals
employee_agreements.EmployeeId = leave_accruals.Employee
employee_agreements.Creator = leave_accruals.Employee
employee_agreements.EmployeeId = leave_accruals.Creator
employee_agreements.Creator = leave_accruals.Creator
leave_pay_lines
employee_agreements.EmployeeId = leave_pay_lines.Creator
employee_agreements.Creator = leave_pay_lines.Creator
employee_agreements.Id = leave_pay_lines.EmployeeAgreement
leave_rules
employee_agreements.EmployeeId = leave_rules.Creator
employee_agreements.Creator = leave_rules.Creator
leaves
employee_agreements.EmployeeId = leaves.Employee
employee_agreements.Creator = leaves.Employee
employee_agreements.EmployeeId = leaves.Creator
employee_agreements.Creator = leaves.Creator
memos
employee_agreements.EmployeeId = memos.Creator
employee_agreements.Creator = memos.Creator
operational_units
employee_agreements.EmployeeId = operational_units.Creator
employee_agreements.Creator = operational_units.Creator
pay_periods
employee_agreements.EmployeeId = pay_periods.Creator
employee_agreements.Creator = pay_periods.Creator
employee_agreements.PayPeriod = pay_periods.Id
pay_rules
employee_agreements.EmployeeId = pay_rules.Creator
employee_agreements.Creator = pay_rules.Creator
employee_agreements.SalaryPayRule = pay_rules.Id
public_holidays
employee_agreements.EmployeeId = public_holidays.Creator
employee_agreements.Creator = public_holidays.Creator
roster_opens
employee_agreements.EmployeeId = roster_opens.Employee
employee_agreements.Creator = roster_opens.Employee
employee_agreements.EmployeeId = roster_opens.Creator
employee_agreements.Creator = roster_opens.Creator
roster_swaps
employee_agreements.EmployeeId = roster_swaps.Employee
employee_agreements.Creator = roster_swaps.Employee
employee_agreements.EmployeeId = roster_swaps.Creator
employee_agreements.Creator = roster_swaps.Creator
rosters
employee_agreements.EmployeeId = rosters.Employee
employee_agreements.Creator = rosters.Employee
employee_agreements.EmployeeId = rosters.ConfirmBy
employee_agreements.Creator = rosters.ConfirmBy
employee_agreements.EmployeeId = rosters.Creator
employee_agreements.Creator = rosters.Creator
sales_data
employee_agreements.EmployeeId = sales_data.Employee
employee_agreements.Creator = sales_data.Employee
employee_agreements.EmployeeId = sales_data.Creator
employee_agreements.Creator = sales_data.Creator
schedules
employee_agreements.EmployeeId = schedules.Creator
employee_agreements.Creator = schedules.Creator
sms_logs
employee_agreements.EmployeeId = sms_logs.Creator
employee_agreements.Creator = sms_logs.Creator
states
employee_agreements.EmployeeId = states.Creator
employee_agreements.Creator = states.Creator
stress_profiles
employee_agreements.EmployeeId = stress_profiles.Creator
employee_agreements.Creator = stress_profiles.Creator
system_usage_balances
employee_agreements.EmployeeId = system_usage_balances.Creator
employee_agreements.Creator = system_usage_balances.Creator
system_usage_tracking
employee_agreements.EmployeeId = system_usage_tracking.Creator
employee_agreements.Creator = system_usage_tracking.Creator
task_group_setups
employee_agreements.EmployeeId = task_group_setups.Creator
employee_agreements.Creator = task_group_setups.Creator
task_groups
employee_agreements.EmployeeId = task_groups.Creator
employee_agreements.Creator = task_groups.Creator
task_opunit_configs
employee_agreements.EmployeeId = task_opunit_configs.Creator
employee_agreements.Creator = task_opunit_configs.Creator
task_setups
employee_agreements.EmployeeId = task_setups.Creator
employee_agreements.Creator = task_setups.Creator
tasks
employee_agreements.EmployeeId = tasks.Creator
employee_agreements.Creator = tasks.Creator
teams
employee_agreements.EmployeeId = teams.LeaderEmployee
employee_agreements.Creator = teams.LeaderEmployee
employee_agreements.EmployeeId = teams.Creator
employee_agreements.Creator = teams.Creator
timesheet_pay_returns
employee_agreements.EmployeeId = timesheet_pay_returns.Creator
employee_agreements.Creator = timesheet_pay_returns.Creator
employee_agreements.SalaryPayRule = timesheet_pay_returns.PayRule
timesheets
employee_agreements.EmployeeId = timesheets.Employee
employee_agreements.Creator = timesheets.Employee
employee_agreements.EmployeeId = timesheets.Creator
employee_agreements.Creator = timesheets.Creator
employee_agreements.Id = timesheets.EmployeeAgreement
training_modules
employee_agreements.EmployeeId = training_modules.Creator
employee_agreements.Creator = training_modules.Creator
training_records
employee_agreements.EmployeeId = training_records.Employee
employee_agreements.Creator = training_records.Employee
employee_agreements.EmployeeId = training_records.Creator
employee_agreements.Creator = training_records.Creator
webhooks
employee_agreements.EmployeeId = webhooks.Creator
employee_agreements.Creator = webhooks.Creator

Active

BOOLEAN

CompanyName

STRING

Contract

INTEGER

ContractFile

INTEGER

Created

DATE-TIME

Creator

INTEGER

EmpType

INTEGER

EmployeeId

INTEGER

HistoryId

INTEGER

Id

INTEGER

Modified

DATE-TIME

PayPeriod

INTEGER

PayPoint

INTEGER

PayrollId

INTEGER

SalaryPayRule

INTEGER

StartDate

DATE

employee_appraisal

The employee_appraisal table contains info about employee appraisals.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_appraisal with on
addresses
employee_appraisal.Creator = addresses.Creator
employee_appraisal.Employee = addresses.Creator
categories
employee_appraisal.Creator = categories.Creator
employee_appraisal.Employee = categories.Creator
comments
employee_appraisal.Creator = comments.Creator
employee_appraisal.Employee = comments.Creator
companies
employee_appraisal.Creator = companies.Creator
employee_appraisal.Employee = companies.Creator
company_periods
employee_appraisal.Creator = company_periods.Creator
employee_appraisal.Employee = company_periods.Creator
contacts
employee_appraisal.Creator = contacts.Creator
employee_appraisal.Employee = contacts.Creator
countries
employee_appraisal.Creator = countries.Creator
employee_appraisal.Employee = countries.Creator
custom_app_data
employee_appraisal.Creator = custom_app_data.Employee
employee_appraisal.Employee = custom_app_data.Employee
employee_appraisal.Creator = custom_app_data.Creator
employee_appraisal.Employee = custom_app_data.Creator
custom_field_data
employee_appraisal.Creator = custom_field_data.Creator
employee_appraisal.Employee = custom_field_data.Creator
custom_fields
employee_appraisal.Creator = custom_fields.Creator
employee_appraisal.Employee = custom_fields.Creator
employee_agreement_history
employee_appraisal.Creator = employee_agreement_history.Creator
employee_appraisal.Employee = employee_agreement_history.Creator
employee_agreements
employee_appraisal.Creator = employee_agreements.EmployeeId
employee_appraisal.Employee = employee_agreements.EmployeeId
employee_appraisal.Creator = employee_agreements.Creator
employee_appraisal.Employee = employee_agreements.Creator
employee_availability
employee_appraisal.Creator = employee_availability.Employee
employee_appraisal.Employee = employee_availability.Employee
employee_appraisal.Creator = employee_availability.Creator
employee_appraisal.Employee = employee_availability.Creator
employee_contract_leave_rules
employee_appraisal.Creator = employee_contract_leave_rules.Creator
employee_appraisal.Employee = employee_contract_leave_rules.Creator
employee_contracts
employee_appraisal.Creator = employee_contracts.Creator
employee_appraisal.Employee = employee_contracts.Creator
employee_history
employee_appraisal.Creator = employee_history.EmployeeId
employee_appraisal.Employee = employee_history.EmployeeId
employee_appraisal.Creator = employee_history.Creator
employee_appraisal.Employee = employee_history.Creator
employee_paycycle_returns
employee_appraisal.Creator = employee_paycycle_returns.Creator
employee_appraisal.Employee = employee_paycycle_returns.Creator
employee_paycycles
employee_appraisal.Creator = employee_paycycles.EmployeeId
employee_appraisal.Employee = employee_paycycles.EmployeeId
employee_appraisal.Creator = employee_paycycles.Creator
employee_appraisal.Employee = employee_paycycles.Creator
employee_roles
employee_appraisal.Creator = employee_roles.Creator
employee_appraisal.Employee = employee_roles.Creator
employee_salary_opunit_costing
employee_appraisal.Creator = employee_salary_opunit_costing.Employee
employee_appraisal.Employee = employee_salary_opunit_costing.Employee
employee_appraisal.Creator = employee_salary_opunit_costing.Creator
employee_appraisal.Employee = employee_salary_opunit_costing.Creator
employee_workplaces
employee_appraisal.Creator = employee_workplaces.EmployeeId
employee_appraisal.Employee = employee_workplaces.EmployeeId
employee_appraisal.Creator = employee_workplaces.Creator
employee_appraisal.Employee = employee_workplaces.Creator
employment_conditions
employee_appraisal.Creator = employment_conditions.Creator
employee_appraisal.Employee = employment_conditions.Creator
events
employee_appraisal.Creator = events.Creator
employee_appraisal.Employee = events.Creator
geo
employee_appraisal.Creator = geo.Creator
employee_appraisal.Employee = geo.Creator
journal
employee_appraisal.Creator = journal.EmployeeId
employee_appraisal.Employee = journal.EmployeeId
employee_appraisal.Creator = journal.Creator
employee_appraisal.Employee = journal.Creator
kiosks
employee_appraisal.Creator = kiosks.Creator
employee_appraisal.Employee = kiosks.Creator
leave_accruals
employee_appraisal.Creator = leave_accruals.Employee
employee_appraisal.Employee = leave_accruals.Employee
employee_appraisal.Creator = leave_accruals.Creator
employee_appraisal.Employee = leave_accruals.Creator
leave_pay_lines
employee_appraisal.Creator = leave_pay_lines.Creator
employee_appraisal.Employee = leave_pay_lines.Creator
leave_rules
employee_appraisal.Creator = leave_rules.Creator
employee_appraisal.Employee = leave_rules.Creator
leaves
employee_appraisal.Creator = leaves.Employee
employee_appraisal.Employee = leaves.Employee
employee_appraisal.Creator = leaves.Creator
employee_appraisal.Employee = leaves.Creator
memos
employee_appraisal.Creator = memos.Creator
employee_appraisal.Employee = memos.Creator
operational_units
employee_appraisal.Creator = operational_units.Creator
employee_appraisal.Employee = operational_units.Creator
pay_periods
employee_appraisal.Creator = pay_periods.Creator
employee_appraisal.Employee = pay_periods.Creator
pay_rules
employee_appraisal.Creator = pay_rules.Creator
employee_appraisal.Employee = pay_rules.Creator
public_holidays
employee_appraisal.Creator = public_holidays.Creator
employee_appraisal.Employee = public_holidays.Creator
roster_opens
employee_appraisal.Creator = roster_opens.Employee
employee_appraisal.Employee = roster_opens.Employee
employee_appraisal.Creator = roster_opens.Creator
employee_appraisal.Employee = roster_opens.Creator
roster_swaps
employee_appraisal.Creator = roster_swaps.Employee
employee_appraisal.Employee = roster_swaps.Employee
employee_appraisal.Creator = roster_swaps.Creator
employee_appraisal.Employee = roster_swaps.Creator
rosters
employee_appraisal.Creator = rosters.Employee
employee_appraisal.Employee = rosters.Employee
employee_appraisal.Creator = rosters.ConfirmBy
employee_appraisal.Employee = rosters.ConfirmBy
employee_appraisal.Creator = rosters.Creator
employee_appraisal.Employee = rosters.Creator
sales_data
employee_appraisal.Creator = sales_data.Employee
employee_appraisal.Employee = sales_data.Employee
employee_appraisal.Creator = sales_data.Creator
employee_appraisal.Employee = sales_data.Creator
schedules
employee_appraisal.Creator = schedules.Creator
employee_appraisal.Employee = schedules.Creator
sms_logs
employee_appraisal.Creator = sms_logs.Creator
employee_appraisal.Employee = sms_logs.Creator
states
employee_appraisal.Creator = states.Creator
employee_appraisal.Employee = states.Creator
stress_profiles
employee_appraisal.Creator = stress_profiles.Creator
employee_appraisal.Employee = stress_profiles.Creator
system_usage_balances
employee_appraisal.Creator = system_usage_balances.Creator
employee_appraisal.Employee = system_usage_balances.Creator
system_usage_tracking
employee_appraisal.Creator = system_usage_tracking.Creator
employee_appraisal.Employee = system_usage_tracking.Creator
task_group_setups
employee_appraisal.Creator = task_group_setups.Creator
employee_appraisal.Employee = task_group_setups.Creator
task_groups
employee_appraisal.Creator = task_groups.Creator
employee_appraisal.Employee = task_groups.Creator
task_opunit_configs
employee_appraisal.Creator = task_opunit_configs.Creator
employee_appraisal.Employee = task_opunit_configs.Creator
task_setups
employee_appraisal.Creator = task_setups.Creator
employee_appraisal.Employee = task_setups.Creator
tasks
employee_appraisal.Creator = tasks.Creator
employee_appraisal.Employee = tasks.Creator
teams
employee_appraisal.Creator = teams.LeaderEmployee
employee_appraisal.Employee = teams.LeaderEmployee
employee_appraisal.Creator = teams.Creator
employee_appraisal.Employee = teams.Creator
timesheet_pay_returns
employee_appraisal.Creator = timesheet_pay_returns.Creator
employee_appraisal.Employee = timesheet_pay_returns.Creator
timesheets
employee_appraisal.Creator = timesheets.Employee
employee_appraisal.Employee = timesheets.Employee
employee_appraisal.Creator = timesheets.Creator
employee_appraisal.Employee = timesheets.Creator
training_modules
employee_appraisal.Creator = training_modules.Creator
employee_appraisal.Employee = training_modules.Creator
training_records
employee_appraisal.Creator = training_records.Employee
employee_appraisal.Employee = training_records.Employee
employee_appraisal.Creator = training_records.Creator
employee_appraisal.Employee = training_records.Creator
webhooks
employee_appraisal.Creator = webhooks.Creator
employee_appraisal.Employee = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

Date

DATE

DayTimestamp

INTEGER

Employee

INTEGER

Id

INTEGER

Mark01

NUMBER

Mark02

NUMBER

Mark03

NUMBER

Mark04

NUMBER

Mark05

NUMBER

Modified

DATE-TIME

employee_availability

The employee_availability table contains info about employee availability.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_availability with on
addresses
employee_availability.Employee = addresses.Creator
employee_availability.Creator = addresses.Creator
categories
employee_availability.Employee = categories.Creator
employee_availability.Creator = categories.Creator
comments
employee_availability.Employee = comments.Creator
employee_availability.Creator = comments.Creator
companies
employee_availability.Employee = companies.Creator
employee_availability.Creator = companies.Creator
company_periods
employee_availability.Employee = company_periods.Creator
employee_availability.Creator = company_periods.Creator
contacts
employee_availability.Employee = contacts.Creator
employee_availability.Creator = contacts.Creator
countries
employee_availability.Employee = countries.Creator
employee_availability.Creator = countries.Creator
custom_app_data
employee_availability.Employee = custom_app_data.Employee
employee_availability.Creator = custom_app_data.Employee
employee_availability.Employee = custom_app_data.Creator
employee_availability.Creator = custom_app_data.Creator
custom_field_data
employee_availability.Employee = custom_field_data.Creator
employee_availability.Creator = custom_field_data.Creator
custom_fields
employee_availability.Employee = custom_fields.Creator
employee_availability.Creator = custom_fields.Creator
employee_agreement_history
employee_availability.Employee = employee_agreement_history.Creator
employee_availability.Creator = employee_agreement_history.Creator
employee_agreements
employee_availability.Employee = employee_agreements.EmployeeId
employee_availability.Creator = employee_agreements.EmployeeId
employee_availability.Employee = employee_agreements.Creator
employee_availability.Creator = employee_agreements.Creator
employee_appraisal
employee_availability.Employee = employee_appraisal.Creator
employee_availability.Creator = employee_appraisal.Creator
employee_availability.Employee = employee_appraisal.Employee
employee_availability.Creator = employee_appraisal.Employee
employee_contract_leave_rules
employee_availability.Employee = employee_contract_leave_rules.Creator
employee_availability.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_availability.Employee = employee_contracts.Creator
employee_availability.Creator = employee_contracts.Creator
employee_history
employee_availability.Employee = employee_history.EmployeeId
employee_availability.Creator = employee_history.EmployeeId
employee_availability.Employee = employee_history.Creator
employee_availability.Creator = employee_history.Creator
employee_paycycle_returns
employee_availability.Employee = employee_paycycle_returns.Creator
employee_availability.Creator = employee_paycycle_returns.Creator
employee_paycycles
employee_availability.Employee = employee_paycycles.EmployeeId
employee_availability.Creator = employee_paycycles.EmployeeId
employee_availability.Employee = employee_paycycles.Creator
employee_availability.Creator = employee_paycycles.Creator
employee_roles
employee_availability.Employee = employee_roles.Creator
employee_availability.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_availability.Employee = employee_salary_opunit_costing.Employee
employee_availability.Creator = employee_salary_opunit_costing.Employee
employee_availability.Employee = employee_salary_opunit_costing.Creator
employee_availability.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employee_availability.Employee = employee_workplaces.EmployeeId
employee_availability.Creator = employee_workplaces.EmployeeId
employee_availability.Employee = employee_workplaces.Creator
employee_availability.Creator = employee_workplaces.Creator
employment_conditions
employee_availability.Employee = employment_conditions.Creator
employee_availability.Creator = employment_conditions.Creator
events
employee_availability.Employee = events.Creator
employee_availability.Creator = events.Creator
employee_availability.Schedule = events.Schedule
geo
employee_availability.Employee = geo.Creator
employee_availability.Creator = geo.Creator
journal
employee_availability.Employee = journal.EmployeeId
employee_availability.Creator = journal.EmployeeId
employee_availability.Employee = journal.Creator
employee_availability.Creator = journal.Creator
kiosks
employee_availability.Employee = kiosks.Creator
employee_availability.Creator = kiosks.Creator
leave_accruals
employee_availability.Employee = leave_accruals.Employee
employee_availability.Creator = leave_accruals.Employee
employee_availability.Employee = leave_accruals.Creator
employee_availability.Creator = leave_accruals.Creator
leave_pay_lines
employee_availability.Employee = leave_pay_lines.Creator
employee_availability.Creator = leave_pay_lines.Creator
leave_rules
employee_availability.Employee = leave_rules.Creator
employee_availability.Creator = leave_rules.Creator
leaves
employee_availability.Employee = leaves.Employee
employee_availability.Creator = leaves.Employee
employee_availability.Employee = leaves.Creator
employee_availability.Creator = leaves.Creator
memos
employee_availability.Employee = memos.Creator
employee_availability.Creator = memos.Creator
operational_units
employee_availability.Employee = operational_units.Creator
employee_availability.Creator = operational_units.Creator
employee_availability.Schedule = operational_units.RosterActiveHoursSchedule
pay_periods
employee_availability.Employee = pay_periods.Creator
employee_availability.Creator = pay_periods.Creator
pay_rules
employee_availability.Employee = pay_rules.Creator
employee_availability.Creator = pay_rules.Creator
employee_availability.Schedule = pay_rules.Schedule
public_holidays
employee_availability.Employee = public_holidays.Creator
employee_availability.Creator = public_holidays.Creator
roster_opens
employee_availability.Employee = roster_opens.Employee
employee_availability.Creator = roster_opens.Employee
employee_availability.Employee = roster_opens.Creator
employee_availability.Creator = roster_opens.Creator
roster_swaps
employee_availability.Employee = roster_swaps.Employee
employee_availability.Creator = roster_swaps.Employee
employee_availability.Employee = roster_swaps.Creator
employee_availability.Creator = roster_swaps.Creator
rosters
employee_availability.Employee = rosters.Employee
employee_availability.Creator = rosters.Employee
employee_availability.Employee = rosters.ConfirmBy
employee_availability.Creator = rosters.ConfirmBy
employee_availability.Employee = rosters.Creator
employee_availability.Creator = rosters.Creator
sales_data
employee_availability.Employee = sales_data.Employee
employee_availability.Creator = sales_data.Employee
employee_availability.Employee = sales_data.Creator
employee_availability.Creator = sales_data.Creator
schedules
employee_availability.Employee = schedules.Creator
employee_availability.Creator = schedules.Creator
employee_availability.Schedule = schedules.Id
sms_logs
employee_availability.Employee = sms_logs.Creator
employee_availability.Creator = sms_logs.Creator
states
employee_availability.Employee = states.Creator
employee_availability.Creator = states.Creator
stress_profiles
employee_availability.Employee = stress_profiles.Creator
employee_availability.Creator = stress_profiles.Creator
system_usage_balances
employee_availability.Employee = system_usage_balances.Creator
employee_availability.Creator = system_usage_balances.Creator
system_usage_tracking
employee_availability.Employee = system_usage_tracking.Creator
employee_availability.Creator = system_usage_tracking.Creator
task_group_setups
employee_availability.Employee = task_group_setups.Creator
employee_availability.Creator = task_group_setups.Creator
task_groups
employee_availability.Employee = task_groups.Creator
employee_availability.Creator = task_groups.Creator
task_opunit_configs
employee_availability.Employee = task_opunit_configs.Creator
employee_availability.Creator = task_opunit_configs.Creator
employee_availability.Schedule = task_opunit_configs.Schedule
task_setups
employee_availability.Employee = task_setups.Creator
employee_availability.Creator = task_setups.Creator
employee_availability.Schedule = task_setups.Schedule
tasks
employee_availability.Employee = tasks.Creator
employee_availability.Creator = tasks.Creator
teams
employee_availability.Employee = teams.LeaderEmployee
employee_availability.Creator = teams.LeaderEmployee
employee_availability.Employee = teams.Creator
employee_availability.Creator = teams.Creator
timesheet_pay_returns
employee_availability.Employee = timesheet_pay_returns.Creator
employee_availability.Creator = timesheet_pay_returns.Creator
timesheets
employee_availability.Employee = timesheets.Employee
employee_availability.Creator = timesheets.Employee
employee_availability.Employee = timesheets.Creator
employee_availability.Creator = timesheets.Creator
training_modules
employee_availability.Employee = training_modules.Creator
employee_availability.Creator = training_modules.Creator
training_records
employee_availability.Employee = training_records.Employee
employee_availability.Creator = training_records.Employee
employee_availability.Employee = training_records.Creator
employee_availability.Creator = training_records.Creator
webhooks
employee_availability.Employee = webhooks.Creator
employee_availability.Creator = webhooks.Creator

Comment

INTEGER

Created

DATE-TIME

Creator

INTEGER

Date

DATE

Employee

INTEGER

EndTime

INTEGER

Id

INTEGER

MaxDateRecurringGenerated

DATE

Modified

DATE-TIME

Schedule

INTEGER

StartTime

INTEGER

Type

INTEGER

employee_contract_leave_rules

The employee_contract_leave_rules table contains info about employment contract leave rules.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_contract_leave_rules with on
addresses
employee_contract_leave_rules.Creator = addresses.Creator
categories
employee_contract_leave_rules.Creator = categories.Creator
comments
employee_contract_leave_rules.Creator = comments.Creator
companies
employee_contract_leave_rules.Creator = companies.Creator
company_periods
employee_contract_leave_rules.Creator = company_periods.Creator
contacts
employee_contract_leave_rules.Creator = contacts.Creator
countries
employee_contract_leave_rules.Creator = countries.Creator
custom_app_data
employee_contract_leave_rules.Creator = custom_app_data.Employee
employee_contract_leave_rules.Creator = custom_app_data.Creator
custom_field_data
employee_contract_leave_rules.Creator = custom_field_data.Creator
custom_fields
employee_contract_leave_rules.Creator = custom_fields.Creator
employee_agreement_history
employee_contract_leave_rules.Creator = employee_agreement_history.Creator
employee_contract_leave_rules.ContractId = employee_agreement_history.Contract
employee_contract_leave_rules.LoadingPayRule1 = employee_agreement_history.SalaryPayRule
employee_contract_leave_rules.LoadingPayRule2 = employee_agreement_history.SalaryPayRule
employee_contract_leave_rules.LoadingPayRule3 = employee_agreement_history.SalaryPayRule
employee_agreements
employee_contract_leave_rules.Creator = employee_agreements.EmployeeId
employee_contract_leave_rules.Creator = employee_agreements.Creator
employee_contract_leave_rules.ContractId = employee_agreements.Contract
employee_contract_leave_rules.LoadingPayRule1 = employee_agreements.SalaryPayRule
employee_contract_leave_rules.LoadingPayRule2 = employee_agreements.SalaryPayRule
employee_contract_leave_rules.LoadingPayRule3 = employee_agreements.SalaryPayRule
employee_appraisal
employee_contract_leave_rules.Creator = employee_appraisal.Creator
employee_contract_leave_rules.Creator = employee_appraisal.Employee
employee_availability
employee_contract_leave_rules.Creator = employee_availability.Employee
employee_contract_leave_rules.Creator = employee_availability.Creator
employee_contracts
employee_contract_leave_rules.Creator = employee_contracts.Creator
employee_contract_leave_rules.ContractId = employee_contracts.Id
employee_contract_leave_rules.LoadingPayRule1 = employee_contracts.BasePayRule
employee_contract_leave_rules.LoadingPayRule2 = employee_contracts.BasePayRule
employee_contract_leave_rules.LoadingPayRule3 = employee_contracts.BasePayRule
employee_history
employee_contract_leave_rules.Creator = employee_history.EmployeeId
employee_contract_leave_rules.Creator = employee_history.Creator
employee_paycycle_returns
employee_contract_leave_rules.Creator = employee_paycycle_returns.Creator
employee_contract_leave_rules.LoadingPayRule1 = employee_paycycle_returns.PayRule
employee_contract_leave_rules.LoadingPayRule2 = employee_paycycle_returns.PayRule
employee_contract_leave_rules.LoadingPayRule3 = employee_paycycle_returns.PayRule
employee_paycycles
employee_contract_leave_rules.Creator = employee_paycycles.EmployeeId
employee_contract_leave_rules.Creator = employee_paycycles.Creator
employee_roles
employee_contract_leave_rules.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_contract_leave_rules.Creator = employee_salary_opunit_costing.Employee
employee_contract_leave_rules.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employee_contract_leave_rules.Creator = employee_workplaces.EmployeeId
employee_contract_leave_rules.Creator = employee_workplaces.Creator
employment_conditions
employee_contract_leave_rules.Creator = employment_conditions.Creator
events
employee_contract_leave_rules.Creator = events.Creator
geo
employee_contract_leave_rules.Creator = geo.Creator
journal
employee_contract_leave_rules.Creator = journal.EmployeeId
employee_contract_leave_rules.Creator = journal.Creator
kiosks
employee_contract_leave_rules.Creator = kiosks.Creator
leave_accruals
employee_contract_leave_rules.Creator = leave_accruals.Employee
employee_contract_leave_rules.Creator = leave_accruals.Creator
employee_contract_leave_rules.LeaveRuleId = leave_accruals.LeaveRule
leave_pay_lines
employee_contract_leave_rules.Creator = leave_pay_lines.Creator
employee_contract_leave_rules.LeaveRuleId = leave_pay_lines.LeaveRule
leave_rules
employee_contract_leave_rules.Creator = leave_rules.Creator
employee_contract_leave_rules.LeaveRuleId = leave_rules.Id
leaves
employee_contract_leave_rules.Creator = leaves.Employee
employee_contract_leave_rules.Creator = leaves.Creator
memos
employee_contract_leave_rules.Creator = memos.Creator
operational_units
employee_contract_leave_rules.Creator = operational_units.Creator
pay_periods
employee_contract_leave_rules.Creator = pay_periods.Creator
pay_rules
employee_contract_leave_rules.Creator = pay_rules.Creator
employee_contract_leave_rules.LoadingPayRule1 = pay_rules.Id
employee_contract_leave_rules.LoadingPayRule2 = pay_rules.Id
employee_contract_leave_rules.LoadingPayRule3 = pay_rules.Id
public_holidays
employee_contract_leave_rules.Creator = public_holidays.Creator
roster_opens
employee_contract_leave_rules.Creator = roster_opens.Employee
employee_contract_leave_rules.Creator = roster_opens.Creator
roster_swaps
employee_contract_leave_rules.Creator = roster_swaps.Employee
employee_contract_leave_rules.Creator = roster_swaps.Creator
rosters
employee_contract_leave_rules.Creator = rosters.Employee
employee_contract_leave_rules.Creator = rosters.ConfirmBy
employee_contract_leave_rules.Creator = rosters.Creator
sales_data
employee_contract_leave_rules.Creator = sales_data.Employee
employee_contract_leave_rules.Creator = sales_data.Creator
schedules
employee_contract_leave_rules.Creator = schedules.Creator
sms_logs
employee_contract_leave_rules.Creator = sms_logs.Creator
states
employee_contract_leave_rules.Creator = states.Creator
stress_profiles
employee_contract_leave_rules.Creator = stress_profiles.Creator
system_usage_balances
employee_contract_leave_rules.Creator = system_usage_balances.Creator
system_usage_tracking
employee_contract_leave_rules.Creator = system_usage_tracking.Creator
task_group_setups
employee_contract_leave_rules.Creator = task_group_setups.Creator
task_groups
employee_contract_leave_rules.Creator = task_groups.Creator
task_opunit_configs
employee_contract_leave_rules.Creator = task_opunit_configs.Creator
task_setups
employee_contract_leave_rules.Creator = task_setups.Creator
tasks
employee_contract_leave_rules.Creator = tasks.Creator
teams
employee_contract_leave_rules.Creator = teams.LeaderEmployee
employee_contract_leave_rules.Creator = teams.Creator
timesheet_pay_returns
employee_contract_leave_rules.Creator = timesheet_pay_returns.Creator
employee_contract_leave_rules.LoadingPayRule1 = timesheet_pay_returns.PayRule
employee_contract_leave_rules.LoadingPayRule2 = timesheet_pay_returns.PayRule
employee_contract_leave_rules.LoadingPayRule3 = timesheet_pay_returns.PayRule
timesheets
employee_contract_leave_rules.Creator = timesheets.Employee
employee_contract_leave_rules.Creator = timesheets.Creator
employee_contract_leave_rules.LeaveRuleId = timesheets.LeaveRule
training_modules
employee_contract_leave_rules.Creator = training_modules.Creator
training_records
employee_contract_leave_rules.Creator = training_records.Employee
employee_contract_leave_rules.Creator = training_records.Creator
webhooks
employee_contract_leave_rules.Creator = webhooks.Creator

ContractId

INTEGER

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

LeaveRuleId

INTEGER

LoadingPayRule1

INTEGER

LoadingPayRule2

INTEGER

LoadingPayRule3

INTEGER

Modified

DATE-TIME

employee_contracts

The employee_contracts table contains info about employee contracts.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Join employee_contracts with on
categories
employee_contracts.EmploymentCategory = categories.Id
employee_contracts.Creator = categories.Creator
employment_conditions
employee_contracts.EmploymentCategory = employment_conditions.EmploymentCategory
employee_contracts.Creator = employment_conditions.Creator
employee_contracts.EmploymentCondition = employment_conditions.Id
addresses
employee_contracts.Creator = addresses.Creator
comments
employee_contracts.Creator = comments.Creator
companies
employee_contracts.Creator = companies.Creator
company_periods
employee_contracts.Creator = company_periods.Creator
contacts
employee_contracts.Creator = contacts.Creator
countries
employee_contracts.Creator = countries.Creator
custom_app_data
employee_contracts.Creator = custom_app_data.Employee
employee_contracts.Creator = custom_app_data.Creator
custom_field_data
employee_contracts.Creator = custom_field_data.Creator
custom_fields
employee_contracts.Creator = custom_fields.Creator
employee_agreement_history
employee_contracts.Creator = employee_agreement_history.Creator
employee_contracts.Id = employee_agreement_history.Contract
employee_contracts.BasePayRule = employee_agreement_history.SalaryPayRule
employee_agreements
employee_contracts.Creator = employee_agreements.EmployeeId
employee_contracts.Creator = employee_agreements.Creator
employee_contracts.Id = employee_agreements.Contract
employee_contracts.BasePayRule = employee_agreements.SalaryPayRule
employee_appraisal
employee_contracts.Creator = employee_appraisal.Creator
employee_contracts.Creator = employee_appraisal.Employee
employee_availability
employee_contracts.Creator = employee_availability.Employee
employee_contracts.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_contracts.Creator = employee_contract_leave_rules.Creator
employee_contracts.Id = employee_contract_leave_rules.ContractId
employee_contracts.BasePayRule = employee_contract_leave_rules.LoadingPayRule1
employee_contracts.BasePayRule = employee_contract_leave_rules.LoadingPayRule2
employee_contracts.BasePayRule = employee_contract_leave_rules.LoadingPayRule3
employee_history
employee_contracts.Creator = employee_history.EmployeeId
employee_contracts.Creator = employee_history.Creator
employee_paycycle_returns
employee_contracts.Creator = employee_paycycle_returns.Creator
employee_contracts.BasePayRule = employee_paycycle_returns.PayRule
employee_paycycles
employee_contracts.Creator = employee_paycycles.EmployeeId
employee_contracts.Creator = employee_paycycles.Creator
employee_roles
employee_contracts.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_contracts.Creator = employee_salary_opunit_costing.Employee
employee_contracts.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employee_contracts.Creator = employee_workplaces.EmployeeId
employee_contracts.Creator = employee_workplaces.Creator
events
employee_contracts.Creator = events.Creator
geo
employee_contracts.Creator = geo.Creator
journal
employee_contracts.Creator = journal.EmployeeId
employee_contracts.Creator = journal.Creator
kiosks
employee_contracts.Creator = kiosks.Creator
leave_accruals
employee_contracts.Creator = leave_accruals.Employee
employee_contracts.Creator = leave_accruals.Creator
leave_pay_lines
employee_contracts.Creator = leave_pay_lines.Creator
leave_rules
employee_contracts.Creator = leave_rules.Creator
leaves
employee_contracts.Creator = leaves.Employee
employee_contracts.Creator = leaves.Creator
memos
employee_contracts.Creator = memos.Creator
operational_units
employee_contracts.Creator = operational_units.Creator
pay_periods
employee_contracts.Creator = pay_periods.Creator
pay_rules
employee_contracts.Creator = pay_rules.Creator
employee_contracts.BasePayRule = pay_rules.Id
public_holidays
employee_contracts.Creator = public_holidays.Creator
roster_opens
employee_contracts.Creator = roster_opens.Employee
employee_contracts.Creator = roster_opens.Creator
roster_swaps
employee_contracts.Creator = roster_swaps.Employee
employee_contracts.Creator = roster_swaps.Creator
rosters
employee_contracts.Creator = rosters.Employee
employee_contracts.Creator = rosters.ConfirmBy
employee_contracts.Creator = rosters.Creator
sales_data
employee_contracts.Creator = sales_data.Employee
employee_contracts.Creator = sales_data.Creator
schedules
employee_contracts.Creator = schedules.Creator
sms_logs
employee_contracts.Creator = sms_logs.Creator
states
employee_contracts.Creator = states.Creator
stress_profiles
employee_contracts.Creator = stress_profiles.Creator
system_usage_balances
employee_contracts.Creator = system_usage_balances.Creator
system_usage_tracking
employee_contracts.Creator = system_usage_tracking.Creator
task_group_setups
employee_contracts.Creator = task_group_setups.Creator
task_groups
employee_contracts.Creator = task_groups.Creator
task_opunit_configs
employee_contracts.Creator = task_opunit_configs.Creator
task_setups
employee_contracts.Creator = task_setups.Creator
tasks
employee_contracts.Creator = tasks.Creator
teams
employee_contracts.Creator = teams.LeaderEmployee
employee_contracts.Creator = teams.Creator
timesheet_pay_returns
employee_contracts.Creator = timesheet_pay_returns.Creator
employee_contracts.BasePayRule = timesheet_pay_returns.PayRule
timesheets
employee_contracts.Creator = timesheets.Employee
employee_contracts.Creator = timesheets.Creator
training_modules
employee_contracts.Creator = training_modules.Creator
training_records
employee_contracts.Creator = training_records.Employee
employee_contracts.Creator = training_records.Creator
webhooks
employee_contracts.Creator = webhooks.Creator

BasePayRule

INTEGER

Code

STRING

Created

DATE-TIME

Creator

INTEGER

Description

STRING

EmploymentBasis

INTEGER

EmploymentCategory

INTEGER

EmploymentCondition

INTEGER

EmploymentStatus

INTEGER

EndDate

DATE

File

INTEGER

Id

INTEGER

Modified

DATE-TIME

Name

STRING

PeriodType

INTEGER

StartDate

DATE

employee_history

The employee_history table contains info about employee histories.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_history with on
addresses
employee_history.MainAddress = addresses.Id
employee_history.PostalAddress = addresses.Id
employee_history.EmergencyAddress = addresses.Id
employee_history.EmployeeId = addresses.Creator
employee_history.Creator = addresses.Creator
companies
employee_history.MainAddress = companies.Address
employee_history.PostalAddress = companies.Address
employee_history.EmergencyAddress = companies.Address
employee_history.Company = companies.Id
employee_history.Company = companies.ParentCompany
employee_history.EmployeeId = companies.Creator
employee_history.Creator = companies.Creator
operational_units
employee_history.MainAddress = operational_units.Address
employee_history.PostalAddress = operational_units.Address
employee_history.EmergencyAddress = operational_units.Address
employee_history.EmployeeId = operational_units.Creator
employee_history.Creator = operational_units.Creator
company_periods
employee_history.Company = company_periods.Company
employee_history.EmployeeId = company_periods.Creator
employee_history.Creator = company_periods.Creator
employee_workplaces
employee_history.Company = employee_workplaces.Company
employee_history.EmployeeId = employee_workplaces.EmployeeId
employee_history.Creator = employee_workplaces.EmployeeId
employee_history.EmployeeId = employee_workplaces.Creator
employee_history.Creator = employee_workplaces.Creator
kiosks
employee_history.Company = kiosks.Company
employee_history.EmployeeId = kiosks.Creator
employee_history.Creator = kiosks.Creator
leaves
employee_history.Company = leaves.Company
employee_history.EmployeeId = leaves.Employee
employee_history.Creator = leaves.Employee
employee_history.EmployeeId = leaves.Creator
employee_history.Creator = leaves.Creator
employee_history.Id = leaves.EmployeeHistory
system_usage_tracking
employee_history.Company = system_usage_tracking.CompanyId
employee_history.EmployeeId = system_usage_tracking.Creator
employee_history.Creator = system_usage_tracking.Creator
categories
employee_history.EmployeeId = categories.Creator
employee_history.Creator = categories.Creator
comments
employee_history.EmployeeId = comments.Creator
employee_history.Creator = comments.Creator
contacts
employee_history.EmployeeId = contacts.Creator
employee_history.Creator = contacts.Creator
countries
employee_history.EmployeeId = countries.Creator
employee_history.Creator = countries.Creator
custom_app_data
employee_history.EmployeeId = custom_app_data.Employee
employee_history.Creator = custom_app_data.Employee
employee_history.EmployeeId = custom_app_data.Creator
employee_history.Creator = custom_app_data.Creator
custom_field_data
employee_history.EmployeeId = custom_field_data.Creator
employee_history.Creator = custom_field_data.Creator
custom_fields
employee_history.EmployeeId = custom_fields.Creator
employee_history.Creator = custom_fields.Creator
employee_agreement_history
employee_history.EmployeeId = employee_agreement_history.Creator
employee_history.Creator = employee_agreement_history.Creator
employee_agreements
employee_history.EmployeeId = employee_agreements.EmployeeId
employee_history.Creator = employee_agreements.EmployeeId
employee_history.EmployeeId = employee_agreements.Creator
employee_history.Creator = employee_agreements.Creator
employee_appraisal
employee_history.EmployeeId = employee_appraisal.Creator
employee_history.Creator = employee_appraisal.Creator
employee_history.EmployeeId = employee_appraisal.Employee
employee_history.Creator = employee_appraisal.Employee
employee_availability
employee_history.EmployeeId = employee_availability.Employee
employee_history.Creator = employee_availability.Employee
employee_history.EmployeeId = employee_availability.Creator
employee_history.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_history.EmployeeId = employee_contract_leave_rules.Creator
employee_history.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_history.EmployeeId = employee_contracts.Creator
employee_history.Creator = employee_contracts.Creator
employee_paycycle_returns
employee_history.EmployeeId = employee_paycycle_returns.Creator
employee_history.Creator = employee_paycycle_returns.Creator
employee_paycycles
employee_history.EmployeeId = employee_paycycles.EmployeeId
employee_history.Creator = employee_paycycles.EmployeeId
employee_history.EmployeeId = employee_paycycles.Creator
employee_history.Creator = employee_paycycles.Creator
employee_roles
employee_history.EmployeeId = employee_roles.Creator
employee_history.Creator = employee_roles.Creator
employee_history.Role = employee_roles.Id
employee_salary_opunit_costing
employee_history.EmployeeId = employee_salary_opunit_costing.Employee
employee_history.Creator = employee_salary_opunit_costing.Employee
employee_history.EmployeeId = employee_salary_opunit_costing.Creator
employee_history.Creator = employee_salary_opunit_costing.Creator
employment_conditions
employee_history.EmployeeId = employment_conditions.Creator
employee_history.Creator = employment_conditions.Creator
events
employee_history.EmployeeId = events.Creator
employee_history.Creator = events.Creator
geo
employee_history.EmployeeId = geo.Creator
employee_history.Creator = geo.Creator
journal
employee_history.EmployeeId = journal.EmployeeId
employee_history.Creator = journal.EmployeeId
employee_history.EmployeeId = journal.Creator
employee_history.Creator = journal.Creator
leave_accruals
employee_history.EmployeeId = leave_accruals.Employee
employee_history.Creator = leave_accruals.Employee
employee_history.EmployeeId = leave_accruals.Creator
employee_history.Creator = leave_accruals.Creator
leave_pay_lines
employee_history.EmployeeId = leave_pay_lines.Creator
employee_history.Creator = leave_pay_lines.Creator
leave_rules
employee_history.EmployeeId = leave_rules.Creator
employee_history.Creator = leave_rules.Creator
memos
employee_history.EmployeeId = memos.Creator
employee_history.Creator = memos.Creator
pay_periods
employee_history.EmployeeId = pay_periods.Creator
employee_history.Creator = pay_periods.Creator
pay_rules
employee_history.EmployeeId = pay_rules.Creator
employee_history.Creator = pay_rules.Creator
public_holidays
employee_history.EmployeeId = public_holidays.Creator
employee_history.Creator = public_holidays.Creator
roster_opens
employee_history.EmployeeId = roster_opens.Employee
employee_history.Creator = roster_opens.Employee
employee_history.EmployeeId = roster_opens.Creator
employee_history.Creator = roster_opens.Creator
roster_swaps
employee_history.EmployeeId = roster_swaps.Employee
employee_history.Creator = roster_swaps.Employee
employee_history.EmployeeId = roster_swaps.Creator
employee_history.Creator = roster_swaps.Creator
rosters
employee_history.EmployeeId = rosters.Employee
employee_history.Creator = rosters.Employee
employee_history.EmployeeId = rosters.ConfirmBy
employee_history.Creator = rosters.ConfirmBy
employee_history.EmployeeId = rosters.Creator
employee_history.Creator = rosters.Creator
sales_data
employee_history.EmployeeId = sales_data.Employee
employee_history.Creator = sales_data.Employee
employee_history.EmployeeId = sales_data.Creator
employee_history.Creator = sales_data.Creator
schedules
employee_history.EmployeeId = schedules.Creator
employee_history.Creator = schedules.Creator
sms_logs
employee_history.EmployeeId = sms_logs.Creator
employee_history.Creator = sms_logs.Creator
states
employee_history.EmployeeId = states.Creator
employee_history.Creator = states.Creator
stress_profiles
employee_history.EmployeeId = stress_profiles.Creator
employee_history.Creator = stress_profiles.Creator
system_usage_balances
employee_history.EmployeeId = system_usage_balances.Creator
employee_history.Creator = system_usage_balances.Creator
task_group_setups
employee_history.EmployeeId = task_group_setups.Creator
employee_history.Creator = task_group_setups.Creator
task_groups
employee_history.EmployeeId = task_groups.Creator
employee_history.Creator = task_groups.Creator
task_opunit_configs
employee_history.EmployeeId = task_opunit_configs.Creator
employee_history.Creator = task_opunit_configs.Creator
task_setups
employee_history.EmployeeId = task_setups.Creator
employee_history.Creator = task_setups.Creator
tasks
employee_history.EmployeeId = tasks.Creator
employee_history.Creator = tasks.Creator
teams
employee_history.EmployeeId = teams.LeaderEmployee
employee_history.Creator = teams.LeaderEmployee
employee_history.EmployeeId = teams.Creator
employee_history.Creator = teams.Creator
timesheet_pay_returns
employee_history.EmployeeId = timesheet_pay_returns.Creator
employee_history.Creator = timesheet_pay_returns.Creator
timesheets
employee_history.EmployeeId = timesheets.Employee
employee_history.Creator = timesheets.Employee
employee_history.EmployeeId = timesheets.Creator
employee_history.Creator = timesheets.Creator
employee_history.Id = timesheets.EmployeeHistory
training_modules
employee_history.EmployeeId = training_modules.Creator
employee_history.Creator = training_modules.Creator
training_records
employee_history.EmployeeId = training_records.Employee
employee_history.Creator = training_records.Employee
employee_history.EmployeeId = training_records.Creator
employee_history.Creator = training_records.Creator
webhooks
employee_history.EmployeeId = webhooks.Creator
employee_history.Creator = webhooks.Creator

Active

BOOLEAN

Company

INTEGER

Created

DATE-TIME

Creator

INTEGER

DateOfBirth

DATE

DisplayName

STRING

EmergencyAddress

STRING

EmployeeId

INTEGER

FirstName

STRING

Gender

INTEGER

Id

INTEGER

JobAppId

INTEGER

LastName

STRING

MainAddress

STRING

Modified

DATE-TIME

OtherName

STRING

Photo

INTEGER

Position

STRING

PostalAddress

STRING

Role

INTEGER

Salutation

STRING

StartDate

DATE

TerminationDate

DATE

employee_paycycle_returns

The employee_paycycle_returns table contains info about employee paycycle returns.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_paycycle_returns with on
addresses
employee_paycycle_returns.Creator = addresses.Creator
categories
employee_paycycle_returns.Creator = categories.Creator
comments
employee_paycycle_returns.Creator = comments.Creator
companies
employee_paycycle_returns.Creator = companies.Creator
company_periods
employee_paycycle_returns.Creator = company_periods.Creator
contacts
employee_paycycle_returns.Creator = contacts.Creator
countries
employee_paycycle_returns.Creator = countries.Creator
custom_app_data
employee_paycycle_returns.Creator = custom_app_data.Employee
employee_paycycle_returns.Creator = custom_app_data.Creator
custom_field_data
employee_paycycle_returns.Creator = custom_field_data.Creator
custom_fields
employee_paycycle_returns.Creator = custom_fields.Creator
employee_agreement_history
employee_paycycle_returns.Creator = employee_agreement_history.Creator
employee_paycycle_returns.PayRule = employee_agreement_history.SalaryPayRule
employee_agreements
employee_paycycle_returns.Creator = employee_agreements.EmployeeId
employee_paycycle_returns.Creator = employee_agreements.Creator
employee_paycycle_returns.PayRule = employee_agreements.SalaryPayRule
employee_appraisal
employee_paycycle_returns.Creator = employee_appraisal.Creator
employee_paycycle_returns.Creator = employee_appraisal.Employee
employee_availability
employee_paycycle_returns.Creator = employee_availability.Employee
employee_paycycle_returns.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_paycycle_returns.Creator = employee_contract_leave_rules.Creator
employee_paycycle_returns.PayRule = employee_contract_leave_rules.LoadingPayRule1
employee_paycycle_returns.PayRule = employee_contract_leave_rules.LoadingPayRule2
employee_paycycle_returns.PayRule = employee_contract_leave_rules.LoadingPayRule3
employee_contracts
employee_paycycle_returns.Creator = employee_contracts.Creator
employee_paycycle_returns.PayRule = employee_contracts.BasePayRule
employee_history
employee_paycycle_returns.Creator = employee_history.EmployeeId
employee_paycycle_returns.Creator = employee_history.Creator
employee_paycycles
employee_paycycle_returns.Creator = employee_paycycles.EmployeeId
employee_paycycle_returns.Creator = employee_paycycles.Creator
employee_paycycle_returns.PaycycleId = employee_paycycles.Id
employee_roles
employee_paycycle_returns.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_paycycle_returns.Creator = employee_salary_opunit_costing.Employee
employee_paycycle_returns.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employee_paycycle_returns.Creator = employee_workplaces.EmployeeId
employee_paycycle_returns.Creator = employee_workplaces.Creator
employment_conditions
employee_paycycle_returns.Creator = employment_conditions.Creator
events
employee_paycycle_returns.Creator = events.Creator
geo
employee_paycycle_returns.Creator = geo.Creator
journal
employee_paycycle_returns.Creator = journal.EmployeeId
employee_paycycle_returns.Creator = journal.Creator
kiosks
employee_paycycle_returns.Creator = kiosks.Creator
leave_accruals
employee_paycycle_returns.Creator = leave_accruals.Employee
employee_paycycle_returns.Creator = leave_accruals.Creator
leave_pay_lines
employee_paycycle_returns.Creator = leave_pay_lines.Creator
leave_rules
employee_paycycle_returns.Creator = leave_rules.Creator
leaves
employee_paycycle_returns.Creator = leaves.Employee
employee_paycycle_returns.Creator = leaves.Creator
memos
employee_paycycle_returns.Creator = memos.Creator
operational_units
employee_paycycle_returns.Creator = operational_units.Creator
pay_periods
employee_paycycle_returns.Creator = pay_periods.Creator
pay_rules
employee_paycycle_returns.Creator = pay_rules.Creator
employee_paycycle_returns.PayRule = pay_rules.Id
public_holidays
employee_paycycle_returns.Creator = public_holidays.Creator
roster_opens
employee_paycycle_returns.Creator = roster_opens.Employee
employee_paycycle_returns.Creator = roster_opens.Creator
roster_swaps
employee_paycycle_returns.Creator = roster_swaps.Employee
employee_paycycle_returns.Creator = roster_swaps.Creator
rosters
employee_paycycle_returns.Creator = rosters.Employee
employee_paycycle_returns.Creator = rosters.ConfirmBy
employee_paycycle_returns.Creator = rosters.Creator
sales_data
employee_paycycle_returns.Creator = sales_data.Employee
employee_paycycle_returns.Creator = sales_data.Creator
schedules
employee_paycycle_returns.Creator = schedules.Creator
sms_logs
employee_paycycle_returns.Creator = sms_logs.Creator
states
employee_paycycle_returns.Creator = states.Creator
stress_profiles
employee_paycycle_returns.Creator = stress_profiles.Creator
system_usage_balances
employee_paycycle_returns.Creator = system_usage_balances.Creator
system_usage_tracking
employee_paycycle_returns.Creator = system_usage_tracking.Creator
task_group_setups
employee_paycycle_returns.Creator = task_group_setups.Creator
task_groups
employee_paycycle_returns.Creator = task_groups.Creator
task_opunit_configs
employee_paycycle_returns.Creator = task_opunit_configs.Creator
task_setups
employee_paycycle_returns.Creator = task_setups.Creator
tasks
employee_paycycle_returns.Creator = tasks.Creator
teams
employee_paycycle_returns.Creator = teams.LeaderEmployee
employee_paycycle_returns.Creator = teams.Creator
timesheet_pay_returns
employee_paycycle_returns.Creator = timesheet_pay_returns.Creator
employee_paycycle_returns.PayRule = timesheet_pay_returns.PayRule
timesheets
employee_paycycle_returns.Creator = timesheets.Employee
employee_paycycle_returns.Creator = timesheets.Creator
employee_paycycle_returns.Id = timesheets.PaycycleId
training_modules
employee_paycycle_returns.Creator = training_modules.Creator
training_records
employee_paycycle_returns.Creator = training_records.Employee
employee_paycycle_returns.Creator = training_records.Creator
webhooks
employee_paycycle_returns.Creator = webhooks.Creator

Approved

BOOLEAN

Cost

NUMBER

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

Modified

DATE-TIME

Overridden

BOOLEAN

OverrideComment

STRING

PayRule

INTEGER

PaycycleId

INTEGER

Value

NUMBER

employee_paycycles

The employee_paycycles table contains info about employee paycycles.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_paycycles with on
company_periods
employee_paycycles.PeriodId = company_periods.Id
employee_paycycles.EmployeeId = company_periods.Creator
employee_paycycles.Creator = company_periods.Creator
addresses
employee_paycycles.EmployeeId = addresses.Creator
employee_paycycles.Creator = addresses.Creator
categories
employee_paycycles.EmployeeId = categories.Creator
employee_paycycles.Creator = categories.Creator
comments
employee_paycycles.EmployeeId = comments.Creator
employee_paycycles.Creator = comments.Creator
companies
employee_paycycles.EmployeeId = companies.Creator
employee_paycycles.Creator = companies.Creator
contacts
employee_paycycles.EmployeeId = contacts.Creator
employee_paycycles.Creator = contacts.Creator
countries
employee_paycycles.EmployeeId = countries.Creator
employee_paycycles.Creator = countries.Creator
custom_app_data
employee_paycycles.EmployeeId = custom_app_data.Employee
employee_paycycles.Creator = custom_app_data.Employee
employee_paycycles.EmployeeId = custom_app_data.Creator
employee_paycycles.Creator = custom_app_data.Creator
custom_field_data
employee_paycycles.EmployeeId = custom_field_data.Creator
employee_paycycles.Creator = custom_field_data.Creator
custom_fields
employee_paycycles.EmployeeId = custom_fields.Creator
employee_paycycles.Creator = custom_fields.Creator
employee_agreement_history
employee_paycycles.EmployeeId = employee_agreement_history.Creator
employee_paycycles.Creator = employee_agreement_history.Creator
employee_paycycles.EmployeeAgreementHistoryId = employee_agreement_history.Id
employee_paycycles.EmployeeAgreementId = employee_agreement_history.AgreementId
employee_agreements
employee_paycycles.EmployeeId = employee_agreements.EmployeeId
employee_paycycles.Creator = employee_agreements.EmployeeId
employee_paycycles.EmployeeId = employee_agreements.Creator
employee_paycycles.Creator = employee_agreements.Creator
employee_paycycles.EmployeeAgreementHistoryId = employee_agreements.HistoryId
employee_paycycles.EmployeeAgreementId = employee_agreements.Id
employee_appraisal
employee_paycycles.EmployeeId = employee_appraisal.Creator
employee_paycycles.Creator = employee_appraisal.Creator
employee_paycycles.EmployeeId = employee_appraisal.Employee
employee_paycycles.Creator = employee_appraisal.Employee
employee_availability
employee_paycycles.EmployeeId = employee_availability.Employee
employee_paycycles.Creator = employee_availability.Employee
employee_paycycles.EmployeeId = employee_availability.Creator
employee_paycycles.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_paycycles.EmployeeId = employee_contract_leave_rules.Creator
employee_paycycles.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_paycycles.EmployeeId = employee_contracts.Creator
employee_paycycles.Creator = employee_contracts.Creator
employee_history
employee_paycycles.EmployeeId = employee_history.EmployeeId
employee_paycycles.Creator = employee_history.EmployeeId
employee_paycycles.EmployeeId = employee_history.Creator
employee_paycycles.Creator = employee_history.Creator
employee_paycycle_returns
employee_paycycles.EmployeeId = employee_paycycle_returns.Creator
employee_paycycles.Creator = employee_paycycle_returns.Creator
employee_paycycles.Id = employee_paycycle_returns.PaycycleId
employee_roles
employee_paycycles.EmployeeId = employee_roles.Creator
employee_paycycles.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_paycycles.EmployeeId = employee_salary_opunit_costing.Employee
employee_paycycles.Creator = employee_salary_opunit_costing.Employee
employee_paycycles.EmployeeId = employee_salary_opunit_costing.Creator
employee_paycycles.Creator = employee_salary_opunit_costing.Creator
employee_paycycles.EmployeeAgreementId = employee_salary_opunit_costing.EmployeeAgreement
employee_workplaces
employee_paycycles.EmployeeId = employee_workplaces.EmployeeId
employee_paycycles.Creator = employee_workplaces.EmployeeId
employee_paycycles.EmployeeId = employee_workplaces.Creator
employee_paycycles.Creator = employee_workplaces.Creator
employee_paycycles.EmployeeAgreementId = employee_workplaces.Agreement1
employee_paycycles.EmployeeAgreementId = employee_workplaces.Agreement2
employee_paycycles.EmployeeAgreementId = employee_workplaces.Agreement3
employment_conditions
employee_paycycles.EmployeeId = employment_conditions.Creator
employee_paycycles.Creator = employment_conditions.Creator
events
employee_paycycles.EmployeeId = events.Creator
employee_paycycles.Creator = events.Creator
geo
employee_paycycles.EmployeeId = geo.Creator
employee_paycycles.Creator = geo.Creator
journal
employee_paycycles.EmployeeId = journal.EmployeeId
employee_paycycles.Creator = journal.EmployeeId
employee_paycycles.EmployeeId = journal.Creator
employee_paycycles.Creator = journal.Creator
kiosks
employee_paycycles.EmployeeId = kiosks.Creator
employee_paycycles.Creator = kiosks.Creator
leave_accruals
employee_paycycles.EmployeeId = leave_accruals.Employee
employee_paycycles.Creator = leave_accruals.Employee
employee_paycycles.EmployeeId = leave_accruals.Creator
employee_paycycles.Creator = leave_accruals.Creator
leave_pay_lines
employee_paycycles.EmployeeId = leave_pay_lines.Creator
employee_paycycles.Creator = leave_pay_lines.Creator
employee_paycycles.EmployeeAgreementId = leave_pay_lines.EmployeeAgreement
leave_rules
employee_paycycles.EmployeeId = leave_rules.Creator
employee_paycycles.Creator = leave_rules.Creator
leaves
employee_paycycles.EmployeeId = leaves.Employee
employee_paycycles.Creator = leaves.Employee
employee_paycycles.EmployeeId = leaves.Creator
employee_paycycles.Creator = leaves.Creator
memos
employee_paycycles.EmployeeId = memos.Creator
employee_paycycles.Creator = memos.Creator
operational_units
employee_paycycles.EmployeeId = operational_units.Creator
employee_paycycles.Creator = operational_units.Creator
pay_periods
employee_paycycles.EmployeeId = pay_periods.Creator
employee_paycycles.Creator = pay_periods.Creator
pay_rules
employee_paycycles.EmployeeId = pay_rules.Creator
employee_paycycles.Creator = pay_rules.Creator
public_holidays
employee_paycycles.EmployeeId = public_holidays.Creator
employee_paycycles.Creator = public_holidays.Creator
roster_opens
employee_paycycles.EmployeeId = roster_opens.Employee
employee_paycycles.Creator = roster_opens.Employee
employee_paycycles.EmployeeId = roster_opens.Creator
employee_paycycles.Creator = roster_opens.Creator
roster_swaps
employee_paycycles.EmployeeId = roster_swaps.Employee
employee_paycycles.Creator = roster_swaps.Employee
employee_paycycles.EmployeeId = roster_swaps.Creator
employee_paycycles.Creator = roster_swaps.Creator
rosters
employee_paycycles.EmployeeId = rosters.Employee
employee_paycycles.Creator = rosters.Employee
employee_paycycles.EmployeeId = rosters.ConfirmBy
employee_paycycles.Creator = rosters.ConfirmBy
employee_paycycles.EmployeeId = rosters.Creator
employee_paycycles.Creator = rosters.Creator
sales_data
employee_paycycles.EmployeeId = sales_data.Employee
employee_paycycles.Creator = sales_data.Employee
employee_paycycles.EmployeeId = sales_data.Creator
employee_paycycles.Creator = sales_data.Creator
schedules
employee_paycycles.EmployeeId = schedules.Creator
employee_paycycles.Creator = schedules.Creator
sms_logs
employee_paycycles.EmployeeId = sms_logs.Creator
employee_paycycles.Creator = sms_logs.Creator
states
employee_paycycles.EmployeeId = states.Creator
employee_paycycles.Creator = states.Creator
stress_profiles
employee_paycycles.EmployeeId = stress_profiles.Creator
employee_paycycles.Creator = stress_profiles.Creator
system_usage_balances
employee_paycycles.EmployeeId = system_usage_balances.Creator
employee_paycycles.Creator = system_usage_balances.Creator
system_usage_tracking
employee_paycycles.EmployeeId = system_usage_tracking.Creator
employee_paycycles.Creator = system_usage_tracking.Creator
task_group_setups
employee_paycycles.EmployeeId = task_group_setups.Creator
employee_paycycles.Creator = task_group_setups.Creator
task_groups
employee_paycycles.EmployeeId = task_groups.Creator
employee_paycycles.Creator = task_groups.Creator
task_opunit_configs
employee_paycycles.EmployeeId = task_opunit_configs.Creator
employee_paycycles.Creator = task_opunit_configs.Creator
task_setups
employee_paycycles.EmployeeId = task_setups.Creator
employee_paycycles.Creator = task_setups.Creator
tasks
employee_paycycles.EmployeeId = tasks.Creator
employee_paycycles.Creator = tasks.Creator
teams
employee_paycycles.EmployeeId = teams.LeaderEmployee
employee_paycycles.Creator = teams.LeaderEmployee
employee_paycycles.EmployeeId = teams.Creator
employee_paycycles.Creator = teams.Creator
timesheet_pay_returns
employee_paycycles.EmployeeId = timesheet_pay_returns.Creator
employee_paycycles.Creator = timesheet_pay_returns.Creator
timesheets
employee_paycycles.EmployeeId = timesheets.Employee
employee_paycycles.Creator = timesheets.Employee
employee_paycycles.EmployeeId = timesheets.Creator
employee_paycycles.Creator = timesheets.Creator
employee_paycycles.EmployeeAgreementId = timesheets.EmployeeAgreement
training_modules
employee_paycycles.EmployeeId = training_modules.Creator
employee_paycycles.Creator = training_modules.Creator
training_records
employee_paycycles.EmployeeId = training_records.Employee
employee_paycycles.Creator = training_records.Employee
employee_paycycles.EmployeeId = training_records.Creator
employee_paycycles.Creator = training_records.Creator
webhooks
employee_paycycles.EmployeeId = webhooks.Creator
employee_paycycles.Creator = webhooks.Creator

CostTotal

NUMBER

Created

DATE-TIME

Creator

INTEGER

EmployeeAgreementHistoryId

INTEGER

EmployeeAgreementId

INTEGER

EmployeeId

INTEGER

ExportId

INTEGER

Exported

BOOLEAN

Id

INTEGER

Modified

DATE-TIME

Paid

BOOLEAN

PaycycleRules

INTEGER

PaycycleRulesApproved

INTEGER

PeriodId

INTEGER

RecommendedLoadings

BOOLEAN

TimeTotal

NUMBER

Timesheets

INTEGER

TimesheetsPayApproved

STRING

TimesheetsTimeApproved

INTEGER

employee_roles

The employee_roles table contains info about employee roles.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_roles with on
addresses
employee_roles.Creator = addresses.Creator
categories
employee_roles.Creator = categories.Creator
comments
employee_roles.Creator = comments.Creator
companies
employee_roles.Creator = companies.Creator
company_periods
employee_roles.Creator = company_periods.Creator
contacts
employee_roles.Creator = contacts.Creator
countries
employee_roles.Creator = countries.Creator
custom_app_data
employee_roles.Creator = custom_app_data.Employee
employee_roles.Creator = custom_app_data.Creator
custom_field_data
employee_roles.Creator = custom_field_data.Creator
custom_fields
employee_roles.Creator = custom_fields.Creator
employee_agreement_history
employee_roles.Creator = employee_agreement_history.Creator
employee_agreements
employee_roles.Creator = employee_agreements.EmployeeId
employee_roles.Creator = employee_agreements.Creator
employee_appraisal
employee_roles.Creator = employee_appraisal.Creator
employee_roles.Creator = employee_appraisal.Employee
employee_availability
employee_roles.Creator = employee_availability.Employee
employee_roles.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_roles.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_roles.Creator = employee_contracts.Creator
employee_history
employee_roles.Creator = employee_history.EmployeeId
employee_roles.Creator = employee_history.Creator
employee_roles.Id = employee_history.Role
employee_paycycle_returns
employee_roles.Creator = employee_paycycle_returns.Creator
employee_paycycles
employee_roles.Creator = employee_paycycles.EmployeeId
employee_roles.Creator = employee_paycycles.Creator
employee_salary_opunit_costing
employee_roles.Creator = employee_salary_opunit_costing.Employee
employee_roles.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employee_roles.Creator = employee_workplaces.EmployeeId
employee_roles.Creator = employee_workplaces.Creator
employment_conditions
employee_roles.Creator = employment_conditions.Creator
events
employee_roles.Creator = events.Creator
geo
employee_roles.Creator = geo.Creator
journal
employee_roles.Creator = journal.EmployeeId
employee_roles.Creator = journal.Creator
kiosks
employee_roles.Creator = kiosks.Creator
leave_accruals
employee_roles.Creator = leave_accruals.Employee
employee_roles.Creator = leave_accruals.Creator
leave_pay_lines
employee_roles.Creator = leave_pay_lines.Creator
leave_rules
employee_roles.Creator = leave_rules.Creator
leaves
employee_roles.Creator = leaves.Employee
employee_roles.Creator = leaves.Creator
memos
employee_roles.Creator = memos.Creator
operational_units
employee_roles.Creator = operational_units.Creator
pay_periods
employee_roles.Creator = pay_periods.Creator
pay_rules
employee_roles.Creator = pay_rules.Creator
public_holidays
employee_roles.Creator = public_holidays.Creator
roster_opens
employee_roles.Creator = roster_opens.Employee
employee_roles.Creator = roster_opens.Creator
roster_swaps
employee_roles.Creator = roster_swaps.Employee
employee_roles.Creator = roster_swaps.Creator
rosters
employee_roles.Creator = rosters.Employee
employee_roles.Creator = rosters.ConfirmBy
employee_roles.Creator = rosters.Creator
sales_data
employee_roles.Creator = sales_data.Employee
employee_roles.Creator = sales_data.Creator
schedules
employee_roles.Creator = schedules.Creator
sms_logs
employee_roles.Creator = sms_logs.Creator
states
employee_roles.Creator = states.Creator
stress_profiles
employee_roles.Creator = stress_profiles.Creator
system_usage_balances
employee_roles.Creator = system_usage_balances.Creator
system_usage_tracking
employee_roles.Creator = system_usage_tracking.Creator
task_group_setups
employee_roles.Creator = task_group_setups.Creator
task_groups
employee_roles.Creator = task_groups.Creator
task_opunit_configs
employee_roles.Creator = task_opunit_configs.Creator
task_setups
employee_roles.Creator = task_setups.Creator
tasks
employee_roles.Creator = tasks.Creator
teams
employee_roles.Creator = teams.LeaderEmployee
employee_roles.Creator = teams.Creator
timesheet_pay_returns
employee_roles.Creator = timesheet_pay_returns.Creator
timesheets
employee_roles.Creator = timesheets.Employee
employee_roles.Creator = timesheets.Creator
training_modules
employee_roles.Creator = training_modules.Creator
training_records
employee_roles.Creator = training_records.Employee
employee_roles.Creator = training_records.Creator
webhooks
employee_roles.Creator = webhooks.Creator

Created

DATE-TIME

Creator

INTEGER

Id

INTEGER

Modified

DATE-TIME

Permissions

STRING

Ranking

INTEGER

ReportTo

INTEGER

Require2fa

BOOLEAN

Role

STRING

employee_salary_opunit_costing

The employee_salary_opunit_costing table contains info about employee salary operational unit costs.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_salary_opunit_costing with on
addresses
employee_salary_opunit_costing.Employee = addresses.Creator
employee_salary_opunit_costing.Creator = addresses.Creator
categories
employee_salary_opunit_costing.Employee = categories.Creator
employee_salary_opunit_costing.Creator = categories.Creator
comments
employee_salary_opunit_costing.Employee = comments.Creator
employee_salary_opunit_costing.Creator = comments.Creator
companies
employee_salary_opunit_costing.Employee = companies.Creator
employee_salary_opunit_costing.Creator = companies.Creator
company_periods
employee_salary_opunit_costing.Employee = company_periods.Creator
employee_salary_opunit_costing.Creator = company_periods.Creator
contacts
employee_salary_opunit_costing.Employee = contacts.Creator
employee_salary_opunit_costing.Creator = contacts.Creator
countries
employee_salary_opunit_costing.Employee = countries.Creator
employee_salary_opunit_costing.Creator = countries.Creator
custom_app_data
employee_salary_opunit_costing.Employee = custom_app_data.Employee
employee_salary_opunit_costing.Creator = custom_app_data.Employee
employee_salary_opunit_costing.Employee = custom_app_data.Creator
employee_salary_opunit_costing.Creator = custom_app_data.Creator
custom_field_data
employee_salary_opunit_costing.Employee = custom_field_data.Creator
employee_salary_opunit_costing.Creator = custom_field_data.Creator
custom_fields
employee_salary_opunit_costing.Employee = custom_fields.Creator
employee_salary_opunit_costing.Creator = custom_fields.Creator
employee_agreement_history
employee_salary_opunit_costing.Employee = employee_agreement_history.Creator
employee_salary_opunit_costing.Creator = employee_agreement_history.Creator
employee_salary_opunit_costing.EmployeeAgreement = employee_agreement_history.AgreementId
employee_agreements
employee_salary_opunit_costing.Employee = employee_agreements.EmployeeId
employee_salary_opunit_costing.Creator = employee_agreements.EmployeeId
employee_salary_opunit_costing.Employee = employee_agreements.Creator
employee_salary_opunit_costing.Creator = employee_agreements.Creator
employee_salary_opunit_costing.EmployeeAgreement = employee_agreements.Id
employee_appraisal
employee_salary_opunit_costing.Employee = employee_appraisal.Creator
employee_salary_opunit_costing.Creator = employee_appraisal.Creator
employee_salary_opunit_costing.Employee = employee_appraisal.Employee
employee_salary_opunit_costing.Creator = employee_appraisal.Employee
employee_availability
employee_salary_opunit_costing.Employee = employee_availability.Employee
employee_salary_opunit_costing.Creator = employee_availability.Employee
employee_salary_opunit_costing.Employee = employee_availability.Creator
employee_salary_opunit_costing.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_salary_opunit_costing.Employee = employee_contract_leave_rules.Creator
employee_salary_opunit_costing.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_salary_opunit_costing.Employee = employee_contracts.Creator
employee_salary_opunit_costing.Creator = employee_contracts.Creator
employee_history
employee_salary_opunit_costing.Employee = employee_history.EmployeeId
employee_salary_opunit_costing.Creator = employee_history.EmployeeId
employee_salary_opunit_costing.Employee = employee_history.Creator
employee_salary_opunit_costing.Creator = employee_history.Creator
employee_paycycle_returns
employee_salary_opunit_costing.Employee = employee_paycycle_returns.Creator
employee_salary_opunit_costing.Creator = employee_paycycle_returns.Creator
employee_paycycles
employee_salary_opunit_costing.Employee = employee_paycycles.EmployeeId
employee_salary_opunit_costing.Creator = employee_paycycles.EmployeeId
employee_salary_opunit_costing.Employee = employee_paycycles.Creator
employee_salary_opunit_costing.Creator = employee_paycycles.Creator
employee_salary_opunit_costing.EmployeeAgreement = employee_paycycles.EmployeeAgreementId
employee_roles
employee_salary_opunit_costing.Employee = employee_roles.Creator
employee_salary_opunit_costing.Creator = employee_roles.Creator
employee_workplaces
employee_salary_opunit_costing.Employee = employee_workplaces.EmployeeId
employee_salary_opunit_costing.Creator = employee_workplaces.EmployeeId
employee_salary_opunit_costing.Employee = employee_workplaces.Creator
employee_salary_opunit_costing.Creator = employee_workplaces.Creator
employee_salary_opunit_costing.EmployeeAgreement = employee_workplaces.Agreement1
employee_salary_opunit_costing.EmployeeAgreement = employee_workplaces.Agreement2
employee_salary_opunit_costing.EmployeeAgreement = employee_workplaces.Agreement3
employment_conditions
employee_salary_opunit_costing.Employee = employment_conditions.Creator
employee_salary_opunit_costing.Creator = employment_conditions.Creator
events
employee_salary_opunit_costing.Employee = events.Creator
employee_salary_opunit_costing.Creator = events.Creator
geo
employee_salary_opunit_costing.Employee = geo.Creator
employee_salary_opunit_costing.Creator = geo.Creator
journal
employee_salary_opunit_costing.Employee = journal.EmployeeId
employee_salary_opunit_costing.Creator = journal.EmployeeId
employee_salary_opunit_costing.Employee = journal.Creator
employee_salary_opunit_costing.Creator = journal.Creator
kiosks
employee_salary_opunit_costing.Employee = kiosks.Creator
employee_salary_opunit_costing.Creator = kiosks.Creator
leave_accruals
employee_salary_opunit_costing.Employee = leave_accruals.Employee
employee_salary_opunit_costing.Creator = leave_accruals.Employee
employee_salary_opunit_costing.Employee = leave_accruals.Creator
employee_salary_opunit_costing.Creator = leave_accruals.Creator
leave_pay_lines
employee_salary_opunit_costing.Employee = leave_pay_lines.Creator
employee_salary_opunit_costing.Creator = leave_pay_lines.Creator
employee_salary_opunit_costing.EmployeeAgreement = leave_pay_lines.EmployeeAgreement
leave_rules
employee_salary_opunit_costing.Employee = leave_rules.Creator
employee_salary_opunit_costing.Creator = leave_rules.Creator
leaves
employee_salary_opunit_costing.Employee = leaves.Employee
employee_salary_opunit_costing.Creator = leaves.Employee
employee_salary_opunit_costing.Employee = leaves.Creator
employee_salary_opunit_costing.Creator = leaves.Creator
memos
employee_salary_opunit_costing.Employee = memos.Creator
employee_salary_opunit_costing.Creator = memos.Creator
operational_units
employee_salary_opunit_costing.Employee = operational_units.Creator
employee_salary_opunit_costing.Creator = operational_units.Creator
employee_salary_opunit_costing.OpUnit = operational_units.Id
employee_salary_opunit_costing.OpUnit = operational_units.ParentOperationalUnit
pay_periods
employee_salary_opunit_costing.Employee = pay_periods.Creator
employee_salary_opunit_costing.Creator = pay_periods.Creator
pay_rules
employee_salary_opunit_costing.Employee = pay_rules.Creator
employee_salary_opunit_costing.Creator = pay_rules.Creator
public_holidays
employee_salary_opunit_costing.Employee = public_holidays.Creator
employee_salary_opunit_costing.Creator = public_holidays.Creator
roster_opens
employee_salary_opunit_costing.Employee = roster_opens.Employee
employee_salary_opunit_costing.Creator = roster_opens.Employee
employee_salary_opunit_costing.Employee = roster_opens.Creator
employee_salary_opunit_costing.Creator = roster_opens.Creator
roster_swaps
employee_salary_opunit_costing.Employee = roster_swaps.Employee
employee_salary_opunit_costing.Creator = roster_swaps.Employee
employee_salary_opunit_costing.Employee = roster_swaps.Creator
employee_salary_opunit_costing.Creator = roster_swaps.Creator
rosters
employee_salary_opunit_costing.Employee = rosters.Employee
employee_salary_opunit_costing.Creator = rosters.Employee
employee_salary_opunit_costing.Employee = rosters.ConfirmBy
employee_salary_opunit_costing.Creator = rosters.ConfirmBy
employee_salary_opunit_costing.Employee = rosters.Creator
employee_salary_opunit_costing.Creator = rosters.Creator
employee_salary_opunit_costing.OpUnit = rosters.OperationalUnit
sales_data
employee_salary_opunit_costing.Employee = sales_data.Employee
employee_salary_opunit_costing.Creator = sales_data.Employee
employee_salary_opunit_costing.Employee = sales_data.Creator
employee_salary_opunit_costing.Creator = sales_data.Creator
employee_salary_opunit_costing.OpUnit = sales_data.OperationalUnit
schedules
employee_salary_opunit_costing.Employee = schedules.Creator
employee_salary_opunit_costing.Creator = schedules.Creator
sms_logs
employee_salary_opunit_costing.Employee = sms_logs.Creator
employee_salary_opunit_costing.Creator = sms_logs.Creator
states
employee_salary_opunit_costing.Employee = states.Creator
employee_salary_opunit_costing.Creator = states.Creator
stress_profiles
employee_salary_opunit_costing.Employee = stress_profiles.Creator
employee_salary_opunit_costing.Creator = stress_profiles.Creator
system_usage_balances
employee_salary_opunit_costing.Employee = system_usage_balances.Creator
employee_salary_opunit_costing.Creator = system_usage_balances.Creator
system_usage_tracking
employee_salary_opunit_costing.Employee = system_usage_tracking.Creator
employee_salary_opunit_costing.Creator = system_usage_tracking.Creator
task_group_setups
employee_salary_opunit_costing.Employee = task_group_setups.Creator
employee_salary_opunit_costing.Creator = task_group_setups.Creator
task_groups
employee_salary_opunit_costing.Employee = task_groups.Creator
employee_salary_opunit_costing.Creator = task_groups.Creator
employee_salary_opunit_costing.OpUnit = task_groups.OpUnitId
task_opunit_configs
employee_salary_opunit_costing.Employee = task_opunit_configs.Creator
employee_salary_opunit_costing.Creator = task_opunit_configs.Creator
employee_salary_opunit_costing.OpUnit = task_opunit_configs.OpUnitId
task_setups
employee_salary_opunit_costing.Employee = task_setups.Creator
employee_salary_opunit_costing.Creator = task_setups.Creator
tasks
employee_salary_opunit_costing.Employee = tasks.Creator
employee_salary_opunit_costing.Creator = tasks.Creator
employee_salary_opunit_costing.OpUnit = tasks.OpUnitId
teams
employee_salary_opunit_costing.Employee = teams.LeaderEmployee
employee_salary_opunit_costing.Creator = teams.LeaderEmployee
employee_salary_opunit_costing.Employee = teams.Creator
employee_salary_opunit_costing.Creator = teams.Creator
timesheet_pay_returns
employee_salary_opunit_costing.Employee = timesheet_pay_returns.Creator
employee_salary_opunit_costing.Creator = timesheet_pay_returns.Creator
timesheets
employee_salary_opunit_costing.Employee = timesheets.Employee
employee_salary_opunit_costing.Creator = timesheets.Employee
employee_salary_opunit_costing.Employee = timesheets.Creator
employee_salary_opunit_costing.Creator = timesheets.Creator
employee_salary_opunit_costing.EmployeeAgreement = timesheets.EmployeeAgreement
employee_salary_opunit_costing.OpUnit = timesheets.OperationalUnit
training_modules
employee_salary_opunit_costing.Employee = training_modules.Creator
employee_salary_opunit_costing.Creator = training_modules.Creator
training_records
employee_salary_opunit_costing.Employee = training_records.Employee
employee_salary_opunit_costing.Creator = training_records.Employee
employee_salary_opunit_costing.Employee = training_records.Creator
employee_salary_opunit_costing.Creator = training_records.Creator
webhooks
employee_salary_opunit_costing.Employee = webhooks.Creator
employee_salary_opunit_costing.Creator = webhooks.Creator

AgreementHistory

INTEGER

Cost

NUMBER

Created

DATE-TIME

Creator

INTEGER

Date

DATE

DayTimestamp

STRING

Employee

INTEGER

EmployeeAgreement

INTEGER

Final

BOOLEAN

Id

INTEGER

Modified

DATE-TIME

OpUnit

INTEGER

employee_workplaces

The employee_workplaces table contains info about employee workplaces.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employee_workplaces with on
companies
employee_workplaces.Company = companies.Id
employee_workplaces.Company = companies.ParentCompany
employee_workplaces.EmployeeId = companies.Creator
employee_workplaces.Creator = companies.Creator
company_periods
employee_workplaces.Company = company_periods.Company
employee_workplaces.EmployeeId = company_periods.Creator
employee_workplaces.Creator = company_periods.Creator
employee_history
employee_workplaces.Company = employee_history.Company
employee_workplaces.EmployeeId = employee_history.EmployeeId
employee_workplaces.Creator = employee_history.EmployeeId
employee_workplaces.EmployeeId = employee_history.Creator
employee_workplaces.Creator = employee_history.Creator
kiosks
employee_workplaces.Company = kiosks.Company
employee_workplaces.EmployeeId = kiosks.Creator
employee_workplaces.Creator = kiosks.Creator
leaves
employee_workplaces.Company = leaves.Company
employee_workplaces.EmployeeId = leaves.Employee
employee_workplaces.Creator = leaves.Employee
employee_workplaces.EmployeeId = leaves.Creator
employee_workplaces.Creator = leaves.Creator
system_usage_tracking
employee_workplaces.Company = system_usage_tracking.CompanyId
employee_workplaces.EmployeeId = system_usage_tracking.Creator
employee_workplaces.Creator = system_usage_tracking.Creator
addresses
employee_workplaces.EmployeeId = addresses.Creator
employee_workplaces.Creator = addresses.Creator
categories
employee_workplaces.EmployeeId = categories.Creator
employee_workplaces.Creator = categories.Creator
comments
employee_workplaces.EmployeeId = comments.Creator
employee_workplaces.Creator = comments.Creator
contacts
employee_workplaces.EmployeeId = contacts.Creator
employee_workplaces.Creator = contacts.Creator
countries
employee_workplaces.EmployeeId = countries.Creator
employee_workplaces.Creator = countries.Creator
custom_app_data
employee_workplaces.EmployeeId = custom_app_data.Employee
employee_workplaces.Creator = custom_app_data.Employee
employee_workplaces.EmployeeId = custom_app_data.Creator
employee_workplaces.Creator = custom_app_data.Creator
custom_field_data
employee_workplaces.EmployeeId = custom_field_data.Creator
employee_workplaces.Creator = custom_field_data.Creator
custom_fields
employee_workplaces.EmployeeId = custom_fields.Creator
employee_workplaces.Creator = custom_fields.Creator
employee_agreement_history
employee_workplaces.EmployeeId = employee_agreement_history.Creator
employee_workplaces.Creator = employee_agreement_history.Creator
employee_workplaces.Agreement1 = employee_agreement_history.AgreementId
employee_workplaces.Agreement2 = employee_agreement_history.AgreementId
employee_workplaces.Agreement3 = employee_agreement_history.AgreementId
employee_agreements
employee_workplaces.EmployeeId = employee_agreements.EmployeeId
employee_workplaces.Creator = employee_agreements.EmployeeId
employee_workplaces.EmployeeId = employee_agreements.Creator
employee_workplaces.Creator = employee_agreements.Creator
employee_workplaces.Agreement1 = employee_agreements.Id
employee_workplaces.Agreement2 = employee_agreements.Id
employee_workplaces.Agreement3 = employee_agreements.Id
employee_appraisal
employee_workplaces.EmployeeId = employee_appraisal.Creator
employee_workplaces.Creator = employee_appraisal.Creator
employee_workplaces.EmployeeId = employee_appraisal.Employee
employee_workplaces.Creator = employee_appraisal.Employee
employee_availability
employee_workplaces.EmployeeId = employee_availability.Employee
employee_workplaces.Creator = employee_availability.Employee
employee_workplaces.EmployeeId = employee_availability.Creator
employee_workplaces.Creator = employee_availability.Creator
employee_contract_leave_rules
employee_workplaces.EmployeeId = employee_contract_leave_rules.Creator
employee_workplaces.Creator = employee_contract_leave_rules.Creator
employee_contracts
employee_workplaces.EmployeeId = employee_contracts.Creator
employee_workplaces.Creator = employee_contracts.Creator
employee_paycycle_returns
employee_workplaces.EmployeeId = employee_paycycle_returns.Creator
employee_workplaces.Creator = employee_paycycle_returns.Creator
employee_paycycles
employee_workplaces.EmployeeId = employee_paycycles.EmployeeId
employee_workplaces.Creator = employee_paycycles.EmployeeId
employee_workplaces.EmployeeId = employee_paycycles.Creator
employee_workplaces.Creator = employee_paycycles.Creator
employee_workplaces.Agreement1 = employee_paycycles.EmployeeAgreementId
employee_workplaces.Agreement2 = employee_paycycles.EmployeeAgreementId
employee_workplaces.Agreement3 = employee_paycycles.EmployeeAgreementId
employee_roles
employee_workplaces.EmployeeId = employee_roles.Creator
employee_workplaces.Creator = employee_roles.Creator
employee_salary_opunit_costing
employee_workplaces.EmployeeId = employee_salary_opunit_costing.Employee
employee_workplaces.Creator = employee_salary_opunit_costing.Employee
employee_workplaces.EmployeeId = employee_salary_opunit_costing.Creator
employee_workplaces.Creator = employee_salary_opunit_costing.Creator
employee_workplaces.Agreement1 = employee_salary_opunit_costing.EmployeeAgreement
employee_workplaces.Agreement2 = employee_salary_opunit_costing.EmployeeAgreement
employee_workplaces.Agreement3 = employee_salary_opunit_costing.EmployeeAgreement
employment_conditions
employee_workplaces.EmployeeId = employment_conditions.Creator
employee_workplaces.Creator = employment_conditions.Creator
events
employee_workplaces.EmployeeId = events.Creator
employee_workplaces.Creator = events.Creator
geo
employee_workplaces.EmployeeId = geo.Creator
employee_workplaces.Creator = geo.Creator
journal
employee_workplaces.EmployeeId = journal.EmployeeId
employee_workplaces.Creator = journal.EmployeeId
employee_workplaces.EmployeeId = journal.Creator
employee_workplaces.Creator = journal.Creator
leave_accruals
employee_workplaces.EmployeeId = leave_accruals.Employee
employee_workplaces.Creator = leave_accruals.Employee
employee_workplaces.EmployeeId = leave_accruals.Creator
employee_workplaces.Creator = leave_accruals.Creator
leave_pay_lines
employee_workplaces.EmployeeId = leave_pay_lines.Creator
employee_workplaces.Creator = leave_pay_lines.Creator
employee_workplaces.Agreement1 = leave_pay_lines.EmployeeAgreement
employee_workplaces.Agreement2 = leave_pay_lines.EmployeeAgreement
employee_workplaces.Agreement3 = leave_pay_lines.EmployeeAgreement
leave_rules
employee_workplaces.EmployeeId = leave_rules.Creator
employee_workplaces.Creator = leave_rules.Creator
memos
employee_workplaces.EmployeeId = memos.Creator
employee_workplaces.Creator = memos.Creator
operational_units
employee_workplaces.EmployeeId = operational_units.Creator
employee_workplaces.Creator = operational_units.Creator
pay_periods
employee_workplaces.EmployeeId = pay_periods.Creator
employee_workplaces.Creator = pay_periods.Creator
pay_rules
employee_workplaces.EmployeeId = pay_rules.Creator
employee_workplaces.Creator = pay_rules.Creator
public_holidays
employee_workplaces.EmployeeId = public_holidays.Creator
employee_workplaces.Creator = public_holidays.Creator
roster_opens
employee_workplaces.EmployeeId = roster_opens.Employee
employee_workplaces.Creator = roster_opens.Employee
employee_workplaces.EmployeeId = roster_opens.Creator
employee_workplaces.Creator = roster_opens.Creator
roster_swaps
employee_workplaces.EmployeeId = roster_swaps.Employee
employee_workplaces.Creator = roster_swaps.Employee
employee_workplaces.EmployeeId = roster_swaps.Creator
employee_workplaces.Creator = roster_swaps.Creator
rosters
employee_workplaces.EmployeeId = rosters.Employee
employee_workplaces.Creator = rosters.Employee
employee_workplaces.EmployeeId = rosters.ConfirmBy
employee_workplaces.Creator = rosters.ConfirmBy
employee_workplaces.EmployeeId = rosters.Creator
employee_workplaces.Creator = rosters.Creator
sales_data
employee_workplaces.EmployeeId = sales_data.Employee
employee_workplaces.Creator = sales_data.Employee
employee_workplaces.EmployeeId = sales_data.Creator
employee_workplaces.Creator = sales_data.Creator
schedules
employee_workplaces.EmployeeId = schedules.Creator
employee_workplaces.Creator = schedules.Creator
sms_logs
employee_workplaces.EmployeeId = sms_logs.Creator
employee_workplaces.Creator = sms_logs.Creator
states
employee_workplaces.EmployeeId = states.Creator
employee_workplaces.Creator = states.Creator
stress_profiles
employee_workplaces.EmployeeId = stress_profiles.Creator
employee_workplaces.Creator = stress_profiles.Creator
system_usage_balances
employee_workplaces.EmployeeId = system_usage_balances.Creator
employee_workplaces.Creator = system_usage_balances.Creator
task_group_setups
employee_workplaces.EmployeeId = task_group_setups.Creator
employee_workplaces.Creator = task_group_setups.Creator
task_groups
employee_workplaces.EmployeeId = task_groups.Creator
employee_workplaces.Creator = task_groups.Creator
task_opunit_configs
employee_workplaces.EmployeeId = task_opunit_configs.Creator
employee_workplaces.Creator = task_opunit_configs.Creator
task_setups
employee_workplaces.EmployeeId = task_setups.Creator
employee_workplaces.Creator = task_setups.Creator
tasks
employee_workplaces.EmployeeId = tasks.Creator
employee_workplaces.Creator = tasks.Creator
teams
employee_workplaces.EmployeeId = teams.LeaderEmployee
employee_workplaces.Creator = teams.LeaderEmployee
employee_workplaces.EmployeeId = teams.Creator
employee_workplaces.Creator = teams.Creator
timesheet_pay_returns
employee_workplaces.EmployeeId = timesheet_pay_returns.Creator
employee_workplaces.Creator = timesheet_pay_returns.Creator
timesheets
employee_workplaces.EmployeeId = timesheets.Employee
employee_workplaces.Creator = timesheets.Employee
employee_workplaces.EmployeeId = timesheets.Creator
employee_workplaces.Creator = timesheets.Creator
employee_workplaces.Agreement1 = timesheets.EmployeeAgreement
employee_workplaces.Agreement2 = timesheets.EmployeeAgreement
employee_workplaces.Agreement3 = timesheets.EmployeeAgreement
training_modules
employee_workplaces.EmployeeId = training_modules.Creator
employee_workplaces.Creator = training_modules.Creator
training_records
employee_workplaces.EmployeeId = training_records.Employee
employee_workplaces.Creator = training_records.Employee
employee_workplaces.EmployeeId = training_records.Creator
employee_workplaces.Creator = training_records.Creator
webhooks
employee_workplaces.EmployeeId = webhooks.Creator
employee_workplaces.Creator = webhooks.Creator

Agreement1

INTEGER

Agreement2

INTEGER

Agreement3

INTEGER

Company

INTEGER

Created

DATE-TIME

Creator

INTEGER

EmployeeId

INTEGER

Id

INTEGER

Modified

DATE-TIME

SortOrder

INTEGER

employment_conditions

The employment_conditions table contains info about employment conditions.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join employment_conditions with on
categories
employment_conditions.EmploymentCategory = categories.Id
employment_conditions.Creator = categories.Creator
employee_contracts
employment_conditions.EmploymentCategory = employee_contracts.EmploymentCategory
employment_conditions.Creator = employee_contracts.Creator
employment_conditions.Id = employee_contracts.EmploymentCondition
addresses
employment_conditions.Creator = addresses.Creator
comments
employment_conditions.Creator = comments.Creator
companies
employment_conditions.Creator = companies.Creator
company_periods
employment_conditions.Creator = company_periods.Creator
contacts
employment_conditions.Creator = contacts.Creator
countries
employment_conditions.Creator = countries.Creator
custom_app_data
employment_conditions.Creator = custom_app_data.Employee
employment_conditions.Creator = custom_app_data.Creator
custom_field_data
employment_conditions.Creator = custom_field_data.Creator
custom_fields
employment_conditions.Creator = custom_fields.Creator
employee_agreement_history
employment_conditions.Creator = employee_agreement_history.Creator
employee_agreements
employment_conditions.Creator = employee_agreements.EmployeeId
employment_conditions.Creator = employee_agreements.Creator
employee_appraisal
employment_conditions.Creator = employee_appraisal.Creator
employment_conditions.Creator = employee_appraisal.Employee
employee_availability
employment_conditions.Creator = employee_availability.Employee
employment_conditions.Creator = employee_availability.Creator
employee_contract_leave_rules
employment_conditions.Creator = employee_contract_leave_rules.Creator
employee_history
employment_conditions.Creator = employee_history.EmployeeId
employment_conditions.Creator = employee_history.Creator
employee_paycycle_returns
employment_conditions.Creator = employee_paycycle_returns.Creator
employee_paycycles
employment_conditions.Creator = employee_paycycles.EmployeeId
employment_conditions.Creator = employee_paycycles.Creator
employee_roles
employment_conditions.Creator = employee_roles.Creator
employee_salary_opunit_costing
employment_conditions.Creator = employee_salary_opunit_costing.Employee
employment_conditions.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
employment_conditions.Creator = employee_workplaces.EmployeeId
employment_conditions.Creator = employee_workplaces.Creator
events
employment_conditions.Creator = events.Creator
geo
employment_conditions.Creator = geo.Creator
journal
employment_conditions.Creator = journal.EmployeeId
employment_conditions.Creator = journal.Creator
kiosks
employment_conditions.Creator = kiosks.Creator
leave_accruals
employment_conditions.Creator = leave_accruals.Employee
employment_conditions.Creator = leave_accruals.Creator
leave_pay_lines
employment_conditions.Creator = leave_pay_lines.Creator
leave_rules
employment_conditions.Creator = leave_rules.Creator
leaves
employment_conditions.Creator = leaves.Employee
employment_conditions.Creator = leaves.Creator
memos
employment_conditions.Creator = memos.Creator
operational_units
employment_conditions.Creator = operational_units.Creator
pay_periods
employment_conditions.Creator = pay_periods.Creator
pay_rules
employment_conditions.Creator = pay_rules.Creator
public_holidays
employment_conditions.Creator = public_holidays.Creator
roster_opens
employment_conditions.Creator = roster_opens.Employee
employment_conditions.Creator = roster_opens.Creator
roster_swaps
employment_conditions.Creator = roster_swaps.Employee
employment_conditions.Creator = roster_swaps.Creator
rosters
employment_conditions.Creator = rosters.Employee
employment_conditions.Creator = rosters.ConfirmBy
employment_conditions.Creator = rosters.Creator
sales_data
employment_conditions.Creator = sales_data.Employee
employment_conditions.Creator = sales_data.Creator
schedules
employment_conditions.Creator = schedules.Creator
sms_logs
employment_conditions.Creator = sms_logs.Creator
states
employment_conditions.Creator = states.Creator
stress_profiles
employment_conditions.Creator = stress_profiles.Creator
system_usage_balances
employment_conditions.Creator = system_usage_balances.Creator
system_usage_tracking
employment_conditions.Creator = system_usage_tracking.Creator
task_group_setups
employment_conditions.Creator = task_group_setups.Creator
task_groups
employment_conditions.Creator = task_groups.Creator
task_opunit_configs
employment_conditions.Creator = task_opunit_configs.Creator
task_setups
employment_conditions.Creator = task_setups.Creator
tasks
employment_conditions.Creator = tasks.Creator
teams
employment_conditions.Creator = teams.LeaderEmployee
employment_conditions.Creator = teams.Creator
timesheet_pay_returns
employment_conditions.Creator = timesheet_pay_returns.Creator
timesheets
employment_conditions.Creator = timesheets.Employee
employment_conditions.Creator = timesheets.Creator
training_modules
employment_conditions.Creator = training_modules.Creator
training_records
employment_conditions.Creator = training_records.Employee
employment_conditions.Creator = training_records.Creator
webhooks
employment_conditions.Creator = webhooks.Creator

AvgHoursPerDay

NUMBER

AwardLevel

STRING

Created

DATE-TIME

Creator

INTEGER

Description

STRING

EmploymentBasis

INTEGER

EmploymentCategory

INTEGER

EmploymentPeriod

INTEGER

EmploymentStatus

INTEGER

Id

INTEGER

MinHoursForLeave

NUMBER

MinHoursPerDay

NUMBER

Modified

DATE-TIME

Name

STRING

ProbationaryPeriod

INTEGER

UsualFinishTime

STRING

UsualMealbreak

STRING

UsualStartTime

STRING

WorkingDaysPerPeriod

NUMBER

events

The events table contains info about events.

Replication Method

Key-based Incremental

Primary Key

Modified

Replication Key

Modified

Useful links

Deputy documentation

Join events with on
addresses
events.Creator = addresses.Creator
categories
events.Creator = categories.Creator
comments
events.Creator = comments.Creator
companies
events.Creator = companies.Creator
company_periods
events.Creator = company_periods.Creator
contacts
events.Creator = contacts.Creator
countries
events.Creator = countries.Creator
custom_app_data
events.Creator = custom_app_data.Employee
events.Creator = custom_app_data.Creator
custom_field_data
events.Creator = custom_field_data.Creator
custom_fields
events.Creator = custom_fields.Creator
employee_agreement_history
events.Creator = employee_agreement_history.Creator
employee_agreements
events.Creator = employee_agreements.EmployeeId
events.Creator = employee_agreements.Creator
employee_appraisal
events.Creator = employee_appraisal.Creator
events.Creator = employee_appraisal.Employee
employee_availability
events.Creator = employee_availability.Employee
events.Creator = employee_availability.Creator
events.Schedule = employee_availability.Schedule
employee_contract_leave_rules
events.Creator = employee_contract_leave_rules.Creator
employee_contracts
events.Creator = employee_contracts.Creator
employee_history
events.Creator = employee_history.EmployeeId
events.Creator = employee_history.Creator
employee_paycycle_returns
events.Creator = employee_paycycle_returns.Creator
employee_paycycles
events.Creator = employee_paycycles.EmployeeId
events.Creator = employee_paycycles.Creator
employee_roles
events.Creator = employee_roles.Creator
employee_salary_opunit_costing
events.Creator = employee_salary_opunit_costing.Employee
events.Creator = employee_salary_opunit_costing.Creator
employee_workplaces
events.Creator = employee_workplaces.EmployeeId
events.Creator = employee_workplaces.Creator
employment_conditions
events.Creator = employment_conditions.Creator
geo
events.Creator = geo.Creator
journal
events.Creator = journal.EmployeeId
events.Creator = journal.Creator
kiosks
events.Creator = kiosks.Creator
leave_accruals
events.Creator = leave_accruals.Employee
events.Creator = leave_accruals.Creator
leave_pay_lines
events.Creator = leave_pay_lines.Creator
leave_rules
events.Creator = leave_rules.Creator
leaves
events.Creator = leaves.Employee
events.Creator = leaves.Creator
memos
events.Creator = memos.Creator