Workfront Data Connect data dictionary

Last update: Tue Oct 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Reports and Dashboards

CREATED FOR:

User

This page contains information about the structure and content of the data in Workfront Data Connect.

NOTE

The data in Data Connect refreshes every four hours, so recent changes may not be immediately reflected.

Table types

There are a number of table types you can utilize in Data Connect to view your Workfront data in a way that provides the most insight.

Current table

The Current table reflects data similarly to how it exists in Workfront, every object and its current state. However, it can be navigated with much lower latency than within Workfront.
Event table

The Event table tracks every change record in Workfront: that is, every time an object changes state, a record is created that shows when the change happened, who made the change, and what was changed. Therefore, this table is useful for point-in-time comparisons. This table only includes records from the past three years.
Daily History table

The Daily History table offers an abbreviated version of the Event table, in that it shows the state of each object on a daily basis rather than when each individual event occurred. As such, this table is useful for trend analysis.

Entity relationship diagram

Objects in Workfront (and, therefore, in your Data Connect data lake) are defined not only by their individual values, but by their relationships with other objects. The entity relationship diagram below provides a high-level mapping of object relationships in Data Connect. The diagram can be viewed and downloaded using the following link:

Data Connect entity relationship diagram

IMPORTANT

The entity relationship diagram is a work in progress—as such, it is for reference purposes only and is subject to change.

Date types

There are a number of date objects that provide information about when specific events occur.

DL_LOAD_TIMESTAMP: This date is used for internal reference, and reflects when the data was loaded into the Current, Event, or Daily History table. This date should not be used for data analysis, and planned to be removed during the beta phase of Workfront data lake.
CALENDAR_DATE: This date is present only in the Daily History table. This table provides a record of what the data looked like at 11:59 UTC for each date specified in CALENDAR_DATE.
BEGIN_EFFECTIVE_TIMESTAMP: This date is present in both Event and Daily History tables, and records exactly when a record changed to the value it has in the current row.
END_EFFECTIVE_TIMESTAMP: This date is present in both Event and Daily History tables, and records exactly when a record changed from the value in the current row to a value in a different row. To allow for between queries on BEGIN_EFFECTIVE_TIMESTAMP and END_EFFECTIVE_TIMESTAMP this is value is never null, even if there is no new value. In the event a record is still valid (i.e., the value has not changed), END_EFFECTIVE_TIMESTAMP will have a value of 2300-01-01.

Terminology table

The following table correlates object names in Workfront (as well as their names in the interface and API) with their equivalent names in Data Connect.

Workfront Entity Name

Interface References

API Reference | Label

Data Lake Tables

Relationships Field

Relationship Table & Field

Access Level

ACSLVL | Access Level

ACCESSLEVELS_CURRENT
ACCESSLEVELS_DAILY_HISTORY
ACCESSLEVELS_EVENT

ACCESSLEVELID (self)
APPGLOBALID
LASTUPDATEDBYID
LEGACYACCESSLEVELID
OBJID
SYSID

Self
Not a relationship; used for internal application purposes
USER_CURRENT | USERID
Not a relationship; used for internal application purposes
The ID of the object identified in the OBJCODE field
Not a relationship; used for internal application purposes

Access Rule

ACSRUL | Share

ACCESSRULES_CURRENT
ACCESSRULES_DAILY_HISTORY
ACCESSRULES_EVENT

ACCESSORID
ACCESSRULEID (self)
ANCESTORID
LASTUPDATEDBYID
SECURITYOBJID
SYSID

The ID of the object identified in ACCESSOROBJCODE field
Self
The ID of the object identified in the ANCESTOROBJCODE field
USERS_CURRENT | USERID
The ID of the object identified in the SECURITYOBJCODE field
Not a relationship; used for internal application purposes

Approval Path

ARVPTH | Approval

APPROVALPATHS_CURRENT
APPROVALPATHS_DAILY_HISTORY
APPROVALPATHS_EVENT

APPROVALPATHID (self)
APPROVALPROCESSID
ENTEREDBYID
GLOBALPATHID
LASTUPDATEDBYID
SYSID

Self
APPROVALPROCESSES_CURRENT | APPROVALPROCESSID
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes

Approval Process

ARVPRC | Approval Process

APPROVALPROCESSES_CURRENT
APPROVALPROCESSES_DAILY_HISTORY
APPROVALPROCESSES_EVENT

APPROVALPROCESSID (self)
ENTEREDBYID
LASTUPDATEDBYID
SYSID

Self
USERS_CURRENT | USERID
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes

Approval Step

ARVSTP | Approval Stage

APPROVALSTEPS_CURRENT
APPROVALSTEPS_DAILY_HISTORY
APPROVALSTEPS_EVENT

APPROVALPATHID
APPROVALSTEPID (self)
SYSID

APPROVALPATHS_CURRENT | APPROVALPATHID
Self
Not a relationship; used for internal application purposes

ApproverStatus

Approver Status

ARVSTS | ApproverStatus

APPROVERSTATUSES_CURRENT
APPROVERSTATUSES_DAILY_HISTORY
APPROVERSTATUSES_EVENT

APPROVERSTATUSID (self)
APPROVABLEOBJID
APPROVALSTEPID
APPROVEDBYID
DELEGATEUSERID
LASTUPDATEDBYID
OPTASKID
OVERRIDDENUSERID
PROJECTID
STEPAPPROVERID
SYSID
TASKID
WILDCARDUSERID

Assignment

ASSGN | Assignment

ASSIGNMENTS_CURRENT
ASSIGNMENTS_DAILY_HISTORY
ASSIGNMENTS_EVENT

ASSIGNEDBYID
ASSIGNEDTOID
ASSIGNMENTID (self)
CATEGORYID
CLASSIFIERID
OPTASKID
PRIVATERATECARDID
PROJECTID
ROLEID
TASKID
TEAMID

Awaiting Approvals

AWAPVL | Awaiting Approval

AWAITINGAPPROVALS_CURRENT
AWAITINGAPPROVALS_DAILY_HISTORY
AWAITINGAPPROVALS_EVENT

