Project Fields

ActivityDefaultActivityType

string
restricted to
'Task Dependent'
'Resource Dependent'
'Level of Effort'
'Start Milestone'
'Finish Milestone'
'WBS Summary'

X

The default type for activities. Possible values are 'Task Dependent', 'Resource Dependent', 'Level of Effort', or 'Milestone'. A 'Task Dependent' activity is scheduled using the activity's calendar rather than the calendars of the assigned resources. A 'Resource Dependent' activity is scheduled using the calendars of the assigned resources. This type is used when several resources are assigned to the activity, but they may work separately. A 'Milestone' is a zero-duration activity without resources, marking a significant project event. A 'Level of Effort' activity has a duration that is determined by its dependent activities. Administration-type activities are typically 'Level of Effort'.

ActivityDefaultCalendarName

string

X

X

The name of the calendar assigned to new activities by default. Can be null for baselines.

ActivityDefaultCalendarObjectId

int

X

The unique ID of the calendar assigned to new activities by default. Can be null for baselines.

ActivityDefaultCostAccountObjectId

int

X

The unique ID of the cost account assigned to new activities and project expenses by default.

ActivityDefaultDurationType

string
restricted to
'Fixed Units/Time'
'Fixed Duration and Units/Time'
'Fixed Units'
'Fixed Duration and Units'

X

The duration type assigned to new activities by default. Valid values are 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'.

ActivityDefaultPercentCompleteType

string
restricted to
'Physical'
'Duration'
'Units'
'Scope'

X

The percent complete type assigned to new activities by default. Valid values are 'Physical', 'Duration', 'Units', and 'Scope'. 'Scope' is only a valid option when P6 is integrated with Oracle Primavera Cloud for scope management.

ActivityDefaultPricePerUnit

double
restricted to
minInclusive(0.0)

X

The price used to estimate resource costs for activities that have planned, actual, or remaining units, but no resource assignments. This price is also used to compute costs for activities in cases where resources are assigned but the resources have no prices. Resource cost is computed as the resource units multiplied by the price per time.

ActivityDefaultReviewRequired

boolean

The indicator that determines whether status changes for new activities must be approved by default.

ActivityIdBasedOnSelectedActivity

boolean

X

The flag that indicates how to auto-number activity IDs for new activities-Y/N - Y means use the selected activity's activity ID as prefix, N means use standard auto-numbering based on the prefix, suffix. Default = 'false'

ActivityIdIncrement

int

X

The increment used for auto-numbering of activity IDs. When a new activity is created, the activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique. Example: 'A', '1000', '10' yields activity IDs of 'A1010', 'A1020', 'A1030', etc.

ActivityIdPrefix

string
restricted to
maxLength(20)

X

The prefix used for auto-numbering of activity IDs. When a new activity is created, the activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique. Example: 'A', '1000', '10' yields activity IDs of 'A1010', 'A1020', 'A1030', etc.

ActivityIdSuffix

int

X

The suffix used for auto-numbering of activity IDs. When a new activity is created, the activity ID is automatically generated using auto-numbering. Activity ID auto-numbering concatenates the prefix and the suffix, with the suffix incremented to make the code unique. Example: 'A', '1000', '10' yields activity IDs of 'A1010', 'A1020', 'A1030', etc.

ActivityPercentCompleteBasedOnActivitySteps

boolean

X

The flag that indicates whether activity physical percent complete is automatically computed from the activity steps completed.

AddActualToRemaining

boolean

X

The flag that indicates whether to add actual to remaining or to subtract actual from at complete when actual units and costs are updated. Default = 'true'

AddedBy

string
restricted to
maxLength(255)

X

The name of the user who added the project to the database.

AllowNegativeActualUnitsFlag

boolean

X

The flag that indicates whether the project can allow the negative values for the actual units.

AllowStatusReview

boolean

X

The indicator that determines whether status updates to activities in a project are eligible for manual approval before committing changes.

AnnualDiscountRate

double
restricted to
minInclusive(0.0)
maxInclusive(100.0)

X

The user-defined number field that identifies the discount rate for the project.

AnticipatedFinishDate

dateTime

X

The anticipated finish date of Project element. User-entered - not dependent upon any other fields. If there are no children, the anticipated finish date will be the finish date displayed in the columns.

AnticipatedStartDate

dateTime

X

The anticipated start date of Project element. User-entered - not dependent upon any other fields. If there are no children, the anticipated start date will be the start date displayed in the columns.

AssignmentDefaultDrivingFlag

boolean

X

The default flag assigned to new assignments, to indicate whether assignments will drive activity dates.

AssignmentDefaultRateType

string
restricted to
'Price / Unit'
'Price / Unit 2'
'Price / Unit 3'
'Price / Unit 4'
'Price / Unit 5'

X

The default rate type when adding resource assignments to a project. Valid values are 'Price / Unit', 'Price / Unit2', 'Price / Unit3', 'Price / Unit4', and 'Price / Unit5'.

CalculateFloatBasedOnFinishDate

boolean

X

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. If true, each activity's float is calculated based on its project's ScheduledFinishDate. If false, then each activity's float is calculated based on the latest ScheduledFinishDate of all of the projects in the scheduling batch.

CheckOutDate

dateTime

X

X

The date on which the project was checked out of the Project Management database.

CheckOutStatus

boolean

X

The flag that indicates that the project is currently checked out to an external file or database and is being managed remotely.

CheckOutUserObjectId

int

X

X

The unique ID of the User that checked out this project.

ComputeTotalFloatType

