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
Latest Entries
TimeSheet Manager Behaviour on Show All Setting
September 22, 2021
Ability to update the Task Status off a Checklist
September 20, 2021
Task Grids updated to select all sub tasks in the grid on parent task selection
September 16, 2021
Ability to See/Select Inactive Serviceable Units and Reactivate from Job on Assignment ~ Mobile
September 16, 2021
Contractors and Sub Contractors in TimeTrak
September 13, 2021