Valutor Project Management

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

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.

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

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.

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.