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.