Activity

Description: An activity is a unit of work performed during the course of a project.

Field

Description

Id

The unique identifier of the activity.

Name

The name of the activity. The activity name does not have to be unique.

PlannedDuration

The activity planned duration.

EarlyStartDate

The early start date of the activity.

ActualDuration

The activity actual duration percent of planned. Computed as actual duration / BL duration * 100. The value can exceed 100. The BL duration is the activity's at completion duration from the project baseline.

RemainingDuration

 

SecondaryConstraintDate

The date to be used for the cstr_type2 assignment, if the activity has a cstr_type2 value. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.

SecondaryConstraintType

The additional constraint to be used by the scheduler.

Type

The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone', 'Finish Milestone', or 'WBS Summary'.

EarlyFinishDate

The early finish date of the activity.

StartDate

The early start date of the activity.

FinishDate

The early finish date of the activity.

LateStartDate

The late start date of the activity.

LateFinishDate

The late finish date of the activity.

ActualStartDate

The actual start date of the activity.

ActualFinishDate

The actual finish date of the activity.

LocationName

The name of the location assigned to the activity.

LocationCode

The code of the location assigned to the activity.

PlannedStartDate

The date the activity is scheduled to begin. This date is computed 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 been started.

PlannedFinishDate

The date the activity is scheduled to finish. This date is computed 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 been started.

PostResponsePessimisticFinish

The post-response pessimistic finish date for the activity.

PostResponsePessimisticStart

The post-response pessimistic start date for the activity.

PreResponsePessimisticFinish

The pre-response pessimistic finish date for the activity.

PreResponsePessimisticStart

The pre-response pessimistic start date for the activity.

PrimaryConstraintType

The primary constraint type of the activity.

PrimaryConstraintDate

The primary constraint date of the activity.

ObjectId

The unique ID generated by the system.

ProjectObjectId

The unique ID of the associated project.

WBSObjectId

The unique ID of the WBS for the activity.

RolledupWBSObjectId

Rolled up WBS Object Ids after filtering either by levels or tagging

Status

The current status of the activity, either 'Not Started', 'In Progress', or 'Completed'.

LongText

The long text value.

CalendarName

The name of the calendar.

CalendarObjectId

The unique id of the calendar.

CalendarCode

The unique code of the calendar.

IsStarred

The flag that indicates whether this activity is marked as starred activity.

MaximumDuration

The maximum duration of the activity

MinimumDuration

The minimum duration of the activity

MostLikelyDuration

The most likely duration of the activity

LocationObjectId

The unique ID of the location assigned to the activity.

ProjectId

The short code of the associated project.

RemainingStart

The remaining start date of the project.

RemainingFinish

The remaining finish date of the project.

SuspendDate

The suspend date of the project.

ResumeDate

The resume date of the project.

RemainingLateStart

The remaining late start date of the project.

RemainingLateFinish

The remaining late finish date of the project.

BaselineStartDate

The current start date of the activity in the project baseline.

BaselineFinishDate

The current finish date of the activity in the project baseline.

ActivityPercentComplete

The activity percent complete. This value is tied to the activity duration % complete, units % complete, or physical % complete, depending on the setting for the activity's percent complete type.

BaselineDuration

The duration for the activity in the project baseline.

BaselinePlannedLaborUnits

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

BaselinePlannedNonLaborUnits

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

IsWorkPackage

Whether this WBS is a work package.

WBSCode

The short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents' codes.

ExpectedFinishDate

The expected finish date of the activity in the project baseline.

DurationType

The duration type of the activity. One of 'FIXED_RATE', 'FIXED_DURATION', 'FIXED_QUANTITY', or 'FIXED_DURATION_AND_UNITS'.

Related Topics

Prime Business Objects

ActivityRisk

Calendar

EPS

Location

Project

ProjectCode

ProjectCodeType

Relationship

Resource

ResourceAssignment

Risk

RiskImpact

RiskMatrix

RiskMatrixScore

RiskMatrixThreshold

RiskResponseAction

RiskResponseActionImpact

RiskResponsePlan

RiskThreshold

RiskThresholdLevel

Role

UDFType

WBS

WBSSpread



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Monday, March 30, 2015