Microsoft Project Central 2000 Database Format

February, 2000

(C) 2000 Microsoft Corporation. All rights reserved.

Contents

Overview
Database object naming conventions
     Table naming conventions
     Column naming conventions
     Column name abbreviations

Database tables
     Key columns
     Column data types
     MSP_WEB_ADMIN
     MSP_WEB_ADMIN_LINKS
     MSP_WEB_ASSIGNMENTS
     MSP_WEB_CONVERSIONS
     MSP_WEB_DELEGATION_ASSIGNMENTS
     MSP_WEB_DELEGATIONS
     MSP_WEB_GANTT_SCHEMES
     MSP_WEB_GANTT_SETTINGS
     MSP_WEB_GANTT_STYLES
     MSP_WEB_MESSAGES
     MSP_WEB_MESSAGES_ASSIGNMENTS
     MSP_WEB_MESSAGES_DELEGATIONS
     MSP_WEB_MESSAGES_NONWORKING
     MSP_WEB_MGR_RULES
     MSP_WEB_MGR_RULES_LISTS
     MSP_WEB_NONWORKING
     MSP_WEB_NONWORKING_CATEGORIES
     MSP_WEB_PROJECT_WORKGROUP_INFO
     MSP_WEB_PROJECTS
     MSP_WEB_RESERVED_DATA
     MSP_WEB_RESOURCES
     MSP_WEB_RESOURCES_CATEGORIES
     MSP_WEB_STATUS_DISTRIBUTION
     MSP_WEB_STATUS_FREQUENCIES
     MSP_WEB_STATUS_REPORTS
     MSP_WEB_STATUS_REQUESTS
     MSP_WEB_STATUS_RESPONSES
     MSP_WEB_STRING_TYPES
     MSP_WEB_VIEW_CATEGORIES
     MSP_WEB_VIEW_DSNS
     MSP_WEB_VIEW_FIELDS
     MSP_WEB_VIEW_PROJECTCATEGORIES
     MSP_WEB_VIEW_REPORTCATEGORIES
     MSP_WEB_VIEW_REPORTS
     MSP_WEB_VIEW_REPORTS_FIELDS
     MSP_WEB_VIEW_RESOURCES
     MSP_WEB_VIEW_TABLES
     MSP_WEB_WORK
     MSP_WEB_WORKGROUP_FIELDS
     MSP_WEB_WORKGROUP_FIELDS_INFO

Overview

This document provides the information necessary to query information from the Microsoft Project Central 2000 database.

Database object naming conventions

Table naming conventions

The following conventions apply to table names:

Top

Column naming conventions

The following conventions apply to column names:

* Some tables are intersection, or association, tables that inherit columns from other tables. These tables do not have their own prefixes.

Top

Column name abbreviations

In order to keep the word components of column names short but consistent, the following abbreviations are used when naming columns:

Abbreviation Word Abbreviation Word
ACT Actual OVT Overtime
AVAIL Available PCT Percent
BASE Baseline PRED Predecessor
CAL Calendar PROJ Project
COMP Complete REF Reference
DEF Default REG Regular
DUR Duration REM Remaining
EST Estimated RES Resource
EXT Externally SCHED Schedule
FMT Format STD Standard
LANG Language SUCC Successor
MAX Maximum UID Unique ID
NUM Number VAR Variance

Top

Database tables

Key columns

The following table definitions describe the database structure that is created when you save a whole project to a database. The fields that comprise the key for each table are indicated in the key column by number (ordinal position of the columns within the key).

Top

Column data 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
bit Boolean where supported, integer in databases where Boolean is not supported
char Character
datetime Date including time
decimal(n,n) Decimal (Number in Oracle)
float Floating point number (Number in Oracle)
image Binary data greater than 255 bytes (data-type blob in Oracle)
integer Integer (Number in Oracle)
long Long integer (Number in Oracle)
smallint Small integer (Number in Oracle)
text Longest text field available (8000 bytes in SQL Server, 64k in Microsoft Access, 255 characters in Oracle)
varchar(n) Variable-length character text unless otherwise indicated (Varchar2(n) in Oracle)

If Microsoft Project needs to store a time value, but not a date value, the time value is stored as a date. When you read the project from the database, the date component in these fields is ignored.

Top

MSP_WEB_ADMIN

This table contains the selections made by the Microsoft Project Central administrator. The column names and descriptions explain each selection.

Key Column Name Data Type Description
  WADMIN_AUTHENTICATION_TYPE int 1 for Windows NT Authentication only, 2 for Microsoft Project Central authentication  only, 3 for both
