Activity

activityCode

String

The project activity code assigned to the activity.

No

activityId

String

The unique ID generated by the system.

No

activityName

String

The name of the activity.

No

activityPercentComplete

Double

The percent of the activity that has been completed. The value is based on the formula for the selected percent complete type. The percent complete type can be Physical, Duration, or Units.

No

activityPriority

Enum

Determines the priority of the activity when performing role leveling.

No

activityStatus

Enum

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

No

activityType

Enum

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

No

activityWorkManagerTaskDateStatus

String

The activity task date status associated to the activity.

Yes

activityWorkManagerTaskStatus

String

The activity task status associated to the activity.

Yes

activityWorkManagerTaskStatusIndicator

String

The activity task indicator associated to the activity.

Yes

actualDuration

Double

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.

Yes

actualFinishDate

DateTime

The date when the activity was completed.

No

actualLaborCost

Double

The actual costs for all labor resources assigned to the activity (Base Currency).

Yes

actualLaborCostProject

Double

The actual costs for all labor resources assigned to the activity (Project Currency).

Yes

actualLaborUnits

Double

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

No

actualMaterialCost

Double

The actual costs for all material resource assignments on the activity in base currency.

Yes

actualMaterialCostProject

Double

The actual costs for all material resource assignments on the activity in project currency.

Yes

actualNonLaborCost

Double

The actual costs for all nonlabor resource assignments on the activity (Base Currency).

Yes

actualNonLaborCostProject

Double

The actual costs for all nonlabor resource assignments on the activity in project currency.

Yes

actualNonLaborUnits

Double

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

No

actualStartDate

DateTime

The date work on the activity began.

No

actualThisPeriodLaborCost

Double

ActualThisPeriodLaborCost

No

actualThisPeriodMaterialCost

Double

The material costs incurred during a financial period.

Yes

actualThisPeriodNonLaborCost

Double

The nonlabor costs incurred during a financial period.

Yes

actualTotalCost

Double

The actual total cost for all resource assignments and direct activity costs (expenses) on the activity in base currency.

Yes

actualTotalCostProject

Double

The actual total cost for all resource assignments and direct activity costs (expenses) on the activity in project currency.

Yes

atCompletionBudgetLaborUnits

Double

AtCompletionBudgetLaborUnits

Yes

atCompletionCostVariance

Double

The difference between the baseline total cost and the current estimate of total cost.

Yes

atCompletionDuration

Double

The total working time from the activity's current start date to the current finish date.

Yes

atCompletionLaborCost

Double

The sum of the actual costs plus remaining costs for all labor resource assignments on the activity in base currency.

Yes

atCompletionLaborCostProject

Double

The sum of the actual costs plus remaining costs for all labor resource assignments on the activity in project currency.

Yes

atCompletionLaborUnits

Double

The sum of the actual plus remaining units for all labor resources assigned to the activity. It is the same as the planned labor units if the activity is not started, and the actual labor units after the activity is completed.

No

atCompletionMaterialCost

Double

The sum of the actual costs plus remaining costs for all material resource assignments on the activity in base currency.

Yes

atCompletionMaterialCostProject

Double

The sum of the actual costs plus remaining costs for all material resource assignments on the activity in project currency.

Yes

atCompletionNonLaborCost

Double

The sum of the actual costs plus remaining costs for all nonlabor resource assignments on the activity in base currency.

Yes

atCompletionNonLaborCostProject

Double

The sum of the actual costs plus remaining costs for all nonlabor resource assignments on the activity in project currency.

Yes

atCompletionNonLaborUnits

Double

The sum of the actual plus remaining units for all nonlabor resources assigned to the activity. It is the same as the planned nonlabor units if the activity is not started, and the actual nonlabor units once the activity is completed.

No

atCompletionTotalCost

Double

The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs (expenses) on the activity in base currency.

Yes

atCompletionTotalCostProject

Double

The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs (expenses) on the activity in project currency.

Yes

budgetAtCompletion

Double

The planned total cost through activity completion.

Yes

calendarCode

String

The unique code of the calendar.

Yes

calendarId

ForeignKey

The calendar assigned to the activity.

No

calendarName

String

The name of the calendar.

Yes

completedWeight

Double

CompletedWeight

Yes

constraintDate

DateTime

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

No

constraintType

Enum

The main restriction impacting the activity start or finish date.