string
restricted to
'Start Float = Late Start - Early Start'
'Finish Float = Late Finish - Early Finish'

'Smallest of Start Float and Finish Float'

X

The method for calculating total float for all activities. Start Float is the difference between the early and late start dates (Start Float = Late Start - Early Start); Finish Float is the difference between the early and late finish dates (Finish Float = Late Finish - Early Finish); and Smallest of Start Float and Finish Float is the most critical float value.

ContainsSummaryData

boolean

X

X

The flag that indicates that the Project has been summarized.

CostQuantityRecalculateFlag

boolean

X

The flag that, when costs and quantities are linked, indicates whether the quantities should be updated when costs are updated,

CreateDate

dateTime

X

X

The date this project was created.

CreateUser

string
restricted to
maxLength(255)

X

X

The name of the user that created this project.

CriticalActivityFloatLimit

double

X

The duration used to determine if an activity is critical. When an activity has total float that is less than or equal to this duration, the activity is marked as critical.

CriticalActivityFloatThreshold

double

X

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

CriticalActivityPathType

string
restricted to
'Critical Float'
'Longest Path'

X

The critical path type, which indicates how critical path activities are identified for the project, based on either 'Critical Float' or 'Longest Path'.

CriticalFloatThreshold

double

X

The option used for setting the critical float threshold value when scheduling projects.

CurrentBaselineProjectObjectId

int

X

The unique ID of the project's baseline to use for computing summaries.

CurrentBudget

double

X

The sum of the original budget plus the approved and pending budgets from the budget change log.

CurrentVariance

double

X

The difference between the current budget and the total spending plan. Calculated as current budget - total spending plan. Not rolled up

DataDate

dateTime

The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied.

DateAdded

dateTime

X

The date on which the project was added to the Project Management database.

DefaultPriceTimeUnits

string
restricted to
''
'Hour'
'Day'
'Week'
'Month'
'Year'
'Days Hours'
'Hours Minutes'

X

The time units associated with the project's default price per time. Valid values are 'Hour', 'Day', 'Week', 'Month', and 'Year'.

Description

string
restricted to
maxLength(500)

X

The description of the Project.

DiscountApplicationPeriod

string
restricted to
'Month'
'Quarter'
'Year'

X

the timescale for entering ROI spending and benefit plan. Valid values are 'Month', 'Quarter', or 'Year'.

DistributedCurrentBudget

double

X

The current budget values from one level lower.

EarnedValueComputeType

string
restricted to
''
'Activity Percent Complete'
'0 / 100'
'50 / 50'
'Custom Percent Complete'
'WBS Milestones Percent Complete'
'Activity Percent Complete Using Resource Curves'

X

The technique used for computing earned-value percent complete for activities within the Project. Valid values are 'Activity Percent Complete', '0 / 100', '50 / 50', 'Custom Percent Complete', 'WBS Milestones Percent Complete', and 'Activity Percent Complete Using Resource Curves'.

EarnedValueETCComputeType

string
restricted to
''
'ETC = Remaining Cost for Activity'
'PF = 1'
'PF = Custom Value'
'PF = 1 / CPI'
'PF = 1 / (CPI * SPI)'

X

The technique for computing earned-value estimate-to-complete for activities within the Project. Valid values are 'ETC = Remaining Cost for Activity', 'Performance Factor = 1', 'Performance Factor = Custom Value', 'Performance Factor = 1 / Cost Performance Index', and 'Performance Factor = 1 / (Cost Performance Index * Schedule Performance Index)'.

EarnedValueETCUserValue

double
restricted to
minInclusive(0.0)

X

The user-defined performance factor, PF, for computing earned-value estimate-to-complete. ETC is computed as PF * (BAC - earned value).

EarnedValueUserPercent

double

X

The user-defined percent complete for computing earned value for activities within the Project. A value of, say, 25 means that 25% of the planned amount is earned when the activity is started and the remainder is earned when the activity is completed.

EnablePublication

boolean

X

Enables the project to be processed by the Project Arbiter service.

EnableSummarization

boolean

X

The option which, when true, directs the Summarizer service to automatically summarize the project. If this is false, the project will be skipped during the summary run.

EtlInterval

string
restricted to
"Immediate"
"Scheduled"

X

The time interval for ETL for use in P6 Analytics, could be 'None', 'Scheduled', 'Immediate'.

ExternalCRKey

string

Unique identifier for the project in an external Content Repository.

FinancialPeriodTmplId

int

X

The unique identifier of the financial period calendar assigned to the project.

FinishDate

dateTime

X

The finish date of the project. This is a summary method calculated from fields populated by the Summarizer job service.

FiscalYearStartMonth

int

X

The month that marks the beginning of the fiscal year for the project.

ForecastFinishDate

dateTime

X

The alternate end date to be optionally used by the scheduler. The user sets the alternate end date by dragging the project bar in the Gantt Chart while manually leveling the resource profile in a resource analysis layout.

ForecastStartDate

dateTime

X

The alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout.

GUID

string
restricted to
pattern
'\{[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}\}|'

X

The globally unique ID generated by the system.

HasFutureBucketData

boolean

X

The flag that indicates whether a resource assignment in the project has future bucket data.

HistoryInterval

string
restricted to
''
'Month'
'Week'
'Day'
'Quarter'
'Year'
'Financial Period'

X

The time interval for how historical project data is stored for use in P6 Analytics, could be 'Month', 'Week', 'Quarter', 'Year' and 'Financial Period'.

HistoryLevel