WADMIN_NEW_ACCOUNT_PRIVILEGE int 1 for manager only, 2 for all resources through delegation only, 3 for both. Administrator always
WADMIN_IS_DELEGATION_ALLOWED bit  0 for no, 1 for yes
WADMIN_WEEK_STARTS_ON int 1 for Monday through 7 for Sun
WADMIN_MIN_PASSWORD_LENGTH int Length of password

Top

MSP_WEB_ADMIN_LINKS

This table stores the links (hyperlinks or HTML content) the administrator defines. These links appear on everyone’s Home page.

Key Column Name Data Type Description
1 WLINKS_ID int Index of the administrator links
  WLINKS_HREF nvarchar URL
WLINKS_TITLE nvarchar Title of the link or content
WLINKS_NAME nvarchar Name of the link or content
WLINKS_HEIGHT nvarchar Link height
WLINKS_TYPE int 0 for link, 1 for content

Top

MSP_WEB_ASSIGNMENTS

This table contains assignment information for resources.

Key Column Name Data Type Description
1 WASSN_ID int Assignment ID
  WRES_ID int Resource ID
WASSN_PARENT_ID int Assignment Parent ID. This value is -1 if the assignment has no parent; otherwise, the ID of this assignment parent in this table
WPROJ_ID int Project ID. ID of the file in the File table or -1
WRES_ID_MGR int ID of the manager who last updated the assignment
ASSN_UID int Unique ID of the assignment in Microsoft Project or -1
TASK_UID int Unique ID of the task in Microsoft Project or -1
TASK_ID int ID of the task in Microsoft Project or -1
TASK_UID_SUMMARY int Unique ID of the task's parent in Microsoft Project or -1
TASK_NAME nvarchar Name of the assignment (and task)
ASSN_START_DATE datetime Assignment start date
ASSN_FINISH_DATE datetime Assignment finish date
ASSN_WORK decimal Assignment work
ASSN_REM_WORK decimal Assignment remaining work
WASSN_LAST_WORK decimal Scheduled work from the last update from Microsoft Project
WASSN_COMMENTS nvarchar Comment for the assignment
TASK_IS_MILESTONE bit True if the task is a milestone
TASK_IS_SUMMARY bit True if the task is a summary task
WASSN_IS_CONFIRMED bit Set to false if the resource rejects the assignment
WASSN_MGR_UPDATED bit Set to true if one or more of the fields for that row have been changed (due to TeamUpdate or other workgroup messages)
WASSN_CREATED_BY_RES int 1 if created by the resource, 2 when sent to the project manager but not updated yet
WASSN_CURRENT_TRACKING_MODE int 0=default,1=actuals,2=percent complete tracking
WASSN_UPDATE_TRACKING_MODE int 0=default,1=actuals,2=percent complete tracking
WASSN_SEND_UPDATE_NEEDED bit True if the task has been used for sending actuals by the resource
WASSN_DELETED_IN_PROJ bit True if the assignment has been deleted by the manager
WASSN_RESOURCE_UPDATE bit True if a team resource has submitted actuals
WASSN_REQUEST_UPDATE bit True if an actuals update was requested
WASSN_UPDATES_ACCEPTED bit True if the new task has been accepted by the manager
WASSN_DELEG_ACCEPTED bit Delegation has been accepted by the resource
WASSN_DELEG_APPROVED bit Delegation has been approved by the manager
WASSN_ACTUALS_PENDING bit True if actuals have been submitted but not yet updated into Microsoft Project by the manager
WASSN_DELEG_PENDING bit Delegation pending manager approval
WASSN_IS_DELEGATED bit True if an assignment has been delegated since the last Microsoft Project update
WASSN_IS_NEW_ASSN bit True if this is a new assignment
WASSN_LAST_DELEG_ID int Last delegation done on this assignment
WASSN_PCT_COMP int Percentage complete on the assignment
WRES_ID_TEAM_LEAD int ID of the team lead
WNWRK_ID int ID of the nonworking time type if this assignment is a dummy assignment that represents nonworking time
WNWRK_ENTRY_ID nvarchar Entry ID of the appointment in Microsoft Outlook
RESERVED_DATA1 int Used to temporarily store editable calculated values

Do not edit this field

RESERVED_DATA2 int Used to temporarily store editable calculated values 

Do not edit this field

RESERVED_DATA3 int Used to temporarily store editable calculated values

Do not edit this field

WASSN_REMOVED_BY_RESOURCE bit True if the task was deleted by the resource in the Tasks page

Top

MSP_WEB_CONVERSIONS