No

costVarianceLaborUnits

Double

CostVarianceLaborUnits

Yes

critical

Boolean

Designates an activity as critical. An activity is defined as critical based upon the project settings configured for the project.

Yes

distributionShape

Enum

DistributionShape of the activity

No

drivingPath

Boolean

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

Yes

durationPercentComplete

Double

The duration percent complete for the activity. Calculated as planned duration minus remaining duration divided by planned duration multiplied by 100.

Yes

durationPercentOfPlanned

Double

The actual duration percent of planned duration for the activity. Calculated as actual duration divided by BL duration multiplied by 100.

Yes

durationType

Enum

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.

No

earlyFinishDate

DateTime

The earliest possible date the activity can finish. This date is calculated based on network logic, schedule constraints, and resource availability.

No

earlyStartDate

DateTime

The earliest possible date the remaining work for the activity can begin. This date is calculated based on network logic, schedule constraints, and resource availability.

No

earnedValueCost

Double

The portion of the baseline total cost of the activity that is actually completed as of the project data date.

Yes

earnedValueLaborUnits

Double

EarnedValueLaborUnits

Yes

estimateAtCompletionCost

Double

Calculated as ETC Cost plus Actual Cost to Date.

Yes

estimateToCompletionCost

Double

Yes

existenceProbability

Double

Signifies the probability that a particular activity occurs (exists) in a given project. For example, an activity that may or may not have to be done depending on the circumstances.

No

expectedFinishDate

DateTime

The date on which you anticipate work on the activity will finish.

No

finishDate

DateTime

The current finish date for the activity.

No

freeFloat

Double

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

Yes

isWorkPackage

Boolean

Whether this WBS is a work package.

No

laborUnitsCompletePercent

Double

The percent complete of units for all labor resources for the activity. Calculated as actual labor units divided by at completion labor unit multiplied by 100.

Yes

lateFinishDate

DateTime

The latest possible date the activity can finish without delaying the project finish date. This date is calculated based on activity relationships, schedule constraints, and resource availability.

No

lateStartDate

DateTime

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.

No

locationId

ForeignKey

The physical location associated with the activity.

No

materialCostPercentComplete

Double

MaterialCostPercentComplete

No

maximumRemainingDuration

Double

The maximum remaining duration of the activity.

Yes

minimumRemainingDuration

Double

The minimum remaining duration of the activity.

Yes

monteCarloScenario

Enum

The Risk Analysis scenario

Yes

mostLikelyRemainingDuration

Double

The most likely remaining duration of the activity.

Yes

nonLaborUnitsCompletePercent

Double

The percent complete of units for all nonlabor resources for the activity. Calculated as actual nonlabor units divided by at completion nonlabor unit multiplied by 100.

Yes

ownerId

Int

The user responsible for the activity.

No

parentActivityId

ForeignKey

The ID of the summary activity to which the activity belongs, if summary activities are used.

No

percentCompleteType

Enum

The activity percent complete type: 'Physical','Duration','Units', or 'Scope'.

No

percentCompleteWeightedBy

Enum

PercentCompleteWeightedBy of the activity

No

physicalPercentComplete

Double

The activity percent complete, manually entered by a user.

No

plannedDuration

String

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.

Yes

plannedFinishDate

DateTime

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.

No

plannedLaborCost

Double

The planned cost for all labor resources assigned to the activity in base currency.

Yes

plannedLaborCostProject

Double

The planned cost for all labor resources assigned to the activity in base currency.

No

plannedLaborUnits

Double

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

Yes

plannedNonLaborCost

Double

PlannedNonLaborCost

No

plannedNonLaborCostProject

Double

The planned cost for all nonlabor resources assigned to the activity in project currency.

No

plannedMaterialCost

Double

The planned cost for all material resources assigned to the activity in base currency.

Yes

plannedMaterialCostProject

Double

The planned cost for all material resources assigned to the activity in project currency.

No

plannedNonLaborUnits

Double

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

Yes

plannedStartDate

DateTime

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.

No

plannedTotalCost

Double

The expected total cost of the activity and includes all resources and direct activity costs (expenses) in base currency.

Yes

plannedTotalCostProject

Double

The expected total cost of the activity and includes all resources and direct activity costs (expenses) in project currency.

Yes

plannedValueCost

Double

PlannedValueCost

