Field Map for Oracle Primavera P6 Reporting Database

This documents the mapping from the Oracle Primavera P6 Reporting Database persisted fields to the fields in the database from whence they are derived.

RESOURCEASSIGNMENTSPREADTop
ResourceAssignmentObjectId
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
StartDate
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
EndDate
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
resourceobjectid
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
RoleObjectId
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActivityObjectId
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
WBSObjectId
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
projectobjectid
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
CostAccountObjectId
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActualRegularUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualOvertimeUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingLateUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingLateUnits
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualRegularCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualOvertimeCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingLateCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingLateCost
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ChangeDate
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
change_skey
ODS TableRESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
STG_RESOURCEASSIGNMENTSPREADTop
ResourceAssignmentObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
StartDate
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
EndDate
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ResourceObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
RoleObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActivityObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
WBSObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ProjectObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
CostAccountObjectId
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActualRegularUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualOvertimeUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingLateUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingLateUnits
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualRegularCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualOvertimeCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
StaffedRemainingLateCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
UnstaffedRemainingLateCost
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
change_skey
ODS TableSTG_RESOURCEASSIGNMENTSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ACTIVITYSPREADTop
ActivityObjectId
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
StartDate
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
EndDate
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ActivityCode
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ActivityName
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
WBSObjectId
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
projectobjectid
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActualLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedValueLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingNonLaborUnits
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedValueCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateExpenseCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingMaterialCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingNonLaborCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingTotalCost
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ChangeDate
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
change_skey
ODS TableACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
STG_ACTIVITYSPREADTop
ActivityObjectId
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
StartDate
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
EndDate
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ActivityCode
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ActivityName
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
WBSObjectId
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ProjectObjectId
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActualLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedValueLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingNonLaborUnits
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
ActualTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
BaselineActualTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1ActualTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
Baseline1PlannedTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
PlannedValueCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateExpenseCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLateTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingMaterialCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingNonLaborCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
RemainingTotalCost
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
change_skey
ODS TableSTG_ACTIVITYSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typebigint
ACTIVITYTop
ObjectIdThe unique ID generated by the system.
ODS TableActivity
API Business ObjectActivity
API Field NameObjectId
PMDB Tabletask
PMDB Field Nametask_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivity
API Business ObjectActivity
API Field NameProjectObjectId
PMDB Tabletask
PMDB Field Nameproj_id
Data Typeinteger
WBSObjectIdThe unique ID of the WBS for the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameWBSObjectId
PMDB Tabletask
PMDB Field Namewbs_id
Data Typeinteger
CalendarObjectIdThe unique ID of the calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool.
ODS TableActivity
API Business ObjectActivity
API Field NameCalendarObjectId
PMDB Tabletask
PMDB Field Nameclndr_id
Data Typeinteger
EstimatedWeightThe estimation weight for the activity, used for top-down estimation. Top-down estimation weights are used to calculate the proportion of units that each activity receives in relation to the other activities within the same WBS. Top-down estimation distributes estimated units in a top-down manner to activities using the WBS hierarchy.
ODS TableActivity
API Business ObjectActivity
API Field NameEstimatedWeight
PMDB Tabletask
PMDB Field Nameest_wt
Data Typedouble
IsNewFeedbackThe flag that indicates that a resource has sent feedback notes about this activity which have not been reviewed yet.
ODS TableActivity
API Business ObjectActivity
API Field NameIsNewFeedback
PMDB Tabletask
PMDB Field Namerev_fdbk_flag
Data Typestring
AutoComputeActualsThe option that determines whether the activity's actual and remaining units, start date, finish date, and percent complete are computed automatically using the planned dates, planned units and the schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. Use this option to assume that all work for the activity proceeds according to plan.
ODS TableActivity
API Business ObjectActivity
API Field NameAutoComputeActuals
PMDB Tabletask
PMDB Field Nameauto_compute_act_flag
Data Typestring
PercentCompleteTypeThe activity percent complete type: 'Physical', 'Duration', or 'Units'.
ODS TableActivity
API Business ObjectActivity
API Field NamePercentCompleteType
PMDB Tabletask
PMDB Field Namecomplete_pct_type
Data Typestring
TypeThe type of activity, either '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'.
ODS TableActivity
API Business ObjectActivity
API Field NameType
PMDB Tabletask
PMDB Field Nametask_type
Data Typestring
DurationTypeThe duration type of the activity. One of 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'. For 'Fixed Units/Time' activities, the resource units per time are constant when the activity duration or units are changed. This type is used when an activity has fixed resources with fixed productivity output per time period. For 'Fixed Duration and Units/Time' activities, the activity duration is constant as the units or resource units per time are changed. This type is used when the activity is to be completed within a fixed time period regardless of the resources assigned. For 'Fixed Units' activities, the activity units are constant when the duration or resource units per time are changed. This type is used when the total amount of work is fixed, and increasing the resources can decrease the activity duration.
ODS TableActivity
API Business ObjectActivity
API Field NameDurationType
PMDB Tabletask
PMDB Field Nameduration_type
Data Typestring
ReviewStatusThe activity review status. Valid values are 'OK', 'For Review', and 'Rejected'. Primary resources set the status to 'For Review' when they believe the activity is completed but are not allowed to mark activities as completed.
ODS TableActivity
API Business ObjectActivity
API Field NameReviewStatus
PMDB Tabletask
PMDB Field Namereview_type
Data Typestring
StatusThe current status of the activity, either 'Not Started', 'In Progress', or 'Completed'.
ODS TableActivity
API Business ObjectActivity
API Field NameStatus
PMDB Tabletask
PMDB Field Namestatus_code
Data Typestring
IdThe short ID that uniquely identifies the activity within the project.
ODS TableActivity
API Business ObjectActivity
API Field NameId
PMDB Tabletask
PMDB Field Nametask_code
Data Typestring
NameThe name of the activity. The activity name does not have to be unique.
ODS TableActivity
API Business ObjectActivity
API Field NameName
PMDB Tabletask
PMDB Field Nametask_name
Data Typestring
PrimaryResourceObjectIdThe unique ID of the primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using Timesheets.
ODS TableActivity
API Business ObjectActivity
API Field NamePrimaryResourceObjectId
PMDB Tabletask
PMDB Field Namersrc_id
Data Typeinteger
TotalFloatThe amount of time the activity 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.
ODS TableActivity
API Business ObjectActivity
API Field NameTotalFloat
PMDB Tabletask
PMDB Field Nametotal_float_hr_cnt
Data Typedouble
FreeFloatThe amount of time the activity can be delayed before delaying the start date of any successor activity.
ODS TableActivity
API Business ObjectActivity
API Field NameFreeFloat
PMDB Tabletask
PMDB Field Namefree_float_hr_cnt
Data Typedouble
RemainingDurationThe remaining duration of the activity. Remaining duration is the total working time from the activity remaining start date to the remaining finish date. The remaining working time is computed using the activity's calendar. Before the activity is started, the remaining duration is the same as the planned duration. After the activity is completed the remaining duration is zero.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingDuration
PMDB Tabletask
PMDB Field Nameremain_drtn_hr_cnt
Data Typedouble
ActualLaborUnitsThe actual units for all labor resources assigned to the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualLaborUnits
PMDB Tabletask
PMDB Field Nameact_work_qty
Data Typedouble
RemainingLaborUnitsThe remaining units for all labor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingLaborUnits
PMDB Tabletask
PMDB Field Nameremain_work_qty
Data Typedouble
PlannedLaborUnitsThe planned units for all labor resources assigned to the activity. This field is named BudgetedLaborUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedLaborUnits
PMDB Tabletask
PMDB Field Nametarget_work_qty
Data Typedouble
PlannedDurationThe total working time from the activity planned start date to the planned finish date. The planned working time is computed using the activity's calendar. This field is named OriginalDuration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedDuration
PMDB Tabletask
PMDB Field Nametarget_drtn_hr_cnt
Data Typedouble
PlannedNonLaborUnitsThe planned units for all nonlabor resources assigned to the activity. This field is named BudgetedNonLaborUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedNonLaborUnits
PMDB Tabletask
PMDB Field Nametarget_equip_qty
Data Typedouble
ActualNonLaborUnitsThe actual units for all nonlabor resources assigned to the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualNonLaborUnits
PMDB Tabletask
PMDB Field Nameact_equip_qty
Data Typedouble
RemainingNonLaborUnitsThe remaining units for all nonlabor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the planned units. After the activity is completed, the remaining units are zero.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingNonLaborUnits
PMDB Tabletask
PMDB Field Nameremain_equip_qty
Data Typedouble
PrimaryConstraintDateThe constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.
ODS TableActivity
API Business ObjectActivity
API Field NamePrimaryConstraintDate
PMDB Tabletask
PMDB Field Namecstr_date
Data Typedate
ActualStartDateThe date on which the activity is actually started.
ODS TableActivity
API Business ObjectActivity
API Field NameActualStartDate
PMDB Tabletask
PMDB Field Nameact_start_date
Data Typedate
ActualFinishDateThe date on which the activity is actually finished.
ODS TableActivity
API Business ObjectActivity
API Field NameActualFinishDate
PMDB Tabletask
PMDB Field Nameact_end_date
Data Typedate
LateStartDateThe latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.
ODS TableActivity
API Business ObjectActivity
API Field NameLateStartDate
PMDB Tabletask
PMDB Field Namelate_start_date
Data Typedate
LateFinishDateThe latest possible date the activity must finish without delaying the project finish date. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.
ODS TableActivity
API Business ObjectActivity
API Field NameLateFinishDate
PMDB Tabletask
PMDB Field Namelate_end_date
Data Typedate
ExpectedFinishDateThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameExpectedFinishDate
PMDB Tabletask
PMDB Field Nameexpect_end_date
Data Typedate
EarlyStartDateThe earliest possible date the remaining work for the activity can begin. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.
ODS TableActivity
API Business ObjectActivity
API Field NameEarlyStartDate
PMDB Tabletask
PMDB Field Nameearly_start_date
Data Typedate
EarlyFinishDateThe earliest possible date the activity can finish. This date is computed by the project scheduler based on network logic, schedule constraints, and resource availability.
ODS TableActivity
API Business ObjectActivity
API Field NameEarlyFinishDate
PMDB Tabletask
PMDB Field Nameearly_end_date
Data Typedate
RemainingEarlyStartDateThe date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining start date is the same as the planned start date. This is the start date that Timesheets users follow.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingEarlyStartDate
PMDB Tabletask
PMDB Field Namerestart_date
Data Typedate
RemainingEarlyFinishDateThe remaining late end date, which is calculated by the scheduler.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingEarlyFinishDate
PMDB Tabletask
PMDB Field Namereend_date
Data Typedate
PlannedStartDateThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedStartDate
PMDB Tabletask
PMDB Field Nametarget_start_date
Data Typedate
PlannedFinishDateThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedFinishDate
PMDB Tabletask
PMDB Field Nametarget_end_date
Data Typedate
ReviewFinishDateThe finish date of the activity as proposed by the primary resource using Timesheets, while the activity is in "For Review" state. If the project manager approves the activity completion, the review finish is copied to the actual finish.
ODS TableActivity
API Business ObjectActivity
API Field NameReviewFinishDate
PMDB Tabletask
PMDB Field Namereview_end_date
Data Typedate
RemainingLateStartDatethe remaining late start date calculated by the scheduler.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingLateStartDate
PMDB Tabletask
PMDB Field Namerem_late_start_date
Data Typedate
RemainingLateFinishDatethe remaining late finish date calculated by the scheduler.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingLateFinishDate
PMDB Tabletask
PMDB Field Namerem_late_end_date
Data Typedate
PrimaryConstraintTypeThe type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler. Start date constraints are 'Start On', 'Start On or Before', and 'Start On or After'. Finish date constraints are 'Finish On', 'Finish On or Before', and 'Finish On or After'. Another type of constraint, 'As Late As Possible', schedules the activity as late as possible based on the available free float.
ODS TableActivity
API Business ObjectActivity
API Field NamePrimaryConstraintType
PMDB Tabletask
PMDB Field Namecstr_type
Data Typestring
LevelingPriorityThe activity priority used to prioritize activities in a project when performing resource leveling. Valid values are 'Top', 'High', 'Normal', 'Low', and 'Lowest'.
ODS TableActivity
API Business ObjectActivity
API Field NameLevelingPriority
PMDB Tabletask
PMDB Field Namepriority_type
Data Typestring
SecondaryConstraintDateThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameSecondaryConstraintDate
PMDB TableTASK
PMDB Field Name
Data Typedate
SecondaryConstraintTypeThe additional constraint to be used by the scheduler. If more than one constraint is assigned, this value should be restricted to one of the following: "Start On or Before", "Start On or After", "Finish On or Before", or "Finish On or After".
ODS TableActivity
API Business ObjectActivity
API Field NameSecondaryConstraintType
PMDB TableTASK
PMDB Field Name
Data Typestring
FloatPathThe integer representing the critical path this activity is on. The value 1 is the most critical path, value 2 is the second most critical path, etc.
ODS TableActivity
API Business ObjectActivity
API Field NameFloatPath
PMDB Tabletask
PMDB Field Namefloat_path
Data Typeinteger
FloatPathOrderThe integer representing the order in which this object was found on one of the critical paths.
ODS TableActivity
API Business ObjectActivity
API Field NameFloatPathOrder
PMDB Tabletask
PMDB Field Namefloat_path_order
Data Typeinteger
ActualThisPeriodLaborUnitsThe actual this period labor units (hours) for all labor resources assigned to the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualThisPeriodLaborUnits
PMDB Tabletask
PMDB Field Nameact_this_per_work_qty
Data Typedouble
ActualThisPeriodNonLaborUnitsThe actual this period nonlabor units (hours) for all nonlabor resources assigned to the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualThisPeriodNonLaborUnits
PMDB Tabletask
PMDB Field Nameact_this_per_equip_qty
Data Typedouble
IsLongestPathThe flag that indicates whether an activity is on the longest path. Default = 'N'
ODS TableActivity
API Business ObjectActivity
API Field NameIsLongestPath
PMDB Tabletask
PMDB Field Namedriving_path_flag
Data Typestring
SuspendDateThe start date when the progress of a task or resource dependent activity is delayed from. The suspend date must be later than the actual start date, which the activity must have. The progress of the activity can be resumed by setting the resume date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.
ODS TableActivity
API Business ObjectActivity
API Field NameSuspendDate
PMDB Tabletask
PMDB Field Namesuspend_date
Data Typedate
ResumeDateThe date when a suspended task or resource dependent activity should be resumed. The resume date must be later than the suspend date and earlier than the actual finish date. The Suspend/Resume period behaves like a nonworktime on the activity calendar or resource calendar for task and resource dependent activities.
ODS TableActivity
API Business ObjectActivity
API Field NameResumeDate
PMDB Tabletask
PMDB Field Nameresume_date
Data Typedate
ExternalEarlyStartDateThe date value that determines the early start date for imported activities with external constraints lost (relations from/to external projects that do not exist in the database). This field is the relationship early finish date (REF) when the lost relationship type is FS or SS. When the relationship type is SF or FF, this field is calculated as REF - RD of the successor.
ODS TableActivity
API Business ObjectActivity
API Field NameExternalEarlyStartDate
PMDB Tabletask
PMDB Field Nameexternal_early_start_date
Data Typedate
ExternalLateFinishDateThe date value that determines the Late Finish Date for imported activities with external constraints lost (from/to external projects that do not exist in the database). This field is the relationship late finish date (RLF) when the lost relationship type is FS or FF. When the relationship type is SS or SF, this field is calculated as RLS + RD of the predecessor.
ODS TableActivity
API Business ObjectActivity
API Field NameExternalLateFinishDate
PMDB Tabletask
PMDB Field Nameexternal_late_end_date
Data Typedate
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivity
API Business ObjectActivity
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
AccountingVarianceThe difference between the planned value of work scheduled and the actual cost of work performed. Computed as accounting variance = planned value - actual cost . A negative value indicates that actual costs have exceeded the scheduled costs.
ODS TableActivity
API Business ObjectActivity
API Field NameAccountingVariance
PMDB Table
PMDB Field Name
Data Typenumber
AccountingVarianceLaborUnitsThe difference between the planned value of work scheduled and the actual work performed. Computed as accounting variance labor units = planned value labor units - actual units. A negative value indicates that actual costs have exceeded the scheduled costs.
ODS TableActivity
API Business ObjectActivity
API Field NameAccountingVarianceLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
ActualDurationThe total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar.
ODS TableActivity
API Business ObjectActivity
API Field NameActualDuration
PMDB Table
PMDB Field Name
Data Typenumber
ActualExpenseCostThe actual costs for all project expenses associated with the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualExpenseCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualLaborCostThe actual costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity actual labor units * project default price / time.
ODS TableActivity
API Business ObjectActivity
API Field NameActualLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualMaterialCostThe sum of all regular and overtime costs for material resources.
ODS TableActivity
API Business ObjectActivity
API Field NameActualMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualNonLaborCostThe actual costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity actual nonlabor units * project default price / time.
ODS TableActivity
API Business ObjectActivity
API Field NameActualNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualThisPeriodLaborCostThe actual this period labor cost for all labor resources assigned to the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameActualThisPeriodLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualThisPeriodMaterialCostThe sum of all material resource costs for the current period.
ODS TableActivity
API Business ObjectActivity
API Field NameActualThisPeriodMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualThisPeriodNonLaborCostThe actual this period nonlabor cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity actual nonlabor units * project default price / time.
ODS TableActivity
API Business ObjectActivity
API Field NameActualThisPeriodNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualTotalCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameActualTotalCost
PMDB Table
PMDB Field Name
Data Typenumber
ActualTotalUnitsthe sum of Actual Labor Units and Actual Nonlabor Units.
ODS TableActivity
API Business ObjectActivity
API Field NameActualTotalUnits
PMDB TableTASK
PMDB Field Name
Data Typenumber
AtCompletionDurationThe total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionDuration
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionExpenseCostThe sum of the actual plus remaining costs for all expenses associated with the activity. Computed as actual expense cost + remaining expense cost.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionExpenseCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionLaborUnitsThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionLaborUnits
PMDB TableTASK
PMDB Field Name
Data Typenumber
AtCompletionLaborUnitsVarianceThe project baseline planned total labor units minus the estimate at completion labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionLaborUnitsVariance
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionMaterialCostThe sum of all actual and remaining costs for material resources.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionNonLaborUnitsThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionNonLaborUnits
PMDB TableTASK
PMDB Field Name
Data Typenumber
AtCompletionTotalCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionTotalCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionTotalUnitsThe sum of the actual plus remaining units for the resource assignment on the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionTotalUnits
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionVarianceThe difference between the project baseline total cost and the current estimate of total cost. Computed as VAC = BAC - EAC. A negative value indicates an estimated cost overrun. BAC is computed from the current project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameAtCompletionVariance
PMDB Table
PMDB Field Name
Data Typenumber
BaselineDurationThe duration for the activity in the project baseline. The 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.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselineDuration
PMDB Table
PMDB Field Name
Data Typenumber
BaselineFinishDateThe current finish date of the activity in the project baseline. Set to the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselineFinishDate
PMDB Table
PMDB Field Name
Data Typedate
BaselinePlannedDurationThe planned duration for the activity in the project 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. This field is named Baseline Budgeted Duration in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedDuration
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedExpenseCostThe planned costs for all project expenses associated with the activity. This field is named Baseline Budgeted Expense Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedExpenseCost
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborCostThe cost at completion for all labor resources assigned to the activity in the project baseline. Computed from the baseline at completion labor units. If no resources are assigned, computed as the activity BL labor units * project default price / time. This field is named Baseline Budgeted Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedLaborUnitsThe planned units for all labor resources assigned to the activity. This field is named Baseline Budgeted Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedMaterialCostThe Planned Material Cost for a project baseline activity.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborCostThe planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named Baseline Budgeted Non Labor Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedNonLaborUnitsThe planned units for all nonlabor resources assigned to the activity. This field is named Baseline Budgeted Non Labor Units in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedNonLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
BaselinePlannedTotalCostThe 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. This field is named Baseline Budgeted Total Cost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselinePlannedTotalCost
PMDB Table
PMDB Field Name
Data Typenumber
BaselineStartDateThe current start date of the activity in the project baseline. Set to the planned start date until the activity is started, then set to the actual start date.
ODS TableActivity
API Business ObjectActivity
API Field NameBaselineStartDate
PMDB Table
PMDB Field Name
Data Typedate
BudgetAtCompletionThe planned total cost through activity completion. Computed as planned labor cost + planned nonlabor cost + planned expense cost, same as the planned total cost.
ODS TableActivity
API Business ObjectActivity
API Field NameBudgetAtCompletion
PMDB Table
PMDB Field Name
Data Typenumber
CalendarNameThe name of the calendar.
ODS TableActivity
API Business ObjectActivity
API Field NameCalendarName
PMDB Tablecalendar
PMDB Field Nameclndr_name
Data Typestring
CostPercentCompleteThe percent complete of costs for all labor resources, nonlabor resources, and expenses for the activity. Computed as actual total cost / at completion total cost * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
CostPercentOfPlannedThe percent complete of planned costs for all labor resources, nonlabor resources, and expenses for the activity. Computed as actual total cost / BL planned total cost * 100. The value can exceed 100.
ODS TableActivity
API Business ObjectActivity
API Field NameCostPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
CostPerformanceIndexThe earned value divided by the actual cost. A value less than 1 indicates that actual cost have exceeded the planned value.
ODS TableActivity
API Business ObjectActivity
API Field NameCostPerformanceIndex
PMDB Table
PMDB Field Name
Data Typenumber
CostPerformanceIndexLaborUnitsThe ratio of the earned value labor units and the actual work performed. Computed as CPI labor units = earned value labor units / actual labor units .
ODS TableActivity
API Business ObjectActivity
API Field NameCostPerformanceIndexLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
CostVarianceThe difference between the earned value and the actual cost of work performed. Computed as CV = earned value - actual costs. A negative value indicates that actual costs have exceeded the value of work performed.
ODS TableActivity
API Business ObjectActivity
API Field NameCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
CostVarianceIndexThe ratio of the cost variance and the earned value of work performed. Computed as CVI = cost variance / earned value.
ODS TableActivity
API Business ObjectActivity
API Field NameCostVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
CostVarianceIndexLaborUnitsThe ratio of the cost variance labor units and the earned value of work performed. Computed as CVI labor units = CV labor units / earned value labor units
ODS TableActivity
API Business ObjectActivity
API Field NameCostVarianceIndexLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
CostVarianceLaborUnitsThe difference between the earned value of labor units and the actual cost of labor units. Calculated as CV labor units = earned value planned units - actual units. A negative value indicates that actual costs have exceeded the value of work performed.
ODS TableActivity
API Business ObjectActivity
API Field NameCostVarianceLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
DataDateThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameDataDate
PMDB Table
PMDB Field Name
Data Typedate
Duration1VarianceThe duration between the activity's primary baseline duration and the at complete duration. Computed as primary baseline duration - at completion duration.
ODS TableActivity
API Business ObjectActivity
API Field NameDuration1Variance
PMDB Table
PMDB Field Name
Data Typenumber
DurationPercentCompleteThe percent complete of the activity duration. Computed as (planned duration - remaining duration) / planned duration * 100. Always in the range 0 to 100. The planned duration is taken from the current plan, not from the baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameDurationPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
DurationPercentOfPlannedThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameDurationPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
DurationVarianceThe duration between the activity's project baseline duration and the at complete duration. Computed as project baseline duration - at completion duration.
ODS TableActivity
API Business ObjectActivity
API Field NameDurationVariance
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueCostThe portion of the project baseline total cost of the activity that is actually completed as of the project data date. Computed as earned value = BAC * performance % complete. The method for computing performance % complete depends on the earned-value technique selected for the activity's WBS. BAC is computed from the project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameEarnedValueCost
PMDB Table
PMDB Field Name
Data Typenumber
EarnedValueLaborUnitsThe portion of the project baseline labor units that is actually completed as of the project data date. Computed as labor units earned value = project baseline labor units * performance % complete. The method for computing performance % complete depends on the earned-value technique selected for the activity's WBS. The BL labor units is taken from the project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameEarnedValueLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameEstimateAtCompletionCost
PMDB Table
PMDB Field Name
Data Typenumber
EstimateAtCompletionLaborUnitsThe estimated labor units at completion of the activity. Calculated as actual labor units + estimate to complete labor units. estimate to complete labor units is calculated based off of the earned value setting on the WBS.
ODS TableActivity
API Business ObjectActivity
API Field NameEstimateAtCompletionLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteThe estimated cost to complete the activity. Computed as either the remaining total cost for the activity (remaining total cost), or as PF * (BAC - earned value), depending on the earned-value technique selected for the activity's WBS. BAC is computed from the project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameEstimateToComplete
PMDB Table
PMDB Field Name
Data Typenumber
EstimateToCompleteLaborUnitsThe estimated quantity to complete the activity. Computed as either the remaining total units for the activity (remaining total units), or as PF * (BL labor units - earned value), depending on the earned-value technique selected for the activity's WBS.
ODS TableActivity
API Business ObjectActivity
API Field NameEstimateToCompleteLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
ExpenseCost1VarianceThe difference between primary baseline expense cost and at completion expense cost. Calculated as primary baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).
ODS TableActivity
API Business ObjectActivity
API Field NameExpenseCost1Variance
PMDB Table
PMDB Field Name
Data Typenumber
ExpenseCostPercentCompleteThe percent complete of costs for all expenses associated with the activity. Computed as actual expense cost / at completion expense cost * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameExpenseCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
ExpenseCostVarianceThe difference between project baseline expense cost and at completion expense cost. Calculated as project baseline expense cost - at completion expense cost (at completion expense cost = actual expense cost + remaining expense cost).
ODS TableActivity
API Business ObjectActivity
API Field NameExpenseCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
FinishDateThe current finish date of the activity. Set to the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed.
ODS TableActivity
API Business ObjectActivity
API Field NameFinishDate
PMDB Table
PMDB Field Name
Data Typedate
FinishDate1Variancethe duration between the finish date in the current project and the primary baseline finish date. Calculated as finish date - primary baseline finish date.
ODS TableActivity
API Business ObjectActivity
API Field NameFinishDate1Variance
PMDB Table
PMDB Field Name
Data Typenumber
FinishDateVariancethe duration between the finish date in the current project and the project baseline finish date. Calculated as finish date - project baseline finish date.
ODS TableActivity
API Business ObjectActivity
API Field NameFinishDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
IsCriticalThe flag that indicates whether the activity is critical. An activity is critical when its total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project.
ODS TableActivity
API Business ObjectActivity
API Field NameIsCritical
PMDB Table
PMDB Field Name
Data Typestring
LaborCost1VarianceThe difference between primary baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost
ODS TableActivity
API Business ObjectActivity
API Field NameLaborCost1Variance
PMDB Table
PMDB Field Name
Data Typenumber
LaborCostPercentCompleteThe percent complete of costs for all labor resources assigned to the activity. Computed as actual labor cost / at completion labor cost * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
LaborCostVarianceThe difference between project baseline labor cost and at completion labor cost. Calculated as BL labor cost - at completion labor cost
ODS TableActivity
API Business ObjectActivity
API Field NameLaborCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
LaborUnits1VarianceThe difference between primary baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameLaborUnits1Variance
PMDB Table
PMDB Field Name
Data Typenumber
LaborUnitsPercentCompleteThe percent complete of units for all labor resources for the activity. Computed as actual labor units / at completion labor units * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameLaborUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
LaborUnitsVarianceThe difference between project baseline labor units and at completion labor units. Calculated as BL labor units - at completion labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameLaborUnitsVariance
PMDB Table
PMDB Field Name
Data Typenumber
MaterialCost1VarianceThe primary Baseline Planned Material Cost minus the At Completion Material Cost.
ODS TableActivity
API Business ObjectActivity
API Field NameMaterialCost1Variance
PMDB Table
PMDB Field Name
Data Typenumber
MaterialCostPercentCompleteThe percent complete of costs for all material resources assigned to the activity. Computed as actual nonlabor cost / at completion nonlabor cost * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameMaterialCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
MaterialCostVarianceThe project BaselinePlannedMaterialCost minus the AtCompletionMaterialCost.
ODS TableActivity
API Business ObjectActivity
API Field NameMaterialCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborCost1VarianceThe difference between the primary baseline nonlabor cost and at completion nonlabor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborCost1Variance
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborCostPercentCompleteThe percent complete of costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost / at completion nonlabor cost * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborCostVarianceThe difference between the project baseline labor cost and at completion labor cost. Calculated as BL nonlabor cost - at completion nonlabor cost.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborUnits1VarianceThe difference between the primary baseline nonlabor units and at completion nonlabor units. Calculated as BL nonlabor units - at completion nonlabor units.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborUnits1Variance
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborUnitsPercentCompleteThe percent complete of units for all nonlabor resources for the activity. Computed as actual nonlabor units / at completion nonlabor units * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
NonLaborUnitsVarianceThe difference between the project baseline labor units and at completion labor units. Calculated as BL nonlabor units - at completion nonlabor units.
ODS TableActivity
API Business ObjectActivity
API Field NameNonLaborUnitsVariance
PMDB Table
PMDB Field Name
Data Typenumber
PercentCompleteThe 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, which is one of Duration, Units, or Physical. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NamePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
PerformancePercentCompleteThe activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the activity % complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The performance % complete specifies what percentage of the activity's planned worth has been earned so far.
ODS TableActivity
API Business ObjectActivity
API Field NamePerformancePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
PhysicalPercentCompleteThe physical percent complete, which can either be user entered or calculated from the activity's weighted steps.
ODS TableActivity
API Business ObjectActivity
API Field NamePhysicalPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
PlannedExpenseCostThe planned costs for all project expenses associated with the activity. This field is named BudgetedExpenseCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedExpenseCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedLaborCostThe planned costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity planned labor units * project default price / time. This field is named BudgetedLaborCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedMaterialCostThe sum of all material resource costs.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedNonLaborCostThe planned costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity planned nonlabor units * project default price / time. This field is named BudgetedNonLaborCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedTotalCostThe 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. This field is named BudgetedTotalCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedTotalCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedTotalUnitsthe sum of Planned Labor Units and Planned Nonlabor Units. This field is named BudgetedTotalUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedTotalUnits
PMDB TableTASK
PMDB Field Name
Data Typenumber
PlannedValueCostThe portion of the project baseline total cost of the activity that is scheduled to be completed as of the project data date. Computed as BAC * schedule % complete. Also known as the work scheduled to be performed for the activity. The schedule % complete specifies how much of the activity's project baseline duration has been completed so far. BAC is computed from the project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedValueCost
PMDB Table
PMDB Field Name
Data Typenumber
PlannedValueLaborUnitsThe portion of the project baseline labor units that is scheduled to be completed as of the project data date. Computed as BL labor units * schedule % complete. The schedule % complete specifies how much of the activity's project baseline duration has been completed so far. BL labor units is taken from the project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NamePlannedValueLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
PrimaryResourceIdThe name of the resource.
ODS TableActivity
API Business ObjectActivity
API Field NamePrimaryResourceId
PMDB Tablersrc
PMDB Field Namersrc_short_name
Data Typestring
PrimaryResourceNameThe name of the resource.
ODS TableActivity
API Business ObjectActivity
API Field NamePrimaryResourceName
PMDB Tablersrc
PMDB Field Namersrc_name
Data Typestring
RemainingExpenseCostThe remaining costs for all project expenses associated with the activity.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingExpenseCost
PMDB Table
PMDB Field Name
Data Typenumber
RemainingFloatThe amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as late finish - remaining finish. If the remaining finish is the same as the early finish (in general, when the activity is not started), then the remaining float is the same as the total float.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingFloat
PMDB Table
PMDB Field Name
Data Typenumber
RemainingLaborCostThe remaining costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity remaining labor units * project default price / time.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
RemainingMaterialCostThe sum of all material resource remaining costs.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingMaterialCost
PMDB Table
PMDB Field Name
Data Typenumber
RemainingNonLaborCostThe remaining costs for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity remaining nonlabor units * project default price / time.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingNonLaborCost
PMDB Table
PMDB Field Name
Data Typenumber
RemainingTotalCostThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingTotalCost
PMDB Table
PMDB Field Name
Data Typenumber
RemainingTotalUnitsthe sum of Remaining Labor Units and Remaining Nonlabor Units.
ODS TableActivity
API Business ObjectActivity
API Field NameRemainingTotalUnits
PMDB TableTASK
PMDB Field Name
Data Typenumber
SchedulePercentCompleteThe activity schedule percent complete, which specifies how much of the activity's project baseline duration has been completed so far. Computed based on where the current data date falls relative to the activity's project baseline start and finish dates. If the data date is earlier than the BL start, the schedule % complete is 0. If the data date is later than the BL finish, the schedule % complete is 100. The schedule % complete indicates how much of the activity duration should be currently completed, relative to the selected project baseline.
ODS TableActivity
API Business ObjectActivity
API Field NameSchedulePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SchedulePerfIndexLaborUnitsThe ratio of the earned value of labor units and the planned value of labor units. Computed as SPI labor units = earned value labor units / planned value labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameSchedulePerformanceIndexLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SchedulePerformanceIndexThe ratio of the earned value of work performed and the work scheduled to be performed. Computed as SPI = earned value/ planned value. A value less than 1 indicates that less work was actually performed than was scheduled.
ODS TableActivity
API Business ObjectActivity
API Field NameSchedulePerformanceIndex
PMDB Table
PMDB Field Name
Data Typenumber
ScheduleVarianceThe difference between the earned value of work performed and the work scheduled to be performed. Computed as SV = earned value - planned value. A negative value indicates that less work was actually performed than was scheduled.
ODS TableActivity
API Business ObjectActivity
API Field NameScheduleVariance
PMDB Table
PMDB Field Name
Data Typenumber
ScheduleVarianceIndexThe ratio of the schedule variance and the work scheduled to be performed. Computed as SVI = SV / planned value.
ODS TableActivity
API Business ObjectActivity
API Field NameScheduleVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
ScheduleVarianceLaborUnitsThe difference between the earned value of work performed and the work scheduled to be performed. Computed as SV labor units = earned value labor units - planned value labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameScheduleVarianceLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
ScheduleVarIndexLaborUnitsThe ratio of the schedule variance and the work scheduled to be performed. Computed as SVI labor units = SV labor units / planned value labor units.
ODS TableActivity
API Business ObjectActivity
API Field NameScheduleVarianceIndexLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
StartDateThe start date of the activity. Set to the remaining start date until the activity is started, then set to the actual start date.
ODS TableActivity
API Business ObjectActivity
API Field NameStartDate
PMDB Table
PMDB Field Name
Data Typedate
StartDate1VarianceThe duration between the start date in the current project and the primary baseline start date. Calculated as start date - primary baseline start date.
ODS TableActivity
API Business ObjectActivity
API Field NameStartDate1Variance
PMDB Table
PMDB Field Name
Data Typenumber
StartDateVarianceThe duration between the start date in the current project and the project baseline start date. Calculated as start date - project baseline start date.
ODS TableActivity
API Business ObjectActivity
API Field NameStartDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
ToCompletePerformanceIndexThe TCPI, which is calculated as (budget at completion - earned value) / (estimate at completion - ACWP).
ODS TableActivity
API Business ObjectActivity
API Field NameToCompletePerformanceIndex
PMDB Table
PMDB Field Name
Data Typenumber
TotalCost1VarianceThe difference between the primary baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.
ODS TableActivity
API Business ObjectActivity
API Field NameTotalCost1Variance
PMDB Table
PMDB Field Name
Data Typenumber
TotalCostVarianceThe difference between the project baseline total cost and the at completion total cost. Calculated as BL total cost - at completion total cost.
ODS TableActivity
API Business ObjectActivity
API Field NameTotalCostVariance
PMDB Table
PMDB Field Name
Data Typenumber
UnitsPercentCompleteThe percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as actual units / at completion units * 100. Always in the range 0 to 100.
ODS TableActivity
API Business ObjectActivity
API Field NameUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
WBSCodeThe 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.
ODS TableActivity
API Business ObjectActivity
API Field NameWBSCode
PMDB Tableprojwbs
PMDB Field Namewbs_short_name
Data Typestring
WBSNameThe name of the WBS element.
ODS TableActivity
API Business ObjectActivity
API Field NameWBSName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
lastupdateuserLast Update User
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on Activity
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ActivityOwnerObjectIdActivity - OwnerObjectId maps to TASKUSER.user_id
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ActivityOwnerActivity - Owner maps to USERS.user_name
ODS TableACTIVITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ACTIVITYCODETop
ObjectIdThe unique ID generated by the system.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameObjectId
PMDB Tableactvcode
PMDB Field Nameactv_code_id
Data Typeinteger
CodeTypeObjectIdThe unique ID of the parent activity code type.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameCodeTypeObjectId
PMDB Tableactvcode
PMDB Field Nameactv_code_type_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameSequenceNumber
PMDB Tableactvcode
PMDB Field Nameseq_num
Data Typeinteger
CodeValueThe value of the activity code.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameCodeValue
PMDB Tableactvcode
PMDB Field Nameshort_name
Data Typestring
ParentObjectIdThe unique ID of the parent activity code of this activity code in the hierarchy.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameParentObjectId
PMDB Tableactvcode
PMDB Field Nameparent_actv_code_id
Data Typeinteger
DescriptionThe description of the activity code.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameDescription
PMDB Tableactvcode
PMDB Field Nameactv_code_name
Data Typestring
CodeTypeNameThe name of the parent code type for this code.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameCodeTypeName
PMDB Tableactvtype
PMDB Field Nameactv_code_type
Data Typestring
issecurecodeActivityCodeType - IsSecureCode maps to ACTVTYPE.super_flag
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
projectobjectidActivityCodeType - ProjectObjectId maps to ACTVTYPE.proj_id
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
CodeTypeScopethe scope of the parent activity code type: Global, EPS, or Project. An activity code with Global scope can be assigned to any activity. An activity code with EPS scope can be assigned only to an activity within a project under that particular EPS. Similarly, an activity code with Project scope can be assigned only to an activity within that particular project.
ODS TableActivityCode
API Business ObjectActivityCode
API Field NameCodeTypeScope
PMDB Tableactvtype
PMDB Field Nameactv_code_type_scope
Data Typestring
lastupdateuserLast Update User
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityCode
ODS TableACTIVITYCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYCODEASSIGNMENTTop
ActivityObjectIdThe unique ID of the activity to which the activity code is assigned.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityObjectId
PMDB Tabletaskactv
PMDB Field Nametask_id
Data Typeinteger
ActivityCodeTypeObjectIdThe unique ID of the parent activity code type.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeTypeObjectId
PMDB Tabletaskactv
PMDB Field Nameactv_code_type_id
Data Typeinteger
ActivityCodeObjectIdThe unique ID of the associated activity code.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeObjectId
PMDB Tabletaskactv
PMDB Field Nameactv_code_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameProjectObjectId
PMDB Tabletaskactv
PMDB Field Nameproj_id
Data Typeinteger
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
ActivityCodeDescriptionThe description of the associated activity code.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeDescription
PMDB Tableactvcode
PMDB Field Nameactv_code_name
Data Typestring
ActivityCodeTypeNameThe name of the parent activity code type.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeTypeName
PMDB Tableactvtype
PMDB Field Nameactv_code_type
Data Typestring
ActivityCodeTypeScopeThe scope of the associated activity code type: Global, EPS, or Project. An activity code with Global scope can be assigned to any activity. An activity code with EPS scope can be assigned only to an activity within a project under that particular EPS. Similarly, an activity code with Project scope can be assigned only to an activity within that particular project.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeTypeScope
PMDB Tableactvtype
PMDB Field Nameactv_code_type_scope
Data Typestring
ActivityCodeValueThe value of the associated activity code.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityCodeValue
PMDB Tableactvcode
PMDB Field Nameshort_name
Data Typestring
ActivityIdThe short ID that uniquely identifies the activity to which the activity code is assigned.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityId
PMDB Tabletask
PMDB Field Nametask_code
Data Typestring
ActivityNameThe name of the activity to which the activity code is assigned.
ODS TableActivityCodeAssignment
API Business ObjectActivityCodeAssignment
API Field NameActivityName
PMDB Tabletask
PMDB Field Nametask_name
Data Typestring
issecurecodeActivityCodeAssignment - IsSecureCode maps to TASKACTV.super_flag
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdateuserLast Update User
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityCodeAssignment
ODS TableACTIVITYCODEASSIGNMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYCODEHIERARCHYTop
CodeTypeObjectId
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
CodeTypeName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
CodeTypeSequenceNumber
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
CodeTypeIsSecure
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentCodeValueObjectId
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentCodeValueName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentCodeValueShortName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentCodeValueSequenceNumber
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildCodeValueObjectId
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildCodeValueName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildCodeValueShortName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildCodeValueSequenceNumber
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentLevelsBelowRoot
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildLevelsBelowRoot
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
LevelsBetween
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildHasChildren
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
FullPathName
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
CodeTypeScope
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
CodeTypeProjectId
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
SKey
ODS TableACTIVITYCODEHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYCODETYPETop
ObjectIdThe unique ID generated by the system.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameObjectId
PMDB Tableactvtype
PMDB Field Nameactv_code_type_id
Data Typeinteger
LengthThe maximum number of characters allowed for values of this activity code.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameLength
PMDB Tableactvtype
PMDB Field Nameactv_short_len
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameSequenceNumber
PMDB Tableactvtype
PMDB Field Nameseq_num
Data Typeinteger
NameThe name of the activity code type.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameName
PMDB Tableactvtype
PMDB Field Nameactv_code_type
Data Typestring
Scopethe scope of the code type: Global, EPS, or Project. An activity code with Global scope can be assigned to any activity. An activity code with EPS scope can be assigned only to an activity within a project under that particular EPS. Similarly, an activity code with Project scope can be assigned only to an activity within that particular project.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameScope
PMDB Tableactvtype
PMDB Field Nameactv_code_type_scope
Data Typestring
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameProjectObjectId
PMDB Tableactvtype
PMDB Field Nameproj_id
Data Typeinteger
EPSObjectIdThe unique ID of the associated EPS.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameEPSObjectId
PMDB Tableactvtype
PMDB Field Nameproj_id
Data Typeinteger
IsSecureCodethe flag indicating whether this is a secure Activity Code Type.
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameIsSecureCode
PMDB Tableactvtype
PMDB Field Namesuper_flag
Data Typestring
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityCodeType
API Business ObjectActivityCodeType
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
lastupdateuserLast Update User
ODS TableACTIVITYCODETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYCODETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYCODETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYCODETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityCodeType
ODS TableACTIVITYCODETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYCODETYPESECURITYTop
RDBMSUSERID
ODS TableACTIVITYCODETYPESECURITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
PROJECTOBJECTID
ODS TableACTIVITYCODETYPESECURITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ACTIVITYEXPENSETop
ObjectIdThe unique ID generated by the system.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameObjectId
PMDB Tableprojcost
PMDB Field Namecost_item_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameProjectObjectId
PMDB Tableprojcost
PMDB Field Nameproj_id
Data Typeinteger
ActivityObjectIdThe unique ID of the activity to which the project expense is linked. Every project expense is associated with one activity in the project.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameActivityObjectId
PMDB Tableprojcost
PMDB Field Nametask_id
Data Typeinteger
AutoComputeActualsThe flag that identifies whether the actual and remaining costs for the expense are computed automatically using the planned cost and the activity's schedule percent complete. If this option is selected, the actual/remaining costs are automatically updated when project actuals are applied. This assumes the expenses are made according to plan.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameAutoComputeActuals
PMDB Tableprojcost
PMDB Field Nameauto_compute_act_flag
Data Typestring
AccrualTypeThe accrual type for the project expense. If the accrual type is 'Start of Activity', the entire expense costs are accrued at the start date of the activity. If the accrual type is 'End of Activity', the entire expense costs are accrued at the finish date of the activity. If the accrual type is 'Uniform over Activity', the expense costs are accrued uniformly over the duration of the activity.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameAccrualType
PMDB Tableprojcost
PMDB Field Namecost_load_type
Data Typestring
CostAccountObjectIdThe unique ID of the cost account associated with the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameCostAccountObjectId
PMDB Tableprojcost
PMDB Field Nameacct_id
Data Typeinteger
ExpenseCategoryObjectIdThe unique ID of the expense category for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameExpenseCategoryObjectId
PMDB Tableprojcost
PMDB Field Namecost_type_id
Data Typeinteger
PlannedCostThe planned cost for the project expense. This field is named BudgetedCost in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NamePlannedCost
PMDB Tableprojcost
PMDB Field Nametarget_cost
Data Typedouble
ActualCostThe actual cost for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameActualCost
PMDB Tableprojcost
PMDB Field Nameact_cost
Data Typedouble
RemainingCostThe remaining cost for the project expense. Before actual expenses are made, remaining cost should be the same as planned cost. While the activity is in progress, the remaining cost should be updated to reflect the estimated remaining cost required for the expense. After the expense is completed, the remaining cost should be zero.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameRemainingCost
PMDB Tableprojcost
PMDB Field Nameremain_cost
Data Typedouble
UnitOfMeasureThe unit of measure for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameUnitOfMeasure
PMDB Tableprojcost
PMDB Field Nameqty_name
Data Typestring
PlannedUnitsThe planned number of units for the project expense. This number is multiplied by the price per unit to compute the planned cost. This field is named BudgetedUnits in Primavera's Engineering & Construction and Maintenance & Turnaround solutions.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NamePlannedUnits
PMDB Tableprojcost
PMDB Field Nametarget_qty
Data Typedouble
PricePerUnitThe planned price per unit for the project expense. This number is multiplied by the planned number of units to compute the planned cost.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NamePricePerUnit
PMDB Tableprojcost
PMDB Field Namecost_per_qty
Data Typedouble
DocumentNumberThe document number for the expense. Use this for the purchase order number, invoice number, requisition number, or similar, as needed.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameDocumentNumber
PMDB Tableprojcost
PMDB Field Namepo_number
Data Typestring
VendorThe name of the vendor providing the product or service associated with the expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameVendor
PMDB Tableprojcost
PMDB Field Namevendor_name
Data Typestring
ExpenseItemThe name of the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameExpenseItem
PMDB Tableprojcost
PMDB Field Namecost_name
Data Typestring
ExpenseDescriptionThe description of the expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameExpenseDescription
PMDB Tableprojcost
PMDB Field Namecost_descr
Data Typeclob
ActivityIdThe short ID that uniquely identifies the activity within the project.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameActivityId
PMDB Tabletask
PMDB Field Nametask_code
Data Typestring
ActivityNameThe name of the activity. The activity name does not have to be unique.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameActivityName
PMDB Tabletask
PMDB Field Nametask_name
Data Typestring
ActualUnitsThe actual units for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameActualUnits
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionCostThe sum of the actual plus remaining costs for the project expense. Computed as actual cost + remaining cost.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameAtCompletionCost
PMDB Table
PMDB Field Name
Data Typenumber
AtCompletionUnitsThe at completion units for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameAtCompletionUnits
PMDB Table
PMDB Field Name
Data Typenumber
CostAccountIdThe id of associated cost account.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameCostAccountId
PMDB Tableaccount
PMDB Field Nameacct_short_name
Data Typestring
CostAccountNameThe name of the associated cost account.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameCostAccountName
PMDB Tableaccount
PMDB Field Nameacct_name
Data Typestring
ExpenseCategoryNameThe name of the expense category.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameExpenseCategoryName
PMDB Tablecosttype
PMDB Field Namecost_type
Data Typestring
ExpensePercentCompleteThe percent complete of the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameExpensePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
OverBudgetThe indicator that reflects whether the project expense is over budget. An expense is over budget when the actual cost + remaining cost exceeds the planned cost.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameOverBudget
PMDB Table
PMDB Field Name
Data Typestring
ProjectIdThe short code that uniquely identifies the project.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameProjectId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
RemainingUnitsThe remaining units for the project expense.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameRemainingUnits
PMDB Table
PMDB Field Name
Data Typenumber
WBSObjectIdThe unique ID of the WBS for the activity.
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameWBSObjectId
PMDB Tabletask
PMDB Field Namewbs_id
Data Typeinteger
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityExpense
API Business ObjectActivityExpense
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
lastupdateuserLast Update User
ODS TableACTIVITYEXPENSE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYEXPENSE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYEXPENSE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYEXPENSE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityExpense
ODS TableACTIVITYEXPENSE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYNOTETop
ObjectIdThe unique ID generated by the system.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameObjectId
PMDB Tabletaskmemo
PMDB Field Namememo_id
Data Typeinteger
ActivityObjectIdThe unique ID of the activity to which the activity note is assigned.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameActivityObjectId
PMDB Tabletaskmemo
PMDB Field Nametask_id
Data Typeinteger
NotebookTopicObjectIdThe unique ID of the associated notebook topic.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameNotebookTopicObjectId
PMDB Tabletaskmemo
PMDB Field Namememo_type_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameProjectObjectId
PMDB Tabletaskmemo
PMDB Field Nameproj_id
Data Typeinteger
NoteThe information that is associated with the notebook topic.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameNote
PMDB Tabletaskmemo
PMDB Field Nametask_memo
Data Typeclob
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
ActivityIdThe short ID that uniquely identifies the activity to which the activity note is assigned.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameActivityId
PMDB Tabletask
PMDB Field Nametask_code
Data Typestring
ActivityNameThe name of the activity to which the activity note is assigned.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameActivityName
PMDB Tabletask
PMDB Field Nametask_name
Data Typestring
NotebookTopicNameThe name of the associated notebook topic.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameNotebookTopicName
PMDB Tablememotype
PMDB Field Namememo_type
Data Typestring
ProjectIdThe short code that uniquely identifies the associated project.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameProjectId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
RawTextNoteThe information that is associated with the notebook topic, without any HTML.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameRawTextNote
PMDB Table
PMDB Field Name
Data Typeclob
WBSObjectIdThe unique ID of the WBS for the activity.
ODS TableActivityNote
API Business ObjectActivityNote
API Field NameWBSObjectId
PMDB Tabletask
PMDB Field Namewbs_id
Data Typeinteger
lastupdateuserLast Update User
ODS TableACTIVITYNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityNote
ODS TableACTIVITYNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYPERIODACTUALTop
FinancialPeriodObjectIdThe unique ID of the associated financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameFinancialPeriodObjectId
PMDB Tabletaskfin
PMDB Field Namefin_dates_id
Data Typeinteger
ActivityObjectIdThe unique ID of the associated activity.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActivityObjectId
PMDB Tabletaskfin
PMDB Field Nametask_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameProjectObjectId
PMDB Tabletaskfin
PMDB Field Nameproj_id
Data Typeinteger
ActualLaborUnitsThe actual labor units on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualLaborUnits
PMDB Tabletaskfin
PMDB Field Nameact_work_qty
Data Typedouble
ActualLaborCostThe actual labor cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualLaborCost
PMDB Tabletaskfin
PMDB Field Nameact_work_cost
Data Typedouble
ActualNonLaborUnitsThe actual nonlabor units on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualNonLaborUnits
PMDB Tabletaskfin
PMDB Field Nameact_equip_qty
Data Typedouble
ActualNonLaborCostThe actual nonlabor cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualNonLaborCost
PMDB Tabletaskfin
PMDB Field Nameact_equip_cost
Data Typedouble
ActualMaterialCostThe actual material cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualMaterialCost
PMDB Tabletaskfin
PMDB Field Nameact_mat_cost
Data Typedouble
ActualExpenseCostThe actual expense cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameActualExpenseCost
PMDB Tabletaskfin
PMDB Field Nameact_expense_cost
Data Typedouble
EarnedValueCostThe earned value cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameEarnedValueCost
PMDB Tabletaskfin
PMDB Field Namebcwp
Data Typedouble
PlannedValueLaborUnitsThe planned value labor units on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NamePlannedValueLaborUnits
PMDB Tabletaskfin
PMDB Field Namesched_work_qty
Data Typedouble
PlannedValueCostThe planned value cost on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NamePlannedValueCost
PMDB Tabletaskfin
PMDB Field Namebcws
Data Typedouble
EarnedValueLaborUnitsThe earned value labor units on this activity during a financial period.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameEarnedValueLaborUnits
PMDB Tabletaskfin
PMDB Field Nameperfm_work_qty
Data Typedouble
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
WBSObjectIdThe unique ID of the WBS for the activity.
ODS TableActivityPeriodActual
API Business ObjectActivityPeriodActual
API Field NameWBSObjectId
PMDB Tabletask
PMDB Field Namewbs_id
Data Typeinteger
lastupdateuserLast Update User
ODS TableACTIVITYPERIODACTUAL
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYPERIODACTUAL
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYPERIODACTUAL
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYPERIODACTUAL
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityPeriodActual
ODS TableACTIVITYPERIODACTUAL
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ACTIVITYSTEPTop
ObjectIdThe unique ID generated by the system.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameObjectId
PMDB Tabletaskproc
PMDB Field Nameproc_id
Data Typeinteger
ActivityObjectIdThe unique ID of the activity to which the steps are assigned.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameActivityObjectId
PMDB Tabletaskproc
PMDB Field Nametask_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameSequenceNumber
PMDB Tabletaskproc
PMDB Field Nameseq_num
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameProjectObjectId
PMDB Tabletaskproc
PMDB Field Nameproj_id
Data Typeinteger
IsCompletedThe flag that indicates whether the step has been completed.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameIsCompleted
PMDB Tabletaskproc
PMDB Field Namecomplete_flag
Data Typestring
NameThe name of the activity step.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameName
PMDB Tabletaskproc
PMDB Field Nameproc_name
Data Typestring
WeightThe weight that is assigned to the step. This is a user defined field that is used to calculate the physical percent complete when the project option is set.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameWeight
PMDB Tabletaskproc
PMDB Field Nameproc_wt
Data Typedouble
PercentCompleteThe percent complete for the step.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NamePercentComplete
PMDB Tabletaskproc
PMDB Field Namecomplete_pct
Data Typedouble
DescriptionThe description of the activity step.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameDescription
PMDB Tabletaskproc
PMDB Field Nameproc_descr
Data Typeclob
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
ActivityIdThe short ID that uniquely identifies the activity within the project.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameActivityId
PMDB Tabletask
PMDB Field Nametask_code
Data Typestring
ActivityNameThe name of the activity. The activity name does not have to be unique.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameActivityName
PMDB Tabletask
PMDB Field Nametask_name
Data Typestring
ProjectIdThe short code that uniquely identifies the project.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameProjectId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
WBSObjectIdThe unique ID of the WBS for the activity.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameWBSObjectId
PMDB Tabletask
PMDB Field Namewbs_id
Data Typeinteger
WeightPercentThe non-editable field that displays the percentage amount that corresponds to the step. It is calculated by taking the weight of the step and dividing it by the total of all weights for the activity.
ODS TableActivityStep
API Business ObjectActivityStep
API Field NameWeightPercent
PMDB Table
PMDB Field Name
Data Typenumber
lastupdateuserLast Update User
ODS TableACTIVITYSTEP
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableACTIVITYSTEP
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableACTIVITYSTEP
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableACTIVITYSTEP
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on ActivityStep
ODS TableACTIVITYSTEP
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
BASELINEPROJECTTop
ObjectIdThe unique ID generated by the system.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameObjectId
PMDB Tableprojwbs
PMDB Field Nameproj_id
Data Typeinteger
IdThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
FiscalYearStartMonthThe month that marks the beginning of the fiscal year for the project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameFiscalYearStartMonth
PMDB Tableproject
PMDB Field Namefy_start_month_num
Data Typeinteger
ResourcesCanEditAsgnmtPctCmpThe flag that indicates whether the project's resource can use the timesheet application to update remaining units or percent complete for their activities.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameResourcesCanEditAssignmentPercentComplete
PMDB Tableproject
PMDB Field Namechng_eff_cmp_pct_flag
Data Typestring
ResourcesCanSelfAssignToActsThe flag that indicates whether timesheet application users are allowed to assign themselves to activities in this project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameResourcesCanAssignThemselvesToActivities
PMDB Tableproject
PMDB Field Namersrc_self_add_flag
Data Typestring
PrimaryResCanMarkActsAsCmpThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NamePrimaryResourcesCanMarkActivitiesAsCompleted
PMDB Tableproject
PMDB Field Nameallow_complete_flag
Data Typestring
ResourceCanAssignToSameActThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameResourceCanBeAssignedToSameActivityMoreThanOnce
PMDB Tableproject
PMDB Field Namersrc_multi_assign_flag
Data Typestring
CheckOutStatusThe flag that indicates that the baseline project is currently checked out to an external file or database and is being managed remotely.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCheckOutStatus
PMDB Tableproject
PMDB Field Namecheckout_flag
Data Typestring
ActivityPctCmpBasedOnStepsThe flag that indicates whether activity physical percent complete is automatically computed from the activity steps completed.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityPercentCompleteBasedOnActivitySteps
PMDB Tableproject
PMDB Field Namestep_complete_flag
Data Typestring
CostQuantityRecalculateFlagThe flag that indicates whether quantities should be updated when costs are updated, if costs and quantities are linked.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCostQuantityRecalculateFlag
PMDB Tableproject
PMDB Field Namecost_qty_recalc_flag
Data Typestring
EnableSummarizationThe flag which, when true, causes the Summarizer service to automatically summarize the project. If this is false, the project will be skipped during the summary run.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameEnableSummarization
PMDB Tableproject
PMDB Field Namebatch_sum_flag
Data Typestring
WBSCodeSeparatorThe character used to separate the concatenated code fields for the project's WBS tree.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameWBSCodeSeparator
PMDB Tableproject
PMDB Field Namename_sep_char
Data Typestring
ActivityDefaultPctCmpTypeThe percent complete type assigned to new activities by default. Valid values are 'Physical', 'Duration', and 'Units'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultPercentCompleteType
PMDB Tableproject
PMDB Field Namedef_complete_pct_type
Data Typestring
ActivityDefCostAcctObjectIdThe unique ID of the cost account assigned to new activities and project expenses by default.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultCostAccountObjectId
PMDB Tableproject
PMDB Field Nameacct_id
Data Typeinteger
ActivityDefCalendarObjectIdThe unique ID of the calendar assigned to new activities by default. Can be null for EPS and baselines.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultCalendarObjectId
PMDB Tableproject
PMDB Field Nameclndr_id
Data Typeinteger
ActivityIdSuffixThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityIdSuffix
PMDB Tableproject
PMDB Field Nametask_code_base
Data Typeinteger
ActivityIdIncrementThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityIdIncrement
PMDB Tableproject
PMDB Field Nametask_code_step
Data Typeinteger
LevelingPriorityThe priority for scheduling.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLevelingPriority
PMDB Tableproject
PMDB Field Namepriority_num
Data Typeinteger
StrategicPriorityThe baseline project's priority. The range is from 1 to 10,000.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameStrategicPriority
PMDB Tableproject
PMDB Field Namestrgy_priority_num
Data Typeinteger
CriticalActivityFloatLimitThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCriticalActivityFloatLimit
PMDB Tableproject
PMDB Field Namecritical_drtn_hr_cnt
Data Typedouble
ActivityDefaultPricePerUnitThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultPricePerUnit
PMDB Tableproject
PMDB Field Namedef_cost_per_qty
Data Typedouble
PlannedStartDateThe planned start date of the project. Used by the project scheduler.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NamePlannedStartDate
PMDB Tableproject
PMDB Field Nameplan_start_date
Data Typedate
MustFinishByDateThe date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameMustFinishByDate
PMDB Tableproject
PMDB Field Nameplan_end_date
Data Typedate
ScheduledFinishDateThe early finish date of the latest activity in the project, as computed by the project scheduler.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameScheduledFinishDate
PMDB Tableproject
PMDB Field Namescd_end_date
Data Typedate
DateAddedThe date on which the project was added to the Project Management database.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameDateAdded
PMDB Tableproject
PMDB Field Nameadd_date
Data Typedate
summarizeddatadateBaselineProject - SummarizedDataDate maps to PROJECT.sum_data_date
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
LastSummarizedDateThe date the project was last summarized.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLastSummarizedDate
PMDB Tableproject
PMDB Field Namelast_tasksum_date
Data Typedate
ProjectForecastStartDateThe 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 while manually leveling the resource profile in a resource analysis layout.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameProjectForecastStartDate
PMDB Tableproject
PMDB Field Namefcst_start_date
Data Typedate
ActivityDefaultDurationTypeThe 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'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultDurationType
PMDB Tableproject
PMDB Field Namedef_duration_type
Data Typestring
ActivityIdPrefixThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityIdPrefix
PMDB Tableproject
PMDB Field Nametask_code_prefix
Data Typestring
DefaultPriceTimeUnitsThe time units associated with the project's default price per time. Valid values are 'Hour', 'Day', 'Week', 'Month', and 'Year'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameDefaultPriceTimeUnits
PMDB Tableproject
PMDB Field Namedef_qty_type
Data Typestring
AddedByThe name of the user who added the project to the database.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAddedBy
PMDB Tableproject
PMDB Field Nameadd_by_name
Data Typestring
WebSiteRootDirectoryThe root directory for storing project Web site files before they are published to the Web server.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameWebSiteRootDirectory
PMDB Tableproject
PMDB Field Nameweb_local_root_path
Data Typestring
WebSiteURLThe project Web site URL, which is the Web address of the project's website.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameWebSiteURL
PMDB Tableproject
PMDB Field Nameproj_url
Data Typestring
AssignmentDefaultRateTypeThe default rate type when adding resource assignments to a project. Valid values are 'Price / Unit', 'Price / Unit2', 'Price / Unit3', 'Price / Unit4', and 'Price / Unit5'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAssignmentDefaultRateType
PMDB Tableproject
PMDB Field Namedef_rate_type
Data Typestring
LinkActualToActualThisPeriodThe flag that determines whether actual units and costs are linked to actual-this-period units and costs. Default = 'Y'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLinkActualToActualThisPeriod
PMDB Tableproject
PMDB Field Nameact_this_per_link_flag
Data Typestring
ActivityDefaultActivityTypeThe 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'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityDefaultActivityType
PMDB Tableproject
PMDB Field Namedef_task_type
Data Typestring
LinkPercentCompleteWithActualThe flag that determines whether actual units and cost should be recalculated when percent complete changes. Default = 'N'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLinkPercentCompleteWithActual
PMDB Tableproject
PMDB Field Nameact_pct_link_flag
Data Typestring
AddActualToRemainingThe flag that indicates whether to add actual to remaining or to subtract actual from at complete when actual units and costs are updated. Default = 'Y'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAddActualToRemaining
PMDB Tableproject
PMDB Field Nameadd_act_remain_flag
Data Typestring
CriticalActivityPathTypeThe critical path type, which indicates how critical path activities are identified for the project, based on either 'Critical Float' or 'Longest Path'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCriticalActivityPathType
PMDB Tableproject
PMDB Field Namecritical_path_type
Data Typestring
ActivityIdBasedOnSelActivityThe 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 = 'N'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameActivityIdBasedOnSelectedActivity
PMDB Tableproject
PMDB Field Nametask_code_prefix_flag
Data Typestring
AssignmentDefaultDrivingFlagThe default flag assigned to new assignments, to indicate whether assignments will drive activity dates.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAssignmentDefaultDrivingFlag
PMDB Tableproject
PMDB Field Namedef_rollup_dates_flag
Data Typestring
LinkPlannedAndAtCompletionFlagThe flag that indicates whether the At Completion Cost/Units should be linked to Planned Cost/Units for not-started activities. Default = 'Y'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLinkPlannedAndAtCompletionFlag
PMDB Tableproject
PMDB Field Namerem_target_link_flag
Data Typestring
ResetPlannedToRemainingFlagThe 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 = 'Y'
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameResetPlannedToRemainingFlag
PMDB Tableproject
PMDB Field Namereset_planned_flag
Data Typestring
allownegativeactualunitsflagBaselineProject - AllowNegativeActualUnitsFlag maps to PROJECT.allow_neg_act_flag
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
OwnerResourceObjectIdThe unique ID of the Owner Resource of this baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameOwnerResourceObjectId
PMDB Tableproject
PMDB Field Namersrc_id
Data Typeinteger
CheckOutDateThe date on which the baseline project was checked out of the Project Management database.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCheckOutDate
PMDB Tableproject
PMDB Field Namecheckout_date
Data Typedate
CheckOutUserObjectIdThe unique ID of the User that checked out this baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCheckOutUserObjectId
PMDB Tableproject
PMDB Field Namecheckout_user_id
Data Typeinteger
LastFinancialPeriodObjectIdThe unique ID of the last closed financial period for the baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLastFinancialPeriodObjectId
PMDB Tableproject
PMDB Field Namelast_fin_dates_id
Data Typeinteger
AnnualDiscountRateThe user-defined number field that identifies the discount rate for the project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAnnualDiscountRate
PMDB Tableprojwbs
PMDB Field Nameann_dscnt_rate_pct
Data Typenumber
AnticipatedFinishDateThe anticipated finish date of WBS, project and EPS elements. 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAnticipatedFinishDate
PMDB Tableprojwbs
PMDB Field Nameanticip_end_date
Data Typedate
AnticipatedStartDateThe anticipated start date of WBS, project and EPS elements. 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameAnticipatedStartDate
PMDB Tableprojwbs
PMDB Field Nameanticip_start_date
Data Typedate
BaselineTypeNameThe name of the baseline type for this project baseline. Baseline types are used to categorize project baselines.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameBaselineTypeName
PMDB Table
PMDB Field Name
Data Typestring
BaselineTypeObjectIdThe unique ID of the baseline type.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameBaselineTypeObjectId
PMDB Tableproject
PMDB Field Namebase_type_id
Data Typeinteger
CurrentBudgetThe sum of the original budget plus the approved and pending budgets from the budget change log.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
CurrentVarianceThe current budget minus the total spending plan.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
DataDateThe 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.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameDataDate
PMDB Table
PMDB Field Name
Data Typedate
DiscountApplicationPeriodthe timescale for entering ROI spending and benefit plan. Valid values are 'Month', 'Quarter', or 'Year'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameDiscountApplicationPeriod
PMDB Tableprojwbs
PMDB Field Namedscnt_period_type
Data Typestring
DistributedCurrentBudgetThe sum of the current budget values from one level lower.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameDistributedCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
EstimatedWeightThe estimation weight for the WBS element, used for top-down estimation. Top-down estimation weights are used to calculate the proportion of units that each WBS element or activity receives in relation to its siblings in the WBS hierarchy. top-down estimation distributes estimated units in a top-down manner to activities using the WBS hierarchy.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameEstimatedWeight
PMDB Tableprojwbs
PMDB Field Nameest_wt
Data Typenumber
FinishDateThe finish date of the baseline project. This field depends on summary data that was created when the original project was last summarized before this baseline was created.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameFinishDate
PMDB Table
PMDB Field Name
Data Typedate
ForecastFinishDateThe alternate end date to be optionally used by the scheduler).
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameForecastFinishDate
PMDB Table
PMDB Field Name
Data Typedate
ForecastStartDateThe alternate start date to be optionally used by the scheduler.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameForecastStartDate
PMDB Table
PMDB Field Name
Data Typedate
IndependentETCLaborUnitsThe user-entered ETC total labor.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameIndependentETCLaborUnits
PMDB Tableprojwbs
PMDB Field Nameindep_remain_work_qty
Data Typenumber
IndependentETCTotalCostThe user-entered ETC total cost.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameIndependentETCTotalCost
PMDB Tableprojwbs
PMDB Field Nameindep_remain_total_cost
Data Typenumber
LastBaselineUpdateDateThe date this project baseline was last changed by Baseline Update in Project Management.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameLastBaselineUpdateDate
PMDB Tableproject
PMDB Field Namelast_baseline_update_date
Data Typedate
NameThe name of the baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
OBSNameThe name of the person/role in the organization, sometimes referred to as the "responsible manager".
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameOBSName
PMDB Tableobs
PMDB Field Nameobs_name
Data Typestring
OBSObjectIdThe unique ID of the project manager from the project's OBS tree who is responsible for the WBS.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameOBSObjectId
PMDB Tableprojwbs
PMDB Field Nameobs_id
Data Typeinteger
OriginalBudgetThe original budget for the baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameOriginalBudget
PMDB Tableprojwbs
PMDB Field Nameorig_cost
Data Typenumber
OriginalProjectObjectIdThe unique ID of the project from which the project baseline was created, if the current project is a project baseline.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameOriginalProjectObjectId
PMDB Tableproject
PMDB Field Nameorig_proj_id
Data Typeinteger
ParentEPSObjectIdThe unique ID of the parent EPS of this baseline project.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameParentEPSObjectId
PMDB Tableprojwbs
PMDB Field Nameparent_wbs_id
Data Typeinteger
ProposedBudgetThe sum of the original budget plus the approved and pending budgets from the budget change log.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameProposedBudget
PMDB Table
PMDB Field Name
Data Typenumber
RiskLevelThe risk level assigned to the project: 'Very High', 'High', 'Medium', 'Low', and 'Very Low'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameRiskLevel
PMDB Table
PMDB Field Name
Data Typestring
StartDateThe start date of the baseline project. This field depends on summary data that was created when the original project was last summarized before this baseline was created.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameStartDate
PMDB Table
PMDB Field Name
Data Typedate
StatusThe project status: 'Planned', 'Active', 'Inactive', 'What-If', or 'Requested'.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameStatus
PMDB Tableprojwbs
PMDB Field Namestatus_code
Data Typestring
TotalBenefitPlanThe sum of the monthly benefit plan.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameTotalBenefitPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalBenefitPlanTallyThe sum of the monthly benefit plan tally.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameTotalBenefitPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanThe sum of the monthly spending plan.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameTotalSpendingPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanTallyThe sum of the monthly spending plan tally.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameTotalSpendingPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
UnallocatedBudgetThe total current budget minus the distributed current budget.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameUnallocatedBudget
PMDB Table
PMDB Field Name
Data Typenumber
UndistributedCurrentVarianceThe total spending plan minus the total spending plan tally.
ODS TableBaselineProject
API Business ObjectBaselineProject
API Field NameUndistributedCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
lastupdateuserLast Update User
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on BaselineProject
ODS TableBASELINEPROJECT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
BASELINETYPETop
ObjectIdThe unique ID generated by the system.
ODS TableBaselineType
API Business ObjectBaselineType
API Field NameObjectId
PMDB Tablebasetype
PMDB Field Namebase_type_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableBaselineType
API Business ObjectBaselineType
API Field NameSequenceNumber
PMDB Tablebasetype
PMDB Field Namebase_type_seq_num
Data Typeinteger
NameThe name of this baseline type.
ODS TableBaselineType
API Business ObjectBaselineType
API Field NameName
PMDB Tablebasetype
PMDB Field Namebase_type
Data Typestring
lastupdateuserLast Update User
ODS TableBASELINETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableBASELINETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableBASELINETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableBASELINETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on BaselineType
ODS TableBASELINETYPE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
CALENDARTop
ObjectIdThe unique ID generated by the system.
ODS TableCalendar
API Business ObjectCalendar
API Field NameObjectId
PMDB Tablecalendar
PMDB Field Nameclndr_id
Data Typeinteger
IsDefaultThe flag that identifies the default global calendar (applies to global calendars only).
ODS TableCalendar
API Business ObjectCalendar
API Field NameIsDefault
PMDB Tablecalendar
PMDB Field Namedefault_flag
Data Typestring
NameThe name of the calendar.
ODS TableCalendar
API Business ObjectCalendar
API Field NameName
PMDB Tablecalendar
PMDB Field Nameclndr_name
Data Typestring
ProjectObjectIdThe unique ID of the associated project.
ODS TableCalendar
API Business ObjectCalendar
API Field NameProjectObjectId
PMDB Tablecalendar
PMDB Field Nameproj_id
Data Typeinteger
BaseCalendarObjectIdThe unique ID of the global calendar to which this calendar is linked. Any changes to the global calendar are automatically propagated to this calendar.
ODS TableCalendar
API Business ObjectCalendar
API Field NameBaseCalendarObjectId
PMDB Tablecalendar
PMDB Field Namebase_clndr_id
Data Typeinteger
lastchangedateCalendar - lastchangedate maps to PSTG_CALENDARFULL.lastchangedate
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
TypeThe calendar type - either 'Global', 'Resource', or 'Project'. 'Global' calendars can be assigned to projects and resources. 'Resource' calendars can be assigned only to resources. 'Project' calendars are specific to projects.
ODS TableCalendar
API Business ObjectCalendar
API Field NameType
PMDB Tablecalendar
PMDB Field Nameclndr_type
Data Typestring
daydateCalendar - daydate maps to PSTG_CALENDARFULL.daydate
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
WeekdayNumberCalendar - WeekdayNumber maps to PSTG_CALENDARFULL.WeekdayNumber
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
WorkDayFlag
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
TotalWorkHours
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
WorkHoursByHalfHour
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
WorkDayStartTimeCalendar - WorkDayStartTime maps to PSTG_CALENDARFULL.WorkDayStartTime
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
WorkDayFinishTimeCalendar - WorkDayFinishTime maps to PSTG_CALENDARFULL.WorkDayFinishTime
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableCalendar
API Business ObjectCalendar
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
SKeySKey generated key on Calendar
ODS TableCALENDAR
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeidentity
COSTACCOUNTTop
ObjectIdThe unique ID generated by the system.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameObjectId
PMDB Tableaccount
PMDB Field Nameacct_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameSequenceNumber
PMDB Tableaccount
PMDB Field Nameacct_seq_num
Data Typeinteger
IdThe short ID assigned to each cost account for identification. Each cost account is uniquely identified by concatenating its own ID together with its parents' IDs.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameId
PMDB Tableaccount
PMDB Field Nameacct_short_name
Data Typestring
NameThe name of the cost account.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameName
PMDB Tableaccount
PMDB Field Nameacct_name
Data Typestring
ParentObjectIdThe unique ID of the parent cost account of this cost account in the hierarchy.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameParentObjectId
PMDB Tableaccount
PMDB Field Nameparent_acct_id
Data Typeinteger
DescriptionThe description of the cost account.
ODS TableCostAccount
API Business ObjectCostAccount
API Field NameDescription
PMDB Tableaccount
PMDB Field Nameacct_descr
Data Typeclob
lastupdateuserLast Update User
ODS TableCOSTACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableCOSTACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableCOSTACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableCOSTACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on CostAccount
ODS TableCOSTACCOUNT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
COSTACCOUNTHIERARCHYTop
ParentObjectId
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentSequenceNumber
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentName
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentId
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildObjectId
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildSequenceNumber
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildName
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildId
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentLevelsBelowRoot
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildLevelsBelowRoot
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
LevelsBetween
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildHasChildren
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
FullPathName
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
SKey
ODS TableCOSTACCOUNTHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
COSTSECURITYTop
RDBMSUSERID
ODS TableCOSTSECURITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
PROJECTOBJECTID
ODS TableCOSTSECURITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
WHOLEPROJECTFLAG
ODS TableCOSTSECURITY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typecharacter
CURRENCYTop
ObjectIdThe unique ID generated by the system.
ODS TableCurrency
API Business ObjectCurrency
API Field NameObjectId
PMDB Tablecurrtype
PMDB Field Namecurr_id
Data Typeinteger
DecimalPlacesThe number of decimal places displayed.
ODS TableCurrency
API Business ObjectCurrency
API Field NameDecimalPlaces
PMDB Tablecurrtype
PMDB Field Namedecimal_digit_cnt
Data Typedouble
SymbolThe currency symbol displayed.
ODS TableCurrency
API Business ObjectCurrency
API Field NameSymbol
PMDB Tablecurrtype
PMDB Field Namecurr_symbol
Data Typestring
DecimalSymbolThe decimal symbol displayed.
ODS TableCurrency
API Business ObjectCurrency
API Field NameDecimalSymbol
PMDB Tablecurrtype
PMDB Field Namedecimal_symbol
Data Typestring
DigitGroupingSymbolThe symbol used to group the numbers.
ODS TableCurrency
API Business ObjectCurrency
API Field NameDigitGroupingSymbol
PMDB Tablecurrtype
PMDB Field Namedigit_group_symbol
Data Typestring
PositiveSymbolThe symbol used to display a positive currency.
ODS TableCurrency
API Business ObjectCurrency
API Field NamePositiveSymbol
PMDB Tablecurrtype
PMDB Field Namepos_curr_fmt_type
Data Typestring
NegativeSymbolThe symbol used to display a negative currency.
ODS TableCurrency
API Business ObjectCurrency
API Field NameNegativeSymbol
PMDB Tablecurrtype
PMDB Field Nameneg_curr_fmt_type
Data Typestring
NameThe name of the currency.
ODS TableCurrency
API Business ObjectCurrency
API Field NameName
PMDB Tablecurrtype
PMDB Field Namecurr_type
Data Typestring
IdThe unique currency abbreviation for each currency.
ODS TableCurrency
API Business ObjectCurrency
API Field NameId
PMDB Tablecurrtype
PMDB Field Namecurr_short_name
Data Typestring
ExchangeRateThe exchange rate against the base currency.
ODS TableCurrency
API Business ObjectCurrency
API Field NameExchangeRate
PMDB Tablecurrtype
PMDB Field Namebase_exch_rate
Data Typedouble
IsBaseCurrencyThe currency used to store cost in the Project Management database. The exchange rate for the base currency is always 1.0. The base currency ID, name, and symbol default to U.S. dollars and can be edited but never deleted.
ODS TableCurrency
API Business ObjectCurrency
API Field NameIsBaseCurrency
PMDB Table
PMDB Field Name
Data Typestring
lastupdateuserLast Update User
ODS TableCURRENCY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableCURRENCY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableCURRENCY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableCURRENCY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on Currency
ODS TableCURRENCY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
DOCUMENTTop
ObjectIdThe unique ID generated by the system.
ODS TableDocument
API Business ObjectDocument
API Field NameObjectId
PMDB Tabledocument
PMDB Field Namedoc_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableDocument
API Business ObjectDocument
API Field NameSequenceNumber
PMDB Tabledocument
PMDB Field Namedoc_seq_num
Data Typeinteger
DeliverableThe flag that indicates that the work product or document is a project deliverable.
ODS TableDocument
API Business ObjectDocument
API Field NameDeliverable
PMDB Tabledocument
PMDB Field Namedeliv_flag
Data Typestring
TitleThe title or name of a project work product or document.
ODS TableDocument
API Business ObjectDocument
API Field NameTitle
PMDB Tabledocument
PMDB Field Namedoc_name
Data Typestring
ParentObjectIdThe unique ID of the parent document of this document in the hierarchy.
ODS TableDocument
API Business ObjectDocument
API Field NameParentObjectId
PMDB Tabledocument
PMDB Field Nameparent_doc_id
Data Typeinteger
ProjectObjectIdThe unique ID of the associated project.
ODS TableDocument
API Business ObjectDocument
API Field NameProjectObjectId
PMDB Tabledocument
PMDB Field Nameproj_id
Data Typeinteger
DocumentStatusCodeObjectIdThe unique ID of the associated document status code.
ODS TableDocument
API Business ObjectDocument
API Field NameDocumentStatusCodeObjectId
PMDB Tabledocument
PMDB Field Namedoc_status_id
Data Typeinteger
DocumentCategoryObjectIdThe unique ID of the associated document category.
ODS TableDocument
API Business ObjectDocument
API Field NameDocumentCategoryObjectId
PMDB Tabledocument
PMDB Field Namedoc_catg_id
Data Typeinteger
RevisionDateThe date of the work product or document's last update.
ODS TableDocument
API Business ObjectDocument
API Field NameRevisionDate
PMDB Tabledocument
PMDB Field Namedoc_date
Data Typedate
VersionThe work product or document's version number.
ODS TableDocument
API Business ObjectDocument
API Field NameVersion
PMDB Tabledocument
PMDB Field Nameversion_name
Data Typestring
ReferenceNumberThe work product or document's reference or catalog number.
ODS TableDocument
API Business ObjectDocument
API Field NameReferenceNumber
PMDB Tabledocument
PMDB Field Namedoc_short_name
Data Typestring
AuthorThe person who created the work product or document.
ODS TableDocument
API Business ObjectDocument
API Field NameAuthor
PMDB Tabledocument
PMDB Field Nameauthor_name
Data Typestring
PrivateLocationThe work product or document's private file location.
ODS TableDocument
API Business ObjectDocument
API Field NamePrivateLocation
PMDB Tabledocument
PMDB Field Nameprivate_loc
Data Typestring
PublicLocationThe work product or document's publicly-accessible file location.
ODS TableDocument
API Business ObjectDocument
API Field NamePublicLocation
PMDB Tabledocument
PMDB Field Namepublic_loc
Data Typestring
ResourceObjectIdThe unique ID of the associated resource.
ODS TableDocument
API Business ObjectDocument
API Field NameResourceObjectId
PMDB Tabledocument
PMDB Field Namersrc_id
Data Typeinteger
DocumentTypeThe type of document: 'Non-Collaboration' or 'Collaboration'.
ODS TableDocument
API Business ObjectDocument
API Field NameDocumentType
PMDB Tabledocument
PMDB Field Namedoc_mgmt_type
Data Typestring
DocumentCategoryNameThe name of the associated document category.
ODS TableDocument
API Business ObjectDocument
API Field NameDocumentCategoryName
PMDB Tabledoccatg
PMDB Field Namedoc_catg_name
Data Typestring
DocumentStatusCodeNameThe name of the associated document status code.
ODS TableDocument
API Business ObjectDocument
API Field NameDocumentStatusCodeName
PMDB Tabledocstat
PMDB Field Namedoc_status_code
Data Typestring
ProjectIdThe short code that uniquely identifies the project.
ODS TableDocument
API Business ObjectDocument
API Field NameProjectId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
ResourceIdThe short code that uniquely identifies the associated resource.
ODS TableDocument
API Business ObjectDocument
API Field NameResourceId
PMDB Tablersrc
PMDB Field Namersrc_short_name
Data Typestring
ResourceNameThe name of the associated resource.
ODS TableDocument
API Business ObjectDocument
API Field NameResourceName
PMDB Tablersrc
PMDB Field Namersrc_name
Data Typestring
IsBaselineThe boolean value indicating if this business object is related to a Project or Baseline
ODS TableDocument
API Business ObjectDocument
API Field NameIsBaseline
PMDB Table
PMDB Field Name
Data Typestring
lastupdateuserLast Update User
ODS TableDOCUMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableDOCUMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableDOCUMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableDOCUMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on Document
ODS TableDOCUMENT
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
DOCUMENTCATEGORYTop
ObjectIdThe unique ID generated by the system.
ODS TableDocumentCategory
API Business ObjectDocumentCategory
API Field NameObjectId
PMDB Tabledoccatg
PMDB Field Namedoc_catg_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableDocumentCategory
API Business ObjectDocumentCategory
API Field NameSequenceNumber
PMDB Tabledoccatg
PMDB Field Nameseq_num
Data Typeinteger
NameThe name of the document category.
ODS TableDocumentCategory
API Business ObjectDocumentCategory
API Field NameName
PMDB Tabledoccatg
PMDB Field Namedoc_catg_name
Data Typestring
lastupdateuserLast Update User
ODS TableDOCUMENTCATEGORY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableDOCUMENTCATEGORY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableDOCUMENTCATEGORY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableDOCUMENTCATEGORY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on DocumentCategory
ODS TableDOCUMENTCATEGORY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
DOCUMENTSTATUSCODETop
ObjectIdThe unique ID generated by the system.
ODS TableDocumentStatusCode
API Business ObjectDocumentStatusCode
API Field NameObjectId
PMDB Tabledocstat
PMDB Field Namedoc_status_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableDocumentStatusCode
API Business ObjectDocumentStatusCode
API Field NameSequenceNumber
PMDB Tabledocstat
PMDB Field Nameseq_num
Data Typeinteger
NameThe name of the document status code.
ODS TableDocumentStatusCode
API Business ObjectDocumentStatusCode
API Field NameName
PMDB Tabledocstat
PMDB Field Namedoc_status_code
Data Typestring
lastupdateuserLast Update User
ODS TableDOCUMENTSTATUSCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableDOCUMENTSTATUSCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableDOCUMENTSTATUSCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableDOCUMENTSTATUSCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on DocumentStatusCode
ODS TableDOCUMENTSTATUSCODE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSTop
ObjectIdThe unique ID generated by the system.
ODS TableEPS
API Business ObjectEPS
API Field NameObjectId
PMDB Tableprojwbs
PMDB Field Namewbs_id
Data Typeinteger
ProjectObjectIdThe internal Project ID of the EPS. This ID cannot be used to load a Project object directly.
ODS TableEPS
API Business ObjectEPS
API Field NameProjectObjectId
PMDB Tableprojwbs
PMDB Field Nameproj_id
Data Typeinteger
OBSObjectIdThe unique ID of the project manager from the project's OBS tree who is responsible for the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameOBSObjectId
PMDB Tableprojwbs
PMDB Field Nameobs_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableEPS
API Business ObjectEPS
API Field NameSequenceNumber
PMDB Tableprojwbs
PMDB Field Nameseq_num
Data Typeinteger
NameThe name of the EPS element.
ODS TableEPS
API Business ObjectEPS
API Field NameName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
ParentObjectIdThe unique ID of the parent EPS of this EPS in the hierarchy.
ODS TableEPS
API Business ObjectEPS
API Field NameParentObjectId
PMDB Tableprojwbs
PMDB Field Nameparent_wbs_id
Data Typeinteger
OriginalBudgetThe original budget for the project.
ODS TableEPS
API Business ObjectEPS
API Field NameOriginalBudget
PMDB Tableprojwbs
PMDB Field Nameorig_cost
Data Typedouble
IndependentETCTotalCostThe user-entered ETC total cost.
ODS TableEPS
API Business ObjectEPS
API Field NameIndependentETCTotalCost
PMDB Tableprojwbs
PMDB Field Nameindep_remain_total_cost
Data Typedouble
IndependentETCLaborUnitsThe user-entered ETC total labor.
ODS TableEPS
API Business ObjectEPS
API Field NameIndependentETCLaborUnits
PMDB Tableprojwbs
PMDB Field Nameindep_remain_work_qty
Data Typedouble
AnticipatedStartDateThe anticipated start date of the EPS. 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.
ODS TableEPS
API Business ObjectEPS
API Field NameAnticipatedStartDate
PMDB Tableprojwbs
PMDB Field Nameanticip_start_date
Data Typedate
AnticipatedFinishDateThe anticipated finish date of the EPS. 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.
ODS TableEPS
API Business ObjectEPS
API Field NameAnticipatedFinishDate
PMDB Tableprojwbs
PMDB Field Nameanticip_end_date
Data Typedate
CurrentBudgetThe sum of the original budget plus the approved and pending budgets from the budget change log.
ODS TableEPS
API Business ObjectEPS
API Field NameCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
CurrentVarianceThe difference between the current budget and the total spending plan. Calculated as current budget - total spending plan. Not rolled up
ODS TableEPS
API Business ObjectEPS
API Field NameCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
DistributedCurrentBudgetThe current budget values from one level lower.
ODS TableEPS
API Business ObjectEPS
API Field NameDistributedCurrentBudget
PMDB Table
PMDB Field Name
Data Typenumber
FinishDateThe finish date of the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameFinishDate
PMDB Table
PMDB Field Name
Data Typedate
fullnameEPS - Full name
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
IdThe short code assigned to each EPS element for identification.
ODS TableEPS
API Business ObjectEPS
API Field NameId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
LastSummarizedDateThe date the project was last summarized.
ODS TableEPS
API Business ObjectEPS
API Field NameLastSummarizedDate
PMDB Tableproject
PMDB Field Namelast_tasksum_date
Data Typedate
OBSNameThe name of the person/role in the organization, sometimes referred to as the "responsible manager".
ODS TableEPS
API Business ObjectEPS
API Field NameOBSName
PMDB Tableobs
PMDB Field Nameobs_name
Data Typestring
PlannedStartDateThe planned start date of the project. Used by the project scheduler.
ODS TableEPS
API Business ObjectEPS
API Field NamePlannedStartDate
PMDB Tableproject
PMDB Field Nameplan_start_date
Data Typedate
ProposedBudgetThe Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log.
ODS TableEPS
API Business ObjectEPS
API Field NameProposedBudget
PMDB Table
PMDB Field Name
Data Typenumber
StartDateThe start date of the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameStartDate
PMDB Table
PMDB Field Name
Data Typedate
SumAccountingVarByLaborUnitsthe Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAccountingVarianceByLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAccountingVarianceByCostthe Planned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAccountingVarianceByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumActThisPeriodMaterialCostThe actual this period material cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodMaterialCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_mat_cost
Data Typenumber
SumActThisPeriodNonLaborCostThe actual this period nonlabor cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodNonLaborCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_equip_cost
Data Typenumber
SumActThisPeriodNonLaborUnitsThe actual this period nonlabor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_this_per_equip_qty
Data Typenumber
SumActualThisPeriodLaborCostThe actual this period labor cost
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodLaborCost
PMDB Tabletasksum
PMDB Field Nameact_this_per_work_cost
Data Typenumber
SumActualThisPeriodLaborUnitsThe actual this period labor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_this_per_work_qty
Data Typenumber
SumAtCompletionMaterialCostThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionMaterialCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionNonLaborCostThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionNonLaborCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionNonLaborUnitsThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionNonLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionTotalCostVarthe Baseline Planned Total Cost - At Completion Total Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionTotalCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumBaselineCompActivityCountThe number of completed activities in the baseline.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineCompletedActivityCount
PMDB Tabletasksum
PMDB Field Namebase_complete_cnt
Data Typenumber
SumBaselineNotStartedActCntThe number of activities not started in the baseline.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineNotStartedActivityCount
PMDB Tabletasksum
PMDB Field Namebase_notstarted_cnt
Data Typenumber
SumBLInProgressActivityCountthe number of activities that should be currently in progress, according to the primary baseline. Computed using the baseline start and finish dates and the current data date.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineInProgressActivityCount
PMDB Tabletasksum
PMDB Field Namebase_active_cnt
Data Typenumber
SumBudgetAtCmpByLaborUnitsthe Baseline Labor Units
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBudgetAtCompletionByLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_work_qty
Data Typenumber
SumBudgetAtCompletionByCostthe Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBudgetAtCompletionByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumCostPerfIndexByCostthe Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostPerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumCostPerfIndexByLaborUnitsthe Earned Value Labor Units / Actual Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostPerformanceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarianceByLaborUnitsthe Earned Value Labor Cost minus Actual Value Labor Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostVarianceByLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumCostVarIndexByLaborUnitsthe Cost Variance Labor Units divided by Earned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostVarianceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationPercentOfPlannedThe summary actual duration percent of planned of all activities under this EPS. 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryDurationPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
SumEACByCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateAtCompletionByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumEACByLaborUnitsthe Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the EPS.)
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateAtCompletionByLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumEACHighPctByLaborUnitsthe high forecast of Estimate At Completion (EAC) by labor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateAtCompletionHighPercentByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumEACLowPctByLaborUnitsthe low forecast of Estimate At Completion (EAC) by labor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateAtCompletionLowPercentByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumETCByCostthe 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).
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateToCompleteByCost
PMDB Tabletasksum
PMDB Field Nameetc
Data Typenumber
SumETCByLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEstimateToCompleteByLaborUnits
PMDB Tabletasksum
PMDB Field Nameetc_work_qty
Data Typenumber
SumExpenseCostPctCompleteThe percent complete of cost for all expenses associated with the EPS. It is computed as Actual Expense Cost / At Complete Expense Cost * 100, and it is always in the range of 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryExpenseCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumLaborCostPercentCompleteThe percent complete of cost for all labor resources assigned to the EPS. It is computed as Actual Labor Cost / At Complete Labor Cost * 100, and it is always in the range of 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumLaborUnitsPercentCompleteThe percent complete of units for all labor resources for the EPS. Computed as actual labor units / at complete labor units * 100. Always in the range 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryLaborUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumActivityCountthe number of activities that are currently in progress.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActivityCount
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumActualDurationThe actual duration.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualDuration
PMDB Tabletasksum
PMDB Field Nameact_drtn_hr_cnt
Data Typenumber
SumActualExpenseCostThe actual costs for all project expenses associated with the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualExpenseCost
PMDB Tabletasksum
PMDB Field Nameact_expense_cost
Data Typenumber
SumActualFinishDateThe latest actual finish date of all activities in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualFinishDate
PMDB Tabletasksum
PMDB Field Nameact_end_date
Data Typedate
SumActualLaborCostThe actual cost for all labor resources assigned to the activity.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualLaborCost
PMDB Tabletasksum
PMDB Field Nameact_work_cost
Data Typenumber
SumActualLaborUnitsThe actual labor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_work_qty
Data Typenumber
SumActualMaterialCostThe actual units for all material resources assigned to the activity.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualMaterialCost
PMDB Tabletasksum
PMDB Field Nameact_mat_cost
Data Typenumber
SumActualNonLaborCostThe actual units for all nonlabor resources assigned to the activity.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualNonLaborCost
PMDB Tabletasksum
PMDB Field Nameact_equip_cost
Data Typenumber
SumActualNonLaborUnitsThe actual nonlabor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_equip_qty
Data Typenumber
SumActualStartDateThe earliest actual start date of all activities in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualStartDate
PMDB Tabletasksum
PMDB Field Nameact_start_date
Data Typedate
SumActualThisPeriodCostThe actual this period cost (will be labor or nonlabor).
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualThisPeriodCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumActualTotalCostThe actual labor cost + actual nonlabor cost + actual expense cost as of the project data date.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualTotalCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumActualValueByCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualValueByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumActualValueByLaborUnitsthe actual total labor units for the activity as of the project data date (i.e., actual total cost by labor units).
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryActualValueByLaborUnits
PMDB Tabletasksum
PMDB Field Nameact_work_qty
Data Typenumber
SumAtCompletionDurationThe duration at completion.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionDuration
PMDB Tabletasksum
PMDB Field Nametotal_drtn_hr_cnt
Data Typenumber
SumAtCompletionExpenseCostthe sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionExpenseCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionLaborCostThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionLaborCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionLaborUnitsThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumAtCompletionTotalCostThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryAtCompletionTotalCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumBaselineDurationthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineDuration
PMDB Tabletasksum
PMDB Field Namebase_drtn_hr_cnt
Data Typenumber
SumBaselineExpenseCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineExpenseCost
PMDB Tabletasksum
PMDB Field Namebase_expense_cost
Data Typenumber
SumBaselineFinishDateThe current latest finish date of all activities in the EPS for the current baseline.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineFinishDate
PMDB Tabletasksum
PMDB Field Namebase_end_date
Data Typedate
SumBaselineLaborCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineLaborCost
PMDB Tabletasksum
PMDB Field Namebase_work_cost
Data Typenumber
SumBaselineLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_work_qty
Data Typenumber
SumBaselineMaterialCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineMaterialCost
PMDB Tabletasksum
PMDB Field Namebase_mat_cost
Data Typenumber
SumBaselineNonLaborCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineNonLaborCost
PMDB Tabletasksum
PMDB Field Namebase_equip_cost
Data Typenumber
SumBaselineNonLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineNonLaborUnits
PMDB Tabletasksum
PMDB Field Namebase_equip_qty
Data Typenumber
SumBaselineStartDateThe current earliest start date of all activities in the EPS for the current baseline.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineStartDate
PMDB Tabletasksum
PMDB Field Namebase_start_date
Data Typedate
SumBaselineTotalCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryBaselineTotalCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumCompletedActivityCountthe number of activities that have an Actual Finish in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCompletedActivityCount
PMDB Tabletasksum
PMDB Field Namecomplete_cnt
Data Typenumber
SumCostPercentCompleteThe percent complete of costs for the resource assignments in the EPS. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumCostPercentOfPlannedThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostPercentOfPlanned
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarianceByCostthe Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostVarianceByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumCostVarianceIndexThe value that is calculated as the Cost Variance divided by Earned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
SumCostVarianceIndexByCostthe Cost Variance divided by Earned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryCostVarianceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationPercentCompleteThe activity actual duration percent of planned. Computed as actual duration / at completion duration * 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryDurationPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumDurationVarianceThe duration between the activity's baseline duration and the at complete duration. Computed as baseline duration - at completion duration.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryDurationVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumEarnedValueByCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEarnedValueByCost
PMDB Tabletasksum
PMDB Field Namebcwp
Data Typenumber
SumEarnedValueByLaborUnitsthe Schedule Variance Labor Units divided by the Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryEarnedValueByLaborUnits
PMDB Tabletasksum
PMDB Field Nameperfm_work_qty
Data Typenumber
SumExpenseCostVariancethe Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost).
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryExpenseCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumFinishDateVarianceThe duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryFinishDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
SumInProgressActivityCountthe number of activities that are currently in progress.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryInProgressActivityCount
PMDB Tabletasksum
PMDB Field Nameactive_cnt
Data Typenumber
SumLaborCostVariancethe Baseline Planned Labor Cost - At Completion Labor Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryLaborCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumLaborUnitsVarianceThe difference between baseline labor units and at completion labor units. Calculated as Baseline labor units - at completion labor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryLaborUnitsVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumMaterialCostVarianceThe variance that is calculated as Baseline Material Cost - At Completion Material Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryMaterialCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumNonLaborCostVariancethe Baseline Planned Nonlabor Cost - At Completion Nonlabor Cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryNonLaborCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumNonLaborUnitsVarianceThe difference between baseline nonlabor units and at completion non labor units. Calculated as Baseline nonlabor units - at completion nonlabor units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryNonLaborUnitsVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumNotStartedActivityCountthe number of activities that are currently not started.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryNotStartedActivityCount
PMDB Tabletasksum
PMDB Field Namenotstarted_cnt
Data Typenumber
SumPlannedValueByCostthe 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
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryPlannedValueByCost
PMDB Tabletasksum
PMDB Field Namebcws
Data Typenumber
SumProgressFinishDatethe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryProgressFinishDate
PMDB Table
PMDB Field Name
Data Typedate
SumRemainingDurationThe total working time from the EPS remaining start date to the remaining finish date.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingDuration
PMDB Tabletasksum
PMDB Field Nameremain_drtn_hr_cnt
Data Typenumber
SumRemainingExpenseCostThe remaining costs for all project expenses associated with the activities in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingExpenseCost
PMDB Tabletasksum
PMDB Field Nameremain_expense_cost
Data Typenumber
SumRemainingFinishDateThe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingFinishDate
PMDB Tabletasksum
PMDB Field Namereend_date
Data Typedate
SumRemainingLaborCostThe remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingLaborCost
PMDB Tabletasksum
PMDB Field Nameremain_work_cost
Data Typenumber
SumRemainingLaborUnitsThe remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingLaborUnits
PMDB Tabletasksum
PMDB Field Nameremain_work_qty
Data Typenumber
SumRemainingMaterialCostThe remaining material costs for all project expenses associated with the activities in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingMaterialCost
PMDB Tabletasksum
PMDB Field Nameremain_mat_cost
Data Typenumber
SumRemainingNonLaborCostThe remaining nonlabor costs for all project expenses associated with the activities in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingNonLaborCost
PMDB Tabletasksum
PMDB Field Nameremain_equip_cost
Data Typenumber
SumRemainingNonLaborUnitsThe remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingNonLaborUnits
PMDB Tabletasksum
PMDB Field Nameremain_equip_qty
Data Typenumber
SumRemainingStartDateThe earliest remaining start of all activities assigned to the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingStartDate
PMDB Tabletasksum
PMDB Field Namerestart_date
Data Typedate
SumRemainingTotalCostThe sum of all remaining total costs in the EPS.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryRemainingTotalCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumSchedulePercentCompleteThe measure that indicates how much of the EPS 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 EPS duration should be currently completed, relative to the selected baseline.
ODS TableEPS
API Business ObjectEPS
API Field NameSummarySchedulePercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumScheduleVarianceByCostthe Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryScheduleVarianceByCost
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumScheduleVarianceIndexThe value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryScheduleVarianceIndex
PMDB Table
PMDB Field Name
Data Typenumber
SumStartDateVarianceThe duration between the start date in the current project and the baseline start date. Calculated as start date - baseline start date.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryStartDateVariance
PMDB Table
PMDB Field Name
Data Typenumber
SumTotalCostVarianceThe value that is calculated as baseline total cost - total cost.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryTotalCostVariance
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumTotalFloatThe amount of time the EPS 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryTotalFloat
PMDB Tabletasksum
PMDB Field Nametotal_float_hr_cnt
Data Typenumber
SumUnitsPercentCompleteThe percent complete of units for the resource assignments in the EPS. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryUnitsPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumMaterialCostPctCompleteThe percent complete of cost for all material resources assigned to the EPS. It is computed as Actual Material Cost / At Complete Material Cost * 100, and it is always in the range of 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryMaterialCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumNonLaborCostPctCompleteThe percent complete of cost for all non-labor resources assigned to the EPS. It is computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100, and it is always in the range of 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryNonLaborCostPercentComplete
PMDB Table
PMDB Field Name
Data Typenumber
SumNonLaborUnitsPctCompleteThe percent complete of units for all nonlabor resources for the EPS. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryNonLaborUnitsPercentComplete
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumPerfPctCmpByLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryPerformancePercentCompleteByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumPlannedValueByLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryPlannedValueByLaborUnits
PMDB Tabletasksum
PMDB Field Namesched_work_qty
Data Typenumber
SumSchdPctCmpByLaborUnitsthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummarySchedulePercentCompleteByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdPerfIndexByLaborUnitsthe Earned Value Labor Units divided by Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummarySchedulePerformanceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdVarianceByLaborUnitsthe Earned Value Labor Units minus the Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryScheduleVarianceByLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
SumSchdVarianceIndexByCostthe Schedule Variance divided by the Planned Value.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryScheduleVarianceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumSchdVarIndexByLaborUnitsthe Schedule Variance Labor Units divided by the Planned Value Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryScheduleVarianceIndexByLaborUnits
PMDB Table
PMDB Field Name
Data Typenumber
SumSchedulePctCompleteByCostthe 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.
ODS TableEPS
API Business ObjectEPS
API Field NameSummarySchedulePercentCompleteByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumSchedulePerfIndexByCostthe Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled.
ODS TableEPS
API Business ObjectEPS
API Field NameSummarySchedulePerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumToCompletePerfIndexByCostthe (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost).
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryToCompletePerformanceIndexByCost
PMDB Table
PMDB Field Name
Data Typenumber
SumVarAtCmpByLaborUnitsthe Baseline Planned Total Labor Units minus Estimate at Completion Labor Units.
ODS TableEPS
API Business ObjectEPS
API Field NameSummaryVarianceAtCompletionByLaborUnits
PMDB TablePROJWBS
PMDB Field Name
Data Typenumber
TotalBenefitPlanThe sum of the monthly benefit plan.
ODS TableEPS
API Business ObjectEPS
API Field NameTotalBenefitPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalBenefitPlanTallyThe sum of the monthly benefit plan tally.
ODS TableEPS
API Business ObjectEPS
API Field NameTotalBenefitPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
TotalFundingThe total amount of funding contributed to the project by your funding sources.
ODS TableEPS
API Business ObjectEPS
API Field NameTotalFunding
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanThe sum of the monthly spending plan.
ODS TableEPS
API Business ObjectEPS
API Field NameTotalSpendingPlan
PMDB Table
PMDB Field Name
Data Typenumber
TotalSpendingPlanTallyThe sum of the monthly spending plan tally.
ODS TableEPS
API Business ObjectEPS
API Field NameTotalSpendingPlanTally
PMDB Table
PMDB Field Name
Data Typenumber
UnallocatedBudgetThe total current budget minus the distributed current budget.
ODS TableEPS
API Business ObjectEPS
API Field NameUnallocatedBudget
PMDB Table
PMDB Field Name
Data Typenumber
UndistributedCurrentVarianceThe total spending plan minus the total spending plan tally.
ODS TableEPS
API Business ObjectEPS
API Field NameUndistributedCurrentVariance
PMDB Table
PMDB Field Name
Data Typenumber
lastupdateuserLast Update User
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on EPS
ODS TableEPS
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSBUDGETCHANGELOGTop
ObjectIdThe unique ID generated by the system.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameObjectId
PMDB Tablebudgchng
PMDB Field Namebudg_chng_id
Data Typeinteger
projectobjectidEPSBudgetChangeLog - ProjectObjectId maps to PROJWBS.proj_id
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
EPSObjectIdThe unique ID of the EPS element to which the budget change log applies.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameEPSObjectId
PMDB Tablebudgchng
PMDB Field Namewbs_id
Data Typeinteger
EPSBudgetChangeLogDateThe date of this budget change entry.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameDate
PMDB Tablebudgchng
PMDB Field Namechng_date
Data Typedate
ChangeNumberThe change number that is automatically incremented according to when changes are added. This can be changed to any number.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameChangeNumber
PMDB Tablebudgchng
PMDB Field Namechng_short_name
Data Typestring
AmountThe amount of budget change.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameAmount
PMDB Tablebudgchng
PMDB Field Namechng_cost
Data Typedouble
ResponsibleThe person responsible for the change.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameResponsible
PMDB Tablebudgchng
PMDB Field Namechng_by_name
Data Typestring
StatusThe status of this budget change request.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameStatus
PMDB Tablebudgchng
PMDB Field Namestatus_code
Data Typestring
ReasonThe description of the reason for the budget change request.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameReason
PMDB Tablebudgchng
PMDB Field Namechng_descr
Data Typestring
EPSIdThe short code assigned to the associated EPS.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameEPSId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
EPSNameThe name of the EPS element associated with this budget change log.
ODS TableEPSBudgetChangeLog
API Business ObjectEPSBudgetChangeLog
API Field NameEPSName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
lastupdateuserLast Update User
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on EPSBudgetChangeLog
ODS TableEPSBUDGETCHANGELOG
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSFUNDINGTop
ObjectIdThe unique ID generated by the system.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameObjectId
PMDB Tableprojfund
PMDB Field Nameproj_fund_id
Data Typeinteger
FundingSourceObjectIdThe unique ID of the associated funding source for this EPS funding.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameFundingSourceObjectId
PMDB Tableprojfund
PMDB Field Namefund_id
Data Typeinteger
projectobjectidEPSFunding - ProjectObjectId maps to PROJWBS.proj_id
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
AmountThe amount of a funding source that is allocated to the EPS.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameAmount
PMDB Tableprojfund
PMDB Field Namefund_cost
Data Typedouble
FundShareThe percentage of the total fund that is allocated to the EPS.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameFundShare
PMDB Tableprojfund
PMDB Field Namefund_wt
Data Typedouble
EPSIdThe short code assigned to the associated EPS.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameEPSId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
EPSNameThe name of the EPS element associated with this funding.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameEPSName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
EPSObjectIdThe unique ID of the associated EPS for this EPS funding.
ODS TableEPSFunding
API Business ObjectEPSFunding
API Field NameEPSObjectId
PMDB Tableprojwbs
PMDB Field Namewbs_id
Data Typeinteger
lastupdateuserLast Update User
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on EPSFunding
ODS TableEPSFUNDING
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSHIERARCHYTop
ParentObjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentProjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentSequenceNumber
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentName
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentOriginalBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentIndependentETCTotalCost
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentIndependentETCLaborUnits
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentCurrentBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentCurrentVariance
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentDistributedCurrentBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentProposedBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ParentStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentFinishDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentAnticipatedStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentAnticipatedFinishDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentLastSummarizedDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentPlannedStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ParentOBSObjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentOBSName
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildObjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildProjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildSequenceNumber
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildName
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildOriginalBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildIndependentETCTotalCost
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildIndependentETCLaborUnits
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildCurrentBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildCurrentVariance
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildDistributedCurrentBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildProposedBudget
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ChildStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildFinishDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildAnticipatedStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildAnticipatedFinishDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildLastSummarizedDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildPlannedStartDate
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ChildOBSObjectId
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
ChildOBSName
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentLevelsBelowRoot
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildLevelsBelowRoot
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
LevelsBetween
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildHasChildren
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
FullPathName
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
SKey
ODS TableEPSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
WBSHIERARCHYTop
ParentObjectId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentProjectId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentSequenceNumber
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ParentName
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildObjectId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildProjectId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildSequenceNumber
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildName
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ChildId
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentLevelsBelowRoot
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildLevelsBelowRoot
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
LevelsBetween
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ChildHasChildren
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
FullPathName
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
SKey
ODS TableWBSHIERARCHY
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSNOTETop
ObjectIdThe unique ID generated by the system.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameObjectId
PMDB Tablewbsmemo
PMDB Field Namewbs_memo_id
Data Typeinteger
projectobjectidEPSNote - ProjectObjectId maps to PROJWBS.proj_id
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
NotebookTopicObjectIdThe unique ID of the associated notebook topic.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameNotebookTopicObjectId
PMDB Tablewbsmemo
PMDB Field Namememo_type_id
Data Typeinteger
NoteThe information that is associated with the notebook topic.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameNote
PMDB Tablewbsmemo
PMDB Field Namewbs_memo
Data Typeclob
EPSIdThe short code assigned to the associated EPS.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameEPSId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
EPSNameThe name of the EPS element associated with this note.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameEPSName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
EPSObjectIdThe unique ID of the associated EPS.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameEPSObjectId
PMDB Tablewbsmemo
PMDB Field Namewbs_id
Data Typeinteger
NotebookTopicNameThe name of the associated notebook topic.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameNotebookTopicName
PMDB Tablememotype
PMDB Field Namememo_type
Data Typestring
RawTextNoteThe information that is associated with the notebook topic, without any HTML.
ODS TableEPSNote
API Business ObjectEPSNote
API Field NameRawTextNote
PMDB Table
PMDB Field Name
Data Typeclob
lastupdateuserLast Update User
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on EPSNote
ODS TableEPSNOTE
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSSPENDINGPLANTop
ObjectIdThe unique ID generated by the system.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameObjectId
PMDB Tablewbsbudg
PMDB Field Namewbs_budg_id
Data Typeinteger
projectobjectidEPSSpendingPlan - ProjectObjectId maps to PROJWBS.proj_id
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
SpendingPlanThe editable total monthly expenditure for the EPS.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameSpendingPlan
PMDB Tablewbsbudg
PMDB Field Namespend_cost
Data Typedouble
BenefitPlanThe editable monthly profit portion for each month for the EPS.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameBenefitPlan
PMDB Tablewbsbudg
PMDB Field Namebenefit_cost
Data Typedouble
SpendingPlanDateThe start of a spending/benefit plan time period for the EPS.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameDate
PMDB Tablewbsbudg
PMDB Field Namestart_date
Data Typedate
EPSIdThe short code assigned to the associated EPS.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameEPSId
PMDB Tableproject
PMDB Field Nameproj_short_name
Data Typestring
EPSNameThe name of the EPS element associated with this spending plan.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameEPSName
PMDB Tableprojwbs
PMDB Field Namewbs_name
Data Typestring
EPSObjectIdThe unique ID of the associated EPS for this EPS spending plan.
ODS TableEPSSpendingPlan
API Business ObjectEPSSpendingPlan
API Field NameEPSObjectId
PMDB Tablewbsbudg
PMDB Field Namewbs_id
Data Typeinteger
lastupdateuserLast Update User
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
lastupdatedateLast Update Date
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
createuserCreate User
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
createdateCreate Date
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
SKeySKey generated key on EPSSpendingPlan
ODS TableEPSSPENDINGPLAN
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeint
EPSSPREADTop
ObjectId
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
Id
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
Name
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
ParentObjectId
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
projectobjectid
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ObsObjectId
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typeinteger
ObsName
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typestring
StartDate
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
EndDate
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedate
ActualLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualNonlaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionNonlaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedNonlaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EarnedValueLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EstimateAtCompletionLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EstimateToCompleteLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
PlannedValueLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingLaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingNonlaborUnits
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualExpenseCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualLaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualMaterialCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualNonlaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
ActualTotalCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionExpenseCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionLaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionMaterialCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionNonlaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
AtCompletionTotalCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedExpenseCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedLaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedMaterialCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedNonlaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
BaselinePlannedTotalCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EarnedValueCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EstimateAtCompletionCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
EstimateToCompleteCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
PlannedValueCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingExpenseCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingLaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingMaterialCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingNonlaborCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
RemainingTotalCost
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typedouble
SKey
ODS TableEPSSPREAD
API Business Object
API Field Name
PMDB Table
PMDB Field Name
Data Typenumber
EXPENSECATEGORYTop
ObjectIdThe unique ID generated by the system.
ODS TableExpenseCategory
API Business ObjectExpenseCategory
API Field NameObjectId
PMDB Tablecosttype
PMDB Field Namecost_type_id
Data Typeinteger
SequenceNumberThe sequence number for sorting.
ODS TableExpenseCategory
API Business ObjectExpenseCategory
API Field NameSequenceNumber