Microsoft Project 2002 OLE DB Provider Information

(C) 2002 Microsoft Corporation. All rights reserved.

Contents

Overview
  What's new in OLE DB
  New tables
  Specifics
  Limitations

Accessing the OLE DB table structure using data access pages in Microsoft Access
  Microsoft Access 2000
  Microsoft Access 2002

Sample code using Microsoft ActiveX Data Objects (ADO)
  Accessing the provider on your computer

OLE DB tables
  Indicator symbols
  Assignments
  Assignment Timephased by Minute, Hour, Day, Week, and Month
  Availability
  BaselineTaskSplits
  CalendarData
  CalendarExceptions
  Calendars
  CostRates
  CustomFieldGraphicalIndicators
  CustomFields
  CustomFieldValueList
  CustomOutlineCodeFields
  CustomOutlineCodeLookupTables
  Predecessors
  Project
  Resources
  Resource Timephased by Minute, Hour, Day, Week, and Month
  Successors
  Tasks
  TaskSplits
  Task Timephased by Minute, Hour, Day, Week, and Month
  WBS (work breakdown structure)

Overview

This document provides the information necessary to access Microsoft Project data through the Microsoft Project OLE DB Provider. In addition to describing the OLE DB table structures, this document details additional information about the provider, including how to access the table structure using data access pages, and sample Microsoft ActiveX Data Objects (ADO) code.

Top

What's new in OLE DB

OLE DB in Microsoft Project has been expanded and includes the following enhancements:

Top

New tables

The following tables have been added to OLE DB in Microsoft Project:

Top

Specifics

Some aspects of the OLE DB Provider for Microsoft Project are unique and should be noted to prevent unexpected results:

Additionally, the provider supports three registry keys that determine the number of seconds that must elapse before certain time-out conditions occur. These keys can be found under the HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\MS Project\OLE DB Provider subkey of the registry:

Registry Key Default Value Description
TimeoutOnLoad 90 Determines how long the provider attempts to load a project before returning an error message that it is unavailable.
TimeBeforeUnload 600 Determines how long a project remains open after another project is loaded. Until a new project is loaded, the current project remains in memory, regardless of this setting.
TimeBeforeRefresh 1 Determines how often the current project is checked for updated information.

Tip   Setting a key to 0 prevents a time-out.

Note   Before you edit the registry, make sure you understand how to restore it if a problem occurs. Editing the registry incorrectly can cause serious problems that may require you to reinstall your operating system.

Top

Limitations

The current implementation of the OLE DB Provider has some limitations:

Top

Accessing the OLE DB table structure using data access pages in Microsoft Access

Data access pages in Microsoft Access provide a versatile and powerful method for generating reports using data from Microsoft Project. They also provide a convenient way to view the Microsoft Project OLE DB table structure. For more information on data access pages, see Microsoft Access Help.

Note   Data access pages require Microsoft Internet Explorer 5 or later.

Microsoft Access 2000

The following steps describe how to connect to the Microsoft Project OLE DB Provider with Microsoft Access 2000:

1   Start Microsoft Access 2000, create a new database by clicking Access database wizards, pages, and projects, and then click OK.
2   In the New dialog box, click the General tab, and then double-click Data Access Page..
3   In the New Data Access Page dialog box, click Design View, and then click OK.
4   In the Data Link Properties dialog box, click the Provider tab, and then click Microsoft Project 10.0 OLE DB Provider.
5   Click the All tab, click Project Name, and then click Edit Value.
6   Enter the path and file name of the project you want to access, and then click OK.

Note To connect to a Microsoft Project database file, enter only the Project Name, and be sure to enter values for Data Source, Initial Catalog, User ID, and, if necessary, Password on the Connection tab.

7   Click OK to close the Data Link Properties dialog box.

The OLE DB table structure of the project is displayed in the Field List dialog box.

Top

Microsoft Access 2002

The following steps describe how to connect to the Microsoft Project OLE DB Provider using Microsoft Access 2002:

1   Start Microsoft Access 2002, and create a blank data access page by clicking File, New, Blank Data Access Page.
2   Click +Connect to New Data Source .odc, then click Open.
3   Click Other/Advanced, then click Next.
4   Click Microsoft Project 10.0 OLE DB Provider.
5   Click the All tab.
6   Click Project Name, click Edit Value, and then under Property Value, type the path and file name for the .mpp file you wish to create a data access page from.
7   Verify the value of Enterprise Mode (either True or False), and then click OK.

If everything is set correctly, the Data Connection Wizard - Choose Data dialog box appears with the Microsoft Project tables displayed. Click Next.

8   Enter the name of your data access page, and then click Finish.

Top

Sample code using Microsoft ActiveX Data Objects

Microsoft ActiveX Data Objects (ADO) provides simple access to the OLE DB Provider through a set of objects, events, methods, and properties. Likely scenarios for ADO operations include accessing the provider on your computer and accessing it from the Microsoft Project Server.

Accessing the provider on your computer

This sample accesses a Microsoft Project file on your computer and displays some assignment information from the project.

Note   For the sample to compile, you must add a reference to the Microsoft ActiveX Data Objects 2.1 or later to your project. For more information, see the topic "Set a Reference to a Type Library" in Microsoft Project Visual Basic Help.

Sub Connect()
    Dim conData As New ADODB.Connection
    Dim rstAssigns As New ADODB.Recordset
    Dim intCount As Integer
    Dim strSelect As String
    Dim strResults As String
    
    conData.ConnectionString = "Provider=Microsoft.Project.OLEDB.10.0;PROJECT NAME=" & FILE_NAME
' To connect to a Microsoft SQL Server file, you must also supply User ID and Password arguments
'    conData.ConnectionString = "Provider=Microsoft.Project.OLEDB.10.0;User ID=jsmith;Password=MyPass5;PROJECT NAME=" & FILE_NAME
    
    conData.ConnectionTimeout = 30
    conData.Open

    strSelect = "SELECT ResourceUniqueID, AssignmentResourceID, AssignmentResourceName, TaskUniqueID, AssignmentTaskID," & _
        	        " AssignmentTaskName FROM Assignments WHERE TaskUniqueID > 0 ORDER BY AssignmentTaskID ASC"
    rstAssigns.Open strSelect, conData

    Do While Not rstAssigns.EOF
        For intCount = 0 To rstAssigns.Fields.Count - 1
            If (Not IsNull(rstAssigns.Fields(intCount).Value)) Then
                strResults = strResults & "'" & rstAssigns.Fields(intCount).Name & "'" & Space(40 - Len(rstAssigns.Fields(intCount).Name)) & vbTab & CStr(rstAssigns.Fields(intCount).Value) & vbCrLf
            End If
            
            If (IsNull(rstAssigns.Fields(intCount).Value)) Then
                strResults = strResults & "'" & rstAssigns.Fields(intCount).Name & "'" & Space(40 - Len(rstAssigns.Fields(intCount).Name)) & vbTab & CStr("") & vbCrLf
            End If
                   
        Next
        strResults = strResults & vbCrLf
        rstAssigns.MoveNext
    Loop
    
    conData.Close
    
    Open "C:\My Documents\Results.txt" For Output As #1
    Print #1, strResults
    Close #1
        
    Shell "Notepad C:\My Documents\Results.txt", vbMaximizedFocus

End Sub

Top

OLE DB tables

The tables exposed through the Microsoft Project OLE DB Provider are shown in the following list. Their columns (fields), data types, descriptions, and values (where appropriate) are detailed below.

Note   Field names in the table descriptions that are formatted in bold indicate that the field is common to more than one table.

Note   Enterprise custom fields, available only in Microsoft Project Professional , are identified in the table descriptions with an E in the left column.

Top

Indicator symbols

The following indicator symbols are available in Microsoft Project:

Value Indicator symbol
0 None
1 Sphere, Lime
2 Sphere, Yellow
3 Sphere, Red
4 Sphere, Black
5 Sphere, White
6 Sphere, Aqua
7 Sphere, Green
8 Sphere, Blue
9 Sphere, Fuschia
10 Sphere, Purple
11 Sphere, Maroon
12 Sphere, Silver
13 Sphere, Gray
14 Flag, Lime
15 Flag, Yellow
16 Flag, Red
17 Flag, White
18 Flag, Aqua
19 Flag, Blue
20 Flag, Fuschia
21 Flag, Gray
22 Square, Lime
23 Square, Yellow
24 Square, Red
25 Square, Black
26 Square, White
27 Plus, Lime
28 Plus, Yellow
29 Plus, Red
30 Plus, Black
31 Plus, White
32 Minus, Lime
33 Minus, Yellow
34 Minus, Red
35 Minus, Black
36 Minus, White
37 Diamond, Lime
38 Diamond, Yellow
39 Diamond, Red
40 Arrow, Left
41 Arrow, Right
42 Arrow, Double
43 Arrow, Up
44 Arrow, Down
45 Circle, Solid Fill
46 Circle, Bottom Fill
47 Circle, Left Fill
48 Circle, Top Fill
49 Circle, Right Fill
50 Circle, Outer Fill
51 Circle, No Fill (Hollow)
52 Light Bulb, Off
53 Light Bulb, On
54 Check Mark
55 Delete Mark
56 Question Mark
57 Clock
58 Push Pin
59 Happy Face, Yellow
60 Happy Face, Lime
61 Straight Face, Yellow
62 Straight Face, Aqua
63 Sad Face, Yellow
64 Sad Face, Red
65 Dash

Top

Assignments

This table contains assignment data and links an assignment to its associated tasks and resources.

 Column NameData TypeDescription
ProjectstextThe name of the project, shown as the path to the location, for example: C:\\pathname\MyProject.mpp.
EProjectUniqueIDnumberRefers to a valid ID in the Project table.
ResourceUniqueIDnumberRefers to a valid ID in the Resources table.
EResourceEnterpriseUniqueIDnumberRefers to a valid enterprise ID in the Resources table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
AssignmentUniqueIDnumberThe unique ID for the assignment.
AssignmentPercentWorkCompletenumberThe current status of an assignment, expressed as the percentage of the assignment's work that has been completed.
AssignmentActualCostnumberThe cost incurred for work already performed by a resource on a task.
AssignmentActualFinishdateThe date and time when an assignment was actually completed.
AssignmentActualOvertimeCostnumberThe cost incurred for overtime work already performed by a resource on a task.
AssignmentActualOvertimeWorknumberThe actual amount of overtime work already performed by a resource on an assigned task.
AssignmentActualStartdateThe date and time that an assignment actually began.
AssignmentActualWorknumberThe amount of work that has already been done by a resource on a task.
AssignmentACWPnumberThe costs incurred for work already performed by a resource on a task up to the project status date or today's date; also called actual cost of work performed.
AssignmentBaselineCostnumberThe total planned cost for work to be performed by a resource on a task.
AssignmentBaseline1Cost-10numberCustom baseline cost information.
AssignmentBaselineFinishdateThe planned completion date for an assignment at the time a baseline is saved.
AssignmentBaseline1Finish-10numberCustom baseline finish information.
AssignmentBaselineStartdateThe planned beginning date for an assignment at the time a baseline is saved.
AssignmentBaseline1Start-10numberCustom baseline start information.
AssignmentBaselineWorknumberThe originally planned amount of work to be performed by a resource on a task.
AssignmentBaseline1Work-10numberCustom baseline work information.
AssignmentBCWPnumberThe cumulative value of the assignment's timephased percentage of work complete multiplied by the assignment's timephased baseline cost up to the status date or today's date; also known as budgeted cost of work performed.
AssignmentBCWSnumberThe cumulative timephased baseline costs up to the status date or today's date; also known as budgeted cost of work scheduled.
AssignmentConfirmedBooleanIndicates whether a resource assigned to a task has accepted or rejected the task assignment in response to a message notifying the resource of the assignment.
AssignmentCostnumberThe total scheduled (or projected) cost for an assignment based on costs already incurred for work performed by the resource on a task, in addition to the costs planned for the remaining work for the assignment.
AssignmentCost1-10numberCustom cost information.
CostRateTablenumberIndicates which cost rate table to use for a resource on an assignment:
0 A (default)
1 B
2 C
3 D
4 E
AssignmentCostVariancenumberThe difference between the baseline cost and total cost for an assignment.
AssignmentCVnumberThe difference between how much it should have cost to achieve the current level of completion on the assignment and how much it has actually cost to achieve the current level of completion up to the status date or today's date.
AssignmentDate1-10dateCustom date information.
AssignmentDelaynumberThe amount of time a resource is to wait after the task start date before starting work on an assignment.
AssignmentDuration1-10numberCustom assignment duration information entered and stored separately in a project.
EAssignmentEnterpriseCost1-10numberEnterprise custom assignment cost information.
EAssignmentEnterpriseDate1-30numberEnterprise custom date information.
EAssignmentEnterpriseDuration1-10numberEnterprise custom duration information.
EAssignmentEnterpriseFlag1-20numberEnterprise custom flag information.
EAssignmentEnterpriseNumber1-40numberEnterprise custom number information.
EAssignmentEnterpriseOutlineCode1-30IDnumberEnterprise custom outline code information.
EAssignmentEnterpriseText1-40numberEnterprise custom text information.
AssignmentFinishdateThe date and time that an assigned resource is scheduled to complete work on a task.
AssignmentFinish1-10dateCustom finish date information.
AssignmentFinishVariancenumberThe difference between an assignment's baseline finish date and its scheduled finish date.
AssignmentFixedMaterialBooleanIndicates whether the consumption of the assigned material resource occurs in a single, fixed amount.
AssignmentFlag1-20BooleanIndicates whether an assignment is marked for further action or identification of some kind.
AssignmentHasFixedRateUnitsBooleanIndicates whether an assignment has fixed rate units.
AssignmentHyperlinktextThe title or explanatory text for a hyperlink associated with an assignment.
AssignmentHyperlinkAddresstextThe address for a hyperlink associated with an assignment.
AssignmentHyperlinkHreftextThe combination, or concatenation, of the hyperlink address and hyperlink subaddress fields associated with an assignment.
AssignmentHyperlinkScreenTiptextThe text contained in a screen tip associated with a hyperlink.
AssignmentHyperlinkSubAddresstextThe specific location in a document within a hyperlink associated with an assignment.
AssignmentLevelingDelaynumberThe amount of time that an assignment is to be delayed from the scheduled start date as a result of resource leveling.
AssignmentLinkedFieldsBooleanIndicates whether there are OLE links to the assignment.
AssignmentMilestoneBooleanIndicates whether the assignment task is a milestone.
AssignmentNotestextContains notes about an assignment.
AssignmentNumber1-20numberCustom numeric information.
AssignmentOverallocatedBooleanIndicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity.
EAssignmentOtherTypenumberIndicates the type of assignment:
0 Regular
1 Task-only work
2 Fixed cost
3 Fixed cost and task-only work
AssignmentOvertimeCostnumberThe total overtime cost for a resource assignment.
AssignmentOvertimeWorknumberThe amount of overtime to be performed by a resource on a task, charged at the resource's overtime rate.
AssignmentPeakUnitsnumberThe maximum percentage of units for which a resource is assigned to a task for a given period of time.
AssignmentRegularWorknumberThe total amount of non-overtime work scheduled to be performed by a resource assigned to a task.
AssignmentRemainingCostnumberThe costs associated with completing all remaining scheduled work by any resources on a specific task.
AssignmentRemainingOvertimeCostnumberThe remaining scheduled overtime expense for an assignment.
AssignmentRemainingOvertimeWorknumberThe amount of overtime work that remains on an assignment.
AssignmentRemainingWorknumberThe amount of time required by a resource assigned to a task to complete an assignment.
AssignmentResourceIDnumberRefers to a valid ID in the Resources table.
AssignmentResourceNametextThe name of the resource associated with the assignment.
AssignmentResourceTypenumberThe resource type:
0 Work (default) (people and equipment)
1 Material (consumable supplies like steel, concrete, or soil)
EAssignmentResourceRequestTypenumberThe type of request:
0 None (default)
1 Request
2 Demand
AssignmentResponsePendingBooleanIndicates whether an answer has been received from a message sent to a resource assigned to a task notifying the resource of the assignment.
AssignmentStartdateThe date and time that an assigned resource is scheduled to begin working on a task.
AssignmentStart1-10dateCustom start date information.
AssignmentStartVariancenumberThe difference between an assignment's baseline start date and its currently scheduled start date.
AssignmentSummarynumberIndicates whether the assignment is part of a summary task.
AssignmentSVnumberThe difference in cost between the current progress and the baseline plan of the assignment up to the status date or today's date.
AssignmentTaskIDnumberRefers to a valid ID in the Tasks table.
AssignmentTaskNametextThe name of the task associated with the assignment.
AssignmentTaskSummaryNametextThe name of the summary task for the task associated with the assignment.
AssignmentTeamStatusPendingBooleanIndicates whether a status message has been received in response to a message requesting progress information that is sent to a resource assigned to a task.
AssignmentText1-30textCustom text information.
AssignmentUnitsnumberThe number of units for which a resource is assigned to a task, expressed as a percentage of 100%, assuming a resource's MaxUnits value is 100%.
AssignmentUpdateNeedednumberIndicates whether a message should be sent to the resource assigned to a task because of changes to the start date, finish date, or resource reassignments.
AssignmentVACnumberThe variance at completion (VAC) between the baseline cost and the total cost for an assignment on a task.
AssignmentWorknumberThe total amount of work scheduled to be performed by a resource on a task.
AssignmentWorkContournumberIndicates how work for an assignment is to be distributed across the duration of the assignment:
0 Flat (default)
1 Back Loaded
2 Front Loaded
3 Double Peak
4 Early Peak
5 Late Peak
6 Bell
7 Turtle
8 Contoured
AssignmentWorkVariancenumberThe difference between an assignment's baseline work and the currently scheduled work.

Top

Assignment Timephased by Minute, Hour, Day, Week, and Month

The OLE DB Provider supports timephased data. There are five assignment timephased tables, one each for minute, hour, day, week, and month. The database uses a consistent format for all timephased table names: tableTimephasedBytime, for example, AssignmentTimephasedByMinute. These tables return timephased data for all assignments by minute, hour, day, week, or month from the earliest start to the latest finish.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
AssignmentUniqueIDnumberThe unique ID for the assignment.
AssignmentTimeStartdateThe date and time that an assigned resource is scheduled to begin working on a task.
AssignmentTimeFinishdateThe date and time that an assigned resource is scheduled to complete work on a task.
AssignmentTimeActualCostnumberShows costs incurred for work already performed by a resource on a task.
AssignmentTimeActualOvertimeWorknumberThe actual amount of overtime work already performed by a resource on an assigned task.
AssignmentTimeActualWorknumberThe amount of work that has already been done by a resource on a task.
AssignmentTimeACWPnumberThe costs incurred for work already performed by a resource on a task, up to the project status date or today's date.
AssignmentTimeBaselineCostnumberSpecifies the total planned cost for work to be performed by a resource on a task.
AssignmentTimeBaseline1Cost-10numberCustom baseline cost information.
AssignmentTimeBaselineFinishnumberThe planned completion date for an assignment at the time a baseline is saved.
AssignmentTimeBaseline1Finish-10numberCustom baseline finish information.
AssignmentTimeBaselineStartnumberThe planned beginning date for an assignment at the time a baseline is saved.
AssignmentTimeBaseline1Start-10numberCustom baseline start information.
AssignmentTimeBaselineWorknumberThe originally planned amount of work to be performed by a resource on a task.
AssignmentTimeBaseline1Work-10numberCustom baseline work information.
AssignmentTimeBCWPnumberThe cumulative value of the assignment's timephased percentage of work complete multiplied by the assignment's timephased baseline cost, calculated up to the status date or today's date.
AssignmentTimeBCWSnumberThe cumulative timephased baseline costs of an assignment up to the status date or today's date.
AssignmentTimeCostnumberThe total scheduled (or projected) cost for a resource assignment based on costs already incurred for work performed by the resource on a task, in addition to the costs planned for the remaining work for the assignment.
AssignmentTimeCumulativeCostnumberThe scheduled cumulative timephased cost for a resource assignment to date, based on costs already incurred for work performed by the resource on the task, in addition to the costs planned for the remaining work for the assignment.
AssignmentTimeCumulativeWorknumberThe total amount of work scheduled to be performed by a resource on a task.
AssignmentTimeCVnumberThe difference between how much it should have cost to achieve the current level of completion on the assignment and how much it has actually cost to achieve the current level of completion up to the status date or today's date.
AssignmentTimeOvertimeWorknumberThe amount of overtime to be performed by a resource on a task; charged at the resource's overtime rate.
AssignmentTimePeakUnitsnumberThe maximum percentage of units for which a resource is assigned to a task for a given period of time.
AssignmentTimePercentAllocationnumberThe percentage that represents the amount of a resource's capacity being allocated to a specific assignment.
AssignmentTimeRegularWorknumberThe total amount of non-overtime work scheduled to be performed by a resource assigned to a task.
AssignmentTimeSVnumberThe difference in cost between the current progress and the baseline plan of the assignment up to the status date or today's date.
AssignmentTimeWorknumberThe total amount of time for work scheduled to be performed by a resource on a task.

Top

Availability

This table is normally used in conjunction with the Resources table to obtain resource availability information.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
ResourceUniqueIDnumberRefers to a valid ID in the Resources table.
ResourceEnterpriseUniqueIDnumberRefers to a valid enterprise ID in the Resources table.
AvailabilityAvailableFromdateThe starting date that a resource is available for work at the units specified for the current time period.
AvailabilityAvailableTodateThe ending date in which a resource will be available for work at the units specified for the current time period.
AvailabilityAvailableUnitsnumberThe number of units for which a resource is assigned to a task, expressed as a percentage of 100%, assuming a resource's MaxUnits value is 100 %.

Top

BaselineTaskSplits

This table stores baseline split information for a specific task.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
BaselineFieldnumberThe field that the baseline task split's start or end is measured from.
BaselineSplitFinishdateThe date the baseline task split ends.
BaselineSplitStartdateThe date the baseline task split begins.

Top

CalendarData

Along with the existing Calendars and the new CalendarExceptions tables, CalendarData stores all calendar information stored in the Microsoft Project OLE DB provider.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CalendarUniqueIDnumberRefers to a valid ID in the Calendars table.
CalendarWeekdaynumberIndicates the defined working day for the calendar:
0 Exception
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
CalendarWorkingBooleanIndicates whether the selected days are working or nonworking days.
CalendarFromDatedateThe date the exception begins.
CalendarToDatedateThe date the exception ends.
CalendarFromTime1-5numberThe time the first, second, third, fourth, or fifth shift begins.
CalendarToTime1-5numberThe time the first, second, third, fourth, or fifth shift ends.

Top

CalendarExceptions

Along with the existing Calendars and CalendarData tables, this table stores all calendar information in the OLE DB Provider.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CalendarUniqueIDnumberRefers to a valid ID in the Calendars table.
CalendarExceptionFromDatedateThe date the calendar exception begins.
CalendarExceptionToDatedateThe date the calendar exception ends.
CalendarExceptionWorkingBooleanIndicates whether the days contained in the calendar exception date range are working or nonworking days.
CalendarExceptionFromTime1-5numberThe time the first, second, third, fourth, or fifth time period begins.
CalendarExceptionToTime1-5numberThe time the first, second, third, fourth, or fifth time period ends.

Top

Calendars

Calendars are used to define standard working and nonworking times. Projects must have one base calendar. Tasks and resources may have their own calendars, but any task or resource calendar must be based on a base calendar. This table stores basic calendar data.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CalendarUniqueIDnumberThe unique ID for the calendar.
ResourceUniqueIDnumberRefers to a valid ID in the Resources table.
ResourceEnterpriseUniqueIDnumberRefers to a valid enterprise ID in the Resources table.
CalendarNametextThe name of the calendar; empty if this calendar is a resource calendar.
CalendarIsBaseCalendarBooleanIndicates whether this calendar is a base calendar; a resource calendar cannot be a base calendar.
CalendarBaseCalendarUniqueIDnumberRefers a calendar to its parent base calendar (required for all resource calendars).

Top

CostRates

This table is normally used in conjunction with the Resources table to display the cost rates tables for a resource. This table can also be used in conjunction with the Assignments table to get information about the cost rate table being used by an assignment.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
ResourceUniqueIDnumberRefers to a valid ID in the Resources table.
ResourceEnterpriseUniqueIDnumberRefers to a valid enterprise ID in the Resources table.
CostRateTablenumberIndicates which cost rate table to use for a resource on an assignment:
0 A (default)
1 B
2 C
3 D
4 E
CostFromDatedateThe first date that the resource rates are in effect.
CostToDatedateThe last date that the resource rates are in effect.
CostStandardRatenumberThe standard rate as entered in the selected cost rate table.
CostOvertimeRatenumberThe overtime rate as entered in the selected cost rate table.
CostPerUseCostnumberThe per-use cost as entered in the selected cost rate table.

Top

CustomFieldGraphicalIndicators

This table is normally used in conjunction with the CustomFields table to get the setting for those custom fields that have graphical indicators associated with the field.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CustomFieldCategorynumberIndicates whether the custom field is a task or a resource custom field:
0 Task
1 Resource
CustomFieldNamenumberThe default field ID as displayed in the user interface, for example, Cost1.
IndicatorCriterianumberIndicates the type of task or resource the criteria applies to:
0 Non-summary rows
1 Summary rows
2 Project summary
IndicatorCriteriaIndexnumberThe index of the criteria when multiple criteria are indicated for a single field.
IndicatorCriteriaTesttextThe textual representation of the criteria; used to determine whether a graphical indicator is displayed, for example: "is equal to".
IndicatorCriteriaValuenumberThe value the criteria tests for, for example: "$99".
IndicatorCriteriaGraphicnumberThe index of the graphical indicator to be displayed.
IndicatorCriteriaDescriptiontextA description of the graphical indicator.

Top

CustomFields

