cloud sync data mapping guide - oracle...cloud sync data mapping guide 6 p6 eppm field prime...

CClloouudd SSyynncc DDaattaa MMaappppiinngg GGuuiiddeeVVeerrssiioonn 1188

AApprriill 22001188

3

Contents

About This Guide ............................................................................................................................... 5

P6 EPPM to Oracle Prime Projects Data Mapping ............................................................................ 5

Global Field Mappings ............................................................................................................................ 5

Project Field Mappings ........................................................................................................................... 8

Units of Measure Field Mappings ........................................................................................................ 15

Monte Carlo Field Mappings ................................................................................................................ 16

Resource Management Field Mappings ............................................................................................. 18

Risk Field Mappings ............................................................................................................................. 26

Schedule Management Field Mappings ............................................................................................. 34

Task Field Mappings ............................................................................................................................ 50

Legal Notices .................................................................................................................................. 52

5

About This Guide

This guide details mappings between fields in Oracle Prime Projects and P6 EPPM. Field mappings determine how data is exchanged between P6 EPPM and Prime Projects using Cloud Sync. This guide also lists the Prime Projects API objects that correspond to each Prime Projects and P6 EPPM field.

Caution: Personally Identifiable Information (PII) may be at risk of exposure. It is your responsibility to mitigate any risk of exposure. You should consult your data security or legal team to determine whether it is safe to use this feature.

P6 EPPM to Oracle Prime Projects Data Mapping

For the purposes of Oracle Prime Projects Cloud Sync, Oracle Prime Projects fields are mapped to P6 EPPM fields that represent equivalent types of data. Prime Projects Cloud Sync updates the values of fields in one product using the values of corresponding fields in the other product. For example, a project using Cloud Sync integration set to export data from P6 EPPM to Prime Projects will update the Prime Projects status field to match the value of the corresponding project status field of the project in P6 EPPM.