ACCESSREQUESTID
APPROVABLEID
APPROVERID
AWAITINGAPPROVALID (self)
DOCUMENTID
DOCUMENTVERSIONID
OPTASKID
PROJECTID
ROLEID
SUBMITTEDBYID
SYSID
TASKID
TEAMID
TIMESHEETID
USERID

Baseline

BLIN | Baseline

BASELINES_CURRENT
BASELINES_DAILY_HISTORY
BASELINES_EVENT

BASELINEID (self)
EXCHANGERATEID
PROJECTID
SYSID

Self
EXCHANGERATES_CURRENT | EXCHANGERATEID
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes

Baseline Task

BSTSK | Baseline Task

BASELINETASKS_CURRENT
BASELINETASKS_DAILY_HISTORY
BASELINETASKS_EVENT

BASELINEID
BASELINETASKID (self)
EXCHANGERATEID
PROJECTID
SYSID
TASKID

BASELINES_CURRENT | BASELINEID
Self
EXCHANGERATES_CURRENT | EXCHANGERATEID
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes
TASKS_CURRENT | TASKID

Billing Rate

Rate or Override Rate

RATE | Billing Rate

RATES_CURRENT
RATES_DAILY_HISTORY
RATES_EVENT

ASSIGNMENTID
CLASSIFIERID
EXCHANGERATEID
NLBRCATEGORYID
NONLABORRESOURCEID
OBJID
PROJECTID
RATECARDID
RATEID (self)
ROLEID
SOURCERATECARDID
SYSID
TEMPLATEID
USERID

ASSIGNMENTS_CURRENT | ASSIGNMENTID
Classifier table not supported currently
EXCHANGERATES_CURRENT | EXCHANGERATEID
Non-Labor Resource Category table not supported currently
NONLABORRESOURCES_CURRENT | NONLABORRESOURCEID
The ID of the object identified in the OBJCODE field
PROJECTS_CURRENT | PROJECTID
RATECARD_CURRENT | RATECARDID
Self
ROLES_CURRENT | ROLEID
RATECARD_CURRENT | RATECARDID
Not a relationship; used for internal application purposes
TEMPLATES_CURRNT | TEMPLATEID
USERS_CURRENT | USERID

Billing Record

BILL | Billing Record

BILLINGRECORDS_CURRENT
BILLINGRECORDS_DAILY_HISTORY
BILLINGRECORDS_EVENT

BILLINGRECORDID (self)
CATEGORYID
EXCHANGERATEID
INVOICEID
LASTUPDATEDBYID
PROJECTID
SYSID

Self
CATEGORIES_CURRENT | CATEGORYID
EXCHANGERATES_CURRENT | EXCHANGERATEID
Invoice table not supported currently
USERS_CURRENT | USERID
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes

Booking

BOOKNG | Booking

BOOKINGS_CURRENT
BOOKINGS_DAILY_HISTORY
BOOKINGS_EVENT

BOOKINGID (self)
ENTEREDBYID
LASTUPDATEDBYID
NLBRCATEGORYID
NONLABORRESOURCEID
OBJID
PROJECTID
SYSID
TASKID
TEMPLATEID
TEMPLATETASKID
TOPOBJID

Self
USERS_CURRENT | USERID
USERS_CURRENT | USERID
Non-labor Resource Category table not supported currently
NONLABORRESOURCES_CURRENT | NONLABORRESOURCEID
The ID of the object identified in the OBJOBJCODE field
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes
TASKS_CURRENT | TASKID
TEMPLATES_CURRENT | TEMPLATEID
TEMPLATETASKS_CURRENT | TEMPLATETASKID
The ID of the object identified in the TOPOBJCODE field

Category

Custom Form

CTGY | Category

CATEGORIES_CURRENT
CATEGORIES_DAILY_HISTORY
CATEGORIES_EVENT

CATEGORYID (self)
ENTEREDBYID
GROUPID
LASTUPDATEDBYID
SYSID

Self
USERS_CURRENT | USERID
GROUPS_CURRENT | GROUPID
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes

Category Parameter

Custom Form Fields

CTGYPA | Category Parameter

CATEGORIESPARAMETERS_CURRENT
CATEGORIESPARAMETERS_DAILY_HISTORY
CATEGORIESPARAMETERS_EVENT

CATEGORIESPARAMETERID (self)
CATEGORYID
PARAMETERGROUPID
PARAMETERID
SYSID

Self
CATEGORIES_CURRENT | CATEGORYID
Parameter Group table not supported currently
PARAMETERS_CURRENT | PARAMETERID
Not a relationship; used for internal application purposes

Company

CMPY | Company

COMPANIES_CURRENT
COMPANIES_DAILY_HISTORY
COMPANIES_EVENT

CATEGORYID
COMPANYID (self)
ENTEREDBYID
GROUPID
LASTUPDATEDBYID
PRIVATERATECARDID
SYSID

Custom Quarter

CSTQRT | Custom Quarter

CUSTOMQUARTERS_CURRENT
CUSTOMQUARTERS_DAILY_HISTORY
CUSTOMQUARTERS_EVENT

CUSTOMQUARTERID (self)
SYSID

Self
Not a relationship; used for internal application purposes

CustomEnum

Condition, Priority, Severity, Status

CSTEM | Custom Enum

CUSTOMENUMS_CURRENT
CUSTOMENUMS_DAILY_HISTORY
CUSTOMENUMS_EVENT
* The type of record is identified through the `enumClass` property. The following are the expected types:
CONDITION_OPTASK
CONDITION_PROJ
CONDITION_TASK
PRIORITY_OPTASK
PRIORITY_PROJ
PRIORITY_TASK
SEVERITY_OPTASK
STATUS_OPTASK
STATUS_PROJ
STATUS_TASK

ENTEREDBYID
GROUPID

USER_CURRENT | USERID
GROUP_CURRENT | GROUPID

Document

DOCU | Document

DOCUMENTS_CURRENT
DOCUMENTS_DAILY_HISTORY
DOCUMENTS_EVENT
DOCUMENTS_CUSTOM_VALUE_CURRENT
DOCUMENTS_CUSTOM_VALUE_DAILY_HISTORY
DOCUMENTS_CUSTOM_VALUE_EVENT

