Primavera Software Development Kit Spread Tables and Fields

Note: Tables and fields in red are not fully tested and so are not supported in this release. Using unsupported fields may result in inconsistent behavior or data loss.

Summary

Table

Title

Description

ACCOUNT_SPREADS

Spread data for Cost Accounts

Cost accounts contain the organization's Cost Account IDs. Available across all projects, they support tracking of costs and earned value based on the organizationís Cost Account IDs

PROJCOST_SPREADS

Spread data for Project Expenses

Project expenses are non-resource costs associated with a project. Project expenses are assigned to activities. They are typically one-time expenditures for non-reusable items.

PROJWBS_SPREADS

Spread data for WBS

The project work breakdown structure (WBS) is a hierarchical arrangement of the products and services produced during and by a project. Each element of a WBS may contain more-detailed WBS elements, activities, or both.

ROLES_SPREADS

Spread data for Roles

Roles are project-personnel job titles or skills. Roles are defined globally across projects. Roles are assigned to activities and to resources. The set of roles you assign to an activity define an activity's skill requirements and facilitate resource staffing for the activity. The set of roles you assign to a resource describe a resource's skill capabilities.

RSRC_SPREADS

Spread data for Resources

Resources contain the personnel and equipment that perform work on activities across all projects. Resources are always time-based and are generally reused between activities and between projects.

TASK_SPREADS

Spread data for Activities

The set of activities for all projects.

TASKRSRC_SPREADS

Spread data for Activity Resource Assignments

The set of resources assigned to perform activities.

WBSRSRC_SPREADS

Spread data for High Level Resource Assignments

The set of resources assigned at WBS or Project level.

Detail

ACCOUNT_SPREADS - (Spreads for Cost Accounts) Cost accounts contain the organization's Cost Account IDs. Available across all projects, they support tracking of costs and earned value based on the organizationís Cost Account IDs.

Field Name

Field Type

Time Distribution

Descriptions

acct_id

Primary Key

 

Unique ID generated by the system.

act_cost

Cost

DateMgr

The actual total cost for the cost account, including labor resources, nonlabor resources, material resources and project expenses. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

act_equip_cost

Cost

DateMgr

The actual cost for all nonlabor resource assignments associated with the cost account. Includes nonovertime plus overtime cost.

act_equip_ot_cost

Cost

DateMgr

The actual overtime cost for all nonlabor resource assignments associated with the cost account.

act_equip_reg_cost

Cost

DateMgr

The actual nonovertime cost for all nonlabor resource assignments associated with the cost account.

act_expense_cost

Cost

DateMgr

The actual cost for all project expenses associated with the cost account.

act_mat_cost

Cost

DateMgr

The actual material cost associated with the cost account.

act_work_cost

Cost

DateMgr

The actual cost for all labor resource assignments associated with the cost account. Includes nonovertime plus overtime cost.

act_work_ot_cost

Cost

DateMgr

The actual overtime cost for all labor resource assignments associated with the cost account.

act_work_reg_cost

Cost

DateMgr

The actual nonovertime cost for all labor resource assignments associated with the cost account.

base_cost

Cost

DateMgr

The total cost including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses in the primary baseline associated with the cost account. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost.

base_equip_cost

Cost

DateMgr

The cost for all nonlabor resource assignments in the primary baseline associated with the cost account.

base_expense_cost

Cost

DateMgr

The cost for all project expenses in the primary baseline associated with the cost account.

base_mat_cost

Cost

DateMgr

The cost for all project expenses in the primary baseline associated with the cost account.

base_work_cost

Cost

DateMgr

The cost for all labor resource assignments in the primary baseline associated with the cost account.

fin_period_act_cost

Cost

DateMgr

The actual total cost for the cost account in the period, including labor resources, nonlabor resources, material resources and project expenses. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

fin_period_act_equip_cost

Cost

DateMgr

The actual cost for all nonlabor resource assignments associated with the cost account in the period. Includes nonovertime plus overtime cost.

fin_period_act_mat_cost

Cost

DateMgr

The actual material cost associated with the cost account in the period.

fin_period_act_work_cost

Cost

DateMgr

The actual cost for all labor resource assignments associated with the cost account in the period. Includes non-overtime plus overtime costs.

fin_period_total_cost

Cost

DateMgr

The total cost at completion is the sum of the actual plus remaining costs for all labor resource assignments, nonlabor resource assignments, and project expenses associated with the cost account in the period.

fin_period_total_equip_cost

Cost

DateMgr

The nonlabor cost at completion is the sum of the actual plus remaining costs for all nonlabor resource assignments associated with the cost account in the period. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost.

fin_period_total_mat_cost

Cost

DateMgr

The total actual material cost associated with the cost account in the period.

fin_period_total_work_cost

Cost

DateMgr

The labor cost at completion is the sum of the actual plus remaining costs for all labor resource assignments associated with the cost account in the period. Computed as Actual Labor Cost + Remaining Labor Cost.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

remain_cost

Cost

DateMgr

The remaining total cost for the cost account, including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses. Remaining Total Cost = Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost.

remain_equip_cost

Cost

DateMgr

The remaining cost for all nonlabor resource assignments associated with the cost account.

remain_expense_cost

Cost

DateMgr

The remaining cost for all project expenses associated with the cost account.

remain_mat_cost

Cost

DateMgr

The remaining material cost associated with the cost account.

remain_work_cost

Cost

DateMgr

The remaining cost for all labor resource assignments associated with the cost account.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

start_date

Start Date

 

The start date of the spread.

target_cost

Cost

DateMgr

The budgeted total cost for the cost account, including labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses. Budgeted Total Cost = Budgeted Labor Cost + Budgeted Nonlabor Cost + Budgeted Material Cost + Budgeted Expense Cost.

target_equip_cost

Cost

DateMgr

The budgeted cost for all nonlabor resource assignments associated with the cost account.

target_expense_cost

Cost

DateMgr

The budgeted cost for all project expenses associated with the cost account.

target_mat_cost

Cost

DateMgr

The budgeted material cost associated with the cost account.

target_work_cost

Cost

DateMgr

The budgeted cost for all labor resource assignments associated with the cost account.

total_cost

Cost

DateMgr

The total cost at completion is the sum of the actual plus remaining cost for all labor resource assignments, nonlabor resource assignments, material resource assignments, and project expenses associated with the cost account.

total_equip_cost

Cost

DateMgr

The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resource assignments associated with the cost account. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost.

total_expense_cost

Cost

DateMgr

The expense cost at completion is 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.

total_mat_cost

Cost

DateMgr

The total material cost at completion associated with the cost account.

total_work_cost

Cost

DateMgr

The labor cost at completion is the sum of the actual plus remaining cost for all labor resource assignments associated with the cost account. Computed as Actual Labor Cost + Remaining Labor Cost.

tree_indent_level

 

 

Used internally.

tree_sort_string

 

 

Used internally.

 

 

 

 

 

PROJCOST_SPREADS - (Spreads for Project Expenses) Project expenses are non-resource costs associated with a project. Project expenses are assigned to activities. They are typically one-time expenditures for non-reusable items. .

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

The actual cost for the project expense.

cost_item_id

Primary Key

 

Unique Id generated by the system.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

remain_cost

Cost

DateMgr

The remaining cost for the project expense. Before actual expenses are made, remaining cost should be the same as budgeted 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.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

start_date

Start Date

 

The start date of the spread.

target_cost

Cost

DateMgr

The budgeted cost for the project expense.

 

 

 

 

 

PROJWBS_SPREADS - (Spreads for WBS) The project work breakdown structure (WBS) is a hierarchical arrangement of the products and services produced during and by a project. Each element of a WBS may contain more-detailed WBS elements, activities, or both. .

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

Sum of all actual total cost in the project.

act_equip_cost

Cost

DateMgr

The actual cost for all nonlabor resources assigned to the activities under the WBS.

act_equip_qty

Quantity

DateMgr

The actual units for all nonlabor resources assigned to the activities under the WBS.

act_expense_cost

Cost

DateMgr

The total actual expense cost for all child activities.

act_mat_cost

Cost

DateMgr

The total actual material cost for all child activities.

act_work_cost

Cost

DateMgr

The total actual labor cost for all child activities.

act_work_qty

Quantity

DateMgr

The total actual labor units for all child activities.

ACWP

Cost

DateMgr

Actual Cost is the Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost as of the project data date. Same as the Actual Total Cost.

base_cost

Cost

DateMgr

