Microsoft KB Archive/143482

PRJ98: Contents of the Database.wri File (Part 2 of 2)

PSS ID Number: Q143482 Article last modified on 09-29-1998

WINDOWS:98

WINDOWS

================================================================ ==

The information in this article applies to:

 == Microsoft Project 98 for Windows == 

= SUMMARY =

The “More Information” section of this article contains the “Microsoft Project Database Structure” section of the Database.wri file. To obtain part one, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q143481 TITLE : PRJ98: Contents of the Database.wri File (Part 1 of 2)

NOTE: The Database.wri file is located in the Office folder on the Microsoft Project 98 compact disc.

= MORE INFORMATION =

Microsoft Project Database Format August 1997 (C) 1997 Microsoft Corporation. All rights reserved.

Contents
Microsoft Project Database Structure - Export-Only Fields - How Calendar Information is Stored - How External Project Links are Stored - Field Types - Project_Information Table - Task_Information Table - Resource_Information Table - Assignment_Information Table - Calendars Table - Calendar_Working_Times Table - Calendar_Exceptions Table - Task_Dependencies Table - Assignment_Remaining_Work Table - Assignment_Actual_Work Table - Assignment_Actual_Ovt_Work - Assignment_Actual_Exceptions Table - Assignment_Baseline_Cost Table - Assignment_Baseline_Work Table - Assignment_Actual_Cost Table - Resource_Rates Table - Resource_Baseline_Work Table - Resource_Baseline_Cost Table - Task_Baseline_Work Table - Task_Baseline_Cost Table - Task_Percent_Complete Table - Task_Baseline_Interim_Splits Table - Text_Fields Table - Custom_Number_Fields Table - Custom_Date_Fields Table - Custom_Duration_Fields Table Format - Intl_FieldReferences Table - Intl_TextConversions Table - Reserved_CommandBars Table - Reserved_ExternalDataLinks Table - Reserved_ImportExportMaps Table - Reserved_Filters Table - Reserved_Modules Table - Reserved_Reports Table - Reserved_Tables Table - Reserved_CustomForms Table - Reserved_V_iews Table - Reserved_AssignmentPoolInfo Table

Microsoft Project Database Structure
Export-Only Fields:

Some fields contain data that is written by Microsoft Project upon exporting to a database, but is not read while importing project data into Microsoft Project. Usually, this data is the result of calculations or settings in Microsoft Project. If you edit this data directly in the database, the changes will not be reflected when you import the data in Microsoft Project. These fields are indicated as “Export-Only” in the table descriptions.

How Calendar Information is Stored:

Microsoft Project saves calendar information for a project into three different tables. The Calendars table contains the information which identifies the calendar, and the resources for which it is a base calendar. The Calendar_Working_Times table contains the working and non-working time information for each day of the week, and the shift start and finish times. The Calendar_Exceptions table contains any exceptions to the work schedule defined in the calendar, such as vacations and holidays. For more information, see the detailed descriptions of each table below.

How External Project Links are Stored:

Microsoft Project saves information about links to external projects in the CrossProjectLink field in the Task_Dependencies table and ExternalTask field in the Task_Information table. The CrossProjectLink field indicates that there is a cross-project link, and the ExternalTask field indicates that the task in an external task, These fields are read-only and should not edited. You can’t create external project links directly in the database. You must create them in Microsoft Project.

Field Types:

The following field types are used in the Microsoft Project database structure. The field type for each field is indicated in the tables below.

Field Type Description

-

Number - Double Floating point number, in Oracle this is Number

Number - Long Long integer, in Oracle this is Number

Number - Integer Integer, in Oracle this is Number

Char Text, 255 characters unless otherwise indicated

Longtext Longest text field available, in Microsoft Access this is 64K, in Oracle this is 255 characters

Binary - Long Binary data, greater than 255 bytes

Binary - Short Binary data, less than 255 bytes

Number - Bit Boolean where supported, Integer in database where Boolean is not supported.

Date Date, including time

Where Microsoft Project needs to store a time value, but not a date value, it will store the project start date as a date, with the desired time value in a Date field. When you read the project from the database, the date values in these particular fields will be ignored.

The following tables detail the database structure that is created when you save a whole project to a database. The fields which are the key for each table are indicated in the Key column.

Project_Information Table:

This table contains Project level data. Project summary task information, such as duration and percent complete, is not saved in the Project_Information table, but rather in the Task_Information table under the UniqueID number 0.

Key/Field Export Name Field Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.

ProjectName Char No The project name. The project name together with the Data Source name can’t exceed 255 characters.

Author Longtext No The author of the project.

Category Longtext No The category of the project.

Company Longtext No The company name for the project.

CurrentDate Date Yes The current date in the project.

FinishDate Date No The project finish date.

Keywords Longtext No The keywords for the project.

LastSaved Date No The last date the project was saved.

Manager Longtext No The manager for the project.

OriginalFileName Longtext No The original file name of the project.

OriginalSave Date No The original save date of the project.

ProjectCalendarName Longtext No The name of the project calendar.

ResourcePool Number - Bit No Whether the project is a resource pool project or the sharer of a resource pool.

PoolFileName Char Yes The resource pool file name.

ScheduleFrom Number - Integer No Whether the project is scheduled from a start date or a finish date.

StartDate Date No The project start date.

StatusDate Date No The project status date.

Subject Longtext No The subject of the project.

Title Longtext No The title of the project.

Version Number - Long No The version of the project.

CurrencySymbol Char (20) No The currency symbol used in the project.

CurrencyPosition Number - Integer No The position of the currency symbol.

CurrencyDigits Number - Integer No The number of digits after the decimal, in currencies.

DefaultStandardRate Number - Double No The default standard rate for new resources.

DefaultOvertimeRate Number - Double No The default overtime rate for new resources.

DefaultTaskType Number - Integer No The default type of the task.

DefaultEffortDriven Number - Bit No Whether new tasks are effort driven by default.

UpdateTaskUpdateResource Number - Bit No Whether updates to tasks update resources.

SplitInProgressTasks Number - Bit No Whether in-progress tasks can be split.

HonorConstraints Number - Bit No Whether tasks honor their constraint dates.

DefaultFixedCostAccrual Number - Integer No The default accrual of task fixed costs.

SpreadPercentToStatus Number - Bit No Whether %Complete is spread to the status date.

SpreadActualCostsToStatus Number - Bit No Whether actual costs are spread to the status date.

AutoCalcActualCosts Number - Bit No Whether actual costs are calculated by Microsoft Project, or are entered by the user.

MultipleCriticalPaths Number - Bit No Whether multiple critical paths are calculated.

CriticalSlack Number - Long No Number of days slack is less than or equal for tasks to be critical.

DurationEnteredIn Number - Integer No The default duration unit.

WorkEnteredIn Number - Integer No The default work unit.

DefaultMinutesPerDay Number - Long No The default number of minutes per day.

DefaultMinutesPerWeek Number - Long No The default number of minutes per week.

DefaultStartTime Date - Time No The default start time of new tasks.

DefaultFinishTime Date - Time No The default finish time of new tasks.

Custom_Number_Field_Set Number - Bit No Whether the user edited a record in the Custom_Number_Fields table.

Custom_Duration_Field_Set Number - Bit No Whether the user edited a record in the Custom_Duration_Fields table.

Custom_Date_Field_Set Number - Bit No Whether the user edited a record in the Custom_Date_Fields table.

Text_Field_Set Number - Bit No Whether the user edited a record in the Text_Fields table.

Project_Locked Char (4) No Whether a user is writing to a table.

