Currency Fields

Table B-1 lists all currency and currency rate fields available in Microsoft Project.

For more information about working with costs, see Chapter 8, "Planning Resource and Task Costs," and "Monitoring and Adjusting Costs" on page 338. For more information about analyzing project information with earned value, see Chapter 13, "Analyzing Project Information."

Available

OLE DB

Microsoft Project

Field

Categories

Provider

Database

Description

Actual

Assignment

AssignmentActualCost

ASSN_ACT_COST

The actual costs

Cost

Assignment

AssignmentTime-

associated with

(Timephased)

ActualCost

resource work or

Resource

ResourceActualCost

RES_ACT_COST

fixed costs for tasks.

Resource

ResourceTimeActualCost

(Timephased)

Task

TaskActualCost

TASK_ACT_COST

Task

TaskTimeActualCost

(Timephased)

Actual

Task

TaskTimeActualFixedCost

The actual fixed cost

Fixed Cost

(Timephased)

expenses charged over time.

Actual

Assignment

AssignmentActual-

ASSN_ACT_OVT_COST

The actual overtime

Overtime

OvertimeCost

costs.

Cost

Resource

ResourceActual-OvertimeCost

RES_ACT_OVT_COST

Task

TaskActualOvertimeCost

TASK_ACT_OVT_COST

ACWP

Assignment

AssignmentACWP

ASSN_ACWP

The earned value

Assignment

AssignmentTimeACWP

actual cost of work-

(Timephased)

performed (ACWP).

Resource

ResourceACWP

RES_ACWP

Resource

ResourceTimeACWP

(Timephased)

Task

TaskACWP

TASK_ACWP

Task

TaskTimeACWP

(Timephased)

BAC

Assignment

AssignmentBaselineCost

ASSN_BASE_COST

The earned value

Assignment

AssignmentTime-

Budget At Comple-

(Timephased)

BaselineCost

tion (BAC). Same as

Resource

ResourceBaselineCost

RES_BASE_COST

the Baseline Cost field.

Resource

ResourceTime-

(Timephased)

BaselineCost

Task

TaskBaselineCost

TASK_BASE_COST

Task

TaskTimeBaselineCost

(Timephased)

Available

OLE DB

Microsoft Project

Field

Categories

Provider

Database

Description

Baseline-

Assignment

AssignmentBaselineCost

ASSN_BASE_COST

The total planned

Resource Resource (Timephased)

AssignmentTime-BaselineCost

ResourceBaselineCost

ResourceTime-

BaselineCost

RES_BASE_COST

cost for work performed, plus fixed costs.

Task

TaskBaselineCost

TASK_BASE_COST

Task

TaskTimeBaselineCost

(Timephased)

Baselinel-

Assignment

AssignmentBaselinel-

The baseline costs

lOCost

CostlO

for Baseline l

Assignment

AssignmentTimeBaselinel-

through Baseline 10.

(Timephased)

Cost-10

Resource

ResourceBaselinel-CostlO

Resource

ResourceTimeBaselinel-

(Timephased)

Cost-lO

Task

TaskBaselinelCost-10

Task

TaskTimeBaselinel-

(Timephased)

Cost-10

BCWP

Assignment

AssignmentBCWP

ASSN_BCWP

The earned

Assignment (Timephased)

AssignmentTimeBCWP

value budgeted costs of work performed (BCWP) costs.

Resource Resource

ResourceBCWP ResourceTimeBCWP

RES_BCWP

(Timephased)

Task

TaskBCWP

TASK_BCWP

Task

TaskTimeBCWP

(Timephased)

Available

OLE DB

Microsoft Project

Field

Categories

Provider

Database

Description

BCWS

Assignment

AssignmentBCWS

ASSN_BCWS

The earned

Assignment (Timephased)

AssignmentTimeBCWS

value budgeted cost of work scheduled (BCWS) costs.

Resource Resource

ResourceBCWS ResourceTimeBCWS

RES_BCWS

(Timephased)

Task

TaskBCWS

TASK_BCWS

Task

TaskTimeBCWS

(Timephased)

Cost

Assignment

AssignmentCost

ASSN_COST

The total

Resource Resource (Timephased)

AssignmentTimeCost

ResourceCost ResourceTimeCost

RES_COST

scheduled cost for an assignment, including expected costs and those already incurred.

Task

TaskCost

TASK_COST

Task

TaskTimeCost

(Timephased)

Cost Per

Resource

ResourceCostPerUse

RES_COST_PER_USE

The cost for each

Use

unit of work performed by a resource.

Cost

Assignment

AssignmentCostVariance

The difference

Variance

Resource Task

ResourceCostVariance TaskCostVariance

between the baseline cost and total scheduled cost.

Cost1-10

Assignment

AssignmentCost1-10

The values for

Resource Task

ResourceCost1-10 TaskCost1-10

the custom Cost1 through Cost10 fields.

Cumulative

Assignment

AssignmentTime-

The cumulative

Cost

(Timephased)

CumulativeCost

cost for all work

(Timephased)

Task

ResourceTimeCumulative-Cost

TaskTimeCumulativeCost

performed on all assigned tasks, as distributed over time.

(Timephased)

(Timephased)

Available

OLE DB

Microsoft Project

Field

Categories

Provider

Database

Description

CV

Assignment

AssignmentCV

The earned value

Resource Resource (Timephased)

AssignmentTimeCV

ResourceCV ResourceTimeCV

Cost Variance (CV), which is the difference between the budgeted (baseline) cost and the actual

Task

TaskCV

cost of work

Task

TaskTimeCV

performed.

(Timephased)

EAC

Task

TaskEAC

TASK_EAC

The earned value estimate at completion (EAC), which is the expected total cost of a task.

Fixed Cost

Task

TaskFixedCost

TASK_FIXED_COST

The expense for

Task

TaskTimeFixedCost

a nonresource task.

(Timephased)

Overtime

Assignment

AssignmentOvertimeCost

ASSN_OVT_COST

The total scheduled

Cost

Resource Task

ResourceOvertimeCost TaskOvertimeCost

RES_OVT_COST TASK_OVT_COST

overtime cost for an assignment, resource, or task.

Overtime

Resource

ResourceOvertimeCost

RES_OVT_COST

The total overtime

Rate

cost for a resource on all assigned tasks.

Remaining

Assignment

AssignmentRemaining-

ASSN_REM_COST

The costs asso-

Cost

Cost

ciated with

Resource Task

ResourceRemainingCost TaskRemainingCost

RES_REM_COST TASK_REM_COST

completing remaining scheduled work.

Remaining

Resource

ResourceRemaining-

RES_REM_OVT_COST

The remaining over-

Overtime

OvertimeCost

time costs for a

Cost

resource.

Standard

Resource

ResourceStandardRate

RES_STD_RATE

The standard rate

Rate

for nonovertime work performed by a resource.

Available

OLE DB

Microsoft Project

Field

Categories

Provider

Database

Description

SV

Assignment

AssignmentSV

The earned value

Resource

AssignmentTimeSV ResourceSV

schedule variance (SV), which is the difference between BCWP

Resource

ResourceTimeSV

and BCWS measured

(Timephased)

in cost terms.

Task

TaskSV

Task

TaskTimeSV

(Timephased)

Resource

Task

AssignmentVAC

ResourceVAC

TaskVAC

Assignment

Resource

Task

AssignmentVAC

ResourceVAC

TaskVAC

TASK VAC

The earned value variance at completion (VAC), which is the difference between BAC and EAC, measured in cost terms.

T3 T3

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment