Percentage and Number Fields

Table B-8 lists all percentage and number fields available in Microsoft Project.

Table B-8. Percentage and Number Fields

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Assign-

Assignment

AssignmentUnits

ASSN_UNITS

The number of resource units

ment Units

assigned to a task, expressed as a percentage of a resource's total availability.

(Timephased)

TaskCPI

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

Cumulative

Task

The progress of a task mea-

Percent

(Timephased)

sured as a percentage of the

Complete

total work required to finish the task, as distributed over time.

(Timephased)

TaskCVP

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

Max Units

Resource

ResourceMax-

RES_MAX_

The maximum number of units

Units

UNITS

a resource is available to be assigned to tasks in the project.

Number1-

Assignment

Assignment-

The values for the custom

20

Number1-20

Number1 through Number20

Resource

Resource-Number1-20

fields.

Task

TaskNumber1-20

Objects

Resource

ResourceObjects

RES_NUM_ OBJECTS

The number of objects, such as an inserted graphic or a linked

Task

TaskObjects

TASK_NUM_ OBJECTS

file, associated with either a task or resource.

Peak

Assignment

Assignment-PeakUnits

The number of units that represents a resource's largest

Resource

Resource-PeakUnits

RES_PEAK

assignment (in units) or the number of units required to complete an assignment.

Table B-8. Percentage and Number Fields

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Peak Units

Assignment

AssignmentTime-

The number of units that repre

(Timephased)

PeakUnits

sents a resource's largest assign

Resource (Timephased)

ResourceTime-PeakUnits

ment (in units) or the number of units required to complete an assignment, shown for a specific time period.

Percent

Assignment

AssignmentTime-

The percentage of a resource's

Allocation

(Timephased)

PercentAllocation

total available units compared

Resource

ResourceTime-

with assigned units.

(Timephased)

PercentAllocation

Percent

Task

TaskPercent-

TASK_PCT_

The ratio of a task's total dura

(Timephased)

Complete

COMP

tion to completed duration.

Percent

Assignment

TaskPercentWork-

TASK_PCT_

The ratio of a task's total work

Work

Resource Task

Complete

WORK_COMP

to completed work.

Complete

Physical

Task

TASK_PHY_

A percent complete value that

Percent

PCT_COMP

can be used as an alternative to

Complete

regular percent complete for the purposes of calculating BCWP and other earned value fields.

(Timephased)

TaskSPI

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

(Timephased)

TaskSVP

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

Task Out-

Assignment

TaskOutlineNum-

TASK_

Indicates a task's position in

line Number

ber

OUTLINE_NUM

the outline.

TCPI

Task

TaskTCPI

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

Unit

Resource

ResourceTime-

The number of units a resource

Availability

(Timephased)

Unit-Availability

is available to be assigned work, expressed as a percentage of a resource's total units.

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