TimeTrak Database Changes between 3.2 – 4.0
September 24, 2018 General,
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.co.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.co.nz or phone NZ:0800 12 00 99 | AU:1800 60 80 77
Search
Categories
Tags
Latest Entries
TimeTrak 24.1 Release Notes – What’s New
May 2, 2024
TimeTrak SMS
May 1, 2024
Job Quote Line Narrations Displayed in TimeTrak APP
June 22, 2023
TimeTrak – Jobs
June 13, 2023
TimeTrak – Tasks
May 23, 2023
Payroll OverTime Calculator
May 2, 2024
Disbursement description can now be edited within checklists in TimeTrak APP
April 30, 2024
Access TimeTrak data for reporting
April 24, 2024