CATEGORYID
CHECKEDOUTBYID
DOCUMENTID
DOCUMENTREQUESTID
EXCHANGERATEID
ITERATIONID
LASTNOTEID
LASTUPDATEDBYID
NOTEID
OBJID
OPTASKID
OWNERID
PORTFOLIOID
PROGRAMID
PROJECTID
RELEASEVERSIONID
TASKID
TEMPLATEID
TEMPLATETASKID
TOPOBJID
USERID

Document Approval

DOCAPL | Document Approval

DOCAPPROVALS_CURRENT
DOCAPPROVALS_DAILY_HISTORY
DOCAPPROVALS_EVENT

APPROVERID
DOCAPPROVALID (self)
DOCUMENTID
NOTEID
REQUESTORID
SYSID

USERS_CURRENT | USERID
Self
DOCUMENTS_CURRENT | DOCUMENTID
NOTES_CURRENT | NOTEID
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes

Document Folder

DOCFLD | DocsFolders

DOCFOLDERS_CURRENT
DOCFOLDERS_DAILY_HISTORY
DOCFOLDERS_EVENT

DOCFOLDERID (self)
ENTEREDBYID
ISSUEID
ITERATIONID
LINKEDFOLDERID
PARENTID
PORTFOLIOID
PROGRAMID
PROJECTID
SYSID
TASKID
TEMPLATEID
TEMPLATETASKID
USERID

DocumentProvideMetadata

Document Provide Metadata

DOCMET | DocumentProviderMetadata

DOCPROVIDERMETA_CURRENT
DOCPROVIDERMETA_DAILY_HISTORY
DOCPROVIDERMETA_EVENT

DOCPROVIDERMETAID (self)
SYSID

Self
Not a relationship; used for internal application purposes

DocumentProvider

Document Provider

DOCPRO | Document Provider

DOCPROVIDERS_CURRENT
DOCPROVIDERS_DAILY_HISTORY
DOCPROVIDERS_EVENT

DOCPROVIDERCONFIGID
DOCPROVIDERID (self)
OWNERID
SYSID

DOCPROVIDERCONFIG_CURRENT | DOCPROVIDERCONFIGID
Self
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes

DocumentProviderConfig

Document Provider Config

DOCCFG | DocumentProviderConfig

DOCPROVIDERCONFIG_CURRENT
DOCPROVIDERCONFIG_DAILY_HISTORY
DOCPROVIDERCONFIG_EVENT

DOCPROVIDERCONFIGID (self)
SYSID

Self
Not a relationship; used for internal application purposes

DocumentVersion

Document Version

DOCV | Document Version

DOCUMENTVERSIONS_CURRENT
DOCUMENTVERSIONS_DAILY_HISTORY
DOCUMENTVERSIONS_EVENT

DOCUMENTID
DOCUMENTPROVIDERID
DOCUMENTVERSIONID
ENTEREDBYID
EXTERNALSTORAGEID
PROOFAPPROVALSTATUSID
PROOFEDBYUSERID
PROOFID
PROOFOWNERID
PROOFSTAGEID

DOCUMENT_CURRENT | DOCUMENTID
DOCPROVIDERS_CURRENT | DOCUMENTPROVIDERID
Self
USER_CURRENT | USERID
External ID
Proof Approval Status table not supported currently
USER_CURRENT | USERID
Proof table not supported currently
USER_CURRENT | USERID
Proof Stage table not supported currently

Exchange Rate

EXRATE | Exchange Rate

EXCHANGERATES_CURRENT
EXCHANGERATES_DAILY_HISTORY
EXCHANGERATES_EVENT

EXCHANGERATEID (self)
PROJECTID
SYSID
TEMPLATEID

Self
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes
TEMPLATES_CURRENT | TEMPLATEID

Expense

EXPNS | Expense

EXPENSES_CURRENT
EXPENSES_DAILY_HISTORY
EXPENSES_EVENT

BILLINGRECORDID
CATEGORYID
ENTEREDBYID
EXCHANGERATEID
EXPENSEID (self)
EXPENSETYPEID
LASTUPDATEDBYID
OBJID
PROJECTID
SYSID
TASKID
TEMPLATEID
TEMPLATETASKID
TOPOBJID

BILLINGRECORDS_CURRENT | BILLINGRECORDID
CATEGORIES_CURRENT | CATEGORYID
USERS_CURRENT | USERID
EXCHANGERATES_CURRENT | EXCHANGERATEID
Self
EXPENSETYPES_CURRENT | EXPENSETYPEID
USERS_CURRENT | USERID
The ID of the object identified in the OBJCODE field
PROJECTS_CURRENT | PROJECTID
Not a relationship; used for internal application purposes
TASKS_CURRENT | TASKID
TEMPLATES_CURRENT | TEMPLATEID
TEMPLATETASKS_CURRENT | TEMPLATETASKID
The ID of the object identified in the TOPOBJCODE field

Expense Type

EXPTYP | Expense Type

EXPENSETYPES_CURRENT
EXPENSETYPES_DAILY_HISTORY
EXPENSETYPES_EVENT

APPGLOBALID
EXPENSETYPEID (self)
OBJID
SYSID

Not a relationship; used for internal application purposes
Self
The ID of the object identified in the OBJCODE field
Not a relationship; used for internal application purposes

Group

GROUP | Group

GROUPS_CURRENT
GROUPS_DAILY_HISTORY
GROUPS_EVENT

BUSINESSLEADERID
CATEGORYID
ENTEREDBYID
GROUPID
LAYOUTTEMPLATEID
PARENTID
ROOTID
UITEMPLATEID

Hour

HOUR | Hour

HOURS_CURRENT
HOURS_DAILY_HISTORY
HOURS_EVENT

APPROVEDBYID
BILLINGRECORDID
CATEGORYID
CLASSIFIERID
DUPID
EXCHANGERATEID
EXTERNALTIMESHEETID
HOURID
HOURTYPEID
LASTUPDATEDBYID
OPTASKID
OWNERID
PROJECTID
PROJECTOVERHEADID
ROLEID
TASKID
TIMESHEETID