Stores the static text in Microsoft Project Central that is represented in different languages, for example Gantt Chart types, or external milestones. Conv_Value and Lang_ID together identify a string in a particular language. The contents of some columns are converted to numeric constants. Microsoft Project Central writes two tables to the database containing the conversion information for those columns: MSP_WEB_STRING_TYPES, which contains the mapping between the enumerated field categories and the field names, and MSP_WEB_CONVERSIONS, which contains the mapping between the numeric constants and the possible text values for each field.

Key Column Name Data Type Description
1 STRING_TYPE_ID int Links to the MSP_WEB_STRING_TYPES table
2 CONV_VALUE int Identifier of string
3 LANG_ID int Language locale ID (for example, 1033 for English)
  CONV_STRING nvarchar Text of the item

Top

MSP_WEB_DELEGATION_ASSIGNMENTS

This table normalizes the delegation information for assignments.

Key Column Name Data Type Description
1 WDELEG_ID int Delegation ID
2 WASSN_ID int Assignment ID
  WDELEG_APPROVE bit True if delegation is approved by the manager
WDELEG_ACCEPT bit True if delegation is accepted by the resource who gets the assignment (delegate)
WDELEG_KEEP_COPY bit True if the delegator chooses to keep a copy of the assignment after delegation to track its progress

Top

MSP_WEB_DELEGATIONS

This table stores information about delegations.

Key Column Name Data Type Description
1 WDELEG_ID int Delegation ID
  WRES_ID_DELEGATOR int ID of the delegator 
WRES_ID_DELEGATEE int ID of the delegate
WDELEG_KEEP_COPY bit Reserved for future use
WDELEG_DATE datetime Delegation date
WDELEG_REJECT bit True if the delegate rejected the assignment

Top

MSP_WEB_GANTT_SCHEMES

This table enumerates the scheme types for the Gantt views in Microsoft Project Central.

Key Column Name Data Type Description
1 WGANTT_SCHEME_ID int Gantt scheme ID
  WGANTT_SCHEME_TYPE int 0=personal Gantt, 1=assignment or portfolio views Gantt, 2=project views Gantt
WGANTT_SCHEME_NAME nvarchar Gantt scheme name

Top

MSP_WEB_GANTT_SETTINGS

This table stores detailed setting information about Gantt views.

Key Column Name Data Type Description
1 WGANTT_SCHEME_ID int Scheme identifier
2 WGANTT_STYLE_ID int ID for the Gantt bar type

0 Normal task

1 Critical task

2 External task

3 Delegated task

4 Milestone

5 Summary task

6 Project Summary

7 Group by summary

8 Progress

9 Summary progress

10 Baseline task

11 Baseline summary

12 Baseline milestone

13 Preleveled task

14 Preleveled summary

15 Preleveled milestone

16 Split

17 Critical split

18 Baseline split

19 Deadline

20 Slack

21 Slippage

22 Delay

23 Custom duration 1

24 Custom duration 2

25 Custom duration 3

26 Custom duration 4

27 Custom duration 5

28 Custom duration 6

29 Custom duration 7

30 Custom duration 8

31 Custom duration 9

32 Custom duration 10

33 Early schedule

34 Late schedule

35 External milestone

  WGANTT_SHOW bit True if the Gantt bar type is shown for the scheme
WGANTT_BAR_TYPE int Type of the lines drawn for the bars

0 None

1 Rectangle

2 Rectangle top

3 Rectangle middle

4 Rectangle bottom

5 Line top

6 Line middle

7 Line bottom

WGANTT_BAR_PATTERN int 0 Hollow

1 Solid fill

2 Light fill

3 Medium fill

4 Dark fill

5 Diagonal left

6 Diagonal right

7 Diagonal cross

8 Line vertical

9 Line horizontal

10 Line cross

WGANTT_BAR_COLOR int 1 Black

2 Red

3 Yellow

4 Lime

5 Aqua

6 Blue

7 Fuchsia

8 White

9 Maroon

10 Green

11 Olive

12 Navy

13 Purple

14 Teal

15 Gray

16 Silver

WGANTT_START_SHAPE int 0 No shape

1 House up

2 House down

3 Diamond

4 Triangle up

5 Triangle down

6 Triangle right

7 Triangle left

8 Arrow up

9 Caret down top

10 Caret up bottom

11 Line shape

12 Square

13 Circle diamond

14 Arrow down

15 Circle triangle up

16 Circle triangle down

17 Circle arrow up

18 Circle arrow down

19 Circle

20 Star

WGANTT_START_COLOR int Same as bar colors
WGANTT_END_SHAPE int Same as start shapes
WGANTT_END_COLOR int Same as bar colors

Top

MSP_WEB_GANTT_STYLES

This table links the Gantt Chart style identified in the MSP_WEB_GANTT_SCHEMES table to the string stored in the MSP_WEB_CONVERSIONS table.

