Between TimeTrak version 3.2 and 4.0 the TimeTrak database was redesigned in preparation for our API.
This means that a lot of TimeTrak database tables and columns have been renamed and in some cases removed.
Due to this and the amount of new features, the upgrade from 3.2 to 4.0 is a large one.
Any customisation that you have in your Exo database or TimeTrak database that relates to these old TimeTrak tables/ fields will need to be updated to reference the new table / field names.
This customisation includes any custom reports in TimeTrak or Exo.
We have TimeTrak 4.0 Database Schemas available on our website as per below:
https://timetrak.benandhayley.nz/blog/category/database-schemas
Please see below 3.2 to 4.0 changes for your reference:
Table and Column Updates:
| Original Table Name |
New Table Name |
Original Column Name |
New Column Name |
| Breaks |
Breaks |
BID |
Id |
| UserGroup |
Groups |
Gid
|
Id
|
|
|
GroupName |
Name |
|
|
ResourceId |
JobResourceId |
|
|
DefaultJobType |
JobTypeId |
| ApplicationUser |
Users |
Uid |
Id |
|
|
StaffId |
JobResourceId |
|
|
UserName |
Name |
|
|
LatestCost |
WageCost |
|
|
StockLocation |
StockLocationId |
|
|
CalendarClick |
REMOVED |
|
|
CalendarGroupBy |
REMOVED |
|
|
CalendarShowGroups |
REMOVED |
|
|
CalendarType |
REMOVED |
|
|
ClosedTasksVisible |
REMOVED |
|
|
DateView |
REMOVED |
|
|
DaysOnCalendar |
REMOVED |
|
|
DefaultTaskSortField |
REMOVED |
|
|
ExpandLevel |
REMOVED |
|
|
LoginMessage |
REMOVED |
|
|
NewTaskAssignment |
REMOVED |
|
|
PreLoadTaskTitle |
REMOVED |
|
|
RefreshMins |
REMOVED |
|
|
SharedCalendars |
REMOVED |
|
|
ShowAcceptanceTab |
REMOVED |
|
|
ShowAllSubTasks |
REMOVED |
|
|
ShowRate |
REMOVED |
|
|
TasksAcceptedEmail |
REMOVED |
|
|
TaskEmail |
REMOVED |
|
|
TaskTrakView |
REMOVED |
|
|
TaskView |
REMOVED |
|
|
TimeFormat |
REMOVED |
|
|
WorkInProgress |
REMOVED |
| TimeEntry |
TimeEntries |
Eid |
Id |
|
|
Uid |
UserId |
|
|
Sid |
StatusId |
|
|
Npid |
TimeAnalysisId |
|
|
CostGroup |
CostGroupId |
|
|
CostType |
CostTypeId |
|
|
ApprovalSent |
ApprovalSentAt |
|
|
Approval |
ApprovalState |
|
|
Approved |
ApprovedAt |
| TT_Task |
Tasks |
TaskId |
Id |
|
|
TimeRequired |
EstimateTime |
|
|
TotalSubTask |
TotalFromSubTasks |
|
|
PercentComplete |
ActualComplete |
|
|
Priority |
PriorityId |
|
|
Uid |
UserId |
|
|
Gid |
GroupId |
|
|
Status |
StatusId |
|
|
JobType |
TypeId |
|
|
JobCategory |
CategoryId |
|
|
Urgency |
UrgencyId |
|
|
Contact |
ContactNo |
|
|
CreatedBy |
CreatedById |
|
|
ClientCreated |
CreatedByClient |
|
|
DateEntered |
CreatedDate |
|
|
LastModified |
LastModifiedById |
|
|
AssignedBy |
AssignedById |
|
|
SyncTask |
SyncToOutlook |
|
|
ResponseLevel |
ResponseLevelId |
|
|
Rid |
RecurrenceId |
|
|
Sid |
BillableStatusId |
| GroupMembership |
UserGroups |
Uid
|
UserId
|
|
|
Gid |
GroupId |
| GroupEmailUsers |
GroupEmailUsers |
Gid |
GroupId |
| LabourCodeMembership |
UserLabourCodes |
Sid |
StatusId |
| UserEmailTemplates |
UserEmailTemplates |
Uid |
UserId |
| Narration |
Narrations |
Nid |
Id |
| NarrationGroup |
NarrationGroups |
Gid
|
GroupId
|
|
|
Nid |
NarrationId |
| NonProductive |
TimeAnalyses |
NPID
|
Id
|
|
|
Sid |
StatusId |
|
|
Detail |
Name |
|
|
IncludeProdCalc |
IncludeInProdCalc |
| NonProductiveGroups |
TimeAnalysesGroups |
NPID
|
TimeAnalysisId
|
|
|
Gid |
GroupId |
| CostTypeGroup |
CostTypeGroups |
Gid
|
GroupId
|
|
|
Ctid |
CostTypeId |
| CostType |
CostTypes |
Ctid
|
Id
|
|
|
Description |
Name |
|
|
ApplyToDisbursements |
ApplyPriceToDisbursements |
| Status |
Statuses |
Sid
|
Id
|
|
|
Status |
Name |
|
|
IncludeProdCalc |
IncludeInProdCalc |
| Approval |
Approvals |
ApprovalId
|
Id
|
|
|
SentBy |
SentById |
| ExonetStatus |
ExoStatus |
Sid
|
StatusId |
| Export |
Exports |
ExportId
|
Id
|
|
|
ExportBy |
ResponseToId |
| TT_TaskLog |
TaskLogs |
LogId
|
Id
|
|
|
ResponseTo |
ResponseToId |
|
|
CreatedBy |
CreatedById |
|
|
ClientCreated |
CreatedByClient |
|
|
LastModifiedBy |
LastModifiedById |
Scalar Functions:
| GetTimeRequired |
GetTaskEstimatedTime (TaskId, BaseId, TotalFromSubTasks, EstimatedTime) |
| GetActualTime |
GetTaskActualTime (TaskId, BaseId, TotalFromSubTasks) |
| GetSubTaskCount |
GetTaskSubCount (TaskId, BaseId, TotalFromSubTasks) |
|
GetTaskAppointmentCount (TaskId, BaseId, TotalfromSubTasks) |
|
GetTaskScheduledTime (TaskId, BaseId, TotalFromSubTasks) |
| HasSubTask |
REMOVED |
Table Functions:
| GetTasksWithTotals |
GetTaskTotals (TaskId, BaseId) |
| GetCompletedTasksWithTotals |
REMOVED |
| GetJobList |
REMOVED |
| GetTasks |
REMOVED |
| GetTasksByJobWithTotals |
REMOVED |
If you have any further questions please contact the TimeTrak team via email: support@timetrak.benandhayley.nz or phone NZ:0800 12 00 99 | AU:1800 60 80 77