This table is used to get all the settings for a custom field. To edit these fields, the enterprise global template must be checked out.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CustomFieldCategorynumberIndicates whether the custom field is a task or a resource custom field:
0 Task
1 Resource
CustomFieldNamenumberThe default field ID as seen in the user interface, for example, Cost1.
CustomFieldAliastextThe name assigned to a renamed custom field, for example, ExpectedCost(Cost1).
CustomFieldAttributenumberIndicates whether a custom field has a value list, a formula, or none (default) associated with it.
CustomFieldValueListOrdernumberDefines the order of the items in the dropdown list of values that appears in the custom field list:
0 By row number (default)
1 Sort ascending
2 Sort descending
CustomFieldSummaryCalculationnumberIndicates whether task and group summary rows use rolled-up values, are calculated by a formula, or are edited directly by the user:
0 None (default); allows direct data entry and editing of task summary values
1 Rollup (see CustomFieldSummaryRollup)
2 Use formula (see CustomFieldFormula)
CustomFieldSummaryRollupnumberDefines the type of rollup if Rollup is selected in CustomFieldSummaryCalculation:
0 Maximum (default)
1 Minimum
3 Sum
4 Average
5 Average First Sublevel
CustomFieldFormulanumberThe formula for the custom field if Use formula is selected in CustomFieldSummaryCalculation.
CustomFieldGraphicalIndicatorBooleanIndicates whether data is replaced by a graphical indicator. If the data is replaced by a graphical indicator, see the CustomFieldGraphicalIndicators table for more information.

Top

CustomFieldValueList

This table is used to get the lookup table values for custom fields that have a value list.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CustomFieldCategorynumberIndicates whether the custom field is a task or a resource custom field:
0 Task
1 Resource
CustomFieldNamenumberThe default field ID as seen in the user interface, for example, Cost1.
ValueListIndexnumberIndicates the position of a custom field value list item in relation to other custom field value list items.
ValueListValuetextThe value of the custom field list.
ValueListDescriptiontextA description of the custom field list.

Top

CustomOutlineCodeFields

This table contains the mask for each of the custom outline code lookup tables.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
CustomFieldCategorynumberIndicates whether the custom field is a task or a resource custom field:
0 Task
1 Resource
CustomFieldNametextThe default field ID as seen in the user interface, for example, Cost1.
OutlineLevelnumberIndicates the outline level that corresponds with the code mask; is automatically incremented as each additional level of the code mask is entered.
OutlineSequencenumberDefines the character type for code masks:
0 Numbers (ordered); shows a numerical custom outline code for this level (default)
1 Uppercase Letters (ordered); shows uppercase, alphabetical custom outline codes (for example, A, B, and C for the first three summary tasks in the project)
2 Lowercase Letters (ordered); shows lowercase, alphabetical custom outline codes (for example, a, b, and c for the first three summary tasks in the project)
3 Characters (unordered); shows any combination of numbers and uppercase or lowercase letters (for example, Arch1, Const1, or Insp1) for the first three summary tasks in the project). Microsoft Project displays an asterisk (*) in the custom outline field until you type or enter a string of characters for this code
OutlineLengthnumberDefines the maximum number of characters (including spaces and separators) allowed in the first-level code string:
0 Any number of characters (default)
1 One character
2 ... 255 Two characters up to 255 characters
OutlineSeparatortextDefines the character used to separate custom outline code levels. The following values are shown in the Outline Code Definition dialog box in Microsoft Project; however, any symbol may be used as the custom outline code separator:
. Period (default)
- Minus
+ Plus
/ Forward slash

Top

CustomOutlineCodeLookupTables

This table is used to get a list of lookup table values for custom outline code fields.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
OutlineCodenumberThe field ID for the outline code, for example 188744096.
OutlineCodeLookupIndexnumberIndicates the position of an outline code in relation to other outline codes.
OutlineCodeLookupLevelnumberThe level of the outline code.
OutlineCodeLookupParentnumberRefers to the parent in the outline code tree structure.
OutlineCodeLookupValuetextThe value of the custom outline code.
OutlineCodeLookupDescriptiontextA description of the custom outline code.

Top

Predecessors

This table is normally used in conjunction with the Tasks table to display detailed information about predecessor tasks.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
PredecessorTaskUniqueIDnumberRefers to a valid ID in the Tasks table.
PredecessorLagnumberThe amount of lead (negative number) or lag (positive number) time for the predecessor task, for example, -3d or +4d.
PredecessorPathtextThe path to the predecessor task (even if the successor task is contained in another project), for example, C:\My Documents\Bldg E Construction.mpp\3FF.
PredecessorTypenumberThe type of predecessor task:
0 FF (finish-to-finish)
1 FS (finish-to-start)
2 SF (start-to-finish)
3 SS (start-to-start)
PredecessorLagTypetextIndicates the format for the amount of lag specified in PredecessorLag:
3 m
4 em
5 h
6 eh
7 d
8 ed
9 w
10 ew
11 mo
12 emo
19 %
20 e%
35 m?
36 em?
37 h?
38 eh?
39 d?
40 ed?
41 w?
42 ew?
43 mo?
44 emo?
51 %?
52 e%?

Top

Project

This table provides access to the project-level settings on Project Information (Project menu), Options (Tools menu), and Properties (File menu) dialog boxes. For the fields of the Project summary task, access the Tasks table using a value of 0 for the TaskID column.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberThe unique ID for the project.
ProjectAuthortextThe name of the author of the project; used to group similar projects together.
ProjectCalendarNametextThe name of the calendar associated with the project.
ProjectCategorytextThe category the project belongs to; used to group similar projects together.
ProjectCompanytextThe name of the company that created the project; used to group similar projects together.
ProjectCreationDatedateThe date the project was created.
ProjectCriticalSlackLimitnumberThe number of days past its end date that a task can go before Microsoft Project marks that task as a critical task.
ProjectCurrencyDigitsnumberThe number of digits that appear after the decimal when currency values are shown in Microsoft Project:
0 No digits after the decimal: $0
1 One digit after the decimal: $0.0
2 Two digits after the decimal (default): $0.00
ProjectCurrencyPositionnumber Indicates the placement of the currency symbol in relation to the currency value:
0 Before, no space (default): $0
1 After, no space: 0$
2 Before, with space: $ 0
3 After, with space: 0 $
ProjectCurrencySymboltext The current symbol used to represent the type of currency used in the project.
ProjectCurrentDatedateThe current date for a project.
ProjectDaysPerMonthnumberThe default number of working days per month.
ProjectDefaultFinishTimenumberThe default finish time for all new tasks.
ProjectDefaultFixedCostAccrualBooleanIndicates whether fixed costs are accrued.
ProjectDefaultOvertimeRatetextThe default overtime rate of pay for new resources. See ResourceOvertimeRate.
ProjectDefaultStandardRatetextThe default rate of pay for new resources. See ResourceStandardRate.
ProjectDefaultStartTimenumberThe default start time for all new tasks.
ProjectDefaultTaskTypenumberThe default type for all tasks in the project:
0 Fixed work; the amount of work remains constant, regardless of any change in duration or the number of resources (Assignment Units) assigned to the task
1 Fixed units (default); the number of resources (Assignment Units) remains constant, regardless of the amount of work or duration on the task
2 Fixed duration; the duration of the task remains constant, regardless of the number of resources (Assignment Units) assigned or the amount of work
ProjectDurationFormatnumberThe default format for all durations in the project:
0 minute
1 hour (default)
2 day
3 week
4 month
ProjectEditableActualCostsBooleanIndicates whether Microsoft Project automatically calculates actual costs.
EProjectEnterpriseCost1-10numberEnterprise custom project cost information.
EProjectEnterpriseCost1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseDate1-30numberEnterprise custom date information.
EProjectEnterpriseDate1Indicator-30numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseDuration1- 10numberEnterprise custom duration information.
EProjectEnterpriseDuration1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseFlag1-20numberEnterprise custom flag information.
EProjectEnterpriseFlag1Indicator-20numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseNametextThe name of the project in the Microsoft Project Server database.
EProjectEnterpriseNumber1-40numberEnterprise custom number information.
EProjectEnterpriseNumber1Indicator-40numberThe indicator symbol for the corresponding enterprise custom field. See Indicator symbols for more information.
EProjectEnterpriseOutlineCode1-30IDnumberEnterprise custom outline code information.
EProjectEnterpriseOutlineCode1Indicator-30numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseText1-40numberEnterprise custom text information.
EProjectEnterpriseText1Indicator-40numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EProjectEnterpriseVersionnumberThe version of the project for projects in the Microsoft Project Server database.
ProjectExpandTimephasedBooleanIndicates whether Microsoft Project saves timephased data in a readable or binary format when a project is saved to a database.
ProjectFinishDatedateThe date and time that a project is scheduled for completion.
ProjectFYStartnumberThe month the fiscal year begins:
0 January (default)
1 February
2 March
3 April
4 May
5 June
6 July
7 August
8 September
9 October
10 November
11 December
ProjectHonorConstraintsBooleanIndicates whether Microsoft Project schedules tasks according to their constraint date instead of any task dependencies.
ProjectInsertedProjectsLikeSummaryBooleanIndicates whether inserted projects are treated as summary tasks rather than as separate projects for schedule calculation.
ProjectIsResourcePoolBooleanIndicates whether the projectonly its own resources, or whether it shares its resources with another project or from a resource pool; see ProjectPoolAttachedTo.
ProjectKeywordstextLists keywords associated with the project; used to group similar projects together.
ProjectLastSaveddateThe date the project was last saved.
ProjectManagertextThe manager of the project; used to group projects with the same manager together.
ProjectMinsPerDaynumberThe default number of minutes per day.
ProjectMinsPerWeeknumberThe default number of minutes per week.
ProjectMultipleCriticalPathsBooleanIndicates whether Microsoft Project calculates and displays a critical path for each independent network of critical tasks within a project.
ProjectNewTasksEffortDrivenBooleanIndicates whether new tasks are effort-driven.
ProjectNewTasksEstimatedBooleanIndicates whether new tasks have estimated durations.
ProjectPoolAttachedTotextThe name of the project file that shares resources with this project file; required if ProjectIsResourcePool is set to True.
ProjectRevisiontextThe current revision number for the project file.
ProjectSavePreviewPictureBooleanIndicates whether Microsoft Project saves a picture of a project for preview.
ProjectScheduledFromStartBooleanIndicates whether a project is scheduled from the project start date (default) or the project finish date.
ProjectShowEstimatedDurationsBooleanIndicates whether Microsoft Project displays a ? after the duration of any task with an estimated duration.
ProjectSplitInProgressTasksBooleanIndicates whether in-progress tasks may be split.
ProjectSpreadActualCostsBooleanIndicates whether actual costs are spread to the status date.
ProjectSpreadPercentCompleteBooleanIndicates whether percent complete is spread to the status date.
ProjectStartDatedateThe date and time that a project is scheduled to begin.
ProjectStatusDatedateThe project status date.
ProjectSubjecttextThe subject of the project; used to group similar projects together.
ProjectTaskUpdatesResourceBooleanIndicates whether Microsoft Project automatically calculates actual and remaining work and costs as you enter task percent complete information in your schedule.
ProjectTitletextThe title of the project; used to group similar projects together.
ProjectWorkFormatnumberThe default format for all work durations in the project:
0 minute
1 hour (default)
2 day
3 week
4 month