USER_CURRENT | USERID
BILLINGRECORDS_CURRENT | BILLINGRECORDID
CATEGORIES_CURRENT | CATEGORYID
Classifier table not supported currently
Not a relationship; used for internal application purposes
EXCHANGERATES_CURRENT | EXCHANGERATEID
Not a Workfront relationship; used for integration to external systems
Self
HOURTYPE_CURRENT | HOURTYPEID
USER_CURRENT | USERID
OPTASK_CURRENT | OPTASKID
USER_CURRENT | USERID
PROJECT_CURRENT | PROJECTID
Not a relationship; used for internal application purposes
ROLE_CURRENT | ROLEID
TASK_CURRENT | TASKID
TIMESHEET_CURRENT | TIMESHEETID

Hour Type

HOURT | Hour Type

HOURTYPES_CURRENT

APPGLOBALID
HOURTYPEID
OBJID

Not a relationship; used for internal application purposes
Self
Not a relationship; used for internal application purposes

Iteration

ITRN | Iteration

ITERATIONS_CURRENT
ITERATIONS_DAILY_HISTORY
ITERATIONS_EVENT

CATEGORYID
ENTEREDBYID
ITERATIONID (self)
LASTUPDATEDBYID
OWNERID
SYSID
TEAMID

Journal Entry

JRNLE | Journal Entry

JOURNALENTRIES_CURRENT
JOURNALENTRIES_DAILY_HISTORY
JOURNALENTRIES_EVENT

APPROVERSTATUSID
ASSIGNMENTID
AUDITRECORDID
BASELINEID
BILLINGRECORDID
COMPANYID
DOCUMENTID
DOCUMENTSHAREID
EDITEDBYID
EXPENSEID
HOURID
INITIATIVEID
JOURNALENTRIEID (self)
OBJID
OPTASKID
PORTFOLIOID
PROGRAMID
PROJECTID
SUBOBJID
SUBSCRIBEID
SYSID
TASKID
TEMPLATEID
TIMESHEETID
TOPOBJID
USERID

APPROVERSTATUSES_CURRENT | APPROVERSTATUSID
ASSIGNMENTS_CURRENT | ASSIGNMENTID
Audit record table not supported currently
BASELINES_CURRENT | BASELINEID
BILLINGRECORDS_CURRENT | BILLINGRECORDID
COMPANIES_CURRENT | COMPANYID
DOCUMENTS_CURRENT | DOCUMENTID
Document Share table not supported currently
USERS_CURRENT | USERID
EXPENSES_CURRENT | EXPENSEID
HOURS_CURRENT | HOURID
Initiative table not supported currently
Self
The ID of the object identified in the OBJCODE field
OPTASKS_CURRENT | OPTASKID
PORTFOLIO_CURRENT | PORTFOLIOID
PROGRAM_CURRENT | PROGRAMID
PROJECTS_CURRENT | PROJECTID
The ID of the object identified in the SUBOBJCODE field
Subscribe table not supported currently
Not a relationship; used for internal application purposes
TASKS_CURRENT | TASKID
TEMPLATES_CURRENT | TEMPLATEID
TIMESHEETS_CURRENT | TIMESHEETID
The ID of the object identified in the TOPOBJCODE field
USERS_CURRENT | USERID

LinkedFolder

LNKFDR | LinkedFolder

LINKEDFOLDERS_CURRENT
LINKEDFOLDERS_DAILY_HISTORY
LINKEDFOLDERS_EVENT

DOCUMENTPROVIDERID
EXTERNALSTORAGEID
FOLDERID
LINKEDBYID
LINKEDFOLDERID (self)
SYSID

DOCPROVIDERS_CURRENT | DOCPROVIDERID
External ID
DOCFOLDERS_CURRENT | DOCFOLDERID
USERS_CURRENT | USERID
Self
Not a relationship; used for internal application purposes

Milestone

MILE | Milestone

MILESTONES_CURRENT
MILESTONES_DAILY_HISTORY
MILESTONES_EVENT

LASTUPDATEDBYID
MILESTONEID
MILESTONEPATHID

USER_CURRENT | USERID
Self
MILESTONEPATH_CURRENT | MILESTONEID

MilestonePath

Milestone Path

MPATH | Milestone Path

MILESTONEPATHS_CURRENT
MILESTONEPATHS_DAILY_HISTORY
MILESTONEPATHS_EVENT

ENTEREDBYID
LASTUPDATEDBYID
MILESTONEPATHID

USER_CURRENT | USERID
USER_CURRENT | USERID
Self

NonLaborResource

Non-labor resource

NLBR | Non-labor resource

NONLABORRESOURCES_CURRENT
NONLABORRESOURCES_DAILY_HISTORY
NONLABORRESOURCES_EVENT

CATEGORYID
NONLABORRESOURCEID (self)
ENTEREDBYID
HOMEGROUPID
LASTUPDATEDBYID
NONLABORRESOURCECATEGORYID
SYSID

CATEGORIES_CURRENT | CATEGORYID
Self
USERS_CURRENT | USERID
GROUPS_CURRENT | GROUPID
USERS_CURRENT | USERID
Non-labor Resource Category table not supported currently
Not a relationship; used for internal application purposes

Non-Work Day

Schedule Exception

NONWKD | Non Work Day

NONWORKDAYS_CURRENT
NONWORKDAYS_DAILY_HISTORY
NONWORKDAYS_EVENT

NONWORKDAYID (self)
OBJID
SCHEDULEID
SYSID
USERID

Self
The ID of the object identified in the OBJCODE field
SCHEDULES_CURRENT | SCHEDULEID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID

Note

NOTE | Note

NOTES_CURRENT
NOTES_DAILY_HISTORY
NOTES_EVENT

ATTACHDOCUMENTID
ATTACHOBJID
ATTACHOPTASKID
ATTACHWORKID
ATTACHWORKUSERID
AUDITRECORDID
COMPANYID
DOCUMENTID
EXTERNALSERVICEID
ITERATIONID
NOTEID
OBJID
OPTASKID
OWNERID
PARENTENDORSEMENTID
PARENTJOURNALENTRYID
PARENTNOTEID
PORTFOLIOID
PROGRAMID
PROJECTID
PROOFACTIONID
PROOFID
RICHTEXTNOTEID
TASKID
TEMPLATEID
TEMPLATETASKID
THREADID
TIMESHEETID
TOPOBJID
USERID

