skey | F_PROJECTS.skey maps to STG_F_PROJECT.skey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
projectskey | F_PROJECTS.projectskey maps to STG_F_PROJECT.projectskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
financialperiodskey | F_PROJECTS.financialperiodskey maps to STG_F_PROJECT.financialperiodskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
costaccountskey | F_PROJECTS.costaccountskey maps to STG_F_PROJECT.costaccountskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
epsskey | F_PROJECTS.epsskey maps to STG_F_PROJECT.epsskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
obsskey | F_PROJECTS.obsskey maps to STG_F_PROJECT.obsskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
startdateskey | F_PROJECTS.startdateskey maps to STG_F_PROJECT.startdateskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
finishdateskey | F_PROJECTS.finishdateskey maps to STG_F_PROJECT.finishdateskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
anticipatedfinishdateskey | F_PROJECTS.anticipatedfinishdateskey maps to STG_F_PROJECT.anticipatedfinishdateskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
anticipatedstartdateskey | F_PROJECTS.anticipatedstartdateskey maps to STG_F_PROJECT.anticipatedstartdateskey |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | bigint |
isbaseline | F_PROJECTS.isbaseline maps to STG_F_PROJECT.isbaseline |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | character |
currentprocesscycledate | F_PROJECTS.currentprocesscycledate maps to STG_F_PROJECT.currentprocesscycledate |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
ActivityDefaultPricePerUnit | The price used to estimate resource costs for activities that have planned, actual, or remaining units, but no resource assignments. This price is also used to compute costs for activities in cases where resources are assigned but the resources have no prices. Resource cost is computed as the resource units multiplied by the price per time. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ActivityDefaultPricePerUnit |
PMDB Table | project |
PMDB Field Name | def_cost_per_qty |
Data Type | number |
AnnualDiscountRate | The user-defined number field that identifies the discount rate for the project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | AnnualDiscountRate |
PMDB Table | projwbs |
PMDB Field Name | ann_dscnt_rate_pct |
Data Type | number |
CheckOutDate | The date on which the project was checked out of the Project Management database. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | CheckOutDate |
PMDB Table | project |
PMDB Field Name | checkout_date |
Data Type | date |
CriticalActivityFloatLimit | The duration used to determine if an activity is critical. When an activity has total float that is less than or equal to this duration, the activity is marked as critical. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | CriticalActivityFloatLimit |
PMDB Table | project |
PMDB Field Name | critical_drtn_hr_cnt |
Data Type | number |
CurrentBudget | The sum of the original budget plus the approved and pending budgets from the budget change log. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | CurrentBudget |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
CurrentVariance | The difference between the current budget and the total spending plan. Calculated as current budget - total spending plan. Not rolled up |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | CurrentVariance |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
DataDate | The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | DataDate |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
DateAdded | The date on which the project was added to the Project Management database. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | DateAdded |
PMDB Table | project |
PMDB Field Name | add_date |
Data Type | date |
DistributedCurrentBudget | The current budget values from one level lower. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | DistributedCurrentBudget |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
EarnedValueUserPercent | The user-defined percent complete for computing earned value for activities within the Project. A value of, say, 25 means that 25% of the planned amount is earned when the activity is started and the remainder is earned when the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | EarnedValueUserPercent |
PMDB Table | projwbs |
PMDB Field Name | ev_user_pct |
Data Type | number |
FiscalYearStartMonth | The month that marks the beginning of the fiscal year for the project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | FiscalYearStartMonth |
PMDB Table | project |
PMDB Field Name | fy_start_month_num |
Data Type | integer |
ForecastFinishDate | The alternate end date to be optionally used by the scheduler. The user sets the alternate end date by dragging the project bar in the Gantt Chart while manually leveling the resource profile in a resource analysis layout. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ForecastFinishDate |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
ForecastStartDate | The alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ForecastStartDate |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
IndependentETCLaborUnits | The user-entered ETC total labor. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | IndependentETCLaborUnits |
PMDB Table | projwbs |
PMDB Field Name | indep_remain_work_qty |
Data Type | number |
IndependentETCTotalCost | The user-entered ETC total cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | IndependentETCTotalCost |
PMDB Table | projwbs |
PMDB Field Name | indep_remain_total_cost |
Data Type | number |
lastbaselineupdatedate | F_PROJECTS.lastbaselineupdatedate maps to STG_F_PROJECT.lastbaselineupdatedate |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
LastSummarizedDate | The date the project was last summarized. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | LastSummarizedDate |
PMDB Table | project |
PMDB Field Name | last_tasksum_date |
Data Type | date |
LevelingPriority | The priority for scheduling. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | LevelingPriority |
PMDB Table | project |
PMDB Field Name | priority_num |
Data Type | integer |
MustFinishByDate | The date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | MustFinishByDate |
PMDB Table | project |
PMDB Field Name | plan_end_date |
Data Type | date |
OverallProjectScore | The project score calculated based on all project code types assigned to this project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | OverallProjectScore |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
PlannedStartDate | The planned start date of the project. Used by the project scheduler. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | PlannedStartDate |
PMDB Table | project |
PMDB Field Name | plan_start_date |
Data Type | date |
ProjectForecastStartDate | The alternate start date to be optionally used by the scheduler. The user sets the alternate start date by dragging the project bar in the Gantt Chart around while manually leveling the resource profile in a resource analysis layout. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ProjectForecastStartDate |
PMDB Table | project |
PMDB Field Name | fcst_start_date |
Data Type | date |
ProposedBudget | The Proposed Budget, which is the sum of the original budget plus the approved and pending budgets from the budget change log. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ProposedBudget |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
ScheduledFinishDate | The early finish date of the latest activity in the project, as computed by the project scheduler. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | ScheduledFinishDate |
PMDB Table | project |
PMDB Field Name | scd_end_date |
Data Type | date |
StrategicPriority | The project's priority. The range is from 1 to 10,000. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | StrategicPriority |
PMDB Table | project |
PMDB Field Name | strgy_priority_num |
Data Type | integer |
SummarizedDataDate | The data date of the project when it was last summarized-only updated by summarizer. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarizedDataDate |
PMDB Table | project |
PMDB Field Name | sum_data_date |
Data Type | date |
Status | The project status: 'Planned', 'Active', 'Inactive', 'What-If', or 'Requested'. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | Status |
PMDB Table | projwbs |
PMDB Field Name | status_code |
Data Type | string |
SumAccountingVarByLaborUnits | the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAccountingVarianceByLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAccountingVarianceByCost | the Planned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAccountingVarianceByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumActivityCount | the number of activities that are currently in progress. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActivityCount |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumActThisPeriodMaterialCost | The actual this period material cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodMaterialCost |
PMDB Table | tasksum |
PMDB Field Name | act_this_per_mat_cost |
Data Type | number |
SumActThisPeriodNonLaborCost | The actual this period nonlabor cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodNonLaborCost |
PMDB Table | tasksum |
PMDB Field Name | act_this_per_equip_cost |
Data Type | number |
SumActThisPeriodNonLaborUnits | The actual this period nonlabor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodNonLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | act_this_per_equip_qty |
Data Type | number |
SumActualDuration | The actual duration. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualDuration |
PMDB Table | tasksum |
PMDB Field Name | act_drtn_hr_cnt |
Data Type | number |
SumActualExpenseCost | The actual costs for all project expenses associated with the project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualExpenseCost |
PMDB Table | tasksum |
PMDB Field Name | act_expense_cost |
Data Type | number |
SumActualFinishDate | The latest actual finish date of all activities in the project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualFinishDate |
PMDB Table | tasksum |
PMDB Field Name | act_end_date |
Data Type | date |
SumActualLaborCost | The actual cost for all labor resources assigned to the activity. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualLaborCost |
PMDB Table | tasksum |
PMDB Field Name | act_work_cost |
Data Type | number |
SumActualLaborUnits | The actual labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | act_work_qty |
Data Type | number |
SumActualMaterialCost | The actual units for all material resources assigned to the activity. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualMaterialCost |
PMDB Table | tasksum |
PMDB Field Name | act_mat_cost |
Data Type | number |
SumActualNonLaborCost | The actual units for all nonlabor resources assigned to the activity. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualNonLaborCost |
PMDB Table | tasksum |
PMDB Field Name | act_equip_cost |
Data Type | number |
SumActualNonLaborUnits | The actual nonlabor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualNonLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | act_equip_qty |
Data Type | number |
SumActualStartDate | The earliest actual start date of all activities in the project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualStartDate |
PMDB Table | tasksum |
PMDB Field Name | act_start_date |
Data Type | date |
SumActualThisPeriodCost | The actual this period cost (will be labor or nonlabor). |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumActualThisPeriodLaborCost | The actual this period labor cost |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodLaborCost |
PMDB Table | tasksum |
PMDB Field Name | act_this_per_work_cost |
Data Type | number |
SumActualThisPeriodLaborUnits | The actual this period labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualThisPeriodLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | act_this_per_work_qty |
Data Type | number |
sumactualtotalcost | F_PROJECTS.sumactualtotalcost maps to STG_F_PROJECT.sumactualtotalcost |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumActualValueByCost | the actual total cost incurred on the activity as of the project data date, computed as Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualValueByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumActualValueByLaborUnits | the actual total labor units for the activity as of the project data date (i.e., actual total cost by labor units). |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryActualValueByLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | act_work_qty |
Data Type | number |
SumAtCompletionDuration | The duration at completion. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionDuration |
PMDB Table | tasksum |
PMDB Field Name | total_drtn_hr_cnt |
Data Type | number |
SumAtCompletionExpenseCost | the sum of the actual plus remaining cost for all project expenses associated with the cost account. Computed as Actual Expense Cost + Remaining Expense Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionExpenseCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionLaborCost | The sum of the actual plus remaining costs for all labor resources assigned to the activity. Computed as actual labor cost + remaining labor cost. Same as the planned labor costs if the activity is not started and the actual labor costs once the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionLaborCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionLaborUnits | The sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as actual labor units + remaining labor units. Same as the planned labor units if the activity is not started and the actual labor units once the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionMaterialCost | The material cost at completion. It is the sum of the actual plus remaining costs for all material resources assigned to the activity. Computed as actual material cost + remaining material cost. Same as the planned material costs if the activity is not started and the actual material costs once the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionMaterialCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionNonLaborCost | The nonlabor cost at completion. It is the sum of the actual plus remaining costs for all nonlabor resources assigned to the activity. Computed as actual nonlabor cost + remaining nonlabor cost. Same as the planned nonlabor costs if the activity is not started and the actual nonlabor costs once the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionNonLaborCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionNonLaborUnits | The nonlabor units at completion. It is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as actual nonlabor units + remaining nonlabor units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionNonLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionTotalCost | The estimated cost at completion for the activity. Computed as the actual total cost plus the estimate-to-complete cost; EAC = ACWP + ETC. Note that the method for computing ETC depends on the earned-value technique selected for the activity's WBS. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionTotalCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumAtCompletionTotalCostVar | the Baseline Planned Total Cost - At Completion Total Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryAtCompletionTotalCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumBaselineCompActivityCount | The number of completed activities in the baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineCompletedActivityCount |
PMDB Table | tasksum |
PMDB Field Name | base_complete_cnt |
Data Type | number |
SumBaselineDuration | the planned duration for the activity in the primary baseline. Planned duration is the total working time from the activity current start date to the current finish date. Same as the actual duration plus the remaining duration. The total working time is computed using the activity's calendar. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineDuration |
PMDB Table | tasksum |
PMDB Field Name | base_drtn_hr_cnt |
Data Type | number |
SumBaselineExpenseCost | the planned cost for all project expenses associated with the activity in the primary baseline. Computed as the baseline actual expense cost plus the baseline remaining expense cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineExpenseCost |
PMDB Table | tasksum |
PMDB Field Name | base_expense_cost |
Data Type | number |
SumBaselineFinishDate | The current latest finish date of all activities in the project for the current baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineFinishDate |
PMDB Table | tasksum |
PMDB Field Name | base_end_date |
Data Type | date |
SumBaselineLaborCost | the planned cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion labor units. If no resources are assigned, computed as the activity Baseline Planned Labor Units * Project Default Price / Time. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineLaborCost |
PMDB Table | tasksum |
PMDB Field Name | base_work_cost |
Data Type | number |
SumBaselineLaborUnits | the planned units for all labor resources assigned to the activity in the primary baseline. Computed as the baseline actual labor units plus the baseline remaining labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | base_work_qty |
Data Type | number |
SumBaselineMaterialCost | the planned cost for all material resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineMaterialCost |
PMDB Table | tasksum |
PMDB Field Name | base_mat_cost |
Data Type | number |
SumBaselineNonLaborCost | the planned cost for all nonlabor resources assigned to the activity in the primary baseline. Computed from the baseline At Completion nonlabor units. If no resources are assigned, computed as the activity Baseline Planned Nonlabor Units * Project Default Price / Time. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineNonLaborCost |
PMDB Table | tasksum |
PMDB Field Name | base_equip_cost |
Data Type | number |
SumBaselineNonLaborUnits | the planned units for all nonlabor resources assigned to the activity in the primary baseline. Computed as the baseline actual nonlabor units plus the baseline remaining nonlabor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineNonLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | base_equip_qty |
Data Type | number |
SumBaselineNotStartedActCnt | The number of activities not started in the baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineNotStartedActivityCount |
PMDB Table | tasksum |
PMDB Field Name | base_notstarted_cnt |
Data Type | number |
SumBaselineStartDate | The current earliest start date of all activities in the Project for the current baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineStartDate |
PMDB Table | tasksum |
PMDB Field Name | base_start_date |
Data Type | date |
SumBaselineTotalCost | the Planned Total Cost for the activity in the primary baseline, including labor resources, nonlabor resources, and project expenses. Baseline Planned Total Cost = Baseline Planned Labor Cost + Baseline Planned Nonlabor Cost + Baseline Planned Expense Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineTotalCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumBLInProgressActivityCount | The number of in-progress activities in the baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBaselineInProgressActivityCount |
PMDB Table | tasksum |
PMDB Field Name | base_active_cnt |
Data Type | number |
SumBudgetAtCmpByLaborUnits | the Baseline Labor Units |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBudgetAtCompletionByLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | base_work_qty |
Data Type | number |
SumBudgetAtCompletionByCost | the Planned Total Cost through activity completion. Computed as Planned Labor Cost + Planned Nonlabor Cost + Planned Expense Cost, same as the Planned Total Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryBudgetAtCompletionByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumCompletedActivityCount | the number of activities that have an Actual Finish in the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCompletedActivityCount |
PMDB Table | tasksum |
PMDB Field Name | complete_cnt |
Data Type | number |
SumCostPercentComplete | The percent complete of cost for all nonlabor resources assigned. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostPercentOfPlanned | The activity actual cost percent of planned. Computed as actual total cost / baseline total cost * 100, or equivalently as ACWP / BAC * 100. The value can exceed 100. The baseline total cost is the activity's at completion cost from the current baseline. This field is named SummaryCostPercentOfBudget in Primavera's Engineering & Construction and Maintenance & Turnaround solutions. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostPercentOfPlanned |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostPerfIndexByCost | the Earned Value divided by the Actual Cost. A value less than 1 indicates that the Actual Cost has exceeded the Planned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostPerformanceIndexByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostPerfIndexByLaborUnits | the Earned Value Labor Units / Actual Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostPerformanceIndexByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostVarianceByCost | the Earned Value minus the Actual Cost. A negative value indicates that the Actual Cost has exceeded the Planned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostVarianceByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumCostVarianceByLaborUnits | the Earned Value Labor Cost minus Actual Value Labor Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostVarianceByLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumCostVarianceIndex | The value that is calculated as the Cost Variance divided by Earned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostVarianceIndex |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostVarianceIndexByCost | the Cost Variance divided by Earned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostVarianceIndexByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumCostVarIndexByLaborUnits | the Cost Variance Labor Units divided by Earned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryCostVarianceIndexByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumDurationPercentComplete | The activity actual duration percent of planned. Computed as actual duration / baseline planned duration * 100. The value can exceed 100. The baseline planned duration is the activity's at complete duration from the primary baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryDurationPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumDurationPercentOfPlanned | The summary actual duration percent of planned of all activities under this project. Computed as actual duration / baseline duration * 100. The value can exceed 100. The Baseline duration is the activity's at complete duration from the current baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryDurationPercentOfPlanned |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumDurationVariance | The duration between the activity's baseline duration and the at complete duration. Computed as baseline planned duration - at completion duration. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryDurationVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumEACByCost | the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateAtCompletionByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumEACByLaborUnits | the Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the Project.) |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateAtCompletionByLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumEACHighPctByLaborUnits | the high forecast of Estimate At Completion (EAC) by labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateAtCompletionHighPercentByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumEACLowPctByLaborUnits | the low forecast of Estimate At Completion (EAC) by labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateAtCompletionLowPercentByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumEarnedValueByCost | the Budget at Completion * Performance % Complete. The method for computing the Performance Percent Complete depends on the Earned Value technique selected for the activity's WBS. Budget at Completion is computed from the primary baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEarnedValueByCost |
PMDB Table | tasksum |
PMDB Field Name | bcwp |
Data Type | number |
SumEarnedValueByLaborUnits | the portion of the baseline labor units that is actually completed as of the project data date. Computed as Baseline Labor Units * Performance % Complete. The planned labor units performed is essentially the labor units Earned Value for the activity. The method for computing the Performance % Complete depends on the Earned Value technique selected for the activity's WBS. The Baseline Labor Units is taken from the current baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEarnedValueByLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | perfm_work_qty |
Data Type | number |
SumETCByCost | the Remaining Total Cost for the activity or the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS (calculated from the primary baseline). |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateToCompleteByCost |
PMDB Table | tasksum |
PMDB Field Name | etc |
Data Type | number |
SumETCByLaborUnits | the estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Planned Labor Units - Planned Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryEstimateToCompleteByLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | etc_work_qty |
Data Type | number |
SumExpenseCostPctComplete | The percent complete of cost for all expenses associated with the project. It is computed as Actual Expense Cost / At Complete Expense Cost * 100, and it is always in the range of 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryExpenseCostPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumExpenseCostVariance | the Baseline Planned Expense Cost - At Completion Expense Cost (At Completion Expense Cost = Actual Expense Cost + Remaining Expense Cost). |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryExpenseCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumFinishDateVariance | The duration between the finish date in the current project and the baseline finish date. Calculated as finish date - baseline finish date. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryFinishDateVariance |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumInProgressActivityCount | the number of activities that are currently in progress. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryInProgressActivityCount |
PMDB Table | tasksum |
PMDB Field Name | active_cnt |
Data Type | number |
SumLaborCostPercentComplete | The percent complete of cost for all labor resources assigned to the project. It is computed as Actual Labor Cost / At Complete Labor Cost * 100, and it is always in the range of 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryLaborCostPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumLaborCostVariance | the Baseline Planned Labor Cost - At Completion Labor Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryLaborCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumLaborUnitsPercentComplete | The percent complete of units for all labor resources for the Project. Computed as actual labor units / at complete labor units * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryLaborUnitsPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumLaborUnitsVariance | The difference between baseline labor units and at completion labor units. Calculated as baseline labor units - at completion labor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryLaborUnitsVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumMaterialCostPctComplete | The percent complete of cost for all material resources assigned to the project. It is computed as Actual Material Cost / At Complete Material Cost * 100, and it is always in the range of 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryMaterialCostPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumMaterialCostVariance | The variance that is calculated as Baseline Material Cost - At Completion Material Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryMaterialCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumNonLaborCostPctComplete | The percent complete of cost for all non-labor resources assigned to the project. It is computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100, and it is always in the range of 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryNonLaborCostPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumNonLaborCostVariance | the Baseline Planned Nonlabor Cost - At Completion Nonlabor Cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryNonLaborCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumNonLaborUnitsPctComplete | The percent complete of units for all nonlabor resources for the Project. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryNonLaborUnitsPercentComplete |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumNonLaborUnitsVariance | The difference between baseline nonlabor units and at completion non labor units. Calculated as baseline nonlabor units - at completion nonlabor units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryNonLaborUnitsVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumNotStartedActivityCount | the number of activities that are currently not started. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryNotStartedActivityCount |
PMDB Table | tasksum |
PMDB Field Name | notstarted_cnt |
Data Type | number |
SumPerfPctCmpByLaborUnits | the percent complete of performance for all labor resources. Computed as earned value labor units / baseline labor units * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryPerformancePercentCompleteByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumPlannedValueByCost | the Budget at Completion * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Budget at Completion is computed from the primary baseline |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryPlannedValueByCost |
PMDB Table | tasksum |
PMDB Field Name | bcws |
Data Type | number |
SumPlannedValueByLaborUnits | the portion of the baseline labor units that is scheduled to be completed as of the project data date. Computed as Baseline Labor Units * Schedule % Complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The Baseline Labor Units is taken from the current baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryPlannedValueByLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | sched_work_qty |
Data Type | number |
SumProgressFinishDate | the date the activity is expected to be finished according to the progress made on the activity's work products. The expected finish date is entered manually by people familiar with progress of the activity's work products. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryProgressFinishDate |
PMDB Table | |
PMDB Field Name | |
Data Type | date |
SumRemainingDuration | The total working time from the Project remaining start date to the remaining finish date. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingDuration |
PMDB Table | tasksum |
PMDB Field Name | remain_drtn_hr_cnt |
Data Type | number |
SumRemainingExpenseCost | The remaining costs for all project expenses associated with the activities in the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingExpenseCost |
PMDB Table | tasksum |
PMDB Field Name | remain_expense_cost |
Data Type | number |
SumRemainingFinishDate | The date the resource is scheduled to finish the remaining work for the activity. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingFinishDate |
PMDB Table | tasksum |
PMDB Field Name | reend_date |
Data Type | date |
SumRemainingLaborCost | The remaining costs for all labor resources assigned to the activities. The remaining cost reflects the cost remaining for the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingLaborCost |
PMDB Table | tasksum |
PMDB Field Name | remain_work_cost |
Data Type | number |
SumRemainingLaborUnits | The remaining units for all labor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | remain_work_qty |
Data Type | number |
SumRemainingMaterialCost | The remaining material costs for all project expenses associated with the activities in the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingMaterialCost |
PMDB Table | tasksum |
PMDB Field Name | remain_mat_cost |
Data Type | number |
SumRemainingNonLaborCost | The remaining nonlabor costs for all project expenses associated with the activities in the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingNonLaborCost |
PMDB Table | tasksum |
PMDB Field Name | remain_equip_cost |
Data Type | number |
SumRemainingNonLaborUnits | The remaining units for all nonlabor resources assigned to the activities. The remaining units reflects the work remaining to be done for the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingNonLaborUnits |
PMDB Table | tasksum |
PMDB Field Name | remain_equip_qty |
Data Type | number |
SumRemainingStartDate | The earliest remaining start of all activities assigned to the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingStartDate |
PMDB Table | tasksum |
PMDB Field Name | restart_date |
Data Type | date |
SumRemainingTotalCost | The sum of all remaining total costs in the Project. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryRemainingTotalCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumSchdPctCmpByLaborUnits | the percent complete of units for all labor resources. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarySchedulePercentCompleteByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchdPerfIndexByLaborUnits | the Earned Value Labor Units divided by Planned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarySchedulePerformanceIndexByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchdVarianceByLaborUnits | the Earned Value Labor Units minus the Planned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryScheduleVarianceByLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumSchdVarianceIndexByCost | the Schedule Variance divided by the Planned Value. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryScheduleVarianceIndexByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchdVarIndexByLaborUnits | the Schedule Variance Labor Units divided by the Planned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryScheduleVarianceIndexByLaborUnits |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchedulePctCompleteByCost | the percent complete of performance for all labor resources, nonlabor resources, and expenses. Computed as Earned Value / Budget At Completion * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarySchedulePercentCompleteByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchedulePercentComplete | The measure that indicates how much of the Project baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline start, the schedule % complete is 0. If the data date is later than the baseline finish, the schedule % complete is 100. The schedule % complete indicates how much of the Project duration should be currently completed, relative to the selected baseline. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarySchedulePercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumSchedulePerfIndexByCost | the Earned Value divided by the Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummarySchedulePerformanceIndexByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumScheduleVarianceByCost | the Earned Value divided by the Planned Value. A negative value indicates that less work was actually performed than was scheduled. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryScheduleVarianceByCost |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumScheduleVarianceIndex | The value that is calculated as the Schedule Variance Labor Units divided by Planned Value Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryScheduleVarianceIndex |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumStartDateVariance | The duration between the start date in the current project and the baseline start date. Calculated as start date - baseline start date. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryStartDateVariance |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumToCompletePerfIndexByCost | the (Budget at Completion - Earned Value) divided by (Estimate at Completion - Actual Cost). |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryToCompletePerformanceIndexByCost |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumTotalCostVariance | The value that is calculated as baseline total cost - total cost. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryTotalCostVariance |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
SumTotalFloat | The amount of time the Project can be delayed before delaying the project finish date. Total float can be computed as late start - early start or as late finish - early finish; this option can be set when running the project scheduler. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryTotalFloat |
PMDB Table | tasksum |
PMDB Field Name | total_float_hr_cnt |
Data Type | number |
SumUnitsPercentComplete | The percent complete of units for the resource assignments in the Project. Computed as Actual Units / At Complete Units * 100. Always in the range 0 to 100. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryUnitsPercentComplete |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
SumVarAtCmpByLaborUnits | the Baseline Planned Total Labor Units minus Estimate at Completion Labor Units. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | SummaryVarianceAtCompletionByLaborUnits |
PMDB Table | PROJECT |
PMDB Field Name | |
Data Type | number |
TotalBenefitPlan | The sum of the monthly benefit plan. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | TotalBenefitPlan |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
TotalBenefitPlanTally | The sum of the monthly benefit plan tally. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | TotalBenefitPlanTally |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
TotalFunding | The total amount of funding contributed to the project by your funding sources. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | TotalFunding |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
TotalSpendingPlan | The sum of the monthly spending plan. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | TotalSpendingPlan |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
TotalSpendingPlanTally | The sum of the monthly spending plan tally. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | TotalSpendingPlanTally |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
UnallocatedBudget | The total current budget minus the distributed current budget. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | UnallocatedBudget |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
UndistributedCurrentVariance | The total spending plan minus the total spending plan tally. |
STAR Table | F_PROJECTS |
API Business Object | Project |
API Field Name | UndistributedCurrentVariance |
PMDB Table | |
PMDB Field Name | |
Data Type | number |
snapshotid | ID of star snapshot |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | integer |
etlprocess | F_PROJECTS.etlprocess maps to STG_F_PROJECT.etlprocess |
STAR Table | F_PROJECTS |
API Business Object | |
API Field Name | |
PMDB Table | |
PMDB Field Name | |
Data Type | date |