Top

Resources

This table contains information related to resources.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
EProjectUniqueIDnumberRefers to a valid ID in the Project table.
ResourceUniqueIDnumberThe unique ID for the resource.
ResourcePercentWorkCompletenumberThe current status of all tasks assigned to a resource, expressed as the total percentage of the resource's work that has been completed.
ResourceAccrueAtnumberIndicates how and when resource standard and overtime costs are to be charged, or accrued, to the cost of a task:
1 Start; costs are accrued as soon as the task starts, as indicated by a date entered in the ActualStart field.
2 End; costs are not incurred until remaining work is zero.
3 Prorated (default); costs accrue as work is scheduled to occur and as actual work is reported.
ResourceActualCostnumberThe sum of costs incurred for the work already performed by a resource for all assigned tasks.
ResourceActualOvertimeCostnumberThe cost incurred for overtime work already performed by a resource for all assigned tasks.
ResourceActualOvertimeWorknumberThe actual amount of overtime work already performed for all assignments assigned to a resource.
ResourceActualWorknumberThe actual amount of work that has already been done for all assignments assigned to a resource.
ResourceACWPnumberThe sum of Actual Cost of Work Performed (ACWP) values for all of a resource's assignments, up to the status date or today's date.
ResourceAvailableFromdateThe starting date that a resource is available for work at the units specified for the current time period.
ResourceAvailableTo dateThe ending date in which a resource will be available for work at the units specified for the current time period.
ResourceBaseCalendartextLists all calendars available to be applied to a resource, including the standard calendar and any custom calendars:
0 Standard (default)
1+ Custom calendar
ResourceBaselineCostnumberThe total planned cost for a resource for all assigned tasks; also called budget at completion (BAC).
ResourceBaseline1Cost-10numberCustom baseline cost information.
ResourceBaselineFinishnumberThe planned finish date for assignments.
ResourceBaseline1Finish-10numberCustom baseline finish information.
ResourceBaselineStartnumberThe planned beginning date for assignments.
ResourceBaseline1Start-10numberCustom baseline start information.
ResourceBaselineWorknumberThe originally planned amount of work to be performed for all assignments assigned to a resource.
ResourceBaseline1Work-10numberCustom baseline work information.
ResourceBCWPnumberThe rolled-up summary of a resource's BCWP values for all assigned tasks, calculated up to the status date or today's date; also called budgeted cost of work performed.
ResourceBCWSnumberThe rolled-up summary of a resource's BCWS values for all assigned tasks; also called budgeted cost of work scheduled.
ResourceCanLevelBooleanIndicates whether resource leveling can be done for a resource.
ResourceCodetextA code, abbreviation, or number entered as part of a resource's information.
ResourceConfirmedBooleanIndicates whether a resource has accepted or rejected all task assignments in response to a message assigning tasks to the resource.
ResourceCostnumberThe total scheduled cost for a resource for all assigned tasks, based on costs already incurred for work performed by the resource on all assigned tasks in addition to the costs planned for all remaining work.
ResourceCost1-10numberCustom cost information.
EResourceCost1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceCostPerUsenumberThe cost that accrues each time a resource is used.
ResourceCostVariancenumberThe difference between the baseline cost and total cost for a resource.
ResourceCVnumberThe difference between how much it should have cost for the resource to achieve the current level of completion, and how much it has actually cost to achieve the current level of completion, up to the status date or today's date.
ResourceDate1-10dateCustom date information.
EResourceDate1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDuration1-10numberCustom duration information.
EResourceDuration1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEmailAddresstextThe e-mail address of a resource; if this field is left blank, Microsoft Project uses the name in the ResourceName field as the e-mail address.
EResourceEnterpriseCost1-10numberEnterprise custom resource cost information.
EResourceEnterpriseCost1Indicator-10 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseDate1-30numberCustom enterprise-level date information.
EResourceEnterpriseDate1Indicator-30 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseDuration1-10numberEnterprise custom duration information.
EResourceEnterpriseDuration1-10IndicatornumberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseFlag1-20numberCustom enterprise-level flag information.
EResourceEnterpriseFlag1Indicator-20 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseGenericBooleanIndicates whether the resource is a generic resource.
EResourceEnterpriseNumber1-40numberEnterprise custom number information.
EResourceEnterpriseNumber1Indicator-40 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseOutlineCode1-30IDnumberEnterprise custom outline code information.
EResourceEnterpriseOutlineCode1Indicator-30numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseText1-40numberEnterprise custom text information.
EResourceEnterpriseText1Indicator-40 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
EResourceEnterpriseUniqueIDnumberThe unique ID for the enterprise resource.
ResourceFinishdateThe date and time that a resource is scheduled to complete work on all assigned tasks.
ResourceFinish1-10 dateCustom finish date information.
EResourceFinish1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceFlag1-20BooleanIndicates whether a resource is marked for further action or identification of some kind.
EResourceFlag1Indicator-20numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceGrouptextThe name of the group a resource belongs to.
ResourceHyperlinktextThe title or explanatory text for a hyperlink associated with a resource.
ResourceHyperlinkAddresstextThe address for a hyperlink associated with a resource.
ResourceHyperlinkHreftextThe combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a resource.
ResourceHyperlinkScreenTiptextThe text contained in a ScreenTip associated with a hyperlink.
ResourceHyperlinkSubAddresstextThe specific location in a document within a hyperlink associated with a resource.
ResourceIDnumberIndicates the position of a resource in relation to other resources.
ResourceInitialstextThe abbreviation for a resource name.
ResourceIsNullBooleanIndicates whether the resource is a null resource.
ResourceLinkedFieldsBooleanIndicates whether there are OLE links to the resource, from elsewhere in the active project, another Microsoft Project file, or from another program.
ResourceMaterialLabeltextThe unit of measurement entered for a material resource, for example, tons, boxes, or cubic yards. This is used in conjunction with the material resource's Assignment Units and is only available if ResourceType is set to Material.
ResourceMaxUnitsnumberThe maximum percentage, or number of units, that represents the maximum capacity that a resource is available to accomplish any tasks during the current time period:
0-99 Resource is 0%-99% available for the specified task
100 Resource is 100% available for the specified task (default)
ResourceNametextThe name of the resource; must be unique within Microsoft Project Server, whether the resource is active.
ResourceNotestextNotes about a resource.
ResourceNTAccounttextThe Windows NT account name for a resource; for example, domain name\user name.
ResourceNumber1-20numberCustom numeric information.
EResourceNumber1Indicator-20numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceObjectsnumberThe number of objects associated with a resource, not including those in notes.
ResourceOutlineCode1-10textAn alphanumeric code defined to represent a hierarchical structure of resources.
ResourceOverallocatedBooleanIndicates whether a resource is assigned to do more work on all assigned tasks than can be done within the resource's normal work capacity.
ResourceOvertimeCostnumberThe total overtime cost for a resource on all assigned tasks.
ResourceOvertimeRatetextThe rate of pay for overtime work performed by a resource.
ResourceOvertimeWorknumberThe amount of overtime to be performed for all tasks assigned to a resource and charged at the resource's overtime rate.
ResourcePeakUnitsnumberThe maximum percentage, or number of units, that a resource is assigned at any one time for all tasks assigned to the resource.
ResourcePhoneticstextContains phonetic information in either Hiragana or Katakana for resource names; used only in the Japanese version of Microsoft Project.
ResourceRegularWorknumberThe total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource.
ResourceRemainingCostnumberThe remaining scheduled expense that will be incurred in completing the remaining work assigned to a resource.
ResourceRemainingOvertimeCostnumberThe remaining scheduled overtime expense of a resource that will be incurred in completing the remaining planned overtime work by a resource on all assigned tasks.
ResourceRemainingOvertimeWorknumberThe remaining amount of overtime required by a resource to complete all tasks.
ResourceRemainingWorknumberThe amount of time, or person-hours, still required by a resource to complete all assigned tasks.
ResourceResponsePendingBooleanIndicates whether an answer has been received from all messages sent to a resource about assigned tasks.
ResourceStandardRatetextThe rate of pay for regular, non-overtime work performed by a resource.
ResourceStartdateThe date and time that an assigned resource is scheduled to begin working on all assigned tasks.
ResourceStart1-10dateCustom start date information.
EResourceStart1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceSVnumberThe difference in cost between the current progress and the baseline plan of all the resource's assigned tasks up to the status date or today's date; also called schedule variance.
ResourceText1-30textCustom text information.
EResourceText1Indicator-30numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceTeamStatusPendingBooleanIndicates whether an answer has been received in response to a message requesting progress information sent to a resource about an assigned task.
ResourceTypenumberThe resource type (Work or Material):
0 Work (default) (people and equipment)
1 Material (consumable supplies like steel, concrete, or soil)
ResourceUpdateNeededBooleanIndicates whether a message should be sent to a resource because of changes to any of the resource's assigned tasks.
ResourceVACnumberThe difference between the baseline cost and the total cost for a resource.
ResourceWorknumberThe total amount of work scheduled to be performed by a resource on all assigned tasks.
ResourceWorkgrouptextThe messaging method used to communicate with a project team:
0 Default
1 Web (Microsoft Project Web Access)
2 E-mail only
3 None; Workgroup messaging is not used on this project
ResourceWorkVariancenumberThe difference between a resource's total baseline work and the currently scheduled work.