DOCUMENT_CURRENT | DOCUMENTID
Variable depending on ATTACHOBJCODE
OPTASK_CURRENT | OPTASKID
WORKITEMS_CURRENT
USER_CURRENT | USERID
Audit Record table not supportd currently
COMPANIES_CURRENT | COMPANYID
DOCUMENT_CURRENT | DOCUMENTID
Not a Workfront relationship; used for integration to external systems
ITERATIONS_CURRENT | ITERATIONID
Self
Variable depending on the NOTEOBJCODE
OPTASK_CURRENT | OPTASKID
USER_CURRENT | USERID
Endorsement table not supported currently
JOURNALENTRIES_CURRENT | JOURNALENTRYID
NOTE_CURRENT | NOTEID
PORTFOLIO_CURRENT | PORTFOLIOID
PROGRAM_CURRENT | PROGRAMID
PROJECT_CURRENT | PROJECTID
Proof Action table not supported currently
Proof table not supported currently
RESERVEDTEXTNOTES_CURRENT | RICHTEXTNOTEID
TASK_CURRENT | TASKID
TEMPLATES_CURRENT | TEMPLATEID
TEMPLATETASKS_CURRENT | TEMPLATETASKID
NOTE_CURRENT | NOTEID
TIMESHEET_CURRENT | TIMESHEETID
Variable depending on TOPOBJCODE
USER_CURRENT | USERID

Object Integration

OBJINT | ObjectIntegration

OBJECTINTEGRATION_CURRENT
OBJECTINTEGRATION_DAILY_HISTORY
OBJECTINTEGRATION_EVENT

LINKEDOBJECTID
OBJECTINTEGRATIONID (self)
OBJID
SYSID

The ID of the object identified in the LINKEDOBJECTCODE field
Self
The ID of the object identified in the OBJCODE field
Not a relationship; used for internal application purposes

Objects Category

Object Categories

OBJCAT | Object Category

OBJECTSCATEGORIES_CURRENT
OBJECTSCATEGORIES_DAILY_HISTORY
OBJECTSCATEGORIES_EVENT

CATEGORYID
OBJECTSCATEGORYID (self)
OBJID
SYSID

CATEGORIES_CURRENT | CATEGORYID
Self
The ID of the object identified in the OBJCODE field
Not a relationship; used for internal application purposes

OpTask

Issue, Request

OPTASK | Issue

OPTASKS_CURRENT
OPTASKS_DAILY_HISTORY
OPTASKS_EVENT
OPTASKS_CUSTOM_VALUE_CURRENT
OPTASKS_CUSTOM_VALUE_DAILY_HISTORY
OPTASKS_CUSTOM_VALUE_EVENT

APPROVALPROCESSID
ASSIGNEDTOID
CATEGORYID
CURRENTAPPROVALSTEPID
ENTEREDBYID
EXCHANGERATEID
ITERATIONID
KANBANBOARDID
LASTCONDITIONNOTEID
LASTNOTEID
LASTUPDATEDBYID
OPTASKID
OWNERID
PROJECTID
QUEUEDEFID
QUEUETOPICID
RESOLVEOPTASKID
RESOLVEPROJECTID
RESOLVETASKID
RESOLVINGOBJID
ROLEID
SOURCEOBJID
SOURCETASKID
SUBMITTEDBYID
TEAMID

Parameter

Custom Field

PARAM | Parameter

PARAMETERS_CURRENT
PARAMETERS_DAILY_HISTORY
PARAMETERS_EVENT

LASTUPDATEDBYID
PARAMETERFILTERID
PARAMETERID (self)
SYSID

USERS_CURRENT | USERID
Parameter Filter table not supported currently
Self
Not a relationship; used for internal application purposes

Parameter Option

POPT | Parameter Option

PARAMETEROPTIONS_CURRENT
PARAMETEROPTIONS_DAILY_HISTORY
PARAMETEROPTIONS_EVENT

PARAMETERID
PARAMETEROPTIONID (self)
SYSID

PARAMETERS_CURRENT | PARAMETERID
Self
Not a relationship; used for internal application purposes

Portal Section

Report

PTLSEC | Report

PORTALSECTIONS_CURRENT
PORTALSECTIONS_DAILY_HISTORY
PORTALSECTIONS_EVENT

APPGLOBALID
ENTEREDBYID
FILTERID
GROUPBYID
LASTUPDATEDBYID
LASTVIEWEDBYID
OBJID
PORTALSECTIONID (self)
PREFERENCEID
PUBLICRUNASUSERID
REPORTFOLDERID
RUNASUSERID
SCHEDULEDREPORTID
SYSID
VIEWID

Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
UIFILTERS_CURRENT | FILTERID
UIGROUPBYS_CURRENT | GROUPBYID
USERS_CURRENT | USERID
USERS_CURRENT | USERID
The ID of the object identified in the OBJOBJCODE field
Self
PREFERENCES_CURRENT | PREFERENCEID
USERS_CURRENT | USERID
REPORTFOLDERS_CURRENT | REPORTFOLDERID
USERS_CURRENT | USERID
Scheduled Report table not supported currently
Not a relationship; used for internal application purposes
UIVIEWS_CURRENT | VIEWID

Portal Tab

Dashboard

PTLTAB | Dashboard

PORTALTABS_CURRENT
PORTALTABS_DAILY_HISTORY
PORTALTABS_EVENT

DOCID
LASTUPDATEDBYID
PORTALPROFILEID
PORTALTABID (self)
SYSID
USERID

Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Portal Profile table will not be supported
Self
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID

Portal Tab Section

Dashboard Section

PRTBSC | Portal Tab Section

PORTALTABSPORTALSECTIONS_CURRENT
PORTALTABSPORTALSECTIONS_DAILY_HISTORY
PORTALTABSPORTALSECTIONS_EVENT

