YesNo Fields

Table B-10 lists all Yes/No fields available in Microsoft Project. Yes/No fields, which are set either by the user or by Microsoft Project, indicate the state of a task, resource, or assignment as being on or off or being true or false. Yes/No fields are also referred to as Boolean fields.

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Resource

Task

Indicates whether this is an assignment.

Can Level

Resource

ResourceCanLevel

RES_CAN_LEVEL

The setting that specifies whether leveling can be performed on the resource.

Confirmed

Assignment

Assignment-

ASSN_IS_

The setting that specifies

Confirmed

CONFIRMED

whether a resource has

Resource Task

ResourceConfirmed TaskConfirmed

accepted an assignment using an electronic team collaboration method.

Critical

Task

TaskCritical

TASK_IS_CRITICAL

The setting that specifies whether the task is on the critical path.

Effort Driven

Task

TaskEffortDriven

TASK_IS_EFFORT_D RIVEN

The setting that specifies whether the task is effort-driven.

Estimated

Task

TaskEstimated

TASK_DUR_IS_ EST

The setting that specifies whether a task's duration is estimated.

External Task

Task

TaskExternalTask

TASK_IS_ EXTERNAL

The setting that specifies whether the task is an external task.

Flag1-20

Assignment

Assignment-Flag1-20

The setting that specifies whether the custom fields

Resource Task

ResourceFlag1-20 TaskFlag1-20

Flag1 through Flag20 are on or off.

Group By

Resource Task

TaskSummary

TASK_IS_

The setting that specifies

Summary

SUMMARY

whether a task is a summary task.

Hide Bar

Task

TaskHideBar

TASK_BAR_IS_ HIDDEN

The setting that specifies whether Gantt and Calendar bars are hidden for a task.

Ignore

Task

TaskIgnore-

TASK_IGNORES_

The setting that specifies

Resource

ResourceCalendar

RES_CAL

whether a resource's calen-

Calendar

dar is taken into account in conjunction with a task calendar.

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Inactive

Resource

The setting that specifies whether an enterprise resource has been made inactive.

Level

Task

TaskLevel-

TASK_LEVELING_

The setting that specifies

Assignments

Assignments

ADJUSTS_ASSN

whether assignments can be split or delayed to resolve resource overallocations.

Leveling Can

Task

TaskLevelingCan-

TASK_LEVELING_

The setting that specifies

Split

Split

CAN_SPLIT

whether resource leveling can cause a task split on the remaining work on a task.

Linked Fields

Assignment

AssignmentLinked-

ASSN_HAS_

The setting that specifies

Fields

LINKED_FIELDS

whether an assignment,

Resource

ResourceLinked-

RES HAS

resource, or task has OLE

Fields

LINKED_FIELDS

links to it from within the

Task

TaskLinkedFields

TASK_HAS_ LINKED_FIELDS

project, another project, or an external application.

Marked

Task

TaskMarked

TASK_MARKED

The setting that specifies whether a task is identified, or flagged, as requiring further attention.

Milestone

Task

TaskMilestone

TASK_MILESTONE

The setting that specifies whether a task is a milestone.

Overallocated

Assignment

Assignment-

ASSN_IS_

The setting that specifies

Overallocated

OVERALLOCATED

whether resources have

Resource

Resource-

RES_IS_

been assigned work

Overallocated

OVERALLOCATED

beyond their work capacity

Task

TaskOverallocated

TASK_IS_ OVERALLOCATED

or availability.

Recurring

Task

TaskRecurring

TASK_IS_ RECURRING

The setting that specifies whether a task is recurring.

Available

OLE DB

Microsoft

Field

Categories

Provider

Project Database

Description

Response

Assignment

Assignment-

ASSN_RESPONSE_

The setting that specifies

Pending

ResponsePending

PENDING

whether a response to an

Resource Task

Resource-ResponsePending

TaskResponse-Pending

update has been received through an electronic team collaboration method.

Rollup

Task

TaskRollup

TASK_IS_ ROLLED_UP

The setting that specifies whether information on the subtask Gantt bar is rolled up to the summary task bar.

Subproject

Task

TaskSubproject-

The setting that specifies

Read Only

ReadOnly

whether a subproject of a task is read-only.

Summary

Task

TaskSummary

TASK_IS_ SUMMARY

The setting that specifies whether the task is a summary task.

TeamStatus

Assignment

AssignmentTeam-

ASSN_TEAM_

The setting that specifies

Pending

StatusPending

STATUS_PENDING

whether a response to a

Resource

ResourceTeam-

progress request has been

TaskTeam-StatusPending

received through an electronic team collaboration method.

Text Above

Task

The setting that specifies whether text appears above or below the summary Gantt bar.

Update

Assignment

AssignmentUpdate-

ASSN_UPDATE_

The setting that specifies

Needed

Needed

NEEDED

whether an update mes-

Resource

ResourceUpdate-Needed

sage should be sent to resources to notify them of

Task

TaskUpdateNeeded

updates to their assigned tasks through an elec-

tronic team collaboration method.

tronic team collaboration method.

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