The total cost for the WBS in the baseline, including labor resources, nonlabor resources, material resources, and project expenses. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost.

base_equip_cost

Cost

DateMgr

The cost for all nonlabor resources in the baseline assigned to activities in the WBS. Computed from the baseline Budgeted (or At Completion) nonlabor units. If no resources are assigned, computed as the activity BL Nonlabor Units * Project Default Price/Time.

base_equip_qty

Quantity

DateMgr

The sum of Budgeted (or At Completion) Units in the baseline for all nonlabor resources assigned to activities in the WBS.

base_expense_cost

Cost

DateMgr

Sum of all expense cost in the baseline assigned to activities in the wbs.

base_mat_cost

Cost

DateMgr

The Budgeted (or At Completion) Cost in the baseline for all material resources assigned to activities in the WBS.

base_work_cost

Cost

DateMgr

The cost for all labor resources in the baseline assigned to activities in the WBS. Computed from the baseline Budgeted (or At Completion) labor units. If no resources are assigned, computed as the sum of the activities BL Labor Units * Project Default Price/Time.

base_work_qty

Quantity

DateMgr

The sum of Budgeted (or At Completion) Units in the baseline for all labor resources assigned to activities in the WBS.

bcwp

Cost

DateMgr

Earned value cost for the project. Not editable.

bcws

Cost

DateMgr

Budgeted cost of work scheduled for the project. Not editable.

EAC

Cost

DateMgr

Estimate Cost at Completion is 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.

eac_work

Quantity

DateMgr

Calculated as Estimate At Completion - Labor Units.

etc

Cost

DateMgr

Calculated Estimate To Complete using specified technique.

etc_work_qty

Quantity

DateMgr

Sum of all to-complete labor units in the wbs.

fin_period_act_cost

Cost

DateMgr

Sum of all actual total costs in the project for the period.

fin_period_act_equip_cost

Cost

DateMgr

The actual costs for all nonlabor resources assigned to the activities under the WBS in the period.

fin_period_act_equip_qty

Quantity

DateMgr

The actual units for all nonlabor resources assigned to the activities under the WBS in the period.

fin_period_act_expense_cost

Cost

DateMgr

Sum of all actual expense costs in the baseline assigned to activities in the WBS in the period.

fin_period_act_mat_cost

Cost

DateMgr

The total actual material costs for all child activities in the period.

fin_period_act_work_cost

Cost

DateMgr

The total actual labor costs for all child activities in the period.

fin_period_act_work_qty

Quantity

DateMgr

The total actual labor units for all child activities in the period.

fin_period_bcwp

Cost

DateMgr

Earned value cost for the project in the period. Not editable.

fin_period_bcws

Cost

DateMgr

Budgeted cost of work scheduled for the project in the period. Not editable.

fin_period_EAC

Cost

DateMgr

The estimated cost at completion for the Project in the period. 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 Project.

fin_period_eac_work

Quantity

DateMgr

Calculated as Estimate At Completion Ė Labor Units in the period.

fin_period_perfm_work_qty

Quantity

DateMgr

Earned value for the Project in the period. This field is calculated from the Earned Value technique specified for the Project.

fin_period_sched_work_qty

Quantity

DateMgr

 

fin_period_total_cost

Cost

DateMgr

Sum of all at completion total costs in the project in the period.

fin_period_total_equip_cost

Cost

DateMgr

Sum of all at completion nonlabor costs in the WBS in the period.

fin_period_total_equip_qty

Quantity

DateMgr

Sum of all at completion nonlabor units in the WBS in the period.

fin_period_total_expense_cost

Cost

DateMgr

Sum of all at completion expense costs in the WBS in the period.

fin_period_total_mat_cost

Cost

DateMgr

Sum of all at completion material costs in the WBS n the period.

fin_period_total_work_cost

Cost

DateMgr

Sum of all at completion labor costs in the WBS in the period.

fin_period_total_work_qty

Quantity

DateMgr

Sum of all at completion labor units in the WBS in the period.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

perfm_work_qty

Quantity

DateMgr

Earned value for the wbs. This field is calculated from the Earned Value technique specified for the wbs.

remain_cost

Cost

DateMgr

Sum of all remaining total cost in the wbs.

remain_equip_cost

Cost

DateMgr

Sum of all remaining nonlabor cost for the activities in the wbs.

remain_equip_qty

Quantity

DateMgr

Sum of all remaining nonlabor units for the activities in the wbs.

remain_expense_cost

Cost

DateMgr

The remaining cost for all project expenses associated with the wbs.

remain_mat_cost

Cost

DateMgr

Sum of all remaining material cost for the activities in the wbs.

remain_work_cost

Cost

DateMgr

Sum of all remaining labor cost for the activities in the wbs.

remain_work_qty

Quantity

DateMgr

Sum of all remaining labor units for the activities in the wbs.

sched_work_qty

Quantity

DateMgr

Uneditable budgeted cost of work scheduled for the wbs.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

start_date

Start Date

 

The current start date of the wbs.

tot_benefit_plan

Cost

DateMgr

Sum of the Monthly Benefit Plan. Not rolled up.

tot_benefit_plan_tally

Cost

DateMgr

Sum of the Monthly Benefit Plan Tally. Not rolled up.

tot_spend_plan

Cost

DateMgr

Sum of the Monthly Spending Plan. Not rolled up.

tot_spend_plan_tally

Cost

DateMgr

Sum of the Monthly Spending Plan Tally. Not rolled up.

total_cost

Cost

DateMgr

Sum of all at completion total cost in the project.

total_equip_cost

Cost

DateMgr

Sum of all at completion nonlabor cost in the wbs.

total_equip_qty

Quantity

DateMgr

Sum of all at completion nonlabor units in the wbs.

total_expense_cost

Cost

DateMgr

Sum of all at completion expense cost in the wbs.

total_mat_cost

Cost

DateMgr

Sum of all at completion material cost in the wbs.

total_work_cost

Cost

DateMgr

Sum of all at completion labor cost in the wbs.

total_work_qty

Quantity

DateMgr

Sum of all at completion labor units in the project.

tree_indent_level

 

 

Used internally.

tree_sort_string

 

 

Used internally.

undistrib_cur_var

Cost

DateMgr

Computed as the Total Spending Plan minus the Total Spending Plan Tally. Not rolled up.

wbs_id

Primary Key

 

Unique ID.

 

 

 

 

 

ROLES_SPREADS - (Spreads for Roles) Roles are project-personnel job titles or skills. Roles are defined globally across projects. Roles are assigned to activities and to resources. The set of roles you assign to an activity define an activity's skill requirements and facilitate resource staffing for the activity. The set of roles you assign to a resource describe a resource's skill capabilities. .

Field Name

Field Type

Time Distribution

Descriptions

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

act_cost

Cost

DateMgr

Time distribution of the role's non-overtime plus overtime actual cost.

act_qty

Quantity

DateMgr

Time distribution of the role's non-overtime plus overtime actual units.

fin_period_act_cost

Cost

DateMgr

Time distribution of the role's non-overtime plus overtime actual cost in the period.

fin_period_act_qty

Quantity

DateMgr

Time distribution of the role's non-overtime plus overtime actual units in the period.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

remain_cost

Cost

DateMgr

Time distribution of the role's remaining cost.

remain_qty

Quantity

DateMgr

Time distribution of the role's remaining units.

role_id

Primary Key

 

Unique ID generated by the system.

staffed_remain_cost

Cost

DateMgr

Time distribution of the role's remaining cost for any roles that have been filled by resources.

staffed_remain_qty

Quantity

DateMgr

Time distribution of the role's remaining units for any roles that have been filled by resources.

start_date

Start Date

 

The start date of the spread.

target_cost

Cost

DateMgr

Time distribution of the role's planned cost.

target_qty

Quantity

DateMgr

Time distribution of the role's planned units.

tree_indent_level

 

 

Used internally.

tree_sort_string

 

 

Used internally.

unstaffed_remain_cost

Cost

DateMgr

Time distribution of the role's remaining cost for any roles that have not been filled by resources.

unstaffed_remain_qty

Quantity

DateMgr

Time distribution of the role's remaining units for any roles that have not been filled by resources.

 

 

 

 

 

RSRC_SPREADS - (Spreads for Resources) Resources contain the personnel and equipment that perform work on activities across all projects. Resources are always time-based and are generally reused between activities and between projects. .

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

Time distribution of the resource's actual cost.

act_qty

Quantity