string
restricted to
''
'None'
'Project'
'WBS'
'Activity'

X

The level of historical project data that is stored for use in P6 Analytics, cab be 'None', 'Project', 'WBS' and 'Activity'.

Id

string
restricted to
maxLength(40)

X

The short code assigned to each Project element for identification. Each Project element is uniquely identified by this short code.

IgnoreOtherProjectRelationships

boolean

X

Determines whether to ignore activity relationships between projects.

IndependentETCLaborUnits

double

X

The user-entered ETC total labor.

IndependentETCTotalCost

double

X

The user-entered ETC total cost.

IntegratedType

string
restricted to
''
'ERP'
'Fusion'
'Gateway'
'PrimaveraCloudScope'

X

The flag indicating whether the project is integrated with an Enterprise Resource Planning (ERP) system. 'Fusion' indicates the project is integrated with Oracle Fusion. 'ERP' indicates the project is integrated with another ERP system. 'Gateway' indicates the project is integrated with Oracle Primavera Gateway.

IntegratedWBS

boolean

The flag that determines whether the WBS is integrated with another application.

IsTemplate

boolean

X

X

The boolean value indicating if this Project is a template Project.

LastApplyActualsDate

dateTime

X

X

The last date Apply Actuals was run for this project.

LastFinancialPeriodObjectId

int

X

The unique ID of the last closed financial period for the project.

LastLevelDate

dateTime

X

X

The date the project was last leveled.

LastPublishedOn

dateTime

X

X

The date the project was last published.

LastScheduleDate

dateTime

X

X

The date the project was last scheduled.

LastSummarizedDate

dateTime

X

X

The date the project was last summarized.

LastUpdateDate

dateTime

X

X

The date this project was last updated.

LastUpdateUser

string
restricted to
maxLength(255)

X

X

The name of the user that last updated this project.

LevelAllResources

boolean

X

The resources to level.

LevelDateFlag

boolean

X

Gets the date the project was last leveled.

LevelFloatThresholdCount

int

X

The amount of float you want to maintain when activities are delayed because of resource conflicts. You can type a new number and time unit.

LevelOuterAssign

boolean

X

Include resource assignments in other projects to level.

LevelOuterAssignPriority

int

X

Set the range of the leveling priority that you specify when determining if a resource is over-allocated. Assignments in closed projects are considered.

LevelOverAllocationPercent

double

X

The maximum percentage by which resource availability can be increased during resource leveling. This increased resource availability is used to level if resources on an activity cannot be leveled after using up the activity's float limit. You can type a new percentage.

LevelPriorityList

string

X

Lists the fields by which to prioritize resources when leveling. Priorities are used only when more than one activity competes for the same resource at the same time. Sort Order: The order in which to level resources according to the field names displayed. Double-click the Sort Order field to choose Ascending, Descending, or Hierarchy (option only appears for fields that are hierarchical)

LevelResourceList

string

X

Consists of the list of resources to level.

LevelWithinFloat

boolean

X

To delay activities with resource conflicts only up to their late finish date.

LevelingPriority

int
restricted to
minInclusive(1)
maxInclusive(100)

X

The priority for scheduling.

LimitMultipleFloatPaths

boolean

X

The option used for enabling/disabling limit multiple float paths when scheduling projects.

LinkActualToActualThisPeriod

boolean

X

The flag that indicates whether actual units and costs are linked to actual-this-period units and costs. Setting this field to true asynchronously causes all actual-this-period values to be recalculated for the project via a job service. Default = 'true'.

LinkPercentCompleteWithActual

boolean

X

The flag that indicates whether actual units and cost should be recalculated when percent complete changes. Default = 'false'

LinkPlannedAndAtCompletionFlag

boolean

X

The flag that indicates whether the At Completion Cost/Units should be linked to Planned Cost/Units for not-started activities. Default = 'true'

LocationName

string
restricted to
maxLength(100)

X

X

The name of the location assigned to the project.

LocationObjectId

int

X

The unique ID of the location assigned to the project.

MakeOpenEndedActivitiesCritical

boolean

X

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

MaximumMultipleFloatPaths

int
restricted to
minInclusive(0)
maxInclusive(1000)

X

The number of critical float paths to calculate. For example, if you set the field to five, the module calculates the five most critical float paths ending with the activity you selected. The module ranks each float path from most critical to least critical, and stores the value for each activity in the Float Path field. For example, if you calculate five float paths, the module will store a value of one in the Float Path field for each activity in the most critical float path; the module will store a value of five for each activity in the least critical float path. Note: To view the critical float paths after you schedule the project, group activities in the Activity Table by Float Path and sort by Float Path Order. A Float Path value of one indicates that those activities are part of the most critical float path. The Float Path Order value indicates the order in which the activities were processed.

MultipleFloatPathsEnabled

boolean

X

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

MultipleFloatPathsEndingActivityObjectId

int

X

The activity in the WBS that you want to represent the end of the float paths. Typically, this will be a milestone activity or some other significant activity that has a start date or end date that cannot change. Note: if a value is not assigned, the module will choose an activity based on MultipleFloatPathsUseTotalFloat. If you are calculating multiple paths using Free Float, the module will choose the open-ended activity with the most critical Free Float. If you are calculating multiple paths using Total Float, the module will calculate the Total Float for all activity relationships, then choose the activity with the most critical Relationship Total Float.

MultipleFloatPathsUseTotalFloat

boolean

X

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