Mapped P6 EPPM and Prime Projects fields have associated representations in the Prime Projects API in the form of response object properties. You can use the Prime Projects API to view and modify application data. For more information on the Prime Projects API, see the Prime Projects API Documentation(http://docs.oracle.com/construction-engineering/prime-17/PRIME/).

The following topics detail the field mappings between P6 EPPM and Prime Projects in addition to each field's corresponding Prime Projects API response object property.

Caution: Personally Identifiable Information (PII) may be at risk of exposure. It is your responsibility to mitigate any risk of exposure. You should consult your data security or legal team to determine whether it is safe to use this feature.

Global Field Mappings

The following sections describe global field mappings between P6 EPPM and Prime Projects:

Calendar Fields

Calendar fields detail the workdays and work hours available for a given project. The ApiEntityCalendar schema represents calendar fields in the Prime Projects API. The following table lists P6 EPPM calendar fields and their corresponding fields and API object properties in Prime Projects:

http://docs.oracle.com/construction-engineering/prime-17/PRIME/

Cloud Sync Data Mapping Guide

6

P6 EPPM Field Prime Projects Field Prime Projects API Object Property

Notes

Not Applicable ID

The unique identifier for the calendar.

calendarId

Calendar Name Name

The name of the calendar.

calendarName

Calendar Exceptions Fields

Calendar exception fields determine calendar exception times, such as holidays. The ApitEntityCalendarException schema represents calendar exception fields in the Prime Projects API. The following table lists P6 EPPM calendar exception fields and their corresponding fields and API object properties in Prime Projects:


Notes

Not Applicable Exception Date

The date that is marked as an exception. An exception is a change to the regularly scheduled time in the calendar.

exceptionDate

Code Type Fields

Code type fields differentiate and organize projects and other data. The ApiEntityCodeTypeschema represents code type fields in the Prime Projects API. The following table lists P6 EPPM code type fields and their corresponding fields and API object properties in Prime Projects:


Notes

Not Applicable {workspace}

The ID of the owning workspace.

workspace


7

Project Code

Activity Code

Resource Code

ID

This field displays the name of a code or value.

codeTypeCode

Name Name

The name of a code or value.

codeTypeName

Code Value Fields

Code value fields contain the values of user defined codes. The ApiEntityCodeValue schema represents code value fields in the Prime Projects API. The following table lists P6 EPPM code value fields and their corresponding fields and API object properties in Prime Projects:


Notes

Name Name

The name of the code value.

codeValueName

Not Applicable ID

The unique identifier for the code value.

codeValueId

Not Applicable Parent Value

The parent code value.

parentCodeValue

Not Applicable Code Type

The ID for the code type.

codeTypeId

Note: When synchronizing projects between P6 EPPM and Prime Projects using Cloud Sync, an EPS Code Type representing the project's EPS in P6 EPPM is added to the project in Prime Projects.


8

Project Field Mappings

The following sections describe project field mappings between P6 EPPM and Prime Projects:

WBS Fields

WBS fields contain information about the hierarchical structure of your projects or processes. The ApiEntityWBS schema represents WBS fields in the Prime Projects API. The following table lists P6 EPPM WBS fields and their corresponding fields and API object properties in Prime Projects:

P6 EPPM Field Prime Projects Field and Description

Prime Projects API Object Property

Notes

WBS Code Code

The unique identifier for the WBS.

wbsCode

WBS Name Name

The name of the WBS.

wbsName

Parent WBS Parent

The name of the parent WBS.

parentWbs

Project Fields

Project fields specify details about your projects. The ApiEntityProject schema represents project fields in the Prime Projects API. The following table lists P6 EPPM project fields and their corresponding fields and API object properties in Prime Projects:

P6 EPPM Field Prime Projects Field and Description


Notes

Unique ID Project ID

The unique identifier for the project.

projectId

Not Applicable {workspace}

The workspace the project is associated with.

workspaceId


9

Project Owner Manager

The manager or person responsible for the project.

owner If the P6 EPPM project owner's matching resource in Prime Projects does not have a user assignment, the P6 EPPM-Prime Projects Cloud Sync fallback user will be set as the Prime Projects project manager.

Risk Scoring Matrix Risk Matrix

The risk matrix assigned to the project for calculating project risk scores.

riskMatrix

Default Calendar Calendar

The calendar assigned to the project.

calendar

Not Applicable Project Currency

The currency used by the project. The project currency can differ from the base currency.

projectCurrency

The project created in Prime Projects using P6 EPPM-Prime Projects Cloud Sync will use the base currency set at the root workspace level.

Project ID ID

The unique identifier for a project set by the user who created the project.

projectCode

WBS Name Name

The name of the project.

projectName


10

Description Description

The detailed summary for the project.

The description provides more information than short names or titles.

It can give background information or establish a purpose for the item.

These details help differentiate between items with similar names and are especially useful in multi-user environments.

description

Project Website URL Project Website URL

The link to a website related to the project.

websiteUrl


11

Project Status Status

The current status of a project.

Proposal: The project is a project proposal and has not been extensively planned nor accrued any costs.

Rejected: The project proposal has been rejected and will not be initiated as a project.

Planned: The project is currently planned for execution. Project managers input expected project costs and other project data during this stage.

Active: The project is currently active and being executed.

Inactive: The project has been rendered inactive and will temporarily accrue no costs.

Complete: The project has been successfully completed and will no longer accrue costs.

status Status values are converted using the following scheme:

A P6 EPPM status of Requested is converted to a Prime Projects status of Proposal.

A P6 EPPM status of Inactive is converted to a Prime Projects status of Inactive.

A P6 EPPM status of What-if is converted to a Prime Projects status of Planned.

A P6 EPPM status of Active is converted to a Prime Projects status of Active.

A P6 EPPM status of Planned is converted to a Prime Projects status of Planned.

A P6 EPPM status of Template sets the corresponding Prime Projects project's Template flag to true.


12

Strategic Priority Strategic Priority

The project's priority in the strategic plan.

This priority value ranges from 1 to 10,000 with a default of 500. Use of the priority value, such as whether to place higher priority at the lower end of the scale, toward the endpoint 1, or at the higher end, toward 10,000, is at the discretion of the user. This field is not used for calculating data.

strgyPriorityNum

Planned Start Project Planned Start

The start date for the time phased Planned Budget of the project.

Planned Budget cost spread will adjust when this date is changed.

The Project Planned Start also represents the earliest date that activities can occur within a project schedule.

planStartDate


13

Schedule Finish Schedule Must Finish By Date

The latest date on which the scheduled activities must be complete for a project.

scheduledFinishDate

Last Recalc Date Data Date

The progress point, or "as-of date", for activities in the project. Project status is up-to-date as of the data date. You can set the data date when you schedule the project, or you can set it manually.

The data date is also used for updating the dates of scope assignments and work packages when they are not linked to activities.

dataDate

Must Finish By Schedule Must Finish By Date

The latest date on which the scheduled activities must be complete for a project.

mustFinishByDate

Not Applicable Synced with P6

Indicates the project is synchronized with P6 EPPM.

isPSyncManaged


14

Project Financial Fields

Project financial fields detail financial information about your projects. The ApiEntityProjectFinancial schema represents project financial fields in the Prime Projects API. The following table lists P6 EPPM project cost fields and their corresponding fields and API object properties in Prime Projects:


Notes

Project PROJ ID

The unique identifier for a project set by the user who created the project.

Not Applicable

Annual Discount Rate

Annual Discount Rate

The interest rate associated with the cost of an investment from your commercial bank or another funding source.

For example, an annual growth rate of an investment such as 4.75% can be used as an annual discount rate. This rate is used when a future value is assumed and you are trying to find the required Net Present Value.

This value can be entered manually or can be imported.

annualDiscountRate


15

AutoNumber Fields

Autonumber fields specify the automatic ordering scheme applied to activities. The ApiEntityProjectAutoNumber schema represents autonumber fields in the Prime Projects API. The following table lists P6 EPPM activity autonumber fields and their corresponding fields and API object properties in Prime Projects:


Notes

Not Applicable Id

The auto generated ID for the object.

projectAutonumberId

Activity ID Prefix Prefix

The initial characters for the auto numbering sequence.

prefix

Activity ID Suffix Starting Number

The first number in the auto numbering sequence.

suffix

Activity ID Increment Increment

The number to increment the starting number by.

increment

Units of Measure Field Mappings

The following sections describe units of measure field mappings between P6 EPPM and Prime Projects.

Units of Measure

Units of Measure fields define units of measure used to evaluate quantities of materials or products. The ApiEntityUnitsOfMeasure schema represents unit of measure fields in the Prime Projects API. The following table lists P6 EPPM units of measure fields and their corresponding fields and API object properties in Prime Projects:


16

P6 EPPM Prime Projects Field and Description


Notes

Unit Abbreviation Abbreviation

The abbreviation for the unit of measure name.

key

Unit Name Name

The name of the unit of measure.

displayName

Monte Carlo Field Mappings

The following sections describe Monte Carlo field mappings between P6 EPPM and Prime Projects.

Activity Uncertainty

Activity uncertainty fields capture project contingencies. The ApiEntityActivityUncertaintyschema represents activity uncertainty fields in the Prime Projects API. The following table lists P6 EPPM activity uncertainty fields and their corresponding fields and API object properties in Prime Projects:


17


Notes

Not Applicable Uncertainty Distribution

The probability distribution that best models the three-point estimate durations. The valid values are Triangular and Uniform.

distributionShape Prime Projects Uncertainty Distribution values are set depending on the values of the maximum, minimum, and most likely duration fields in P6 EPPM. If all three duration fields have values, the Uncertainty Distribution is set to a value of Triangular, if only the Minimum and Maximum fields have values, the Uncertainty Distribution is set to a value of Uniform, and if none of the duration fields have values, the Uncertainty Distribution is set to None.

Minimum Duration Minimum Duration

The estimated least amount of time required to complete the activity. This field is used for three-point estimation to indicate activity uncertainty.

minDuration


18

Most Likely Duration Most Likely Duration

The estimated most likely amount of time required to complete the activity. This field is used for three-point estimation to indicate activity uncertainty.

mostLikelyDuration

Maximum Duration Maximum Duration

The estimated maximum amount of time required to complete the activity. This field is used for three-point estimation to indicate activity uncertainty.

maxDuration

Resource Management Field Mappings

The following sections describe resource management field mappings between P6 EPPM and Prime Projects.

Resource

Resource fields detail inventories of project roles and resources. The ApiEntityResourceschema represents resource fields in the Prime Projects API. The following table lists P6 EPPM resource fields and their corresponding fields and API object properties in Prime Projects:


Notes

Resource ID

Role ID ID

The unique identifier for the resource or role.

resourceId


19

Resource Name

Role Name Name

The name of the resource or role.

resourceName

Resource Type Type

The resource type. Valid values are:

Labor: Indicates that the selected resource performs labor, measured in units of time.

Nonlabor: Indicates that the selected resource does not perform labor, measured in units of time. Equipment is a nonlabor resource.

Material: Indicates that the resource has a unit of measure other than time. You can select a unit of measure for the material resource.

resourceType Roles are automatically assigned a type of Labor during synchronization.


20

Active Status

Determines whether the resource or role is currently active.

Inactive resources might have left the organization, but are not deleted from the system because they might have been assigned an activity in the past or have incurred actual hours.

status If the active flag is set within P6 EPPM, the status will be set to Active in P6 EPPM. If the active flag is not set, the status will be set to Inactive.

Calendar Calendar

The calendar assigned to the resource or role.

calendar If the synchronized resource is a role, the default workspace calendar is set to the calendar value for the role.

Title Title

The job title for the resource.

For example, a resource may have the title Senior Engineer.

resrouceTitleName

User Login User

The name of the user in the application that is also a resource.

applicationUser

Office Phone Office Phone

The office phone number for the resource.

officePhoneNumber


21

Other Phone Other Phone

The alternate phone numbers for the resource.

otherPhoneNumber

Employee ID Employee ID

The resource identifier within the organization, typically the employee number or social security number.

employeeNumber

E-Mail Address Email

The email address for the resource.

emailAddress

Unit of Measure Unit of Measure

The unit of measure used for the material resource.

unitOfMeasure


22

Default Units/Time Default Units/Time

The default unit/time is the maximum work units per time a resource or role can perform on all their assigned activities. The value is shown as either a percentage or units/duration depending on the user settings. If the Resource Type is Material, then units/duration are always displayed.

For example, if the selected resource is one person, a reasonable value may be 8 hours (units) per day (duration). In this case, the Max Units/Time would be 8.00h/d, or 8 hours of work per day, which is represented as 100%.

defaultUnitsPerHour

Resource Notes

Role Notes Description

Additional information for the resource or the role.

description


23

Timesheet Approval Manager

Manager

The person designated as the manager for the resource.

resourceManagerId If the user specified as the timesheet approval manager in P6 EPPM does not exist in Prime Projects the user specified as a fallback user will be set as the Manager in Prime Projects.

Limits

Limit fields specify constraints on the maximum amount of working units that may be assigned to resources and roles. The ApiEntityResourceWorkRate schema represents limit fields in the Prime Projects API. The following table lists P6 EPPM limit fields and their corresponding fields and API objects in Prime Projects:


24


Notes

Max Units/Time Max Units/Time

The maximum work units per time the resource or role can perform on all their assigned activities

For example, if the selected resource is one person, a reasonable value may be 8 hours (units) per day (duration). In this case, the Max Units/Time would be 8.00h/d, or 8 hours of work per day. Similarly, if the selected resource is a department with 5 people, then the Max Units/Time may be 40.00h/d. This means that 5 people can perform 40 hours of work per day, rather than 1 person performing 8 hours of work per day.

maxUnitsPerTime If shifts are set in P6 EPPM, P6 EPPM-Prime Projects Cloud Sync will set the value of the Max Units/Time field in Prime Projects to the value of the Max Units/Time of the first shift in P6 EPPM.


25

Effective Date Effective Start Date

The date that the corresponding units/time period and rates go into effect for the resource or role.

effectiveStartDate

Role Assignment Fields

Role assignment fields indicate the role to which a resource is assigned. The ApiEntityResourceRoleAssignment schema represents resource/role assignment fields in the Prime Projects API. The following table lists P6 EPPM resource/role assignment fields and their corresponding fields and API objects in Prime Projects:


Notes

Resource ID

The identifier for the resource assigned to the role.

resourceId

Role ID ID

The identifier for the role assigned to the resource.

roleId

Proficiency Proficiency

The skill level of the resource.

Skill levels are Master, Expert, Skilled, Proficient, and Inexperienced.

proficiency


26

Not Applicable Primary Role

Determines whether this is the resource's main role. A role that does not have this option selected indicates that this is a secondary role for the resource. You can only assign one primary role per resource. A resource is not required to have a primary role.

primaryFlag

Curve Fields

Curve fields determine the distribution of resource or role hours over the duration of an activity. The ApiEntityCurve schema represents curve fields in the Prime Projects API. The following table lists P6 EPPM resource curve fields and their corresponding fields and API object properties in Prime Projects:


Notes

Curve Curve Name

The name of the curve profile.

curveName

Risk Field Mappings

The following sections describe risk field mappings between P6 EPPM and Prime Projects.

Project Risk Fields

Project risk fields contain information about risks associated with a particular project. The ApiEntityProjectRisk schema represents project risk fields in the Prime Projects API. The following table lists P6 EPPM project risk fields and the corresponding fields and API object properties that represent equivalent data in Prime Projects:


27

P6 EPPM Fields Prime Projects Fields Prime Projects API Object Property

Notes

Project ID Project

The unique identifier for the project to which the risk was added.

project

ID ID

The unique identifier for the risk.

riskCode


28

Status Status

The status of the risk.

Proposed: The risk is identified and awaits approval.

Open: The risk is approved as a valid risk to the project.

Active: The risk is currently impacting the project.

Rejected (Closed): The risk is not seen as a valid risk to the project and therefore will not be tracked and managed by the project. The data for this risk cannot be modified after it is closed.

Managed (Closed): The risk occurred and was successfully managed by the project team and is no longer an active risk. The data for this risk cannot be modified after it is closed.

Impacted (Closed): The risk occurred, impacted the project and is no longer an active risk. The data for this risk cannot be modified after it is closed.

riskStatus


29

Name Name

The name of the risk.

riskName

Type Type

The type of risk. Valid values are Threat and Opportunity.

riskType


A detailed summary of the risk.

description

Cause Cause

A description of the cause of the risk.

cause

Effect Effect

The resulting effect of the presence of the risk.

effect

Risk Mitigation Fields

Risk mitigation fields detail information related to mitigation techniques applied during quantitative risk analysis in order to lower the impact of project risks. The ApiEntityRiskMitigation schema represents risk mitigation fields in the Prime Projects API. The following table lists P6 EPPM risk mitigation fields and the corresponding fields and API object properties that represent equivalent data in Prime Projects:

P6 EPPM Field Prime Projects Field


Description Notes

Name Name

The name of the risk response action item.

riskMitigationName


30

Activity Activity

The activity assigned to a risk response action item.

activity

Start Start Date

The earliest start date of all risk response action items.

startDate

Finish Finish Date

The latest finish date of all risk response action items.

finishDate

Planned Start Planned Start Date

The earliest scheduled start date of all risk response action items.

plannedStartDate

Planned Finish Planned Finish Date

The latest scheduled finish date of all the risk response action items.

plannedFinishDate


31

Status Status

The status of the risk response action item. The valid values are: Proposed, Sanctioned, Rejected, In-Progress, and Complete.

riskMitigationStatus

Risk Matrix Fields

Risk matrix fields describe the parameters of a risk scoring matrix used to determine the severity of project risks. The ApiEntityRiskMatrix schema represents risk matrix fields in the Prime Projects API. The following table lists P6 EPPM risk matrix fields and the corresponding fields and API object properties that represent equivalent data in Prime Projects:


Notes

Name Name

The name of the risk scoring matrix.

matrixName


The detailed summary of the risk scoring matrix.

matrixDescription

Risk Scoring Method Scoring Method

The type of calculation used to obtain an overall impact value. The valid values are Highest Impact and Average Impact.

riskScoreMatrixMethod


32

Risk Matrix Score Fields

Risk matrix score fields indicate the severity level of a given project risk. The ApiEntityRiskMatrixScore schema represents risk matrix score fields in the Prime Projects API. The following table lists P6 EPPM risk matrix score fields and their corresponding fields and API object properties in Prime Projects:


Notes

Severity 1 Severity 1

The severity level of schedule and cost impacts in your risk scoring matrix.

severityOne



severityTwo



severityThree



severityFour



severityFive


33



severitySix



severitySeven



severityEight



severityNine

Risk Score Type Fields

Risk score type fields indicate the category to which an individual risk belongs. The ApiEntityRiskScoreType schema represents risk score type fields in the Prime Projects API. The following table lists P6 EPPM risk score type fields and their corresponding fields and API object properties in Prime Projects:


Notes

Name Name

The name of the risk score type.

riskScoreTypeName

Type Type

The type of risk score.

scoreType


34

Risk Score Threshold Fields

Risk threshold fields define upper and lower bounds used for determining the severity of a given risk. The ApiEntityRiskScoreThreshold schema represents risk score threshold fields in the Prime Projects API. The following table lists P6 EPPM risk score threshold fields and their corresponding fields and API object properties in Prime Projects:


Notes

Name Name

The name of the risk threshold.

riskScoreThresholdName

Code Code

The unique identifier for the risk scoring threshold.

riskScoreThresholdCode

Not Applicable High

The upper limit of the risk score threshold range.

upper

Range Low

The lower limit of the risk score threshold range.

lower

Color Color

The color that represents the urgency of the risk.

color

Name (Level) Description

The value of the string.

stringValue

Schedule Management Field Mappings

The following sections describe schedule management field mappings between P6 EPPM and Prime Projects.


35

Activity Fields

Activity fields represent units of work that must be completed to accomplish your project's objectives. The ApiEntityActivity schema represents activity fields in the Prime Projects API. The following table lists P6 EPPM activity fields and their corresponding fields and API object properties in Prime Projects:


Notes

Activity ID Id (Activity)

The unique identifier for the activity.

activtiyId

Project ID Project

The unique identifier of the project to which the activity was added.

project

Activity Code ID

The project activity code assigned to the activity.

itemcode

Activity Name Name

The name of the activity.

activityName

WBS ID WBS

The WBS that the activity is associated with.

wbs

Physical Percent Complete


The activity percent complete, manually entered by a user.

physicalPercentComplete

Calendar ID Calendar

The calendar assigned to the activity.

calendar


36

Percent Complete Type

Percent Complete Type

Determines the way in which the application calculates the percent complete for the activity. Valid values are Physical, Duration, and Units.

percentCompleteType

Activity Type Type

The type of activity. Valid values are Activity Dependent, Resource Dependent, Level of Effort, Start Milestone, and Finish Milestone.

activityType

Duration Type Duration Type

Determines how remaining duration, units, and units/time are calculated when you update an activity that has resources assigned. The valid values are Fixed Units/Time, Fixed Units, Fixed Duration & Units, and Fixed Duration & Units/Time.

durationType

Activity Status Activity Status

Determines the status of the activity. Valid values are Not Started, In Progress, and Completed.

activiyStatus


37

Primary Resource Primary Resource

The user designated as the primary resource for the activity.

primaryResource

Total Float Total Float

The amount of time the activity can be delayed before delaying the project finish date. Calculated asLate Start minus Early Start or as Late Finish minus Early Finish.

totalFloat

Free Float Free Float

The amount of time the activity can be delayed before delaying the start date of any successor activity.

freeFloat

Remaining Duration Remaining Duration

The total working time from the activity remaining start date to the remaining finish date.

remainingDuration

Actual Labor Units Actual Labor Units

The number of units expended for all labor resources assigned to the activity.

actualLaborUnits


38

Remaining Labor Units

Remaining Labor Units

The remaining units for all labor resources assigned to the activity.

The Remaining Labor Units reflect the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero.

remainingLaborUnits

Planned Labor Units Planned Labor Units

The planned number of units for all labor resources assigned to the activity.

plannedLaborUnits

Planned Duration Planned Duration

The expected amount of time required to complete an activity.

The planned working time is calculated using the activity's calendar. The duration is measured from the activity's planned start date to its planned finish date.

plannedDuration


39

Planned Nonlabor Units

Planned Nonlabor Units

The planned units for all nonlabor resources assigned to the activities in the project.

plannedNonLaborUnits

Actual Nonlabor Units

Actual Nonlabor Units

The number of nonlabor units that have been expended on the activity.

actualNonLaborUnits

Remaining Nonlabor Units

Remaining Nonlabor Units

The remaining units for all nonlabor resources assigned to the activity.

The remaining units reflect the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, there are zero remaining units.

remainingNonLaborUnits

Constraint Date Primary Constraint Date

The constraint date for the activity, if the activity has a constraint.

constraintDate


40

Actual Start Actual Start

The date work on the activity began.

actualStart

Actual Finish Actual Finish

The date when the activity was completed.

actualFinish

Late Start Late Start

The latest possible date the remaining work for the activity can begin without delaying the project finish date.

This date is calculated based on activity relationships, schedule constraints, and resource availability.

lateStart

Late Finish Late Finish

The latest possible date the activity can finish without delaying the project finish date.


lateFinish

Expected Finish Expected Finish

The date you expect work on the activity to finish.

expectedFinish


41

Remaining Start Remaining Early Start

The date the remaining work for the activity is scheduled to begin.

This date can be updated manually by the user. Before the activity is started, this date is the same as the planned start.

remainingStart

Remaining Finish Remaining Early Finish

The date the remaining work for the activity is scheduled to finish.

If this activity is not started, this date is the planned finish. This date can be updated manually by the user, but it is overwritten when you schedule the project.

remainingFinish


42

Planned Start Planned Start

The date the activity is scheduled to start.

This date the activity is scheduled to begin is calculated by the project scheduler but can be updated manually by the project manager. This date cannot be changed by the project scheduler after the activity has started.

plannedStart

Planned Finish Planned Finish

The date the activity is scheduled to finish if the activity has not started.

This date is calculated by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has started.

plannedFinish


43

Remaining Late Start


The latest possible date the remaining work for the activity must begin without delaying the project finish date.

This date is calculated by the project scheduler based on activity relationship, schedule constraints, and resource availability.

remainingLateStart

Remaining Late Finish


The latest possible date the activity must finish without delaying the project finish date.

This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability. When the activity is complete, this field is blank.

remainingLateFinish

Primary Constraint Primary Constraint

The main restriction impacting the activity start or finish date.

constraintType


44

Activity Priority Late Start

The latest possible date the remaining work for the activity can begin without delaying the project finish date.


activityPriority

Secondary Constraint Date

Secondary Constraint Date

The date for the activity's secondary constraint, if the activity has a secondary constraint.

secondaryConstraintDate

Secondary Constraint

Secondary Constraint

The secondary restriction impacting the activity start or finish date.

secondaryConstraintType

Driving Path Flag Longest Path

The sequence of project activities from start to finish where the Total Duration is longer than any other path.

drivingPath


45

Suspend Date Suspend Date

The date work has temporarily stopped on a given activity.

suspendDate

Resume Date Resume Date

The date when a suspended task or activity is resumed.

resumeDate

Activity Owner Owner

The user responsible for the activity.

owner

Relationship Fields

Relationship fields determine whether activities must be completed sequentially and the order in which they must be completed. The ApiEntityRelationship schema represents relationship fields in the Prime Projects API. The following table lists P6 EPPM relationship fields and their corresponding fields and API object properties in Prime Projects:


Notes

Activity ID Relationship ID

The unique identifier for the relationship.

relationshipId

Lag Lag

The amount of time the predecessor activity was delayed, affecting the ability of its successor activity to start or finish.

lagHours


46

Relationship Type Relationship Type

The relationship type defining the behavior between two activities. The valid values are Finish to Start, Finish to Finish, Start to Start, and Start to Finish.

relationshipType

Activity Assignment Fields

Activity assignment fields determine how project resources are allocated to project activities. The ApiEntityAssignment schema represents assignment fields in the Prime Projects API. The following table lists P6 EPPM activity assignment fields and their corresponding fields and API object properties in Prime Projects:

P6 EPPM Field Prime Projects Field Prime Projects API Object

Notes

Resource Type Resource Type

The resource type. Valid values are Labor, Nonlabor, and Material.

resourceType

Resource ID Resource ID

The unique identifier for the resource assigned to the activity.

resource

Role ID Role ID

The unique identifier for the role assigned to the activity.

resourceRole


47

Remaining Units Remaining Units

The remaining units of work to be performed by the resource on the activity.

remainingUnits

Planned Units Planned Units

The planned units of work for the resource assignment on the activity.

plannedUnits

Remaining Units/Time

Remaining Units/Time

The units per time required for the resource assignment to complete the activity.

remainingUnitsPerHour

Planned Lag Planned Lag

The planned time lag between the activity's planned start date and the resource's planned start date on the activity.

plannedLag

Planned Units/Time Planned Units/Time

The planned units per time at which the resource is to perform work on the activity.

plannedUnitsPerHour


48

Actual Overtime Units

Actual Over Time Units

The actual overtime units worked by the resource on the activity.

actualOverTimeUnits

Remaining Lag Remaining Lag

The time lag between the activity's remaining start date and the resource's remaining start date on the activity.

remainingLag

Activity Actual Start Actual Start

If the activity has started, the date work began on the activity.

actualStart

Actual Remaining Start

Remaining Early Start

The date the assignment is scheduled to begin.

remainingStart

Actual Remaining Finish

Remaining Early Finish

The date the assignment is scheduled to be finished.

remainingFinish

Activity Planned Start

Planned Start

The planned start date for the assignment on the activity.

plannedStart


49

Planned Finish Planned Finish

The date the assignment is scheduled to be finished.

plannedFinishDate



The latest possible date the assignment must begin to not delay the project finish date.

remainingLateStart



The latest possible date the assignment must be finished to not delay the project finish date.

remainingLateFinish

Curve Curve

The resource's units and costs distributed over the duration of an activity.

curve

Drive Activity Dates Drive Activity Dates

Determines whether new resource or role assignments determine activity dates.

driveActivityDates


50

Proficiency Proficiency

The skill level of the resource an activity is assigned to. The valid values are Master, Expert, Skilled, Proficient, and Inexperienced.

proficiency

Task Field Mappings

The following sections describe P6 EPPM task fields and their corresponding fields and API object properties in Prime Projects.

Task Fields

Task fields represent actionable goals related to project activities that must be completed to accomplish your project's objectives. The ApiEntityWorkManagerTask schema represents task fields in the Prime Projects API. The following table lists P6 EPPMtask fields and their corresponding fields and API object properties in Prime Projects:

P6 EPPM Field Prime Projects Field


Description Notes


Scope Percent Complete

The percentage completion of the scope assignments linked to the activity.

Calculated as Installed Quantity divided by At Completion Quantity.

scopePercentComplete

The percentage completion of the scope items linked to the activity. It is calculated as the sum of the Quantity Completed Weight for the scope items assigned to the activity divided by the total Revised Quantity for the scope items.


51

Pre-Response Pessimistic Start

Pre-Response Pessimistic Start

The calculated activity start date that corresponds to the defined pessimistic percentile on the risk analysis histogram.

pessimisticStartDate

The calculated activity start date that corresponds to the defined pessimistic percentile on the risk analysis histogram.

Pre-Response Pessimistic Finish

Pre-Response Pessimistic Finish

The calculated project finish date that corresponds to the defined pessimistic percentile.

pessimisticFinishDate

The calculated project finish date that corresponds to the defined pessimistic percentile.

52

Oracle Prime Projects Cloud Sync Data Mapping Guide

Copyright © 2014, 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are “commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products and services from third-parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Legal Notices

cloud sync data mapping guide - oracle...cloud sync data mapping guide 6 p6 eppm field prime...

Documents