DateMgr

Time distribution of the resource's non-overtime plus overtime actual units, based on the resource assignment to the current project.

fin_period_act_cost

Cost

DateMgr

Time distribution of the resource's actual cost in the period.

fin_period_act_qty

Quantity

DateMgr

Time distribution of the resource's non-overtime plus overtime actual units, based on the resource assignment to the current project in the period.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

remain_cost

Cost

DateMgr

Time distribution of the resource's remaining cost.

remain_qty

Quantity

DateMgr

Time distribution of the resource's remaining units, based on the resource assignment to the current project.

rsrc_id

Primary Key

 

The name of the report included in the batch report.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

target_cost

Cost

DateMgr

Time distribution of the resource's planned cost.

target_qty

Quantity

DateMgr

Time distribution of the resource's planned units, based on the resource assignment to the current project.

total_qty

Quantity

DateMgr

 

tree_indent_level

 

 

Used internally.

tree_sort_string

 

 

Used internally.

 

 

 

 

 

TASK_SPREADS - (Spreads for Activities) The set of activities for all projects..

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

The Actual Total Cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

act_equip_cost

Cost

DateMgr

The actual 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.

act_equip_qty

Quantity

DateMgr

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

act_expense_cost

Cost

DateMgr

The actual cost for all project expenses associated with the activity.

act_mat_cost

Cost

DateMgr

The actual cost for all material resources assigned to the activity.

act_work_cost

Cost

DateMgr

The actual cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Labor Units * Project Default Price / Time.

act_work_qty

Quantity

DateMgr

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

ACWP

Cost

DateMgr

Actual Cost is the Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost as of the project data date. Same as the Actual Total Cost.

base_cost

Cost

DateMgr

The total cost for the activity in the baseline, including labor resources, nonlabor resources, material resources, and project expenses. BL Total Cost = BL Labor Cost + BL Nonlabor Cost + BL Material Cost + BL Expense Cost.

base_equip_cost

Cost

DateMgr

The cost for all nonlabor resources assigned to the activity in the baseline. Computed from the baseline Budgeted (or At Completion) nonlabor units. If no resources are assigned, computed as the activity BL Nonlabor Units * Project Default Price/Time.

base_equip_qty

Quantity

DateMgr

The sum of the Budgeted (or At Completion) Units for all nonlabor resources assigned to the activity in the project baseline.

base_expense_cost

Cost

DateMgr

The cost for all project expenses associated with the activity in the baseline.. Computed as the sum of the baseline Budgeted (or At Completion) expense cost.

base_mat_cost

Cost

DateMgr

The Budgeted (or At Completion) Cost for all material resources assigned to the activity in the baseline.

base_work_cost

Cost

DateMgr

The cost for all labor resources assigned to the activity in the primary baseline. Computed from the baseline Budgeted (or At Completion) labor units. If no resources are assigned, computed as the activity BL Labor Units * Project Default Price/Time.

base_work_qty

Quantity

DateMgr

The sum of the Budgeted (or At Completion) Units for all labor resources assigned to the activity in the project baseline.

BCWP

Cost

DateMgr

Earned Value Cost is 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 baseline.

BCWS

Cost

DateMgr

Planned Value Cost is 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 baseline. When an activity has assignments, the Planned Value Cost is calculated as the Budget At Completion * (Data date of current project - Baseline Assignment start date)/(Baseline Assignment start date) for each of the assignments and then summed to the activity level.

EAC

Cost

DateMgr

Estimate Cost at Completion is 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.

eac_work

Quantity

DateMgr

Estimate At Completion Labor Units is 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.)

ETC

Cost

DateMgr

Estimate Cost to Complete is calculated from the baseline as either the Remaining Total Cost for the activity, or as the Performance Factor * (Budget at Completion - Earned Value), depending on the Earned Value technique selected for the activity's WBS.

etc_work_qty

Quantity

DateMgr

The estimated quantity to complete the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Budgeted Labor Units - Budgeted Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS.

fin_period_act_cost

Cost

DateMgr

The Actual Total Cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses in the period. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost.

fin_period_act_equip_cost

Cost

DateMgr

The actual 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.

fin_period_act_equip_qty

Quantity

DateMgr

The actual units for all nonlabor resources assigned to the activity in the period.

fin_period_act_expense_cost

Cost