CALENDARPORTALSECTIONID
EXTERNALSECTIONID
INTERNALSECTIONID
PORTALSECTIONOBJID
PORTALTABID
PORTALTABSECTIONID (self)
SYSID

Calendar Portal Section not supported currently
External Sections table not supported currently
PORTALSECTIONS_CURRENT | PORTALSECTIONID
The ID of the object identified in the PORTALSECTIONOBJCODE field
PORTALTABS_CURRENT | PORTALTABID
Self
Not a relationship; used for internal application purposes

PortalSectionLastViewer

Report Last Viewers

PLSLSV | PortalSectionLastViewer

REPORTLASTVIEWERS_CURRENT
REPORTLASTVIEWERS_DAILY_HISTORY
REPORTLASTVIEWERS_EVENT

REPORTID
REPORTLASTVIEWERID (self)
SYSID
VIEWERID

PORTALSECTIONS_CURRENT | PORTALSECTIONID
REPORTLASTVIEWERID (self)
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID

Portfolio

PORT | Portfolio

PORTFOLIOS_CURRENT
PORTFOLIOS_DAILY_HISTORY
PORTFOLIOS_EVENT
PORTFOLIOS_CUSTOM_VALUE_CURRENT
PORTFOLIOS_CUSTOM_VALUE_DAILY_HISTORY
PORTFOLIOS_CUSTOM_VALUE_EVENT

ALIGNMENTSCORECARDID
CATEGORYID
ENTEREDBYID
GROUPID
LASTUPDATEDBYID
OWNERID
PORTFOLIOID

Preference

View, Filter, Grouping, Report Definition

PROSET | Preference

PREFERENCES_CURRENT
PREFERENCES_DAILY_HISTORY
PREFERENCES_EVENT

APPGLOBALID
PREFERENCEID (self)
SYSID

Not a relationship; used for internal application purposes
Self
Not a relationship; used for internal application purposes

Program

PRGM | Program

PROGRAMS_CURRENT
PROGRAMS_DAILY_HISTORY
PROGRAMS_EVENT
PROGRAMS_CUSTOM_VALUE_CURRENT
PROGRAMS_CUSTOM_VALUE_DAILY_HISTORY
PROGRAMS_CUSTOM_VALUE_EVENT

CATEGORYID
ENTEREDBYID
GROUPID
LASTUPDATEDBYID
OWNERID
PORTFOLIOID
PROGRAMID

Project

PROJ | Project

PROJECTS_CURRENT
PROJECTS_DAILY_HISTORY
PROJECTS_EVENT
PROJECTS_CUSTOM_VALUE_CURRENT
PROJECTS_CUSTOM_VALUE_DAILY_HISTORY
PROJECTS_CUSTOM_VALUE_EVENT

AEMNATIVEFOLDERTREESREFID
ALIGNMENTSCORECARDID
APPROVALPROCESSID
ATTACHEDRATECARDID
CATEGORYID
COMPANYID
CONVERTEDOPTASKID
CONVERTEDOPTASKORIGINATORID
CURRENTAPPROVALSTEPID
DELIVERABLESCORECARDID
ENTEREDBYID
GROUPID
LASTCONDITIONNOTEID
LASTNOTEID
LASTUPDATEDBYID
MILESTONEPATHID
OWNERID
POPACCOUNTID
PORTFOLIOID
PRIVATERATECARDID
PROGRAMID
PROJECTID
QUEUEDEFID
REJECTIONISSUEID
RESOURCEPOOLID
SCHEDULEID
SPONSORID
SUBMITTEDBYID
TEAMID
TEMPLATEID

RateCard

Rate Card

RTCRD |Rate Card

RATECARD_CURRENT
RATECARD_DAILY_HISTORY
RATECARD_EVENT

CATEGORYID
ENTEREDBYID
LASTUPDATEDBYID
RATECARDID (self)
SECURITYROOTID
SOURCEID
SYSID

CATEGORYID
USERS_CURRENT | USERID
USERS_CURRENT | USERID
Self
The ID of the object identified in the SECURITYOBJCODE field
The ID of the object identified in the SOURCEOBJCODE field
Not a relationship; used for internal application purposes

Report Folder

RPTFDR | Report Folder

REPORTFOLDERS_CURRENT
REPORTFOLDERS_DAILY_HISTORY
REPORTFOLDERS_EVENT

REPORTFOLDERID (self)
SYSID

Self
Not a relationship; used for internal application purposes

Reserved Time

(Personal) Time Off

RESVT | Time Off

RESERVEDTIMES_CURRENT
RESERVEDTIMES_DAILY_HISTORY
RESERVEDTIMES_EVENT

RESERVEDTIMEID (self)
SYSID
TASKID
USERID

Self
Not a relationship; used for internal application purposes
TASKS_CURRENT | TASKID
USERS_CURRENT | USERID

Resource Pool

RSPL | Resource Pool

RSRCPOOLS_CURRENT
RSRCPOOLS_DAILY_HISTORY
RSRCPOOLS_EVENT

ENTEREDBYID
LASTUPDATEDBYID
RESOURCEPOOLID (self)
SYSID

USERS_CURRENT | USERID
USERS_CURRENT | USERID
Self
Not a relationship; used for internal application purposes

Rich Text Note

RHNOTE | Rich Text Note

RESERVEDTEXTNOTES_CURRENT
RESERVEDTEXTNOTES_DAILY_HISTORY
RESERVEDTEXTNOTES_EVENT

RICHTEXTNOTEID (self)
SYSID

Self
Not a relationship; used for internal application purposes

Rich Text Parameter Value

RCHVAL | RichTextParameterValue

RICHTEXTPARAMETERVALUES_CURRENT
RICHTEXTPARAMETERVALUES_DAILY_HISTORY
RICHTEXTPARAMETERVALUES_EVENT

PARAMETERVALUEID
RICHTEXTPARAMETERVALUEID (self)
SYSID

Paramter Value table not supported currently
Self
Not a relationship; used for internal application purposes

Risk

RISK | Risk

RISKS_CURRENT
RISKS_DAILY_HISTORY
RISKS_EVENT

