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.
OLE DB in Microsoft Project has been expanded and includes the following enhancements:
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:
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.
The following steps describe how to connect to the Microsoft Project OLE DB Provider with Microsoft Access 2000:
The following steps describe how to connect to the Microsoft Project OLE DB Provider using Microsoft Access 2002:
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.
This sample accesses a Microsoft Project file on your computer and displays some assignment information from the project.
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.
This table contains assignment data and links an assignment to its associated tasks and resources.
| | Column Name | Data Type | Description |
| Projects | text | The name of the project, shown as the path to the location, for example: C:\\pathname\MyProject.mpp. |
| E | ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| ResourceUniqueID | number | Refers to a valid ID in the Resources table. |
| E | ResourceEnterpriseUniqueID | number | Refers to a valid enterprise ID in the Resources table. |
| TaskUniqueID | number | Refers to a valid ID in the Tasks table. |
| AssignmentUniqueID | number | The unique ID for the assignment. |
| AssignmentPercentWorkComplete | number | The current status of an assignment, expressed as the percentage of the assignment's work that has been completed.
|
| AssignmentActualCost | number | The cost incurred for work already performed by a resource on a task. |
| AssignmentActualFinish | date | The date and time when an assignment was actually completed. |
| AssignmentActualOvertimeCost | number | The cost incurred for overtime work already performed by a resource on a task. |
| AssignmentActualOvertimeWork | number | The actual amount of overtime work already performed by a resource on an assigned task. |
| AssignmentActualStart | date | The date and time that an assignment actually began. |
| AssignmentActualWork | number | The amount of work that has already been done by a resource on a task. |
| AssignmentACWP | number | The 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. |
| AssignmentBaselineCost | number | The total planned cost for work to be performed by a resource on a task.
|
| AssignmentBaseline1Cost-10 | number | Custom baseline cost information. |
| AssignmentBaselineFinish | date | The planned completion date for an assignment at the time a baseline is saved. |
| AssignmentBaseline1Finish-10 | number | Custom baseline finish information. |
| AssignmentBaselineStart | date | The planned beginning date for an assignment at the time a baseline is saved. |
| AssignmentBaseline1Start-10 | number | Custom baseline start information. |
| AssignmentBaselineWork | number | The originally planned amount of work to be performed by a resource on a task. |
| AssignmentBaseline1Work-10 | number | Custom baseline work information. |
| AssignmentBCWP | number | The 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. |
| AssignmentBCWS | number | The cumulative timephased baseline costs up to the status date or today's date; also known as budgeted cost of work scheduled. |
| AssignmentConfirmed | Boolean | Indicates 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.
|
| AssignmentCost | number | The 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-10 | number | Custom cost information. |
| CostRateTable | number | Indicates which cost rate table to use for a resource on an assignment:
| 0 |
A (default) |
| 1 |
B |
| 2 |
C |
| 3 |
D |
| 4 |
E |
|
| AssignmentCostVariance | number | The difference between the baseline cost and total cost for an assignment. |
| AssignmentCV | number | The 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-10 | date | Custom date information. |
| AssignmentDelay | number | The amount of time a resource is to wait after the task start date before starting work on an assignment. |
| AssignmentDuration1-10 | number | Custom assignment duration information entered and stored separately in a project. |
| E | AssignmentEnterpriseCost1-10 | number | Enterprise custom assignment cost information. |
| E | AssignmentEnterpriseDate1-30 | number | Enterprise custom date information. |
| E | AssignmentEnterpriseDuration1-10 | number | Enterprise custom duration information. |
| E | AssignmentEnterpriseFlag1-20 | number | Enterprise custom flag information. |
| E | AssignmentEnterpriseNumber1-40 | number | Enterprise custom number information. |
| E | AssignmentEnterpriseOutlineCode1-30ID | number | Enterprise custom outline code information. |
| E | AssignmentEnterpriseText1-40 | number | Enterprise custom text information. |
| AssignmentFinish | date | The date and time that an assigned resource is scheduled to complete work on a task. |
| AssignmentFinish1-10 | date | Custom finish date information. |
| AssignmentFinishVariance | number | The difference between an assignment's baseline finish date and its scheduled finish date.
|
| AssignmentFixedMaterial | Boolean | Indicates whether the consumption of the assigned material resource occurs in a single, fixed amount.
|
| AssignmentFlag1-20 | Boolean | Indicates whether an assignment is marked for further action or identification of some kind. |
| AssignmentHasFixedRateUnits | Boolean | Indicates whether an assignment has fixed rate units. |
| AssignmentHyperlink | text | The title or explanatory text for a hyperlink associated with an assignment. |
| AssignmentHyperlinkAddress | text | The address for a hyperlink associated with an assignment. |
| AssignmentHyperlinkHref | text | The combination, or concatenation, of the hyperlink address and hyperlink subaddress fields associated with an assignment. |
| AssignmentHyperlinkScreenTip | text | The text contained in a screen tip associated with a hyperlink.
|
| AssignmentHyperlinkSubAddress | text | The specific location in a document within a hyperlink associated with an assignment.
|
| AssignmentLevelingDelay | number | The amount of time that an assignment is to be delayed from the scheduled start date as a result of resource leveling.
|
| AssignmentLinkedFields | Boolean | Indicates whether there are OLE links to the assignment.
|
| AssignmentMilestone | Boolean | Indicates whether the assignment task is a milestone.
|
| AssignmentNotes | text | Contains notes about an assignment.
|
| AssignmentNumber1-20 | number | Custom numeric information. |
| AssignmentOverallocated | Boolean | Indicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity.
|
| E | AssignmentOtherType | number | Indicates the type of assignment:
| 0 |
Regular |
| 1 |
Task-only work |
| 2 |
Fixed cost |
| 3 |
Fixed cost and task-only work |
|
| AssignmentOvertimeCost | number | The total overtime cost for a resource assignment.
|
| AssignmentOvertimeWork | number | The amount of overtime to be performed by a resource on a task, charged at the resource's overtime rate.
|
| AssignmentPeakUnits | number | The maximum percentage of units for which a resource is assigned to a task for a given period of time.
|
| AssignmentRegularWork | number | The total amount of non-overtime work scheduled to be performed by a resource assigned to a task.
|
| AssignmentRemainingCost | number | The costs associated with completing all remaining scheduled work by any resources on a specific task. |
| AssignmentRemainingOvertimeCost | number | The remaining scheduled overtime expense for an assignment.
|
| AssignmentRemainingOvertimeWork | number | The amount of overtime work that remains on an assignment. |
| AssignmentRemainingWork | number | The amount of time required by a resource assigned to a task to complete an assignment.
|
| AssignmentResourceID | number | Refers to a valid ID in the Resources table.
|
| AssignmentResourceName | text | The name of the resource associated with the assignment. |
| AssignmentResourceType | number | The resource type:
| 0 |
Work (default) (people and equipment) |
| 1 |
Material (consumable supplies like steel, concrete, or soil) |
|
| E | AssignmentResourceRequestType | number | The type of request:
| 0 |
None (default) |
| 1 |
Request |
| 2 |
Demand |
|
| AssignmentResponsePending | Boolean | Indicates whether an answer has been received from a message sent to a resource assigned to a task notifying the resource of the assignment. |
| AssignmentStart | date | The date and time that an assigned resource is scheduled to begin working on a task.
|
| AssignmentStart1-10 | date | Custom start date information.
|
| AssignmentStartVariance | number | The difference between an assignment's baseline start date and its currently scheduled start date.
|
| AssignmentSummary | number | Indicates whether the assignment is part of a summary task.
|
| AssignmentSV | number | The difference in cost between the current progress and the baseline plan of the assignment up to the status date or today's date.
|
| AssignmentTaskID | number | Refers to a valid ID in the Tasks table.
|
| AssignmentTaskName | text | The name of the task associated with the assignment.
|
| AssignmentTaskSummaryName | text | The name of the summary task for the task associated with the assignment.
|
| AssignmentTeamStatusPending | Boolean | Indicates 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-30 | text | Custom text information.
|
| AssignmentUnits | number | The 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%. |
| AssignmentUpdateNeeded | number | Indicates 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. |
| AssignmentVAC | number | The variance at completion (VAC) between the baseline cost and the total cost for an assignment on a task.
|
| AssignmentWork | number | The total amount of work scheduled to be performed by a resource on a task. |
| AssignmentWorkContour | number | Indicates 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 |
|
| AssignmentWorkVariance | number | The difference between an assignment's baseline work and the currently scheduled work.
|
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 Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| AssignmentUniqueID | number | The unique ID for the assignment. |
| AssignmentTimeStart | date | The date and time that an assigned resource is scheduled to begin working on a task. |
| AssignmentTimeFinish | date | The date and time that an assigned resource is scheduled to complete work on a task. |
| AssignmentTimeActualCost | number | Shows costs incurred for work already performed by a resource on a task. |
| AssignmentTimeActualOvertimeWork | number | The actual amount of overtime work already performed by a resource on an assigned task. |
| AssignmentTimeActualWork | number | The amount of work that has already been done by a resource on a task. |
| AssignmentTimeACWP | number | The costs incurred for work already performed by a resource on a task, up to the project status date or today's date. |
| AssignmentTimeBaselineCost | number | Specifies the total planned cost for work to be performed by a resource on a task. |
| AssignmentTimeBaseline1Cost-10 | number | Custom baseline cost information. |
| AssignmentTimeBaselineFinish | number | The planned completion date for an assignment at the time a baseline is saved. |
| AssignmentTimeBaseline1Finish-10 | number | Custom baseline finish information.
|
| AssignmentTimeBaselineStart | number | The planned beginning date for an assignment at the time a baseline is saved. |
| AssignmentTimeBaseline1Start-10 | number | Custom baseline start information.
|
| AssignmentTimeBaselineWork | number | The originally planned amount of work to be performed by a resource on a task. |
| AssignmentTimeBaseline1Work-10 | number | Custom baseline work information.
|
| AssignmentTimeBCWP | number | The 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. |
| AssignmentTimeBCWS | number | The cumulative timephased baseline costs of an assignment up to the status date or today's date. |
| AssignmentTimeCost | number | The 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. |
| AssignmentTimeCumulativeCost | number | The 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. |
| AssignmentTimeCumulativeWork | number | The total amount of work scheduled to be performed by a resource on a task. |
| AssignmentTimeCV | number | The 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. |
| AssignmentTimeOvertimeWork | number | The amount of overtime to be performed by a resource on a task; charged at the resource's overtime rate. |
| AssignmentTimePeakUnits | number | The maximum percentage of units for which a resource is assigned to a task for a given period of time. |
| AssignmentTimePercentAllocation | number | The percentage that represents the amount of a resource's capacity being allocated to a specific assignment. |
| AssignmentTimeRegularWork | number | The total amount of non-overtime work scheduled to be performed by a resource assigned to a task. |
| AssignmentTimeSV | number | The difference in cost between the current progress and the baseline plan of the assignment up to the status date or today's date.
|
| AssignmentTimeWork | number | The total amount of time for work scheduled to be performed by a resource on a task. |
This table stores baseline split information for a specific task.
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.
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.
This table is used to get the lookup table values for custom fields that have a value list.
This table contains the mask for each of the custom outline code lookup tables.
This table is used to get a list of lookup table values for custom outline code fields.
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 Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| ProjectUniqueID | number | The unique ID for the project. |
| ProjectAuthor | text | The name of the author of the project; used to group similar projects together. |
| ProjectCalendarName | text | The name of the calendar associated with the project.
|
| ProjectCategory | text | The category the project belongs to; used to group similar projects together.
|
| ProjectCompany | text | The name of the company that created the project; used to group similar projects together. |
| ProjectCreationDate | date | The date the project was created.
|
| ProjectCriticalSlackLimit | number | The number of days past its end date that a task can go before Microsoft Project marks that task as a critical task.
|
| ProjectCurrencyDigits | number | The 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 |
|
| ProjectCurrencyPosition | number | 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 $ |
|
| ProjectCurrencySymbol | text | The current symbol used to represent the type of currency used in the project. |
| ProjectCurrentDate | date | The current date for a project. |
| ProjectDaysPerMonth | number | The default number of working days per month. |
| ProjectDefaultFinishTime | number | The default finish time for all new tasks. |
| ProjectDefaultFixedCostAccrual | Boolean | Indicates whether fixed costs are accrued.
|
| ProjectDefaultOvertimeRate | text | The default overtime rate of pay for new resources. See ResourceOvertimeRate.
|
| ProjectDefaultStandardRate | text | The default rate of pay
for new resources. See ResourceStandardRate. |
| ProjectDefaultStartTime | number | The default start time for all new tasks.
|
| ProjectDefaultTaskType | number | The 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 |
|
| ProjectDurationFormat | number | The default format for all durations in the project:
| 0 |
minute |
| 1 |
hour (default) |
| 2 |
day |
| 3 |
week |
| 4 |
month |
|
| ProjectEditableActualCosts | Boolean | Indicates whether Microsoft Project automatically calculates actual costs. |
| E | ProjectEnterpriseCost1-10 | number | Enterprise custom project cost information. |
| E | ProjectEnterpriseCost1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseDate1-30 | number | Enterprise custom date information.
|
| E | ProjectEnterpriseDate1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseDuration1- 10 | number | Enterprise custom duration information.
|
| E | ProjectEnterpriseDuration1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | ProjectEnterpriseFlag1-20 | number | Enterprise custom flag information.
|
| E | ProjectEnterpriseFlag1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseName | text | The name of the project in the Microsoft Project Server database. |
| E | ProjectEnterpriseNumber1-40 | number | Enterprise custom number information. |
| E | ProjectEnterpriseNumber1Indicator-40 | number | The indicator symbol for the corresponding enterprise custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseOutlineCode1-30ID | number | Enterprise custom outline code information.
|
| E | ProjectEnterpriseOutlineCode1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseText1-40 | number | Enterprise custom text information.
|
| E | ProjectEnterpriseText1Indicator-40 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ProjectEnterpriseVersion | number | The version of the project for projects in the Microsoft Project Server database.
|
| ProjectExpandTimephased | Boolean | Indicates whether Microsoft Project saves timephased data in a readable or binary format when a project is saved to a database. |
| ProjectFinishDate | date | The date and time that a project is scheduled for completion.
|
| ProjectFYStart | number | The 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 |
|
| ProjectHonorConstraints | Boolean | Indicates whether Microsoft Project schedules tasks according to their constraint date instead of any task dependencies.
|
| ProjectInsertedProjectsLikeSummary | Boolean | Indicates whether inserted projects are treated as summary tasks rather than as separate projects for schedule calculation.
|
| ProjectIsResourcePool | Boolean | Indicates whether the projectonly its own resources, or whether it shares its resources with another project or from a resource pool; see ProjectPoolAttachedTo. |
| ProjectKeywords | text | Lists keywords associated with the project; used to group similar projects together.
|
| ProjectLastSaved | date | The date the project was last saved.
|
| ProjectManager | text | The manager of the project; used to group projects with the same manager together.
|
| ProjectMinsPerDay | number | The default number of minutes per day.
|
| ProjectMinsPerWeek | number | The default number of minutes per week.
|
| ProjectMultipleCriticalPaths | Boolean | Indicates whether Microsoft Project calculates and displays a critical path for each independent network of critical tasks within a project.
|
| ProjectNewTasksEffortDriven | Boolean | Indicates whether new tasks are effort-driven. |
| ProjectNewTasksEstimated | Boolean | Indicates whether new tasks have
estimated durations. |
| ProjectPoolAttachedTo | text | The name of the project file that shares resources
with this project file; required if ProjectIsResourcePool is set to True. |
| ProjectRevision | text | The current revision number for the project file. |
| ProjectSavePreviewPicture | Boolean | Indicates whether Microsoft Project saves a picture of a project for preview.
|
| ProjectScheduledFromStart | Boolean | Indicates whether a project is scheduled from the project start date (default) or the project finish date.
|
| ProjectShowEstimatedDurations | Boolean | Indicates whether Microsoft Project displays a ? after the duration of any task with an estimated duration.
|
| ProjectSplitInProgressTasks | Boolean | Indicates whether in-progress tasks may be split. |
| ProjectSpreadActualCosts | Boolean | Indicates whether actual costs are spread to the status date.
|
| ProjectSpreadPercentComplete | Boolean | Indicates whether percent complete is spread to the status date.
|
| ProjectStartDate | date | The date and time that a project is scheduled to begin.
|
| ProjectStatusDate | date | The project status date.
|
| ProjectSubject | text | The subject of the project; used to group similar projects together.
|
| ProjectTaskUpdatesResource | Boolean | Indicates whether Microsoft Project automatically calculates actual and remaining work and costs as you enter task percent complete information in your schedule.
|
| ProjectTitle | text | The title of the project; used to group similar projects together.
|
| ProjectWorkFormat | number | The default format for all work durations in the project:
| 0 |
minute |
| 1 |
hour (default) |
| 2 |
day |
| 3 |
week |
| 4 |
month |
|
This table contains information related to resources.
| | Column Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| E | ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| ResourceUniqueID | number | The unique ID for the resource. |
| ResourcePercentWorkComplete | number | The current status of all tasks assigned to a resource, expressed as the total percentage of the resource's work that has been completed. |
| ResourceAccrueAt | number | Indicates 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. |
|
| ResourceActualCost | number | The sum of costs incurred for the work already performed by a resource for all assigned tasks.
|
| ResourceActualOvertimeCost | number | The cost incurred for overtime work already performed by a resource for all assigned tasks.
|
| ResourceActualOvertimeWork | number | The actual amount of overtime work already performed for all assignments assigned to a resource.
|
| ResourceActualWork | number | The actual amount of work that has already been done for all assignments assigned to a resource. |
| ResourceACWP | number | The 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. |
| ResourceAvailableFrom | date | The starting date that a resource is available for work at the units specified for the current time period. |
| ResourceAvailableTo | date | The ending date in which a resource will be available for work at the units specified for the current time period. |
| ResourceBaseCalendar | text | Lists all calendars available to be applied to a resource, including the standard calendar and any custom calendars:
| 0 |
Standard (default) |
| 1+ |
Custom calendar |
|
| ResourceBaselineCost | number | The total planned cost for a resource for all assigned tasks; also called budget at completion (BAC).
|
| ResourceBaseline1Cost-10 | number | Custom baseline cost information.
|
| ResourceBaselineFinish | number | The planned finish date for assignments. |
| ResourceBaseline1Finish-10 | number | Custom baseline finish information.
|
| ResourceBaselineStart | number | The planned beginning date for assignments.
|
| ResourceBaseline1Start-10 | number | Custom baseline start information.
|
| ResourceBaselineWork | number | The originally planned amount of work to be performed for all assignments assigned to a resource.
|
| ResourceBaseline1Work-10 | number | Custom baseline work information.
|
| ResourceBCWP | number | The 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.
|
| ResourceBCWS | number | The rolled-up summary of a resource's BCWS values for all assigned tasks; also called budgeted cost of work scheduled.
|
| ResourceCanLevel | Boolean | Indicates whether resource leveling can be done for a resource.
|
| ResourceCode | text | A code, abbreviation, or number entered as part of a resource's information. |
| ResourceConfirmed | Boolean | Indicates whether a resource has accepted or rejected all task assignments in response to a message assigning tasks to the resource.
|
| ResourceCost | number | The 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-10 | number | Custom cost information. |
| E | ResourceCost1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| ResourceCostPerUse | number | The cost that accrues each time a resource is used. |
| ResourceCostVariance | number | The difference between the baseline cost and total cost for a resource.
|
| ResourceCV | number | The 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-10 | date | Custom date information.
|
| E | ResourceDate1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| ResourceDuration1-10 | number | Custom duration information.
|
| E | ResourceDuration1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| ResourceEmailAddress | text | The 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.
|
| E | ResourceEnterpriseCost1-10 | number | Enterprise custom resource cost information. |
| E | ResourceEnterpriseCost1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ResourceEnterpriseDate1-30 | number | Custom enterprise-level date information. |
| E | ResourceEnterpriseDate1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ResourceEnterpriseDuration1-10 | number | Enterprise custom duration information. |
| E | ResourceEnterpriseDuration1-10Indicator | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | ResourceEnterpriseFlag1-20 | number | Custom enterprise-level flag information. |
| E | ResourceEnterpriseFlag1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ResourceEnterpriseGeneric | Boolean | Indicates whether the resource is a generic resource. |
| E | ResourceEnterpriseNumber1-40 | number | Enterprise custom number information. |
| E | ResourceEnterpriseNumber1Indicator-40 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | ResourceEnterpriseOutlineCode1-30ID | number | Enterprise custom outline code information. |
| E | ResourceEnterpriseOutlineCode1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ResourceEnterpriseText1-40 | number | Enterprise custom text information. |
| E | ResourceEnterpriseText1Indicator-40 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | ResourceEnterpriseUniqueID | number | The unique ID for the enterprise resource. |
| ResourceFinish | date | The date and time that a resource is scheduled to complete work on all assigned tasks.
|
| ResourceFinish1-10 | date | Custom finish date information.
|
| E | ResourceFinish1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| ResourceFlag1-20 | Boolean | Indicates whether a resource is marked for further action or identification of some kind.
|
| E | ResourceFlag1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| ResourceGroup | text | The name of the group a resource belongs to. |
| ResourceHyperlink | text | The title or explanatory text for a hyperlink associated with a resource.
|
| ResourceHyperlinkAddress | text | The address for a hyperlink associated with a resource.
|
| ResourceHyperlinkHref | text | The combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a resource.
|
| ResourceHyperlinkScreenTip | text | The text contained in a ScreenTip associated with a hyperlink.
|
| ResourceHyperlinkSubAddress | text | The specific location in a document within a hyperlink associated with a resource.
|
| ResourceID | number | Indicates the position of a resource in relation to other resources.
|
| ResourceInitials | text | The abbreviation for a resource name. |
| ResourceIsNull | Boolean | Indicates whether the resource is a null resource.
|
| ResourceLinkedFields | Boolean | Indicates whether there are OLE links to the resource, from elsewhere in the active project, another Microsoft Project file, or from another program.
|
| ResourceMaterialLabel | text | The 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. |
| ResourceMaxUnits | number | The 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) |
|
| ResourceName | text | The name of the resource; must be unique within Microsoft Project Server, whether the resource is active. |
| ResourceNotes | text | Notes about a resource.
|
| ResourceNTAccount | text | The Windows NT account name for a resource; for example, domain name\user name.
|
| ResourceNumber1-20 | number | Custom numeric information. |
| E | ResourceNumber1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| ResourceObjects | number | The number of objects associated with a resource, not including those in notes. |
| ResourceOutlineCode1-10 | text | An alphanumeric code defined to represent a hierarchical structure of resources.
|
| ResourceOverallocated | Boolean | Indicates whether a resource is assigned to do more work on all assigned tasks than can be done within the resource's normal work capacity.
|
| ResourceOvertimeCost | number | The total overtime cost for a resource on all assigned tasks.
|
| ResourceOvertimeRate | text | The rate of pay for overtime work performed by a resource. |
| ResourceOvertimeWork | number | The amount of overtime to be performed for all tasks assigned to a resource and charged at the resource's overtime rate.
|
| ResourcePeakUnits | number | The maximum percentage, or number of units, that a resource is assigned at any one time for all tasks assigned to the resource.
|
| ResourcePhonetics | text | Contains phonetic information in either Hiragana or Katakana for resource names; used only in the Japanese version of Microsoft Project.
|
| ResourceRegularWork | number | The total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource.
|
| ResourceRemainingCost | number | The remaining scheduled expense that will be incurred in completing the remaining work assigned to a resource.
|
| ResourceRemainingOvertimeCost | number | The 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.
|
| ResourceRemainingOvertimeWork | number | The remaining amount of overtime required by a resource to complete all tasks.
|
| ResourceRemainingWork | number | The amount of time, or person-hours, still required by a resource to complete all assigned tasks.
|
| ResourceResponsePending | Boolean | Indicates whether an answer has been received from all messages sent to a resource about assigned tasks.
|
| ResourceStandardRate | text | The rate of pay for regular, non-overtime work performed by a resource. |
| ResourceStart | date | The date and time that an assigned resource is scheduled to begin working on all assigned tasks.
|
| ResourceStart1-10 | date | Custom start date information. |
| E | ResourceStart1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| ResourceSV | number | The 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-30 | text | Custom text information.
|
| E | ResourceText1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| ResourceTeamStatusPending | Boolean | Indicates whether an answer has been received in response to a message requesting progress information sent to a resource about an assigned task. |
| ResourceType | number | The resource type (Work or Material):
| 0 |
Work (default) (people and equipment) |
| 1 |
Material (consumable supplies like steel, concrete, or soil) |
|
| ResourceUpdateNeeded | Boolean | Indicates whether a message should be sent to a resource because of changes to any of the resource's assigned tasks.
|
| ResourceVAC | number | The difference between the baseline cost and the total cost for a resource.
|
| ResourceWork | number | The total amount of work scheduled to be performed by a resource on all assigned tasks. |
| ResourceWorkgroup | text | The 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 |
|
| ResourceWorkVariance | number | The difference between a resource's total baseline work and the currently scheduled work.
|
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 Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| ResourceUniqueID | number | Refers to a valid ID in the Resources table. |
| ResourceEnterpriseUniqueID | number | Refers to a valid enterprise ID in the Resources table. |
| ResourceTimeStart | date | The date and time that an assigned resource is scheduled to begin working on all assigned tasks. |
| ResourceTimeFinish | date | The date and time that an assigned resource is scheduled to finish working on all assigned tasks. |
| ResourceTimeActualCost | number | The timephased costs incurred for work already performed by a resource for all assigned tasks. |
| ResourceTimeActualOvertimeWork | number | The actual amount of overtime work already performed for all assignments assigned to a resource. |
| ResourceTimeActualWork | number | The amount of work that has already been done for all assignments assigned to a resource. |
| ResourceTimeACWP | number | The timephased sum of ACWP (actual cost of work performed) values for all of a resource's assignments. |
| ResourceTimeBaselineCost | number | The baseline cost for this resource; also called budget at completion. |
| ResourceTimeBaseline1Cost-10 | number | Custom baseline cost information. |
| ResourceTimeBaselineFinish | number | The planned finish date for assignments. |
| ResourceTimeBaseline1Finish-10 | number | Custom baseline finish information. |
| ResourceTimeBaselineStart | number | The planned beginning date for assignments. |
| ResourceTimeBaseline1Start-10 | number | Custom baseline start information. |
| ResourceTimeBaselineWork | number | The originally planned amount of work to be performed for all assignments assigned to a resource. |
| ResourceTimeBaseline1Work-10 | number | Custom baseline work information. |
| ResourceTimeBCWP | number | The timephased rolled-up summary of a resource's BCWP (budgeted cost of work performed) values for all assigned tasks. |
| ResourceTimeBCWS | number | The cumulative BCWS (budgeted cost of work scheduled) for the resource. |
| ResourceTimeCost | number | The scheduled timephased cost for a resource for all assigned tasks. |
| ResourceTimeCumulativeCost | number | The 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. |
| ResourceTimeCumulativeWork | number | The total work, or person-hours, for a resource, as accumulated over time. |
| ResourceTimeCV | number | The 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. |
| ResourceTimeOverallocation | number | The amount of work, as distributed over time, that a resource is overallocated for all assigned tasks. |
| ResourceTimeOvertimeWork | number | The amount of overtime to be performed for all assignments assigned to a resource and charged at the resource's overtime rate. |
| ResourceTimePeakUnits | number | The percentage, or number of units, to which a resource is assigned at any one time for all assigned tasks. |
| ResourceTimePercentAllocation | number | The percentage of a resource's total work capacity that is allocated to all assigned tasks. |
| ResourceTimeRegularWork | number | The total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource. |
| ResourceTimeRemainingAvailability | number | The amount of time remaining that a resource will be available to work during a particular time period. |
| ResourceTimeSV | number | The difference in cost between the current plan and the baseline progress of all the resource's assigned tasks. |
| ResourceTimeUnitAvailability | number | The percentage or number of maximum units that a work resource is available to accomplish any tasks during any selected time period.
|
| ResourceTimeWorkAvailability | number | The maximum amount of time a work resource is available to be scheduled for work during any selected time period. |
| ResourceTimeWork | number | The total amount of work scheduled to be performed by a resource on all assigned tasks. |
This table stores the information about the tasks that make up a project.
| | Column Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| E | ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| TaskUniqueID | number | The unique ID for the task. |
| TaskPercentWorkComplete | number | The current status of a task, expressed as the percentage of the task's work that has been completed.
|
| TaskActualCost | number | The costs incurred for work already performed by all resources on a task, along with any other recorded costs associated with the task.
|
| TaskActualDuration | number | The span of actual working time for a task so far, based on the scheduled duration and current remaining work or completion percentage. |
| TaskActualFinish | date | The date and time that a task actually finished.
|
| TaskActualOvertimeCost | number | The costs incurred for overtime work already performed on a task by all assigned resources.
|
| TaskActualOvertimeWork | number | The actual amount of overtime work already performed by all resources assigned to a task.
|
| TaskActualStart | number | The date and time that a task actually began. |
| TaskActualWork | number | The amount of work that has already been done by the resources assigned to a task.
|
| TaskACWP | number | The costs incurred for work already done on a task, up to the project status date or today's date.
|
| TaskBaselineCost | number | The total planned cost for a task; also referred to as budget at completion (BAC).
|
| TaskBaselineCost1-10 | number | Custom baseline cost information. |
| TaskBaselineDuration | number | The original span of time planned to complete a task.
|
| TaskBaselineDuration1-10 | number | Custom baseline duration information. |
| TaskBaselineDurationEstimated | Boolean | Indicates whether the baseline duration is estimated.
|
| TaskBaselineDurationEstimated1-10 | Boolean | Custom baseline estimated duration information. |
| TaskBaselineFinish | date | The planned completion date for a task at the time a baseline is saved.
|
| TaskBaselineFinish1-10 | number | Custom baseline finish information. |
| TaskBaselineStart | date | The planned beginning date for a task at the time a baseline is saved.
|
| TaskBaselineStart1-10 | number | Custom baseline start information.
|
| TaskBaselineWork | number | The originally planned amount of work to be performed by all resources assigned to a task.
|
| TaskBaselineWork1-10 | number | Custom baseline work information. |
| TaskBCWP | number | The 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.
|
| TaskBCWS | number | The cumulative timephased baseline costs up to the status date or today's date.
|
| TaskCalendar | text | Lists all calendars available to be applied to a task, including the standard calendar and any custom calendars:
| 0 |
Standard (default) |
| 1+ |
Custom calendar |
|
| TaskCompleteThrough | date | The progress of a task on the Gantt Chart, up to the point that actuals have been reported for the task. |
| TaskConfirmed | Boolean | Indicates whether all resources assigned to a task have accepted or rejected the task assignment in response to a message assigning a task.
|
| TaskConstraintDate | date | Indicates 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.
|
| TaskConstraintType | number | The 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 |
|
| TaskContact | text | The name of the individual who is responsible for a task. |
| TaskCost | number | The 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-10 | number | Custom cost information. |
| E | TaskCost1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| TaskCostVariance | number | The difference between the baseline cost and the total cost for a task.
|
| TaskCPI | number | The cost performance index, or the ratio of budget to actual cost. |
| TaskCreated | date | The date and time that a task was added to a project. |
| TaskCritical | Boolean | Indicates whether a task has room in the schedule to slip, or if it is on the critical path. |
| TaskCV | number | The 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. |
| TaskCVP | number | The cost variance percentage for a task. |
| TaskDate1-10 | date | Custom date information. |
| E | TaskDate1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| TaskDeadline | date | The date entered as a deadline for the task.
|
| TaskDuration | number | The total span of active working time for a task. |
| TaskDuration1-10 | number | Custom duration information. |
| E | TaskDuration1Estimated-10 | Boolean | Indicates whether the corresponding TaskDuration1-10 field is estimated.
|
| E | TaskDuration1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| TaskDurationElapsed | number | Indicates which field is used to base BCWP values on. |
| TaskDurationVariance | number | The difference between the baseline duration of a task and the total duration (current estimate) of a task.
|
| E | TaskEnterpriseCost1-10 | number | Custom enterprise-level cost information. |
| E | TaskEnterpriseCost1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| E | TaskEnterpriseDate1-30 | number | Custom enterprise-level date information. |
| E | TaskEnterpriseDate1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | TaskEnterpriseDuration1-10 | number | Custom enterprise-level duration information. |
| E | TaskEnterpriseDuration1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | TaskEnterpriseFlag1-20 | number | Custom enterprise-level flag information. |
| E | TaskEnterpriseFlag1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | TaskEnterpriseNumber1-40 | number | Custom enterprise-level number information. |
| E | TaskEnterpriseNumber1Indicator-40 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| E | TaskEnterpriseOutlineCode1-30ID | number | Custom enterprise-level outline code information. |
| E | TaskEnterpriseText1-40 | number | Custom enterprise-level text information. |
| E | TaskEnterpriseText1Indicator-40 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| TaskEarlyFinish | date | The earliest date that a task could possibly finish, based on early finish dates of predecessor and successor tasks, other constraints, and any leveling delay.
|
| TaskEarlyStart | date | The
earliest date that a task could possibly begin, based on the early start dates of predecessor and successor tasks, and other constraints. |
| TaskEffortDriven | Boolean | Indicates whether scheduling for a task is effort-driven.
|
| TaskEstimated | Boolean | Indicates whether the task's duration is flagged as an estimate.
|
| TaskExternalTask | Boolean | Indicates whether the task is linked from another project or whether it originated in the current project.
|
| TaskEAC | number | The total scheduled or projected cost for a task based on costs already incurred, in addition to the costs planned for remaining work.
|
| TaskFinish | date | The date and time that a task is scheduled to be completed. |
| TaskFinish1-10 | date | Custom finish date information. |
| E | TaskFinish1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information. |
| TaskFinishSlack | number | The duration between the early finish and late finish dates.
|
| TaskFinishVariance | number | The amount of time that represents the difference between a task's baseline finish date and its current finish date.
|
| TaskFixedCost | number | A task expense that is not associated with a resource cost.
|
| TaskFixedCostAccrual | number | Indicates 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-20 | Boolean | Custom flag information.
|
| E | TaskFlag1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| TaskFreeSlack | number | The 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. |
| TaskHideBar | Boolean | Indicates whether the Gantt bars and Calendar bars for a task are hidden.
|
| TaskHyperlink | text | The title or explanatory text for a hyperlink associated with a task.
|
| TaskHyperlinkAddress | text | The address for a hyperlink associated with a task.
|
| TaskHyperlinkHref | text | The combination, or concatenation, of the hyperlink address and hyperlink subaddress fields associated with a task.
|
| TaskHyperlinkScreenTip | text | The text contained in a ScreenTip associated with a hyperlink.
|
| TaskHyperlinkSubAddress | text | The specific location in a document within a hyperlink associated with a task.
|
| TaskID | number | Indicates the position of a task in relation to other tasks.
|
| TaskIgnoreResourceCalendar | Boolean | Indicates whether the scheduling of the task takes into account the calendars of the resources assigned to the task.
|
| TaskIsNull | Boolean | Indicates whether a task is a null task.
|
| TaskLateFinish | date | The latest date that a task can finish without delaying the finish of the project. |
| TaskLateStart | date | The latest date that a task can start without delaying the finish of the project. |
| TaskLevelAssignments | Boolean | Indicates whether the leveling function can delay and split individual assignments (rather than the entire task) to resolve overallocations. |
| TaskLevelingCanSplit | Boolean | Indicates whether the resource leveling function can split remaining work on a task. |
| TaskLevelingDelay | number | The amount of time that a task is to be delayed from its early start date as a result of resource leveling.
|
| TaskLinkedFields | Boolean | Indicates whether there are OLE links to a task, from elsewhere in the active project, another Microsoft Project file, or from another program.
|
| TaskMarked | Boolean | Indicates whether a task is marked for further action or identification of some kind.
|
| TaskMilestone | Boolean | Indicates whether a task is a milestone.
|
| TaskName | text | The name of a task. |
| TaskNotes | text | Notes entered about a task.
|
| TaskNumber1-20 | number | Custom numeric information. |
| E | TaskNumber1Indicator-20 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| TaskObjects | number | The number of objects attached to a task.
|
| TaskOutlineCode1-10 | text | An alphanumeric code that represents a hierarchical structure of tasks.
|
| TaskOutlineLevel | number | The number that indicates the level of a task in the project outline hierarchy.
|
| TaskOutlineNumber | text | 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.
|
| TaskOverallocated | Boolean | Indicates 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. |
| TaskOvertimeCost | number | The actual overtime cost for a task.
|
| TaskOvertimeWork | number | The amount of overtime scheduled to be performed by all resources assigned to a task and charged at overtime rates.
|
| TaskPercentComplete | number | The current status of a task, expressed as the percentage of the task's duration that has been completed. |
| TaskPredecessors | text | The task ID numbers for the predecessor tasks to this task. |
| TaskPreleveledFinish | date | The finish date of a task as it was before resource leveling was done.
|
| TaskPreleveledStart | date | The start date of a task as it was before resource leveling was done.
|
| TaskPriority | number | Indicates 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 |
|
| TaskRecurring | Boolean | Indicates whether a task is a recurring task.
|
| TaskRegularWork | number | The total amount of non-overtime work scheduled to be performed by all resources assigned to a task. |
| TaskRemainingCost | number | The remaining scheduled expense of a task that will be incurred in completing the remaining scheduled work by all resources assigned to a task.
|
| TaskRemainingDuration | number | The 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). |
| TaskRemainingOvertimeCost | number | The remaining scheduled overtime expense for a task.
|
| TaskRemainingOvertimeWork | number | The amount of remaining overtime scheduled by all assigned resources to complete a task.
|
| TaskRemainingWork | number | The amount of time still required by all assigned resources to complete a task.
|
| TaskResourceGroup | text | The list of resource groups to which the resources assigned to a task belong.
|
| TaskResourceInitials | text | Lists the abbreviations for the names of resources assigned to a task.
|
| TaskResourceName | text | Lists the names of all resources assigned to a task.
|
| TaskResourcePhonetics | text | Contains information in either Hiragana or Katakana for the names of resources assigned to a task; used only in the Japanese version of Microsoft Project. |
| TaskResponsePending | Boolean | Indicates whether an answer has been received from all messages sent to the resources assigned to a task notifying them of the assignments.
|
| TaskResume | date | The date the remaining portion of a task is scheduled to resume after you enter a new value for the Percent (%) Complete field is entered.
|
| TaskRollup | Boolean | Indicates 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. |
| TaskSPI | number | The schedule performance index or the ratio of performed to scheduled work.
|
| TaskStart | date | The date and time that a task is scheduled to begin; this value is automatically calculated if a task has a predecessor. |
| TaskStart1-10 | date | Custom start date information.
|
| E | TaskStart1Indicator-10 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| TaskStartSlack | number | The amount of time a task can be delayed without affecting the start date of a successor task or the project finish date.
|
| TaskStartVariance | number | The difference between a task's baseline start date and its currently scheduled start date.
|
| TaskStop | date | The date that represents the end of the actual portion of a task; contains NA until you enter actual work or a percent complete. |
| TaskStatus | | The current status of a task.
|
| TaskSubprojectFile | text | The name of a project inserted into the active project file including the subproject's path and file name.
|
| TaskSubprojectReadOnly | Boolean | Indicates whether the subproject of this task is a read-only project.
|
| TaskSuccessors | text | The task ID numbers for the successor tasks to this task. |
| TaskSummary | Boolean | Indicates whether a task is a summary task. |
| TaskSummaryProgress | number | The progress on a summary task, based on the progress of its subtasks.
|
| TaskSV | number | The 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.
|
| TaskSVP | number | The schedule variance percentage (SVP) for a task.
|
| TaskTCPI | number | The to complete performance index (TCPI) for a task.
|
| TaskTeamStatusPending | Boolean | Indicates whether an answer has been received in response to a message requesting progress information sent to the resources assigned to a task.
|
| TaskText1-30 | text | Custom text information.
|
| E | TaskText1Indicator-30 | number | The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
|
| TaskTotalSlack | number | The amount of time a task can be delayed without delaying a project's finish date. |
| TaskType | number | Indicates 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 |
|
| TaskUniqueIDPredeccessors | text | The 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. |
| TaskUniqueIDSuccessors | text | The 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. |
| TaskUpdateNeeded | Boolean | Indicates whether a message should be sent to the assigned resources notifying them of changes to the start date, finish date, or reassignments of tasks.
|
| TaskVAC | number | The difference between the baseline cost and the total cost for a task; also called variance at completion (VAC).
|
| TaskWBS | text | A unique code (WBS) used to represent a task's position within the hierarchical structure of the project. |
| TaskWBSPredecessors | text | The WBS codes associated with a predecessor task that the task depends on before it can start or finish. |
| TaskWBSSuccessors | text | Lists the WBS codes associated with the successor tasks.
|
| TaskWork | number | The total amount of work scheduled to be performed on a task by all assigned resources.
|
| TaskWorkVariance | number | The difference between a task's baseline work and the currently scheduled work.
|
This table stores the start and finish dates for a task split.
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 Name | Data Type | Description |
| Project | text | The name of the project, shown as the path to the location, for example: C:\pathname\MyProject.mpp. |
| ProjectUniqueID | number | Refers to a valid ID in the Project table. |
| TaskUniqueID | number | Refers to a valid ID in the Tasks table. |
| TaskTimeStart | date | The date and time that a task is scheduled to begin. |
| TaskTimeFinish | date | The date and time that a task is scheduled to be completed. |
| TaskTimeActualCost | number | The costs incurred for work already performed by all resources on a task, along with any other recorded costs associated with the task. |
| TaskTimeActualOvertimeWork | number | The actual amount of overtime work already performed by all resources assigned to a task. |
| TaskTimeActualWork | number | The amount of work that has already been done by the resources assigned to a task. |
| TaskTimeACWP | number | The costs incurred for work already done on a task, up to the project status date or today's date. |
| TaskTimeBaselineCost | number | The total planned cost for a task; also referred to as budget at completion (BAC). |
| TaskTimeBaseline1Cost-10 | number | Custom baseline cost information. |
| TaskTimeBaselineFinish | number | The planned completion date for a task at the time a baseline is saved. |
| TaskTimeBaseline1Finish-10 | number | Custom baseline finish information. |
| TaskTimeBaselineStart | number | The planned beginning date for a task at the time a baseline is saved. |
| TaskTimeBaseline1Start-10 | number | Custom baseline start information. |
| TaskTimeBaselineWork | number | The amount of work originally planned to be performed by all resources assigned to a task. |
| TaskTimeBaseline1Work-10 | number | Custom baseline work information. |
| TaskTimeBCWP | number | The 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.
|
| TaskTimeBCWS | number | The cumulative timephased baseline costs up to the status date or today's date. |
| TaskTimeCost | number | The 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).
|
| TaskTimeCumulativeCost | number | The total cost for a task. |
| TaskTimeCumulativeWork | number | The total work, or person-hours, for a task. |
| TaskTimeCV | number | The 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. |
| TaskTimeFixedCost | number | A task expense that is not associated with a resource cost. |
| TaskTimeOvertimeWork | number | The amount of overtime scheduled to be performed by all resources assigned to a task and charged at the resources' overtime rates. |
| TaskTimeRegularWork | number | The total amount of non-overtime work scheduled to be performed by all resources assigned to a task. |
| TaskTimeSV | number | The 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.
|
| TaskTimeWork | number | The total amount of work scheduled to be performed on a task by all assigned resources.
|
| TaskTimeActualFixedCost | number | The actual timephased task expenses not related to resource costs, charged over time according to the selected cost accrual method. |
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).