Project_ReadWrite Char (4) No Whether the project is open for write.

Reserved_LanguageID Number - Long Yes The language ID for the language in which the project is saved.

Reserved_NLSCodePage Number - Long Yes The NLS code page for the project.

Reserved_Project_FormatID Char (40) Yes The FormatID of the project - for use by future versions of Microsoft Project

Reserved_DataSourceName Char (128) Yes The Data Source Name for the project. Used when Microsoft Project checks for concurrent usage.

Reserved_Project_ReadOnly Char (10) Yes Whether the project is read- only.

Reserved_ReadCount Char (10) Yes How many users have one or more project tables open read-only.

Reserved_LastUpdateTimestamp Char (50) Yes Time of the last update made to the project.

UserMachineID Char (100) No Machine ID of the user who is opening the project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Task_Information Table:

This table contains task data. Microsoft Project will write 3 records to this table with UniqueIDs of -65536, -65535, -65534. These records are used internally by Microsoft Project. You should not edit or delete these records.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * TaskUniqueID Number - Long No The unique ID for the task in the project.

TaskID Number - Long No The task ID.

ActualCost Number - Double No The actual cost.

ActualDuration Number - Long No The actual duration.

ActualFinish Date No The actual finish date.

ActualFixedCost Number - Double No The actual fixed cost.

ActualOvertimeCost Number - Double No The actual overtime cost.

ActualOvertimeWork Number - Double No The actual amount of overtime work.

ActualStart Date No The actual start date.

ActualWork Number - Double No The actual amount of work.

ACWP Number - Double Yes Actual cost of work performed.

BaselineCost Number - Double No The baseline cost.

BaselineDuration Number - Long No The baseline duration.

BaselineDurationDisplayUnits Number - Integer No The units in which the baseline duration is displayed in Microsoft Project.

BaselineFinish Date No The baseline finish date.

BaselineStart Date No The baseline start date.

BaselineWork Number - Double No The amount of baseline work.

BCWP Number - Double Yes Budgeted cost of work performed.

BCWS Number - Double Yes Budgeted cost of work scheduled.

ConstraintDate Date No The constraint date.

ConstraintType Number - Integer No The constraint type.

Cost Number - Double No The cost.

Created Date No The date the task was created.

Critical Number - Bit No Whether the task is critical.

Duration Number - Long No The duration of the task.

DurationDisplayUnits Number - Integer No The units in which the duration is displayed in Microsoft Project.

DurationVariance Number - Long Yes The duration variance.

EarlyFinish Date No The early finish date.

EarlyStart Date No The early start date.

EffortDriven Number - Bit No Whether the task is effort driven.

ExternalTask Number - Bit Yes Whether this is an external task to which another task in this project is cross- project linked.

FinishDate Date No The task finish date.

FinishVariance Number - Long Yes The finish variance.

FixedCost Number - Double No The fixed cost.

FixedCostAccrual Number - Integer No The way fixed costs are accrued

Flag1 Number - Bit No Custom flag field.

Flag2 Number - Bit No Custom flag field.

Flag3 Number - Bit No Custom flag field.

Flag4 Number - Bit No Custom flag field.

Flag5 Number - Bit No Custom flag field.

Flag6 Number - Bit No Custom flag field.

Flag7 Number - Bit No Custom flag field.

Flag8 Number - Bit No Custom flag field.

Flag9 Number - Bit No Custom flag field.

Flag10 Number - Bit No Custom flag field.

Flag11 Number - Bit No Custom flag field.

Flag12 Number - Bit No Custom flag field.

Flag13 Number - Bit No Custom flag field.

Flag14 Number - Bit No Custom flag field.

Flag15 Number - Bit No Custom flag field.

Flag16 Number - Bit No Custom flag field.

Flag17 Number - Bit No Custom flag field.

Flag18 Number - Bit No Custom flag field.

Flag19 Number - Bit No Custom flag field.

Flag20 Number - Bit No Custom flag field.

FreeSlack Number - Long No The amount of free slack.

HideBar Number - Bit No Whether the Gantt bars are hidden when displayed in Microsoft Project.

Hyperlink Longtext No The link representation for the hyperlink.

HyperlinkAddress Longtext No The URL or UNC for the target document of the hyperlink.

HyperlinkSubAddress Longtext No The location within the target document of the hyperlink.

LateFinish Date No The late finish date.

LateStart Date No The late start date.

LevelAssignments Number - Bit No Whether leveling can level individual assignments.

LevelingCanSplit Number - Bit No Whether leveling can cause a task split.

LevelingDelay Number - Long No The delay caused by leveling.

LevelingDelayDisplayUnits Number - Integer No The units in which the leveling delay is displayed in Microsoft Project.

LinkedFields Number - Bit No Whether there are data links to the task.

Marked Number - Bit No Whether the task is marked.

Milestone Number - Bit No Whether the task is a milestone.

Name Char No The name of the task.

Notes Longtext No The first 255 characters of the notes, or the characters up to the first line end or object, for the task.

Objects Number - Long Yes The number of objects attached to the task, not including those in notes.

OutlineLevel Number - Integer No The outline level.

OutlineNumber Char Yes The outline number.

Overallocated Number - Bit Yes Whether the task is overallocated.

OvertimeCost Number - Double No The overtime cost.

OvertimeWork Number - Double Yes The amount of overtime work.

PercentComplete Number - Integer No The percent complete.

PercentWorkComplete Number - Integer No The percent work complete.

PreleveledStart Date No The start date of the task before leveling was done.

PreleveledFinish Date No The finish date of the task before leveling was done.

Priority Number - Integer No The priority.

ProjectSummary Number - Bit No Whether the task is a project summary.

Recurring Number - Bit No Whether the task is a recurring task.

RecurringTaskSummary Number - Bit No Whether the task is a summary for recurring tasks.

RegularWork Number - Double Yes The regular work.

RemainingCost Number - Double Yes The remaining cost.

RemainingDuration Number - Long No The remaining duration.

RemainingFixedCost Number - Double No The remaining fixed cost.

RemainingOvertimeCost Number - Double No The amount of remaining work.

RemainingOvertimeWork Number - Double No The amount of remaining overtime work.

RemainingWork Number - Double No The amount of remaining work.

ResumeDate Date Yes The resume date.

Rollup Number - Bit No Whether the task is rolled up.

ScheduledWork Number - Double No The amount of work.

StartDate Date No The task start date.

StartVariance Number - Long Yes The start variance.

StopDate Date No The stop date.

Subproject Number - Bit No Whether the task is an inserted project.

SubprojectReadOnly Number - Bit No Whether the inserted project is read-only.

Summary Number - Bit No Whether the task is a summary.

TaskType Number - Integer No The type of task

TotalSlack Number - Long No The total slack

Reserved_AssignedBefore Number - Bit No Used internally by Microsoft Project.

Reserved_BeforeDelay Number - Bit No Used internally by Microsoft Project.

Reserved_ComputeActualDuration Number - Bit No Used internally by Microsoft Project.

Reserved_ComputeResume Number - Bit No Used internally by Microsoft Project.

Reserved_ExternalTaskUniqueID Number - Long No Used internally by Microsoft Project.

Reserved_ExternalTaskIndex Number - Long No Used internally by Microsoft Project.

Reserved_Fixed Number - Bit No Used internally by Microsoft Project.

Reserved_HasPageBreak Number - Bit No Used internally by Microsoft Project.

Reserved_HasNotes Number - Bit No Used internally by Microsoft Project.

Reserved_HasHyperlink Number - Bit No Used internally by Microsoft Project.

Reserved_InternalMarked Number - Bit No Used internally by Microsoft Project.

