Workfront Data Connect data dictionary
This page contains information about the structure and content of the data in Workfront Data Connect.
NOTEThe 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:
IMPORTANTThe 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 inCALENDAR_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 onBEGIN_EFFECTIVE_TIMESTAMPandEND_EFFECTIVE_TIMESTAMPthis 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_TIMESTAMPwill 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 | 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 | Share | 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 | 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 | 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 | 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 | Self The ID of the object identified in the APPROVABLEOBJCODE field APPROVALSTEPS_CURRENT | APPROVALSTEPID USERS_CURRENT | USERID USERS_CURRENT | USERID USERS_CURRENT | USERID OPTASKS_CURRENT | OPTASKID USERS_CURRENT | USERID PROJECTS_CURRENT | PROJECTID USERS_CURRENT | USERID Not a relationship; used for internal application purposes TASKS_CURRENT | TASKID USERS_CURRENT | USERID |
| Assignment | Assignment | ASSGN | Assignment | ASSIGNMENTS_CURRENT ASSIGNMENTS_DAILY_HISTORY ASSIGNMENTS_EVENT | ASSIGNEDBYID ASSIGNEDTOID ASSIGNMENTID (self) CATEGORYID CLASSIFIERID OPTASKID PRIVATERATECARDID PROJECTID ROLEID TASKID TEAMID | USER_CURRENT | USERID USER_CURRENT | USERID Self CATEGORIES_CURRENT | CATEGORYID Classifier table not supported currently OPTASK_CURRENT | OPTASKID RATECARD_CURRENT | RATECARDID PROJECT_CURRENT | PROJECTID ROLE_CURRENT | ROLEID TASK_CURRENT | TASKID TEAM_CURRENT | TEAMID |
| Awaiting Approvals | 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 | Access Request table not supported currently Not a relationship; used for internal application purposes USERS_CURRENT | USERID Self DOCUMENTS_CURRENT | DOCUMENTID DOCUMENTVERSIONS_CURRENT | DOCUMENTVERSIONID OPTASKS_CURRENT | OPTASKID PROJECTS_CURRENT | PROJECTID ROLES_CURRENT | ROLEID USERS_CURRENT | USERID Not a relationship; used for internal application purposes TASKS_CURRENT | TASKID TEAMS_CURRENT | TEAMID TIMESHEETS_CURRENT | TIMESHEETID USERS_CURRENT | USERID |
| Baseline | 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 | 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 | 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 | 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 |
| Business Profile | Business Profile | BSNPRF | BusinessProfile | BUSINESSPROFILE_CURRENT BUSINESSPROFILE_DAILY_HISTORY BUSINESSPROFILE_EVENT | ACCESSLEVELID BUSINESSPROFILEID (self) ENTEREDBYID GROUPID LASTUPDATEDBYID SYSID | ACCESSLEVELS_CURRENT | ACCESSLEVELID Self USERS_CURRENT | USERID GROUPS_CURRENT | GROUPID USERS_CURRENT | USERID Not a relationship; used for internal application purposes |
| Business Rule | Business Rule | BSNRUL | Business Rule | BUSINESSRULE_CURRENT BUSINESSRULE_DAILY_HISTORY BUSINESSRULE_EVENT | BUSINESSRULEID (self) ENTEREDBYID LASTUPDATEDBYID SYSID | Self USERS_CURRENT | USERID USERS_CURRENT | USERID Not a relationship; used for internal application purposes |
| 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 |
| Classifier | Location | CLSF | Location | CLASSIFIER_CURRENT CLASSIFIER_DAILY_HISTORY CLASSIFIER_EVENT | CLASSIFIERID (self) ENTEREDBYID LASTUPDATEDBYID PARENTID SYSID | Self USERS_CURRENT | USERID USERS_CURRENT | USERID CLASSIFIER_CURRENT | CLASSIFIERID Not a relationship; used for internal application purposes |
| Company | Company | CMPY | Company | COMPANIES_CURRENT COMPANIES_DAILY_HISTORY COMPANIES_EVENT | CATEGORYID COMPANYID (self) ENTEREDBYID GROUPID LASTUPDATEDBYID PRIVATERATECARDID SYSID | CATEGORIES_CURRENT | CATEGORYID Self USERS_CURRENT | USERID GROUPS_CURRENT | GROUPID USERS_CURRENT | USERID RATECARD_CURRENT | RATECARDID Not a relationship; used for internal application purposes |
| Custom Quarter | 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 | 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 | CATEGORIES_CURRENT | CATEGORYID USER_CURRENT | USERID Self Document Request table not supported currently EXCHANGERATES_CURRENT | EXCHANGERATEID ITERATIONS_CURRENT | ITERATIONID NOTE_CURRENT | NOTEID USER_CURRENT | USERID NOTE_CURRENT | NOTEID Varibale depending on DOCOBJCODE value OPTASK_CURRENT | OPTASKID USER_CURRENT | USERID PORTFOLIO_CURRENT | PORTFOLIOID PROGRAM_CURRENT | PROGRAMID PROJECT_CURRENT | PROJECTID Release Version table not supported currently TASK_CURRENT | TASKID TEMPLATES_CURRENT | TEMPLATEID TEMPLATETASKS_CURRENT | TEMPLATETASKID Varibale depending on TOPOBJCODE value USER_CURRENT | USERID |
| Document Approval | 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 | 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 | Self USERS_CURRENT | USERID OPTASKS_CURRENT | OPTASKID ITERATIONS_CURRENT | ITERATIONID LINKEDFOLDERS_CURRENT | LINKEDFOLDERID DOCFOLDERS_CURRENT | DOCFOLDERID PORTFOLIO_CURRENT | PORTFOLIOID PROGRAM_CURRENT | PROGRAMID PROJECTS_CURRENT | PROJECTID Not a relationship; used for internal application purposes TASKS_CURRENT | TASKID TEMPLATES_CURRENT | TEMPLATEID TEMPLATETASKS_CURRENT | TEMPLATETASKID USERS_CURRENT | 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 | 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 | 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 | 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 | Group | GROUPS_CURRENT GROUPS_DAILY_HISTORY GROUPS_EVENT | BUSINESSLEADERID CATEGORYID ENTEREDBYID GROUPID LAYOUTTEMPLATEID PARENTID ROOTID UITEMPLATEID | USER_CURRENT | USERID CATEGORIES_CURRENT | CATEGORYID USER_CURRENT | USERID Self Layout Template table will not be supported GROUP_CURRENT | GROUPID GROUP_CURRENT | GROUPID UITEMPLATES_CURRENT | UITEMPLATEID |
| Hour | 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 | 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 | Iteration | ITRN | Iteration | ITERATIONS_CURRENT ITERATIONS_DAILY_HISTORY ITERATIONS_EVENT | CATEGORYID ENTEREDBYID ITERATIONID (self) LASTUPDATEDBYID OWNERID SYSID TEAMID | CATEGORIES_CURRENT | CATEGORYID USERS_CURRENT | USERID Self USERS_CURRENT | USERID USERS_CURRENT | USERID Not a relationship; used for internal application purposes TEAMS_CURRENT | TEAMID |
| Journal Entry | 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 | 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 | 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-Labor Resource Category | Non-Labor Resource Category | NLBRCY | Non-labor resource category | NLBRCATEGORIES_CURRENT NLBRCATEGORIES_DAILY_HISTORY NLBRCATEGORIES_EVENT | CATEGORYID ENTEREDBYID LASTUPDATEDBYID NLBRCATEGORYID (self) PRIVATERATECARDID SCHEDULEID SYSID | CATEGORIES_CURRENT | CATEGORYID USERS_CURRENT | USERID USERS_CURRENT | USERID Self RATECARD_CURRENT | RATECARDID USERS_CURRENT | USERID 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 | 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 | 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 | APPROVALPROCESSES_CURRENT | APPROVALPROCESSID USER_CURRENT | USERID CATEGORIES_CURRENT | CATEGORYID APPROVALSTEPS_CURRENT | APPROVALSTEPID USER_CURRENT | USERID EXCHANGERATES_CURRENT | EXCHANGERATEID ITERATIONS_CURRENT | ITERATIONID Kanban Board table not supported currently NOTE_CURRENT | NOTEID NOTE_CURRENT | NOTEID USER_CURRENT | USERID Self USER_CURRENT | USERID PROJECT_CURRENT | PROJECTID Queue Definition table not supported currently Queue Topic table not supported currently OPTASK_CURRENT | OPTASKID PROJECT_CURRENT | PROJECTID TASK_CURRENT | TASKID Variable depending on RESOLVINGOBJCODE ROLE_CURRENT | ROLEID Variable depending on SOURCEOBJCODE TASK_CURRENT | TASKID USER_CURRENT | USERID TEAM_CURRENT | 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 | 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 | 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 | Scorecard table not supported currently CATEGORIES_CURRENT | CATEGORYID USER_CURRENT | USERID GROUP_CURRENT | GROUPID USER_CURRENT | USERID USER_CURRENT | USERID Self |
| 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 | 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 | CATEGORIES_CURRENT | CATEGORYID USER_CURRENT | USERID GROUP_CURRENT | GROUPID USER_CURRENT | USERID USER_CURRENT | USERID PORTFOLIO_CURRENT | PORTFOLIOID Self |
| Project | 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 | Not a Workfront relationship; used for integration to external systems Scorecard table not supported currently APPROVALPROCESSES_CURRENT | APPROVALPROCESSID RATECARD_CURRENT | RATECARDID CATEGORIES_CURRENT | CATEGORYID COMPANIES_CURRENT | COMPANYID OPTASK_CURRENT | OPTASKID USER_CURRENT | USERID APPROVALSTEPS_CURRENT | APPROVALSTEPID Scorecard table not supported currently USER_CURRENT | USERID GROUP_CURRENT | GROUPID NOTE_CURRENT | NOTEID NOTE_CURRENT | NOTEID USER_CURRENT | USERID MILESTONEPATH_CURRENT | MILESTONEPATHID USER_CURRENT | USERID Pop Account table not supported currently PORTFOLIO_CURRENT | PORTFOLIOID RATECARD_CURRENT | RATECARDID PROGRAM_CURRENT | PROGRAMID Self Queue Definition table not supported currently OPTASK_CURRENT | OPTASKID RESOURCEPOOLS_CURRENT | RESOURCEPOOLID SCHEDULE_CURRENT | SCHEDULEID USER_CURRENT | USERID USER_CURRENT | USERID TEAM_CURRENT | TEAMID TEMPLATES_CURRENT | TEMPLATEID |
| Project Team User | Project Team User | PRTU | Project User | PROJECTSUSERS_CURRENT PROJECTSUSERS_DAILY_HISTORY PROJECTSUSERS_EVENT | PROJECTID PROJECTSUSERID (self) SYSID TMPUSERID USERID | PROJECTS_CURRENT | PROJECTID Self Not a relationship; used for internal application purposes TEMPLATES_CURRENT | TEMPLATEID USERS_CURRENT | USERID |
| Project Team User Role | Project Team User Role | PTEAM | ProjectUserRole | PROJECTSUSERSROLES_CURRENT PROJECTSUSERSROLES_DAILY_HISTORY PROJECTSUSERSROLES_EVENT | PROJECTID PROJECTSUSERSROLEID (self) ROLEID SYSID USERID | PROJECTS_CURRENT | PROJECTID Self ROLES_CURRENT | ROLEID Not a relationship; used for internal application purposes USERS_CURRENT | USERID |
| 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 | Report Folder | RPTFDR | Report Folder | REPORTFOLDERS_CURRENT REPORTFOLDERS_DAILY_HISTORY REPORTFOLDERS_EVENT | REPORTFOLDERID (self) SYSID | Self Not a relationship; used for internal application purposes |
| Report View Statistic Count | Report View Statistic Count | PLSVST | PortalSectionStatisticInfo | REPORTVIEWSTATISTICCOUNTS_CURRENT REPORTVIEWSTATISTICCOUNTS_DAILY_HISTORY REPORTVIEWSTATISTICCOUNTS_EVENT | REPORTID REPORTVIEWSTATISTICCOUNTID (self) SYSID | PORTALSECTIONS_CURRENT | PORTALSECTIONID Self Not a relationship; used for internal application purposes |
| Reportable Budgeted Hours | Reportable Budgeted Hours | RPBGHR | Budgeted Hour | REPORTABLEBUDGETEDHOURS_CURRENT REPORTABLEBUDGETEDHOURS_DAILY_HISTORY REPORTABLEBUDGETEDHOURS_EVENT | PROJECTID REPORTABLEBUDGETEDHOURID (self) ROLEID SYSID USERID | PROJECTS_CURRENT | PROJECTID Self ROLES_CURRENT | ROLEID Not a relationship; used for internal application purposes USERS_CURRENT | USERID |
| 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 Manager | Resource Manager | RESMGR | Resource Manager | RESOURCEMANAGERS_CURRENT RESOURCEMANAGERS_DAILY_HISTORY RESOURCEMANAGERS_EVENT | ID (self) PROJECTID RESOURCEMANAGERID SYSID TEMPLATEID | Self PROJECTS_CURRENT | PROJECTID USERS_CURRENT | USERID Not a relationship; used for internal application purposes TEMPLATES_CURRENT | TEMPLATEID |
| Resource Pool | 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 | 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 | 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 | Risk | RISKS_CURRENT RISKS_DAILY_HISTORY RISKS_EVENT | ENTEREDBYID EXCHANGERATEID LASTUPDATEDBYID PROJECTID RISKID (self) RISKTYPEID SYSID TEMPLATEID | USERS_CURRENT | USERID EXCHANGERATES_CURRENT | EXCHANGERATEID USERS_CURRENT | USERID PROJECTS_CURRENT | PROJECTID Self RISKTYPES_CURRENT | RISKTYPEID Not a relationship; used for internal application purposes TEMPLATES_CURRENT | TEMPLATEID |
| Risk Type | 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 | 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 | 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 | 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 | APPROVALPROCESSES_CURRENT | APPROVALPROCESSID USER_CURRENT | USERID BILLINGRECORDS_CURRENT | BILLINGRECORDID CATEGORIES_CURRENT | CATEGORYID OPTASK_CURRENT | OPTASKID USER_CURRENT | USERID APPROVALSTEPS_CURRENT | APPROVALSTEPID USER_CURRENT | USERID EXCHANGERATES_CURRENT | EXCHANGERATEID GROUP_CURRENT | GROUPID ITERATIONS_CURRENT | ITERATIONID Kanban Board table not supported currently NOTE_CURRENT | NOTEID NOTE_CURRENT | NOTEID USER_CURRENT | USERID MILESTONE_CURRENT | MILESTONEID TASK_CURRENT | TASKID PROJECT_CURRENT | PROJECTID Recurrence Rule table not supported currently OPTASK_CURRENT | OPTASKID RESERVEDTIMES_CURRENT | RESERVEDTIMEID ROLE_CURRENT | ROLEID USER_CURRENT | USERID Self TEAM_CURRENT | TEAMID TEMPLATETASKS_CURRENT | 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 | Team | TEAMOB | Team | TEAMS_CURRENT TEAMS_DAILY_HISTORY TEAMS_EVENT | ENTEREDBYID GROUPID LAYOUTTEMPLATEID MYWORKVIEWID OWNERID REQUESTSVIEWID SCHEDULEID TEAMID UITEMPLATEID | USER_CURRENT | USERID GROUP_CURRENT | GROUPID Layout Template table will not be supported UIVIEWS_CURRENT | UIVIEWID USER_CURRENT | USERID UIVIEWS_CURRENT | UIVIEWID SCHEDULE_CURRENT | SCHEDULEID Self UITEMPLATES_CURRENT |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 | 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) | APPROVALPROCESSES_CURRENT | APPROVALPROCESSID CATEGORIES_CURRENT | CATEGORYID COMPANIES_CURRENT | COMPANYID DELIVERABLESCORECARDID USERS_CURRENT | USERID GROUPS_CURRENT | GROUPID NOTES_CURRENT | NOTEID USERS_CURRENT | USERID MILESTONEPATH_CURRENT | MILESTONEPATHID USERS_CURRENT | USERID RATECARD_CURRENT | RATECARDID PROGRAM_CURRENT | PROGRAMID Queue Definition table not supported currently SCHEDULES_CURRENT | SCHEDULEID Not a relationship; used for internal application purposes TEAMS_CURRENT | TEAMID Self |
| Template Assignment | 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 | 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) | APPROVALPROCESSES_CURRENT | APPROVALPROCESSID USERS_CURRENT | USERID CATEGORIES_CURRENT | CATEGORYID USERS_CURRENT | USERID EXCHANGERATES_CURRENT | EXCHANGERATEID NOTES_CURRENT | NOTEID USERS_CURRENT | USERID MILESTONE_CURRENT | MILESTONEID TEMPLATETASKS_CURRENT |TEMPLATETASKID Recurrence Rule table not supported currently ROLES_CURRENT | ROLEID Not a relationship; used for internal application purposes TEAMS_CURRENT | TEAMID Team Timelineable table not supported currently TEMPLATES_CURRENT | TEMPLATEID 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 | Timesheet | TSHET | Timesheet | TIMESHEETS_CURRENT TIMESHEETS_DAILY_HISTORY TIMESHEETS_EVENT | APPROVERID LASTNOTEID LASTUPDATEDBYID TIMESHEETID TIMESHEETPROFILEID USERID | USER_CURRENT | USERID NOTE_CURRENT | NOTEID USER_CURRENT | USERID Self TIMESHEETPROFILES_CURRENT | TIMESHEETPROFILEID USER_CURRENT | USERID |
| Timesheet Profile | 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) | 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 View | View | UIVIEW | View | UIVIEWS_CURRENT UIVIEWS_DAILY_HISTORY UIVIEWS_EVENT | APPGLOBALID ENTEREDBYID LASTUPDATEDBYID OBJID PREFERENCEID SYSID UIVIEWID (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 |
| User | 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 | ACCESSLEVELS_CURRENT |ACCESSLEVELID CATEGORIES_CURRENT | CATEGORYID COMPANIES_CURRENT | COMPANYID HOURTYPE_CURRENT | HOURTYPEID USER_CURRENT | USERID Not a relationship; used for internal application purposes USER_CURRENT | USERID GROUP_CURRENT | GROUPID TEAM_CURRENT | TEAMID NOTE_CURRENT | NOTEID USER_CURRENT | USERID NOTE_CURRENT | NOTEID Layout Template table will not be supported USER_CURRENT | USERID Portal Profile table will not be supported Not a relationship; used for internal application purposes RATECARD_CURRENT | RATECARDID RESOURCEPOOLS_CURRENT | RESOURCEPOOLID ROLE_CURRENT | ROLEID SCHEDULE_CURRENT | SCHEDULEID TIMESHEETPROFILES_CURRENT | TIMESHEETPROFILEID UITEMPLATES_CURRENT |UITEMPLATEID Self Not a relationship; used for internal application purposes |
| User Delegation | 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 Location | User Location | USRLOC | UserLocation | USERLOCATIONS_CURRENT USERLOCATIONS_DAILY_HISTORY USERLOCATIONS_EVENT | CLASSIFIERID SYSID USERID USERLOCATIONID (self) | CLASSIFIER_CURRENT | CLASSIFIERID 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 | 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 | 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) | ASSIGNMENTS_CURRENT | ASSIGNMENTID The ID of the object identified in the OBJOBJCODE field OPTASK_CURRENT | OPTASKID PROJECTS_CURRENT | PROJECTID Not a relationship; used for internal application purposes TASKS_CURRENT | TASKID USERS_CURRENT | USERID Self |
Previous pageEstablish a connection to Workfront Data Connect
Next pageWorkfront Data Connect query examples
Workfront
- Workfront documentation
- Product announcements
- Administration and setup
- Adobe Workfront basics
- Agile
- Documents
- Manage Work
- Teams and groups
- Reporting
- Manage resources
- Review and approve work
- Timesheets
- Adobe Workfront Scenario Planner
- Adobe Workfront Goals
- Adobe Workfront Planning
- Adobe Workfront Integrations
- Workfront Proof
- Adobe Workfront API
- ProofHQ API
Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action
Workfront
Tuesday, Mar 4, 6:00 PM UTC
Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.
RegisterThe Perfect Blend: A New Era of Collaboration with AEM and Workfront
Adobe Customer Success Webinars
Wednesday, Apr 2, 5:00 PM UTC
Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.
Register
B2B Reimagined: Transforming Go-to-Market Strategies for Profitable Growth
Online | Strategy Keynote | General Audience
B2B brands are facing a digital revolution. Buyers expect hyper-relevant content and self-service, while internally AI is transforming...
Wed, Mar 19, 1:00 PM PDT (8:00 PM UTC)
Driving Marketing Agility and Scale: Transforming your Content Supply Chain with AI
Online | Strategy Keynote | General Audience
Marketers everywhere are feeling the pressure to deliver impactful campaigns faster and at greater scale. This Strategy Keynote explores...
Tue, Mar 18, 2:30 PM PDT (9:30 PM UTC)
Connect with Experience League at Summit!
Get front-row access to top sessions, hands-on activities, and networking—wherever you are!
Learn moreRegister to learn something new
WORKFRONT
Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.
Register