Top

Resource Timephased by Minute, Hour, Day, Week, and Month

The OLE DB Provider supports timephased data. There are five resource timephased tables, one each for minute, hour, day, week, and month. The database uses a consistent format for all timephased table names: tableTimephasedBytime, for example, ResourceTimephasedByMinute. These tables return timephased data for all resources by minute, hour, day, week, or month from the earliest start to the latest finish.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
ResourceUniqueIDnumberRefers to a valid ID in the Resources table.
ResourceEnterpriseUniqueIDnumberRefers to a valid enterprise ID in the Resources table.
ResourceTimeStartdateThe date and time that an assigned resource is scheduled to begin working on all assigned tasks.
ResourceTimeFinishdateThe date and time that an assigned resource is scheduled to finish working on all assigned tasks.
ResourceTimeActualCostnumberThe timephased costs incurred for work already performed by a resource for all assigned tasks.
ResourceTimeActualOvertimeWorknumberThe actual amount of overtime work already performed for all assignments assigned to a resource.
ResourceTimeActualWorknumberThe amount of work that has already been done for all assignments assigned to a resource.
ResourceTimeACWPnumberThe timephased sum of ACWP (actual cost of work performed) values for all of a resource's assignments.
ResourceTimeBaselineCostnumberThe baseline cost for this resource; also called budget at completion.
ResourceTimeBaseline1Cost-10numberCustom baseline cost information.
ResourceTimeBaselineFinishnumberThe planned finish date for assignments.
ResourceTimeBaseline1Finish-10numberCustom baseline finish information.
ResourceTimeBaselineStartnumberThe planned beginning date for assignments.
ResourceTimeBaseline1Start-10numberCustom baseline start information.
ResourceTimeBaselineWorknumberThe originally planned amount of work to be performed for all assignments assigned to a resource.
ResourceTimeBaseline1Work-10numberCustom baseline work information.
ResourceTimeBCWPnumberThe timephased rolled-up summary of a resource's BCWP (budgeted cost of work performed) values for all assigned tasks.
ResourceTimeBCWSnumberThe cumulative BCWS (budgeted cost of work scheduled) for the resource.
ResourceTimeCostnumberThe scheduled timephased cost for a resource for all assigned tasks.
ResourceTimeCumulativeCostnumberThe cumulative scheduled timephased cost for a resource for all assigned tasks to date, based on costs already incurred for work performed by the resource on all assigned tasks, in addition to the costs planned for the remaining work.
ResourceTimeCumulativeWorknumberThe total work, or person-hours, for a resource, as accumulated over time.
ResourceTimeCVnumberThe difference between how much it should have cost for the resource to achieve the current level of completion and how much it has actually cost to achieve the current level of completion up to the status date or today's date.
ResourceTimeOverallocationnumberThe amount of work, as distributed over time, that a resource is overallocated for all assigned tasks.
ResourceTimeOvertimeWorknumberThe amount of overtime to be performed for all assignments assigned to a resource and charged at the resource's overtime rate.
ResourceTimePeakUnitsnumberThe percentage, or number of units, to which a resource is assigned at any one time for all assigned tasks.
ResourceTimePercentAllocationnumberThe percentage of a resource's total work capacity that is allocated to all assigned tasks.
ResourceTimeRegularWorknumberThe total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource.
ResourceTimeRemainingAvailabilitynumberThe amount of time remaining that a resource will be available to work during a particular time period.
ResourceTimeSVnumberThe difference in cost between the current plan and the baseline progress of all the resource's assigned tasks.
ResourceTimeUnitAvailabilitynumberThe percentage or number of maximum units that a work resource is available to accomplish any tasks during any selected time period.
ResourceTimeWorkAvailabilitynumberThe maximum amount of time a work resource is available to be scheduled for work during any selected time period.
ResourceTimeWorknumberThe total amount of work scheduled to be performed by a resource on all assigned tasks.

Top

Successors

This table is normally used in conjunction with the Tasks table to display detailed information about successor tasks.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
SuccessorTaskUniqueIDnumberRefers to a valid ID in the Tasks table.
SuccessorLagnumberThe amount of lead (negative number) or lag (positive number) time for the successor task; for example, -3d or +4d.
SuccessorPathtextThe path to the successor task (even if the successor task is contained in another project); for example, C:\My Documents\Bldg E Construction.mpp\3FF. Indicates the format for the amount of lag specified in LINK_LAG .
SuccessorTypenumberThe type of dependency to a successor task:
0 FF (finish-to-finish)
1 FS (finish-to-start)
2 SF (start-to-finish)
3 SS (start-to-start)
SuccessorLagTypetextIndicates the format for the amount of lag specified in SuccessorLag:
3 m
4 em
5 h
6 eh
7 d
8 ed
9 w
10 ew
11 mo
12 emo
19 %
20 e%
35 m?
36 em?
37 h?
38 eh?
39 d?
40 ed?
41 w?
42 ew?
43 mo?
44 emo?
51 %?
52 e%?

Top

Tasks