Key Column Name Data Type Description
1 WGANTT_STYLE_ID int ID for the Gantt style
  WGANTT_STYLE_CONV_VALUE int Identifier to string in MSP_Web_Conversions

Top

MSP_WEB_MESSAGES

This table stores information about messages that go from or to Microsoft Project from or two Microsoft Project Central.

Key Column Name Data Type Description
1 WMSG_ID int Unique key for messages
  WMSG_PROJ_TYPE int Type of message as defined by Microsoft Project
WRES_ID_SENDER int Sender's resource ID (-1 if unknown)
WRES_ID_RECEIVER int Recipient’s resource ID (-1 if unknown)
WMSG_SUBJECT nvarchar Subject of the message
WMSG_BODY nvarchar Body of the message
WMSG_TIME datetime Time (full format) message was sent
WPROJ_ID int ID of the project file for this message
WMSG_ACTUAL_TYPE int 1 = Scheduled work

2 = Actual work

3 = 2 + 1

4 = Overtime actual work

5 = 4 + 1

6 = 4 + 2

7 =4+ 2 + 1

WMSG_PERIOD_START datetime Start of message period
WMSG_PERIOD_FINISH datetime Finish of message period
WMSG_PERIOD_BROKEN_BY int Period granularity: 1=By Day, 2=By Week, 3=Total
WMSG_PERIOD_WEEK_STARTS_ON int Week starts On: 0=Sunday, 1=Monday, etc.
WMSG_WAS_READ bit True if the message has been read by recipient
WMSG_PROCESS_ST int Process state: 0 if the message hasn't been processed, 1 if partially processed, 2 if fully processed
WMSG_RES_CAN_DECLINE bit True if the resource can decline assignments (default); false otherwise

Top

MSP_WEB_MESSAGES_ASSIGNMENTS

This table links messages to the assignments in the MSP_WEB_ASSIGNMENTS table.

Key Column Name Data Type Description
1 WMSG_ID int Unique key for messages
2 WASSN_ID int Assignment ID
  WASSN_IS_PROCESSED bit True if the assignment is processed by AutoAccept rules

Top

MSP_WEB_MESSAGES_DELEGATIONS

This table links the delegation information to the messages.

Key Column Name Data Type Description
1 WMSG_ID int Unique key for messages
2 WDELEG_ID int Delegation ID

Top

MSP_WEB_MESSAGES_NONWORKING

This table links nonworking time information to each message that contains such information.

Key Column Name Data Type Description
1 WMSG_ID Int Unique key for messages
2 WNONWORK_ID Int ID of the nonworking time

Top

MSP_WEB_MGR_RULES

This table stores information about message rules for the manager.

Key Column Name Data Type Description
1 WRULE_ID int Rule ID
  WRULE_NAME nvarchar Rule name
  WRES_ID_MGR int Rule owner
  WRULE_IS_ENABLED bit True if rule is enabled
  WRULE_TYPE Int 1 = All messages, 2 = new tasks, 3 = actual update (no condition) or 4 = actual updates with condition, 20 = new task (the rule type ID matches with the message ID)
  WRULE_CONDITION_TYPE Int Do not check for condition (0), field1 op value (1), or field1 op field2 (2)
  WRULE_FIELD1_ID Int Field ID used for condition type
  WRULE_FIELD2_ID Int Field ID used for condition type
  WRULE_OPERATOR Int =, != , >, <, >= , <=
  WRULE_VALTYPE Int The field value indicates whether the entered data is of type integer, date/time, decimal or string:

4 = DATETIME

5 = INTEGER

6 = DECIMAL

21 = STRING

  WRULE_INT_VAL Bit Field value if type = BOOL
  WRULE_DATE_VAL datetime Field value if type = DATE
  WRULE_DECIMAL_VAL decimal Field value if type = DOUBLE, COST
  WRULE_VARCHAR_VAL nvarchar field value if type = STR
  WRULE_DURATION_UNIT Int Reserved for future use
  WRULE_IS_EXCL_PROJID Bit True if all future projects are included in the rule; the default is false
  WRULE_IS_EXCL_RES1ID Bit True if all future resources are included in the rule; the default is false
  WRULE_IS_EXCL_RES2ID Bit  True if all future resources are included in the rule for task delegation requests only; the default is false
  WRULE_DESCRIPTION nvarchar Rule description

 

Top

MSP_WEB_MGR_RULES_LISTS

