Project

actualCost

Double

The actual cost of the project.

No

actualCostPresentValue

Double

Also known as discounted value of the overall project actuals, future cash flows are discounted using the project's annual discount rate. Use the present value of the expected cash flow as a metric for project prioritization and selection.

Yes

actualDuration

Double

The actual duration represents the total working time between the project actual start and actual finish for a project.

Yes

actualFinishDate

DateTime

The actual finish displays the date on which a project is considered complete.

No

actualStartDate

DateTime

The actual start indicates the date work on the project began.

No

addressLine1

String

The first line of the address of a location. This might be the building number and street address.

No

addressLine2

String

The second line of the address of a location. This might be a neighborhood or town.

No

allocatedFundApprovedBudgetVariance

Double

The total and time phased variance between the project's Allocated Fund and Approved Budget.

Yes

allocatedFundForecastVariance

Double

The total and time phased variance between the project's Allocated Fund and Forecast.

Yes

allocatedFundPlannedBudgetVariance

Double

The total and time phased variance between the project's Allocated Fund and Planned Budget.

Yes

annualDiscountRate

Double

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

No

atCompletionCost

Double

The at completion cost of the project.

Yes

baseCurrencyCode

String

The three letter currency character code for the base currency.

Yes

benefitsCost

Double

Project benefits is the income or positive cash flow from which all charges, costs, and expenses are subtracted to arrive at the net income. Also called sales, turnover, or revenue.

No

benefitsCostDistributed

Double

The amount of benefits currently allocated across the project timescale.

Yes

benefitsCostPresentValue

Double

Also known as discounted value of the overall project benefits, future cash flows are discounted using the project's annual discount rate. Use the present value of a project's expected cash flow as a metric for project prioritization and selection.

Yes

benefitsCostUndistributed

Double

The amount of benefits that have not been allocated across the project timescale.

Yes

budgetCurrentCost

Double

The total cost of the project budget, including all transfers and changes in base currency.

Yes

budgetCurrentCostProject

Double

The total cost of the project budget, including all transfers and changes in project currency.

Yes

budgetOriginalCost

Double

The total original cost of the project budget, before transfers and changes in base currency.

Yes

budgetOriginalCostProject

Double

The total original cost of the project budget, before transfers and changes in project currency.

Yes

businessSegment

String

A project code field to define the business segment of the project.

No

calculateFloatBasedOnFinishDate

String

The flag that indicates how each activity's float will be calculated with respect to other projects in the scheduling batch. This setting only has an effect when scheduling multiple projects at the same time

No

calendarId

ForeignKey

The unique identifier of the calendar associated with the project.

No

cityName

String

The city name for a location.

No

computeTotalFloatType

Enum

The method for calculating total float for all activities.

No

constructionCostValue

Double

The total of all project-related costs incurred over the period of construction. This field is in base currency and calculated from construction Value Project field based on the specified exchange rate

Yes

constructionCostValueProject

Double

The total of all project-related costs incurred over the period of construction. This would generally include cost of materials, subcontract totals, overhead costs, general conditions and tax.

Yes

costPerfIndex

Double

The measure of a project's cost efficiency. A value less than 1 indicates the project's Actual Cost has exceeded its planned value.

No

costVariance

Double

The measure of cost performance on a project. A negative value indicates that the Actual Cost has exceeded the planned value.

No

countryCode

String

The country for a location.

No

criticalActivityFloatThreshold

String

The maximum float time for activities before they are marked critical.

No

criticalActivityPathType

Enum

Indicates activity critical path type.

No

criticalDuration

Int

The number of days past the end date that an activity can go before it is marked as a critical activity.

No

currencyId

ForeignKey

The unique identifier of the currency used by the project.

No

currentApprovedBudget

Double

The current approved budget of the project.

Yes

currentApprovedBudgetBaseDistributed

Double

The amount of approved budget currently allocated across the project timescale.

Yes

currentApprovedBudgetBasePresentValue

Double

The present value, also known as discounted value, of the portfolio approved budget. Future cash flows are discounted using the project's annual discount rate

Yes

currentApprovedBudgetBaseUndistributed

Double

The amount of approved budget unallocated across the project timescale.

Yes

currentApprovedFinishDate

DateTime

The finish date for the current approved budget set by the capital planner.

Yes

currentApprovedSpendCostVariance

Double

The total and time phased variance between the project's Approved Budget and Actuals.

Yes

currentApprovedSpendVariance

Double

The total and time phased variance between the project's Current Approved Budget and Spends.

Yes

currentApprovedStartDate

DateTime

The start date for the current approved budget set by the capital planner.

Yes

dataDate

DateTime

The data date of the project.

No

description

String

The description of the project.

No

earnedValueCost

Double

The earned value cost of the project.

No

estAtCompleteCost

Double

The expected total cost of the project when the defined scope of work will be completed.

No

estToCompleteCost

Double

The estimated cost needed to complete the project.

No

exchangeRateType

Enum

