This integration is powered by Singer's Deputy tap. For support, visit the GitHub repo or join the Singer Slack.
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 | |
| Stitch plan |
Standard |
API availability |
Available |
| Singer GitHub repository | |||
| 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
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Deputy icon.
-
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_deputyin 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.
- When finished, click Authorize. You’ll be prompted to sign into your Deputy account if you aren’t already.
- 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.
- After the authorization process is successfully completed, you’ll be directed back to Stitch.
- 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:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
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:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- 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.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
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
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the Deputy integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
addresses
The addresses table contains info about addresses.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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.
|
Key-based Incremental |
|
|
Primary Key |
Modified |
|
Replication Key |
Modified |
| Useful links |
| 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 |