Appendix B

Field Reference

This appendix lists all the fields available in Microsoft Project, broken down by type of data:

Currency
Date
Duration
Enumerated
Indicator
Integer
Outline Code
Percentage and Number
Text
Yes/No

In addition, the following special categories of fields are grouped together for your reference toward the end of this appendix:

Custom fields
Earned Value
PERT Analysis

Each row in the following tables contains the name of a field in Microsoft Project and the category in Microsoft Project to which the field belongs, for example, tasks, resources, and so on. Each row contains a description of the field, and the name of the field when it's exposed using the Microsoft Project 10.0 OLE DB Provider. Each row also includes the name of the field when you open a project as a database, for example, when you save a project as a Microsoft Access Database and open it in Microsoft Access.

Fields are listed in this appendix if the field in the database contains the same data entered or added through Microsoft Project. Some fields listed in this appendix that can be accessed using the Microsoft Project 10.0 OLE DB Provider do not have a corresponding field in the Microsoft Project database. These "missing" fields are actually the results of calculations based on values stored in other fields. For example, the Cost Variance field contains the difference between a baseline cost and total scheduled cost. The Cost Variance field can be assigned in Microsoft Project and exposed using the OLE DB Provider, but it doesn't have its own field in the Microsoft Project database because Cost Variance is the result of a calculation (Cost - Baseline Cost).

Most fields in Microsoft Project can be found in the following OLE DB Provider or Microsoft Project database tables:

Assignment. Fields are stored in the Assignments table in OLE DB and in the MSP_ASSIGNMENTS table in the Microsoft Project Database.