This table stores the list of project IDs (and/or resource IDs) included or excluded by their corresponding rule in the MSP_WEB_MGR_RULES table. If this table is empty for a particular WRULE_ID, and WRULE_IS_EXCL_PROJID (RES1ID, RES2ID) in the MSP_WEB_MGR_RULES table for the same WRULE_ID is false, then no projects (or resources) are included in that rule. If this table is empty for a particular WRULE_ID, and WRULE_IS_EXCL_PROJID (RES1ID, RES2ID) in the MSP_WEB_ MGR_RULES table for the same WRULE_ID is true, then all current and future projects (and/or resources) are included in that rule.

Key Column Name Data Type Description
1 WRULE_ID Int Rule ID
2 ITEM_TYPE Int Project ID (0), resource ID (1), resource delegated to (2, use for rules for task delegation only)
3 ITEM_ID Int Project ID or resource ID. The project or resource is either included in the rule or excluded from the rule depending on the WRULE_IS_EXCL bits in the MSP_WEB_MGR_RULES table.

For example, If WRULE_IS_EXCL_PROJID for the same WRULE_ID is set to False, then this project is included for that rule. If it is set to True, then this project is excluded from that rule.

 

Top

MSP_WEB_NONWORKING

This table stores nonworking time detail.

Key Column Name Data Type Description
1 WNONWORK_ID int ID of the nonworking time
  WNONWORK_SUBJECT nvarchar Subject of the nonworking time
WNONWORK_START datetime Starting time
WNONWORK_END datetime Ending time
WNONWORK_IS_ALL_DAY bit True if this an all day event
WNONWORK_IS_WORKING bit Is working time exception or not

Top

MSP_WEB_NONWORKING_CATEGORIES

This table stores the nonworking time categories.

Key Column Name Data Type Description
1 WNWRK_ID int ID of a nonworking time category
2 WNWRK_NAME nvarchar Name of a nonworking time type
  WNWRK_CODE nvarchar The user can associate a code to a category that can be in in numeric, text, or Microsoft Project outline code format. 
WNWRK_ORDER int The order of nonworking time categories appearing in the grid

Top

MSP_WEB_PROJECT_WORKGROUP_INFO

This table stores the IDs of custom fields the manager sent to the resources for each project.

Key Column Name Data Type Description
1 WPROJ_ID int Unique file ID
2 CUSTFIELD_INFO_ID int Links to MSP_WEB_WORKGROUP_FIELDS_INFO

Top

MSP_WEB_PROJECTS

This table stores information about projects.

Key Column Name Data Type Description
1 WPROJ_ID int Unique file ID
  PROJ_NAME nvarchar Name of project
PROJ_TIMESTAMP nvarchar Timestamp identifier of the file
WLOCAL_PATH nvarchar Path of the file on the manager's computer
WPATH nvarchar UNC Path of the file
WRES_ID int Resource ID of owner (-1 if unknown)
WDSN_ID int DSN ID from MSP_WEB_VIEW_DSNS (if the project file is stored in a database)
WPROJ_DELEG_ALLOWED bit False if task delegation is not allowed for this project
WPROJ_IS_NONWORKING bit This flag, if true, represents the nonworking items in the resource’s timesheet
OPT_DEF_START_TIME datetime Project default start time
OPT_DEF_FINISH_TIME datetime Project default finish time

Top

MSP_WEB_RESERVED_DATA

Reserved for internal use. Do not alter these values.

Key Column Name Data Type Description
  RESERVED_DATA1 int  
RESERVED_DATA2 int
RESERVED_DATA3 int
RESERVED_DATA4 int

Top

MSP_WEB_RESOURCES

This table stores information about resources.

Key Column Name Data Type Description
1 WRES_ID int Resource ID
  RES_NAME nvarchar The unique name used to identify a user in Microsoft Project Central. This field can be a Microsoft Project resource name (for example, bob) or a Windows user account name (for example,  domain\bob)
WRES_USE_NT_LOGON bit Indicates whether RES_NAME is an Windows user account name
WRES_EMAIL nvarchar E-mail address for the resource
WRES_LAST_UPDATE_TIME datetime Reserved for future use
WRES_LAST_CHECKED_TIME datetime Reserved for future use
WRES_IS_OFFLINE bit True if the resource is currently offline in one workstation
WRES_LAST_CONNECT datetime Stores the last time the user logged on
WRES_IS_MANAGER bit True/False depending whether the user has manager privileges
WRES_IS_ADMIN bit True/False depending whether the user has administrator privileges
WRES_IS_ENABLED bit True if resource is enabled. If false, resource name doesn’t show up in the logon screen (or anywhere else in Microsoft Project Central except for the Admin/Users page.)
WRES_DEL_TASKUPDATE_MSG bit Indicates whether to auto delete the task update messages after processing the rules
WRES_DEL_DELEG_MSG bit Indicates whether to auto delete the delegation messages after processing the rules
WRES_DEL_NEWTASK_MSG bit Indicates whether to auto delete the new task messages after processing the rules
WRES_DEL_REASSN_MSG bit Indicates whether to auto delete replies to team assignment messages with all the tasks accepted after processing the rules 
WRES_INCL_TEAMLEAD_RESOURCES bit Reserved for future use
WRES_INCL_TEAMASSIGN_RESOURCES bit Used in assignment views: True if you can see the assignments of other people that you sent assignments to as specified in the User Permissions for Views page.
RES_PHONETICS nvarchar The phonetics for the resource name, used for list sorting for East Asian languages
RESERVED_DATA1 int Reserved for internal use