Yes

postPessimisticFinishDate

DateTime

The post pessimistic finish date for the activity.

Yes

postPessimisticStartDate

DateTime

The post pessimistic start date for the activity.

Yes

postResponseCriticalityIndex

Double

During the Post-Response risk analysis, tasks can join or leave the critical path. The criticality index expresses as a percentage, how often a particular task was on the critical path during the analysis.

Yes

prePessimisticFinishDate

DateTime

The pre pessimistic finish date for the activity.

Yes

prePessimisticStartDate

DateTime

The pre pessimistic start date for the activity.

Yes

preResponseCriticalityIndex

Double

During the Pre-Response risk analysis, tasks can join or leave the critical path. The criticality index expresses as a percentage, how often a particular task was on the critical path during the analysis.

Yes

primaryResourceId

Int

The user designated as the primary resource for the activity.

Yes

projectCode

String

The short name of the associated project.

Yes

projectId

ForeignKey

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

No

recordCount

Int

The number of activities added to the project.

Yes

remainingDuration

Double

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

No

remainingFinishDate

DateTime

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.

No

remainingFloat

Double

The amount of time remaining in which the activity can be delayed before delaying the project finish date. Calculated as late finish minus remaining finish.

Yes

remainingLaborCost

Double

The remaining cost for all labor resource assignments on the activity in base currency.

Yes

remainingLaborCostProject

Double

The remaining cost for all labor resource assignments on the activity in project currency.

Yes

remainingLaborUnits

Double

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.

No

remainingLateFinishDate

DateTime

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.

Yes

remainingLateStartDate

DateTime

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.

Yes

remainingMaterialCost

Double

The remaining cost for all material resource assignments on the activity in base currency.

Yes

remainingMaterialCostProject

Double

The remaining cost for all material resource assignments on the activity in project currency.

Yes

remainingNonLaborCost

Double

The planned cost for all nonlabor resources assigned to the activity in base currency.

No

remainingNonLaborCostProject

Double

The planned cost for all nonlabor resources assigned to the activity in project currency.

No

remainingNonLaborUnits

Double

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.

No

remainingStartDate

DateTime

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.

No

remainingTotalCost

Double

The remaining cost for all resource assignments and direct activity costs (expenses) on the activity in base currency.

Yes

remainingTotalCostProject

Double

The remaining cost for all resource assignments and direct activity costs (expenses) on the activity in project currency.

Yes

resumeDate

DateTime

The date when a suspended task or activity is resumed.

No

scheduleCostVariance

Double

The measure of schedule performance on a project.

Yes

schedulePercentComplete

Double

The activity schedule percent complete, which specifies how much of the activity's project baseline duration is complete so far. Calculated based on where the current data date falls relative to the activity's project baseline start and finish dates.

Yes

schedulePerfIndexLaborUnits

Double

The ratio of the earned value of labor units to the planned value of labor units. Calculated as earned value units divided by planned value units.

Yes

scheduleVarIndexLaborUnits

Double

The ratio of the schedule variance labor units and the planned value labor units. Calculated as schedule variance labor units divided by planned value labor units.

Yes

scopePercentComplete

Double

The percentage completion of the scope items linked to the activitiy. 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.

Yes

secondaryConstraintDate

DateTime

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

No

secondaryConstraintType

Enum

The secondary restriction impacting the activity start or finish date.

No

sequenceNumber

Int

The number that specifies the position of the activity relative to others within the view.

No

startDate

DateTime

The current start date for the activity.

No

suspendDate

DateTime

The date work has temporarily stopped on a given activity.

No

totalFloat

Double

The amount of time the activity can be delayed before delaying the project finish date. Calculated as late start minus early start of as late finish minus early finish.

Yes

unitsPercentComplete

Double

The percent complete of units for all labor and nonlabor resources assigned to the activity. Calculated as actual units divided by at completion units multiplied by 100.

Yes

varCost

Double

VarCost

Yes

wbsCode

String

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.

Yes

wbsId

ForeignKey

The WBS that the activity is associated with.

No

weight

Double

The importance of the activity in relation to other activities.

Yes

workPackageCode

String

The unique code of the work package that the activity is associated with.

No

workPackageId

Int

The unique identifier for the work package that the activity is associated with.

No

workPackageName

String

The name of the work package that the activity is associated with.

Yes