Duration Fields

Table B-3 lists all duration fields available in Microsoft Project.

For more information about durations, see "Setting Task Durations" on page 138.

Table B-3. Duration Fields

Field

Actual

Overtime

Work

Available Categories

OLE DB Provider

Microsoft

Project Database Description

Actual Task Duration

TaskActualDuration

TASK ACT DUR

The amount of time that actual work has been performed on a task, up to the current date.

Assignment

Assignment-OvertimeWork

Assignment AssignmentTime-(Timephased) OvertimeWork

Resource ResourceOvertime-Work

Resource ResourceTime-(Timephased) OvertimeWork

Task Task

TaskOvertimeWork TaskTimeOvertime-

ASSN_OVT_WORK

RES OVT WORK

TASK OVT WORK

The amount of overtime work already completed by a resource on a task.

(Timephased) Work

FEfifUBi

FEW!

Field

Available Categories

OLE DB Provider

Actual Work

Assignment

Assignment-ActualWork

Assignment (Timephased)

AssignmentTime-ActualWork

Resource

ResourceActualWork

Resource (Timephased)

ResourceTime-ActualWork

Task

TaskActualWork

(Timephased)

TaskTimeActualWork

Actual Overtime Work Protected

ActualOvertime-

WorkProtected

Assignment (Timephased)

AssignmentTime-

ActualOvertimeWork-

Protected

Resource

ResourceActualOver-timeWorkProtected

Actual Work Protected

Assignment

AssignmentActual-WorkProtected

Assignment (Timephased)

AssignmentTime-ActualWorkProtected

Resource

ResourceActualWork-Protected

Task

TaskActualWork-Protected

Assignment Delay

Assignment

AssignmentDelay

Microsoft

Project Database Description

ASSN ACT WORK

RES ACT WORK

TASK ACT WORK

ASSN_ACT_OVT_ WORK PROT

RES_ACT_ OVT_ WORK_PROT

ASSN_ACT_WORK_ PROT

RES_ACT_WORK_ PROT

TASK_ACT_WORK_ PROT

ASSN DELAY

Microsoft

Project Database Description

ASSN ACT WORK

The amount of work already completed by a resource on a task.

RES ACT WORK

TASK ACT WORK

ASSN_ACT_OVT_ WORK PROT

RES_ACT_ OVT_ WORK_PROT

The amount of actual overtime work reported by a resource and retained on Project Server, regardless of whether the project manager changes the amount in the project plan.

ASSN_ACT_WORK_ PROT

RES_ACT_WORK_ PROT

TASK_ACT_WORK_ PROT

The amount of actual work reported by a resource and retained on Project Server, regardless of whether the project manager changes the amount in the project plan.

ASSN DELAY

The amount of time between when a resource is assigned work and when a resource begins work.

Available

Microsoft

Field

Categories

OLE DB Provider

Project Database

Description

Baseline

Task

TaskBaselineDuration

TASK_BASE_DUR

The amount of

Duration

time originally planned to complete a task.

Baseline

Assignment

AssignmentBaseline-

ASSN_BASE_WORK

The number of

Work

Work

work resource

Assignment (Timephased)

AssignmentTime-BaselineWork

hours originally planned for a task.

Resource

ResourceBaseline-Work

RES_BASE_WORK

Resource

ResourceTime-

(Timephased)

BaselineWork

Task

TaskBaselineWork

TASK_BASE_WORK

Task

TaskTimeBaseline-

(Timephased)

Work

Baseline1-

Task

TaskBaseline1-

The baseline

10 Duration

Duration-10

duration values for Baseline 1 through Baseline 10.

Baseline1-

Assignment

AssignmentBaseline1-

The baseline

10 Work

Work-10

work values

Assignment

AssignmentTime-

for Baseline 1

(Timephased) Resource

Baseline1Work-10

ResourceBaseline1-Work-10

through Baseline 10.

Resource

ResourceTime-

(Timephased)

Baseline1Work-10

Task

TaskBaseline1-Work-10

Task

TaskTimeBaseline1-

(Timephased)

Work-10

Cumulative

Assignment

AssignmentTime-

The amount of

Work

(Timephased)

CumulativeWork

work over a

Resource

ResourceTime-

period of time.

(Timephased)

CumulativeWork

Task

TaskTimeCumulative-

(Timephased)

Work

Available

Microsoft

Field

Categories

OLE DB Provider

Project Database

Description

Duration

Task

TaskDuration

TASK_DUR

The amount of working time between a task's start and finish dates.

Duration

Task

TaskDuration-

TASK_DUR_VAR

The difference

Variance

Variance

between a task's baseline duration and total scheduled duration.

Dura-

Assignment

Assignment-

The values for

tion1-10

Duration1-10

the Custom

Resource

Resource-Duration1-10

Durationl through DurationlO fields.

Task

TaskDuration1-10

Finish