Reserved_IsLinkSource Number - Bit No Used internally by Microsoft Project.

Reserved_IsNull Number - Bit No Used internally by Microsoft Project.

Reserved_IsBeforeProjectStart Number - Bit No Used internally by Microsoft Project.

Reserved_IsAfterProjectFinish Number - Bit No Used internally by Microsoft Project.

Reserved_IsVisible Number - Bit No Used internally by Microsoft Project.

Reserved_IsCollapsed Number - Bit No Used internally by Microsoft Project.

Reserved_IsAssnHidden Number - Bit No Used internally by Microsoft Project.

Reserved_LevelChanges Number - Bit No Used internally by Microsoft Project.

Reserved_LevelResume Number - Bit No Used internally by Microsoft Project.

Reserved_ParentUniqueID Number - Long No Used internally by Microsoft Project.

Reserved_MySubprojDate Binary No Used internally by Microsoft Project.

Reserved_NextPertBoxUID Number - Long No Used internally by Microsoft Project.

Reserved_NoSplitsCache Number - Bit No Used internally by Microsoft Project.

Reserved_PrevPertBoxUID Number - Long No Used internally by Microsoft Project.

Reserved_PertX Number - Integer No Used internally by Microsoft Project.

Reserved_PertY Number - Integer No Used internally by Microsoft Project.

Reserved_PertZorder Number - Integer No Used internally by Microsoft Project.

Reserved_PertRightMostPredUID Number - Long No Used internally by Microsoft Project.

Reserved_ProjectSummaryInfo Binary - Short No Used internally by Microsoft Project.

Reserved_RecurringTaskUniqueID Number - Integer No Used internally by Microsoft Project.

Reserved_ResumeNoEarlierThan Date No Used internally by Microsoft Project.

Reserved_RollupAssnWork Number - Bit No Used internally by Microsoft Project.

Reserved_NumberExtProjLinks Number - Long No Used internally by Microsoft Project.

Reserved_SubprojectGUID Binary-Short No Used internally by Microsoft Project.

Reserved_OriginalSummaryInfo Binary-Short No Used internally by Microsoft Project.

Reserved_RecurringTaskInfo Binary-Short No Used internally by Microsoft Project.

Reserved_SummaryDuration Number - Bit No Used internally by Microsoft Project.

Reserved_SubprojectStart Date No Used internally by Microsoft Project.

Reserved_SubprojectFinish Date No Used internally by Microsoft Project.

Reserved_TaskSplit Number - Bit No Used internally by Microsoft Project.

Reserved_LinkedProps Binary - Short No Used internally by Microsoft Project.

Reserved_InternalChangedBits Binary - Short No Used internally by Microsoft Project.

Reserved_ExternalChangeData Binary - Short No Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long No Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Resource_Information Table:

This table contains the Resource data. Microsoft Project will write 3 records to this table with UniqueIDs of -65536, -65535, -65534. These records are used internally by Microsoft Project. You should not edit or delete these records.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * ResourceUniqueID Number - Long No The unique ID for the resource in the project.

ResourceID Number - Long No The resource ID.

AccrueAt Number - Integer No The way resource costs are accrued.

ActualCost Number - Double No The actual cost.

ActualOvertimeCost Number - Double No The actual overtime cost.

ActualOvertimeWork Number - Double No The actual overtime work.

ActualWork Number - Double No The actual amount of work.

ACWP Number - Double Yes Actual cost of work performed.

AvailableFrom Date No The first date from which the resource is available.

AvailableTo Date No The last date for which the resource is available.

BaselineCost Number - Double No The baseline cost.

BaselineWork Number - Double No The baseline work.

BCWP Number - Double Yes Budgeted cost of work performed.

BCWS Number - Double Yes Budgeted cost of work scheduled.

CalendarUniqueID Number - Long No The unique ID for the resource calendar.

CanLevel Number - Bit No Whether the resource can be leveled.

Cost Number - Double No The cost.

CostPerUse Number - Double No The cost per use as of the current date.

Flag1 Number - Bit No Custom flag field.

Flag2 Number - Bit No Custom flag field.

Flag3 Number - Bit No Custom flag field.

Flag4 Number - Bit No Custom flag field.

Flag5 Number - Bit No Custom flag field.

Flag6 Number - Bit No Custom flag field.

Flag7 Number - Bit No Custom flag field.

Flag8 Number - Bit No Custom flag field.

Flag9 Number - Bit No Custom flag field.

Flag10 Number - Bit No Custom flag field.

Flag11 Number - Bit No Custom flag field.

Flag12 Number - Bit No Custom flag field.

Flag13 Number - Bit No Custom flag field.

Flag14 Number - Bit No Custom flag field.

Flag15 Number - Bit No Custom flag field.

Flag16 Number - Bit No Custom flag field.

Flag17 Number - Bit No Custom flag field.

Flag18 Number - Bit No Custom flag field.

Flag19 Number - Bit No Custom flag field.

Flag20 Number - Bit No Custom flag field.

Hyperlink Longtext No The link representation for the hyperlink.

HyperlinkAddress Longtext No The URL or UNC for the target document the hyperlink.

HyperlinkSubAddress Longtext No The location within the target document the hyperlink.

Initials Char No The resource’s initials.

LinkedFields Number - Bit No Whether there are data links to the resource.

MaxUnits Number - Double No The maximum number of units available for the resource.

Name Char No The resource name.

Notes Longtext No The first 255 characters of the notes, or the characters up to the first line end or object, for this resource.

Objects Number - Long Yes The number of objects attached to the resource, not including those in the notes.

Overallocated Number - Bit No Whether the resource is overallocated.

OvertimeCost Number - Double No The overtime cost.

OvertimeRate Number - Double No The overtime rate as of the current date.

OvertimeRateDisplayUnits Number - Integer No The units in which the overtime rate is displayed in Microsoft Project.

OvertimeWork Number - Double No The amount of overtime work.

Peak Number - Double Yes The greatest number of resource units assigned at any time.

Phonetics Longtext No In some languages, the phonetic spelling of the resource name.

RegularWork Number - Double No The amount of regular work.

RemainingCost Number - Double No The remaining cost.

RemainingOvertimeCost Number - Double No The remaining overtime cost.

RemainingOvertimeWork Number - Double No The remaining overtime work.

RemainingWork Number - Double No The amount of remaining work.

StandardRate Number - Double No The standard rate as of the current date.

StandardRateDisplayUnits Number - Integer No The units in which the standard rate is displayed in Microsoft Project.

ScheduledWork Number - Double No The amount of work.

Workgroup Number - Integer No How the resource receives workgroup messages.

Reserved_HasPageBreak Number - Bit No Used internally by Microsoft Project.

Reserved_HasNotes Number - Bit No Used internally by Microsoft Project.

Reserved_HasHyperlink Number - Bit No Used internally by Microsoft Project.

Reserved_IsLinkSource Number - Bit No Used internally by Microsoft Project.

Reserved_IsAssnHidden Number - Bit No Used internally by Microsoft Project.

Reserved_IsNull Number - Bit No Used internally by Microsoft Project.

Reserved_PoolResourceUniqueID Number - Bit No Used internally by Microsoft Project.

Reserved_LinkedProps Binary - Short No Used internally by Microsoft Project.

Reserved_InternalChangedBits Binary - Short No Used internally by Microsoft Project.

Reserved_ExternalChangeData Binary - Short No Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long No Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Information Table:

This table contains assignment data. Microsoft Project will write records for unassigned resources in this table, which are saved as assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * AssignmentUniqueID Number - Long No The unique ID of the assignment in the project.