Do not change this field

RESERVED_DATA2 int Reserved for internal use

Do not change this field

RESERVED_DATA3 int Reserved for internal use

Do not change this field

RESERVED_DATA4 int Reserved for internal use

Do not change this field

Top

MSP_WEB_RESOURCES_CATEGORIES

This table links category information (for views) to the resources in the MSP_WEB_RESOURCES table.

Key Column Name Data Type Description
1 WRES_ID int Resource ID
2 WCAT_ID int Category ID

Top

MSP_WEB_STATUS_DISTRIBUTION

This table stores status report distribution information, which SR response was sent to whom.

Key Column Name Data Type Description
1 WRES_ID_DISTR_RECIP int Recipient of status responses
2 WRESP_ID int Status response ID from the MSP_WEB_STATUS_RESPONSES table

Top

MSP_WEB_STATUS_FREQUENCIES

This table stores the recurrence information for status reports. WFREQ is described in greater detail below the following table.

Key Column Name Data Type Description
1 WSR_ID int Status report ID
2 WREPORT_START_DATE datetime Report start date
  WFREQ int 0=Weekly
1=Monthly
2=Yearly
WFREQPAR1 int Frequency parameter (see below)
WFREQPAR2 int Frequency Parameter (see below)
WFREQPAR3 int Frequency parameter (see below)
WFREQPAR4 int Frequency parameter (see below)
WFREQPAR5 int Frequency parameter (see below)
WFREQPAR6 int Frequency parameter (see below)
WFREQPAR_DATE datetime Frequency date parameter
 

The following three tables provide more detail on how WFREQ in the MSP_WEB_STATUS_FREQUENCIES table is related to the FREQPARx fields, where x is a number between 1 and 6:

WFREQ 0=Weekly
WFREQPAR1 1=every week, 2=every other week, 3=every 3 weeks, and so on up to every 12 weeks
WFREQPAR2 Each bit represents a day of the week selected with the lowest bit being Sunday (that is, 9 means Sunday and Wednesday selected)
WFREQPAR3 Not used
WFREQPAR4 Not used
WFREQPAR5 Not used
WFREQPAR6 Not used
WFREQPAR_DATE Not used

WFREQ 1=Monthly
WFREQPAR1 0=first option of monthly, 1=second option of monthly
WFREQPAR2 Day of month (1-31) - used by first option
WFREQPAR3 Every x months (1-12) - used by first option
WFREQPAR4 1=first, 2=second, 3=third, 4=fourth, 5=last - used by second option
WFREQPAR5 1=Sunday, 2=Monday, ..., 7=Saturday - used by second option
WFREQPAR6 Every x months (1-12) - used by second option
WFREQPAR_DATE Not used
 
WFREQ 2=Yearly
WFREQPAR1 0=first option of yearly, 1=second option of yearly
WFREQPAR2 1=first, 2=second, 3=third, 4=fourth, 5=last - used by second option
WFREQPAR3 1=Sunday, 2=Monday, and so on through 7=Saturday - used by second option
WFREQPAR4 Month of year (1-12) - used by second option
WFREQPAR5 not used
WFREQPAR6 not used
WFREQPAR_DATE Date in first option of yearly - used by first option
 

Top

MSP_WEB_STATUS_REPORTS

This table stores general information about status reports.

Key Column Name Data Type Description
1 WSR_ID int Status report ID
  WRES_ID_MGR int ID of the manager who created the report request
WREPORT_NAME nvarchar Name of the status report
WREPORT_UNREQUESTED bit True if the resource is sending an unrequested status report
WREPORT_FORMAT ntext XML representation of the sections
WREPORT_IS_ENABLED bit True if the report is enabled (if the manager deletes it, it becomes false)

Top

MSP_WEB_STATUS_REQUESTS

This table stores detailed information about status report requests.

Key Column Name Data Type Description
1 WRES_ID_RECEIVER int ID of recipient of status request
2 WSR_ID int Status report ID
  WDUE_ON datetime Next date the report is due for this request
