Workfront Data Connect data dictionary

Last update: June 28, 2026

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 4 hours, so recent changes might not be immediately reflected.

View types

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

Current view

The Current view 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 view

The Event view 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 view is useful for point-in-time comparisons. This view only includes records from the past three years.
Daily History view

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

Entity relationship diagrams

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 diagrams (ERDs) below provide a high-level mapping of object relationships in Data Connect for core Workfront objects.

IMPORTANT

The diagrams are centered around single objects and do not represent a complete entity relationship diagram for the entire Workfront application.

These diagrams are meant to provide examples of how the relationships can be used to join data to adjacent objects.

Example entity relationship diagrams

Expand to view the example diagrams

note tip
TIP
To view a diagram in more detail, right-click on the image and select Open image in new tab.

Assignments

Assignments entity relationship diagram

Documents and document approvals

Documents and document approval entity relationship diagram

Hours and Timesheets

Hours and Timesheets entity relationship diagram

Issues

Issues entity relationship diagram

Projects

Projects entity relationship diagram

Tasks

Tasks entity relationship diagram

Users

Users entity relationship diagram

Date types

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

DL_LOAD_TIMESTAMP: This date is updated after a successful data refresh is completed and includes the timestamp of when the refresh job that supplied the latest version of a record began.
CALENDAR_DATE: This date is present only in the Daily History view. The Daily History view 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 views, and represents the time that a record becomes the current value in the application.
END_EFFECTIVE_TIMESTAMP: This date is present in both Event and Daily History views, 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 value is never null, even if there is no new value. In the event a record is still valid (meaning that the value has not changed), END_EFFECTIVE_TIMESTAMP will have a value of 2300-01-01.

Workfront terminology table and descriptions

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, and includes reference fields for each object to other Workfront objects.

NOTE

New fields may be added to the object views without advanced notice to support the evolving data needs of the Workfront application. We caution against using “SELECT” queries where the downstream data recipient isn’t prepared to handle additional columns as they are added.

If renaming or removing a column is required, we will provide advance notice of these changes.

Access Level

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Access Level

ACSLVL

Access Level

ACCESSLEVELS_CURRENT
ACCESSLEVELS_DAILY_HISTORY
ACCESSLEVELS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ACCESSLEVELID

APPGLOBALID

Not a relationship; used for internal application purposes

LASTUPDATEDBYID

USERS_CURRENT

USERID

LEGACYACCESSLEVELID

Not a relationship; used for internal application purposes

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SYSID

Not a relationship; used for internal application purposes

Access Rule

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Access Rule

ACSRUL

ACCESSRULES_CURRENT
ACCESSRULES_DAILY_HISTORY
ACCESSRULES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ACCESSORID

Variable, based on ACCESSOROBJCODE

The primary key / ID of the object identified in the ACCESSOROBJCODE field

ACCESSRULEID

ANCESTORID

Variable, based on ANCESTOROBJCODE

The primary key / ID of the object identified in the ANCESTOROBJCODE field

LASTUPDATEDBYID

USERS_CURRENT

USERID

SECURITYOBJID

Variable, based on SECURITYOBJCODE

The primary key / ID of the object identified in the SECURITYOBJCODE field

SYSID

Not a relationship; used for internal application purposes

Approval Path

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Approval Path

ARVPTH

Approval

APPROVALPATHS_CURRENT
APPROVALPATHS_DAILY_HISTORY
APPROVALPATHS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPATHID

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

ENTEREDBYID

USERS_CURRENT

USERID

GLOBALPATHID

Not a relationship; used for internal application purposes

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

Approval Process

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Approval Process

ARVPRC

Approval Process

APPROVALPROCESSES_CURRENT
APPROVALPROCESSES_DAILY_HISTORY
APPROVALPROCESSES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPROCESSID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

Approval Step

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Approval Step

ARVSTP

Approval Stage

APPROVALSTEPS_CURRENT
APPROVALSTEPS_DAILY_HISTORY
APPROVALSTEPS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPATHID

APPROVALPATHS_CURRENT

APPROVALPATHID

APPROVALSTEPID

SYSID

Not a relationship; used for internal application purposes

Approver Status

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Approver Status

ARVSTS

ApproverStatus

APPROVERSTATUSES_CURRENT
APPROVERSTATUSES_DAILY_HISTORY
APPROVERSTATUSES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVERSTATUSID

APPROVABLEOBJID

Variable, based on APPROVABLEOBJCODE

The primary key / ID of the object identified in the APPROVABLEOBJCODE field

APPROVALSTEPID

APPROVALSTEPS_CURRENT

APPROVALSTEPID

APPROVEDBYID

USERS_CURRENT

USERID

DELEGATEUSERID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OPTASKID

OPTASKS_CURRENT

OPTASKID

OVERRIDDENUSERID

USERS_CURRENT

USERID

PROJECTID

PROJECTS_CURRENT

PROJECTID

STEPAPPROVERID

USERS_CURRENT

USERID

SYSYID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

WILDCARDUSERID

USERS_CURRENT

USERID

Assignment

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Assignment

ASSGN

Assignment

ASSIGNMENTS_CURRENT
ASSIGNMENTS_DAILY_HISTORY
ASSIGNMENTS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNEDBYID

USERS_CURRENT

USERID

ASSIGNEDTOID

USERS_CURRENT

USERID

ASSIGNMENTID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

CLASSIFIERID

CLASSIFIER_CURRENT

CLASSIFIERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OPTASKID

OPTASKS_CURRENT

OPTASKID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

PROJECTID

PROJECTS_CURRENT

PROJECTID

ROLEID

ROLES_CURRENT

ROLEID

TASKID

TASKS_CURRENT

TASKID

TEAMID

TEAMS_CURRENT

TEAMID

Awaiting Approvals

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Awaiting Approvals

AWAPVL

Awaiting Approvals

AWAITINGAPPROVALS_CURRENT
AWAITINGAPPROVALS_DAILY_HISTORY
AWAITINGAPPROVALS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ACCESSREQUESTID

Access Request table not supported currently

APPROVABLEID

Not a relationship; used for internal application purposes

APPROVERID

USERS_CURRENT

USERID

AWAITINGAPPROVALID

DOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

DOCUMENTVERSIONID

DOCUMENTVERSIONS_CURRENT

DOCUMENTVERSIONID

OPTASKID

OPTASKS_CURRENT

OPTASKID

PROJECTID

PROJECTS_CURRENT

PROJECTID

ROLEID

ROLES_CURRENT

ROLEID

SUBMITTEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEAMID

TEAMS_CURRENT

TEAMID

TIMESHEETID

TIMESHEETS_CURRENT

TIMESHEETID

USERID

USERS_CURRENT

USERID

Baseline

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Baseline

BLIN

Baseline

BASELINES_CURRENT
BASELINES_DAILY_HISTORY
BASELINES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BASELINEID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

Baseline Task

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Baseline Task

BSTSK

Baseline Task

BASELINETASKS_CURRENT
BASELINETASKS_DAILY_HISTORY
BASELINETASKS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BASELINEID

BASELINES_CURRENT

BASELINEID

BASELINETASKID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

Billing Rate

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Billing Rate

Rate or Override Rate

RATE

Billing Rate

RATES_CURRENT
RATES_DAILY_HISTORY
RATES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

CLASSIFIERID

CLASSIFIER_CURRENT

CLASSIFIERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

NLBRCATEGORYID

NLBRCATEGORIES_CURRENT

NLBRCATEGORYID

NONLABORRESOURCEID

NONLABORRESOURCES_CURRENT

NONLABORRESOURCEID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PROJECTID

PROJECTS_CURRENT

PROJECTID

RATECARDID

RATECARD_CURRENT

RATECARDID

RATEID

ROLEID

ROLES_CURRENT

ROLEID

SOURCERATECARDID

RATECARD_CURRENT

RATECARDID

SYSID

Not a relationship; used for internal application purposes

TEMPLATEID

TEMPLATES_CURRNT

TEMPLATEID

USERID

USERS_CURRENT

USERID

Billing Record

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Billing Record

BILL

Billing Record

BILLINGRECORDS_CURRENT
BILLINGRECORDS_DAILY_HISTORY
BILLINGRECORDS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BILLINGRECORDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

INVOICEID

Invoice table not supported currently

LASTUPDATEDBYID

USERS_CURRENT

USERID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

Booking

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Booking

BOOKNG

Booking

BOOKINGS_CURRENT
BOOKINGS_DAILY_HISTORY
BOOKINGS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BOOKINGID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

NLBRCATEGORYID

NLBRCATEGORIES_CURRENT

NLBRCATEGORYID

NONLABORRESOURCEID

NONLABORRESOURCES_CURRENT

NONLABORRESOURCEID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

TOPOBJID

Variable, based on TOPOBJCODE

The primary key / ID of the object identified in the TOPOBJCODE field

Business Profile

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Business Profile

BSNPRF

BusinessProfile

BUSINESSPROFILE_CURRENT
BUSINESSPROFILE_DAILY_HISTORY
BUSINESSPROFILE_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ACCESSLEVELID

ACCESSLEVELS_CURRENT

ACCESSLEVELID

BUSINESSPROFILEID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

Business Rule

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Business Rule

BSNRUL

Business Rule

BUSINESSRULE_CURRENT
BUSINESSRULE_DAILY_HISTORY
BUSINESSRULE_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BUSINESSRULEID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

PARAMETERGROUPID

PARAMETERID

PARAMETERS_CURRENT

PARAMETERID

SYSID

Not a relationship; used for internal application purposes

Classifier

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Classifier

Location

CLSF

Location

CLASSIFIER_CURRENT
CLASSIFIER_DAILY_HISTORY
CLASSIFIER_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CLASSIFIERID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

PARENTID

CLASSIFIER_CURRENT

CLASSIFIERID

SYSID

Not a relationship; used for internal application purposes

Company

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Company

CMPY

Company