TaskUniqueID Number - Long No The unique ID of the task in the assignment. This value must be a valid TaskUniqueID in the Task_Information table.

ResourceUniqueID Number - Long No The unique ID of the resource in assignment. This value must be a valid ResourceUniqueID in the Resource_Information table.

ActualCost Number - Double No The actual cost of the assignment.

ActualFinish Date No The actual finish date of the assignment.

ActualOvertimeCost Number - Double No The actual overtime cost.

ActualOvertimeWork Number - Double No The actual amount of overtime work.

ActualStart Date No The actual start date.

ActualWork Number - Double No The actual amount of work.

ACWP Number - Double Yes Actual cost of work performed.

BaselineCost Number - Double No The baseline cost.

BaselineWork Number- Double No The baseline work.

BaselineFinish Date No The baseline finish date.

BaselineStart Date No The baseline start date.

BCWP Number - Double Yes Budgeted cost of work performed.

BCWS Number - Double Yes Budgeted cost of work scheduled.

Confirmed Number - Bit No Whether the assignment is confirmed.

Cost Number - Double Yes The cost of the assignment.

CostRateTable Number - Integer No The cost rate table used for this assignment.

Delay Number - Long No The delay for the assignment.

DelayDisplayUnits Number - Integer No The units in which the delay is displayed in Microsoft Project.

FinishDate Date No The end date of the assignment.

FinishVariance Number - Long Yes The finish variance.

Flag1 Number - Bit No Custom flag field.

Flag2 Number - Bit No Custom flag field.

Flag3 Number - Bit No Custom flag field.

Flag4 Number - Bit No Custom flag field.

Flag5 Number - Bit No Custom flag field.

Flag6 Number - Bit No Custom flag field.

Flag7 Number - Bit No Custom flag field.

Flag8 Number - Bit No Custom flag field.

Flag9 Number - Bit No Custom flag field.

Flag10 Number - Bit No Custom flag field.

Flag11 Number - Bit No Custom flag field.

Flag12 Number - Bit No Custom flag field.

Flag13 Number - Bit No Custom flag field.

Flag14 Number - Bit No Custom flag field.

Flag15 Number - Bit No Custom flag field.

Flag16 Number - Bit No Custom flag field.

Flag17 Number - Bit No Custom flag field.

Flag18 Number - Bit No Custom flag field.

Flag19 Number - Bit No Custom flag field.

Flag20 Number - Bit No Custom flag field.

Hyperlink Longtext No The Link Representation for the hyperlink.

HyperlinkAddress Longtext No The URL or UNC for the target document of the hyperlink.

HyperlinkSubAddress Longtext No The location within the target document of the hyperlink.

LevelingDelay Number - Long No The amount of time the assignment is delayed due to leveling.

LinkedFields Number - Bit No Whether there are data links to the assignment.

Notes Longtext No First 255 characters of the Notes, or the characters up to the first line end or object, for the assignment.

Overallocated Number - Bit Yes Whether the assignment is overallocated.

OvertimeWork Number - Double No The amount of overtime work.

RegularWork Number - Double No The amount of regular work.

RemainingCost Number - Double Yes The remaining cost.

RemainingOvertimeCost Number - Double Yes The remaining overtime cost.

RemainingOvertimeWork Number - Double No The remaining overtime work.

RemainingWork Number - Double No The remaining work

ResponsePending Number - Bit No Whether a response to a TeamAssign message is pending from the assigned resource.

SharedResourceAssignTask Char No The name of the sharer project task to which the pool resource is assigned.

Shared ResourceAssignTaskID Number - Long No The ID of the sharer project task to which the pool resource is assigned.

SharedResAssignSummaryTask Char Yes The name of the summary task for the sharer project task to which the pool resource is assigned.

StartDate Date No The start date of the assignment.

StartVariance Number - Long Yes The start variance.

TeamStatusPending Number - Bit No Whether responses are pending to a TeamStatus message.

Units Number - Double No The number of units assigned.

UpdateNeeded Number - Bit Yes Whether a workgroup update is needed.

ScheduledWork Number - Double No The amount of work.

WorkContour Number - Integer Yes The type of assignment work.

Reserved_ContourUserEdited Number - Bit No Used internally by Microsoft Project.

Reserved_EmailNone Number - Bit No Used internally by Microsoft Project.

Reserved_HasHyperlink Number - Bit No Used internally by Microsoft Project.

Reserved_HasPageBreak Number - Bit No Used internally by Microsoft Project.

Reserved_HasActualStart Number - Bit No Used internally by Microsoft Project.

Reserved_HasActualFinish Number - Bit No Used internally by Microsoft Project.

Reserved_HasNotes Number - Bit No Used internally by Microsoft Project.

Reserved_IsNull Number - Bit No Used internally by Microsoft Project.

Reserved_IsLinkSource Number - Bit No Used internally by Microsoft Project.

Reserved_IsVisibleAsTask Number - Bit No Used internally by Microsoft Project.

Reserved_IsVisibleAsResource Number - Bit No Used internally by Microsoft Project.

Reserved_LastUpdatedMsgStart Date No Used internally by Microsoft Project.

Reserved_LastUpdatedMsgFinish Date No Used internally by Microsoft Project.

Reserved_LevelChanges Number - Bit No Used internally by Microsoft Project.

Reserved_LinkedProps Binary - Short No Used internally by Microsoft Project.

Reserved_WkgpMsgCounter Number - Long No Used internally by Microsoft Project.

Reserved_MsgUniqueID Number - Long No Used internally by Microsoft Project.

Reserved_OutlookTaskID Longtext No Used internally by Microsoft Project.

Reserved_StopDate Date No Used internally by Microsoft Project.

Reserved_ResumeDate Date No Used internally by Microsoft Project.

Reserved_InternalChangedBits Binary - Short No Used internally by Microsoft Project.

Reserved_ExternalChangeData Binary - Short No Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long No Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Reserved_ContourLevelEdited Number - Bit No Used internally by Microsoft Project.

Calendars Table:

This table contains basic calendar data. Microsoft Project will write 3 records to this table with UniqueIDs of -65536, -65535, -65534. These records are used internally by Microsoft Project. You should not edit or delete these records.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * CalendarUniqueID Number - Long No The unique ID for the calendar in the project.

CalendarName Char No The calendar name, not filled in if it is a resource calendar.

BaseCalendarUniqueID Number - Long No The unique ID of the base calendar if this is a resource calendar.

ResourceUniqueID Number - Long No The unique ID of the resource to whom the calendar is assigned.

IsBaseCalendar Number - Bit No Whether this is a base calendar.

Reserved_CalendarAllocated Number - Bit Yes Used internally by Microsoft Project.

Reserved_IsNull Number - Bit Yes Used internally by Microsoft Project.

Reserved_PoolCalendarUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_InternalChangedBits Binary - Short Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Calendar_Working_Times Table:

This table contains calendar working times.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for this working time.

CalendarUniqueID Number - Long No The unique ID for the calendar in the project.

DayOfWeek Number - Integer No Day of the week.

Working Number - Integer No Whether this day is working (value of 0) or non-working (value of 1), or based on the default base calendar (value of 2).

FromTime1 Time No Start time of the first shift.

ToTime1 Time No Finish time of the first shift.

FromTime2 Time No Start time of the second shift.

ToTime2 Time No Finish time of the second shift.

FromTime3 Time No Start time of the third shift.

ToTime3 Time No Finish time of the third shift.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project

Calendar_Exceptions Table:

This table contains calendar exceptions.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for this exception.

CalendarUniqueID Number - Long No The unique ID for the calendar in the project.

