Data Services

This section provides a comparison between Primavera Data Service and Primavera Cloud Data Service.

The table lists Primavera Data Service services in alphabetical order, with any corresponding Primavera Cloud API provided in the Closest Corresponding Primavera Cloud Data Service column. In some cases, multiple Primavera Data Service services all correspond to the same Primavera Cloud API, In such cases, the Primavera Cloud API appears on multiple rows of the table, against each corresponding Primavera Data Service service.

Primavera Cloud Data Service is a robust REST API that provides an extensive list of endpoints. Many of the endpoints are for features not available in P6 EPPM. For information about the full list of Primavera Cloud Data Service endpoints, see Primavera Cloud Data Service API.

Primavera Data Service

Closest Corresponding Primavera Cloud Data Service

Notes

AC_PROJRSRCROLELIST

RM_RESOURCE

In P6 EPPM, project level resources are stored in a separate table from activity level resources.

In Primavera Cloud resources can be assigned to projects, workspaces, or activities.

ACTIVITYCODEHIERARCHY

CO_CODE_VAL

See note 1

ACTIVITYCODETYPESECURITY

 

 

ACTIVITYSPREAD

 

 

ACTVCODE

CO_CODE_TYPE_TABLE

See note 1

ACTVCODEX

 

 

ACTVTYPE

 

 

ADDTASKPROC

 

Primavera Cloud does not support Activity Steps.

Tasks are the closest equivalent.

ADDTASKPROCX

 

 

ADDTRSRC

SM_ASSIGNMENT

 

ALERT

 

 

ALERTPARAM

 

 

ANNOUNCEMENT

 

 

ANNOUNCEMENT_USER

 

 

ARBITER_COUNTER

 

 

ATTR_MASTER

 

 

AUTOVUE_ATTR

 

 

BASETYPE

 

 

BGPLOG

 

 

BUDGCHNG

 

 

BUDGCHNGX

 

 

CALENDAR

CO_CALENDAR

 

CALENDARX

 

 

CBS

 

 

CHGHEAD

 

 

CHGTASK

 

 

CHGTASKACTV

 

 

CHGTASKACTVX

 

 

CHGTASKMEMO

 

 

CHGTASKMEMOX

 

 

CHGTASKPROC

 

 

CHGTASKPROCX

 

 

CHGTASKX

 

 

CHGTRSRC

 

 

CHGTRSRCX

 

 

CHGUDFVALUE

 

 

CHGUDFVALUEX

 

 

COSTACCOUNTHIERARCHY

 

Primavera Cloud does not support Cost Accounts. The CBS is the closest equivalent.

COSTSECURITY

 

 

COSTTYPE

 

 

CURRTYPE

 

 

CURRTYPEX

 

 

DASHBOARD

 

 

DASHUSER

 

 

DBERRLOG

 

 

DELTASKPROC

 

Primavera Cloud does not support Activity Steps. Tasks are the closest equivalent.

DELTASKPROCX

 

 

DISCUSSION

 

 

DISCUSSION_READ

 

 

DM_ATTR

 

 

DOC

 

 

DOC_FOLDER

 

 

DOC_RECENT

 

.

DOC_VERSION

 

 

DOCCATG

 

 

DOCREVIEW

 

 

DOCREVIEWTASK

 

 

DOCSTAT

 

 

DOCUMENT

 

 

DOCUMENT_MAPPER

 

 

DOCUMENTX

 

 

EPSHIERARCHY

WS_WORKSPACE

Primavera Cloud does not support the Enterprise Project Structure.

Workspaces are the closest equivalent.

EPSSPREAD

 

 

EXPPROJ

 

 

EXTAPP

 

 

 

FACTOR

 

 

FACTVAL

 

 

FILTPROP

 

 

FINDATES

 

The closest corresponding functionality in Primavera Cloud is Reporting Cycles.

FINTMPL

 

The closest corresponding functionality in Primavera Cloud is Reporting Cycles.

FORMCATG

 

 

FORMPROJ

 

 

