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, as follows :

• Currency fields

• Date fields

• Duration fields

• Enumerated fields

• Indicator fields

• Integer fields

• Outline code fields

• Percentage and number fields

• Text fields

• Yes/No (Boolean) fields

Currency Fields

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

Cross-References  

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

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
	Resource	ResourceActualCost	RES_ACT_COST
	Resource (Timephased)	ResourceTimeActualCost
	Task	TaskActualCost	TASK_ACT_COST
	Task (Timephased)	TaskTimeActualCost
Actual Fixed Cost	Task (Timephased)	TaskTimeActualFixedCost		The actual fixed cost expenses charged over time.
Actual Overtime Cost	Assignment	AssignmentActualOvertimeCos	ASSN_ACT_OVT_COST	The actual overtime costs
	Resource	ResourceActualOvertimeCost	RES_ACT_OVT_COST
	Task	TaskActualOvertimeCost	TASK_ACT_OVT_COST
ACWP	Assignment	AssignmentACWP	ASSN_ACWP	The earned value actual cost of workperformed (ACWP).
	Assignment (Timephased)	AssignmentTimeACWP
	Resource	ResourceACWP	RES_ACWP
	Resource (Timephased)	ResourceTimeACWP
	Task	TaskACWP	TASK_ACWP
	Task (Timephased)	TaskTimeACWP
BAC	Assignment	AssignmentBaselineCost	ASSN_BASE_COST	The earned value Budget At Completion (BAC). Same as the Baseline Cost field.
	Assignment (Timephased)	AssignmentTimeBaselineCost
	Resource	ResourceBaselineCost	RES_BASE_COST
	Resource(Timephased)	ResourceTimeBaselineCost
	Task	TaskBaselineCost	TASK_BASE_COST
	Task (Timephased)	TaskTimeBaselineCost
aselineCost	Assignment	AssignmentBaselineCost	ASSN_BASE_COST	The total planned cost for work performed, plus fixed costs.
	Assignment (Timephased)	AssignmentTime-BaselineCost
	Resource	ResourceBaselineCost	RES_BASE_COST
	Resource (Timephased)	ResourceTimeBaselineCost
	Task	TaskBaselineCost	TASK_BASE_COST
	Task (Timephased)	TaskTimeBaselineCost
Baseline1-10Cost	Assignment	AssignmentBaseline1Cost10		The baseline costs for Baseline1through Baseline 10.
	Assignment (Timephased)	AssignmentTimeBaseline1-Cost-10
	Resource	ResourceBaseline1Cost10
	Resource (Timephased)	ResourceTimeBaseline1Cost-10
	Task	TaskBaseline1Cost-10
	Task (Timephased)	TaskTimeBaseline1- Cost-10
BCWP	Assignment	AssignmentBCWP	ASSN_BCWP	The earned value budgeted costs of work performed (BCWP) costs.
	Assignment (Timephased)	AssignmentTimeBCWP
	Resource	ResourceBCWP	RES_BCWP
	Resource (Timephased)	ResourceTimeBCWP
	Task	TaskBCWP	TASK_BCWP
	Task (Timephased)	TaskTimeBCWP
BCWS	Assignment	AssignmentBCWS	ASSN_BCWS	The earned value budgeted cost of work scheduled (BCWS) costs.
	Assignment (Timephased)	AssignmentTimeBCWS
	Resource	ResourceBCWS	RES_BCWS
	Resource (Timephased)	ResourceTimeBCWS
	Task	TaskBCWS	TASK_BCWS
	Task (Timephased)	TaskTimeBCWS
Cost	Assignment	AssignmentCost	ASSN_COST	The total scheduled cost for an assignment, including expected costs and those already incurred.
	Assignment (Timephased)	AssignmentTimeCost
	Resource	ResourceCost	RES_COST
	Resource (Timephased)	ResourceTimeCost
	Task	TaskCost	TASK_COST
	Task (Timephased)	TaskTimeCost
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 nonresource task.
	Task (Timephased)	TaskTimeFixedCost
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
Overtime Rate	Resource	ResourceOvertimeCost	RES_OVT_COST	The total overtime cost for a resource on all assigned tasks.
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
Remaining Overtime Cost	Resource	ResourceRemainingOvertimeCost	RES_REM_OVT_COST	The remaining overtime costs for a resource.
Standard Rate	Resource	ResourceStandardRate	RES_STD_RATE	The standard rate for nonovertime 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