COMPANIES_CURRENT
COMPANIES_DAILY_HISTORY
COMPANIES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

COMPANYID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

SYSID

Not a relationship; used for internal application purposes

Custom Quarter

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Custom Quarter

CSTQRT

Custom Quarter

CUSTOMQUARTERS_CURRENT
CUSTOMQUARTERS_DAILY_HISTORY
CUSTOMQUARTERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CUSTOMQUARTERID

SYSID

Not a relationship; used for internal application purposes

Custom Enum

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

CustomEnum

Condition, Priority, Severity, Status

CSTEM

Custom Enum

CUSTOMENUMS_CURRENT
CUSTOMENUMS_DAILY_HISTORY
CUSTOMENUMS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CUSTOMENUMID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

NOTE

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

Document

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document

DOCU

Document

DOCUMENTS_CURRENT
DOCUMENTS_DAILY_HISTORY
DOCUMENTS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

CHECKEDOUTBYID

USERS_CURRENT

USERID

DOCUMENTID

DOCUMENTREQUESTID

Document Request table not supported currently

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

ITERATIONID

ITERATIONS_CURRENT

ITERATIONID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

NOTEID

NOTES_CURRENT

NOTEID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

OPTASKID

OPTASKS_CURRENT

OPTASKID

OWNERID

USERS_CURRENT

USERID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

RELEASEVERSIONID

Release Version table not supported currently

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

TOPOBJID

Variable, based on TOPOBJCODE

The primary key / ID of the object identified in the TOPOBJCODE field

USERID

USERS_CURRENT

USERID

Document Approval

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Approval

DOCAPL

Document Approval

DOCAPPROVALS_CURRENT
DOCAPPROVALS_DAILY_HISTORY
DOCAPPROVALS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVERID

USERS_CURRENT

USERID

DOCAPPROVALID

DOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

NOTEID

NOTES_CURRENT

NOTEID

REQUESTORID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

Document Approval (NEW)

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Approval

Approval

N/A

APPROVAL_CURRENT
APPROVAL_DAILY_HISTORY
APPROVAL_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALID

NOTE: This is also the ID of the DOCUMENTVERSION object the approval is associated with.

ASSETID

Variable, based on ASSETTYPE

The primary key / ID of the object identified in the ASSETTYPE field

CREATORID

USERS_CURRENT

USERID

EAUTHTENANTID

Not a relationship; used for internal application purposes

PRODUCTID

Not a relationship; used for internal application purposes

REALCREATORID

USERS_CURRENT

USERID

Document Approval Stage (NEW)

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Approval Stage

Approval Stage

N/A

APPROVAL_STAGE_CURRENT
APPROVAL_STAGE_DAILY_HISTORY
APPROVAL_STAGE_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALID

APPROVAL_CURRENT

APPROVALID

APPROVALSTAGEID

CREATORID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

Document Approval Stage Participants (NEW)

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Approval Stage Participant

Approval Decisions

N/A

APPROVAL_STAGE_PARTICIPANT_CURRENT
APPROVAL_STAGE_PARTICIPANT_DAILY_HISTORY
APPROVAL_STAGE_PARTICIPANT_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALID

APPROVAL_CURRENT

APPROVALID

APPROVALSTAGEPARTICIPANTID/td>

ASSETID

Variable, based on ASSETTYPE

The primary key / ID of the object identified in the ASSETTYPE field

DECISIONUSERID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PARTICIPANTID

Variable, based on PARTICIPANTTYPE

The primary key / ID of the object identified in the PARTICIPANTTYPE field

REALREQUESTORID

USERS_CURRENT

USERID

REALUSERID

USERS_CURRENT

USERID

REQUESTORID

USERS_CURRENT

USERID

STAGEID

APPROVAL_STAGE_CURRENT

STAGEID

Document Folder

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Folder

DOCFLD

DocsFolders

DOCFOLDERS_CURRENT
DOCFOLDERS_DAILY_HISTORY
DOCFOLDERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCFOLDERID

ENTEREDBYID

USERS_CURRENT

USERID

ISSUEID

OPTASKS_CURRENT

OPTASKID

ITERATIONID

ITERATIONS_CURRENT

ITERATIONID

LINKEDFOLDERID

LINKEDFOLDERS_CURRENT

LINKEDFOLDERID

PARENTID

DOCFOLDERS_CURRENT

DOCFOLDERID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

USERID

USERS_CURRENT

USERID

Document Provider Metadata

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Provider Metadata

DOCMET

DocumentProviderMetadata

DOCPROVIDERMETA_CURRENT
DOCPROVIDERMETA_DAILY_HISTORY
DOCPROVIDERMETA_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCPROVIDERMETAID

SYSID

Not a relationship; used for internal application purposes

Document Provider

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Provider

DOCPRO

Document Provider

DOCPROVIDERS_CURRENT
DOCPROVIDERS_DAILY_HISTORY
DOCPROVIDERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCPROVIDERCONFIGID

DOCPROVIDERCONFIG_CURRENT

DOCPROVIDERCONFIGID

DOCPROVIDERID

OWNERID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

Document Provider Config

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Provider Config

DOCCFG

DocumentProviderConfig

DOCPROVIDERCONFIG_CURRENT
DOCPROVIDERCONFIG_DAILY_HISTORY
DOCPROVIDERCONFIG_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCPROVIDERCONFIGID

SYSID

Not a relationship; used for internal application purposes

Document Version

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Document Version

DOCV

Document Version

DOCUMENTVERSIONS_CURRENT
DOCUMENTVERSIONS_DAILY_HISTORY
DOCUMENTVERSIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

DOCUMENTPROVIDERID

DOCPROVIDERS_CURRENT

DOCUMENTPROVIDERID

DOCUMENTVERSIONID

ENTEREDBYID

USERS_CURRENT

USERID

EXTERNALSTORAGEID

The External ID in the external storage system

PROOFAPPROVALSTATUSID

Proof Approval Status table not supported currently

PROOFEDBYUSERID

USERS_CURRENT

USERID

PROOFID

Proof table not supported currently

PROOFOWNERID

USERS_CURRENT

USERID

PROOFSTAGEID

Proof Stage table not supported currently

SYSID

Not a relationship; used for internal application purposes

Exchange Rate

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Exchange Rate

EXRATE

Exchange Rate

EXCHANGERATES_CURRENT
EXCHANGERATES_DAILY_HISTORY
EXCHANGERATES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

EXCHANGERATEID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

Expense

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Expense

EXPNS

Expense

EXPENSES_CURRENT
EXPENSES_DAILY_HISTORY
EXPENSES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BILLINGRECORDID

BILLINGRECORDS_CURRENT

BILLINGRECORDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

EXPENSEID

EXPENSETYPEID

EXPENSETYPES_CURRENT

EXPENSETYPEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

TOPOBJID

Variable, based on TOPBJCODE

The primary key / ID of the object identified in the TOPBJCODE field

Expense Type

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Expense Type

EXPTYP

Expense Type

EXPENSETYPES_CURRENT
EXPENSETYPES_DAILY_HISTORY
EXPENSETYPES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

EXPENSETYPEID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SYSID

Not a relationship; used for internal application purposes

Group

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Group

GROUP

Group

GROUPS_CURRENT
GROUPS_DAILY_HISTORY
GROUPS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

BUSINESSLEADERID

USERS_CURRENT

USERID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

LAYOUTTEMPLATEID

Not a relationship; used for internal application purposes

PARENTID

GROUPS_CURRENT

GROUPID

ROOTID

GROUPS_CURRENT

GROUPID

SYSID

Not a relationship; used for internal application purposes

UITEMPLATEID

UITEMPLATES_CURRENT

UITEMPLATEID

Hour

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Hour

HOUR

Hour

HOURS_CURRENT
HOURS_DAILY_HISTORY
HOURS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVEDBYID

USERS_CURRENT

USERID

BILLINGRECORDID

BILLINGRECORDS_CURRENT

BILLINGRECORDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

CLASSIFIERID

CLASSIFIER_CURRENT

CLASSIFIERID

DUPID

Not a relationship; used for internal application purposes

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

EXTERNALTIMESHEETID

Not a Workfront relationship; used for integration to external systems Self

HOURID

HOURTYPEID

HOURTYPES_CURRENT

HOURTYPEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OPTASKID

OPTASKS_CURRENT

OPTASKID

OWNERID

USERS_CURRENT

USERID

PROJECTID

PROJECTS_CURRENT

PROJECTID

PROJECTOVERHEADID

Not a relationship; used for internal application purposes

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TIMESHEETID

TIMESHEETS_CURRENT

TIMESHEETID

Hour Type

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Hour Type

HOURT

Hour Type

HOURTYPES_CURRENT
HOURTYPES_DAILY_HISTORY
HOURTYPES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

HOURTYPEID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SYSID

Not a relationship; used for internal application purposes

Iteration

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Iteration

ITRN

Iteration

ITERATIONS_CURRENT
ITERATIONS_DAILY_HISTORY
ITERATIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

ITERATIONID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OWNERID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

Journal Entry

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Journal Entry

JRNLE

Journal Entry

JOURNALENTRIES_CURRENT
JOURNALENTRIES_DAILY_HISTORY
JOURNALENTRIES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVERSTATUSID

APPROVERSTATUSES_CURRENT

APPROVERSTATUSID

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

AUDITRECORDID

Audit record table not supported currently

BASELINEID

BASELINES_CURRENT

BASELINEID

BILLINGRECORDID

BILLINGRECORDS_CURRENT

BILLINGRECORDID

COMPANYID

COMPANIES_CURRENT

COMPANYID

DOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

DOCUMENTSHAREID

Document Share table not supported currently

EDITEDBYID

USERS_CURRENT

USERID

EXPENSEID

EXPENSES_CURRENT

EXPENSEID

HOURID

HOURS_CURRENT

HOURID

INITIATIVEID

Initiative table not supported currently

JOURNALENTRIESID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