FORMTMPL

 

 

FUNDSRC

CP_PROJ_FUND

Primavera Cloud supports Funding, but the functionality is very different from P6 EPPM.

GATEWAYDEPLOYMENT

 

 

GATEWAYPROVIDER

 

 

GATEWAYSYNCACTION

 

 

GCHANGE

 

 

GLOBALSECURITY

 

 

GREPLACE

 

 

GTT_PKLIST

 

 

HQDATA

 

 

HQUERY

 

 

IMAGEDATA

 

 

ISSUHIST

 

 

ITERATION

 

 

ITERTASK

 

 

ITERTEAM

 

 

JOBLOG

 

 

JOBPROJ_LKP

 

 

JOBRPT

 

 

JOBSET

 

 

JOBSVC

 

 

LEANTASK

LN_TASK

 

LOCATION

CO_LOCATION

 

MEMOTYPE

 

 

MTXSCRTYP

RSK_MATRIX_SCR_TYPE

 

NEXTKEY

 

 

NONWORK

 

The corresponding functionality in Primavera Cloud is Hour Types.

NOTE

 

 

OBS

 

 

OBSPROJ

 

 

OPENING_ACCOUNT

 

 

OPENING_ACTVCODE

 

 

OPENING_OBS

 

 

OPENING_ROLE

 

 

OPENING_RSRC

 

 

OPENING_RSRCROLE

 

 

OPENING_USERS

 

 

P6_CERTS

 

 

P6_KEYS

 

 

PAUDIT

 

 

PAUDITX

 

 

PC_KEY_XREF

 

 

PC_PROCESS_STAT

 

 

PCATTYPE

CO_CODE_TYPE_TABLE

See note 1

PCATUSER

 

 

PCATUSERX

 

 

PCATVAL

CO_CODE_VAL

See note 1

PCATVALX

 

 

PFLOAD_IP_UACCESS_VIEW

 

 

PFLOAD_IP_VIEW

 

 

PFLOAD_UACCESS_VIEW

 

 

PFLOAD_VIEW

 

 

PFOLIO

CP_PORTFOLIO

 

PFOLIOUSER

 

 

PFOLIOX

 

See note 3

PHASE

 

Primavera Cloud does not support WBS Categories. Codes are the closest equivalent.

PKXREF

 

 

PLPROJREF

 

 

POBS

 

 

PRMQUEUE

 

 

PROCGROUP

 

 

PROCITEM

 

 

PROFILE

 

 

PROFPRIV

 

 

PROFPRIVX

 

See note 3

PROJCOST

 

 

PROJCOSTX

 

 

PROJDEPLMENT

 

 

PROJECT

CO_PROJECT

 

PROJECT_ETL_LIST

 

 

PROJECTCODEHIERARCHY

CO_CODE_VAL

See note 1

PROJECTCOSTCBSSPREAD

 

 

PROJECTSECURITY

PROJECTSECURITY

 

PROJECTSPREAD

 

 

PROJECTX

 

See note 3

PROJEST

 

 

PROJFUND

CP_PROJ_FUND

See note 2

PROJFUNDX

 

 

PROJISSU

 

Primavera Cloud does not support Issues.

Custom Logs can be used to track an Issue Log.

PROJISSUX

 

 

PROJPCAT

CO_CODE_TYPE_TABLE

See note 1

PROJPCATX

 

 

PROJPROP

CO_PROJECT

 

PROJRISK

RISK_ACTIVITY, RSK_ACTV_QT_OTHR_IMPCT, RISK_PROJECT

Although these tables in Primavera Cloud and P6 EPPM are used to manage the same type of information, the two products differ significantly in how they manage this data.

PROJROLE_PS_VIEW

 

 

PROJROLE_VIEW

 

 

PROJRSRC_PS_VIEW

 

 

PROJRSRC_VIEW

 

 

PROJRSRCROLE_PS_VIEW

 

 

PROJRSRCROLE_VIEW

 

 

PROJSET

CO_PROJECT

 

PROJSHAR

 

 

PROJSHAR_BL_VIEW

 

 

PROJTHRS

 

The cloest corresponding functionality in Primavera Cloud is Project Alerts.

PROJWBS

CO_WBS

 

PROJWBSX

 

See note 3

PROJWSRPT

 

 

PRPFOLIO

 

 

PXJOBRUN

 

 

QUERYLIB

 

 

RCATTYPE

CO_CODE_TYPE_TABLE

See note 1

RCATVAL

CO_CODE_VAL

See note 1

RCATVALX

 

See note 3

REFRDEL

 

 

REITTYPE

 

 

RELEASE

 

 

RELITEMS

 

 

RELITER

 

 

RELPROJ

 

 

REPORTDATE

 

 

REPORTTIME

 

 

RESOURCEASSIGNMENTCBSSPREAD

 

 

RESOURCEASSIGNMENTSPREAD

 

 

RESOURCECODEHIERARCHY

CO_CODE_VAL

See note 1

RESOURCEHIERARCHY

RM_RESOURCE

 

RESOURCELIMIT

RM_RESOURCE

 

RESOURCEUSAGE

 

 

RFOLIO

CP_PORTFOLIO

 

RFOLIOX

 

See note 3

RISK

RSK_PROJECT

 

RISKCTRL

 

 

RISKIMPACT

 

 

RISKMIT

RSK_MITIGATION

 

RISKMITIMP

 

 

RISKMITX

 

See note 3

RISKMTXSCR

RSK_MATRIX_SCORE

 

RISKRSPPLN

 

 

RISKRSPPLNX

 

See note 3

RISKSCRMTX

 

See note 3

RISKSCRTHR

RSK_SCORE_THRESHOLD

 

RISKSCRTYP

RSK_SCORE_TYPE

 

RISKTYPE

RSK_CATEGORY

 

RISKX

 

See note 3

RLFOLIO

CP_PORTFOLIO

 

RLFOLIOX

 

See note 3

ROLECATTYPE

CO_CODE_TYPE_TABLE

See note 1

ROLECATVAL

CO_CODE_VAL

See note 1

ROLECATVALX

 

See note 3

ROLECODEHIERARCHY

CO_CODE_VAL

See note 1

ROLELIMIT

RM_RESOURCE

See note 4

ROLERATE

RM_RESOURCE

See note 4

ROLERATEX

 

See note 3

ROLERCAT

CO_CODE_VAL_RESOURCE

See note 4

ROLERCATX

 

See note 3

ROLES

RM_RESOURCE

See note 4

ROLFOLIO

 

 

RPT

 

 

RPTBATCH

 

 

RPTGROUP

 

 

RPTLIST

 

 

RSRC

RM_RESOURCE

See note 4

RSRCANDASH

 

 

RSRCANVIEW

 

 

RSRCCURV

 

 

RSRCCURVX

 

See note 3

RSRCHOUR

 

 

RSRCHOURX

 

See note 3

RSRCLOC

RM_RESOURCE

 

RSRCOVERALLOC

 

 

RSRCPROP

 

 

RSRCRATE

 

 

RSRCRATEX

 

See note 3

RSRCRCAT

CO_CODE_VAL_RESOURCE

 

RSRCRCATX

 

See note 3

RSRCROLE

RM_ROLE_ASSIGNMENT

See note 4

RSRCROLEASGNMENTSPREAD

 

 

RSRCROLEX

 

See note 3

RSRCSEC

 

 

RSRCSECX

 

See note 3

RSRCX

 

See note 3

RSRFOLIO

 

 

SAFETYDATE

 

 

SCENARIO

 

 

SCENPROJ

SM_SCHEDULE_SCENARIO

Although Schedule Scenarios in Primavera Cloud and What If projects in P6 EPPM are used to manage the same type of information, the two products differ significantly in functionality and how they manage this data.

SCENROLE

 

 

SCENUSER

 

 

SHIFT

 

 

SHIFTPER

 

 

SNAPGROUP

 

 

SNAPPROJ

 

 