ENTEREDBYID
EXCHANGERATEID
LASTUPDATEDBYID
PROJECTID
RISKID (self)
RISKTYPEID
SYSID
TEMPLATEID

Risk Type

RSKTYP | Risk Type

RISKTYPES_CURRENT
RISKTYPES_DAILY_HISTORY
RISKTYPES_EVENT

RISKTYPEID
SYSID

Self
Not a relationship; used for internal application purposes

Role

Job Role

ROLE | Job Role

ROLES_CURRENT
ROLES_DAILY_HISTORY
ROLES_EVENT

ENTEREDBYID
LAYOUTTEMPLATEID
PRIVATERATECARDID
ROLEID
UITEMPLATEID

USER_CURRENT | USERID
Layout Template table will not be supported
RATECARD_CURRENT | RATECARDID
Self
UITEMPLATES_CURRENT |UITEMPLATEID

Schedule

SCHED | Schedule

SCHEDULES_CURRENT
SCHEDULES_DAILY_HISTORY
SCHEDULES_EVENT

ENTEREDBYID
GROUPID
HOMEGROUPID
SCHEDULEID

USER_CURRENT | USERID
GROUP_CURRENT | GROUPID
GROUP_CURRENT | GROUPID
Self

Step Approver

SPAPVR | Stage Approver

STEPAPPROVERS_CURRENT
STEPAPPROVERS_DAILY_HISTORY
STEPAPPROVERS_EVENT

APPROVALSTEPID
ROLEID
STEPAPPROVERID (self)
SYSID
TEAMID
USERID

APPROVALSTEPS_CURRENT | APPROVALSTEPID
ROLES_CURRENT | ROLEID
Self
Not a relationship; used for internal application purposes
TEAMS_CURRENT | TEAMID
USERS_CURRENT | USERID

Task

TASK | Task

TASKS_CURRENT
TASKS_DAILY_HISTORY
TASKS_EVENT
TASKS_CUSTOM_VALUE_CURRENT
TASKS_CUSTOM_VALUE_DAILY_HISTORY
TASKS_CUSTOM_VALUE_EVENT

APPROVALPROCESSID
ASSIGNEDTOID
BILLINGRECORDID
CATEGORYID
CONVERTEDOPTASKID
CONVERTEDOPTASKORIGINATORID
CURRENTAPPROVALSTEPID
ENTEREDBYID
EXCHANGERATEID
GROUPID
ITERATIONID
KANBANBOARDID
LASTCONDITIONNOTEID
LASTNOTEID
LASTUPDATEDBYID
MILESTONEID
PARENTID
PROJECTID
RECURRENCERULEID
REJECTIONISSUEID
RESERVEDTIMEID
ROLEID
SUBMITTEDBYID
TASKID
TEAMID
TEMPLATETASKID

Task Predecessor

Predecessor

PRED | Predecessor

PREDECESSORS_CURRENT
PREDECESSORS_DAILY_HISTORY
PREDECESSORS_EVENT

ID (self)
PREDECESSORID
SUCCESSORID
SYSID

Self
TASKS_CURRENT | TASKID
TASKS_CURRENT | TASKID
Not a relationship; used for internal application purposes

Team

TEAMOB | Team

TEAMS_CURRENT
TEAMS_DAILY_HISTORY
TEAMS_EVENT

ENTEREDBYID
GROUPID
LAYOUTTEMPLATEID
MYWORKVIEWID
OWNERID
REQUESTSVIEWID
SCHEDULEID
TEAMID
UITEMPLATEID

Team Member

Other Teams, Team Member

TEAMMB | Team Member

TEAMMEMBERS_CURRENT
TEAMMEMBERS_DAILY_HISTORY
TEAMMEMBERS_EVENT

SYSID
TEAMID
TEAMMEMBERID (self)
USERID

Not a relationship; used for internal application purposes
TEAMS_CURRENT | TEAMID
Self
USERS_CURRENT | USERID

TeamMemberRole

Team Member Role

TEAMMR | Team Member Role

TEAMMEMBERROLES_CURRENT
TEAMMEMBERROLES_DAILY_HISTORY
TEAMMEMBERROLES_EVENT

ROLEID
TEAMID
TEAMMEMBERROLEID (self)
USERID

ROLES_CURRENT | ROLEID
TEAMS_CURRENT | TEAMID
Self
USERS_CURRENT | USERID

Template

TMPL | Template

TEMPLATES_CURRENT
TEMPLATES_DAILY_HISTORY
TEMPLATES_EVENT

APPROVALPROCESSID
CATEGORYID
COMPANYID
DELIVERABLESCORECARDID
ENTEREDBYID
GROUPID
LASTNOTEID
LASTUPDATEDBYID
MILESTONEPATHID
OWNERID
PRIVATERATECARDID
PROGRAMID
QUEUEDEFID
SCHEDULEID
SYSID
TEAMID
TEMPLATEID (self)

Template Assignment

TASSGN | Template Assignment

TEMPLATEASSIGNMENTS_CURRENT
TEMPLATEASSIGNMENTS_DAILY_HISTORY
TEMPLATEASSIGNMENTS_EVENT

ASSIGNEDTOID
CATEGORYID
LASTUPDATEDBYID
OBJID
ROLEID
SYSID
TEAMID
TEAMTIMELINEABLEID
TEMPLATEASSIGNMENTID (self)
TEMPLATETASKID

USERS_CURRENT | USERID
CATEGORIES_CURRENT | CATEGORYID
USERS_CURRENT | USERID
The ID of the object identified in the OBJCODE field
ROLES_CURRENT | ROLEID
Not a relationship; used for internal application purposes
TEAMS_CURRENT | TEAMID
Team Timelineable table not supported currently
Self
TEMPLATETASKS_CURRENT |TEMPLATETASKID

Template Task

TTSK | Template Task

TEMPLATETASKS_CURRENT
TEMPLATETASKS_DAILY_HISTORY
TEMPLATETASKS_EVENT

APPROVALPROCESSID
ASSIGNEDTOID
CATEGORYID
ENTEREDBYID
EXCHANGERATEID
LASTNOTEID
LASTUPDATEDBYID
MILESTONEID
PARENTID
RECURRENCERULEID
ROLEID
SYSID
TEAMID
TEAMTIMELINEABLEID
TEMPLATEID
TEMPLATETASKID (self)