If True, then based on the activity you want the paths to end on, the module determines which predecessor activity has the most critical Relationship Total Float on the backward pass. The module repeats this process until an activity is reached that has no relationship. The module begins the forward pass from this activity and determines which successor activity has the most critical Relationship Successor Total Float. The module repeats this process until an activity is reached that has no relationship. These activities represent the most critical float path. The process begins again until the remaining sub-critical paths are calculated.

If False, then critical float paths are defined based on longest path. The most critical path will be identical to the critical path that is derived when you choose to define critical activities as Longest Path in the General tab. In a multicalendar project, the longest path is calculated by identifying the activities that have an early finish equal to the latest calculated early finish for the project and tracing all driving relationships for those activities back to the project start date. After the most critical path is identified, the module will calculate the remaining sub-critical paths.

MustFinishByDate

dateTime

X

The date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler.

Name

string
restricted to
maxLength(100)

X

The name of the Project element.

NetPresentValue

double

X

The estimated net value, at the present time for the project

OBSName

string
restricted to
maxLength(100)

X

X

The name of the person/role in the organization, sometimes referred to as the "responsible manager".

OBSObjectId

int

X

The unique ID of the project manager from the project's OBS tree who is responsible for the Project.

ObjectId

int

X

The unique ID generated by the system.

OriginalBudget

double

X

The original budget for the project.

OutOfSequenceScheduleType

string
restricted to
''
'Retained Logic'
'Progress Override'
'Actual Dates'

x

x

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

OverallProjectScore

int

X

The project score calculated based on all project code types assigned to this project.

OwnerResourceObjectId

int

X

The unique ID of the Owner Resource of this project.

ParentEPSId

string

The Id of the parent EPS.

ParentEPSName

string

The Name of the new parent EPS.

ParentEPSObjectId

int

X

The unique ID of the parent EPS of this project.

PaybackPeriod

int

X

The PaybackPeriod for the project

PerformancePercentCompleteByLaborUnits

double

X

The performance percent complete for the project according to the labor units. Computed as project Earned Value Labor Units divided by project Budget at Completion (Labor Units) multiplied by 100.

PlannedStartDate

dateTime

X

The planned start date of the project. Used by the project scheduler.

PostResponsePessimisticStart

dateTime

X

The Post Response Pessimistic Start date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PreResponsePessimisticFinish

dateTime

X

The Pre Response Pessimistic Finish date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PreResponsePessimisticStart

dateTime

X

The Pre Response Pessimistic Start date calculated by Oracle Primavera Cloud during quantitative risk analysis.

PricePerUnit

string
restricted to
maxLength(200)

Field that specifies whether to use role or resource price per unit.

PrimaryResourcesCanMarkActivitiesAsCompleted

boolean

X

The flag that indicates whether primary resources can mark the project activities as completed. If not selected, a primary resource can only mark an activity as For Review. In this case the project manager reviews the activity and marks it as either Rejected or completed.

PrimaryResourcesCanUpdateActivityDates

boolean

X

The flag that indicates whether primary resources can update activity dates in P6 Team Member Web.

ProjectForecastStartDate

dateTime

X

The alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout.

ProjectScheduleType

string
restricted to
''
'Duration'
'Resource'
'Cost'

X

The type of schedule the project is based on. It can contain either "Duration" or "Resource" or "Cost".

PropertyType

string
restricted to
''
'ApplyActuals'
'Schduling'
'ScheduleCheck'

X

X

The project property name associated with the scheduling of projects.

ProposedBudget

double

X

The Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log.

PublicationPriority

int

X

A priority value the Project Arbiter service uses to determine the order in which projects are submitted to the service queue, where 1 is highest priority and 100 is lowest priority.

PublishLevel

string
restricted to
'WBS Level'

'Assignment Level'

''

X

The publish level for the project publication.

RelationshipLagCalendar

string
restricted to
'Predecessor Activity Calendar'
'Successor Activity Calendar'
'24 Hour Calendar'
'Project Default Calendar'

X

he calendar used to calculate the lag between predecessors and successors for all activities. Valid values are 'Predecessor Activity Calendar', 'Successor Activity Calendar', '24 Hour Calendar', and 'Project Default Calendar'. If you do not select a calendar, the successor activity calendar is used.

ResetPlannedToRemainingFlag

boolean

X

The flag that indicates whether to reset Planned Duration and Units to Remaining Duration and Units, or to reset Remaining Duration and Units to Planned Duration and Units when the Activity Status is or becomes not started. Default = 'true'

ResourceCanBeAssignedToSameActivityMoreThanOnce

boolean

X

The flag that indicates whether a resource can be assigned more than once to the same activity. This is useful when the resource is expected to perform more than one role on an activity, for example, documentation plus QA.

ResourceName

string
restricted to
maxLength(255)

X

X

The name of the resource assigned as the Project Owner.

ResourcesCanAssignThemselvesToActivities

boolean

X

The flag that indicates whether timesheet application users are allowed to assign themselves to activities in this project.

ResourcesCanAssignThemselvesToActivitiesOutsideOBSAccess

boolean

X

The flag that indicates whether timesheet application users are allowed to assign themselves to activities in this project even if the resource does not have access to the relevant OBS for the activity.

ResourcesCanEditAssignmentPercentComplete

boolean

X

The flag that indicates whether the project's resource update the remaining units or the percent complete for their activities in the timesheet application.

ResourcesCanMarkAssignmentAsCompleted

boolean

X

The flag that indicates whether timesheet resources can mark the assignment as complete.

ResourcesCanStaffRoleAssignment

boolean

X