OPTASKID

OPTASKS_CURRENT

OPTASKID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SUBOBJID

Variable, based on SUBOBJCODE

The primary key / ID of the object identified in the SUBOBJCODE field

SUBSCRIBEID

Not a relationship; used for internal application purposes

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TIMESHEETID

TIMESHEETS_CURRENT

TIMESHEETID

TOPOBJID

Variable, based on TOPOBJCODE

The primary key / ID of the object identified in the TOPOBJCODE field

USERID

USERS_CURRENT

USERID

Linked Folder

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Linked Folder

LNKFDR

LinkedFolder

LINKEDFOLDERS_CURRENT
LINKEDFOLDERS_DAILY_HISTORY
LINKEDFOLDERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCUMENTPROVIDERID

DOCPROVIDERS_CURRENT

DOCUMENTPROVIDERID

EXTERNALSTORAGEID

The External ID in the external storage system

FOLDERID

DOCFOLDERS_CURRENT

FOLDERID

LINKEDBYID

USERS_CURRENT

USERID

LINKEDFOLDERID

SYSID

Not a relationship; used for internal application purposes

Milestone

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Milestone

MILE

Milestone

MILESTONES_CURRENT
MILESTONES_DAILY_HISTORY
MILESTONES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEID

MILESTONEPATHID

MILESTONEPATHS_CURRENT

MILESTONEPATHID

SYSID

Not a relationship; used for internal application purposes

Milestone Path

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Milestone Path

MPATH

Milestone Path

MILESTONEPATHS_CURRENT
MILESTONEPATHS_DAILY_HISTORY
MILESTONEPATHS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEPATHID

SYSID

Not a relationship; used for internal application purposes

Non-Labor Resource

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Non-Labor Resource

Non-labor resource

NLBR

Non-labor resource

NONLABORRESOURCES_CURRENT
NONLABORRESOURCES_DAILY_HISTORY
NONLABORRESOURCES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

NONLABORRESOURCEID

ENTEREDBYID

USERS_CURRENT

USERID

HOMEGROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

NONLABORRESOURCECATEGORYID

NLBRCATEGORIES_CURRENT

NLBRCATEGORYID

SYSID

Not a relationship; used for internal application purposes

Non-Labor Resource Category

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Non-Labor Resource Category

NLBRCY

Non-labor resource category

NLBRCATEGORIES_CURRENT
NLBRCATEGORIES_DAILY_HISTORY
NLBRCATEGORIES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

NLBRCATEGORYID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

SYSID

Not a relationship; used for internal application purposes

Non-Work Day

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Non-Work Day

Schedule Exception

NONWKD

Non Work Day

NONWORKDAYS_CURRENT
NONWORKDAYS_DAILY_HISTORY
NONWORKDAYS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

NONWORKDAYID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Note

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Note

NOTE

Note

NOTES_CURRENT
NOTES_DAILY_HISTORY
NOTES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ATTACHDOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

ATTACHOBJID

Variable, based on ATTACHOBJCODE

The primary key / ID of the object identified in the OBJCODE ATTACHOBJCODE

ATTACHOPTASKID

OPTASKS_CURRENT

OPTASKID

ATTACHWORKID

WORKITEMS_CURRENT

WORKITEMID

ATTACHWORKUSERID

USERS_CURRENT

USERID

AUDITRECORDID

Audit Record table not supportd currently

COMPANYID

COMPANIES_CURRENT

COMPANYID

DOCUMENTID

DOCUMENTS_CURRENT

DOCUMENTID

EXTERNALSERVICEID

Not a Workfront relationship; used for integration to external systems

ITERATIONID

ITERATIONS_CURRENT

ITERATIONID

NOTEID

OBJID

Variable, based on NOTEOBJCODE

The primary key / ID of the object identified in the NOTEOBJCODE field

OPTASKID

OPTASKS_CURRENT

OPTASKID

OWNERID

USERS_CURRENT

USERID

PARENTENDORSEMENTID

Endorsement table not supported currently

PARENTJOURNALENTRYID

JOURNALENTRIES_CURRENT

JOURNALENTRYID

PARENTNOTEID

NOTES_CURRENT

NOTEID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

PROOFACTIONID

Proof Action table not supported currently

PROOFID

Proof table not supported currently

RICHTEXTNOTEID

RESERVEDTEXTNOTES_CURRENT

RICHTEXTNOTEID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

THREADID

NOTES_CURRENT

NOTEID

TIMESHEETID

TIMESHEETS_CURRENT

TIMESHEETID

TOPOBJID

Variable, based on TOPOBJCODE

The primary key / ID of the object identified in the TOPOBJCODE field

USERID

USERS_CURRENT

USERID

Object Integration

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Object Integration

OBJINT

ObjectIntegration

OBJECTINTEGRATION_CURRENT
OBJECTINTEGRATION_DAILY_HISTORY
OBJECTINTEGRATION_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

LINKEDOBJECTID

Variable, based on LINKEDOBJECTCODE

The primary key / ID of the object identified in the LINKEDOBJECTCODE field

OBJECTINTEGRATIONID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SYSID

Not a relationship; used for internal application purposes

Objects Category

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Objects Category

Object Categories

OBJCAT

Object Category

OBJECTSCATEGORIES_CURRENT
OBJECTSCATEGORIES_DAILY_HISTORY
OBJECTSCATEGORIES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

OBJECTSCATEGORYID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

SYSID

Not a relationship; used for internal application purposes

OpTask / Issue

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

OpTask

Issue, Request

OPTASK

Issue

OPTASKS_CURRENT
OPTASKS_DAILY_HISTORY
OPTASKS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

ASSIGNEDTOID

USERS_CURRENT

USERID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

CURRENTAPPROVALSTEPID

APPROVALSTEPS_CURRENT

APPROVALSTEPID

ENTEREDBYID

USERS_CURRENT

USERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

ITERATIONID

ITERATIONS_CURRENT

ITERATIONID

KANBANBOARDID

Kanban Board table not supported currently

LASTCONDITIONNOTEID

NOTES_CURRENT

NOTEID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OPTASKID

OWNERID

USERS_CURRENT

USERID

PROJECTID

PROJECTS_CURRENT

PROJECTID

QUEUEDEFID

Queue Definition table not supported currently

QUEUETOPICID

Queue Topic table not supported currently

RESOLVEOPTASKID

OPTASKS_CURRENT

OPTASKID

RESOLVEPROJECTID

PROJECTS_CURRENT

PROJECTID

RESOLVETASKID

TASKS_CURRENT

TASKID

RESOLVINGOBJID

Variable, based on RESOLVINGOBJCODE

The primary key / ID of the object identified in the RESOLVINGOBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SOURCEOBJID

Variable, based on SOURCEOBJCODE

The primary key / ID of the object identified in the SOURCEOBJCODE field

SOURCETASKID

TASKS_CURRENT

TASKID

SUBMITTEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

Parameter

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Parameter

Custom Field

PARAM

Parameter

PARAMETERS_CURRENT
PARAMETERS_DAILY_HISTORY
PARAMETERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

LASTUPDATEDBYID

USERS_CURRENT

USERID

PARAMETERFILTERID

Parameter Filter table not supported currently

PARAMETERID

SYSID

Not a relationship; used for internal application purposes

Parameter Group

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Parameter Group

Form Section

PARAM

Parameter Group

PARAMETERGROUPS_CURRENT
PARAMETERGROUPS_DAILY_HISTORY
PARAMETERGROUPS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

LASTUPDATEDBYID

USERS_CURRENT

USERID

PARAMETERGROUPID

SYSID

Not a relationship; used for internal application purposes

Parameter Option

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Parameter Option

POPT

Parameter Option

PARAMETEROPTIONS_CURRENT
PARAMETEROPTIONS_DAILY_HISTORY
PARAMETEROPTIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PARAMETERID

PARAMETERS_CURRENT

PARAMETERID

PARAMETEROPTIONID

SYSID

Not a relationship; used for internal application purposes

Portal Section / Report

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Portal Section

Report

PTLSEC

Report

PORTALSECTIONS_CURRENT
PORTALSECTIONS_DAILY_HISTORY
PORTALSECTIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

ENTEREDBYID

USERS_CURRENT

USERID

FILTERID

UIFILTERS_CURRENT

FILTERID

GROUPBYID

UIGROUPBYS_CURRENT

GROUPBYID

LASTUPDATEDBYID

USERS_CURRENT

USERID

LASTVIEWEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PORTALSECTIONID

PREFERENCEID

PREFERENCES_CURRENT

PREFERENCEID

PUBLICRUNASUSERID

USERS_CURRENT

USERID

REPORTFOLDERID

REPORTFOLDERS_CURRENT

REPORTFOLDERID

RUNASUSERID

USERS_CURRENT

USERID

SCHEDULEDREPORTID

Scheduled Report table not supported currently

SYSID

Not a relationship; used for internal application purposes

VIEWID

UIVIEWS_CURRENT

VIEWID

Portal Tab / Dashboard

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Portal Tab

Dashboard

PTLTAB

Dashboard

PORTALTABS_CURRENT
PORTALTABS_DAILY_HISTORY
PORTALTABS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

DOCID

Not a relationship; used for internal application purposes

LASTUPDATEDBYID

USERS_CURRENT

USERID

PORTALPROFILEID

Not a relationship; used for internal application purposes

PORTALTABID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Portal Tab Section

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Portal Tab Section

Dashboard Section

PRTBSC

Portal Tab Section

PORTALTABSPORTALSECTIONS_CURRENT
PORTALTABSPORTALSECTIONS_DAILY_HISTORY
PORTALTABSPORTALSECTIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CALENDARPORTALSECTIONID

Calendar Portal Section not supported currently

EXTERNALSECTIONID

External Sections table not supported currently

INTERNALSECTIONID

PORTALSECTIONS_CURRENT

PORTALSECTIONID

PORTALSECTIONOBJID

Variable, based on PORTALSECTIONOBJCODE

The primary key / ID of the object identified in the PORTALSECTIONOBJCODE field

PORTALTABID

PORTALTABS_CURRENT

PORTALTABID

PORTALTABSECTIONID

SYSID

Not a relationship; used for internal application purposes

Portal Section Last Viewer

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

PortalSectionLastViewer

Report Last Viewers

PLSLSV

PortalSectionLastViewer

REPORTLASTVIEWERS_CURRENT
REPORTLASTVIEWERS_DAILY_HISTORY
REPORTLASTVIEWERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

REPORTID

PORTALSECTIONS_CURRENT

REPORTID

REPORTLASTVIEWERID

SYSID

Not a relationship; used for internal application purposes

VIEWERID

USERS_CURRENT

USERID

Portfolio

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Portfolio

PORT

Portfolio

PORTFOLIOS_CURRENT
PORTFOLIOS_DAILY_HISTORY
PORTFOLIOS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ALIGNMENTSCORECARDID

Scorecard table not supported currently

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OWNERID

USERS_CURRENT

USERID

PORTFOLIOID

SYSID

Not a relationship; used for internal application purposes

Preference

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Preference

View, Filter, Grouping, Report Definition

PROSET

Preference

PREFERENCES_CURRENT
PREFERENCES_DAILY_HISTORY
PREFERENCES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

PREFERENCEID

SYSID

Not a relationship; used for internal application purposes

Program

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Program

PRGM

Program

PROGRAMS_CURRENT
PROGRAMS_DAILY_HISTORY
PROGRAMS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OWNERID

USERS_CURRENT

USERID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

SYSID

Not a relationship; used for internal application purposes

Project

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Project

PROJ

Project

PROJECTS_CURRENT
PROJECTS_DAILY_HISTORY
PROJECTS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

AEMNATIVEFOLDERTREESREFID

Not a relationship; used for internal application purposes

ALIGNMENTSCORECARDID

Scorecard table not supported currently

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

ATTACHEDRATECARDID

RATECARD_CURRENT

RATECARDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

COMPANYID

COMPANIES_CURRENT

COMPANYID

CONVERTEDOPTASKID

OPTASKS_CURRENT

OPTASKID

CONVERTEDOPTASKORIGINATORID

USERS_CURRENT

USERID

CURRENTAPPROVALSTEPID

APPROVALSTEPS_CURRENT

APPROVALSTEPID

DELIVERABLESCORECARDID

Scorecard table not supported currently

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTCONDITIONNOTEID

NOTES_CURRENT

NOTEID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEPATHID

MILESTONEPATHS_CURRENT

MILESTONEPATHID

OWNERID

USERS_CURRENT

USERID

POPACCOUNTID

Pop Account table not supported currently

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

QUEUEDEFID

Queue Definition table not supported currently

REJECTIONISSUEID

OPTASKS_CURRENT

OPTASKID

RESOURCEPOOLID

RESOURCEPOOLS_CURRENT

RESOURCEPOOLID

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

SPONSORID

USERS_CURRENT

USERID

SUBMITTEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

Project Team User

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Project Team User

PRTU

Project User

PROJECTSUSERS_CURRENT
PROJECTSUSERS_DAILY_HISTORY
PROJECTSUSERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PROJECTID

PROJECTS_CURRENT

PROJECTID

PROJECTSUSERID

SYSID

Not a relationship; used for internal application purposes

TMPUSERID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Project Team User Role

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Project Team User Role

PTEAM

ProjectUserRole

PROJECTSUSERSROLES_CURRENT
PROJECTSUSERSROLES_DAILY_HISTORY
PROJECTSUSERSROLES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PROJECTID

PROJECTS_CURRENT

PROJECTID

PROJECTSUSERSROLEID

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Rate Card

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Rate Card

RTCRD

Rate Card

RATECARD_CURRENT
RATECARD_DAILY_HISTORY
RATECARD_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

RATECARDID

SECURITYROOTID

Variable, based on SECURITYOBJCODE

The primary key / ID of the object identified in the SECURITYOBJCODE field

SOURCEID

Variable, based on SOURCEOBJCODE

The primary key / ID of the object identified in the SOURCEOBJCODE field

SYSID

Not a relationship; used for internal application purposes

Report Folder

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Report Folder

RPTFDR

Report Folder

REPORTFOLDERS_CURRENT
REPORTFOLDERS_DAILY_HISTORY
REPORTFOLDERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

REPORTFOLDERID

SYSID

Not a relationship; used for internal application purposes

Report View Statistic Count

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Report View Statistic Count

PLSVST

PortalSectionStatisticInfo

REPORTVIEWSTATISTICCOUNTS_CURRENT
REPORTVIEWSTATISTICCOUNTS_DAILY_HISTORY
REPORTVIEWSTATISTICCOUNTS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

REPORTID

PORTALSECTIONS_CURRENT

PORTALSECTIONID

REPORTVIEWSTATISTICCOUNTID

SYSID

Not a relationship; used for internal application purposes

Reportable Budgeted Hours

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Reportable Budgeted Hours

RPBGHR

Budgeted Hour

REPORTABLEBUDGETEDHOURS_CURRENT
REPORTABLEBUDGETEDHOURS_DAILY_HISTORY
REPORTABLEBUDGETEDHOURS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PROJECTID

PROJECTS_CURRENT

PROJECTID

REPORTABLEBUDGETEDHOURID

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Reserved Time / PTO

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Reserved Time

(Personal) Time Off

RESVT

Time Off

RESERVEDTIMES_CURRENT
RESERVEDTIMES_DAILY_HISTORY
RESERVEDTIMES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

RESERVEDTIMEID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

USERID

USERS_CURRENT

USERID

Resource Manager

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Resource Manager

RESMGR

Resource Manager

RESOURCEMANAGERS_CURRENT
RESOURCEMANAGERS_DAILY_HISTORY
RESOURCEMANAGERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PROJECTID

PROJECTS_CURRENT

PROJECTID

RESOURCEMANAGERID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

Resource Pool

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Resource Pool

RSPL

Resource Pool

RSRCPOOLS_CURRENT
RSRCPOOLS_DAILY_HISTORY
RSRCPOOLS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

RESOURCEPOOLID

SYSID

Not a relationship; used for internal application purposes

Rich Text Note

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Rich Text Note

RHNOTE

Rich Text Note

RESERVEDTEXTNOTES_CURRENT
RESERVEDTEXTNOTES_DAILY_HISTORY
RESERVEDTEXTNOTES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

RICHTEXTNOTEID

SYSID

Not a relationship; used for internal application purposes

Rich Text Parameter Value

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Rich Text Parameter Value

RCHVAL

RichTextParameterValue

RICHTEXTPARAMETERVALUES_CURRENT
RICHTEXTPARAMETERVALUES_DAILY_HISTORY
RICHTEXTPARAMETERVALUES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PARAMETERVALUEID

Parameter Value table not supported currently

RICHTEXTPARAMETERVALUEID

SYSID

Not a relationship; used for internal application purposes

Risk

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Risk

RISK

Risk

RISKS_CURRENT
RISKS_DAILY_HISTORY
RISKS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

PROJECTID

PROJECTS_CURRENT

PROJECTID

RISKID

RISKTYPEID

RISKTYPES_CURRENT

RISKTYPEID

SYSID

Not a relationship; used for internal application purposes

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

Risk Type

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Risk Type

RSKTYP

Risk Type

RISKTYPES_CURRENT
RISKTYPES_DAILY_HISTORY
RISKTYPES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

RISKTYPEID

SYSID

Not a relationship; used for internal application purposes

Role

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Role

Job Role

ROLE

Job Role

ROLES_CURRENT
ROLES_DAILY_HISTORY
ROLES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

LAYOUTTEMPLATEID

Layout Template table will not be supported

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

ROLEID

SYSID

Not a relationship; used for internal application purposes

UITEMPLATEID

UITEMPLATES_CURRENT

UITEMPLATEID

Schedule

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Schedule

SCHED

Schedule

SCHEDULES_CURRENT
SCHEDULES_DAILY_HISTORY
SCHEDULES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

HOMEGROUPID

GROUPS_CURRENT

GROUPID

SCHEDULEID

SYSID

Not a relationship; used for internal application purposes

Staffing Plan

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Staffing Plan

STAFFP

Staffing Plan

STAFFING_PLAN_CURRENT
STAFFING_PLAN_DAILY_HISTORY
STAFFING_PLAN_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ATTACHEDRATECARDID

RATECARD_CURRENT

RATECARDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

COMPANYID

COMPANIES_CURRENT

COMPANYID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OWNERID

USERS_CURRENT

USERID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

STAFFINGPLANID

Staffing Plan Resource

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Staffing Plan Resource

STAFFR

Staffing Plan Resource

STAFFING_PLAN_RESOURCE_CURRENT
STAFFING_PLAN_RESOURCE_DAILY_HISTORY
STAFFING_PLAN_RESOURCE_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNEDBYID

USERS_CURRENT

USERID

ASSIGNEDTOID

USERS_CURRENT

USERID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

LASTUPDATEDBYID

USERS_CURRENT

USERID

ROLEID

ROLES_CURRENT

ROLEID

STAFFINGPLANID

STAFFING_PLAN_CURRENT

STAFFINGPLANID

STAFFINGPLANRESOURCEID

Step Approver

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Step Approver

SPAPVR

Stage Approver

STEPAPPROVERS_CURRENT
STEPAPPROVERS_DAILY_HISTORY
STEPAPPROVERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALSTEPID

APPROVALSTEPS_CURRENT

APPROVALSTEPID

ROLEID

ROLES_CURRENT

ROLEID

STEPAPPROVERID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

USERID

USERS_CURRENT

USERID

Task

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Task

TASK

Task

TASKS_CURRENT
TASKS_DAILY_HISTORY
TASKS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

ASSIGNEDTOID