Template Task Predecessor

Template Predecessor

TPRED | Predecessor

TEMPLATEPREDECESSORS_CURRENT
TEMPLATEPREDECESSORS_DAILY_HISTORY
TEMPLATEPREDECESSORS_EVENT

PREDECESSORID
SUCCESSORID
TEMPLATEPREDECESSORID (self)
SYSID

TEMPLATETASKS_CURRENT |TEMPLATETASKID
TEMPLATETASKS_CURRENT |TEMPLATETASKID
Self
Not a relationship; used for internal application purposes

Timesheet

TSHET | Timesheet

TIMESHEETS_CURRENT
TIMESHEETS_DAILY_HISTORY
TIMESHEETS_EVENT

APPROVERID
LASTNOTEID
LASTUPDATEDBYID
TIMESHEETID
TIMESHEETPROFILEID
USERID

Timesheet Profile

TSPRO | Timesheet Profile

TIMESHEETPROFILES_CURRENT
TIMESHEETPROFILES_DAILY_HISTORY
TIMESHEETPROFILES_EVENT

APPROVERID
ENTEREDBYID
GROUPID
SYSID
TIMESHEETPROFILEID (self)

USERS_CURRENT | USERID
USERS_CURRENT | USERID
GROUPS_CURRENT | GROUPID
Not a relationship; used for internal application purposes
Self

UI Filter

Filter

UIFT | Filter

UIFILTERS_CURRENT
UIFILTERS_DAILY_HISTORY
UIFILTERS_EVENT

APPGLOBALID
ENTEREDBYID
LASTUPDATEDBYID
OBJID
PREFERENCEID
SYSID
UIFILTERID (self)

Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
USERS_CURRENT | USERID
The ID of the object identified in the OBJCODE field
PREFERENCES_CURRENT | PREFERENCEID
Not a relationship; used for internal application purposes
Self

UI Group By

Grouping

UIGB | Grouping

UIGROUPBYS_CURRENT
UIGROUPBYS_DAILY_HISTORY
UIGROUPBYS_EVENT

ENTEREDBYID
GROUPID
LASTUPDATEDBYID
SYSID
UITEMPLATEID (self)

USERS_CURRENT | USERID
GROUPS_CURRENT | GROUPID
USERS_CURRENT | USERID
Not a relationship; used for internal application purposes
Self

UI Template

Layout Template

UITMPL | Layout Template

UITEMPLATES_CURRENT
UITEMPLATES_DAILY_HISTORY
UITEMPLATES_EVENT

APPGLOBALID
ENTEREDBYID
LASTUPDATEDBYID
OBJID
PREFERENCEID
SYSID
UIGROUPBYID (self)

UI View

View

UIVIEW | View

UIVIEWS_CURRENT
UIVIEWS_DAILY_HISTORY
UIVIEWS_EVENT

APPGLOBALID
ENTEREDBYID
LASTUPDATEDBYID
OBJID
PREFERENCEID
SYSID
UIVIEWID (self)

User

USER | User

USERS_CURRENT
USERS_DAILY_HISTORY
USERS_EVENT
USERS_CUSTOM_VALUE_CURRENT
USERS_CUSTOM_VALUE_DAILY_HISTORY
USERS_CUSTOM_VALUE_EVENT

ACCESSLEVELID
CATEGORYID
COMPANYID
DEFAULTHOURTYPEID
DELEGATIONTOID
EAUTHUSERID
ENTEREDBYID
HOMEGROUPID
HOMETEAMID
LASTENTEREDNOTEID
LASTUPDATEDBYID
LATESTUPDATENOTEID
LAYOUTTEMPLATEID
MANAGERID
PORTALPROFILEID
PREFUIID
PRIVATERATECARDID
RESOURCEPOOLID
ROLEID
SCHEDULEID
TIMESHEETPROFILEID
UITEMPLATEID
USERID
UUMUSERID

User Delegation

USRDEL | User Delegation

USERDELEGATIONS_CURRENT
USERDELEGATIONS_DAILY_HISTORY
USERDELEGATIONS_EVENT

FROMUSERID
SYSID
TOUSERID
USERDELEGATIONID (self)

USERS_CURRENT | USERID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Self

User Group

Other Groups

USRGPS | User Group

USERSGROUPS_CURRENT
USERSGROUPS_DAILY_HISTORY
USERSGROUPS_EVENT

GROUPID
SYSID
USERID
USERSGROUPID (self)

GROUPS_CURRENT | GROUPID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Self

User Role

Other Roles

USRROL | User Role

USERSROLES_CURRENT
USERSROLES_DAILY_HISTORY
USERSROLES_EVENT

ROLEID
SYSID
USERID
USERROLESETID
USERSROLEID (self)

ROLES_CURRENT | ROLEID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
USERROLESET_CURRENT | USERROLESETID
Self

UserPrefValue

USERPF | User Preference

USERPREFVALUES_CURRENT
USERPREFVALUES_DAILY_HISTORY
USERPREFVALUES_EVENT

SYSID
USERID
USERPREFVALUEID (self)

Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Self

UserRoleSet

URSET | UserRoleSet

USERROLESET_CURRENT
USERROLESET_DAILY_HISTORY
USERROLESET_EVENT

PRIMARYROLEID
SYSID
USERID
USERROLESETID (self)

ROLES_CURRENT | ROLEID
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID
Self

UsersDecisions

Users Decisions

USRDEC | Users Decisions

USERSDECISIONS_CURRENT
USERSDECISIONS_DAILY_HISTORY
USERSDECISIONS_EVENT

USERDECISIONID (self)
SYSID
USERID

Self
Not a relationship; used for internal application purposes
USERS_CURRENT | USERID

WorkItem

Work Item

WRKITM | WorkItem

WORKITEMS_CURRENT
WORKITEMS_DAILY_HISTORY
WORKITEMS_EVENT

ASSIGNMENTID
OBJID
OPTASKID
PROJECTID
SYSID
TASKID
USERID
WORKITEMID (self)

recommendation-more-help

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43