This table stores the information about the tasks that make up a project.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
EProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberThe unique ID for the task.
TaskPercentWorkCompletenumberThe current status of a task, expressed as the percentage of the task's work that has been completed.
TaskActualCostnumberThe costs incurred for work already performed by all resources on a task, along with any other recorded costs associated with the task.
TaskActualDurationnumberThe span of actual working time for a task so far, based on the scheduled duration and current remaining work or completion percentage.
TaskActualFinishdateThe date and time that a task actually finished.
TaskActualOvertimeCostnumberThe costs incurred for overtime work already performed on a task by all assigned resources.
TaskActualOvertimeWorknumberThe actual amount of overtime work already performed by all resources assigned to a task.
TaskActualStartnumberThe date and time that a task actually began.
TaskActualWorknumberThe amount of work that has already been done by the resources assigned to a task.
TaskACWPnumberThe costs incurred for work already done on a task, up to the project status date or today's date.
TaskBaselineCostnumberThe total planned cost for a task; also referred to as budget at completion (BAC).
TaskBaselineCost1-10numberCustom baseline cost information.
TaskBaselineDurationnumberThe original span of time planned to complete a task.
TaskBaselineDuration1-10numberCustom baseline duration information.
TaskBaselineDurationEstimatedBooleanIndicates whether the baseline duration is estimated.
TaskBaselineDurationEstimated1-10BooleanCustom baseline estimated duration information.
TaskBaselineFinishdateThe planned completion date for a task at the time a baseline is saved.
TaskBaselineFinish1-10numberCustom baseline finish information.
TaskBaselineStartdateThe planned beginning date for a task at the time a baseline is saved.
TaskBaselineStart1-10numberCustom baseline start information.
TaskBaselineWorknumberThe originally planned amount of work to be performed by all resources assigned to a task.
TaskBaselineWork1-10numberCustom baseline work information.
TaskBCWPnumberThe cumulative value of the task's timephased percent complete multiplied by the task's timephased baseline cost, up to the status date or today's date; also known as budgeted cost of work performed.
TaskBCWSnumberThe cumulative timephased baseline costs up to the status date or today's date.
TaskCalendartextLists all calendars available to be applied to a task, including the standard calendar and any custom calendars:
0 Standard (default)
1+ Custom calendar
TaskCompleteThroughdateThe progress of a task on the Gantt Chart, up to the point that actuals have been reported for the task.
TaskConfirmedBooleanIndicates whether all resources assigned to a task have accepted or rejected the task assignment in response to a message assigning a task.
TaskConstraintDatedateIndicates the constrained start or finish date as defined in TaskConstraintType. Required unless TaskConstraintType is set to As late as possible or As soon as possible.
TaskConstraintTypenumberThe constraint on a scheduled task:
0 As soon as possible
1 As late as possible
2 Must start on; TaskConstraintDate is required
3 Must finish on; TaskConstraintDate is required
4 Start no earlier than; TaskConstraintDate is required
5 Start no later than; TaskConstraintDate is required
6 Finish no earlier than; TaskConstraintDate is required
7 Finish no later than; TaskConstraintDate is required
TaskContacttextThe name of the individual who is responsible for a task.
TaskCostnumberThe total scheduled, or projected, cost for a task, based on costs already incurred for work performed by all resources assigned to the task, in addition to the costs planned for the remaining work for the assignment.
TaskCost1-10numberCustom cost information.
ETaskCost1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskCostVariancenumberThe difference between the baseline cost and the total cost for a task.
TaskCPInumberThe cost performance index, or the ratio of budget to actual cost.
TaskCreateddateThe date and time that a task was added to a project.
TaskCriticalBooleanIndicates whether a task has room in the schedule to slip, or if it is on the critical path.
TaskCVnumberThe difference between how much it should have cost to achieve the current level of completion on the task and how much it has actually cost to achieve the current level of completion up to the status date or today's date; also called cost variance.
TaskCVPnumberThe cost variance percentage for a task.
TaskDate1-10dateCustom date information.
ETaskDate1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskDeadlinedateThe date entered as a deadline for the task.
TaskDurationnumberThe total span of active working time for a task.
TaskDuration1-10numberCustom duration information.
ETaskDuration1Estimated-10BooleanIndicates whether the corresponding TaskDuration1-10 field is estimated.
ETaskDuration1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskDurationElapsednumberIndicates which field is used to base BCWP values on.
TaskDurationVariancenumberThe difference between the baseline duration of a task and the total duration (current estimate) of a task.
ETaskEnterpriseCost1-10numberCustom enterprise-level cost information.
ETaskEnterpriseCost1Indicator-10 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ETaskEnterpriseDate1-30numberCustom enterprise-level date information.
ETaskEnterpriseDate1Indicator-30 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ETaskEnterpriseDuration1-10numberCustom enterprise-level duration information.
ETaskEnterpriseDuration1Indicator-10 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ETaskEnterpriseFlag1-20numberCustom enterprise-level flag information.
ETaskEnterpriseFlag1Indicator-20 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ETaskEnterpriseNumber1-40numberCustom enterprise-level number information.
ETaskEnterpriseNumber1Indicator-40 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ETaskEnterpriseOutlineCode1-30IDnumberCustom enterprise-level outline code information.
ETaskEnterpriseText1-40numberCustom enterprise-level text information.
ETaskEnterpriseText1Indicator-40 numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEarlyFinishdateThe earliest date that a task could possibly finish, based on early finish dates of predecessor and successor tasks, other constraints, and any leveling delay.
TaskEarlyStartdateThe earliest date that a task could possibly begin, based on the early start dates of predecessor and successor tasks, and other constraints.
TaskEffortDrivenBooleanIndicates whether scheduling for a task is effort-driven.
TaskEstimatedBooleanIndicates whether the task's duration is flagged as an estimate.
TaskExternalTaskBooleanIndicates whether the task is linked from another project or whether it originated in the current project.
TaskEACnumberThe total scheduled or projected cost for a task based on costs already incurred, in addition to the costs planned for remaining work.
TaskFinishdateThe date and time that a task is scheduled to be completed.
TaskFinish1-10 dateCustom finish date information.
ETaskFinish1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskFinishSlacknumberThe duration between the early finish and late finish dates.
TaskFinishVariancenumberThe amount of time that represents the difference between a task's baseline finish date and its current finish date.
TaskFixedCostnumberA task expense that is not associated with a resource cost.
TaskFixedCostAccrualnumberIndicates how fixed costs are to be charged, or accrued, to the cost of a task:
1 Start; costs are accrued as soon as the task starts, as indicated by a date entered in the ActualStart field.
2 End; costs are not incurred until remaining work is zero.
3 Prorated (default); costs accrue as work is scheduled to occur and as actual work is reported.
TaskFlag1-20BooleanCustom flag information.
ETaskFlag1Indicator-20numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskFreeSlacknumberThe amount of time that a task can be delayed without delaying any successor tasks; if a task has zero successor tasks, then free slack is the amount of time a task can be delayed without delaying the entire project.
TaskHideBarBooleanIndicates whether the Gantt bars and Calendar bars for a task are hidden.
TaskHyperlinktextThe title or explanatory text for a hyperlink associated with a task.
TaskHyperlinkAddresstextThe address for a hyperlink associated with a task.
TaskHyperlinkHreftextThe combination, or concatenation, of the hyperlink address and hyperlink subaddress fields associated with a task.
TaskHyperlinkScreenTiptextThe text contained in a ScreenTip associated with a hyperlink.
TaskHyperlinkSubAddresstextThe specific location in a document within a hyperlink associated with a task.
TaskIDnumberIndicates the position of a task in relation to other tasks.
TaskIgnoreResourceCalendarBooleanIndicates whether the scheduling of the task takes into account the calendars of the resources assigned to the task.
TaskIsNullBooleanIndicates whether a task is a null task.
TaskLateFinishdateThe latest date that a task can finish without delaying the finish of the project.
TaskLateStartdateThe latest date that a task can start without delaying the finish of the project.
TaskLevelAssignmentsBooleanIndicates whether the leveling function can delay and split individual assignments (rather than the entire task) to resolve overallocations.
TaskLevelingCanSplitBooleanIndicates whether the resource leveling function can split remaining work on a task.
TaskLevelingDelaynumberThe amount of time that a task is to be delayed from its early start date as a result of resource leveling.
TaskLinkedFieldsBooleanIndicates whether there are OLE links to a task, from elsewhere in the active project, another Microsoft Project file, or from another program.
TaskMarkedBooleanIndicates whether a task is marked for further action or identification of some kind.
TaskMilestoneBooleanIndicates whether a task is a milestone.
TaskNametextThe name of a task.
TaskNotestextNotes entered about a task.
TaskNumber1-20 numberCustom numeric information.
ETaskNumber1Indicator-20numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskObjectsnumberThe number of objects attached to a task.
TaskOutlineCode1-10textAn alphanumeric code that represents a hierarchical structure of tasks.
TaskOutlineLevelnumberThe number that indicates the level of a task in the project outline hierarchy.
TaskOutlineNumbertext Indicates the exact position of a task in the outline. For example, 7.2 indicates that a task is the second subtask under the seventh top-level summary task.
TaskOverallocatedBooleanIndicates whether an assigned resource on a task has been assigned to more work on the task than can be done within the normal working capacity.
TaskOvertimeCostnumberThe actual overtime cost for a task.
TaskOvertimeWorknumberThe amount of overtime scheduled to be performed by all resources assigned to a task and charged at overtime rates.
TaskPercentCompletenumberThe current status of a task, expressed as the percentage of the task's duration that has been completed.
TaskPredecessorstextThe task ID numbers for the predecessor tasks to this task.
TaskPreleveledFinishdateThe finish date of a task as it was before resource leveling was done.
TaskPreleveledStartdateThe start date of a task as it was before resource leveling was done.
TaskPrioritynumberIndicates the level of importance assigned to a task; the higher the number, the higher the priority:
0 Lowest priority; task will always be leveled
500 Default value
1000 Highest priority; task will never be leveled
TaskRecurringBooleanIndicates whether a task is a recurring task.
TaskRegularWorknumberThe total amount of non-overtime work scheduled to be performed by all resources assigned to a task.
TaskRemainingCostnumberThe remaining scheduled expense of a task that will be incurred in completing the remaining scheduled work by all resources assigned to a task.
TaskRemainingDurationnumberThe amount of time required to complete the unfinished portion of a task. Remaining duration can be calculated in two ways (either based off of Percent (%) Complete or Actual Duration).
TaskRemainingOvertimeCostnumberThe remaining scheduled overtime expense for a task.
TaskRemainingOvertimeWorknumberThe amount of remaining overtime scheduled by all assigned resources to complete a task.
TaskRemainingWorknumberThe amount of time still required by all assigned resources to complete a task.
TaskResourceGrouptextThe list of resource groups to which the resources assigned to a task belong.
TaskResourceInitialstextLists the abbreviations for the names of resources assigned to a task.
TaskResourceNametextLists the names of all resources assigned to a task.
TaskResourcePhoneticstextContains information in either Hiragana or Katakana for the names of resources assigned to a task; used only in the Japanese version of Microsoft Project.
TaskResponsePendingBooleanIndicates whether an answer has been received from all messages sent to the resources assigned to a task notifying them of the assignments.
TaskResumedateThe date the remaining portion of a task is scheduled to resume after you enter a new value for the Percent (%) Complete field is entered.
TaskRollupBooleanIndicates whether the summary task bar displays rolled-up bars or whether information on the sub-task Gantt bars will be rolled up to the summary task bar; must be set to "True" for sub-tasks to be rolled up to summary tasks.
TaskSPInumberThe schedule performance index or the ratio of performed to scheduled work.
TaskStartdateThe date and time that a task is scheduled to begin; this value is automatically calculated if a task has a predecessor.
TaskStart1-10dateCustom start date information.
ETaskStart1Indicator-10numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskStartSlacknumberThe amount of time a task can be delayed without affecting the start date of a successor task or the project finish date.
TaskStartVariancenumberThe difference between a task's baseline start date and its currently scheduled start date.
TaskStopdateThe date that represents the end of the actual portion of a task; contains NA until you enter actual work or a percent complete.
TaskStatusThe current status of a task.
TaskSubprojectFiletextThe name of a project inserted into the active project file including the subproject's path and file name.
TaskSubprojectReadOnlyBooleanIndicates whether the subproject of this task is a read-only project.
TaskSuccessorstextThe task ID numbers for the successor tasks to this task.
TaskSummaryBooleanIndicates whether a task is a summary task.
TaskSummaryProgressnumberThe progress on a summary task, based on the progress of its subtasks.
TaskSVnumberThe difference between the current progress and the baseline plan of the task up to the status date or today's date; also known as schedule variance.
TaskSVPnumberThe schedule variance percentage (SVP) for a task.
TaskTCPInumberThe to complete performance index (TCPI) for a task.
TaskTeamStatusPendingBooleanIndicates whether an answer has been received in response to a message requesting progress information sent to the resources assigned to a task.
TaskText1-30textCustom text information.
ETaskText1Indicator-30numberThe indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskTotalSlacknumberThe amount of time a task can be delayed without delaying a project's finish date.
TaskTypenumberIndicates the effect that editing work, assignment units, or duration has on the calculations of the other two fields:
0 Fixed work; the amount of work remains constant, regardless of any change in duration or the number of resources (Assignment Units) assigned to the task
1 Fixed units (default); the number of Assignment Units remains constant, regardless of the amount of work or duration on the task
2 Fixed duration; the duration of the task remains constant, regardless of the number of resources (Assignment Units) assigned or the amount of work
TaskUniqueIDPredeccessorstextThe unique IDs for predecessor tasks. For example, 15FS+3d means that this task's predecessor is task ID 15, with a finish-to-start dependency, and 3 days lag time.
TaskUniqueIDSuccessorstextThe unique IDs for successor tasks. For example, 15FS+3d means that this task's successor is task ID 15, with a finish-to-start dependency, and 3 days lag time.
TaskUpdateNeededBooleanIndicates whether a message should be sent to the assigned resources notifying them of changes to the start date, finish date, or reassignments of tasks.
TaskVACnumberThe difference between the baseline cost and the total cost for a task; also called variance at completion (VAC).
TaskWBStextA unique code (WBS) used to represent a task's position within the hierarchical structure of the project.
TaskWBSPredecessorstextThe WBS codes associated with a predecessor task that the task depends on before it can start or finish.
TaskWBSSuccessorstextLists the WBS codes associated with the successor tasks.
TaskWorknumberThe total amount of work scheduled to be performed on a task by all assigned resources.
TaskWorkVariancenumberThe difference between a task's baseline work and the currently scheduled work.