Date Fields

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

Cross-References  

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

Table B-2: Date Fields

Field	Available Categories	OLE DB Provider	Microsoft Project Database	Description
Actual	Assignment	AssignmentActualFinish	ASSN_ACT_FINISH	The actual date and time when a task is completed.
Finish	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	ResourceBaseline1- Finish-10
	Task	TaskBaseline1Finish-10
Baseline 1-10Start	Assignment	AssignmentBaseline1Start-10		The baseline start values for Baseline1Start through Baseline10Start.
	Resource	ResourceBaseline1- Start-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 when 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	AssignmentBaseline1- Finish-10		The values for the custom Finish1 through Finish10 fields.
	Resource	ResourceBaseline1- Finish-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 when 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 when the remaining portion of a split task is scheduled to resume.
Start	Assignment	AssignmentStart	ASSN_START	The date when 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 when 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.

Duration Fields

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

Cross-References  

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

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	Assignment- OvertimeWork	ASSN_OVT_WORK	The amount of overtime work already completed by a resource on a task.
	Assignment (Timephased)	AssignmentTime- OvertimeWork
	Resource	ResourceOvertimeWork	RES_OVT_WORK
	Resource (Timephased)	ResourceTime- OvertimeWork
	Task	TaskOvertimeWork	TASK_OVT_WORK
	Task (Timephased)	TaskTimeOvertimeWork
Actual Work	Assignment	Assignment- ActualWork	ASSN_ACT_WORK	The amount of work already completed by a resource on a task.
	Assignment (Timephased)	AssignmentTime- ActualWork
	Resource	ResourceActualWork	RES_ACT_WORK
	Resource (Timephased)	ResourceTime- ActualWork
	Task	TaskActualWork	TASK_ACT_WORK
	Task (Timephased)	TaskTimeActualWork
New       Actual Overtime Work Protected	Assignment	Assignment- ActualOvertime- WorkProtected	ASSN_ACT_OVT_ WORK_PROT
	Assignment (Timephased)	AssignmentTimeActualOvertimeWorkProtected		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.
	Resource	ResourceActualOvertimeWorkProtected	RES_ACT_ OVT_ WORK_PROT
New       Actual Work Protected	Assignment	AssignmentActualWorkProtected	ASSN_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.
	Assignment (Timephased)	AssignmentTimeActualWorkProtected
	Resource	ResourceActualWorkProtected	RES_ACT_WORK_ PROT
	Task	TaskActualWorkProtected	TASK_ACT_WORK_ PROT
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 number of work resource hours originally planned for a task
	Assignment (Timephased)	AssignmentTime-BaselineWork
	Resource	ResourceBaselineWork	RES_BASE_WORK
	Resource (Timephased)	ResourceTime- BaselineWork
	Task	TaskBaselineWork	TASK_BASE_WORK
	Task (Timephased)	TaskTimeBaselineWork
Baseline1-10 Duration	Task	TaskBaseline1- Duration-10		The baseline duration values for Baseline1through Baseline 10.
Baseline1-10 Work	Assignment	AssignmentBaseline1-Work-10		The baseline work values for Baseline1through Baseline 10.
	Assignment (Timephased)	AssignmentTime- Baseline1Work-10
	Resource	ResourceBaseline1-Work-10
	Resource (Timephased)	ResourceTime- Baseline1Work-10
	Task	TaskBaseline1- Work-10
	Task (Timephased)	TaskTimeBaseline1-Work-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.
Dura- tion1-10	Assignment	AssignmentDuration1-10		The values for the Custom Duration1 through Duration10 fields.
	Resource	Resource- Duration1-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.
	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	Assignment- LevelingDelay	ASSN_LEVELING_ DELAY	The amount of delay caused by resource leveling.
	Resource
	Task	TaskLevelingDelay	TASK_LEVELING_ DELAY
Negative Slack	Task			The amount 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.
Over- allocation	Assignment (Timephased)			The amount of work that exceeds the amount of time a resource is available.
	Resource (Timephased)	ResourceTime- Overallocation
	Task (Timephased)