FromDate Date No Date the exception starts

ToDate Date No Date the exception finishes

Working Number - Integer No Whether the date range is working or non-working. 0 is non-working, and 1 is working.

FromTime1 Time No Start time of the first shift.

ToTime1 Time No Finish time of the first shift.

FromTime2 Time No Start time of the second shift.

ToTime2 Time No Finish time of the second shift.

FromTime3 Time No Start time of the third shift.

ToTime3 Time No Finish time of the third shift.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Task_Dependencies Table:

This table contains task dependency (links) data. Microsoft Project will write 3 records to this table with UniqueIDs of -65536, -65535, -65534. These records are used internally by Microsoft Project. You should not edit or delete these records.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * DependencyUniqueID Number - Long No The unique ID of the dependency in the project.

PredecessorTaskUniqueID Number - Long No The unique ID of the predecessor task.

SuccessorTaskUniqueID Number - Long No The unique ID of the successor task.

CrossProjectLink Number - Bit Yes Whether this is a cross- project link. The external task is stored in the Tasks table.

LinkType Number - Integer No The link type: FS, FF, SS, SF.

LinkLag Number - Long No The amount of lag.

LinkLagDisplayUnits Number - Integer No The units in which the lag is displayed in Microsoft Project.

Reserved_IsNull Number - Bit No Used internally by Microsoft Project.

Reserved_ExternalChangeData Binary - Short No Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Remaining_Work Table:

This table contains information on the timephased remaining work for assignments. This table will contain records for split tasks which have no resources assigned.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

AssignmentUniqueID Number - Long No The unique ID of the assignment. This value must be a valid AssignmentUniqueID in the Assignment_Information table.

FromDate Date Yes The start date of the time interval for which the work value applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount work in the contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Actual_Work Table:

This table contains information on the timephased actual work for assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

From Date Date Yes The start date of the time interval to which the work value applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount of work in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Actual_Ovt_Work Table:

This table will contain information on the timephased actual overtime work for assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

FromDate Date Yes The start date of the time interval to which the work values applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount of work in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Actual_Exceptions Table:

This table contains information on the actual work for assignments that happened in non-working time.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

FromDate Date No The start date of the time interval during which actual work was done.

ToDate Date No The end date of the non- working time interval during which actual work was done.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Baseline_Cost Table:

This table contains information on the timephased baseline cost for assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

FromDate Date No The start date of the time interval to which the cost applies.

ToDate Date No The end date of the time interval to which the cost applies.

Cost Number - Double No Total amount of cost in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Baseline_Work Table:

This table contains information on the timephased baseline work for assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

FromDate Date Yes The start date of the time interval to which the work values applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount of work in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Assignment_Actual_Cost Table:

This table contains information on the timephased actual cost for assignments.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

AssignmentUniqueID Number - Long No The unique ID of the assignment.

FromDate Date No The start date of the time interval to which the cost applies.

ToDate Date No The end date of the time interval to which the cost applies.

Cost Number - Double No Total amount of cost in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Resource_Rates Table:

This table contains information on the resources’ rates.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for this rate in the project.

ResourceUniqueID Number - Long No The unique ID for the resource in the project.

RateTable Number - Integer No The rate table with the integers 0 to 4 corresponding to the rate tables A to E.

FromDate Date No The first date for which the rates are effective.

ToDate Date No The last date for which the rates are effective.

StandardRate Number - Double No The standard rate.

StandardRateDisplayUnits Number - Integer No The units in which the standard rate is displayed in Microsoft Project.

OvertimeRate Number - Double No The overtime rate.

OvertimeRateDisplayUnits Number - Integer No The units in which the overtime rate is displayed in Microsoft Project.

PerUseCost Number - Double No The per use cost.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Resource_Baseline_Work Table:

This table contains information on the timephased baseline work for resources.

Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

ResourceUniqueID Number - Long No The unique ID of the resource.

FromDate Date Yes The start date of the time interval to which the work value applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount of work in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Resource_Baseline_Cost Table:

This table contains information on the timephased baseline cost for resources.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

ResourceUniqueID Number - Long No The unique ID of the resource.

FromDate Date No The start date of the time interval to which the cost applies.

ToDate Date No The end date of the time interval to which the cost applies.

Cost Number - Double No Total amount of cost in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Task_Baseline_Work Table:

This table contains information on the timephased baseline work for tasks.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

TaskUniqueID Number - Long No The unique ID of the task.

FromDate Date Yes The start date of the time interval to which the work value applies.

Units Number - Double No The number of resource units assigned for this contour segment.

WorkingDuration Number - Long No Amount of working time the contour covers.

WorkValue Number - Double No Total amount of work in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Task_Baseline_Cost Table:

This table contains information on the timephased baseline cost for tasks.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

TaskUniqueID Number - Long No The unique ID of the task.

FromDate Date No The start date of the time interval to which the cost applies.

ToDate Date No The end date of the time interval to which the cost applies.

Cost Number - Double No Total amount of cost in this contour segment.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project

Task_Percent_Complete Table:

This table contains information on the timephased percent complete for tasks.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in the project.

TaskUniqueID Number - Long No The unique ID of the task.

FromDate Date No The start date of the time interval to which the percent complete applies.

ToDate Date No The end date of the time interval to which the percent complete applies.

PercentCompleted Number - Double No Percentage completed.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Task_Baseline_Interim_Splits Table:

This table contains baseline and interim splits information for tasks.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID of the project.


 * UniqueID Number - Long No The unique ID of the timephased data in this project.

TaskUniqueID Number - Long No The unique ID of the task.

Baseline_Interim Number - Integer No Whether this is a baseline split, or one of ten interim splits.

FromDate Date No The start date of the split.

ToDate Date No The end date of the split.

Flags Number - Long No Information on the work contour.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Text_Fields Table:

This table holds the custom fields, as well as some of the “extra” Text fields in the main “Information” tables. Rows are added only if the custom text field has a value. The Microsoft Project fields saved in this table are: Text1 through Text30, Task Contact, Task WBS, Task Subproject File, Resource Code, Resource Email Address, Resource Group

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for the task, resource or assignment to which the custom field applies.


 * FieldID Number - Long No The unique ID for the custom text field.

ContainerType Number - Long No Whether this is a record for a task, resource or an assignment.

TextValue Char No The text value stored in the text field.

Custom_Number_Fields Table:

This table holds the custom Number 1-20 and Cost 1-10 fields. Rows are added only if the custom number or cost field has a value.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for the task, resource or assignment to which the custom number or cost field applies.


 * FieldID Number - Long No The unique ID for the custom date, start or finish date.

ContainerType Number - Long No Whether this is a record for a task, resource or an assignment.

NumberValue Number - Double No The number value stored in the custom number or cost field.

Custom_Date_Fields Table:

This table holds the custom Date 1-10, Start 1-10 and Finish 1-10 fields. Rows are added only if the custom date, start or finish field has a value.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for the task, resource or assignment to which the custom date, start or finish field applies.


 * FieldID Number - Long No The unique ID for the custom date, start or finish field.

ContainerType Number - Long No Whether this is a record for a task, resource or an assignment.

DateValue Date No The date value stored in the custom date, start or finish field.

Custom_Duration_Fields Table Format

This table holds the custom Duration 1-10 fields. Rows are added only if the custom duration field has a value.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * UniqueID Number - Long No The unique ID for the task, resource or assignment for which the custom duration field applies.


 * FieldID Number - Long No The unique ID for the custom duration field.

ContainerType Number - Long No Whether this is a record for a task, resource or an assignment.

