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