Earned Value Fields

Earned value fields are used to measure the cost of work and are based on a task's baseline cost. Table B-12 shows earned value fields.

For information about working with earned value, see Chapter 13.

Table B-12. Earned Value Fields

Field

Available Categories

OLE DB

Provider

Microsoft

Project

Database

Description

ACWP

Assignment Assignment (Timephased)

Resource Resource (Timephased)

Task Task

(Timephased)

AssignmentACWP ASSN_ACWP AssignmentTimeACWP

The earned value actual cost of work performed (ACWP).

ResourceACWP ResourceTimeACWP

TaskACWP TaskTimeACWP

RES ACWP

TASK_ACWP

Field Reference

Table B-12.

Earned Value Fields

Microsoft

Available

OLE DB

Project

Field

Categories

Provider

Database

Description

BAC

Assignment

Assignment-

ASSN_BASE_

The earned value Budget

BaselineCost

COST

At Completion (BAC).

Assignment (Timephased)

AssignmentTime-BaselineCost

Same as the Baseline Cost field.

Resource

Resource-BaselineCost

RES_BASE_ COST

Resource

ResourceTime-

(Timephased)

BaselineCost

Task

TaskBaselineCost

TASK_BASE_ COST

Task (Timephased)

TaskTimeBaselineCost

BCWP

Assignment

AssignmentBCWP

ASSN_BCWP

The earned value

Resource

AssignmentTimeBCWP ResourceBCWP

RES_BCWP

budgeted costs of work performed (BCWP) costs.

Resource

ResourceTimeBCWP

(Timephased)

Task

TaskBCWP

TASK_BCWP

Task (Timephased)

TaskTimeBCWP

BCWS

Assignment

AssignmentBCWS

ASSN_BCWS

The earned value

Resource

AssignmentTime-BCWS

ResourceBCWS

RES_BCWS

budgeted cost of work scheduled (BCWS) costs.

Resource

ResourceTimeBCWS

(Timephased)

Task

TaskBCWS

TASK_BCWS

Task (Timephased)

TaskTimeBCWS

(Timephased)

TaskCPI

The earned value cost performance index, which is the ratio between BCWP and ACWP.

Table B-12. Earned Value Fields

Field

Available Categories

OLE DB

Provider

Microsoft

Project

Database

Description

CV Assignment

Assignment (Timephased)

Resource Resource (Timephased)

Task

Task (Timephased)

AssignmentCV AssignmentTimeCV

ResourceCV ResourceTimeCV

TaskCV TaskTimeCV

The earned value Cost Variance (CV), which is the difference between the budgeted (baseline) cost and the actual cost of work performed.

CV Percent Task

Task (Timephased)

TaskCVP

The earned value Cost Variance percent (CV%), which is the ratio of CV to BCWP, expressed as a percentage.

Task

TaskEAC

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

Earned Task

Value

Method

TASK_ The method (Percent

EVMETHOD Complete or Physical Per cent Complete) used to calculate BCWP.

Physical Task

Percent

Complete

TASK_PHY_ The percent complete

PCT_COMP value, also known as earned value percent complete; an alternative to BCWP.

SPI Task TaskSPI

Task (Timephased)

The earned value schedule performance index (SPI), which is the ratio of BCWP to BCWS.

1000

Table B-12. Earned Value Fields

Microsoft

Available

OLE DB

Project

Field

Categories

Provider

Database

Description

SV

Assignment

AssignmentSV

The earned value sched-

Resource

AssignmentTimeSV ResourceSV

ule variance (SV), which is the difference between BCWP and BCWS measured in cost terms.

Resource

ResourceTimeSV

(Timephased)

Task

TaskSV

Task

TaskTimeSV

(Timephased)

(Timephased)

TaskSVP

The earned value schedule variance (SV%), which is the ratio of SV to BCWS.

TCPI

Task

TaskTCPI

The earned value To Complete Performance Index (TCPI), which is the ratio of remaining work to remaining funds.

VAC

Assignment

AssignmentVAC

The earned value vari-

Resource

ResourceVAC

ance at completion (VAC),

Task

TaskVAC

which is the difference between BAC and EAC, measured in cost terms.

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