SNAPSHOT

 

 

SPIDMAP

 

 

SUMPROJCOST

CO_PROJECT_COST

Although both Primavera Cloud and P6 EPPM allow summarization of costs, the two products differ significantly in functionality and how they manage this data.

SUMTASK

 

 

SUMTASKSPREAD

 

 

SUMTRSRC

 

 

SYNC$SYS_NUMLIST

 

 

SYNC$SYS_STRLIST

 

 

TASK

SM_ACTIVITY

 

TASKACTV

CO_CODE_VAL_ACTIVITY

 

TASKACTVX

 

See note 3

TASKCBSX

 

 

TASKDOC

 

 

TASKDOCX

 

See note 3

TASKFDBK

 

See note 3

TASKFIN

SM_ACTIVITY

Although Reporting Cycles in Primavera Cloud and Financial Periods in P6 EPPM are used to manage the same type of information, the two products differ significantly in functionality and how they manage this data.

Only the most recent period values can be extracted from this table in Primavera Cloud.

TASKFINX

 

See note 3

TASKMEMO

 

 

TASKMEMOX

 

See note 3

TASKNOTE

 

 

TASKPRED

SM_RELATIONSHIP

 

TASKPREDX

 

See note 3

TASKPROC

 

Primavera Cloud does not have steps. Tasks are the closest equivalent.

TASKPROCX

 

See note 3

TASKRISK

RISK_ACTIVITY

 

TASKRISKX

 

See note 3

TASKRSRC

RM_ASSIGNMENT

 

TASKRSRCX

 

See note 3

TASKSUM

 

 

TASKSUMFIN

 

 

TASKUSER

 

 

TASKWKSP

 

 

TASKX

 

See note 3

TEMPKEYS

 

 

THRSPARM

 

The closest corresponding functionality in Primavera Cloud is Project Alerts.

TIMESHT

 

 

TIMESHTX

 

See note 3

TMPLCATG

 

 

TPROJMAP

 

 

TRACKOFFLINEUSER

 

 

TRAKVIEW

 

 

TRSRCFIN

 

The closest corresponding functionality in Primavera Cloud is Reporting Cycles.

TRSRCFINX

 

See note 3

TRSRCSUM

 

 

TRSRCSUMFN

 

 

TSAUDIT

 

.

TSDATES

 

 

TSDELEGATE

 

 

UACCESS

PROJECTSECURITY

 

UDFCODE

FD_COLUMN

UDFs are called Configured Fields in Primavera Cloud.

UDFCODEX

 

See note 3

UDFTYPE

FD_COLUMN

UDFs are called Configured Fields in Primavera Cloud.

UDFVALUE

CO_PROJECT_CP_UF, SM_ACTIVITY_UF, SM_ASSIGNMENT_UF, PR_COMPANY_UF, CO_WBS_UF, LN_TASK_UF

Primavera Cloud does not store assigned/entered configured field values in one centralized table. They are stored in individual tables that correspond to the main object, but these tables only store configured field data, For example, configured field values for the project object are stored in CO_PROJECT_CP_UF.

Primavera Cloud supports configured fields for more objects than are exposed to the Primavera Cloud Data Service. The data service exposes configured fields for projects, activities, resource assignments, companies, workspaces, and tasks.

UDFVALUEX

 

See note 3

UEVNTREG

 

 

UMEASURE

 

 

UPKLIST

 

 

USER_ACCEPTANCE_CONSENT

 

 

USERCOL

 

 

USERDATA

 

 

USERENG

 

 

USEROBS

 

 

USEROBSX

 

 

USEROPEN

 

 

USERS

USERS

 

USERSET

 

 

USERSX

 

See note 3

USERWKSP

 

 

Although a feature called Workspaces exists in both P6 EPPM and Primavera Cloud, the two features serve different purposes.

 

To extract user assignment to workspaces from Primavera Cloud, use the WORKSPACESECURITY table. See Primavera Cloud Data Service API.

USESSAUD

 

 

USESSION

 

 