Top

TaskSplits

This table stores the start and finish dates for a task split.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
SplitFinishdateThe date the task split ends.
SplitStartdateThe date the task split begins.

Top

Task Timephased by Minute, Hour, Day, Week, and Month

The OLE DB Provider supports timephased data. There are five task timephased tables, one each for minute, hour, day, week, and month. The database uses a consistent format for all timephased table names: tableTimephasedBytime, for example, TaskTimephasedByMinute. These tables return timephased data for all tasks by minute, hour, day, week, or month from the earliest start to the latest finish.

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
TaskUniqueIDnumberRefers to a valid ID in the Tasks table.
TaskTimeStartdateThe date and time that a task is scheduled to begin.
TaskTimeFinishdateThe date and time that a task is scheduled to be completed.
TaskTimeActualCostnumberThe costs incurred for work already performed by all resources on a task, along with any other recorded costs associated with the task.
TaskTimeActualOvertimeWorknumberThe actual amount of overtime work already performed by all resources assigned to a task.
TaskTimeActualWorknumberThe amount of work that has already been done by the resources assigned to a task.
TaskTimeACWPnumberThe costs incurred for work already done on a task, up to the project status date or today's date.
TaskTimeBaselineCostnumberThe total planned cost for a task; also referred to as budget at completion (BAC).
TaskTimeBaseline1Cost-10numberCustom baseline cost information.
TaskTimeBaselineFinishnumberThe planned completion date for a task at the time a baseline is saved.
TaskTimeBaseline1Finish-10numberCustom baseline finish information.
TaskTimeBaselineStartnumberThe planned beginning date for a task at the time a baseline is saved.
TaskTimeBaseline1Start-10numberCustom baseline start information.
TaskTimeBaselineWorknumberThe amount of work originally planned to be performed by all resources assigned to a task.
TaskTimeBaseline1Work-10numberCustom baseline work information.
TaskTimeBCWPnumberThe cumulative value of the task's timephased percent complete multiplied by the task's timephased baseline cost, up to the status date or today's date; also known as budgeted cost of work performed.
TaskTimeBCWSnumberThe cumulative timephased baseline costs up to the status date or today's date.
TaskTimeCostnumberThe total scheduled, or projected, cost for a task, based on costs already incurred for work performed by all resources assigned to the task, in addition to the costs planned for the remaining work for the assignment; also called estimate at completion (EAC).
TaskTimeCumulativeCostnumberThe total cost for a task.
TaskTimeCumulativeWorknumberThe total work, or person-hours, for a task.
TaskTimeCVnumberThe difference between how much it should have cost to achieve the current level of completion on the task, and how much it has actually cost to achieve the current level of completion up to the status date or today's date; also called cost variance.
TaskTimeFixedCostnumberA task expense that is not associated with a resource cost.
TaskTimeOvertimeWorknumberThe amount of overtime scheduled to be performed by all resources assigned to a task and charged at the resources' overtime rates.
TaskTimeRegularWorknumberThe total amount of non-overtime work scheduled to be performed by all resources assigned to a task.
TaskTimeSVnumberThe difference in cost between the current progress and the baseline plan of the task up to the status date or today's date; also known as schedule variance.
TaskTimeWorknumberThe total amount of work scheduled to be performed on a task by all assigned resources.
TaskTimeActualFixedCostnumberThe actual timephased task expenses not related to resource costs, charged over time according to the selected cost accrual method.

Top

WBS (work breakdown structure)

This table stores WBS code definitions as well as WBS code settings for a project. These are the same definitions that are created in the WBS Code Definition dialog box (Project menu, WBS submenu, Define Code command).

 Column NameData TypeDescription
ProjecttextThe name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp.
ProjectUniqueIDnumberRefers to a valid ID in the Project table.
WBSProjectCodePrefixtextThe prefix for a WBS code.
WBSLevelnumberThe level that has been assigned to each WBS level, beginning with 1.
WBSSequencenumberThe type of code string for first-level tasks:
0 Numbers (ordered); a numerical WBS code for this level (default)
1 Uppercase Letters (ordered); uppercase, alphabetical WBS codes (for example, A, B, and C for the first three summary tasks in the project)
2 Lowercase Letters (ordered); lowercase, alphabetical WBS codes (for example, a, b, and c for the first three summary tasks in the project)
3 Characters (unordered); any combination of numbers and uppercase or lowercase letters (for example, Arch1, Const1, or Insp1) for the first three summary tasks in the project). Microsoft Project displays an asterisk (*) in the custom outline field until you type or enter a string of characters for this code
WBSLengthnumberThe maximum number of characters allowed in the first-level code string (see WBSSequence):
0 Any (default)
1 One character
2 Two characters
... 255 up to 255
WBSSeparatortextThe character used to separate WBS code levels. The following values are shown in the WBS Code Definition dialog box in Microsoft Project; however, any symbol may be used as the WBS code separator:
. Period (default)
- Minus
+ Plus
/ Forward slash
WBSGenerateNewBooleanIndicates whether Microsoft Project automatically generates a new WBS code when a new task is created.
WBSVerifyUniqueBooleanIndicates whether Microsoft Project enforces uniqueness when a WBS code for a task is edited.

Top