Tempo Worklogs

The Tempo Worklogs additional export populates 2 tables in Snowflake:

Table Details

S4J_TEMPOWORKLOGS

This table contains the main information related to Tempo timesheets/worklogs. All Tempo timesheet information associated with the current export’s work items is stored in this table. One instance of this table is created per configured export location. All exports with the Tempo Timesheets additional export option selected will merge their work item’s Tempo timesheet information into this table. For this reason, multiple exports per location may include this option without causing export processes to perform duplicate work. If all Tempo timesheets from Jira are required, then one or more exports containing all Jira work items must include this option. Custom/scheduled updates to exports will only merge in timesheet information that has changed since the last update.

Column	Type	Description
ID	INT	Autogenerated ID
TEMPOWORKLOGID	INT	Tempo worklog unique ID
JIRAWORKLOGID	INT	Associated Jira worklog ID
ISSUEID	INT	Associated Jira issue ID
DESCRIPTION	VARCHAR	Tempo worklog description
TIMESPENTSECONDS	INT	Tempo worklog logged time (seconds)
BILLABLESECONDS	INT	Tempo worklog billable time (seconds)
STARTDATE	DATE	Tempo worklog start date
STARTTIME	TIME	Tempo worklog start time
AUTHORACCOUNTID	VARCHAR	Tempo worklog author’s Jira user account ID
CREATEDAT	DATETIME	Tempo worklog creation timestamp
UPDATEDAT	DATETIME	Tempo worklog update timestamp
DELETEDAT	DATETIME	Tempo worklog deleted timestamp
REVIEWSTATUS	VARCHAR	Tempo worklog review status
REVIEWERACCOUNTID	VARCHAR	Tempo worklog reviewer’s Jira user account ID

S4J_TEMPOWORKLOGS_ATTRIBUTES

This table contains information related to the attributes associated with Tempo timesheets/worklogs.

Column	Type	Description
ID	INT	Autogenerated ID
TEMPOWORKLOGID	INT	Associated Tempo worklog ID
KEY	VARCHAR	Attribute key
VALUE	VARCHAR	Attribute value