USERS_CURRENT

USERID

BILLINGRECORDID

BILLINGRECORDS_CURRENT

BILLINGRECORDID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

CONVERTEDOPTASKID

OPTASKS_CURRENT

OPTASKID

CONVERTEDOPTASKORIGINATORID

USERS_CURRENT

USERID

CURRENTAPPROVALSTEPID

APPROVALSTEPS_CURRENT

APPROVALSTEPID

ENTEREDBYID

USERS_CURRENT

USERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

GROUPID

GROUPS_CURRENT

GROUPID

ITERATIONID

ITERATIONS_CURRENT

ITERATIONID

KANBANBOARDID

Kanban Board table not supported currently

LASTCONDITIONNOTEID

NOTES_CURRENT

NOTEID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEID

MILESTONES_CURRENT

MILESTONEID

PARENTID

TASKS_CURRENT

TASKID

PROJECTID

PROJECTS_CURRENT

PROJECTID

RECURRENCERULEID

Recurrence Rule table not supported currently

REJECTIONISSUEID

OPTASKS_CURRENT

OPTASKID

RESERVEDTIMEID

RESERVEDTIMES_CURRENT

RESERVEDTIMEID

ROLEID

ROLES_CURRENT

ROLEID

SUBMITTEDBYID

USERS_CURRENT

SUBMITTEDBYID

SYSID

Not a relationship; used for internal application purposes

TASKID

TEAMID

TEAMS_CURRENT

TEAMID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

Task Predecessor

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Task Predecessor

Predecessor

PRED

Predecessor

PREDECESSORS_CURRENT
PREDECESSORS_DAILY_HISTORY
PREDECESSORS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PREDECESSORID

TASKS_CURRENT

TASKID

SUCCESSORID

TASKS_CURRENT

TASKID

SYSID

Not a relationship; used for internal application purposes

Team

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Team

TEAMOB

Team

TEAMS_CURRENT
TEAMS_DAILY_HISTORY
TEAMS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LAYOUTTEMPLATEID

Layout Template table will not be supported

MYWORKVIEWID

UIVIEWS_CURRENT

UIVIEWID

OWNERID

USERS_CURRENT

USERID

REQUESTSVIEWID

UIVIEWS_CURRENT

UIVIEWID

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

TEAMID

SYSID

Not a relationship; used for internal application purposes

UITEMPLATEID

UITEMPLATES_CURRENT

UITEMPLATEID

NOTE

There are 3 team types that are stored in the Team object tables: PROJECT, TEMPLATE, and ADHOC.

Each of these team types are represented together in the Data Connect data lake views. To isolate the specific type of team you want returned, you’ll need to filter on the teamtype column. For example, if you only want the traditional teams that are part of your organizational structures, which are configured in the Teams area of the application, you might have a query that looks something like this: select * from teams_current where teamtype = ‘ADHOC’;

Team Member

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Team Member

Other Teams, Team Member

TEAMMB

Team Member

TEAMMEMBERS_CURRENT
TEAMMEMBERS_DAILY_HISTORY
TEAMMEMBERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEAMMEMBERID

USERID

USERS_CURRENT

USERID

Team Member Role

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Team Member Role

TEAMMR

Team Member Role

TEAMMEMBERROLES_CURRENT
TEAMMEMBERROLES_DAILY_HISTORY
TEAMMEMBERROLES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEAMMEMBERROLEID

USERID

USERS_CURRENT

USERID

Template

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Template

Template, Project Template

TMPL

Template

TEMPLATES_CURRENT
TEMPLATES_DAILY_HISTORY
TEMPLATES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

COMPANYID

COMPANIES_CURRENT

COMPANYID

DELIVERABLESCORECARDID

Deliverable Scorecard table not supported currently

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEPATHID

MILESTONEPATHS_CURRENT

MILESTONEPATHID

OWNERID

USERS_CURRENT

USERID

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

QUEUEDEFID

Queue Definition table not supported currently

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEMPLATEID

Template Task Assignment

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Template Task Assignment

Template Assignment

TASSGN

Template Assignment

TEMPLATEASSIGNMENTS_CURRENT
TEMPLATEASSIGNMENTS_DAILY_HISTORY
TEMPLATEASSIGNMENTS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNEDTOID

USERS_CURRENT

USERID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEAMTIMELINEABLEID

Team Timelineable table not supported currently

TEMPLATEASSIGNMENTID

TEMPLATETASKID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

Template Task

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Template Task

TTSK

Template Task

TEMPLATETASKS_CURRENT
TEMPLATETASKS_DAILY_HISTORY
TEMPLATETASKS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVALPROCESSID

APPROVALPROCESSES_CURRENT

APPROVALPROCESSID

ASSIGNEDTOID

USERS_CURRENT

USERID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

ENTEREDBYID

USERS_CURRENT

USERID

EXCHANGERATEID

EXCHANGERATES_CURRENT

EXCHANGERATEID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

MILESTONEID

MILESTONES_CURRENT

MILESTONEID

PARENTID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

RECURRENCERULEID

Recurrence Rule table not supported currently

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

TEAMID

TEAMS_CURRENT

TEAMID

TEAMTIMELINEABLEID

Team Timelineable table not supported currently

TEMPLATEID

TEMPLATES_CURRENT

TEMPLATEID

TEMPLATETASKID

Template Task Predecessor

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Template Task Predecessor

Template Predecessor

TPRED

Predecessor

TEMPLATEPREDECESSORS_CURRENT
TEMPLATEPREDECESSORS_DAILY_HISTORY
TEMPLATEPREDECESSORS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PREDECESSORID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

SUCCESSORID

TEMPLATETASKS_CURRENT

TEMPLATETASKID

TEMPLATEPREDECESSORID

SYSID

Not a relationship; used for internal application purposes

Time-phased KPI Combined

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Time-phased KPI Combined

Time-phased KPI

TMPH

TimePhasedKPI

TIMEPHASED_COMBINED_CURRENT
TIMEPHASED_COMBINED_DAILY_HISTORY
TIMEPHASED_COMBINED_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

EVENT_ID

This is a natural key for the time-phased KPI entry

GROUPID

GROUPS_CURRENT

GROUPID

LOCATIONID

CLASSIFIER_CURRENT

CLASSIFIERID

METADATAID

The METADATA table is not provided

OPTASKID

OPTASKS_CURRENT

OPTASKID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

REFERENCEID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SCHEMAID

The SCHEMA table is not provided; the value from this table is provided in the SCHEMANAME column. The SCHEMANAME identifies the KPI (e.g., plannedHours, estimatedHours, and actualHours) that the record is connected to.

SOURCETASKID

TASKS_CURRENT

TASKID

STAFFINGPLANID

STAFFING_PLAN_CURRENT

STAFFINGPLANID

STAFFINGPLANRESOURCEID

STAFFING_PLAN_RESOURCE_CURRENT

STAFFINGPLANRESOURCEID

TASKID

TASKS_CURRENT

TASKID

USERID

USERS_CURRENT

USERID

Time-phased KPI Currency

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Time-phased KPI Currency

Time-phased KPI

TMPH

TimePhasedKPI

TIMEPHASED_CURRENCY_CURRENT
TIMEPHASED_CURRENCY_DAILY_HISTORY
TIMEPHASED_CURRENCY_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

GROUPID

GROUPS_CURRENT

GROUPID

LOCATIONID

CLASSIFIER_CURRENT

CLASSIFIERID

METADATAID

The METADATA table is not provided

OPTASKID

OPTASKS_CURRENT

OPTASKID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

REFERENCEID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SCHEMAID

The SCHEMA table is not provided; the value from this table is provided in the SCHEMANAME column. The SCHEMANAME identifies the KPI (e.g., plannedRevenueRate, plannedCostRate, actualRevenue, etc.) that the record is connected to.

SCHEMAID

SOURCETASKID

TASKS_CURRENT

TASKID

STAFFINGPLANID

STAFFING_PLAN_CURRENT

STAFFINGPLANID

STAFFINGPLANRESOURCEID

STAFFING_PLAN_RESOURCE_CURRENT

STAFFINGPLANRESOURCEID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TIMEPHASEDCURRENCYID

USERID

USERS_CURRENT

USERID

Time-phased KPI Duration

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Time-phased KPI Duration

Time-phased KPI

TMPH

TimePhasedKPI

TIMEPHASED_DURATION_CURRENT
TIMEPHASED_DURATION_DAILY_HISTORY
TIMEPHASED_DURATION_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

GROUPID

GROUPS_CURRENT

GROUPID

LOCATIONID

CLASSIFIER_CURRENT

CLASSIFIERID

METADATAID

The METADATA table is not provided

OPTASKID

OPTASKS_CURRENT

OPTASKID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

REFERENCEID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SCHEMAID

SOURCETASKID

TASKS_CURRENT

TASKID

STAFFINGPLANID

STAFFING_PLAN_CURRENT

STAFFINGPLANID

STAFFINGPLANRESOURCEID

STAFFING_PLAN_RESOURCE_CURRENT

STAFFINGPLANRESOURCEID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

TIMEPHASEDDURATIONID

USERID

USERS_CURRENT

USERID

Time-phased KPI Numbers

Limited customer availability

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Time-phased KPI Numbers

Time-phased KPI

TMPH

TimePhasedKPI

TIMEPHASED_NUMBERS_CURRENT
TIMEPHASED_NUMBERS_DAILY_HISTORY
TIMEPHASED_NUMBERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

EVENT_ID

This is a natural key for the time-phased KPI entry

GROUPID

GROUPS_CURRENT

GROUPID

LOCATIONID

CLASSIFIER_CURRENT

CLASSIFIERID

METADATAID

The METADATA table is not provided

OPTASKID

OPTASKS_CURRENT

OPTASKID

PORTFOLIOID

PORTFOLIOS_CURRENT

PORTFOLIOID

PROGRAMID

PROGRAMS_CURRENT

PROGRAMID

PROJECTID

PROJECTS_CURRENT

PROJECTID

REFERENCEID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

ROLEID

ROLES_CURRENT

ROLEID

SCHEMAID

SOURCETASKID

TASKS_CURRENT

TASKID

STAFFINGPLANID

STAFFING_PLAN_CURRENT

STAFFINGPLANID

STAFFINGPLANRESOURCEID

STAFFING_PLAN_RESOURCE_CURRENT

STAFFINGPLANRESOURCEID

TASKID

TASKS_CURRENT

TASKID

TIMEPHASEDNUMBERSID

USERID

USERS_CURRENT

USERID

Timesheet

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Timesheet

TSHET

Timesheet

TIMESHEETS_CURRENT
TIMESHEETS_DAILY_HISTORY
TIMESHEETS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVERID

USERS_CURRENT

USERID

LASTNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TIMESHEETID

TIMESHEETPROFILEID

TIMESHEETPROFILES_CURRENT

TIMESHEETPROFILEID

USERID

USERS_CURRENT

USERID

Timesheet Profile

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

Timesheet Profile

TSPRO

Timesheet Profile

TIMESHEETPROFILES_CURRENT
TIMESHEETPROFILES_DAILY_HISTORY
TIMESHEETPROFILES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPROVERID

USERS_CURRENT

USERID

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

SYSID

Not a relationship; used for internal application purposes

TIMESHEETPROFILEID

UI Filter

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UI Filter

Filter

UIFT

Filter

UIFILTERS_CURRENT
UIFILTERS_DAILY_HISTORY
UIFILTERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PREFERENCEID

PREFERENCES_CURRENT

PREFERENCEID

SYSID

Not a relationship; used for internal application purposes

UIFILTERID

UI Group By

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UI Group By

Grouping

UIGB

Grouping

UIGROUPBYS_CURRENT
UIGROUPBYS_DAILY_HISTORY
UIGROUPBYS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PREFERENCEID

PREFERENCES_CURRENT

PREFERENCEID

SYSID

Not a relationship; used for internal application purposes

UIGROUPBYID

UI Template

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UI Template

Layout Template

UITMPL

Layout Template

UITEMPLATES_CURRENT
UITEMPLATES_DAILY_HISTORY
UITEMPLATES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ENTEREDBYID

USERS_CURRENT

USERID

GROUPID

GROUPS_CURRENT

GROUPID

LASTUPDATEDBYID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

UITEMPLATEID

UI View

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UI View

View

UIVIEW

View

UIVIEWS_CURRENT
UIVIEWS_DAILY_HISTORY
UIVIEWS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

APPGLOBALID

Not a relationship; used for internal application purposes

ENTEREDBYID

USERS_CURRENT

USERID

LASTUPDATEDBYID

USERS_CURRENT

USERID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

PREFERENCEID

PREFERENCES_CURRENT

PREFERENCEID

SYSID

Not a relationship; used for internal application purposes

UIVIEWID

User

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User

USER

User

USERS_CURRENT
USERS_DAILY_HISTORY
USERS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ACCESSLEVELID

ACCESSLEVELS_CURRENT

ACCESSLEVELID

CATEGORYID

CATEGORIES_CURRENT

CATEGORYID

COMPANYID

COMPANIES_CURRENT

COMPANYID

DEFAULTHOURTYPEID

HOURTYPES_CURRENT

HOURTYPEID

DELEGATIONTOID

USERS_CURRENT

USERID

EAUTHUSERID

Not a relationship; used for internal application purposes

ENTEREDBYID

USERS_CURRENT

USERID

HOMEGROUPID

GROUPS_CURRENT

GROUPID

HOMETEAMID

TEAMS_CURRENT

TEAMID

LASTENTEREDNOTEID

NOTES_CURRENT

NOTEID

LASTUPDATEDBYID

USERS_CURRENT

USERID

LATESTUPDATENOTEID

NOTES_CURRENT

NOTEID

LAYOUTTEMPLATEID

Layout Template table will not be supported

MANAGERID

USERS_CURRENT

USERID

PORTALPROFILEID

Portal Profile table will not be supported

PREFUIID

Not a relationship; used for internal application purposes

PRIVATERATECARDID

RATECARD_CURRENT

RATECARDID

RESOURCEPOOLID

RESOURCEPOOLS_CURRENT

RESOURCEPOOLID

ROLEID

ROLES_CURRENT

ROLEID

SCHEDULEID

SCHEDULES_CURRENT

SCHEDULEID

SYSID

Not a relationship; used for internal application purposes

TIMESHEETPROFILEID

TIMESHEETPROFILES_CURRENT

TIMESHEETPROFILEID

UITEMPLATEID

UITEMPLATES_CURRENT

UITEMPLATEID

USERID

UUMUSERID

Not a relationship; used for internal application purposes

User Delegation

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User Delegation

USRDEL

User Delegation

USERDELEGATIONS_CURRENT
USERDELEGATIONS_DAILY_HISTORY
USERDELEGATIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

FROMUSERID

USERS_CURRENT

USERID

SYSID

Not a relationship; used for internal application purposes

TOUSERID

USERS_CURRENT

USERID

USERDELEGATIONID

User Group

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User Group

Other Groups

USRGPS

User Group

USERSGROUPS_CURRENT
USERSGROUPS_DAILY_HISTORY
USERSGROUPS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

GROUPID

GROUPS_CURRENT

GROUPID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

USERSGROUPID

User Location

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User Location

USRLOC

UserLocation

USERLOCATIONS_CURRENT
USERLOCATIONS_DAILY_HISTORY
USERLOCATIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

CLASSIFIERID

CLASSIFIER_CURRENT

CLASSIFIERID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

USERLOCATIONID

User Role

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User Role

Other Roles

USRROL

User Role

USERSROLES_CURRENT
USERSROLES_DAILY_HISTORY
USERSROLES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

USERROLESETID

USERROLESET_CURRENT

USERROLESETID

USERLOCATIONID

User Preference Value

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

User Pref Value

User Preference

USERPF

User Preference

USERPREFVALUES_CURRENT
USERPREFVALUES_DAILY_HISTORY
USERPREFVALUES_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

USERPREFVALUEID

User Role Set

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UserRoleSet

User Role Set

URSET

UserRoleSet

USERROLESET_CURRENT
USERROLESET_DAILY_HISTORY
USERROLESET_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

PRIMARYROLEID

ROLES_CURRENT

ROLEID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

USERROLESETID

Users Decisions

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

UsersDecisions

Users Decisions

USRDEC

Users Decisions

USERSDECISIONS_CURRENT
USERSDECISIONS_DAILY_HISTORY
USERSDECISIONS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

USERDECISIONID

SYSID

Not a relationship; used for internal application purposes

USERID

USERS_CURRENT

USERID

Work Item

Workfront Entity Name

Interface References

API Reference

API Label

Data Lake Views

WorkItem

Work Item

WRKITM

WorkItem

WORKITEMS_CURRENT
WORKITEMS_DAILY_HISTORY
WORKITEMS_EVENT

Primary/Foreign Key

Type

Related Table

Related Field

ASSIGNMENTID

ASSIGNMENTS_CURRENT

ASSIGNMENTID

OBJID

Variable, based on OBJCODE

The primary key / ID of the object identified in the OBJCODE field

OPTASKID

OPTASKS_CURRENT

OPTASKID

PROJECTID

PROJECTS_CURRENT

PROJECTID

SYSID

Not a relationship; used for internal application purposes

TASKID

TASKS_CURRENT

TASKID

USERID

USERS_CURRENT

USERID

WORKITEMID

Planning view descriptions and relationships

The following tables describe the data views available in the Planning schema in Data Connect. Unlike the Workflow data views, the Planning data views include a full column-by-column description for each view.

Planning data is available in the following views:

FIELD_CURRENT — The current definitions of all fields configured on Planning record types.
FIELD_DAILY_HISTORY — A daily snapshot of field definitions, useful for tracking field configuration changes over time.
FIELD_EVENT — A change log of every event that modifies a field definition.
PLANNINGRECORD_CURRENT — The current state of all Planning records across all workspaces and record types.
PLANNINGRECORD_DAILY_HISTORY — A daily snapshot of Planning record state, useful for trend analysis.
PLANNINGRECORD_EVENT — A change log of every event that modifies a Planning record, useful for point-in-time comparisons.
RECORDTYPE_CURRENT — The current definitions of all record types configured in Planning workspaces.
RECORDTYPE_DAILY_HISTORY — A daily snapshot of record type definitions, useful for tracking record type configuration changes over time.
RECORDTYPE_EVENT — A change log of every event that modifies a record type definition.
REFERENCE_CURRENT — The current state of all cross-object reference connections between Planning records and Workfront (or other external) objects.
WORKSPACE_CURRENT — The current definitions of all Planning workspaces.
WORKSPACE_DAILY_HISTORY — A daily snapshot of workspace definitions, useful for tracking workspace configuration changes over time.
WORKSPACE_EVENT — A change log of every event that modifies a workspace definition.

NOTE

The following views are available in the Planning schema but are not described in detail here. They follow the same column patterns as their corresponding CURRENT views, with the addition of standard history and event audit fields.

The views are:

DAILY_HISTORY views
EVENT views (FIELD_DAILY_HISTORY, FIELD_EVENT, PLANNINGRECORD_DAILY_HISTORY, PLANNINGRECORD_EVENT, RECORDTYPE_DAILY_HISTORY, RECORDTYPE_EVENT, WORKSPACE_DAILY_HISTORY, and WORKSPACE_EVENT)

FIELD_CURRENT

Contains the current definitions of all fields configured on Workfront Planning record types. Each row represents one field, including its display name, type, and type-specific configuration stored in structured Variant (JSON) columns. Use this view to resolve field IDs from PLANNINGRECORD_CURRENT into human-readable field names and metadata.

Column Name

Type

Description

Related Table

Related Field

`ID`

