Date Fields

Table B-2 lists all date fields available in Microsoft Project.

For information about working with the project schedule and associated date fields, see Chapter 9, "Checking and Adjusting the Project Plan," and "Monitoring and Adjusting the Schedule" on page 327.

Table B-2. Date Fields

Field

Available Categories

OLE DB

Provider

Microsoft Project Database

Description

Actual Finish

Assignment

Resource

Task

AssignmentActualFinish

ResourceActualFinish

TaskActualFinish

ASSN_ACT_FINISH RES_ACT_FINISH TASK ACT FINISH

The actual date and time when a task is completed.

Actual Start

Assignment

Resource

Task

AssignmentActualStart

ResourceActualStart

TaskActualStart

ASSN_ACT_START

RES_ACT_START

TASK_ACT_START

The actual date and time when a task began.

Available From

Resource

ResourceAvailableFrom

RES AVAIL FROM

The start date that a resource is available to start work on a project.

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Available To

Resource

ResourceAvailableTo

RES_AVAIL_TO

The end date that a resource is no longer available to work on a project.

Baseline

Assignment

AssignmentBaselineFinish

ASSN_BASE_FINISH

The originally

Finish

Resource

ResourceBaselineFinish

RES BASE FINISH

planned comple-

Task

TaskBaselineFinish

TASK_BASE_FINISH

tion date for assignments or tasks.

Baseline

Assignment

AssignmentBaselineStart

ASSN_BASE_START

The planned begin

Start

Resource

ResourceBaselineStart

RES_BASE_START

ning date for an

Task

TaskBaselineStart

TASK_BASE_START

assignment or task.

Baseline

Assignment

AssignmentBaselinel-

The baseline

1-10Finish

Finish-10

finish values for

Resource

ResourceBaselinel-Finish-l0

Baseline1Finish through

Task

TaskBaselinelFinish-l0

Baseline10Finish.

Baseline

Assignment

AssignmentBaselinel-

The baseline start

1-10Start

Start-l0

values for

Resource

ResourceBaselinel-Start-l0

BaselinelStart through

Task

TaskBaselinelStart-l0

Baseline10Start.

Complete

Task

TaskCompleteThrough

The most recent

Through

date that actuals have been reported on a task.

Constraint

Task

TaskConstraintDate

TASK_CONSTRAINT_

The date associ-

Date

DATE

ated with a task constraint.

Created

Task

TaskCreated

TASK_CREATION_ DATE

The date and time that a task was first added to this project.

Date1-10

Assignment

AssignmentDatel-10

The values for the

Resource

ResourceDatel-10

custom Date1

Task

TaskDatel-10

through Date10 fields.

Microsoft Office Project 2003 Inside Out

Table B-2.

Date Fields

Available

OLE DB Microsoft

Field

Categories

Provider Project Database

Description

Deadline

Task

TaskDeadline TASK_DEADLINE

The date by which

a task must be

completed.

Early Finish

Task

TaskEarlyFinish TASK_EARLY_FINISH

The earliest date

that a task can

finish, based on

predecessor and

successor tasks,

constraints, and

delays.

Early Start

Task

TaskEarlyStart TASK_EARLY_START

The earliest date

when a task can

start, based on

predecessor and

successor tasks,

constraints, and

delays.

Expected

Task

TaskFinish2

The expected finish

Finish

date of a task for

PERT Analysis

calculations.

Expected

Task

TaskStart2

The expected start

Start

date of a task for

PERT Analysis

calculations.

Finish

Assignment

AssignmentFinish ASSN_FINISH

The date that a task

Resource

ResourceFinish RES_FINISH

is scheduled to be

Task

TaskFinish TASK_FINISH

completed.

Finish1-10

Assignment

AssignmentBaseline1-

The values for the

Finish-10

custom Finish1

Resource

ResourceBaseline1-

through Finish10

Finish-10

fields.

Task

TaskBaseline1Finish-10

Late Finish

Task

TaskLateFinish TASK_LATE_FINISH

The latest date that

a task can finish,

based on predeces-

sor and successor

tasks, constraints,

and delays.

Available OLE DB Microsoft

Field Categories Provider Project Database Description

Late Start Task TaskLateStart TASK_LATE_START The latest date when a task can start, based on predecessor and successor tasks, constraints, and delays.

Optimistic

Task

TaskFinish1

The optimistic finish

Finish

date of a task for PERT Analysis calculations.

Optimistic

Task

TaskStart1

The optimistic start

Start

date of a task for PERT Analysis calculations.

Pessimistic

Task

TaskFinish3

The pessimistic

Finish

finish date of a task for PERT Analysis calculations.

Pessimistic

Task

TaskStart3

The pessimistic

Start

start date of a task for PERT Analysis calculations.

Preleveled

Task

TaskPreleveledFinish

TASK_PRELEVELED_

The finish date for a

Finish

FINISH

task before resource leveling.

Preleveled

Task

TaskPreleveledStart

TASK_PRELEVELED_

The start date for a

Start

START

task before resource leveling.

Resume

Task

TaskResume

TASK_RESUME_ DATE

The date when the remaining portion of a split task is scheduled to resume.

Start

Assignment

AssignmentStart

ASSN_START

The date when a task

Resource

ResourceStart

RES_START

or assignment is

Task

TaskStart

TASK_START

scheduled to begin.

Start1-10

Assignment

AssignmentStart1-10

The values for the cus-

Resource

ResourceStart1-10

tom Start1 through

Task

TaskStart1-10

Start10 fields.

Field

Available Categories

OLE DB

Provider

Microsoft Project Database

Description

Stop

Task

TaskStop

TASK STOP

The date when a split task is to temporarily stop. This is associated with a subsequent Resume date field.

Summary Task Progress

TaskSummaryProgress

The progress made on a summary task.

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