Task

TaskFinishSlack

The difference

Slack

between a task's early start and late finish dates.

Finish

Assignment

AssignmentFinish-

ASSN_FINISH_VAR

The difference

Variance

Variance

between the

Task

TaskFinishVariance

TASK_FINISH_VAR

baseline start date of a task or assignment and its current finish date.

Free Slack

Task

TaskFreeSlack

TASK_FREE_SLACK

The amount of time that a task can be delayed before it will delay a successor task.

Leveling

Assignment

Assignment-

ASSN_LEVELING_

The amount of

Delay

LevelingDelay

DELAY

delay caused

Resource Task

TaskLevelingDelay

TASK_LEVELING_ DELAY

by resource leveling.

Field

T3 T3

Available Categories

OLE DB Provider

Microsoft

Project Database Description

Negative Task Slack

The amount of time that a task is behind schedule. This time must be recovered to prevent delays for successor tasks.

Optimistic

Task

TaskDuration1

The optimistic

Duration

task duration for PERT Analysis calculations.

Over-

Assignment

The amount

allocation

(Timephased)

of work that

Resource

ResourceTime-

exceeds the

(Timephased)

Overallocation

amount of time

(Timephased)

a resource is available.

Overtime

Assignment

Assignment-

ASSN_OVT_WORK

The amount of

Work

OvertimeWork

work assigned to

Assignment

AssignmentTime-

a resource that is

(Timephased)

OvertimeWork

charged at a

Resource

Resource-OvertimeWork

RES_OVT_WORK

resource's overtime rate.

Resource

ResourceTime-

(Timephased)

OvertimeWork

Task

TaskOvertimeWork

TASK_OVT_WORK

Task

TaskTime-

(Timephased)

OvertimeWork

Pessimistic

Task

TaskDuration3

The pessimistic

Duration task duration for PERT Analysis calculation.

Duration task duration for PERT Analysis calculation.

Available

Microsoft

Field

Categories

OLE DB Provider

Project Database

Description

Regular

Assignment

Assignment-

ASSN_REG_WORK

The amount of

Work

RegularWork

work assigned to

Assignment

AssignmentTime-

a resource that is

(Timephased)

RegularWork

charged at a

Resource

ResourceRegularWork

RES_REG_WORK

resource's standard rate.

Resource

ResourceTime-

(Timephased)

RegularWork

Task

TaskRegularWork

TASK_REG_WORK

Task

TaskTimeRegularWork

(Timephased)

Remaining

Resource

ResourceTime-

The amount

Availability

(Timephased)

Remaining-Availability

of available resource time not currently allocated to any task in a given time period.

Remaining

Task

TaskRemaining-

TASK_REM_DUR

The amount of

Duration

Duration

time required to complete a task.

Remaining

Assignment

AssignmentRemaining-

ASSN_REM_OVT_

The amount of

Overtime

OvertimeWork

WORK

scheduled

Work

Resource

ResourceRemaining-

RES_REM_OVT_

overtime work

OvertimeWork

WORK

remaining on

Task

TaskRemaining-OvertimeWork

TASK_REM_OVT_ WORK

unfinished tasks.

Remaining

Assignment

Assignment-

ASSN_REM_WORK

The amount of

Work

RemainingWork

work remaining

Resource

ResourceRemaining-Work

RES_REM_WORK

on a task.

Task

TaskRemainingWork

TASK_REM_WORK

Available Categories

OLE DB Provider

Microsoft Project Database

Description

Start Slack Task

TaskStartSlack

The amount of time that a task can be delayed without affecting a successor task's start date or a project's finish date. Calculated by measuring the difference between a task's early start and late start dates.

Start

Assignment

AssignmentStart-

ASSN

.START

_VAR

The difference

Variance

Task

Variance

between the

TaskStartVariance

TASK_

START.

VAR

baseline start date and the current scheduled start date.

Total Slack Task

TaskTotalSlack

TASK_TOTAL_SLAC K

Total Slack Task

TaskTotalSlack

T3 T3

TASK_TOTAL_SLAC K

The amount of time that a task can be delayed without affecting the project's finish date.

Work

Assignment

Assignment

(Timephased)

Resource

Resource (Timephased) Task Task

(Timephased)

AssignmentWork AssignmentTimeWork

Resource

ResourceTimeWork

TaskWork TaskTimeWork

ASSN WORK

RES WORK

TASK WORK

The total scheduled amount of work assigned to a resource.

Available

Microsoft

Field

Categories

OLE DB Provider

Project Database

Description

Work

Resource

ResourceTime-

The maximum

Availability

(Timephased)

WorkAvailability

amount of time that a resource is available to be assigned work during a specified time period.

Work

Assignment

AssignmentWork-

The difference

Variance

Variance

between base-

Resource

ResourceWork-Variance

line work and scheduled work.

Task

TaskWorkVariance

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