Varchar

The unique identifier for the field definition. Primary key for this view.

—

`RECORDTYPEID`

Varchar

The unique identifier of the record type this field belongs to. Use with RECORDTYPE\_CURRENT to look up record type details.

RECORDTYPE\_CURRENT

`DISPLAYNAME`

Varchar

The display name of the field as shown in the Planning interface.

—

`ALIASNAME`

Varchar

A URL-safe, lowercase version of the field's display name, used for system-level identification and API access (e.g., "End Date" becomes `end_date`, "Percent Complete" becomes `percent_complete`).

—

`DESCRIPTION`

Varchar

A user-provided description of the field's purpose.

—

`FIELDTYPE`

Varchar

The data type or field category. Possible values include: `text`, `long-text`, `number`, `percentage`, `currency`, `date`, `boolean`, `single-select`, `multi-select`, `reference`, `lookup`, `formula`, `user`, `created-at`, and `created-by`.

—

`HASERROR`

Varchar

Indicates whether the field currently has a configuration or sync error. Values are the strings `true` or `false`. A value of `true` means the field is in an error state and may not be returning data correctly.

—

`LINKEDFIELD`

Variant

A JSON object containing the full field definition of the source field that this field is linked to. Present for `reference` and `lookup` field types; includes properties such as `alias`, `displayName`, `fieldType`, and `createdAt`. Null for non-linked fields.

FIELD\_CURRENT

`OPTIONS`

Variant

A JSON array of choice objects for `single-select` and `multi-select` fields. Each choice object contains `color` (a named color label), `displayName` (the label shown in the UI), and `name` (the internal API name). Null for non-select field types.

—

`DATEOPTIONS`

Variant

A JSON object containing date-specific display configuration for `date` fields. Includes `dateFormat` (e.g., `locale`) and `timeFormat` (null if time is not shown). Null for non-date field types.

—

`FORMULAOPTIONS`

Variant

A JSON object containing formula configuration for `formula` fields. Includes `formula` (the human-readable formula expression), `returnType` (e.g., `PERCENTAGE`, `NUMBER`), `numberOptions` (precision, visualization), and `dateOptions`. Null for non-formula fields.

—

`REFERENCEOPTIONS`

Variant

A JSON object containing connection configuration for `reference` fields that link to other Planning record types. Includes `backField` (the definition of the reverse reference field on the connected record type) and `linkedRecordTypeId`. Null for non-reference fields.

—

`LOOKUPOPTIONS`

Variant

A JSON object containing lookup configuration for `lookup` fields that pull values from a connected record type. Includes `referenceFieldId` (the ID of the reference field driving the lookup), `rollup` (aggregation method, or null for no rollup), and `sourceField` (an object with the `id` of the field being looked up). Null for non-lookup fields.

—

`NUMBEROPTIONS`

Variant

A JSON object containing numeric formatting options for `number`, `percentage`, and `currency` fields. Includes `allowNegatives` (boolean), `currency` (currency code or null), `precision` (decimal places), and `visualizationType` (display style, or null for plain text). Null for non-numeric field types.

—

`EXTERNALOPTIONS`

Variant

A JSON object containing configuration for fields connected to external systems outside of Planning. Typically null for natively created fields; populated for fields on externally connected record types.

—

`CREATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this field was created.

—

`CREATEDBY`

Varchar

The identifier of the user who created this field.

WF.USERS\_CURRENT

EAUTHUSERID

`UPDATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this field was last updated.

—

`UPDATEDBY`

Varchar

The identifier of the user who last updated this field.

WF.USERS\_CURRENT

EAUTHUSERID

`USERID`

Varchar

The identifier of the user associated with this field, typically the field owner.

WF.USERS\_CURRENT

EAUTHUSERID

`CREATED`

Number

A flag indicating the last operation type that affected this field record. A value of 1 indicates the record was created in the most recent data refresh cycle; 0 indicates it was not. See CREATEDAT for the actual creation timestamp.

—

`UPDATED`

Number

A flag indicating the last operation type that affected this field record. A value of 1 indicates the record was updated in the most recent data refresh cycle; 0 indicates it was not. See UPDATEDAT for the actual last-updated timestamp.

—

`DELETED`

Number

A flag indicating whether this field has been soft-deleted. A value of 1 indicates deleted; 0 indicates active.

—

`RESTORED`

Number

A flag indicating whether this field was restored after being soft-deleted.

—

`TRIGGEREDBYSERVICE`

Varchar

The name of the service or integration that triggered the last modification to this field record. A value of `Unknown` indicates the originating service could not be determined.

—

`ISFUSION`

Boolean

A flag indicating whether this field was created or managed through a Workfront Fusion integration. A value of `true` indicates Fusion management; `false` or an empty value indicates it is a natively created field.

—

`DL_LOAD_TIMESTAMP`

Timestamp\_NTZ

The timestamp of the data refresh job that last loaded this field record into the data lake. Updated after each successful data refresh cycle.

—

PLANNINGRECORD_CURRENT

Contains the current state of all records created in Workfront Planning, across all workspaces and record types. Each row represents one Planning record, with field values stored in structured Variant (JSON) columns that reflect the dynamic, schema-flexible nature of Planning data.

Column Name

Type

Description

Related Table

Related Field

`RECORDID`

Varchar

The unique identifier for the Planning record. Primary key for this view.

WF.PLANNINGRECORDS\_CURRENT

RECORDID

`WORKSPACEID`

Varchar

The unique identifier for the Planning workspace that contains this record.

WORKSPACE\_CURRENT

`WORKSPACENAME`

Varchar

The display name of the Planning workspace that contains this record.

—

`RECORDTYPEID`

Varchar

The unique identifier for the record type (e.g., Campaign, Initiative) that this record belongs to.

RECORDTYPE\_CURRENT

`RECORDTYPENAME`

Varchar

The display name of the record type that this record belongs to.

—

`FIELD_IDS`

Variant

A JSON object mapping each field's display name to its field ID (e.g., `{"Status": "F69bc...", "End Date": "F69bc..."}`). Use this to map human-readable field names to the IDs used in FIELDID\_VALUES and FIELDID\_VALUES\_RAW.

—

`FIELD_VALUES_RAW`

Variant

A JSON object mapping each field's display name to its raw (unformatted) value. For reference fields, the value is an array of connected record objects; for number and formula fields, it is a plain numeric value; for long-text fields, it is a rich-text content object. Keyed by field display name, matching FIELD\_IDS.

—

`FIELD_VALUES`

Variant

A JSON object mapping each field's display name to its display-formatted string value. Keyed by field display name, matching FIELD\_IDS.

—

`FIELD_TYPES`

Variant

A JSON object mapping each field's display name to its field type string (e.g., `text`, `number`, `date`, `single-select`, `reference`, `formula`). Keyed by field display name, matching FIELD\_IDS.

—

`FIELDID_VALUES`

Variant

A JSON object mapping each field ID to its display-formatted value. For simple field types the value is a string or number; for long-text fields it is an object containing both `content` (plain text) and `contentHTML` (HTML-formatted) properties. Use FIELD\_IDS to look up the display name for each field ID.

—

`FIELDID_VALUES_RAW`

Variant

A JSON object mapping each field ID to its raw (unformatted) value. For most field types, values are plain strings, numbers, or epoch millisecond timestamps. Long-text fields return the plain text content as a string. Use FIELD\_IDS to look up the display name for each field ID.

—

`FIELDID_FIELDID`

Variant

A JSON object that lists all field IDs present on this record as a self-mapping (each field ID maps to itself). Use this to enumerate which fields are populated on a given record, or to cross-reference with FIELD\_CURRENT.

—

`REFERENCE_IDS`

Variant

A JSON object mapping each reference field's display name to the ID of the connection record (e.g., `{"Project": "Ref8b471aa..."}`). Use in conjunction with REFERENCE\_CURRENT to resolve connected external objects for this record.

—

`CREATED`

Number

A flag indicating the last operation type that affected this record. A value of 1 indicates the record was created in the most recent data refresh cycle; 0 indicates it was not. See CREATEDAT for the actual creation timestamp.

—

`UPDATED`

Number

A flag indicating the last operation type that affected this record. A value of 1 indicates the record was updated in the most recent data refresh cycle; 0 indicates it was not. See UPDATEDAT for the actual last-updated timestamp.

—

`DELETED`

Number

A flag indicating whether this record has been soft-deleted. A value of 1 indicates the record is deleted; 0 indicates it is active.

—

`CREATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record was created.

—

`CREATEDBY`

Varchar

The identifier of the user who created this record.

WF.USERS\_CURRENT

EAUTHUSERID

`UPDATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record was last updated.

—

`UPDATEDBY`

Varchar

The identifier of the user who last updated this record.

WF.USERS\_CURRENT

EAUTHUSERID

`DL_LOAD_TIMESTAMP`

Timestamp\_NTZ

The timestamp of the data refresh job that last loaded this record into the data lake. Updated after each successful data refresh cycle.

—

RECORDTYPE_CURRENT

Contains the current definitions of all record types configured in Workfront Planning workspaces. Each row represents one record type, including its display name, workspace association, primary field, and configuration metadata. Use this view to resolve record type IDs from PLANNINGRECORD_CURRENT and FIELD_CURRENT into human-readable names.

Column Name

Type

Description

Related Table

Related Field

`ID`

Varchar

The unique identifier for the record type. Primary key for this view.

—

`CREATED`

Number

A flag indicating the last operation type that affected this record type. A value of 1 indicates the record type was created in the most recent data refresh cycle; 0 indicates it was not. See CREATEDAT for the actual creation timestamp.

—

`UPDATED`

Number

A flag indicating the last operation type that affected this record type. A value of 1 indicates the record type was updated in the most recent data refresh cycle; 0 indicates it was not. See UPDATEDAT for the actual last-updated timestamp.

—

`DELETED`

Number