The type of exchange rate. Floating: A fixed, user-defined exchange rate. Pegged: Follows the exchange rates defined at the workspace.

No

finishDate

DateTime

The date on which all project work is complete.

No

finishDateVariance

DateTime

The duration between the project's finish date and default snapshot. When the field value is generated through a P6 EPPM connection, then it represents the duration between the finish date in the current project and the baseline finish date.

Yes

forecastCost

Double

The total estimation of a project's remaining costs. Once projects have begun, project managers update the project forecast to represent remaining cost estimates for the duration of the project's life cycle.

No

forecastCostDistributed

Double

The amount of forecast cost currently allocated across the project timescale.

Yes

forecastCostPresentValue

Double

Also known as discounted value of the overall project forecast, future cash flows are discounted using the project's annual discount rate. Use the present value of a project's expected cash flow as a metric for project prioritization and selection.

Yes

forecastCostUndistributed

Double

The amount of forecast cost unallocated across the project timescale.

Yes

forecastCurrApprCostVariance

Double

The total and time phased variance between the project's Forecast and Approved Budget.

Yes

forecastCurrApprVar

Double

The total and time phased variance between the project's forecast and current approved budget.

Yes

forecastFinishDate

DateTime

The planned finish date of a project's remaining forecast cost.

No

forecastStartDate

DateTime

The planned start date of a project's remaining forecast cost.

No

ignoreOtherProjectRelationships

Boolean

The option used by the scheduler for treating activity relationships between projects when scheduling.

No

integratedType

Enum

The indicator that determines whether the resource is integrated with an Enterprise Resource Planning (ERP) system, 'Fusion' indicates the resource is integrated with Oracle Fusion. 'ERP' indicates the resource is integrated with another ERP system.

Yes

intRateReturn

Double

The quantitative measurement used to compare the profitability of project investments. The rate at which investors will receive returns on their investments in a project.

No

latitude

Double

The geographical coordinate for the latitude of the location. The default format for latitude is decimal degrees format, but the format you need to use will depend on your geolocation service.

No

linkForecastToSpend

Boolean

Enables you to link project forecast data to project spends data. When linked any updates to the project's spends values will automatically be applied to the project's forecast values.

No

locationName

String

A name for the location that your users will understand and recognize.

No

longitude

Double

The geographical coordinate for the longitude of the location. The default format for longitude is decimal degrees format, but the format you need to use will depend on your geolocation service.

No

makeOpenEndedActivitiesCritical

String

The option used by the scheduler for automatically leveling resources when scheduling projects.

No

manager

String

The manager or person responsible for the project.

No

maximumMultipleFloatPaths

String

The number of critical float paths to calculate

No

multipleFloatPathsEnabled

String

The Boolean value that indicates whether multiple critical float paths (sequences of activities) should be calculated in the project schedule.

No

multipleFloatPathsEndingActivityObjectId

String

The activity in the WBS that you want to represent the end of the float paths.

No

multipleFloatPathsUseTotalFloat

String

The Boolean value that decides whether or not to use total float in multiple float path calculations.

No

mustFinishByDate

DateTime

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

No

netPresentValue

Double

The difference between the present value (PV) of the future cash flows from current investments and project costs.

No

outOfSequenceScheduleType

String

The type of logic used to schedule the progressed activities: 'Retained Logic', 'Progress Override', or 'Actual Dates'.

No

P6 EPS

String

The parent eps id of the project.

No

paybackPeriod

Double

The estimate of the length of time that will transpire before net profits recover the initial and periodic costs of an investment to carry out the selected project.

No

percentComplete

Double

The estimated percentage of work that has been completed on the project.

No

percentCompleteWeightedBy

Enum

The weight for scope items is calculated using quantity.

Yes

planDuration

Double

The duration between project planned start and project planned finish.

Yes

planEndDate

DateTime

The finish date for the time phased planned budget of the project. Planned budget cost spread will adjust when this date is changed.

No

plannedBudget

Double

The planned budget of the project.

No

plannedBudgetDistributed

Double

The amount of planned budget allocated across the project timescale.

Yes

plannedBudgetPresentValue

Double

Also known as discounted value of the overall project planned budget, future cash flows are discounted using the project's annual discount rate. Use the present value of a project's expected cash flow as a metric for project prioritization and selection.

Yes

plannedBudgetUndistributed

Double

The amount of planned budget unallocated across the project timescale.

Yes

plannedValueCost

Double

The amount of approved capital spend on a schedule portion of work on a project. Planned value cost is often used for Earned Value Management.

No

planStartDate

DateTime

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.

No

postalCode

String

The postal code, post code, or zip code of a location.

No

postPessimisticFinishDate

DateTime

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

Yes

postPessimisticStartDate

DateTime

The calculated project post-response start date that corresponds to the defined pessimistic percentile.

Yes

prePessimisticFinishDate

DateTime

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

Yes

prePessimisticStartDate

DateTime

The calculated project pre-response start date that corresponds to the defined pessimistic percentile.

Yes

primaveraWorkspace

String