DurationValue Number - Long No The duration value stored in the custom duration field.

DurationDisplayUnits Number - Integer No The units in which the custom field is displayed in Microsoft Project.

Intl_FieldReferences Table

This table contains information to convert the saved numeric constants to text, for enumerated fields (e.g. Priority, Constraint Type) and duration, work and rate fields, mapping enumerated field categories to text field names.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * FieldType Number - Long Yes A number representing the enumerated field category.

LanguageID Number - Long Yes The ID of the language in which the FieldName is shown.

FieldName Char (200) Yes The name of the enumerated field category.

These are the table contents with English values.

FieldType FieldName ———————–

8 Weekday 101 Schedule Start 22 Accrual 29 Link Type 9 Display Units 28 Work Contour Type 20 Constraint Type 27 Priority 30 Task Type 102 Calendar Working 100 Container Type 105 Field ID 104 Workgroup Messages 103 Currency Symbol Position 34 Cost Rate Units

Intl_TextConversions Table

This table contains values for each possible text value for the particular FieldType, for the language in which the project was saved to the database.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * FieldType Number - Long Yes A number representing the enumerated field category.


 * ConversionValue Number - Long Yes The value seen in the database fields.


 * LanguageID Number - Long Yes The ID of the language in which the conversion text is displayed.

ConversionText Char (200) Yes The text representation of the field contents.

These are the table contents with English values.

FieldType ConversionValue ConversionText ————————————————-

8 1 Sunday 8 2 Monday 8 3 Tuesday 8 4 Wednesday 8 5 Thursday 8 6 Friday 8 7 Saturday 101 1 Project Start 101 2 Project Finish 22 0 Start 22 1 End 22 2 Prorated 29 0 FF 29 1 FS 29 2 SF 29 3 SS 9 3 m 9 4 em 9 5 h 9 6 eh 9 7 d 9 8 ed 9 9 w 9 10 ew 9 15 y 9 16 ey 9 19 % 9 20 e% 28 0 Flat 28 1 Back Loaded 28 2 Front Loaded 28 3 Double Peak 28 4 Early Peak 28 5 Late Peak 28 6 Bell 28 7 Turtle 28 8 Contoured 34 2 m 34 3 h 34 4 d 34 5 w 34 8 y 20 0 As Soon As Possible 20 1 As Late As Possible 20 2 Must Start On 20 3 Must Finish On 20 4 Start No Earlier Than 20 5 Start No Later Than 20 6 Finish No Earlier Than 20 7 Finish No Later Than 27 9 Do Not Level 27 8 Highest 27 7 Very High 27 6 Higher 27 5 High 27 4 Medium 27 3 Low 27 2 Lower 27 1 Very Low 27 0 Lowest 30 0 Fixed Units 30 1 Fixed Duration 30 2 Fixed Work 102 0 Non-Working 102 1 Working 102 2 Default 100 1 Task 100 2 Resource 100 3 Calendar 100 4 Assignment 100 5 Dependencies 105 255852663 Assignment Cost1 105 255852664 Assignment Cost2 105 255852665 Assignment Cost3 105 255852703 Assignment Cost4 105 255852704 Assignment Cost5 105 255852705 Assignment Cost6 105 255852706 Assignment Cost7 105 255852707 Assignment Cost8 105 255852708 Assignment Cost9 105 255852709 Assignment Cost10 105 255852710 Assignment Date1 105 255852711 Assignment Date2 105 255852712 Assignment Date3 105 255852713 Assignment Date4 105 255852714 Assignment Date5 105 255852715 Assignment Date6 105 255852716 Assignment Date7 105 255852717 Assignment Date8 105 255852718 Assignment Date9 105 255852719 Assignment Date10 105 255852657 Assignment Duration1 105 255852658 Assignment Duration2 105 255852659 Assignment Duration3 105 255852720 Assignment Duration4 105 255852721 Assignment Duration5 105 255852722 Assignment Duration6 105 255852723 Assignment Duration7 105 255852724 Assignment Duration8 105 255852725 Assignment Duration9

105 255852726 Assignment Duration10 105 255852647 Assignment Finish1 105 255852648 Assignment Finish2 105 255852649 Assignment Finish3 105 255852650 Assignment Finish4 105 255852651 Assignment Finish5 105 255852727 Assignment Finish6 105 255852728 Assignment Finish7 105 255852729 Assignment Finish8 105 255852730 Assignment Finish9 105 255852731 Assignment Finish10 105 255852652 Assignment Number1 105 255852653 Assignment Number2 105 255852654 Assignment Number3 105 255852655 Assignment Number4 105 255852656 Assignment Number5 105 255852742 Assignment Number6 105 255852743 Assignment Number7 105 255852744 Assignment Number8 105 255852745 Assignment Number9 105 255852746 Assignment Number10 105 255852747 Assignment Number11 105 255852748 Assignment Number12 105 255852749 Assignment Number13 105 255852750 Assignment Number14 105 255852751 Assignment Number15 105 255852752 Assignment Number16 105 255852753 Assignment Number17 105 255852754 Assignment Number18 105 255852755 Assignment Number19 105 255852756 Assignment Number20 105 255852642 Assignment Start1 105 255852643 Assignment Start2 105 255852644 Assignment Start3 105 255852645 Assignment Start4 105 255852646 Assignment Start5 105 255852757 Assignment Start6 105 255852758 Assignment Start7 105 255852759 Assignment Start8 105 255852760 Assignment Start9 105 255852761 Assignment Start10 105 255852632 Assignment Text1 105 255852633 Assignment Text2 105 255852634 Assignment Text3 105 255852635 Assignment Text4 105 255852636 Assignment Text5 105 255852637 Assignment Text6 105 255852638 Assignment Text7 105 255852639 Assignment Text8 105 255852640 Assignment Text9 105 255852641 Assignment Text10 105 255852762 Assignment Text11 105 255852763 Assignment Text12 105 255852764 Assignment Text13 105 255852765 Assignment Text14 105 255852766 Assignment Text15 105 255852767 Assignment Text16 105 255852768 Assignment Text17 105 255852769 Assignment Text18 105 255852770 Assignment Text19 105 255852771 Assignment Text20 105 255852772 Assignment Text21 105 255852773 Assignment Text22 105 255852774 Assignment Text23 105 255852775 Assignment Text24 105 255852776 Assignment Text25 105 255852777 Assignment Text26 105 255852778 Assignment Text27 105 255852779 Assignment Text28 105 255852780 Assignment Text29 105 255852781 Assignment Text30 105 205521019 Resource Cost1 105 205521020 Resource Cost2 105 205521021 Resource Cost3 105 205521062 Resource Cost4 105 205521063 Resource Cost5 105 205521064 Resource Cost6 105 205521065 Resource Cost7 105 205521066 Resource Cost8 105 205521067 Resource Cost9 105 205521068 Resource Cost10 105 205521069 Resource Date1 105 205521070 Resource Date2 105 205521071 Resource Date3 105 205521072 Resource Date4 105 205521073 Resource Date5 105 205521074 Resource Date6 105 205521075 Resource Date7 105 205521076 Resource Date8 105 205521077 Resource Date9 105 205521078 Resource Date10 105 205521013 Resource Duration1 105 205521014 Resource Duration2 105 205521015 Resource Duration3 105 205521079 Resource Duration4 105 205521080 Resource Duration5 105 205521081 Resource Duration6 105 205521082 Resource Duration7 105 205521083 Resource Duration8 105 205521084 Resource Duration9

