Explore the Deputy data model

See how the various Deputy endpoints relate to each other, using our handy Entity Relationship Diagram.

Pulling data from Deputy is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only pull your Deputy endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Location

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Company

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Portfolio int - -
Code string - -
Active boolean - -
ParentCompany int Location → ID -
ParentLocation int - -
CompanyName string - -
TradingName string - -
BusinessNumber string - -
CompanyNumber string - -
IsWorkplace boolean - -
IsPayrollEntity boolean - -
PayrollExportCode string - -
Address int Address → ID -
Contact string -
  • 12 May 2020 `Contact here does not refer to contact id in contact endpoint.
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Timesheet

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Timesheet

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Employee int Employee → ID -
EmployeeHistory int - -
EmployeeAgreement int -
  • 11 May 2020 Foreign Key: Refers to `EmployeeAgreement` (not implemented).
Date datetime - -
StartTime int - -
EndTime int - -
Mealbreak datetime - -
TotalTime decimal - -
TotalTimeInv decimal - -
Cost decimal - -
Roster int Shift → ID -
EmployeeComment string - -
SupervisorComment string - -
Supervisor int - -
Disputed boolean - -
TimeApproved boolean - -
TimeApprover int - -
Discarded boolean - -
ValidationFlag int - -
OperationalUnit int OperationalUnit → ID -
IsInProgress boolean - -
IsLeave boolean - -
LeaveID int Leave → ID -
LeaveRule int -
  • 12 May 2020 Foreign Key: Refers to `LeaveRules` (not implemented).
Invoiced boolean - -
InvoiceComment string - -
PayRuleApproved boolean - -
Exported boolean - -
StagingID int - -
PayStaged boolean - -
PaycycleID int -
  • 12 May 2020 Foreign Key: Refers to `EmployeePaycycle` (not implemented).
File int - -
CustomFieldData int CustomField → ID -
RealTime boolean - -
AutoProcessed boolean - -
AutoRounded boolean - -
AutoTimeApproved boolean - -
AutoPayRuleApproved boolean - -
OnCost decimal - -
StartTimeLocalized datetime - -
EndTimeLocalized datetime - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Employee

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Employee

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Company int Location → ID -
FirstName string - -
LastName string - -
DisplayName string - -
OtherName string - -
Salutation string - -
MainAddress int Address → ID -
PostalAddress int Address → ID -
Contact int Contact → ID -
EmergencyAddress int Address → ID -
DateOfBirth datetime - -
Gender int - -
Photo int - -
UserID int - -
JobAppID int - -
Active boolean - -
StartDate datetime - -
TerminationDate datetime - -
StressProfile int -
  • 12 May 2020 Foreign Key: Refers to `StressProfile` (not implemented).
Position string - -
HigherDuty boolean - -
Role int -
  • 12 May 2020 Foreign Key: Refers to `EmployeeRole` (not implemented).
AllowAppraisal boolean - -
HistoryID int -
  • 12 May 2020 Foreign Key: Refers to `EmployeeHistory` (not implemented).
CustomFieldData int CustomField → ID -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Address

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Address

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ContactName string - -
UnitNo string - -
StreetNo string - -
SuiteNo string - -
PoBox string - -
Street1 string - -
Street2 string - -
City string - -
State string - -
Postcode string - -
Country int - -
Phone string - -
Notes string - -
Format int - -
Saved boolean - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Shift

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Roster

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Date datetime - -
StartTime long - -
EndTime long - -
WhenStart datetime - -
WhenEnd datetime - -
Mealbreak datetime - -
TotalTime decimal - -
Cost decimal - -
OperationalUnit int OperationalUnit → ID -
Employee int Employee → ID -
Comment string - -
Warning string - -
WarningOverrideComment string - -
Published boolean - -
MatchedByTimesheet int Timesheet → ID -
Open boolean - -
ConfirmStatus int - -
ConfirmComment string - -
ConfirmBy int Employee → ID -
ConfirmTime int - -
SwapStatus int - -
SwapManageBy int - -
ShiftTemplate int - -
ConnectStatus int - -
OnCost decimal - -
StartTimeLocalized datetime - -
EndTimeLocalized datetime - -
ExternalID int - -
ConnectCreator int - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

ShiftSlot

Column Type Relates to Notes
RemoteID string - -
ShiftRemoteID string Shift → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BlnEmptySlot boolean - -
BlnCanStartEarly boolean - -
BlnCanEndEarly boolean - -
BlnIsMandatory boolean - -
StrType string - -
IntStart int -
  • 11 May 2020 The intStart is the number of seconds since the parent Roster start date
IntEnd int -
  • 11 May 2020 The intEnd is the number of seconds since the parent Roster end date
IntUnixStart long -
  • 22 Mar 2021 Unix Epoch Time
IntUnixEnd long -
  • 22 Mar 2021 Unix Epoch Time
WhenStart datetime - -
WhenEnd datetime - -
StrTypeName string - -
StrState string - -
Shift int Shift → ID -

Contact

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Contact

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Phone1 string - -
Phone2 string - -
Phone3 string - -
Fax string - -
Phone1Type string - -
Phone2Type string - -
Phone3Type string - -
PrimaryPhone int - -
Email1 string - -
Email1Type string - -
Email2Type string - -
Email2 string - -
PrimaryEmail int - -
Im1 string - -
Im2 string - -
Im1Type string - -
Im2Type string - -
Web string - -
Saved boolean - -
Mobile string - -
Email string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

CustomField

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/CustomField

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
System string - -
ApiName string - -
DeputyField string - -
SortOrder int - -
Default string - -
Type int - -
Published int - -
TriggerScript int - -
Helptext string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

CustomFieldResponse

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/CustomFieldData

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
System string - -
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 - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

CategoryDetails

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Category

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Category string - -
Group string - -
SortOrder int - -
Stafflog boolean - -
System boolean - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

EmployeeAvailability

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/EmployeeAvailability

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Employee int Employee → ID -
Type int -
  • 11 May 2020 Type=0 is a one-off and type=1 is recurring
MaxDateRecurringGenerated datetime - -
StartTime int - -
EndTime int - -
Date datetime - -
Comment string - -
Schedule int Schedule → ID -
StartTimeLocalized datetime - -
EndTimeLocalized datetime - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Event

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Event

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Title string - -
Schedule int Schedule → ID -
Colour string - -
ShowOnRoster boolean - -
BlockTimeOff boolean - -
AddToBudget decimal - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Team

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Team

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
LeaderEmployee int Employee → ID -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

TimesheetSlot

Column Type Relates to Notes
RemoteID string - -
TimesheetRemoteID string Timesheet → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BlnEmptySlot boolean - -
BlnCanStartEarly boolean - -
BlnCanEndEarly boolean - -
BlnIsMandatory boolean - -
StrType string - -
IntStart int - -
IntEnd int - -
IntUnixStart long - -
IntUnixEnd long - -
WhenStart datetime - -
WhenEnd datetime - -
StrTypeName string - -
StrState string - -
Timesheet int Timesheet → ID -

EmployeeAppraisal

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/EmployeeAppraisal

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Employee int Employee → ID -
DayTimestamp long - -
WhenDayTimestamp datetime - -
Date datetime - -
Mark01 decimal - -
Mark02 decimal - -
Mark03 decimal - -
Mark04 decimal - -
Mark05 decimal - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

EmployeeWorkplace

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/EmployeeWorkplace

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
EmployeeID int Employee → ID -
Company int Location → ID -
SortOrder int - -
Agreement1 int -
  • 12 May 2020 Foreign Key: Refers to `EmployeeAgreement` (Not implemented).
Agreement2 int -
  • 12 May 2020 Foreign Key: Refers to `EmployeeAgreement` (Not implemented).
Agreement3 int -
  • 12 May 2020 Foreign Key: Refers to `EmployeeAgreement` (Not implemented).
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

EmploymentCondition

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/EmploymentCondition

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
AwardLevel string - -
EmploymentBasis int - -
EmploymentCategory int - -
EmploymentPeriod int - -
EmploymentStatus int - -
ProbationaryPeriod int - -
WorkingDaysPerPeriod decimal - -
UsualStartTime datetime - -
UsualFinishTime datetime - -
UsualMealbreak datetime - -
AvgHoursPerDay decimal - -
MinHoursPerDay decimal - -
MinHoursForLeave decimal - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Kiosk

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Kiosk

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Company int Location → ID -
ConnectionMode int - -
SubnetRestriction string - -
AuthenticationMode int - -
UseBiometric boolean - -
LastActivity string - -
IpAddress string - -
EnableMultiLocations boolean - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Leave

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Leave

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Employee int Employee → ID -
EmployeeHistory int -
  • 12 May 2020 Foreign Key: Refer to `EmployeeHistory` (not implemented).
Company int Location → ID -
LeaveRule int - -
Start int - -
DateStart datetime - -
End int - -
DateEnd datetime - -
Days decimal - -
ApproverTime int - -
ApproverPay int - -
Comment string - -
Status int - -
ApprovalComment string - -
TotalHours decimal - -
StartTimeLocalized datetime - -
EndTimeLocalized datetime - -
DateStartAllDay boolean - -
DateEndAllDay boolean - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

LeavePayLine

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/LeavePayLine

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
LeaveID int Leave → ID -
LeaveRule int -
  • 12 May 2020 Foreign Key: Refers to `LeaveRule` (not Implemented).
EmployeeAgreement int -
  • 11 May 2020 Foreign Key: Refers to `EmployeeAgreement`(not Implemented)
Date datetime - -
StartTime datetime - -
EndTime datetime - -
Hours string - -
Comment string - -
TimesheetID int Timesheet → ID -
StartTimeLocalized datetime - -
EndTimeLocalized datetime - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

OperationalUnit

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/OperationalUnit

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Company int Location → ID -
ParentOperationalUnit int OperationalUnit → ID -
OperationalUnitName string - -
Active boolean - -
PayrollExportName string - -
Address int Address → ID -
Contact int Contact → ID -
RosterSortOrder int - -
ShowOnRoster boolean - -
Colour string - -
RosterActiveHoursSchedule int Schedule → ID -
DailyRosterBudget decimal - -
OperationalUnitType int - -
CompanyCode string - -
CompanyName string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

PayPeriod

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/PayPeriod

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Active boolean - -
StartDate datetime - -
Cycle int - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

PayRule

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/PayRules

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
PayTitle string - -
RemunerationType int - -
RemunerationBy int - -
AnnualSalary decimal - -
HourlyRate decimal - -
IsMultiplier boolean - -
MultiplierValue boolean - -
MultiplierBaseRate int - -
MinimumType int - -
MaximumType int - -
MinimumValue boolean - -
MaximumValue boolean - -
MinimumShiftLength string - -
MaximumShiftLength string - -
AdvancedCalculation string - -
IsExported boolean - -
UnitValue decimal - -
Schedule int Schedule → ID -
RecommendWith int - -
DexmlScript int - -
DexmlScriptParam string - -
PeriodType int - -
PayPortionRule int - -
PayrollCategory string - -
Comment string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

PublicHoliday

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/PublicHoliday

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Title string - -
Schedule int Schedule → ID -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

SalesData

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/SalesData

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Date datetime - -
Timestamp long - -
WhenTimestamp datetime - -
Employee int Employee → ID -
OperationalUnit int OperationalUnit → ID -
SalesType string - -
SalesRef string - -
SalesQty decimal - -
SalesAmount decimal - -
SalesPayload string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Schedule

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Schedule

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
StartDate datetime - -
EndDate datetime - -
StartTime datetime - -
EndTime datetime - -
RepeatType int - -
RepeatEvery int - -
WeeklyOnDays string - -
MonthlyOnDates string - -
MonthlyOnDays string - -
Exception string - -
Saved boolean - -
Orm string - -
Template boolean - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

StressProfile

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/StressProfile

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
MaxHoursPerShift decimal - -
MaxHoursPerPeriod decimal - -
MaxDaysPerPeriod decimal - -
MaxHoursPerDay decimal - -
GapHoursBetweenShifts decimal - -
CustomRules string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

SystemUsageBalance

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/SystemUsageBalance

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
Type int - -
Date datetime - -
Credit decimal - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

SystemUsageTracking

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/SystemUsageTracking

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
Date datetime - -
EmpID int - -
CompanyID int Location → ID -
BalanceID int SystemUsageBalance → ID -
UsageType int - -
UsageRecordID int - -
Usage decimal - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Task

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/Task

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
TaskSetupID int TaskSetup → ID -
OpUnitID int OperationalUnit → ID -
GroupID int TaskGroup → ID -
DayTimestamp long - -
WhenDayTimestamp datetime - -
Date datetime - -
OrigDayTimestamp long - -
WhenOrigDatTimestamp datetime - -
OrigDate datetime - -
AvailableAfterTimestamp long - -
WhenAvailableAfterTimestamp datetime - -
DueDate datetime - -
DueTimestamp long - -
WhenDueTimestamp datetime - -
RepeatIfNotCompleted boolean - -
SortOrder int - -
Type int - -
Question string - -
Answer string - -
Comment string - -
UserEntry int - -
UserPerformTask int - -
UserResponsible int - -
TsCompleted int - -
Start int - -
End int - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

TaskGroup

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/TaskGroup

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
GroupSetupID int -
  • 12 May 2020 Foreign Key: Refers to `TaskGroupSetup` (not implemented).
Key string - -
DayTimestamp long - -
WhenDayTimestamp datetime - -
Date datetime - -
OrigDayTimestamp long - -
WhenOrigDayTimestamp datetime - -
OrigDate datetime - -
OpUnitID int OperationalUnit → ID -
SortOrder int - -
Comment string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

TaskSetup

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/TaskSetup

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
GroupID int -
  • 12 May 2020 Foreign Key: Refers to `TaskGroupSetup` (not implemented).
Type int - -
Parent int - -
Question string - -
Default string - -
SortOrder int - -
Schedule int Schedule → ID -
OnYes string - -
OnNo string - -
RenderFunc string - -
Active boolean - -
AvailableAfter string - -
RepeatIfNotCompleted boolean - -
Time string - -
Section string - -
Priority string - -
Helptext string - -
SupercedePrev boolean - -
Colour string - -
OnStart string - -
OnSubmit string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

EmployeeAgreement

Documentation: https://www.deputy.com/api-doc/Resources/EmployeeAgreement

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
EmployeeID int Employee → ID -
PayPoint int - -
EmpType int - -
CompanyName string - -
Active boolean - -
StartDate datetime - -
EndDate datetime - -
Contract int - -
SalaryPayRule int - -
ContractFile int - -
PayrollID string - -
PayPeriod int - -
HistoryID int EmployeeAgreementHistory → ID -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

EmployeeAgreementHistory

Documentation: https://www.deputy.com/api-doc/Resources/EmployeeAgreementHistory

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
AgreementID int EmployeeAgreement → ID -
PayPoint int - -
EmpType int - -
CompanyName string - -
Active boolean - -
StartDate datetime - -
Contract int - -
SalaryPayRule int PayRule → ID -
ContractFile int - -
PayrollID string - -
PayPeriod int PayPeriod → ID -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Geo

Documentation: https://api-doc.dev.dpty.io/api-doc/Resources/StressProfile

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Latitude decimal - -
Longitude decimal - -
RecID decimal - -
Orm string - -
No string -
  • 16 Dec 2021 The street number
Street string - -
State string - -
Postcode string - -
Country string - -
Creator int Employee → ID -
Created datetime - -
Modified datetime - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.