Description: An activity is a unit of work performed during the course of a project.
Field | Description |
---|---|
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. |
ActualFinishDate | The actual finish date of the activity. |
ActualStartDate | The actual start date of the activity. |
ActualTotalCost | The actual total cost for the activity, including labor resources, nonlabor resources, and project expenses. Actual total cost = actual labor costs + actual nonlabor costs + actual expense costs. |
AtCompletionDuration | The total working time from the activity's current start date to the current finish date. |
AtCompletionTotalCost | The total cost at completion for the activity, including labor resources, nonlabor resources, and project expenses. At completion total cost = at completion labor cost + at completion nonlabor cost + at completion expense cost. |
BaselineDuration | The duration for the activity in the project baseline. |
BaselineFinishDate | The current finish date of 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. |
BaselineStartDate | The current start date of the activity in the project baseline. |
CalendarCode | The unique code of the calendar. |
CalendarName | The name of the calendar. |
CalendarObjectId | The unique ID of the calendar. |
DurationType | The duration type of the activity. One of 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'. |
EarlyFinishDate | The early finish date of the activity. |
EarlyStartDate | The early start date of the activity. |
ExpectedFinishDate | 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. |
FinishDate | The early finish date of the activity. |
Id | The unique identifier of the activity. |
IsStarred | The flag that indicates whether this activity is marked as starred activity. |
IsWorkPackage | The flag that indicates whether this activity is the child of a work package WBS. |
LateFinishDate | The late finish date of the activity. |
LateStartDate | The late start date of the activity. |
LocationCode | The code of the location assigned to the Activity. |
LocationName | The name of the location assigned to the activity. |
LocationObjectId | The unique ID of the location assigned to the activity. |
LongText | The long text value. |
MaximumDuration | The maximum duration of the activity |
MinimumDuration | The minimum duration of the activity |
MostLikelyDuration | The most likely duration of the activity |
Name | The name of the activity. The activity name does not have to be unique. |
ObjectId | The unique ID generated by the system. |
PercentComplete | 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. |
Phase | An activity code to track the phase of the activity. |
PlannedDuration | The activity planned duration. |
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. |
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. |
PlannedTotalCost | The planned total cost for the activity, including labor resources, nonlabor resources, and project expenses. Planned total cost = planned labor cost + planned nonlabor cost + planned expense cost. |
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. |
ProjectId | The short code of the associated project. |
ProjectObjectId | The unique ID of the associated project. |
RemainingDuration |
|
RemainingEarlyFinishDate | The remaining early finish date of the project. |
RemainingEarlyStartDate | The remaining early start date of the project. |
RemainingLateFinishDate | The remaining late finish date of the project. |
RemainingLateStartDate | The remaining late start date of the project. |
RemainingTotalCost | The remaining total cost for the activity, including labor resources, nonlabor resources, and project expenses. Remaining total cost = remaining labor costs + remaining nonlabor costs + remaining expense costs. |
ResumeDate | The resume of the project. |
RolledupWBSObjectId | Rolled up WBS Object Ids after filtering either by levels or tagging |
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. |
StartDate | The early start date of the activity. |
Status | The current status of the activity, either 'Not Started', 'In Progress', or 'Completed'. |
SuspendDate | The suspend of the project. |
TotalActualCost | An Activity UDF to store Total Actual Cost for the Activity. |
TotalCommitmentCost | An Activity UDF to store Total Commitment Cost for the Activity. |
TotalPlannedCost | An Activity UDF to store Total Planned Cost for the Activity. |
Type | The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone', 'Finish Milestone', or 'WBS Summary'. |
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. |
WBSName | The name of the WBS element. |
WBSObjectId | The unique ID of the WBS for the activity. |
WBSPath | The WBS path of the Activity. |
Legal Notices
Copyright © 2013, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Monday, March 30, 2015