Assignment (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month assignment-timephased tables in OLE DB.

Resource. Fields are stored in the Resources table in OLE DB and in the MSP_RESOURCES table in the Microsoft Project Database.

Resource (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month resource-timephased tables in OLE DB.

Task. Fields are stored in the Tasks table in OLE DB and in the MSP_TASKS table in the Microsoft Project Database.

Task (Timephased). Fields are stored in the Minute, Hour, Day, Week, and Month task-timephased tables in OLE DB.

Custom. Fields are stored in the tables they are associated with in OLE DB, for example, custom assignment cost fields are in the Assignments table.

In the MSP_PROJECTS database, however, custom fields are stored in the following tables: MSP_ASSIGNMENT_BASELINES, MSP_DATE_FIELDS, MSP_DURATION_FIELDS, MSP_FLAG_FIELDS, MSP_NUMBER_FIELDS, MSP_OUTLINE_CODES, MSP_RESOURCE_BASELINES, MSP_TASK_BASELINES, and MSP_TEXT_FIELDS. Data stored in these tables isn't as easy to use as the custom fields in the OLE DB Provider because custom fields in the Microsoft Project database are defined by multiple fields, and the tables can contain data for assignments, resources, and tasks.

For more information about these tables, the fields in these tables, and how to understand the data in these tables and how it links to assignments, resources, or tasks, see Projdb.htm included on the Microsoft Project 2002 installation CD.

Each of the five timephased tables for assignments, resources, and tasks are named "nTimephasedByX" where "n" is assignments, resources, or tasks, and "X" is Minute, Hour, Day, Week, or Month.

For more information about working with fields and adding them to tables, see Using Tables and Using Fields. For more information about custom fields, see Customizing Fields and Working with Outline Codes.

For detailed information about each individual field, including calculations, best uses, and examples, refer to the Fields Reference section of Microsoft Project Help. To do this, open Help. Click Microsoft Project Reference. Click the Fields Reference link, and then click See A List Of Field Types.

Field Types

The fields listed in the following tables (Currency, Date, Duration, Enumerated, Indicator, Integer, Outline Code, Percentage and Number, Text, and Yes/No) are grouped by data type.

Currency Fields

Table B-1 lists all currency and currency rate fields available in Microsoft Project.

For more information about working with costs, see Chapter 8, "Planning Resource and Task Costs," and Monitoring and Adjusting Costs. For more information about ana-lyzing project information with earned value, see Chapter 13, "Analyzing Project Information."

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."

Duration Fields

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

For more information about durations, see Setting Task Durations.

Enumerated Fields

Table B-4 lists all fields that store enumerated values in Microsoft Project.

Indicator Fields

Table B-5 contains information about indicator fields, which are used to provide additional information about assignments, tasks, and resources, using a simple visual icon.

Integer Fields

Table B-6 lists all integer fields available in Microsoft Project.

Outline Code Fields

Table B-7 lists all outline code fields available in Microsoft Project.

Percentage and Number Fields

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

Text Fields

Table B-9 lists all text fields available in Microsoft Project.

Yes/No Fields

Table B-10 lists all yes/no fields available in Microsoft Project. Yes/no fields are set either by the user or by Microsoft Project, and they 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.

Table B-1. Currency Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Actual Cost	Assignment	AssignmentActualCost	ASSN_ACT_COST	The actual costs associated with resource work or fixed costs for tasks.
	Assignment (Timephased)	AssignmentTimeActualCost	ASSN_ACT_COST
	Resource	ResourceActualCost	RES_ACT_COST
	Resource (Timephased)	ResourceTimeActualCost	RES_ACT_COST
	Task	TaskActualCost	TASK_ACT_COST
	Task (Timephased)	TaskTimeActualCost	TASK_ACT_COST
Actual Fixed Cost	Task (Timephased)	TaskTimeActualFixedCost		The actual fixed cost expenses charged over time.
Actual Overtime Cost	Assignment	AssignmentActualOvertimeCost	ASSN_ACT_OVT_COST	The actual over-time costs.
	Resource	ResourceActualOvertimeCost	RES_ACT_OVT_COST
	Task	TaskActualOvertimeCost	TASK_ACT_OVT_COST
ACWP	Assignment	AssignmentACWP	ASSN_ACWP	The earned value actual cost of work performed (ACWP).
	Assignment (Timephased)	AssignmentTimeACWP	ASSN_ACWP
	Resource	ResourceACWP	RES_ACWP
	Resource (Timephased)	ResourceTimeACWP	RES_ACWP
	Task	TaskACWP	TASK_ACWP
	Task (Timephased)	TaskTimeACWP	TASK_ACWP
BAC	Assignment	AssignmentBaselineCost	ASSN_BASE_COST	The earned value Budget At Completion (BAC). Same as the Baseline Cost field.
	Assignment (Timephased)	AssignmentTimeBaselineCost	ASSN_BASE_COST
	Resource	ResourceBaselineCost	RES_BASE_COST
	Resource (Timephased)	ResourceTimeBaselineCost	RES_BASE_COST
	Task	TaskBaselineCost	TASK_BASE_COST
	Task (Timephased)	TaskTimeBaselineCost	TASK_BASE_COST
Baseline Cost	Assignment	AssignmentBaselineCost	ASSN_BASE_COST	The total planned cost for work performed, plus fixed costs.
	Assignment (Timephased)	AssignmentTimeBaselineCost	ASSN_BASE_COST
	Resource	ResourceBaselineCost	RES_BASE_COST
	Resource (Timephased)	ResourceTimeBaselineCost	RES_BASE_COST
	Task	TaskBaselineCost	TASK_BASE_COST
	Task (Timephased)	TaskTimeBaselineCost	TASK_BASE_COST
Baseline1-10Cost	Assignment	AssignmentBaseline1Cost10		The baseline costs for Baseline 1 through Baseline 10.
	Assignment (Timephased)	AssignmentTimeBaseline1Cost-10
	Resource	ResourceBaseline1Cost10
	Resource (Timephased)	ResourceTimeBaseline1Cost-10
	Task	TaskBaseline1Cost-10
	Task (Timephased)	TaskTimeBaseline1Cost-10
BCWP	Assignment	AssignmentBCWP	ASSN_BCWP	The earned value budgeted costs of work performed (BCWP) costs.
	Assignment (Timephased)	AssignmentTimeBCWP	ASSN_BCWP
	Resource	ResourceBCWP	RES_BCWP
	Resource (Timephased)	ResourceTimeBCWP	RES_BCWP
	Task	TaskBCWP	TASK_BCWP
	Task (Timephased)	TaskTimeBCWP	TASK_BCWP
BCWS	Assignment	AssignmentBCWS	ASSN_BCWS	The earned value budgeted cost of work scheduled (BCWS) costs.
	Assignment (Timephased)	AssignmentTimeBCWS	ASSN_BCWS
	Resource	ResourceBCWS	RES_BCWS
	Resource (Timephased)	ResourceTimeBCWS	RES_BCWS
	Task	TaskBCWS	TASK_BCWS
	Task (Timephased)	TaskTimeBCWS	TASK_BCWS
Cost	Assignment	AssignmentCost	ASSN_COST	The total scheduled cost for an assignment, including expected costs and those already incurred.
	Assignment (Timephased)	AssignmentTimeCost	ASSN_COST
	Resource	ResourceCost	RES_COST
	Resource (Timephased)	ResourceTimeCost	RES_COST
	Task	TaskCost	TASK_COST
	Task (Timephased)	TaskTimeCost	TASK_COST
Cost Per Use	Resource	ResourceCostPerUse	RES_COST_PER_USE	The cost for each unit of work performed by a resource.
Cost Variance	Assignment	AssignmentCostVariance		The difference between the baseline cost and total scheduled cost.
	Resource	ResourceCostVariance
	Task	TaskCostVariance
Cost1-10	Assignment	AssignmentCost1-10		The values for the custom Cost1 through Cost10 fields.
	Resource	ResourceCost1-10
	Task	TaskCost1-10
Cumulative Cost	Assignment (Timephased)	AssignmentTimeCumulativeCost		The cumulative cost for all work performed on all assigned tasks, as distributed over time.
	Resource (Timephased)	ResourceTimeCumulativeCost
	Task (Timephased)	TaskTimeCumulativeCost
CV	Assignment	AssignmentCV		The earned value cost variance (CV), which is the difference between the budgeted (baseline) cost and the actual cost of work performed.
	Assignment (Timephased)	AssignmentTimeCV
	Resource	ResourceCV
	Resource (Timephased)	ResourceTimeCV
	Task	TaskCV
	Task (Timephased)	TaskTimeCV
EAC	Task	TaskEAC	TASK_EAC	The earned value estimate at completion (EAC), which is the expected total cost of a task.
Fixed Cost	Task	TaskFixedCost	TASK_FIXED_COST	The expense for a non-resource task.
Fixed Cost	Task (Timephased)	TaskTimeFixedCost	TASK_FIXED_COST	The expense for a non-resource task.
Overtime Cost	Assignment	AssignmentOvertimeCost	ASSN_OVT_COST	The total scheduled overtime cost for an assignment, resource, or task.
	Resource	ResourceOvertimeCost	RES_OVT_COST
	Task	TaskOvertimeCost	TASK_OVT_COST
Remaining Cost	Assignment	AssignmentRemainingCost	ASSN_REM_COST	The costs associated with completing remaining scheduled work.
	Resource	ResourceRemainingCost	RES_REM_COST
	Task	TaskRemainingCost	TASK_REM_COST
Standard Rate	Resource	ResourceStandardRate	RES_STD_RATE	The standard rate for non-overtime work performed by a resource.
SV	Assignment	AssignmentSV		The earned value schedule variance (SV), which is the difference between BCWP and BCWS measured in cost terms.
	Assignment (Timephased)	AssignmentTimeSV
	Resource	ResourceSV
	Resource (Timephased)	ResourceTimeSV
	Task	TaskSV
	Task (Timephased)	TaskTimeSV
VAC	Assignment	AssignmentVAC		The earned value variance at completion (VAC), which is the difference between BAC and EAC, measured in cost terms.
	Resource	ResourceVAC
	Task	TaskVAC	TASK_VAC

Table B-2. Date Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Actual Finish	Assignment	AssignmentActualFinish	ASSN_ACT_FINISH	The actual date and time when a task is completed.
	Resource	ResourceActualFinish	RES_ACT_FINISH
	Task	TaskActualFinish	TASK_ACT_FINISH
Actual Start	Assignment	AssignmentActualStart	ASSN_ACT_START	The actual date and time when a task began.
	Resource	ResourceActualStart	RES_ACT_START
	Task	TaskActualStart	TASK_ACT_START
Available From	Resource	ResourceAvailableFrom	RES_AVAIL_FROM	The start date that a resource is available to start work on a project.
Available To	Resource	ResourceAvailableTo	RES_AVAIL_TO	The end date that a resource is no longer available to work on a project.
Baseline Finish	Assignment	AssignmentBaselineFinish	ASSN_BASE_FINISH	The originally planned completion date for assignments or tasks.
	Resource	ResourceBaselineFinish	RES_BASE_FINISH
	Task	TaskBaselineFinish	TASK_BASE_FINISH
Baseline Start	Assignment	AssignmentBaselineStart	ASSN_BASE_START	The planned beginning date for an assignment or task.
	Resource	ResourceBaselineStart	RES_BASE_START
	Task	TaskBaselineStart	TASK_BASE_START
Baseline 1-10Finish	Assignment	AssignmentBaseline1Finish-10		The baseline finish values for Baseline1Finish through Baseline10Finish.
	Resource	ResourceBaseline1Finish-10
	Task	TaskBaseline1Finish-10
Baseline 1-10Start	Assignment	AssignmentBaseline1Start-10		The baseline start values for Baseline1Start through Baseline10Start.
	Resource	ResourceBaseline1Start-10
	Task	TaskBaseline1Start-10
Complete Through	Task	TaskCompleteThrough		The most recent date that actuals have been reported on a task.
Constraint Date	Task	TaskConstraintDate	TASK_CONSTRAINT_DATE	The date associated 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	AssignmentDate1-10		The values for the custom Date1 through Date10 fields.
	Resource	ResourceDate1-10
	Task	TaskDate1-10
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 that a task can start, based on predecessor and successor tasks, constraints, and delays.
Expected Finish	Task	TaskFinish2		The expected finish date of a task for PERT Analysis calculations.
Expected Start	Task	TaskStart2		The expected start date of a task for PERT Analysis calculations.
Finish	Assignment	AssignmentFinish	ASSN_FINISH	The date that a task is scheduled to be completed.
	Resource	ResourceFinish	RES_FINISH
	Task	TaskFinish	TASK_FINISH
Finish1-10	Assignment	AssignmentBaseline1Finish-10		The values for the custom Finish1 through Finish10 fields.
	Resource	ResourceBaseline1Finish-10
	Task	TaskBaseline1Finish-10
Late Finish	Task	TaskLateFinish	TASK_LATE_FINISH	The latest date that a task can finish, based on predecessor and successor tasks, constraints, and delays.
Late Start	Task	TaskLateStart	TASK_LATE_START	The latest date that a task can start, based on predecessor and successor tasks, constraints, and delays.
Optimistic Finish	Task	TaskFinish1		The optimistic finish date of a task for PERT Analysis calculations.
Optimistic Start	Task	TaskStart1		The optimistic start date of a task for PERT Analysis calculations.
Pessimistic Finish	Task	TaskFinish3		The pessimistic finish date of a task for PERT Analysis calculations.
Pessimistic Start	Task	TaskStart3		The pessimistic start date of a task for PERT Analysis calculations.
Preleveled Finish	Task	TaskPreleveledFinish	TASK_PRELEVELED_FINISH	The finish date for a task before resource leveling.
Preleveled Start	Task	TaskPreleveledStart	TASK_PRELEVELED_START	The start date for a task before resource leveling.
Resume	Task	TaskResume	TASK_RESUME_DATE	The date that the remaining portion of a split task is scheduled to resume.
Start	Assignment	AssignmentStart	ASSN_START	The date that a task or assignment is scheduled to begin.
	Resource	ResourceStart	RES_START
	Task	TaskStart	TASK_START
Start1-10	Assignment	AssignmentStart1-10		The values for the custom Start1 through Start10 fields.
	Resource	ResourceStart1-10
	Task	TaskStart1-10
Stop	Task	TaskStop	TASK_STOP	The date a split task is to temporarily stop. This is associated with a subsequent Resume date field.
Summary Progress	Task	TaskSummaryProgress		The progress made on a summary task.

Table B-3. Duration Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Actual Duration	Task	TaskActualDuration	TASK_ACT_DUR	The amount of time that actual work has been performed on a task, up to the current date.
Actual Overtime Work	Assignment	AssignmentOvertimeWork	ASSN_OVT_WORK	The amount of overtime work already completed by a resource on a task.
	Assignment (Timephased)	AssignmentTimeOvertimeWork	ASSN_OVT_WORK
	Resource	ResourceOvertimeWork	RES_OVT_WORK
	Resource (Timephased)	ResourceTimeOvertimeWork	RES_OVT_WORK
	Task	TaskOvertimeWork	TASK_OVT_WORK
	Task (Timephased)	TaskTimeOvertimeWork	TASK_OVT_WORK
Actual Work	Assignment	AssignmentActualWork	ASSN_ACT_WORK	The amount of work already completed by a resource on a task.
	Assignment (Timephased)	AssignmentTimeActualWork	ASSN_ACT_WORK
	Resource	ResourceActualWork	RES_ACT_WORK
	Resource (Timephased)	ResourceTimeActualWork	RES_ACT_WORK
	Task	TaskActualWork	TASK_ACT_WORK
	Task (Timephased)	TaskTimeActualWork	TASK_ACT_WORK
Assignment Delay	Assignment	AssignmentDelay	ASSN_DELAY	The amount of time between when a resource is assigned work and when a resource begins work.
Baseline Duration	Task	TaskBaselineDuration	TASK_BASE_DUR	The amount of time originally planned to complete a task.
Baseline Work	Assignment	AssignmentBaselineWork	ASSN_BASE_WORK	The amount of work resource hours originally planned for a task.
	Assignment (Timephased)	AssignmentTimeBaselineWork	ASSN_BASE_WORK
	Resource	ResourceBaselineWork	RES_BASE_WORK
	Resource (Timephased)	ResourceTimeBaselineWork	RES_BASE_WORK
	Task	TaskBaselineWork	TASK_BASE_WORK
	Task (Timephased)	TaskTimeBaselineWork	TASK_BASE_WORK
Baseline1-10 Duration	Task	TaskBaseline1Duration-10		The baseline duration values for Baseline 1 through Baseline 10.
Baseline1-10 Work	Assignment	AssignmentBaseline1Work-10		The baseline work values for Baseline 1 through Baseline 10.
	Assignment (Timephased)	AssignmentTime Baseline1Work-10
	Resource	ResourceBaseline1Work-10
	Resource (Timephased)	ResourceTimeBaseline1Work-10
	Task	TaskBaseline1Work-10
	Task (Timephased)	TaskTimeBaseline1Work-10
Cumulative Work	Assignment (Timephased)	AssignmentTimeCumulativeWork		The amount of work over a period of time.
	Resource (Timephased)	ResourceTimeCumulativeWork
	Task (Timephased)	TaskTimeCumulativeWork
Duration	Task	TaskDuration	TASK_DUR	The amount of working time between a task's start and finish dates.
Duration Variance	Task	TaskDurationVariance	TASK_DUR_VAR	The difference between a task's baseline duration and total scheduled duration.
Duration1-10	Assignment	AssignmentDuration1-10		The values for the custom Duration1 through Duration10 fields.
	Resource	ResourceDuration1-10
	Task	TaskDuration1-10
Finish Slack	Task	TaskFinishSlack		The difference between a task's early start and late finish dates.
Finish Variance	Assignment	AssignmentFinishVariance	ASSN_FINISH_VAR	The difference between the baseline start date of a task or assignment and its current finish date.
Finish Variance	Task	TaskFinishVariance	TASK_FINISH_VAR
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 Delay	Assignment	AssignmentLevelingDelay	ASSN_LEVELING_DELAY	The amount of delay caused by resource leveling.
	Resource	AssignmentLevelingDelay	ASSN_LEVELING_DELAY
	Task	TaskLevelingDelay	TASK_LEVELING_DELAY
Negative Slack	Task			The amount of of time that a task is behind schedule. This time must be recovered to prevent delays for successor tasks.
Optimistic Duration	Task	TaskDuration1		The optimistic task duration for PERT Analysis calculations.
Overallocation	Assignment (Timephased)			The amount of work that exceeds the amount of time a resource is available.
	Resource (Timephased)	ResourceTimeOverallocation
	Task (Timephased)
Overtime Work	Assignment	AssignmentOvertimeWork	ASSN_OVT_WORK	The amount of work assigned to a resource that is charged at a resource's overtime rate.
	Assignment (Timephased)	AssignmentTimeOvertimeWork	ASSN_OVT_WORK
	Resource	ResourceOvertimeWork	RES_OVT_WORK
	Resource (Timephased)	ResourceTimeOvertimeWork	RES_OVT_WORK
	Task	TaskOvertimeWork	TASK_OVT_WORK
	Task (Timephased)	TaskTimeOvertimeWork	TASK_OVT_WORK
Pessimistic Duration	Task	TaskDuration3		The pessimistic task duration for PERT Analysis calculation.
Regular Work	Assignment	AssignmentRegularWork	ASSN_REG_WORK	The amount of work assigned to a resource that is charged at a resource's standard rate.
	Assignment (Timephased)	AssignmentTimeRegularWork	ASSN_REG_WORK
	Resource	ResourceRegularWork	RES_REG_WORK
	Resource (Timephased)	ResourceTimeRegularWork	RES_REG_WORK
	Task	TaskRegularWork	TASK_REG_WORK
	Task (Timephased)	TaskTimeRegularWork	TASK_REG_WORK
Remaining Availability	Resource (Timephased)	ResourceTimeRemainingAvailability		The amount of available resource time not currently allocated to any task in a given time period.
Remaining Duration	Task	TaskRemainingDuration	TASK_REM_DUR	The amount of time required to complete a task.
Remaining Overtime Work	Assignment	AssignmentRemainingOvertimeWork	ASSN_REM_OVT_WORK	The amount of scheduled overtime work remaining on unfinished tasks.
	Resource	ResourceRemainingOvertimeWork	RES_REM_OVT_WORK
	Task	TaskRemainingOvertimeWork	TASK_REM_OVT_WORK
Remaining Work	Assignment	AssignmentRemainingWork	ASSN_REM_WORK	The amount of work remaining on a task.
	Resource	ResourceRemainingWork	RES_REM_WORK
	Task	TaskRemainingWork	TASK_REM_WORK
Start Slack	Task	TaskStartSlack		The amount of 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 Variance	Assignment	AssignmentStartVariance	ASSN_START_VAR	The difference between the baseline start date and the current scheduled start date.
Start Variance	Task	TaskStartVariance	TASK_START_VAR
Total Slack	Task	TaskTotalSlack	TASK_TOTAL_SLACK	The amount of time that a task can be delayed without affecting the project's finish date.
Work	Assignment	AssignmentWork	ASSN_WORK	The total scheduled amount of work assigned to a resource.
	Assignment (Timephased)	AssignmentTimeWork	ASSN_WORK
	Resource	Resource	RES_WORK
	Resource (Timephased)	ResourceTimeWork	RES_WORK
	Task	TaskWork	TASK_WORK
	Task (Timephased)	TaskTimeWork	TASK_WORK
Work Availability	Resource (Timephased)	ResourceTimeWorkAvailability		The maximum amount of time that a resource is available to be assigned work during a specified time period.
Work Variance	Assignment	AssignmentWorkVariance		The difference between baseline work and scheduled work.
	Resource	ResourceWorkVariance
	Task	TaskWorkVariance

Table B-4. Enumerated Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Accrue At	Resource	ResourceAccrueAt	RES_ACCRUE_AT	The way in which resource costs are accrued: at the start, end, or prorated across the span of the project.
Base Calendar	Resource	ResourceBaseCalendar	RES_CAL_UID	The base calendar to be used with a particular resource.
Workgroup	Resource	ResourceWorkgroup	RES_WORKGROUP_MESSAGING	The collaboration method used to communicate with resources on a project team.
Constraint Type	Task	TaskConstraintType	TASK_CONSTRAINT_TYPE	The type of constraint applied to a task.
Cost Rate Table	Assignment	AssignmentCostRateTable	ASSN_COST_RATE_TABLE	The cost rate table used for a particular assignment.
Earned Value Method	Task		TASK_EVMETHOD	The method (Percent Complete or Physical Percent Complete) used to calculate earned value budgeted cost of work performed (BCWP).
Fixed Cost Accrual	Task	TaskFixedCostAccrual	TASK_FIXED_COST_ACCRUAL	The way in which fixed costs are accrued: at the start, the end, or prorated across the task duration.
Priority	Task	TaskPriority	TASK_PRIORITY	The relative importanceof the taskscheduling; usedto determinepriority for taskleveling.
Resource Type	Assignment	AssignmentResourceType	ASSN_RES_TYPE	The type of resource (work or material) assigned.
Status	Task	TaskStatus		The current status of a task: Complete, On Schedule, Late, or Future Task.
Task Calendar	Task	TaskCalendar	TASK_CAL_UID	The base calendar to be used with a particular task.
(Resource) Type	Resource	ResourceType	RES_TYPE	The type of resource, either work or material.
(Task) Type	Task	TaskType	TASK_TYPE	The type of task: fixed work, fixed units, or fixed duration.
Work Contour	Assignment	AssignmentWorkContour	ASSN_WORK_CONTOUR	The way in which work is distributed over the length of an assignment

Table B-5. Indicator Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Indicators	Assignment	Various	Various	Indicators that provide additional information about assignments, tasks, and resources.
	Resource	Various	Various
	Task	Various	Various
StatusTask Indicator				Indicators that provide information about whether a task is complete, on schedule, late,or planned.

Table B-6. Integer Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
ID	Resource	ResourceID	RES_ID	The position of a task or resource in relation to other tasks or resources.
ID	Task	TaskID	TASK_ID
Outline Level	Task	TaskOutlineLevel		The task's location within the project outline.
Predecessors	Task	TaskPredecessors		The Task ID for a predecessor task.
Resource ID	Assignment			The position of the resource within the project, in relation to other resources.
Successors	Task	TaskSuccessors		The Task ID of a successor task.
Task ID	Assignment			The position of the task within the project, in relation to other tasks.
Unique ID	Assignment	AssignmentUniqueID	ASSN_UID	The unique ID of an assignment, resource, or task.
	Resource	ResourceUniqueID	RES_UID
	Task	TaskUniqueID	TASK_UID
Unique ID Predecessors	Task	TaskUniqueIDPredecessors		The unique ID of a predecessor task.
Unique ID Successors	Task	TaskUniqueIDSuccessors		The unique ID of a successor task.
WBS Predecessors	Task	TaskWBSPredecessors		The work break-down structure code of the predecessor tasks.
WBS Successors	Task	TaskWBSSuccessors		The work break-down structure code of the successor tasks.

Table B-7. Custom Outline Codes

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Outline Code 1-10	Resource	ResourceOutlineCode1-10		The values for the custom OutlineCode1 through OutlineCode10 fields.
Outline Code 1-10	Task	TaskOutlineCode1-10

Table B-8. Percentage and Number Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Assignment Units	Assignment	AssignmentUnits	ASSN_UNITS	The number of resource units assigned to a task, expressed as a percentage of a resource's total availability.
CPI	Task	TaskCPI		The earned value cost performance index, which is the ratio of the difference between BCWP and ACWP.
CPI	Task (Timephased)
Cumulative Percent Complete	Task (Timephased)			The progress of a task measured as a percentage of the total work required to finish the task, as distributed over time.
CV Percent	Task	TaskCVP		The earned value cost variance percent (CV %), which is the ratio of CV to BCWP, expressed as a percentage.
CV Percent	Task (Timephased)	TaskCVP
Max Units	Resource	ResourceMaxUnits	RES_MAX_UNITS	The maximum number of units a resource is available to be assigned to tasks in the project.
Number1-20	Assignment	AssignmentNumber1-20		The values for the custom Number1 through Number20 fields.
	Resource	ResourceNumber1-20
	Task	TaskNumber1-20
Objects	Resource	ResourceObjects	RES_NUM_OBJECTS	The number of objects, such as an inserted graphic or a linked file, associated with either a task or resource.
Objects	Task	TaskObjects	TASK_NUM_OBJECTS
Peak	Assignment	AssignmentPeakUnits		The number of units that represents a resource's largest assign- ment (in units), or the number of units required to complete an assignment.
Peak	Resource	ResourcePeakUnits	RES_PEAK
Peak Units	Assignment (Timephased)	AssignmentTimePeakUnits		The number of units that represents a resource's largest assignment (in units), or the number of units required to complete an assignment, shown for a specific time period.
Peak Units	Resource (Timephased)	ResourceTimePeakUnits
Percent Allocation	Assignment (Timephased)	AssignmentTimePercentAllocation		The percentage of a resource's total available units compared to assigned units.
Percent Allocation	Resource (Timephased)	ResourceTimePercentAllocation
Percent Complete	Task	TaskPercentComplete	TASK_PCT_COMP	The ratio of a task's total duration to completed duration.
Percent Complete	Task (Timephased)		TASK_PCT_COMP	The ratio of a task's total duration to completed duration.
Percent Work Complete	Assignment			The ratio of a task's total work to completed work.
	Resource
	Task	TaskPercentWorkComplete	TASK_PCT_WORK_COMP
Physical Percent Complete	Task		TASK_PHY_PCT_COMP	A percent complete value that can be used as an alternative to regular percent complete for the purposes of calculating BCWP and other earned value fields.
SPI	Task	TaskSPI		The earned value schedule performance index (SPI), which is the ratio of BCWP to BCWS.
SPI	Task (Timephased)	TaskSPI
SV Percent	Task	TaskSVP		The earned value schedule variance (SV %), which is the ratio of SV to BCWS.
SV Percent	Task (Timephased)	TaskSVP
Task Outline Number	Assignment	TaskOutlineNumber	TASK_OUTLINE_NUM	Indicates a task's position in the outline.
TCPI	Task	TaskTCPI		The earned value To Complete Performance Index (TCPI), which is the ratio of remaining work to remaining funds.
Unit Availability	Resource (Timephased)	ResourceTimeUnitAvailability		The number of units a resource is available to be assigned work, expressed as a percentage of a resource's total units.

Table B-9. Text Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Code	Resource	ResourceCode		The information about a resource entered as a code, abbreviation, or number.
Contact	Task	TaskContact		The name of the person responsible for a task.
E-mail Address	Resource	ResourceEmailAddress		The e-mail address for a resource.
Group	Resource	ResourceGroup		The name of the group that a resource is part of.
Hyperlink	Assignment	AssignmentHyperlink		The title of a hyperlink associated with an assignment, resource, or a task.
	Resource	ResourceHyperlink
	Task	TaskHyperlink
Hyperlink Address	Assignment	AssignmentHyperlinkAddress		The hyperlink address of a hyperlink associated with an assignment, resource, or a task.
	Resource	ResourceHyperlinkAddress
	Task	TaskHyperlinkAddress
Hyperlink Href	Assignment	AssignmentHyperlinkHref		The combination of the Hyperlink Address and the Hyperlink SubAddress fields.
	Resource	ResourceHyperlinkHref
	Task	TaskHyperlinkHref
Hyperlink SubAddress	Assignment	AssignmentHyperlinkSubAddress		The location within a document associated with the Hyperlink Address field.
	Resource	ResourceHyperlinkSubAddress
	Task	TaskHyperlinkSubAddress
Initials	Resource	ResourceInitials	RES_INITIALS	The abbreviation of a resource's name.
Material Label	Resource	ResourceMaterialLabel	RES_MATERIAL_LABEL	The name of the unit of measurement associated with a material resource.
Name	Resource	ResourceName	RES_NAME	The name of a resource or task.
Name	Task	TaskName	TASK_NAME	The name of a resource or task.
Notes	Assignment	AssignmentNotes	ASSN_RTF_NOTES	The notes about an assignment, resource, or task.
	Resource	ResourceNotes	RES_RTF_NOTES
	Task	TaskNotes	TASK_RTF_NOTES
Outline Number	Task	TaskOutlineNumber	TASK_OUTLINE_LEVEL	The number that identifies a task's position in a project's outline; this number is entered automatically by Microsoft Project.
Phonetics	Resource	ResourcePhonetics	RES_PHONETICS	The phonetic information about a resource name; used only in the Japanese version of Microsoft Project.
Project	Assignment	Projects	The PROJ_NAME field in the MSP_PROJECTS table contains the name of a project. Match the PROJ_UID in the MSP_ASSIGNMENTS, MSP_RESOURCES, or MSP_TASKS tables to the PROJ_UID in the MSP_PROJECTS table to identify the project name.	The name of the project.
	Resource	Projects
	Task	Projects
Resource Group	Assignment	ResourceGroup		The name of a group to which a resource belongs.
Resource Group	Task	ResourceGroup		The name of a group to which a resource belongs.
Resource Initials	Assignment	ResourceInitials in the	RES_INITIALS in the	The initials of a resource assigned to a task.
		Resources table	MSP_RESOURCES table
	Task	ResourceInitials in the	RES_INITIALS in the
		Resources table	MSP_RESOURCES table
Resource Names	Assignment	ResourceName in the	RES_NAME in the	The name of a resource assigned to a task.
		Resources table	MSP_RESOURCES table
	Task	ResourceName in the	RES_NAME in the
		Resources table	MSP_RESOURCES table
Subproject File	Task	TaskSubprojectFile		The name of an inserted project, including the path to the project.
Task Name	Assignment	TaskName	TASK_NAME	The name of a task.
Task Summary Name	Assignment	AssignmentTaskSummaryName		The name of a summary task.
Text1-30	Assignment	AssignmentText1-30	MSP_TEXT_FIELDS	The values for the custom Text1 through Text30 fields.
	Resource	ResourceText1-30	MSP_TEXT_FIELDS
	Task	TaskText1-30	MSP_TEXT_FIELDS
WBS	Assignment			The work breakdown structure codes used to represent a task's position within the project.
WBS	Task	TaskWBS	TASK_WBS
Windows User Account	Resource	ResourceNTAccount		The Microsoft Windows user name for a work resource.

Table B-10. Yes/No Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
Assignment	Assignment			Indicates whether this is an assignment.
	Resource
	Task
Can Level	Resource	ResourceCanLevel	RES_CAN_LEVEL	The setting that specifies whether leveling can be performed on the resource.
Confirmed	Assignment	AssignmentConfirmed	ASSN_IS_CONFIRMED	The setting that specifies whether a resource has accepted an assignment using an electronic team collaboration method.
	Resource	ResourceConfirmed
	Task	TaskConfirmed
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_DRIVEN	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	AssignmentFlag1-20		The setting that specifies whether the custom fields Flag1 through Flag20 are on or off.
	Resource	ResourceFlag1-20
	Task	TaskFlag1-20
Group By Summary	Resource			The setting that specifies whether a task is a summary task.
Group By Summary	Task	TaskSummary	TASK_IS_SUMMARY
Hide Bar	Task	TaskHideBar	TASK_BAR_IS_HIDDEN	The setting that specifies whether Gantt and Calendar bars are hidden for a task.
Ignore Resource Calendar	Task	TaskIgnoreResourceCalendar	TASK_IGNORES_RES_CAL	The setting that specifies whether a resource's calendar is taken into account in conjunction with a task calendar.
Inactive	Resource			The setting that specifies whether an enterprise resource has been made inactive.
Level Assignments	Task	TaskLevelAssignments	TASK_LEVELING_ADJUSTS_ASSN	The setting that specifies whether assignments can be split or delayed to resolve resource overallocations.
Leveling Can Split	Task	TaskLevelingCanSplit	TASK_LEVELING_CAN_SPLIT	The setting that specifies whether resource leveling can cause a task split on the remaining work on a task.
Linked Fields	Assignment	AssignmentLinkedFields	ASSN_HAS_LINKED_FIELDS	The setting that specifies whether an assignment, resource, or task has OLE links to it from within the project, another project, or an external application.
	Resource	ResourceLinkedFields	RES_HAS_LINKED_FIELDS
	Task	TaskLinkedFields	TASK_HAS_LINKED_FIELDS
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	AssignmentOverallocated	ASSN_IS_OVERALLOCATED	The setting that specifies whether resources have been assigned work beyond their work capacity or availability.
	Resource	ResourceOverallocated	RES_IS_OVERALLOCATED
	Task	TaskOverallocated	TASK_IS_OVERALLOCATED
TeamStatus Pending	Assignment	AssignmentTeamStatusPending	ASSN_TEAM_STATUS_PENDING	The setting that specifies whether a response to a progress request has been received through an electronic team collaboration method.
	Resource	ResourceTeamStatusPending
	Task	TaskTeamStatusPending
Recurring	Task	TaskRecurring	TASK_IS_RECURRING	The setting that specifies whether a task is recurring.
Response Pending	Assignment	AssignmentResponsePending	ASSN_RESPONSE_PENDING	The setting that specifies whether a response to an update has been received through an electronic team collaboration method.
	Resource	ResourceResponsePending
	Task	TaskResponsePending
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 Read Only	Task	TaskSubprojectReadOnly		The setting that specifies 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.
Text Above	Task			The setting that specifies whether text appears above or below the summary Gantt bar.
Update Needed	Assignment	AssignmentUpdateNeeded	ASSN_UPDATE_NEEDED	The setting that specifies whether an update message should be sent to resources to notify them of updates to their assigned tasks through an electronic team collaboration method.
	Resource	ResourceUpdateNeeded
	Task	TaskUpdateNeeded

Special Field Categories

The fields listed in the following tables (Custom Fields and Custom Outline Codes, Earned Value, and PERT Analysis) are all included in the tables found earlier in this chapter. In this case, these fields are listed by their function in the project plan.

Custom Fields and Custom Outline Codes

Custom fields can be used to create your own cost, date, duration, finish, flag, number, outline code, start, and text fields in Microsoft Project. The number of customizable fields of a given type can range from 10 to 30. When using Microsoft Project or the OLE DB Provider, you will see the fields listed with the type and the number of the custom field. When you're viewing the custom fields using Microsoft Access or Microsoft Excel, each custom field is stored in a unique table that contains all the data required to identify the custom field or custom outline code and where it is being used within a project. The table name is listed in the Microsoft Project Database column. Table B-11 shows custom fields.

For more information about working with custom fields, see Customizing Fields and Working with Outline Codes.

Earned Value Fields

Earned value fields are used to measure the cost of work and are based on a task's baseline cost. Table B-12 shows earned value fields.

For information about working with earned value, see Chapter 13, "Analyzing Project Information."

PERT Analysis Fields

PERT Analysis is a technique used to evaluate task durations using best-case (optimistic), expected-case (expected), and worst-case (pessimistic) scenarios based on a task's duration, start date, or finish date. All PERT analysis fields use custom fields to store the information. Table B-13 shows PERT Analysis fields.

For information about working with PERT Analysis, see Setting Task Durations.

Table B-11. Custom Fields

Field	Available categories	OLE DB provider	Description
Cost1-10	Assignment	AssignmentCost1-10	The currency values for the custom Cost1 through Cost10 fields.
	Resource	ResourceCost1-10
	Task	TaskCost1-10
Date1-10	Assignment	AssignmentDate1-10	The date values for the custom Date1 through Date10 fields.
	Resource	ResourceDate1-10
	Task	TaskDate1-10
Duration1-10	Assignment	AssignmentDuration1-10	The duration values for the custom Duration1 through Duration10 fields.
	Resource	ResourceDuration1-10
	Task	TaskDuration1-10
Finish1-10	Assignment	AssignmentFinish1-10	The date values for the custom Finish1 through Finish10 fields.
	Resource	ResourceFinish1-10
	Task	TaskFinish1-10
Flag1-20	Assignment	AssignmentFlag1-20	The Yes/No values for the custom Flag1 through Flag20 fields.
	Resource	ResourceFlag1-20
	Task	TaskFlag1-20
Number1-20	Assignment	AssignmentNumber1-20	The numeric values for the custom Number1 through Number20 fields.
	Resource	ResourceNumber1-20
	Task	TaskNumber1-20
OutlineCode1-10	Resource	ResourceOutlineCode1-10	The values for the custom OutlineCode1 through OutlineCode10 fields.
OutlineCode1-10	Task	TaskOutlineCode1-10
Start1-10	Assignment	AssignmentStart1-10	The date values for the custom Start1 through Start10 fields.
	Resource	ResourceStart1-10
	Task	TaskStart1-10
Text1-30	Assignment	AssignmentText1-30	The text values for the custom Text1 through Text30 fields.
	Resource	ResourceText1-30
	Task	TaskText1-30

Table B-12. Earned Value Fields

Field	Available categories	OLE DB provider	Microsoft Project database	Description
ACWP	Assignment	AssignmentACWP	ASSN_ACWP	The earned value actual cost of work performed (ACWP).
	Assignment (Timephased)	AssignmentTimeACWP	ASSN_ACWP
	Resource	ResourceACWP	RES_ACWP
	Resource (Timephased)	ResourceTimeACWP	RES_ACWP
	Task	TaskACWP	TASK_ACWP
	Task (Timephased)	TaskTimeACWP	TASK_ACWP
BAC	Assignment	AssignmentBaselineCost	ASSN_BASE_COST	The earned value Budget At Completion (BAC). Same as the Baseline Cost field.
	Assignment (Timephased)	AssignmentTimeBaselineCost	ASSN_BASE_COST
	Resource	ResourceBaselineCost	RES_BASE_COST
	Resource (Timephased)	ResourceTimeBaselineCost	RES_BASE_COST
	Task	TaskBaselineCost	TASK_BASE_COST
	Task (Timephased)	TaskTimeBaselineCost	TASK_BASE_COST
BCWP	Assignment	AssignmentBCWP	ASSN_BCWP	The earned value budgeted costs of work performed (BCWP) costs.
	Assignment (Timephased)	AssignmentTimeBCWP	ASSN_BCWP
	Resource	ResourceBCWP	RES_BCWP
	Resource (Timephased)	ResourceTimeBCWP	RES_BCWP
	Task	TaskBCWP	TASK_BCWP
	Task (Timephased)	TaskTimeBCWP	TASK_BCWP
BCWS	Assignment	AssignmentBCWS	ASSN_BCWS	The earned value budgeted cost of work scheduled (BCWS) costs.
	Assignment (Timephased)	AssignmentTimeBCWS	ASSN_BCWS
	Resource	ResourceBCWS	RES_BCWS
	Resource (Timephased)	ResourceTimeBCWS	RES_BCWS
	Task	TaskBCWS	TASK_BCWS
	Task (Timephased)	TaskTimeBCWS	TASK_BCWS
CPI	Task	TaskCPI		The earned value cost performance index, which is the ratio between BCWP and ACWP.
CPI	Task (Timephased)
CV	Assignment	AssignmentCV		The earned value cost variance (CV), which is the difference between the budgeted (baseline) cost and the actual cost of work performed.
	Assignment (Timephased)	AssignmentTimeCV
	Resource	ResourceCV
	Resource (Timephased)	ResourceTimeCV
	Task	TaskCV
	Task (Timephased)	TaskTimeCV
CV Percent	Task	TaskCVP		The earned value cost variance percent (CV %), which is the ratio of CV to BCWP, expressed as a percentage.
CV Percent	Task (Timephased)
EAC	Task	TaskEAC	TASK_EAC	The earned value estimate at completion (EAC), which is the expected total cost of a task.
Earned Value Method	Task		TASK_EVMETHOD	The method (Percent Complete or Physical Percent Complete) used to calculate BCWP.
Physical Percent Complete	Task		TASK_PHY_PCT_COMP	The percent complete value, also known as earned value percent complete; an alternative to BCWP.
SPI	Task	TaskSPI		The earned value schedule performance index (SPI), which is the ratio of BCWP to BCWS.
SPI	Task (Timephased)
SV	Assignment	AssignmentSV		The earned value schedule variance (SV), which is the difference between BCWP and BCWS measured in cost terms.
	Assignment (Timephased)	AssignmentTimeSV
	Resource	ResourceSV
	Resource (Timephased)	ResourceTimeSV
	Task	TaskSV
	Task (Timephased)	TaskTimeSV
SV Percent	Task	TaskSVP		The earned value schedule variance (SV %), which is the ratio of SV to BCWS.
SV Percent	Task (Timephased)
TCPI	Task	TaskTCPI		The earned value To Complete Performance Index (TCPI), which is the ratio of remaining work to remaining funds.
VAC	Assignment	AssignmentVAC		The earned value variance at completion (VAC), which is the difference between BAC and EAC, measured in cost terms.
	Resource	ResourceVAC
	Task	TaskVAC

Table B-13. PERT Analysis Fields

Field	Available categories	OLE DB provider	Description
Expected Finish	Task	TaskFinish2	The expected finish date of a task for PERT Analysis calculations.
Expected Start	Task	TaskStart2	The expected start date of a task for PERT Analysis calculations.
Expected Duration	Task	TaskDuration2	The expected duration of a task for PERT Analysis calculations.
Optimistic Finish	Task	TaskFinish1	The optimistic finish date of a task for PERT Analysis calculations.
Optimistic Start	Task	TaskStart1	The optimistic start date of a task for PERT Analysis calculations.
Optimistic Duration	Task	TaskDuration1	The optimistic duration of a task for PERT Analysis calculations.
Pessimistic Finish	Task	TaskFinish3	The pessimistic finish date of a task for PERT Analysis calculations.
Pessimistic Start	Task	TaskStart3	The pessimistic start date of a task for PERT Analysis calculations.
Pessimistic Duration	Task	TaskDuration3	The pessimistic duration of a task for PERT Analysis calculations.

Page #199 (Installing Microsoft Project 2002,Installing Microsoft Project 2002,Microsoft Project Server Setup Issues,Microsoft Project Web Access Setup Issues,Enterprise Setup Issues)