Overtime Work	Assignment	Assignment- OvertimeWork	ASSN_OVT_WORK	The amount of work assigned to a resource that is charged at a resource's overtime rate.
	Assignment (Timephased)	AssignmentTime- OvertimeWork
	Resource	Resource- OvertimeWork	RES_OVT_WORK
	Resource (Timephased)	ResourceTime- OvertimeWork
	Task	TaskOvertimeWork	TASK_OVT_WORK
	Task (Timephased)	TaskTime- OvertimeWork
Pessimistic Duration	Task	TaskDuration3		The pessimistic task duration for PERT Analysis calculation.
Regular Work	Assignment	Assignment- RegularWork	ASSN_REG_WORK	The amount of work assigned to a resource that is charged at a resource's standard rate.
	Assignment (Timephased)	AssignmentTime- RegularWork
	Resource	ResourceRegularWork	RES_REG_WORK
	Resource (Timephased)	ResourceTime- RegularWork
	Task	TaskRegularWork	TASK_REG_WORK
	Task (Timephased)	TaskTimeRegularWork
Remaining Availability	Resource (Timephased)	ResourceTime-Remaining- Availability		The amount of available resource time not currently allocated to any task in a given time period.
Remaining Duration	Task	TaskRemaining- Duration	TASK_REM_DUR	The amount of time required to complete a task.
Remaining Overtime Work	Assignment	AssignmentRemaining-OvertimeWork	ASSN_REM_OVT_ WORK	The amount of scheduled overtime work remaining on unfinished tasks
	Resource	ResourceRemaining-OvertimeWork	RES_REM_OVT_ WORK
	Task	TaskRemaining- OvertimeWork	TASK_REM_OVT_ WORK
Remaining Work	Assignment	Assignment- RemainingWork	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 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 Task	AssignmentStart- Variance	ASSN_START_VAR	The difference between the baseline start date and the current scheduled start date.
		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
	Resource	Resource	RES_WORK
	Resource (Timephased)	ResourceTimeWork
	Task	TaskWork	TASK_WORK
	Task (Timephased)	TaskTimeWork
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	AssignmentWork- Variance		The difference between baseline work and scheduled work.
	Resource	ResourceWork- Variance
	Task	TaskWorkVariance

Enumerated Fields

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

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, at the end, or prorated across the span of the project.
Base Calendar Workgroup	Resource	ResourceBase- Calendar	RES_CAL_UID	The base calendar to be used with a particular resource. The collaboration method used to communicate with resources on a project team
	Resource	ResourceWorkgroup	RES_WORKGROUP_MESSAGING
New       Booking Type	Assignment	Assignment- BookingType	ASSN_BOOKING_ TYPE	The booking type for a resource, either Committed or Proposed.
	Resource	Resource- BookingType	RES_BOOKING_ TYPE
Constraint Type	Task	TaskConstraintType	TASK_CONSTRAINT_TYPE	The type of constraint applied to a task.
Cost Rate Table	Assignment	Assignment- CostRateTable	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, at the end, or prorated across the task duration.
Priority	Task	TaskPriority	TASK_PRIORITY	The relative importance of the task scheduling; used to determine priority for task leveling.
Resource Type	Assignment	Assignment-ResourceType	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	Assignment- WorkContour	ASSN_WORK_ CONTOUR	The way in which work is distributed over the length of an assignment.

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.

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.

Integer Fields

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

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.
	Task	TaskID	TASK_ID
Outline Level	Task Level	TaskOutlineLevel		The task's location within the project outline.
Predecessors	Task	Task- Predecessors		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	Task- Successors		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	Assignment-UniqueID	ASSN_UID	The unique ID of an assignment, resource, or task.
	Resource	Resource-UniqueID	RES_UID
	Task	TaskUniqueID	TASK_UID
Unique ID Predecessors	Task	TaskUniqueID- Predecessors		The unique ID of a predecessor task.
Unique ID Successors	Task	TaskUniqueID-Successors		The unique ID of a successor task.
WBS Predecessors	Task	TaskWBS- Predecessors		The work breakdown structure code of the predecessor tasks.
WBS Successors	Task	TaskWBS- Successors		The work breakdown structure code of the successor tasks.