The flag that indicates whether team-member application users are allowed to staff themselves to role assignment in this project.

ResourcesCanViewInactiveActivities

boolean

X

The flag that indicates whether timesheet resources can view inactive project activities.

ReturnOnInvestment

double

X

The estimated return on investment for the project

ReviewType

string
restricted to
''
'Anyone Can Review'
'Everyone Must Review'

X

The type of status review required by team members, when the AllowStatusReview flag is true.

RiskExposure

double

X

The calculated exposure value for the project.

RiskLevel

string
restricted to
'Very High'
'High'
'Medium'
'Low'
'Very Low'

The risk level assigned to the project: 'Very High', 'High', 'Medium', 'Low', and 'Very Low'.

RiskMatrixName

string
restricted to
maxLength(40)

X

X

The name of the risk matrix.

RiskMatrixObjectId

int

X

The unique ID of the associated Risk Matrix.

RiskScore

int

X

The calculated risk score for the project.

ScheduleWBSHierarchyType

string
restricted to
'Complete'
'Partial'
'Levels'

X

The option used for specifying WBS Hierachy sync type.

ScheduledFinishDate

dateTime

X

The early finish date of the latest activity in the project, as computed by the project scheduler.

SourceProjectObjectId

int

X

X

The unique ID of the project from which the reflection project was created, if the current project is a reflection project.

StartDate

dateTime

X

The start date of the project. This is a summary method calculated from fields populated by the Summarizer job service.

StartToStartLagCalculationType

boolean

X