A Project Code field to define the Primavera Cloud Workspace of the Project.

No

profitabilityIndex

Double

The index based on the value of a project's present values divided by initial project investments.

No

projectCode

String

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

No

projectCurrencyCode

String

The three letter currency character code for the project currency.

No

projectDefaultDurationType

Enum

The default project duration type. Values are: ‘Fixed Units/Time’, ‘Fixed Duration and Units/Time’, ‘Fixed Units’, or ‘Fixed Duration and Units’.

No

projectId

String

The unique identifier for the project.

No

projectName

String

The name of the project.

No

proposedBudget

Double

The proposed budget of the project.

Yes

proposedBudgetBaseDistributed

Double

The amount of proposed budget currently allocated across the project timescale.

Yes

proposedBudgetBasePresentValue

Double

The present value, also known as discounted value, of the portfolio proposed budget. Future cash flows are discounted using the project's annual discount rate.

Yes

proposedBudgetBaseUndistributed

Double

The amount of proposed budget unallocated across the project timescale.

Yes

proposedFinishDate

DateTime

The finish date for the proposed budget of the project.

Yes

proposedForecastCostVariance

Double

The total and time phased variance between the project's Proposed Budget and Forecast.

Yes

proposedForecastVariance

Double

The total and time phased variance between the project's proposed budget and forecast.

Yes

proposedPlannedCostVariance

Double

The total and time phased variance between the project's Proposed Budget and Planned Budget.

Yes

proposedPlannedVar

Double

The total and time phased variance between the project's proposed budget and planned budget.

Yes

proposedStartDate

DateTime

The start date for the proposed budget of the project.

Yes

relationshipLagCalendar

Enum

The calendar used to calculate the lag between predecessors and successors for all activities.

No

remainingCost

Double

The remaining total cost for the project, including labor resources, nonlabor resources, and project expenses.

Yes

remainingDuration

Double

The duration between the project start and project finish.

Yes

reportCycleId

Int

The report cycle of the project.

No

reportCycleNamingBoundary

Enum

Determines when period names will be rest. The options available are based on the selection for reporting cycle. The standard calendar start and end dates are used as boundaries for resetting periods.

Yes

returnInvestment

Double

The return on investment of the project.

No

riskLevel

Enum

The risk level assigned to the project.You can use risk level to determine what projects should be included in your plans, as well as which projects should be of priority.

No

riskMatrixId

ForeignKey

The unique identifier of the risk matrik assigned to the project for calculating project risk scores.

No

riskMatrixName

String

The name of the associated risk matrix.

Yes

riskScore

Int

The risk score value is based on the probability and impacts of a risk. It is derived from the probability impact matrix and any associated rules.

Yes

schedPerfIndex

Double

The schedule performance index of the project.

No

scheduleCostVariance

Double

The measure of schedule performance on a project. A negative value indicates that less work was actually performed than was scheduled.

No

scheduledFinishDate

DateTime

The calculated latest early finish date, which is based on the schedule most recently generated for the project.

Yes

securityGuid

String

The security guid of the project.t

Yes

sequenceNumber

Int

The sequence number of the project.

No

spendCost

Double

Linking spends and forecast enables you to combine costs already incurred on a project with the project's predicted future costs effectively creating an at completion curve. Spends cannot be edited if a project has a status of proposal.

No

spendEffectiveDate

DateTime

The month in which a spend value was last added to the project.

Yes

spendFinishDate

DateTime

The finish date for the project spends.

No

spendForecastCostVariance

Double

The total and time phased variance between the project's Actuals and Forecast.

Yes

spendForecastVar

Double

The total and time phased variance between the project's spends and forecast.

Yes

spendPlannedCostVariance

Double

The total and time phased variance between the project's Actuals and Planned Budget.

Yes

spendPlannedVariance

Double

The total and time phased variance between the project's spends and planned budget.

Yes

spendStartDate

DateTime

The start date for the project spends.

No

startDate

DateTime

The date on which work on the project starts.

No

startDateVariance

DateTime

The duration between the project's start date and default snapshot. When the field value is generated through a P6 EPPM connection, then it represents the duration between the start date in the current project and the baseline start date.

Yes

startToStartLagCalculationType

Boolean

The method used to calculate lag when a start-to-start relationship exists and the predecessor starts out of sequence.

No

stateCode

String

A unique identifier for the state or province.

No

stateName

String

The state, region, or province of a location.

No

status

Enum

The status of the project.

No

strgyPriorityNum

Int

The strategic priority of the project.

No

useExpectedFinishDates

String

The option used for setting activity finish dates as the expected finish dates when scheduling projects.

No

websiteUrl

String

The link to a website related to the project.

No

workspaceId

Int

The unique identifier of the workspace.

No

yearEndForecastCost

Double

Total forecast at the end of year actuals till date, with respect to the current year.

No

ytdSpendCost

Double

A measurement of capital spent on a project starting from the beginning of the year up to the present date. YTD Spends provide an overview of the total amount of spends accrued on a project over the current Period Year.

No