Primavera Data Service (PDS) is a new free offering for P6
and Unifier cloud customer to enable and use. It exposes a set of endpoints that enables extraction of data from application database. It uses data service endpoints to discover which database tables and
columns are accessible and then run queries against them. It provides read only access to data. It is available to
both new and existing cloud customers.
Primavera Data Service can be used to read data from cloud environment. Data can be extracted in CSV file format or it can be stored in local database. Once the data is extracted, either in CSV file or stored in local database, reports and dashboard can be built on such data. The complete process to read the data using PDS and writing it to local database or CSV file can be automated. It can be run at pre-determined time or ad-hoc basis based on the requirement.
Primavera Data Service uses JavaScript Object Notation. JSON, is an
open-standard file format or data interchange format that uses
human-readable text to transmit data objects consisting of attribute–value
pairs and array data types (or any other serializable value) - Through JSON
Applications, PDS makes use of RESTful end points to access the cloud database.
Primavera Data Service provide read only access to the
following for P6 EPPM:
·
SELECT privileges on all P6 tables (including PX
tables) except ADMIN_CONFIG, BRE_REGISTRY, PREFER, PUBUSER, SETTINGS, and
tables that start with DLT, DR$ and MDRT_.
·
For granted tables, synonyms use the same name
as the table.
·
Views for PXRPTUSER (ds_p6reportuser config
is used to access these views).
Note that this data need to be extracted periodically to keep it current, although it will still not be real time but good for data
analysis and generating month end reports using tools like Tableau, Microsoft
Power BI, etc.
For real time data, P6 web services can be used. P6 web
services can read and write data and can be used for integration where as PDS can only be used to read data.
Limitation:
*Important NOTE: PDS is currently available for customers running P6/Unifier 19.4 or later in GBUCS environments. PDS is available for OCI running P6/Unifier 19.12.1/20.1 or later.
Limitation:
- The data service cannot be used to read BLOB or CLOB fields.
- Complex SQL queries cannot be written to extract data.
- API does not support queries using LIKE and IN conditions.
*Important NOTE: PDS is currently available for customers running P6/Unifier 19.4 or later in GBUCS environments. PDS is available for OCI running P6/Unifier 19.12.1/20.1 or later.
List of tables available for P6 EPPM with configuration ds_p6adminuser:
ACCOUNT
|
FORMTMPL
|
QUERYLIB
|
TASKDOC
|
ACTIVITYCODEHIERARCHY
|
FUNDSRC
|
RCATTYPE
|
TASKDOCX
|
ACTIVITYCODETYPESECURITY
|
GATEWAYDEPLOYMENT
|
RCATVAL
|
TASKFDBK
|
ACTIVITYSPREAD
|
GATEWAYPROVIDER
|
RCATVALX
|
TASKFIN
|
ACTVCODE
|
GATEWAYSYNCACTION
|
REFRDEL
|
TASKFINX
|
ACTVCODEX
|
GCHANGE
|
REITTYPE
|
TASKMEMO
|
ACTVTYPE
|
GLOBALSECURITY
|
RELEASE
|
TASKMEMOX
|
ADDTASKPROC
|
GREPLACE
|
RELITEMS
|
TASKNOTE
|
ADDTASKPROCX
|
GTT_PKLIST
|
RELITER
|
TASKPRED
|
ADDTRSRC
|
HQDATA
|
RELPROJ
|
TASKPREDX
|
ADMIN_CONFIG
|
HQUERY
|
REPORTDATE
|
TASKPROC
|
ALERT
|
IMAGEDATA
|
REPORTTIME
|
TASKPROCX
|
ALERTPARAM
|
ISSUHIST
|
RESOURCEASSIGNMENTCBSSPREAD
|
TASKRISK
|
ANNOUNCEMENT
|
ITERATION
|
RESOURCEASSIGNMENTSPREAD
|
TASKRISKX
|
ANNOUNCEMENT_USER
|
ITERTASK
|
RESOURCECODEHIERARCHY
|
TASKRSRC
|
ARBITER_COUNTER
|
ITERTEAM
|
RESOURCEHIERARCHY
|
TASKRSRCX
|
ATTR_MASTER
|
JOBLOG
|
RESOURCELIMIT
|
TASKSUM
|
AUTOVUE_ATTR
|
JOBPROJ_LKP
|
RFOLIO
|
TASKSUMFIN
|
BASETYPE
|
JOBRPT
|
RFOLIOX
|
TASKUSER
|
BGPLOG
|
JOBSET
|
RISK
|
TASKWKSP
|
BRE_REGISTRY
|
JOBSVC
|
RISKCTRL
|
TASKX
|
BUDGCHNG
|
LEANTASK
|
RISKIMPACT
|
TEMPKEYS
|
BUDGCHNGX
|
LOCATION
|
RISKMIT
|
THRSPARM
|
CALENDAR
|
MDRT_12D3F$
|
RISKMITIMP
|
TIMESHT
|
CALENDARX
|
MDRT_12D46$
|
RISKMITX
|
TIMESHTX
|
CBS
|
MEMOTYPE
|
RISKMTXSCR
|
TMPLCATG
|
CHECKPROJINTEG
|
MTXSCRTYP
|
RISKRSPPLN
|
TPROJMAP
|
CHGHEAD
|
NEXTKEY
|
RISKRSPPLNX
|
TRAKVIEW
|
CHGTASK
|
NONWORK
|
RISKSCRMTX
|
TRSRCFIN
|
CHGTASKACTV
|
NOTE
|
RISKSCRTHR
|
TRSRCFINX
|
CHGTASKACTVX
|
OBS
|
RISKSCRTYP
|
TRSRCSUM
|
CHGTASKMEMO
|
OBSPROJ
|
RISKTYPE
|
TRSRCSUMFN
|
CHGTASKMEMOX
|
P6_CERTS
|
RISKX
|
TSAUDIT
|
CHGTASKPROC
|
P6_KEYS
|
RLFOLIO
|
TSDATES
|
CHGTASKPROCX
|
PAUDIT
|
RLFOLIOX
|
TSDELEGATE
|
CHGTASKX
|
PAUDITX
|
ROLELIMIT
|
UACCESS
|
CHGTRSRC
|
PCATTYPE
|
ROLERATE
|
UDFCODE
|
CHGTRSRCX
|
PCATUSER
|
ROLERATEX
|
UDFCODEX
|
CHGUDFVALUE
|
PCATUSERX
|
ROLES
|
UDFTYPE
|
CHGUDFVALUEX
|
PCATVAL
|
ROLFOLIO
|
UDFVALUE
|
COSTACCOUNTHIERARCHY
|
PCATVALX
|
RPT
|
UDFVALUEX
|
COSTSECURITY
|
PC_KEY_XREF
|
RPTBATCH
|
UEVNTREG
|
COSTTYPE
|
PC_PROCESS_STAT
|
RPTGROUP
|
UMEASURE
|
CURRTYPE
|
PFOLIO
|
RPTLIST
|
UPKLIST
|
CURRTYPEX
|
PFOLIOUSER
|
RSRC
|
USERCOL
|
DASHBOARD
|
PFOLIOX
|
RSRCANDASH
|
USERDATA
|
DASHUSER
|
PHASE
|
RSRCANVIEW
|
USERENG
|
DELTASKPROC
|
PKXREF
|
RSRCCURV
|
USEROBS
|
DELTASKPROCX
|
PLPROJREF
|
RSRCCURVX
|
USEROBSX
|
DISCUSSION
|
POBS
|
RSRCHOUR
|
USEROPEN
|
DISCUSSION_READ
|
PREFER
|
RSRCHOURX
|
USERS
|
DLTACCT
|
PRMQUEUE
|
RSRCLOC
|
USERSET
|
DLTACTV
|
PROCGROUP
|
RSRCOVERALLOC
|
USERSX
|
DLTOBS
|
PROCITEM
|
RSRCPROP
|
USERWKSP
|
DLTROLE
|
PROFILE
|
RSRCRATE
|
USER_ACCEPTANCE_CONSENT
|
DLTRSRC
|
PROFPRIV
|
RSRCRATEX
|
USESSAUD
|
DLTRSRL
|
PROFPRIVX
|
RSRCRCAT
|
USESSION
|
DLTUSER
|
PROJCOST
|
RSRCRCATX
|
USROPNVAL
|
DM_ATTR
|
PROJCOSTX
|
RSRCROLE
|
VIEWPREF
|
DOC
|
PROJDEPLMENT
|
RSRCROLEASGNMENTSPREAD
|
VIEWPROP
|
DOCCATG
|
PROJECT
|
RSRCROLEX
|
VWPREFDASH
|
DOCREVIEW
|
PROJECTCODEHIERARCHY
|
RSRCSEC
|
VWPREFDATA
|
DOCREVIEWTASK
|
PROJECTCOSTCBSSPREAD
|
RSRCSECX
|
VWPREFUSER
|
DOCSTAT
|
PROJECTSECURITY
|
RSRCX
|
WBRSCAT
|
DOCUMENT
|
PROJECTSPREAD
|
RSRFOLIO
|
WBSBUDG
|
DOCUMENTX
|
PROJECTX
|
SAFETYDATE
|
WBSBUDGX
|
DOCUMENT_MAPPER
|
PROJECT_ETL_LIST
|
SCENARIO
|
WBSHIERARCHY
|
DOC_FOLDER
|
PROJEST
|
SCENPROJ
|
WBSMEMO
|
DOC_RECENT
|
PROJFUND
|
SCENROLE
|
WBSMEMOX
|
DOC_VERSION
|
PROJFUNDX
|
SCENUSER
|
WBSRSRC
|
DR$DOCVER_DOCDATA_QSI$I
|
PROJISSU
|
SETTINGS
|
WBSRSRCX
|
DR$DOCVER_DOCDATA_QSI$K
|
PROJISSUX
|
SHIFT
|
WBSRSRC_QTY
|
DR$DOCVER_DOCDATA_QSI$N
|
PROJPCAT
|
SHIFTPER
|
WBSRSRC_QTYX
|
DR$DOCVER_DOCDATA_QSI$R
|
PROJPCATX
|
SNAPGROUP
|
WBSSPREAD
|
DR$DOCVER_DOCDATA_QSI$U
|
PROJPROP
|
SNAPPROJ
|
WBSSTEP
|
EPSHIERARCHY
|
PROJRISK
|
SNAPSHOT
|
WBSSTEPX
|
EPSSPREAD
|
PROJSET
|
SPIDMAP
|
WKFLTMPL
|
EXPPROJ
|
PROJSHAR
|
SUMPROJCOST
|
WKFLUSER
|
EXTAPP
|
PROJTHRS
|
SUMTASK
|
WORKFLOW
|
FACTOR
|
PROJWBS
|
SUMTASKSPREAD
|
WORKSPACE
|
FACTVAL
|
PROJWBSX
|
SUMTRSRC
|
WRK_LOG_RESULTS
|
FILTPROP
|
PROJWSRPT
|
TASK
|
SYNC$SYS_NUMLIST
|
FINDATES
|
PRPFOLIO
|
TASKACTV
|
SYNC$SYS_STRLIST
|
FORMCATG
|
PUBUSER
|
TASKACTVX
|
|
FORMPROJ
|
PXJOBRUN
|
TASKCBSX
|
List of views available for P6 EPPM with configuration ds_p6adminuser:
OPENING_ACCOUNT
|
PROJRSRC_VIEW
|
WBSRSRC_ASSGN_BY_ROLE_BY_QTR
|
OPENING_ACTVCODE
|
PROJSHAR_BL_VIEW
|
WBSRSRC_ASSGN_BY_ROLE_BY_WEEK
|
OPENING_OBS
|
RESOURCEUSAGE
|
WBSRSRC_ASSGN_BY_ROLE_BY_YEAR
|
OPENING_ROLE
|
WBSRSRC_ASSGN_BY_PROJROLE_MON
|
WBSRSRC_ASSGN_BY_RSRC_BY_MONTH
|
OPENING_RSRC
|
WBSRSRC_ASSGN_BY_PROJROLE_QTR
|
WBSRSRC_ASSGN_BY_RSRC_BY_QTR
|
OPENING_RSRCROLE
|
WBSRSRC_ASSGN_BY_PROJROLE_WEEK
|
WBSRSRC_ASSGN_BY_RSRC_BY_WEEK
|
OPENING_USERS
|
WBSRSRC_ASSGN_BY_PROJROLE_YEAR
|
WBSRSRC_ASSGN_BY_RSRC_BY_YEAR
|
PFLOAD_IP_UACCESS_VIEW
|
WBSRSRC_ASSGN_BY_PROJRSRC_MON
|
WBSRSRC_ASSGN_SUMMARY_BY_MON
|
PFLOAD_IP_VIEW
|
WBSRSRC_ASSGN_BY_PROJRSRC_QTR
|
WBSRSRC_ASSGN_SUMMARY_BY_QTR
|
PFLOAD_UACCESS_VIEW
|
WBSRSRC_ASSGN_BY_PROJRSRC_WEEK
|
WBSRSRC_ASSGN_SUMMARY_BY_WEEK
|
PFLOAD_VIEW
|
WBSRSRC_ASSGN_BY_PROJRSRC_YEAR
|
WBSRSRC_ASSGN_SUMMARY_BY_YEAR
|
PROJROLE_PS_VIEW
|
WBSRSRC_ASSGN_BY_PROJ_BY_MONTH
|
WBSRSRC_ASSN_BY_PROJROLE_BY_FP
|
PROJROLE_VIEW
|
WBSRSRC_ASSGN_BY_PROJ_BY_QTR
|
WBSRSRC_ASSN_BY_PROJRSRC_BY_FP
|
PROJRSRCROLE_PS_VIEW
|
WBSRSRC_ASSGN_BY_PROJ_BY_WEEK
|
WBSRSRC_ASSN_BY_PROJ_BY_FP
|
PROJRSRCROLE_VIEW
|
WBSRSRC_ASSGN_BY_PROJ_BY_YEAR
|
WBSRSRC_ASSN_SUMMARY_BY_FP
|
PROJRSRC_PS_VIEW
|
WBSRSRC_ASSGN_BY_ROLE_BY_MONTH
|
List of views available for P6 EPPM with configuration
ds_p6reportuser:
ACTIVITY
|
DOCUMENTSTATUSCODE
|
PROJECTRESOURCE
|
RISKIMPACT_U
|
ACTIVITYCODE
|
DOCUMENTSTATUSCODE_FULL
|
PROJECTRESOURCEQUANTITY
|
RISKMATRIXSCORE
|
ACTIVITYCODEASSIGNMENT
|
DOCUMENTSTATUSCODE_U
|
PROJECTRESOURCEQUANTITY_FULL
|
RISKMATRIXSCORETYPE
|
ACTIVITYCODEASSIGNMENT_FULL
|
DOCUMENT_FULL
|
PROJECTRESOURCEQUANTITY_U
|
RISKMATRIXSCORETYPE_FULL
|
ACTIVITYCODEASSIGNMENT_GE
|
DOCUMENT_U
|
PROJECTRESOURCE_FULL
|
RISKMATRIXSCORETYPE_U
|
ACTIVITYCODEASSIGNMENT_RT
|
EPS
|
PROJECTRESOURCE_U
|
RISKMATRIXSCORE_FULL
|
ACTIVITYCODEASSIGNMENT_S
|
EPSBUDGETCHANGELOG
|
PROJECTSECURITY
|
RISKMATRIXSCORE_U
|
ACTIVITYCODEASSIGNMENT_U
|
EPSBUDGETCHANGELOG_FULL
|
PROJECTSECURITY_GE
|
RISKRESPONSEACTION
|
ACTIVITYCODEHIERARCHY
|
EPSBUDGETCHANGELOG_U
|
PROJECTSECURITY_RT
|
RISKRESPONSEACTIONIMPACT
|
ACTIVITYCODEHIERARCHY_FULL
|
EPSFUNDING
|
PROJECTSPENDINGPLAN
|
RISKRESPONSEACTIONIMPACT_FULL
|
ACTIVITYCODEHIERARCHY_S
|
EPSFUNDING_FULL
|
PROJECTSPENDINGPLAN_FULL
|
RISKRESPONSEACTIONIMPACT_U
|
ACTIVITYCODEHIERARCHY_U
|
EPSFUNDING_U
|
PROJECTSPENDINGPLAN_U
|
RISKRESPONSEACTION_FULL
|
ACTIVITYCODETYPE
|
EPSHIERARCHY
|
PROJECTSPREAD
|
RISKRESPONSEACTION_U
|
ACTIVITYCODETYPESECURITY
|
EPSHIERARCHY_FULL
|
PROJECTSPREAD_FULL
|
RISKRESPONSEPLAN
|
ACTIVITYCODETYPE_FULL
|
EPSHIERARCHY_U
|
PROJECTSPREAD_U
|
RISKRESPONSEPLAN_FULL
|
ACTIVITYCODETYPE_GE
|
EPSNOTE
|
PROJECT_FULL
|
RISKRESPONSEPLAN_U
|
ACTIVITYCODETYPE_RT
|
EPSNOTE_FULL
|
PROJECT_GE
|
RISKSCOREMATRIX
|
ACTIVITYCODETYPE_S
|
EPSNOTE_U
|
PROJECT_RT
|
RISKSCOREMATRIX_FULL
|
ACTIVITYCODETYPE_U
|
EPSSPENDINGPLAN
|
PROJECT_SC
|
RISKSCOREMATRIX_U
|
ACTIVITYCODEUPDATE
|
EPSSPENDINGPLAN_FULL
|
PROJECT_U
|
RISKSCORETYPE
|
ACTIVITYCODEUPDATE_FULL
|
EPSSPENDINGPLAN_U
|
PROJECT_UDFVALUE_U
|
RISKSCORETYPE_FULL
|
ACTIVITYCODEUPDATE_U
|
EPSSPREAD
|
PXSERVICES
|
RISKSCORETYPE_U
|
ACTIVITYCODE_FULL
|
EPSSPREAD_FULL
|
PXSETTINGS
|
RISKTHRESHOLDLEVEL
|
ACTIVITYCODE_GE
|
EPSSPREAD_U
|
REFRDELETE
|
RISKTHRESHOLDLEVEL_FULL
|
ACTIVITYCODE_RT
|
EPS_FULL
|
REFRDELETE_GE
|
RISKTHRESHOLDLEVEL_U
|
ACTIVITYCODE_S
|
EPS_SC
|
REFRDELETE_RT
|
RISKTYPE
|
ACTIVITYCODE_U
|
EPS_U
|
REFRDELETE_SC
|
RISKTYPE_FULL
|
ACTIVITYCOMMENT
|
ETLFILTER
|
RELATIONSHIP
|
RISKTYPE_U
|
ACTIVITYCOMMENT_FULL
|
EXPENSECATEGORY
|
RELATIONSHIP_FULL
|
RISK_FULL
|
ACTIVITYCOMMENT_U
|
EXPENSECATEGORY_FULL
|
RELATIONSHIP_U
|
RISK_GE
|
ACTIVITYEXPENSE
|
EXPENSECATEGORY_U
|
RELEASE
|
RISK_RT
|
ACTIVITYEXPENSE_FULL
|
FINANCIALPERIOD
|
RELEASEITERATION
|
RISK_U
|
ACTIVITYEXPENSE_GE
|
FINANCIALPERIOD_FULL
|
RELEASEITERATION_FULL
|
ROLE
|
ACTIVITYEXPENSE_RT
|
FINANCIALPERIOD_U
|
RELEASEITERATION_U
|
ROLEAVAILABILITY
|
ACTIVITYEXPENSE_U
|
FUNDINGSOURCE
|
RELEASEPROJECT
|
ROLELIMIT
|
ACTIVITYNOTE
|
FUNDINGSOURCE_FULL
|
RELEASEPROJECT_FULL
|
ROLERATE
|
ACTIVITYNOTE_FULL
|
FUNDINGSOURCE_U
|
RELEASEPROJECT_U
|
ROLERATE_FULL
|
ACTIVITYNOTE_GE
|
GLOBALPROFILE
|
RELEASE_FULL
|
ROLERATE_U
|
ACTIVITYNOTE_RT
|
GLOBALPROFILE_FULL
|
RELEASE_U
|
ROLEROLETEAM
|
ACTIVITYNOTE_U
|
GLOBALPROFILE_U
|
REPORTDATE
|
ROLEROLETEAM_FULL
|
ACTIVITYPERIODACTUAL
|
GLOBALSECURITY
|
REPORTDATE_FULL
|
ROLEROLETEAM_U
|
ACTIVITYPERIODACTUAL_FULL
|
GLOBAL_UDFVALUE_U
|
REPORTDATE_U
|
ROLETEAM
|
ACTIVITYPERIODACTUAL_GE
|
ISSUEHISTORY
|
REPORTTIME
|
ROLETEAM_FULL
|
ACTIVITYPERIODACTUAL_RT
|
ISSUEHISTORY_FULL
|
REPORTTIME_FULL
|
ROLETEAM_U
|
ACTIVITYPERIODACTUAL_SC
|
ISSUEHISTORY_U
|
REPORTTIME_U
|
ROLE_FULL
|
ACTIVITYPERIODACTUAL_U
|
ITERATION
|
RESASSIGNMENTPERIODACTUAL
|
ROLE_SC
|
ACTIVITYRISK
|
ITERATIONACTIVITY
|
RESASSIGNMENTPERIODACTUAL_FULL
|
ROLE_U
|
ACTIVITYRISK_FULL
|
ITERATIONACTIVITY_FULL
|
RESASSIGNMENTPERIODACTUAL_GE
|
SHIFT
|
ACTIVITYRISK_GE
|
ITERATIONACTIVITY_U
|
RESASSIGNMENTPERIODACTUAL_RT
|
SHIFTPERIOD
|
ACTIVITYRISK_RT
|
ITERATIONTEAM
|
RESASSIGNMENTPERIODACTUAL_SC
|
SHIFTPERIOD_FULL
|
ACTIVITYRISK_U
|
ITERATIONTEAM_FULL
|
RESASSIGNMENTPERIODACTUAL_U
|
SHIFTPERIOD_U
|
ACTIVITYSPREAD
|
ITERATIONTEAM_U
|
RESOURCEACCESS
|
SHIFT_FULL
|
ACTIVITYSPREAD_FULL
|
ITERATION_FULL
|
RESOURCEACCESS_FULL
|
SHIFT_U
|
ACTIVITYSPREAD_GE
|
ITERATION_U
|
RESOURCEACCESS_U
|
SNAPSHOT
|
ACTIVITYSPREAD_RT
|
LOCATION
|
RESOURCEASSIGNMENT
|
SNAPSHOTGROUP
|
ACTIVITYSPREAD_SC
|
LOCATION_FULL
|
RESOURCEASSIGNMENTSPREAD
|
SNAPSHOTGROUP_FULL
|
ACTIVITYSPREAD_U
|
LOCATION_U
|
RESOURCEASSIGNMENTSPREAD_FULL
|
SNAPSHOTGROUP_U
|
ACTIVITYSTEP
|
NEVER_LOGGED_USER_DTL
|
RESOURCEASSIGNMENTSPREAD_GE
|
SNAPSHOTPROJECT
|
ACTIVITYSTEPCREATE
|
NOTEBOOKTOPIC
|
RESOURCEASSIGNMENTSPREAD_RT
|
SNAPSHOTPROJECT_FULL
|
ACTIVITYSTEPCREATE_FULL
|
NOTEBOOKTOPIC_FULL
|
RESOURCEASSIGNMENTSPREAD_SC
|
SNAPSHOTPROJECT_U
|
ACTIVITYSTEPCREATE_U
|
NOTEBOOKTOPIC_U
|
RESOURCEASSIGNMENTSPREAD_U
|
SNAPSHOT_FULL
|
ACTIVITYSTEPDEL
|
OBS
|
RESOURCEASSIGNMENTUPDATE
|
SNAPSHOT_U
|
ACTIVITYSTEPDEL_FULL
|
OBS_FULL
|
RESOURCEASSIGNMENTUPDATE_FULL
|
TIMESHEET
|
ACTIVITYSTEPDEL_U
|
OBS_SC
|
RESOURCEASSIGNMENTUPDATE_U
|
TIMESHEETPERIOD
|
ACTIVITYSTEPUPDATE
|
OBS_U
|
RESOURCEASSIGNMENT_FULL
|
TIMESHEETPERIOD_FULL
|
ACTIVITYSTEPUPDATE_FULL
|
OVERHEADCODE
|
RESOURCEASSIGNMENT_GE
|
TIMESHEETPERIOD_U
|
ACTIVITYSTEPUPDATE_U
|
OVERHEADCODE_FULL
|
RESOURCEASSIGNMENT_RT
|
TIMESHEET_FULL
|
ACTIVITYSTEP_FULL
|
OVERHEADCODE_U
|
RESOURCEASSIGNMENT_SC
|
TIMESHEET_U
|
ACTIVITYSTEP_GE
|
PRMAUDIT_FULL
|
RESOURCEASSIGNMENT_U
|
UDFCODE
|
ACTIVITYSTEP_RT
|
PRMAUDIT_PROJ
|
RESOURCECODE
|
UDFCODE_FULL
|
ACTIVITYSTEP_U
|
PROJECT
|
RESOURCECODEASSIGNMENT
|
UDFCODE_S
|
ACTIVITYUPDATE
|
PROJECTBUDGETCHANGELOG
|
RESOURCECODEASSIGNMENT_FULL
|
UDFCODE_U
|
ACTIVITYUPDATE_FULL
|
PROJECTBUDGETCHANGELOG_FULL
|
RESOURCECODEASSIGNMENT_S
|
UDFTYPE
|
ACTIVITYUPDATE_U
|
PROJECTBUDGETCHANGELOG_U
|
RESOURCECODEASSIGNMENT_U
|
UDFTYPE_FULL
|
ACTIVITY_FULL
|
PROJECTCODE
|
RESOURCECODEHIERARCHY
|
UDFTYPE_S
|
ACTIVITY_GE
|
PROJECTCODEASSIGNMENT
|
RESOURCECODEHIERARCHY_FULL
|
UDFTYPE_U
|
ACTIVITY_RT
|
PROJECTCODEASSIGNMENT_FULL
|
RESOURCECODEHIERARCHY_S
|
UDFVALUE
|
ACTIVITY_SC
|
PROJECTCODEASSIGNMENT_GE
|
RESOURCECODEHIERARCHY_U
|
UDFVALUE_FULL
|
ACTIVITY_U
|
PROJECTCODEASSIGNMENT_RT
|
RESOURCECODETYPE
|
UNITOFMEASURE
|
AUDIT_PROJINFO
|
PROJECTCODEASSIGNMENT_S
|
RESOURCECODETYPE_FULL
|
UNITOFMEASURE_FULL
|
AUDIT_SETTINGS
|
PROJECTCODEASSIGNMENT_U
|
RESOURCECODETYPE_S
|
UNITOFMEASURE_U
|
AUDIT_USERS
|
PROJECTCODEHIERARCHY
|
RESOURCECODETYPE_U
|
USERDEFINEDVALUEUPDATE
|
BASELINE
|
PROJECTCODEHIERARCHY_FULL
|
RESOURCECODE_FULL
|
USERDEFINEDVALUEUPDATE_FULL
|
BASELINETYPE
|
PROJECTCODEHIERARCHY_S
|
RESOURCECODE_S
|
USERDEFINEDVALUEUPDATE_U
|
BASELINETYPE_FULL
|
PROJECTCODEHIERARCHY_U
|
RESOURCECODE_U
|
USERMODULEACCESS
|
BASELINETYPE_U
|
PROJECTCODETYPE
|
RESOURCECURVE
|
USERMODULEACCESS_FULL
|
BASELINE_U
|
PROJECTCODETYPE_FULL
|
RESOURCECURVE_FULL
|
USERMODULEACCESS_U
|
BLACTIVITY
|
PROJECTCODETYPE_S
|
RESOURCECURVE_U
|
USEROBS
|
BLACTIVITY_U
|
PROJECTCODETYPE_U
|
RESOURCEHIERARCHY
|
USEROBS_FULL
|
BLPROJECT
|
PROJECTCODEUSER
|
RESOURCEHIERARCHY_FULL
|
USEROBS_U
|
BLPROJECT_U
|
PROJECTCODEUSER_FULL
|
RESOURCEHIERARCHY_U
|
USERPROFILEPRIVILEGE
|
BLWBS
|
PROJECTCODEUSER_U
|
RESOURCEHOUR
|
USERPROFILEPRIVILEGE_FULL
|
BLWBS_U
|
PROJECTCODE_FULL
|
RESOURCEHOUR_FULL
|
USERPROFILEPRIVILEGE_U
|
CALENDAR
|
PROJECTCODE_S
|
RESOURCEHOUR_U
|
USERS
|
CALENDAR_FULL
|
PROJECTCODE_U
|
RESOURCELIMIT
|
USERS_FULL
|
CALENDAR_GE
|
PROJECTDOCUMENT
|
RESOURCELIMIT_FULL
|
USERS_U
|
CALENDAR_RT
|
PROJECTDOCUMENT_FULL
|
RESOURCELIMIT_U
|
USER_LOGIN_DTLS
|
CALENDAR_U
|
PROJECTDOCUMENT_U
|
RESOURCELOCATION
|
USER_NOT_LOGGED_DTL
|
CBS
|
PROJECTETLLIST
|
RESOURCELOCATION_FULL
|
WBS
|
CBS_GE
|
PROJECTETLLIST_FULL
|
RESOURCELOCATION_U
|
WBSCATEGORY
|
CBS_RT
|
PROJECTETLLIST_U
|
RESOURCERATE
|
WBSCATEGORY_FULL
|
CHANGESET
|
PROJECTFUNDING
|
RESOURCERATE_FULL
|
WBSCATEGORY_U
|
CHANGESET_FULL
|
PROJECTFUNDING_FULL
|
RESOURCERATE_U
|
WBSHIERARCHY
|
CHANGESET_U
|
PROJECTFUNDING_U
|
RESOURCERESOURCETEAM
|
WBSHIERARCHY_FULL
|
COSTACCOUNT
|
PROJECTISSUE
|
RESOURCERESOURCETEAM_FULL
|
WBSHIERARCHY_GE
|
COSTACCOUNTHIERARCHY
|
PROJECTISSUE_FULL
|
RESOURCERESOURCETEAM_U
|
WBSHIERARCHY_RT
|
COSTACCOUNTHIERARCHY_FULL
|
PROJECTISSUE_U
|
RESOURCEROLE
|
WBSHIERARCHY_U
|
COSTACCOUNTHIERARCHY_U
|
PROJECTNOTE
|
RESOURCEROLE_FULL
|
WBSMILESTONE
|
COSTACCOUNT_FULL
|
PROJECTNOTE_FULL
|
RESOURCEROLE_U
|
WBSMILESTONE_FULL
|
COSTACCOUNT_SC
|
PROJECTNOTE_GE
|
RESOURCES
|
WBSMILESTONE_U
|
COSTACCOUNT_U
|
PROJECTNOTE_RT
|
RESOURCESECURITY
|
WBSSPREAD
|
COSTSECURITY
|
PROJECTNOTE_U
|
RESOURCES_FULL
|
WBSSPREAD_FULL
|
COSTSECURITY_FULL
|
PROJECTPORTFOLIO
|
RESOURCES_SC
|
WBSSPREAD_U
|
COSTSECURITY_U
|
PROJECTPORTFOLIO_FULL
|
RESOURCES_U
|
WBS_FULL
|
CURRENCY
|
PROJECTPORTFOLIO_U
|
RESOURCETEAM
|
WBS_GE
|
CURRENCY_FULL
|
PROJECTPROFILE
|
RESOURCETEAM_FULL
|
WBS_RT
|
CURRENCY_U
|
PROJECTPROFILE_FULL
|
RESOURCETEAM_U
|
WBS_SC
|
DOCUMENT
|
PROJECTPROFILE_U
|
RESOURCE_UDFVALUE_U
|
WBS_U
|
DOCUMENTCATEGORY
|
PROJECTPROJECTPORTFOLIO
|
RISK
|
|
DOCUMENTCATEGORY_FULL
|
PROJECTPROJECTPORTFOLIO_FULL
|
RISKIMPACT
|
|
DOCUMENTCATEGORY_U
|
PROJECTPROJECTPORTFOLIO_U
|
RISKIMPACT_FULL
|
If you are looking for a solution to extract data from cloud database (P6, Unifier or Oracle Primavera Cloud) and build reporting solution, or
Looking for a demo to extract the data from your cloud environment one time to see how the data looks like, leave a comment or drop a message.
*Reference: How P6 and Unifier Cloud Customers Can Utilize Primavera Data Service (PDS) to Access their Cloud Database (Doc ID 2552583.1)