The method used to calculate lag when a start-to-start relationship exists and the predecessor starts out of sequence. Actual Start sets the successor's start according to the time elapsed from the predecessor's actual start (the successor's start date is the data date plus any remaining lag). Early Start sets the successor's start according to the amount of work that the predecessor activity accomplishes (the expired lag is calculated as the number of work periods between the actual start and the data date, and the successor's start date is the predecessor's internal early start plus any remaining lag).

Status

string
restricted to
'Planned'
'Active'
'Inactive'
'What-If'
'Requested'
'Template'

X

The project status: 'Planned', 'Active', 'Inactive', 'What-If', 'Requested', or 'Template'.

StatusReviewerName

string

X

The names of the users reviewing status updates.

StatusReviewerObjectId

string

X

The unique IDs of the users reviewing status updates.

StrategicPriority

int
restricted to
minInclusive(1)
maxInclusive(10000)

X

The project's priority. The range is from 1 to 10,000.

SummarizeResourcesRolesByWBS

boolean

The flag that indicates whether to create “Resource by WBS” and “Role by WBS” summary records at the project level, on summarization of a given project.

Note: Resource by WBS and Role by WBS records is always created for a “Fusion” project.

SummarizeToWBSLevel

int
restricted to
minInclusive(0)
maxInclusive(50)

X

The maximum level within the project's WBS to perform summarization - default to 2.

SummarizedDataDate

dateTime

X

The data date of the project when it was last summarized-only updated by summarizer.

SummaryAccountingVarianceByCost

double

X

the Planned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.

SummaryAccountingVarianceByLaborUnits

double

X

the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units.

SummaryActivityCount

int

X

the number of activities that are currently in progress.

SummaryActualDuration

double

X

The actual duration.

SummaryActualExpenseCost

double

X

The actual costs for all project expenses associated with the project.

SummaryActualFinishDate

dateTime

X

The latest actual finish date of all activities in the project.

SummaryActualLaborCost

double

X

The actual cost for all labor resources assigned to the activity.

SummaryActualLaborUnits

double

X

The actual labor units.

SummaryActualMaterialCost

double

X

The actual units for all material resources assigned to the activity.

SummaryActualNonLaborCost

double

X

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

SummaryActualNonLaborUnits

double

X

The actual nonlabor units.

SummaryActualStartDate

dateTime

X

The earliest actual start date of all activities in the project.

SummaryActualThisPeriodCost

double

X

The actual this period cost (will be labor or nonlabor).

SummaryActualThisPeriodLaborCost

double

X

The actual this period labor cost

SummaryActualThisPeriodLaborUnits

double

X

The actual this period labor units.

SummaryActualThisPeriodMaterialCost

double

X

The actual this period material cost.

SummaryActualThisPeriodNonLaborCost

double

X

The actual this period nonlabor cost.

SummaryActualThisPeriodNonLaborUnits

double

X

The actual this period nonlabor units.

SummaryActualTotalCost

double

X

The actual labor cost + actual nonlabor cost + actual expense cost as of the project data date.

SummaryActualValueByCost

double

X

the actual total cost incurred on the activity as of the project data date, computed as Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

SummaryActualValueByLaborUnits

double

X

the actual total labor units for the activity as of the project data date (that is, actual total cost by labor units).

SummaryAtCompletionDuration

double

X

The duration at completion.

SummaryAtCompletionExpenseCost

double

X

the sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost.

SummaryAtCompletionLaborCost

double

X

The sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost. Same as the planned labor costs if the activity is not started and the actual labor costs once the activity is completed.

SummaryAtCompletionLaborUnits

double

X

The sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as actual labor units + remaining labor units. Same as the planned labor units if the activity is not started and the actual labor units once the activity is completed.

SummaryAtCompletionMaterialCost

double

X

The material cost at completion. It is the sum of the actual plus remaining costs for all material resources assigned to the activity. Computed as actual material cost + remaining material cost. Same as the planned material costs if the activity is not started and the actual material costs once the activity is completed.

SummaryAtCompletionNonLaborCost

double

X

The nonlabor cost at completion. It is the sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost. Same as the planned nonlabor costs if the activity is not started and the actual nonlabor costs once the activity is completed.

SummaryAtCompletionNonLaborUnits

double

X

The nonlabor units at completion. It is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as actual nonlabor units + remaining nonlabor units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.

SummaryAtCompletionTotalCost

double

X

The estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC. Note that the method for computing ETC depends on the earned-value technique selected for the activity's WBS.

SummaryAtCompletionTotalCostVariance

double

X

the Baseline Planned Total Cost - At Completion Total Cost.

SummaryBaselineCompletedActivityCount

int

X

The number of completed activities in the baseline.

SummaryBaselineDuration

double

X

the planned duration for the activity in the primary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar.

SummaryBaselineExpenseCost

double

X

the planned cost for all project expenses associated with the activity in the primary baseline. Computed as the baseline actual expense cost plus the baseline remaining expense cost.

SummaryBaselineFinishDate

dateTime

X

The current latest finish date of all activities in the project for the current baseline.

SummaryBaselineInProgressActivityCount

int

X

The number of in-progress activities in the baseline.

SummaryBaselineLaborCost

double

X

the planned cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion labor units. If no resources are assigned, computed as the activity Baseline Planned Labor Units * Project Default Price / Time.

SummaryBaselineLaborUnits

double

X

the planned units for all labor resources assigned to the activity in the primary baseline. Computed as the baseline actual labor units plus the baseline remaining labor units.

SummaryBaselineMaterialCost

double

X

the planned cost for all material resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned.

SummaryBaselineNonLaborCost

double

X

the planned cost for all nonlabor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned, computed as the activity Baseline Planned Nonlabor Units * Project Default Price / Time.

SummaryBaselineNonLaborUnits

double

X

the planned units for all nonlabor resources assigned to the activity in the primary baseline. Computed as the baseline actual nonlabor units plus the baseline remaining nonlabor units.

SummaryBaselineNotStartedActivityCount

int

X

The number of activities not started in the baseline.

SummaryBaselineStartDate

dateTime

X

The current earliest start date of all activities in the Project for the current baseline.

SummaryBaselineTotalCost

double

X

the Planned Total Cost for the activity in the primary baseline, including labor resources, nonlabor resources, and project expenses. Baseline Planned Total Cost = Baseline Planned Labor Cost + Baseline Planned Nonlabor Cost + Baseline Planned Expense Cost.

SummaryBudgetAtCompletionByCost

double

X

the Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost.

SummaryBudgetAtCompletionByLaborUnits

double

X

the Baseline Labor Units

SummaryCompletedActivityCount

int

X

the number of activities that have an Actual Finish in the Project.

SummaryCostPercentComplete

double

X

The percent complete of cost for all nonlabor resources assigned. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.

SummaryCostPercentOfPlanned

double

X

The activity actual cost percent of planned. Computed as actual total cost / baseline total cost * 100, or equivalently as ACWP / BAC * 100. The value can exceed 100. The baseline total cost is the activity's at completion cost from the current baseline. This field is named SummaryCostPercentOfBudget in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.

SummaryCostPerformanceIndexByCost

double

X

the Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value.

SummaryCostPerformanceIndexByLaborUnits

double

X

the Earned Value Labor Units / Actual Labor Units.

SummaryCostVarianceByCost

double

X

the Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.

SummaryCostVarianceByLaborUnits

double

X

the Earned Value Labor Cost minus Actual Value Labor Cost.

SummaryCostVarianceIndex

double

X

The value that is calculated as the Cost Variance divided by Earned Value.

SummaryCostVarianceIndexByCost

double

X

the Cost Variance divided by Earned Value.

SummaryCostVarianceIndexByLaborUnits

double

X

the Cost Variance Labor Units divided by Earned Value Labor Units.

SummaryDurationPercentComplete

double

X

The percent complete of the activity duration. Computed as (planned duration - remaining duration) / planned duration * 100. The planned duration is taken from the current plan, not from the baseline.

SummaryDurationPercentOfPlanned

double

X

The summary actual duration percent of planned of all activities under this project. Computed as actual duration / baseline duration * 100. The value can exceed 100. The Baseline duration is the activity's at complete duration from the current baseline.

SummaryDurationVariance

double

X

The duration between the activity's baseline duration and the at complete duration. Computed as baseline planned duration - at completion duration.

SummaryEarnedValueByCost

double

X

the Budget at Completion * Performance % Complete. The method for computing the Performance Percent Complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline.

SummaryEarnedValueByLaborUnits

double

X

the portion of the baseline labor units that is actually completed as of the project data date. Computed as Baseline Labor Units * Performance % Complete. The planned labor units performed is essentially the labor units Earned Value for the activity. The method for computing the Performance % Complete depends on the Earned Value technique selected for the activity's WBS. The Baseline Labor Units is taken from the current baseline.

SummaryEstimateAtCompletionByCost

double

X

the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS.

SummaryEstimateAtCompletionByLaborUnits

double

X

the Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the Project.)

SummaryEstimateAtCompletionHighPercentByLaborUnits

double

X

the high forecast of Estimate At Completion (EAC) by labor units.

SummaryEstimateAtCompletionLowPercentByLaborUnits

double

X

the low forecast of Estimate At Completion (EAC) by labor units.

SummaryEstimateToCompleteByCost

double

X

the Remaining Total Cost for the activity or the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS (calculated from the primary baseline).

SummaryEstimateToCompleteByLaborUnits

double

X

the estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS.