DateMgr

The actual costs for all project expenses associated with the activity in the period.

fin_period_act_mat_cost

Cost

DateMgr

The actual cost for all material resources assigned to the activity in the period.

fin_period_act_work_cost

Cost

DateMgr

The actual costs for all labor resources assigned to the activity in the period. If no resources are assigned, computed as the activity Actual Labor Units * Project Default Price / Time.

fin_period_act_work_qty

Quantity

DateMgr

The actual units for all labor resources assigned to the activity in the period.

fin_period_bcwp

Cost

DateMgr

Budgeted Cost of Work Performed is the portion of the baseline total cost of the activity in the period that is actually completed as of the project data date. Computed as BCWP = BAC * Performance % Complete. Also known as the Earned Value for the activity. The method for computing the performance percent complete depends on the earned-value technique selected for the activity's WBS. BAC is computed from the current baseline.

fin_period_bcws

Cost

DateMgr

Budgeted Cost of Work Scheduled is the portion of the baseline total cost of the activity in the period that is scheduled to be completed as of the project data date. Computed as BCWS = 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 baseline duration has been completed so far. BAC is computed from the current baseline.

fin_period_eac

Cost

DateMgr

The estimated cost at completion for the activity in the period. 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.

fin_period_eac_work

Quantity

DateMgr

Estimate At Completion Labor Units in the period. It is 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.)

fin_period_perfm_work_qty

Quantity

DateMgr

Planned Labor Units Performed is the portion of the baseline labor units in the period that is actually completed as of the project data date. Computed as BL 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 BL Labor Units is taken from the current baseline.

fin_period_sched_work_qty

Quantity

DateMgr

Planned Labor Units Scheduled is the portion of the baseline labor units in the period 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 baseline duration has been completed so far. The BL Labor Units is taken from the current baseline.

fin_period_total_cost

Cost

DateMgr

The total cost at completion for the activity in the period, including labor resources, nonlabor resources, and project expenses. At Completion Total Cost = At Completion Labor Cost + At Completion Nonlabor Cost + At Completion Expense Cost.

fin_period_total_equip_cost

Cost

DateMgr

The nonlabor cost at completion is the sum of the actual plus remaining costs for all nonlabor resources assigned to the activity in the period. 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.

fin_period_total_equip_qty

Quantity

DateMgr

The nonlabor units at completion is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity in the period. Computed as Actual Nonlabor Units + Remain Nonlabor Units. Same as the planned nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.

fin_period_total_expense_cost

Cost

DateMgr

The expense cost at completion is the sum of the actual plus remaining costs for all expenses associated with the activity in the period. Computed as Actual Expense Cost + Remaining Expense Cost.

fin_period_total_mat_cost

Cost

DateMgr

The material cost at completion is the sum of the actual plus remaining material costs for all material resources associated with the activity in the period. Computed as Actual Expense Cost + Remaining Expense Cost.

fin_period_total_work_cost

Cost

DateMgr

The labor cost at completion is the sum of the actual plus remaining costs for all labor resources assigned to the activity in the period. 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.

fin_period_total_work_qty

Quantity

DateMgr

The labor units at completion is the sum of the actual plus remaining units for all labor resources assigned to the activity in the period. 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.

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

perfm_work_qty

Quantity

DateMgr

Earned Value Labor Units Performed is 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 Earned Value Labor Units 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 in taken from the baseline.

remain_cost

Cost

DateMgr

The remaining total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Remaining Total Cost = Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost.

remain_equip_cost

Cost

DateMgr

The remaining cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Nonlabor Units * Project Default Price / Time.

remain_equip_qty

Quantity

DateMgr

The 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 budgeted units. After the activity is completed, the remaining units are zero.

remain_expense_cost

Cost

DateMgr

The remaining cost for all project expenses associated with the activity.

remain_mat_cost

Cost

DateMgr

The remaining cost for all material resources assigned to the activity.

remain_work_cost

Cost

DateMgr

The remaining cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Labor Units * Project Default Price / Time.

remain_work_qty

Quantity

DateMgr

The 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 budgeted units. After the activity is completed, the remaining units are zero.

sched_work_qty

Quantity

DateMgr

Planned Value Labor Units Scheduled is 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 baseline.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

start_date

Start Date

 

The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started.

target_cost

Cost

DateMgr

The budgeted total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Budgeted Total Cost = Budgeted Labor Cost + Budgeted Nonlabor Cost + Budgeted Material Cost + Budgeted Expense Cost.

target_equip_cost

Cost

DateMgr

The budgeted cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Nonlabor Units * Project Default Price / Time.

target_equip_qty

Quantity

DateMgr

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

target_expense_cost

Cost

DateMgr

The budgeted cost for all project expenses associated with the activity.

target_mat_cost

Cost

DateMgr

The budgeted cost for all material resources assigned to the activity.

target_work_cost

Cost

DateMgr

The budgeted costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Labor Units * Project Default Price / Time.

target_work_qty

Quantity

DateMgr

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

task_id

Primary Key

 

Unique ID generated by the system.

total_cost

Cost

DateMgr

The total cost at completion for the activity, including labor resources, nonlabor resources, material resources, and project expenses. At Completion Total Cost = At Completion Labor Cost + At Completion Nonlabor Cost + At Completion Material Cost + At Completion Expense Cost.

total_equip_cost

Cost

DateMgr

The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost. Same as the budgeted nonlabor cost if the activity is not started and the actual nonlabor cost once the activity is completed.

total_equip_qty

Quantity

DateMgr

The nonlabor units at completion 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 budgeted nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed.

total_expense_cost

Cost

DateMgr

The expense cost at completion is the sum of the actual plus remaining cost for all expenses associated with the activity. Computed as Actual Expense Cost + Remaining Expense Cost.

total_mat_cost

Cost

DateMgr

The material cost at completion is the sum of the actual plus remaining cost for all material resources assigned to the activity. Computed as Actual Material Cost + Remaining Material Cost. Same as the budgeted material cost if the activity is not started and the actual material cost once the activity is completed.

total_work_cost

Cost

DateMgr

The labor cost at completion is the sum of the actual plus remaining cost for all labor resources assigned to the activity. Computed as Actual Labor Cost + Remaining Labor Cost. Same as the budgeted labor cost if the activity is not started and the actual labor cost once the activity is completed.

total_work_qty

Quantity

DateMgr

The labor units at completion is 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 budgeted labor units if the activity is not started and the actual labor units once the activity is completed.

 

 

 

 

 

TASKRSRC_SPREADS - (Spreads for Activity Resource Assignments) The set of resources assigned to perform activities..

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

The actual nonovertime plus overtime cost for the resource assignment on the activity. Computed as Actual Cost = Actual Regular Cost + Actual Overtime Cost.

act_ot_cost

Cost

DateMgr

The actual overtime cost for the resource assignment on the activity. Computed as Actual Overtime Cost = Actual Overtime Units * Cost per Time * Overtime Factor.

act_ot_qty

Quantity

DateMgr

The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

act_qty

Quantity

DateMgr

The actual nonovertime plus overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. Computed as Actual Units = Actual Regular Units + Actual Overtime Units.

act_reg_cost

Cost

DateMgr

The actual nonovertime cost for the resource assignment on the activity. Computed as Actual Regular Cost = Actual Regular Units * Cost per Time.

act_reg_qty

Quantity

DateMgr

The actual nonovertime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.

fin_period_act_cost

Cost

DateMgr

The actual non-overtime plus overtime cost for the resource assignment on the activity in the period. Computed as Actual Cost = Actual Regular Cost + Actual Overtime Cost.

fin_period_act_qty

Quantity

DateMgr

The actual non-overtime plus overtime units worked by the resource on this activity in the period. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager. Computed as Actual Units = Actual Regular Units + Actual Overtime Units.

fin_period_total_cost

Cost

DateMgr

 

fin_period_total_qty

Quantity

DateMgr

 

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

remain_cost

Cost

DateMgr

The remaining cost for the resource assignment on the activity. Computed as Remaining Cost = Remaining Units * Cost per Time.

remain_qty

Quantity

DateMgr

The remaining units of work to be performed by this resource on this activity. Before the activity is started, the remaining units are the same as the budgeted units. After the activity is completed, the remaining units are zero.

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

staffed_remain_cost

Cost

DateMgr

Time distribution of the resource's remaining cost for resource assignments that have filled a role.

staffed_remain_qty

Quantity

DateMgr

