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 |
|
|
- 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.
- 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.
- This P6 EPPM data service correlates to a separate table used for reporting. Primavera Cloud does not have separate reporting tables.
- Resources and roles are separate objects in P6 EPPM, but stored in the same object in Primavera Cloud.
Last Published Monday, August 18, 2025