SummaryExpenseCostPercentComplete

double

X

The percent complete of cost for all expenses associated with the project. It is computed as Actual Expense Cost / At Complete Expense Cost * 100, and it is always in the range of 0 to 100.

SummaryExpenseCostVariance

double

X

the Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost).

SummaryFinishDateVariance

double

X

The duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date.

SummaryInProgressActivityCount

int

X

the number of activities that are currently in progress.

SummaryLaborCostPercentComplete

double

X

The percent complete of cost for all labor resources assigned to the project. It is computed as Actual Labor Cost / At Complete Labor Cost * 100, and it is always in the range of 0 to 100.

SummaryLaborCostVariance

double

X

the Baseline Planned Labor Cost - At Completion Labor Cost.

SummaryLaborUnitsPercentComplete

double

X

The percent complete of units for all labor resources for the Project. Computed as actual labor units / at complete labor units * 100. Always in the range 0 to 100.

SummaryLaborUnitsVariance

double

X

The difference between baseline labor units and at completion labor units. Calculated as baseline labor units - at completion labor units.

SummaryLevel

string
restricted to
''
'WBS Level'
'Assignment Level'

X

The summary level for the project while performing project summarization.

SummaryNonLaborCostPercentComplete

double

X

The percent complete of cost for all non-labor resources assigned to the project. It is computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100, and it is always in the range of 0 to 100.

SummaryNonLaborUnitsPercentComplete

double

X

The percent complete of units for all nonlabor resources for the Project. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.

SummaryNonLaborUnitsVariance

double

X

The difference between baseline nonlabor units and at completion non labor units. Calculated as baseline nonlabor units - at completion nonlabor units.

SummaryNotStartedActivityCount

int

X

the number of activities that are currently not started.

SummaryPerformancePercentCompleteByCost

double

X

the percent complete of performance for all labor resources, nonlabor resources, and expenses. Computed as Earned Value / Budget At Completion * 100. Always in the range 0 to 100.

SummaryPerformancePercentCompleteByLaborUnits

double

X

the percent complete of performance for all labor resources. Computed as earned value labor units / baseline labor units * 100. Always in the range 0 to 100.

SummaryPlannedCost

double

X

The sum of all planned expense, non labor, labor, and material costs in the project.

SummaryPlannedDuration

double

X

The total working days between planned start and finish dates in the project.

SummaryPlannedExpenseCost

double

X

The sum of all planned expense costs in the project.

SummaryPlannedFinishDate

dateTime

X

The latest planned finish date of all activities in the project.

SummaryPlannedLaborCost

double

X

The sum of all planned labor costs in the project.

SummaryPlannedLaborUnits

double

X

The sum of all planned labor units in the project.

SummaryPlannedMaterialCost

double

X

The sum of all planned material costs in the project.

SummaryPlannedNonLaborCost

double

X

The sum of all planned non labor costs in the project.

SummaryPlannedNonLaborUnits

double

X

The sum of all planned non labor units in the project.

SummaryPlannedStartDate

dateTime

X

The earliest planned start date of all activities in the project.

SummaryPlannedValueByCost

double

X

the Budget at Completion * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Budget at Completion is computed from the primary baseline

SummaryPlannedValueByLaborUnits

double

X

the portion of the baseline labor units that is scheduled to be completed as of the project data date. Computed as Baseline Labor Units * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The Baseline Labor Units is taken from the current baseline.

SummaryProgressFinishDate

dateTime

X

the date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products.

SummaryRemainingDuration

double

X

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

SummaryRemainingExpenseCost

double

X

The remaining costs for all project expenses associated with the activities in the Project.

SummaryRemainingFinishDate

dateTime

X

The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date.

SummaryRemainingLaborCost

double

X

The remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the Project.

SummaryRemainingLaborUnits

double

X

The remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.

SummaryRemainingMaterialCost

double

X

The remaining material costs for all project expenses associated with the activities in the Project.

SummaryRemainingNonLaborCost

double

X

The remaining nonlabor costs for all project expenses associated with the activities in the Project.

SummaryRemainingNonLaborUnits

double

X

The remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project.

SummaryRemainingStartDate

dateTime

X

The earliest remaining start of all activities assigned to the Project.

SummaryRemainingTotalCost

double

X

The sum of all remaining total costs in the Project.

SummarySchedulePercentComplete

double

X

The measure that indicates how much of the Project baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline start, the schedule % complete is 0. If the data date is later than the baseline finish, the schedule % complete is 100. The schedule % complete indicates how much of the Project duration should be currently completed, relative to the selected baseline.

SummarySchedulePercentCompleteByLaborUnits

double

X

the percent complete of units for all labor resources. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100.

SummarySchedulePerformanceIndexByCost

double

X

the Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled.

SummarySchedulePerformanceIndexByLaborUnits

double

X

the Earned Value Labor Units divided by Planned Value Labor Units.

SummaryScheduleVarianceByCost

double

X

the Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled.

SummaryScheduleVarianceByLaborUnits

double

X

the Earned Value Labor Units minus the Planned Value Labor Units.

SummaryScheduleVarianceIndex

double

X

The value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.

SummaryScheduleVarianceIndexByCost

double

X

the Schedule Variance divided by the Planned Value.

SummaryScheduleVarianceIndexByLaborUnits

double

X

the Schedule Variance Labor Units divided by the Planned Value Labor Units.

SummaryStartDateVariance

double

X

The duration between the start date in the current project and the baseline start date. Calculated as start date - baseline start date.