WREQ_IS_AUTOMERGE bit True if this auto merge response
WREQ_IS_NEW_REQUEST bit True if it's a new request
WREQ_IS_SENT bit True if the request was sent
WREQ_IS_ENABLED bit True if request was enabled (if manager deletes a resource from a status report request, it becomes false)

Top

MSP_WEB_STATUS_RESPONSES

This table stores the responses for status reports.

Key Column Name Data Type Description
1 WRESP_ID int Response ID
  WRES_ID int Resource ID
WSR_ID int Status report ID
WSRESP_PERIOD_START datetime Start date for the response
WSRESP_PERIOD_FINISH datetime End date for the response
WSUBMIT_STATUS int Not submitted=0, saved=1, submitted=2
WSUBMIT_DATE datetime Date report submitted
WUPDATE_STATUS int No updates=0, original=1, update=2
WNUM_SECTIONS int Number of sections that can’t be removed
WRESP_IS_MATCHING bit True if response matches the request period
WRESP_IS_NEW_RESPONSE bit Response is new until manager has seen it
WRESP_IS_MERGED bit True if merged into manager's compiled report
WRESP_TEXT ntext Response text

Top

MSP_WEB_STRING_TYPES

This table maps certain strings used in Microsoft Project Central to the language locale IDs. Microsoft Project Central writes two tables to the database containing the conversion information for those columns: MSP_WEB_STRING_TYPES, which contains the mapping between the enumerated field categories and the field name, and MSP_WEB_CONVERSIONS, which contains the mapping between the numeric constants and the possible text values for each field. Currently this is used only for Gantt bar styles and field names in Microsoft Project Views.

Key Column Name Data Type Description
1 STRING_TYPE_ID int String Type ID
2 STRING_LANG_ID int Language locale ID for the string
  STRING_TYPE nvarchar Name of the string

Top

MSP_WEB_VIEW_CATEGORIES

Stores the category information for Views.

Key Column Name Data Type Description
1 WCAT_ID int Category ID
  WCAT_NAME nvarchar Category name
WCAT_DESCRIPTION nvarchar Category description
WCAT_INCL_ALL_PROJECTS bit True if all projects in the database belong to this category (option button in category definition)
WCAT_INCL_TEAMASSIGN_PROJECTS bit Allow users in this category to view all projects to which they are assigned (they either received or sent workgroup messages)

Top

MSP_WEB_VIEW_DSNS

This table stores DSN information for Views. This is applicable only for projects stored in a database.

Key Column Name Data Type Description
1 WDSN_ID int Data Source Name (DSN) ID for the projects stored in a database
  WDSN_NAME nvarchar DSN name
WDSN_DESCRIPTION nvarchar DSN description
WDSN_LOGIN_ID nvarchar DSN logon ID
WDSN_PASSWORD nvarchar DSN password

Top

MSP_WEB_VIEW_FIELDS

This table stores information about the Fields displayed for each view.

Key Column Name Data Type Description
1 WFIELD_ID int Field ID for views
  WFIELD_NAME_OLEDB nvarchar Field name used by the OLE-DB provider
WFIELD_NAME_SQL nvarchar Field name used by the Microsoft Project Central database
WFIELD_TEXTCONV_TYPE int Do not use numbers that are not listed here.

0 Invalid type

2 Priority (enumeration index into priority table)

3 Constraint type (index into constraint table)

4 Date

5 Percent (for example, 5%)

6 Duration (for example, 5 days)

8 Work (for example, 5h)

9 Cost (for example, $5.00)

11 CostRate (for example, $5/hr)

12 Units

13 Accrual Type (index into accrual table)

14 Contour Type (index into contour table)

15 Plain number

16 Boolean (index into Boolean string table)

17 Yes/no (index into yesno string table)

18 Double (a double value)

21 String

23 Time (minutes since 12:00 A.M.)

25 Link type (for example,  SS,FF,FS,SF)

28 Elapsed duration (for example, 5ed)

29 Task type (for example,  fixed units, fixed work, fixed duration)

31 Hyperlink

32 Hyperlink

33 Hyperlink

WTABLE_ID int 0 = Task

1 = Assignment

2 = Resource

WFIELD_IN_PROJECT_VIEW bit True if field is in the Project view
WFIELD_IN_PORTFOLIO_VIEW bit True if field is in the Portfolio view
WFIELD_IN_WEBCLIENT_VIEW bit True if field is in the Assignment view
WFIELD_IS_CUSTOM_FIELD bit True if the field is a custom field in the Microsoft Project Central database
WFIELD_IS_GANTT_DEFAULT bit True if the field is required to draw the Gantt bars (Start, Finish, Baseline dates, etc.)
WFIELD_NAME_CONV_VALUE int Links to the MSP_WEB_CONVERSIONS table, string name of the field