Outline Code Fields

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

Table B-7: Custom Outline Codes

Field	Available Categories	OLE DB Provider	Microsoft Project Database	Description
Outline	Resource	ResourceOutline-Code1-10		The values for the custom OutlineCode1 through OutlineCode10 fields.
Code 1-10	Task	TaskOutline- Code1-10

Percentage and Number Fields

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

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.
	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 Task (Timephased)	TaskCVP		The earned value Cost Variance percent (CV%), which is the ratio of CV to BCWP … … …, expressed as a percentage.
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	Assignment-Number1-20		The values for the custom Number1 through Number20 fields.
	Resource	Resource- Number1-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.
	Task	TaskObjects	TASK_NUM_ OBJECTS
Peak	Assignment	AssignmentPeakUnits		The number of units that represents a resource's largest assignment (in units) or the number of units required to complete an assignment
	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.
	Resource (Timephased)	ResourceTimePeakUnits
Percent Allocation	Assignment (Timephased)	AssignmentTimePercentAllocation		The percentage of a resource's total available units compared with assigned units.
	Resource (Timephased)	ResourceTimePercentAllocation
Percent Complete	Task	TaskPercentComplete	TASK_PCT_ COMP	The ratio of a task's total duration to completed duration.
	Task (Timephased)
Percent Work Complete	Assignment Resource Task	TaskPercentWork- Complete	TASK_PCT_ WORK_COMP	The ratio of a task's total work to completed work.
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.
	Task (Timephased)
SV Percent	Task	TaskSVP		The earned value schedule variance (SV%), which is the ratio of SV to BCWS.
	Task (Timephased)
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)	ResourceTimeUnit-Availability		The number of units a resource is available to be assigned work, expressed as a percentage of a resource's total units.

Text Fields

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

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	Assignment- Hyperlink		The title of a hyperlink associated with an assignment, resource, or task.
	Resource	Resource- Hyperlink
	Task	TaskHyperlink
Hyperlink Address	Assignment	Assignment- Hyperlink- Address		The hyperlink address of a hyperlink associated with an assignment, resource, or task.
	Resource	ResourceHyperlinkAddress
	Task	TaskHyperlinkAddress
Hyperlink Href	Assignment	AssignmentHyperlinkHref		The combination of the Hyperlink Address and the Hyperlink Sub-Address fields.
	Resource	ResourceHyperlinkHref
	Task	TaskHyperlinkHref
Hyperlink SubAddress	Assignment	Assignment-HyperlinkSubAddress		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	Resource- MaterialLabel	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.
	Task	TaskName	TASK_NAME
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	TaskOutline- Number	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	Resource- Phonetics	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.
	Task	ResourceGroup
Resource Initials	Assignment	ResourceInitials in the Resources table	RES_INITIALS in the MSP_RESOURCES table	The initials of a resource assigned to a task.
	Task	ResourceInitials in the Resources table	RES_INITIALS in the MSP_RESOURCES table
Resource Names	Assignment	ResourceName in the Resources table	RES_NAME in the MSP_RESOURCES table	The name of a resource assigned to a task.
	Task	ResourceName in the Resources table	RES_NAME in the 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	AssignmentTaskSummary-Name		The name of a summary task.
Text1-30	Assignment	Assignment- Text1-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 Task	TaskWBS	TASK_WBS	The work breakdown structure codes used to represent a task's position within the project.
Windows User Account	Resource	ResourceNT-Account		The Microsoft Windows user name for a work resource.

Yes/No 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.

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	Assignment- Flag1-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 Task	TaskSummary	TASK_IS_ SUMMARY	The setting that specifies 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 Resource Calendar	Task	TaskIgnore-ResourceCalendar	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
Recurring	Task	TaskRecurring	TASK_IS_ RECURRING	The setting that specifies whether a task is recurring.
Response Pending	Assignment	Assignment-ResponsePending	ASSN_RESPONSE_PENDING	The setting that specifies whether a response to an update has been received through an electronic team collaboration method.
	Resource	Resource- ResponsePending
	Task	TaskResponse-Pending
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.
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
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