USROPNVAL

 

 

VIEWPREF

 

 

VIEWPROP

 

 

VWPREFDASH

 

 

VWPREFDATA

 

 

VWPREFUSER

 

 

WBRSCAT

 

 

WBSBUDG

 

 

WBSBUDGX

 

 

WBSHIERARCHY

CO_WBS

 

WBSMEMO

 

 

WBSMEMOX

 

 

WBSREVIEWERS

 

 

WBSREVIEWSTATUS

 

 

WBSRSRC

 

 

WBSRSRC_ASSGN_BY_PROJ_BY_MONTH

 

 

WBSRSRC_ASSGN_BY_PROJ_BY_QTR

 

 

WBSRSRC_ASSGN_BY_PROJ_BY_WEEK

 

 

WBSRSRC_ASSGN_BY_PROJ_BY_YEAR

 

 

WBSRSRC_ASSGN_BY_PROJROLE_MON

 

 

WBSRSRC_ASSGN_BY_PROJROLE_QTR

 

 

WBSRSRC_ASSGN_BY_PROJROLE_WEEK

 

 

WBSRSRC_ASSGN_BY_PROJROLE_YEAR

 

 

WBSRSRC_ASSGN_BY_PROJRSRC_MON

 

 

WBSRSRC_ASSGN_BY_PROJRSRC_QTR

 

 

WBSRSRC_ASSGN_BY_PROJRSRC_WEEK

 

 

WBSRSRC_ASSGN_BY_PROJRSRC_YEAR

 

 

WBSRSRC_ASSGN_BY_ROLE_BY_MONTH

 

 

WBSRSRC_ASSGN_BY_ROLE_BY_QTR

 

 

WBSRSRC_ASSGN_BY_ROLE_BY_WEEK

 

 

WBSRSRC_ASSGN_BY_ROLE_BY_YEAR

 

 

WBSRSRC_ASSGN_BY_RSRC_BY_MONTH

 

 

WBSRSRC_ASSGN_BY_RSRC_BY_QTR

 

 

WBSRSRC_ASSGN_BY_RSRC_BY_WEEK

 

 

WBSRSRC_ASSGN_BY_RSRC_BY_YEAR

 

 

WBSRSRC_ASSGN_SUMMARY_BY_MON

 

 

WBSRSRC_ASSGN_SUMMARY_BY_QTR

 

 

WBSRSRC_ASSGN_SUMMARY_BY_WEEK

 

 

WBSRSRC_ASSGN_SUMMARY_BY_YEAR

 

 

WBSRSRC_ASSN_BY_PROJ_BY_FP

 

 

WBSRSRC_ASSN_BY_PROJROLE_BY_FP

 

 

WBSRSRC_ASSN_BY_PROJRSRC_BY_FP

 

 

WBSRSRC_ASSN_SUMMARY_BY_FP

 

 

WBSRSRC_QTY

 

 

WBSRSRC_QTYX

 

 

WBSRSRCX

 

 

WBSSPREAD

 

 

WBSSTEP

 

 

WBSSTEPX

 

 

WKFLTMPL

 

 

WKFLUSER

 

 

WORKFLOW

 

 

WORKSPACE

 

Although a feature called Workspaces exists in both P6 EPPM and Primavera Cloud, the two features serve different purposes.

 

To extract data about Primavera Cloud's workspaces, use WS_WORKSPACE. See Primavera Cloud Data Service API.

WRK_LOG_RESULTS

 

 

  1. All Primavera Cloud codes are stored in one table, regardless of their object type. Similarly, all Primavera Cloud code values are stored in one table, regardless of their object type.
  2. Although Funds in Primavera Cloud and Funding Sources in P6 EPPM are used to manage the same type of information, the two products differ significantly in how they manage this data.
  3. This P6 EPPM data service correlates to a separate table used for reporting. Primavera Cloud does not have separate reporting tables.
  4. Resources and roles are separate objects in P6 EPPM, but stored in the same object in Primavera Cloud.



Last Published Monday, August 18, 2025