Top

MSP_WEB_VIEW_PROJECTCATEGORIES

This table links Projects and Categories.

Key Column Name Data Type Description
1 WPROJ_ID int Project ID
2 WCAT_ID int Category ID

Top

MSP_WEB_VIEW_REPORTCATEGORIES

This table links Views and Categories.

Key Column Name Data Type Description
1 WVIEW_ID int View ID
2 WCAT_ID int Category ID

Top

MSP_WEB_VIEW_REPORTS

This table stores information about Views.

Key Column Name Data Type Description
1 WVIEW_ID int View ID
  WVIEW_NAME nvarchar View name
WVIEW_DESCRIPTION nvarchar View description
WVIEW_TYPE int 0=Project View, 1=Portfolio View, 2=Assignment View
WVIEW_DISPLAY_TYPE int Reserved for future use
WVIEW_WORK_TYPE int Reserved for future use
WGANTT_SCHEME_ID int Scheme ID for the Gantt
WTABLE_ID int Same as in MSP_WEB_VIEW_TABLES
WVIEW_FILTER_PARAM1 nvarchar SQL clause for the first filter of the project view
WVIEW_FILTER_PARAM2 nvarchar SQL clause for the second filter of the project view for the View
WVIEW_FILTER_PARAM3 nvarchar SQL clause for the third filter of the project view
WVIEW_REPORT_KIND int 0=Normal, 1=ASP, 2=HTML, 3=Data access page
WVIEW_PATH nvarchar URL defined in the Get Additional Views section in the view definition page

Top

MSP_WEB_VIEW_REPORTS_FIELDS

This table specifies the fields displayed for each view.

Key Column Name Data Type Description
1 WVIEW_ID int View ID
2 WFIELD_ID int Field ID for views
  WVIEW_FIELD_ORDER int The order the fields appear in

Top

MSP_WEB_VIEW_RESOURCES

This table is used in Assignment Views. It helps determine which resources’ assignments will be displayed in the assignment view.

Key Column Name Data Type Description
1 WRES_ID_MGR int Manager ID
2 WRES_ID_RESOURCE int Resource ID

Top

MSP_WEB_VIEW_TABLES

This table specifies the table names (tasks, assignments, resources.) This table is currently not used in any specific query in Microsoft Project Central.

Key Column Name Data Type Description
1 WTABLE_ID int  
  WTABLE_NAME nvarchar

Top

MSP_WEB_WORK

This table stores all the actual, scheduled, overtime information in the resource’s timesheet. The information is stored in units of days. If the start-to-end is more than a day, the work value is repeated over each day.

Key Column Name Data Type Description
  WRES_ID int Resource ID
1 WASSN_ID int Assignment ID
2 WWORK_START datetime Start date
3 WWORK_FINISH datetime Finish date
4 WWORK_TYPE int 0 = Scheduled work

1 = Actual work

2 = Overtime actual work

  WWORK_VALUE decimal Representation of the work item in Microsoft Project (minutes * 1000)
WWORK_IS_SENT bit True if sent to manager
WWORK_IS_SAVED bit True if saved but not sent yet
RESERVED_DATA1 int Reserved for internal use

Top

MSP_WEB_WORKGROUP_FIELDS

This table stores the values for the workgroup (custom) fields in timesheet.

Key Column Name Data Type Description
1 WASSN_ID int The assignment to which the custom fields belong
2 FIELD_ID int Field ID - unique and predefined for each (custom) field
  CUSTFIELD_TYPE int Same as WFIELD_TEXTCONV_TYPE in the MSP_WEB_VIEW_FIELDS table
INT_VAL int Field value if type = BOOL,INT,ENUM, ENUMRAND,LONG,DATE,CALDATE,PERCENT
DATE_VAL datetime Field value if type = DATE
DECIMAL_VAL decimal Field value if type = DOUBLE,COST
VARCHAR_VAL nvarchar Field value if type = STR
INDICATOR_VAL int Stoplight enum values
DURATION_UNIT int Store 2nd DWORD of (high, unit, etc.) value if necessary (for example, DATERANGE, EFFORT )
WWORKGRP_INFO_IS_READONLY bit Specifies whether the workgroup information is read-only

Top

MSP_WEB_WORKGROUP_FIELDS_INFO

This table stores the names and other information about workgroup (custom) fields in the timesheet.

Key Column Name Data Type Description
1 CUSTFIELD_INFO_ID int Unique custom field info ID
  FIELD_ID int Same as in MSP_WEB_WORKGROUP_FIELDS
CUSTFIELD_NAME nvarchar Name of custom field
PICKLIST_INFO nvarchar Reserved for future use

Top