A flag indicating whether this record type has been soft-deleted. A value of 1 indicates deleted; 0 indicates active.

—

`DL_LOAD_TIMESTAMP`

Timestamp\_NTZ

The timestamp of the data refresh job that last loaded this record type into the data lake. Updated after each successful data refresh cycle.

—

`CREATEDBY`

Varchar

The identifier of the user who created this record type.

WF.USERS\_CURRENT

EAUTHUSERID

`CREATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record type was created.

—

`UPDATEDBY`

Varchar

The identifier of the user who last updated this record type.

WF.USERS\_CURRENT

EAUTHUSERID

`UPDATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record type was last updated.

—

`USERID`

Varchar

The identifier of the user associated with this record type, typically the owner.

WF.USERS\_CURRENT

EAUTHUSERID

`WORKSPACEID`

Varchar

The unique identifier of the workspace this record type belongs to. Use with WORKSPACE\_CURRENT to look up workspace details.

WORKSPACE\_CURRENT

`DISPLAYNAME`

Varchar

The display name of the record type as shown in the Planning interface (e.g., "Campaign", "Initiative").

—

`DESCRIPTION`

Varchar

A user-provided description of the record type's purpose.

—

`COLOR`

Varchar

A named color label associated with this record type in the Planning interface (e.g., `blue`, `green`, `purple`, `magenta`, `chartreuse`, `dark-gray`). Not a hex code.

—

`PERMISSION`

Varchar

The permission level configured for access to this record type (e.g., `VIEW`, `CONTRIBUTE`, `MANAGE`). May be empty if no custom permission is set.

—

`PRIMARYFIELDID`

Varchar

The identifier of the field designated as the primary (title) field for this record type. Foreign key to FIELD\_CURRENT.ID.

FIELD\_CURRENT

`ISTAXONOMY`

Varchar

Indicates whether this record type is classified as a taxonomy type, used to organize and categorize other records. A value of `true` indicates a taxonomy type. May be empty for non-taxonomy record types.

—

`PERMISSION`

Varchar

The permission level configured for access to this record type (e.g., `VIEW`, `CONTRIBUTE`, `MANAGE`). May be empty if no custom permission is set.

—

`PRIMARYFIELDID`

Varchar

The identifier of the field designated as the primary (title) field for this record type. Foreign key to FIELD\_CURRENT.ID.

FIELD\_CURRENT

`ISTAXONOMY`

Varchar

—

`ISEXTERNAL`

Boolean

A flag indicating whether this record type represents an externally connected object type rather than a native Planning record.

—

`EXTERNALOPTIONS`

Variant

A JSON object containing configuration details for record types connected to external systems. Includes `connectionName` (e.g., `workfront`), `objectName` (the Workfront API object code, e.g., `PROJ`), and `fields` (a map of standard field aliases to Planning field IDs for the synced fields). Null for natively created record types.

—

`RESTORED`

Number

A flag indicating whether this record type was restored after being soft-deleted.

—

`ALIAS`

Varchar

An internal alias for the record type, used for system-level identification and API access. May be empty for record types that have not been assigned an alias.

—

`TRIGGEREDBYSERVICE`

Varchar

The name of the service or integration that triggered the last modification to this record type. A value of `Unknown` indicates the originating service could not be determined.

—

`ISFUSION`

Boolean

A flag indicating whether this record type was created or managed through a Workfront Fusion integration. A value of `true` indicates Fusion management; `false` or an empty value indicates it is a natively created record type.

—

`CREATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record type was created.

—

`CREATEDBY`

Varchar

The identifier of the user who created this record type.

WF.USERS\_CURRENT

EAUTHUSERID

`UPDATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this record type was last updated.

—

`UPDATEDBY`

Varchar

The identifier of the user who last updated this record type.

WF.USERS\_CURRENT

EAUTHUSERID

`USERID`

Varchar

The identifier of the user associated with this record type, typically the owner.

WF.USERS\_CURRENT

EAUTHUSERID

`TO_RECORDID`

Varchar

The unique identifier of the Planning record that owns this reference connection. Foreign key to PLANNINGRECORD\_CURRENT.RECORDID.

PLANNINGRECORD\_CURRENT

RECORDID

`TO_EXTERNALID`

Varchar

The unique identifier of the external object being referenced (e.g., a Workfront project ID, task ID, or other connected object ID).

—

`TO_EXTERNALCONNECTIONNAME`

Varchar

The name of the external connection through which the referenced object is connected (e.g., the name of the Workfront connection configured in Planning).

—

`TO_EXTERNALOBJECTNAME`

Varchar

The Workfront API object code for the type of external object being referenced (e.g., `PROJ` for Project, `TASK` for Task, `PORT` for Portfolio). Use this to determine which Workfront table to join when looking up the referenced object.

—

`RECORDTYPEID`

Varchar

The unique identifier of the Planning record type associated with the record that owns this reference. Foreign key to PLANNINGRECORD\_CURRENT.RECORDTYPEID.

RECORDTYPE\_CURRENT

`REFERENCEVALUE`

Varchar

The display name of the referenced external object as of the last data refresh (e.g., a Workfront project name like "Beta" or "Canvas Dashboards Project"). This value reflects the object's name at refresh time and may become stale if the object is renamed.

—

`CREATED`

Number

A flag indicating the last operation type that affected this reference record. A value of 1 indicates the reference was created in the most recent data refresh cycle; 0 indicates it was not.

—

`UPDATED`

Number

A flag indicating the last operation type that affected this reference record. A value of 1 indicates the reference was updated in the most recent data refresh cycle; 0 indicates it was not.

—

`DELETED`

Number

A flag indicating whether this reference connection has been soft-deleted. A value of 1 indicates the reference is deleted; 0 indicates it is active.

—

`DL_LOAD_TIMESTAMP`

Timestamp\_NTZ

The timestamp of the data refresh job that last loaded this reference record into the data lake. Updated after each successful data refresh cycle.

—

WORKSPACE_CURRENT

Contains the current definitions of all Workfront Planning workspaces. Each row represents one workspace, including its name, hierarchy, and ownership metadata. Use this view to resolve workspace IDs from PLANNINGRECORD_CURRENT and RECORDTYPE_CURRENT into human-readable workspace names.

Column Name

Type

Description

Related Table

Related Field

`ID`

Varchar

The unique identifier for the Planning workspace. Primary key for this view.

WF.WORKSPACES\_CURRENT

`CREATED`

Number

A flag indicating the last operation type that affected this workspace record. A value of 1 indicates the workspace was created in the most recent data refresh cycle; 0 indicates it was not. See CREATEDAT for the actual creation timestamp.

—

`UPDATED`

Number

A flag indicating the last operation type that affected this workspace record. A value of 1 indicates the workspace was updated in the most recent data refresh cycle; 0 indicates it was not. See UPDATEDAT for the actual last-updated timestamp.

—

`DELETED`

Number

A flag indicating whether this workspace has been soft-deleted. A value of 1 indicates deleted; 0 indicates active.

—

`DL_LOAD_TIMESTAMP`

Timestamp\_NTZ

The timestamp of the data refresh job that last loaded this workspace record into the data lake. Updated after each successful data refresh cycle.

—

`CREATEDBY`

Varchar

The identifier of the user who created this workspace.

WF.USERS\_CURRENT

EAUTHUSERID

`CREATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this workspace was created.

—

`UPDATEDBY`

Varchar

The identifier of the user who last updated this workspace.

WF.USERS\_CURRENT

EAUTHUSERID

`UPDATEDAT`

Timestamp\_NTZ

The timestamp (no timezone) of when this workspace was last updated.

—

`USERID`

Varchar

The identifier of the user associated with this workspace, typically the workspace owner.

WF.USERS\_CURRENT

EAUTHUSERID

`NAME`

Varchar

The display name of the workspace as shown in the Planning interface.

—

`PARENTID`

Varchar

The identifier of the parent workspace if this workspace is nested within a workspace hierarchy. Empty if this workspace has no parent (i.e., it is a top-level workspace).

WORKSPACE\_CURRENT

`RESTORED`

Number

A flag indicating whether this workspace was restored after being soft-deleted.

—

`TRIGGEREDBYSERVICE`

Varchar

The name of the service or integration that triggered the last modification to this workspace record. A value of `Unknown` indicates the originating service could not be determined.

—

`ISFUSION`

Boolean

A flag indicating whether this workspace was created or managed through a Workfront Fusion integration. A value of `true` indicates Fusion management; `false` or an empty value indicates it is a natively created workspace.

—

recommendation-more-help

workfront-help-quicksilver

Workfront Data Connect data dictionary

View types

Entity relationship diagrams

Example entity relationship diagrams

Assignments

Documents and document approvals

Hours and Timesheets

Issues

Projects

Tasks

Users

Date types

Workfront terminology table and descriptions

Access Level

Access Rule

Approval Path

Approval Process

Approval Step

Approver Status

Assignment

Awaiting Approvals

Baseline

Baseline Task

Billing Rate

Billing Record

Booking

Business Profile

Business Rule

Category

Category Parameter

Classifier

Company

Custom Quarter

Custom Enum

Document

Document Approval

Document Approval (NEW)

Document Approval Stage (NEW)

Document Approval Stage Participants (NEW)

Document Folder

Document Provider Metadata

Document Provider

Document Provider Config

Document Version

Exchange Rate

Expense

Expense Type

Group

Hour

Hour Type

Iteration

Journal Entry

Linked Folder

Milestone

Milestone Path

Non-Labor Resource

Non-Labor Resource Category

Non-Work Day

Note

Object Integration

Objects Category

OpTask / Issue

Parameter

Parameter Group

Parameter Option

Portal Section / Report

Portal Tab / Dashboard

Portal Tab Section

Portal Section Last Viewer

Portfolio

Preference

Program

Project

Project Team User

Project Team User Role

Rate Card

Report Folder

Report View Statistic Count

Reportable Budgeted Hours

Reserved Time / PTO