105 205521085 Resource Duration10 105 205521003 Resource Finish1 105 205521004 Resource Finish2 105 205521005 Resource Finish3 105 205521006 Resource Finish4 105 205521007 Resource Finish5 105 205521086 Resource Finish6 105 205521087 Resource Finish7 105 205521088 Resource Finish8 105 205521089 Resource Finish9 105 205521090 Resource Finish10 105 205521008 Resource Number1 105 205521009 Resource Number2 105 205521010 Resource Number3 105 205521011 Resource Number4 105 205521012 Resource Number5 105 205521101 Resource Number6 105 205521102 Resource Number7 105 205521103 Resource Number8 105 205521104 Resource Number9 105 205521105 Resource Number10 105 205521106 Resource Number11 105 205521107 Resource Number12 105 205521108 Resource Number13 105 205521109 Resource Number14 105 205521110 Resource Number15 105 205521111 Resource Number16 105 205521112 Resource Number17 105 205521113 Resource Number18 105 205521114 Resource Number19 105 205521115 Resource Number20 105 205520998 Resource Start1 105 205520999 Resource Start2 105 205521000 Resource Start3 105 205521001 Resource Start4 105 205521002 Resource Start5 105 205521116 Resource Start6 105 205521117 Resource Start7 105 205521118 Resource Start8 105 205521119 Resource Start9 105 205521120 Resource Start10 105 205520904 Resource Text1 105 205520905 Resource Text2 105 205520926 Resource Text3 105 205520927 Resource Text4 105 205520928 Resource Text5 105 205520993 Resource Text6 105 205520994 Resource Text7 105 205520995 Resource Text8 105 205520996 Resource Text9 105 205520997 Resource Text10 105 205521121 Resource Text11 105 205521122 Resource Text12 105 205521123 Resource Text13 105 205521124 Resource Text14 105 205521125 Resource Text15 105 205521126 Resource Text16 105 205521127 Resource Text17 105 205521128 Resource Text18 105 205521129 Resource Text19 105 205521130 Resource Text20 105 205521131 Resource Text21 105 205521132 Resource Text22 105 205521133 Resource Text23 105 205521134 Resource Text24 105 205521135 Resource Text25 105 205521136 Resource Text26 105 205521137 Resource Text27 105 205521138 Resource Text28 105 205521139 Resource Text29 105 205521140 Resource Text30 105 205520906 Resource Code 105 205520931 Resource EmailAddress 105 205520899 Resource Group 105 188743786 Task Cost1 105 188743787 Task Cost2 105 188743788 Task Cost3 105 188743938 Task Cost4 105 188743939 Task Cost5 105 188743940 Task Cost6 105 188743941 Task Cost7 105 188743942 Task Cost8 105 188743943 Task Cost9 105 188743944 Task Cost10 105 188743945 Task Date1 105 188743946 Task Date2 105 188743947 Task Date3 105 188743948 Task Date4 105 188743949 Task Date5 105 188743950 Task Date6 105 188743951 Task Date7 105 188743952 Task Date8 105 188743953 Task Date9 105 188743954 Task Date10 105 188743783 Task Duration1 105 188743784 Task Duration2 105 188743785 Task Duration3 105 188743955 Task Duration4 105 188743956 Task Duration5 105 188743957 Task Duration6

105 188743958 Task Duration7 105 188743959 Task Duration8 105 188743960 Task Duration9 105 188743961 Task Duration10 105 188743733 Task Finish1 105 188743736 Task Finish2 105 188743739 Task Finish3 105 188743742 Task Finish4 105 188743745 Task Finish5 105 188743963 Task Finish6 105 188743956 Task Finish7 105 188743967 Task Finish8 105 188743969 Task Finish9 105 188743971 Task Finish10 105 188743767 Task Number1 105 188743768 Task Number2 105 188743769 Task Number3 105 188743770 Task Number4 105 188743771 Task Number5 105 188743982 Task Number6 105 188743983 Task Number7 105 188743984 Task Number8 105 188743985 Task Number9 105 188743986 Task Number10 105 188743987 Task Number11 105 188743988 Task Number12 105 188743989 Task Number13 105 188743990 Task Number14 105 188743991 Task Number15 105 188743992 Task Number16 105 188743993 Task Number17 105 188743994 Task Number18 105 188743995 Task Number19 105 188743996 Task Number20 105 188743732 Task Start1 105 188743735 Task Start2 105 188743738 Task Start3 105 188743741 Task Start4 105 188743744 Task Start5 105 188743962 Task Start6 105 188743964 Task Start7 105 188743966 Task Start8 105 188743968 Task Start9 105 188743970 Task Start10 105 188743731 Task Text1 105 188743734 Task Text2 105 188743737 Task Text3 105 188743740 Task Text4 105 188743743 Task Text5 105 188743746 Task Text6 105 188743747 Task Text7 105 188743748 Task Text8 105 188743749 Task Text9 105 188743750 Task Text10 105 188743997 Task Text11 105 188743998 Task Text12 105 188743999 Task Text13 105 188744000 Task Text14 105 188744001 Task Text15 105 188744002 Task Text16 105 188744003 Task Text17 105 188744004 Task Text18 105 188744005 Task Text19 105 188744006 Task Text20 105 188744007 Task Text21 105 188744008 Task Text22 105 188744009 Task Text23 105 188744010 Task Text24 105 188744011 Task Text25 105 188744012 Task Text26 105 188744013 Task Text27 105 188744014 Task Text28 105 188744015 Task Text29 105 188744016 Task Text30 105 188743792 Task Contact 105 188743696 Task WBS 105 188743706 Task SubprojectFile 104 2 Email 104 3 Web 104 4 Email and Web 104 1 None 103 0 Default 103 0 Before 103 1 After 103 2 Before with Space 103 3 After with Space

Reserved_CommandBars Table

This table contains project toolbar formatting information, and is used to recreate the formatting of the tool bars. This table is reserved and should not be edited. You can’t create a project toolbar in the database. It must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_ToolbarID Number - Long Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_ExternalDataLinks Table

This table contains project DDE and OLE links information, and is used to recreate any links in the project. This table is reserved and should not be edited. You can’t create project DDE and OLE links in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Source Char Yes Used internally by Microsoft Project.

Reserved_Destination Char Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_Aspect Number - Long Yes Used internally by Microsoft Project.

Reserved_Platform Number - Integer Yes Used internally by Microsoft Project.

Reserved_Flags Number - Long Yes Used internally by Microsoft Project.

Reserved_FilterUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_TableUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_ViewUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_SizelX Number - Long Yes Used internally by Microsoft Project.

Reserved_SizelY Number - Long Yes Used internally by Microsoft Project.

Reserved_ContainerUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_ImportExportMaps Table

This table contains Import/Export map information, and is used to recreate any maps in the project. This table is reserved and should not be edited. You can’t create project Import/Export maps in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_Filters Table

This table contains the project filter information, used to recreate any filters in the project. This table is reserved and should not be edited. You can’t create project filters in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_Modules Table

This table is needed for backward compatibility with Microsoft Project 95. This table is reserved and should not be edited.

Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_Reports Table

This table contains project report information, and is used to recreate any reports in the project. This table is reserved and should not be edited. You can’t create project reports in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_FontMap Binary - Short Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_Tables Table

This table contains project table information, and is used to recreate any tables in the project. This table is reserved and should not be edited. You can’t create project tables in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_CustomForms Table

This table contains custom form information, and is used to recreate any user defined forms and dialogs in the project. This table is reserved and should not be edited. You can’t create project custom forms in the database. They must be created using Microsoft Project.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * Reserved_ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_AcceleratorChar Number - Integer Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_V_iews Table