Time distribution of the resource's remaining units for resource assignments that have filled a role.

start_date

Start Date

 

The current start date of the resource assignment on the activity. Set to the planned start date until the activity is started, then set to the actual start date.

target_cost

Cost

DateMgr

The budgeted cost for the resource assignment on the activity. Computed as Budgeted Cost = Budgeted Units * Price per Time.

target_qty

Quantity

DateMgr

The budgeted units of work for the resource assignment on the activity.

taskrsrc_id

Primary Key

 

Unique ID generated by the system.

total_cost

Cost

DateMgr

The cost at completion is the sum of the actual plus remaining cost for the resource assignment on the activity. Computed as Actual Cost + Remaining Cost.

total_qty

Quantity

DateMgr

The units at completion is the sum of the actual plus remaining units for the resource assignment on the activity. Computed as Actual Units + Remaining Units. Same as the budgeted units if the activity is not started and the actual units once the activity is completed.

unstaffed_remain_cost

Cost

DateMgr

Time distribution of the resource's remaining cost for resource assignments that have not filled a role.

unstaffed_remain_qty

Quantity

DateMgr

Time distribution of the resource's remaining units for resource assignments that have not filled a role.

 

 

 

 

 

WBSRSRC_SPREADS - (Spreads for High Level Resource Planning Assignments) .

Field Name

Field Type

Time Distribution

Descriptions

act_cost

Cost

DateMgr

 

act_equip_cost

Cost

DateMgr

 

act_equip_qty

Quantity

DateMgr

 

act_expense_cost

Cost

DateMgr

 

act_mat_cost

Cost

DateMgr

 

act_work_cost

Cost

DateMgr

 

act_work_qty

Quantity

DateMgr

 

ACWP

Cost

DateMgr

 

base_cost

Cost

DateMgr

 

base_end_date

Finish Date

DateMgr

 

base_equip_cost

Cost

DateMgr

 

base_equip_qty

Quantity

DateMgr

 

base_expense_cost

Cost

DateMgr

 

base_mat_cost

Cost

DateMgr

 

base_start_date

Start Date

DateMgr

 

base_work_cost

Cost

DateMgr

 

base_work_qty

Quantity

DateMgr

 

BCWP

Cost

DateMgr

 

BCWS

Cost

DateMgr

 

commituncommited_total_qty

Quantity

DateMgr

 

EAC

Cost

DateMgr

 

eac_work

Quantity

DateMgr

 

ETC

Cost

DateMgr

 

etc_work_qty

Quantity

DateMgr

 

fiscal_format

 

 

Only relevant to monthly spreads. It is the mapping of the calendar month into fiscal months. If the spread_type is not months, then the value is null.

normal_format

Start Date

 

The start date reformatted.

perfm_work_qty

Quantity

DateMgr

 

reend_date

Finish Date

DateMgr

 

remain_cost

Cost

DateMgr

 

remain_equip_cost

Cost

DateMgr

 

remain_equip_qty

Quantity

DateMgr

 

remain_expense_cost

Cost

DateMgr

 

remain_mat_cost

Cost

DateMgr

 

remain_work_cost

Cost

DateMgr

 

remain_work_qty

Quantity

DateMgr

 

restart_date

Start Date

DateMgr

 

sched_work_qty

Quantity

DateMgr

 

spread_type

Static

 

Can be Hours(H), Days(D), Weeks(W), Quarters(Q), or Months(M).

start_date

Start Date

 

The current start date of the Resource on the WBS/Project.

target_cost

Cost

DateMgr

 

target_equip_cost

Cost

DateMgr

 

target_equip_qty

Quantity

DateMgr

 

target_expense_cost

Cost

DateMgr

 

target_mat_cost

Cost

DateMgr

 

target_work_cost

Cost

DateMgr

 

target_work_qty

Quantity

DateMgr

 

total_cost

Cost

DateMgr

 

total_equip_cost

Cost

DateMgr

 

total_equip_qty

Quantity

DateMgr

 

total_expense_cost

Cost

DateMgr

 

total_mat_cost

Cost

DateMgr

 

total_qty

Quantity

DateMgr

The total units the Resource is assigned to work on the WBS/Project.

total_work_cost

Cost

DateMgr

 

total_work_qty

Quantity

DateMgr

 

wbsrsrc_id

Primary Key