SummaryToCompletePerformanceIndexByCost

double

X

the (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).

SummaryTotalCostVariance

double

X

The value that is calculated as baseline total cost - total cost.

SummaryTotalFloat

double

X

The amount of time the Project can be delayed before delaying the project finish date. Total float can be computed as late start - early start or as late finish - early finish; this option can be set when running the project scheduler.

SummaryUnitsPercentComplete

double

X

The percent complete of units for the resource assignments in the Project. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.

SummaryVarianceAtCompletionByLaborUnits

double

X

the Baseline Planned Total Labor Units minus Estimate at Completion Labor Units.

SyncWbsHierarchyFlag

boolean

X

The option used for enabling/disabling WBS Hierachy sync.

TeamMemberActivityFields

string
restricted to
maxLength(512)

The list of activity fields that can be updated by a team member using the P6 Team Member interfaces.

TeamMemberAddNewActualUnits

boolean

The indicator that determines whether team members enter new actual units.

TeamMemberAssignmentOption

string
restricted to
maxLength(32)

The indicator that determines whether team member can update activity fields, assignment fields, or both using the P6 Team Member interfaces.

TeamMemberAssignmentProficiencyFlag

boolean

The indicator that determines whether to use role assignment proficiency or resource's role proficiency.

TeamMemberCanStatusOtherResources

boolean

The indicator that determines whether team member can status other resource assignments on an activity.

TeamMemberCanUpdateNotebooks

boolean

The indicator that determines whether notebooks can be updated by the team member.

TeamMemberDisplayBaselineDatesFlag

boolean

The indicator that determines whether baseline dates are visible in P6 Team Member interfaces.

TeamMemberDisplayPlannedUnit

boolean

The indicator that determines whether or not a team member can display planned units on activities and assignments.

TeamMemberDisplayTotalFloatFlag

boolean

The indicator that determines whether or not a team member can view the Total Float for an activity.

TeamMemberIncludePrimaryResources

boolean

Primary Resource Flag determines if Team Members status their activities as Primary Resources too.

TeamMemberReadOnlyActivityFields

string
restricted to
maxLength(512)

The list of activity fields that can be viewed but not updated by a team member using the P6 Team Member interfaces.

TeamMemberResourceAssignmentFields

string
restricted to
maxLength(512)

The list of assignment fields that can be updated by a team member using the P6 Team Member interfaces.

TeamMemberStepUDFViewableFields

string
restricted to
maxLength(512)

The list of step user defined fields that can be viewed and updated by a team member using the P6 Team Member interfaces.

TeamMemberStepsAddDeletable

boolean

The flag which determines whether steps can be added or deleted in P6 Team Member interfaces.

TeamMemberViewableFields

string
restricted to
maxLength(512)

The list of fields that are viewable by a team member using the P6 Team Member interfaces.

TotalBenefitPlan

double

X

The sum of the monthly benefit plan.

TotalBenefitPlanTally

double

X

The sum of the monthly benefit plan tally.

TotalFunding

double

X

The total amount of funding contributed to the project by your funding sources.

TotalSpendingPlan

double

X

The sum of the monthly spending plan.

TotalSpendingPlanTally

double

X

The sum of the monthly spending plan tally.

UnallocatedBudget

double

X

The total current budget minus the distributed current budget.

UndistributedCurrentVariance

double

X

The total spending plan minus the total spending plan tally.

UnifierCBSTasksOnlyFlag

boolean

The flag that indicates whether P6 will only send activities with CBS codes assigned.

UnifierDataMappingName

string
restricted to
maxLength(200)

The Unifier data mapping name.

UnifierDeleteActivitiesFlag

boolean

The flag that indicates whether activities removed from the P6 Schedule are deleted in Unifier.

UnifierEnabledFlag

boolean

The flag that indicates whether P6 integration with Unifier schedule sheet is enabled.

UnifierProjectName

string

Field to specify Unifier project number.

UnifierProjectNumber

string
restricted to
maxLength(200)

The Unifier project number.

UnifierScheduleSheetName

string
restricted to
maxLength(200)

The Unifier schedule sheet name.

UnitPerTimeOvertimeFactor

string
restricted to
maxLength(200)

Field that specifies to use role or resource unitPerTime and overtime factor.

UseExpectedFinishDates

boolean

x

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

UseProjectBaselineForEarnedValue

boolean

X

The flag that indicates whether earned value should be calculated based on the project baseline or the user's primary baseline. This setting only affects Project Management, not the Integration API or Primavera's Web application.

WBSCategoryObjectId

int

X

The unique ID of the associated WBS category value. Note that the label used for the WBS category is dynamic; it is controlled by the system administrator.

WBSCodeSeparator

string
restricted to
maxLength(2)

X

The character used to separate the concatenated code fields for the project's WBS tree.

WBSHierarchyLevels

int

X

The option used for specifying WBS Hierachy sync level

WBSMilestonePercentComplete

double

X

The WBSMilestonePercentComplete field determines whether to calculate earned value by defining milestones at the WBS level and assigning a level of significance or weight to each of them. As progress occurs and you mark each milestone complete, the WBS element's performance percent complete is calculated based on the weight of the milestone.

WBSObjectId

int

X

X

The internal WBS ID of the project. This ID cannot be used to load a WBS object directly.

WebSiteRootDirectory

string
restricted to
maxLength(120)

X

The root directory for storing project Web site files before they are published to the Web server.

WebSiteURL

string
restricted to
maxLength(200)

X

The project Web site URL, which is the Web address of the project's website.