This table contains project view information, and is used to recreate any views in the project. The table name must be Reserved_V_iews, because the word “View” can’t be used as a name in some databases. This table is reserved and should not be edited. You can’t create project views in the database. They must be created using Microsoft Project. Microsoft Project does not store some temporary view information in a database, such as the current date range displayed.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long Yes Used internally by Microsoft Project.


 * Reserved_UniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_Name Char (51) Yes Used internally by Microsoft Project.

Reserved_Type Number - Integer Yes Used internally by Microsoft Project.

Reserved_IsShownInMenu Number - Bit Yes Used internally by Microsoft Project.

Reserved_Contents Number - Integer Yes Used internally by Microsoft Project.

Reserved_MasterSlave Number - Integer Yes Used internally by Microsoft Project.

Reserved_FontMap Binary - Short Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) No Used internally by Microsoft Project.

Reserved_AssignmentPoolInfo Table

This table contains the pool and sharer assignment data.

Key/Field Field Export Name Type Only Description ————————————————————————–


 * ProjectID Number - Long No The unique ID for the project.


 * AssignmentUniqueID Number - Long No The unique ID of the assignment in the project.

TaskUniqueID Number - Long No The unique ID of the task in the assignment. This value must be a valid TaskUniqueID in the Task_Information table.

ResourceUniqueID Number - Long No The unique ID of the resource in the assignment. This value must be a valid ResourceUniqueID in the Resource_Information table.

ActualCost Number - Double No The actual cost of the assignment.

ActualFinish Date No The actual finish date of the assignment.

ActualOvertimeCost Number - Double No The actual overtime cost.

ActualOvertimeWork Number - Double No The actual amount of overtime work.

ActualStart Date No The actual start date.

ActualWork Number - Double No The actual amount of work.

ACWP Number - Double Yes Actual cost of work performed.

BaselineCost Number - Double No The baseline cost.

BaselineWork Number - Double No The baseline work.

BaselineFinish Date No The baseline finish date.

BaselineStart Date No The baseline start date.

BCWP Number - Double Yes Budgeted cost of work performed.

BCWS Number - Double Yes Budgeted cost of work scheduled.

Confirmed Number - Bit No Whether the assignment is confirmed.

Cost Number - Double No The cost of the assignment.

CostRateTable Number - Integer No The cost rate table used for this assignment.

Delay Number - Long No The delay for the assignment.

DelayDisplayUnits Number - Integer No The units in which the delay is displayed in Microsoft Project.

FinishDate Date No The end date of the assignment.

FinishVariance Number - Long Yes The finish variance.

Flag1 Number - Bit No Custom flag field.

Flag2 Number - Bit No Custom flag field.

Flag3 Number - Bit No Custom flag field.

Flag4 Number - Bit No Custom flag field.

Flag5 Number - Bit No Custom flag field.

Flag6 Number - Bit No Custom flag field.

Flag7 Number - Bit No Custom flag field.

Flag8 Number - Bit No Custom flag field.

Flag9 Number - Bit No Custom flag field.

Flag10 Number - Bit No Custom flag field.

Flag11 Number - Bit No Custom flag field.

Flag12 Number - Bit No Custom flag field.

Flag13 Number - Bit No Custom flag field.

Flag14 Number - Bit No Custom flag field.

Flag15 Number - Bit No Custom flag field.

Flag16 Number - Bit No Custom flag field.

Flag17 Number - Bit No Custom flag field.

Flag18 Number - Bit No Custom flag field.

Flag19 Number - Bit No Custom flag field.

Flag20 Number - Bit No Custom flag field.

Hyperlink Longtext No The link representation for the hyperlink.

HyperlinkAddress Longtext No The URL or UNC for the target document of the hyperlink.

HyperlinkSubAddress Longtext No The location within the target document of the hyperlink.

LevelingDelay Number - Long No The amount of time the assignment is delayed due to leveling.

LinkedFields Number - Bit No Whether there are data links to the assignment.

Notes Longtext No First 255 characters of the notes, or the characters up to the first line end or object, for the assignment.

Overallocated Number - Bit Yes Whether the assignment is overallocated.

OvertimeWork Number - Double No The amount of overtime work.

RegularWork Number - Double No The amount of regular work.

RemainingCost Number - Double No The remaining cost.

RemainingOvertimeCost Number - Double No The remaining overtime cost.

RemainingOvertimeWork Number - Double No The remaining overtime work.

RemainingWork Number - Double No The remaining work.

ResponsePending Number - Bit No Whether a response to a TeamAssign message is pending from the assigned resource.

SharedResourceAssignTask Char No The name of the sharer project task to which the pool resource is assigned.

SharedResourceAssignTaskID Number - Long No The ID of the sharer project task to which the pool resource is assigned.

SharedResAssignSummaryTask Char Yes The name of the summary task for the sharer project task to which the pool resource is assigned.

StartDate Date No The start date of the assignment.

StartVariance Number - Long Yes The start variance.

TeamStatusPending Number - Bit No Whether responses are pending to a TeamStatus message.

Units Number - Double No The number of units assigned.

UpdateNeeded Number - Bit Yes Whether a workgroup is needed.

ScheduleWork Number - Double No The amount of work.

WorkContour Number - Integer No The type of work contour.

Reserved_ContourUserEdited Number - Bit Yes Used internally by Microsoft Project.

Reserved_EmailNone Number - Bit Yes Used internally by Microsoft Project.

Reserved_HasHyperlink Number - Bit Yes Used internally by Microsoft Project.

Reserved_HasPageBreak Number - Bit Yes Used internally by Microsoft Project.

Reserved_HasActualStart Number - Bit Yes Used internally by Microsoft Project.

Reserved_HasActualFinish Number - Bit Yes Used internally by Microsoft Project.

Reserved_HasNotes Number - Bit Yes Used internally by Microsoft Project.

Reserved_IsNull Number - Bit Yes Used internally by Microsoft Project.

Reserved_IsLinkSource Number - Bit Yes Used internally by Microsoft Project.

Reserved_IsVisibleAsTask Number - Bit Yes Used internally by Microsoft Project.

Reserved_IsVisibleAsResource Number - Bit Yes Used internally by Microsoft Project.

Reserved_LastUpdatedMsgStart Date Yes Used internally by Microsoft Project.

Reserved_LastUpdatedMsgFinish Date Yes Used internally by Microsoft Project.

Reserved_LevelChanges Number - Bit Yes Used internally by Microsoft Project.

Reserved_LinkedProps Binary - Short Yes Used internally by Microsoft Project.

Reserved_WkgpMsgCounter Number - Long Yes Used internally by Microsoft Project.

Reserved_MsgUniqueID Number - Long Yes Used internally by Microsoft Project.

Reserved_OutlookTaskID Longtext Yes Used internally by Microsoft Project.

Reserved_Stop Date Date Yes Used internally by Microsoft Project.

Reserved_ResumeDate Date Yes Used internally by Microsoft Project.

Reserved_ResourcePoolID Number - Long Yes Used internally by Microsoft Project.

Reserved_InternalChangedBits Binary - Short Yes Used internally by Microsoft Project.

Reserved_ExternalChangeData Binary - Short Yes Used internally by Microsoft Project.

Reserved_BinaryProperties Binary - Long Yes Used internally by Microsoft Project.

Reserved_ElemDeleted Char (1) Yes Used internally by Microsoft Project.

Reserved_ContourLevelEdited Number - Bit Yes Used internally by Microsoft Project.

= Additional query words: readme =

Keywords : kbdta projwin Version : WINDOWS:98 Platform : WINDOWS Hardware : x86 Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.