February, 2000
(C) 2000 Microsoft Corporation. All rights reserved.
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
This document provides the information necessary to query information from the Microsoft Project Central 2000 database.
The following conventions apply to table names:
The following conventions apply to column names:
Table Name | Column Prefix |
---|---|
MSP_WEB_ADMIN | WADMIN_ |
MSP_WEB_ADMIN_LINKS | WLINKS_ |
MSP_WEB_ASSIGNMENTS | WASSN_ |
MSP_WEB_CONVERSIONS | CONV_ |
MSP_WEB_DELEGATION_ASSIGNMENTS | none* |
MSP_WEB_DELEGATIONS | WDELEG_ |
MSP_WEB_GANTT_SCHEMES | WGANTT_SCHEME_ |
MSP_WEB_GANTT_SETTINGS | none* |
MSP_WEB_GANTT_STYLES | WGANTT_STYLE_ |
MSP_WEB_MESSAGES | WMSG_ |
MSP_WEB_MESSAGES_ASSIGNMENTS | none* |
MSP_WEB_MESSAGES_DELEGATIONS | none* |
MSP_WEB_MESSAGES_NONWORKING | none* |
MSP_WEB_MGR_RULES | WRULE_ |
MSP_WEB_MGR_RULES_LISTS | none* |
MSP_WEB_NONWORKING | WNONWORK_ |
MSP_WEB_NONWORKING_CATEGORIES | WNWRK_ |
MSP_WEB_PROJECT_WORKGROUP_INFO | none* |
MSP_WEB_PROJECTS | WPROJ_ |
MSP_WEB_RESERVED_DATA | RESERVED_ |
MSP_WEB_RESOURCES | WRES_ |
MSP_WEB_RESOURCES_CATEGORIES | none* |
MSP_WEB_STATUS_DISTRIBUTION | none* |
MSP_WEB_STATUS_FREQUENCIES | WFREQ |
MSP_WEB_STATUS_REPORTS | WREPORT_ |
MSP_WEB_STATUS_REQUESTS | WREQ_ |
MSP_WEB_STATUS_RESPONSES | WSRESP_ |
MSP_WEB_STRING_TYPES | STRING_ |
MSP_WEB_VIEW_CATEGORIES | WCAT_ |
MSP_WEB_VIEW_DSNS | WDSN_ |
MSP_WEB_VIEW_FIELDS | WFIELD_ |
MSP_WEB_VIEW_PROJECTCATEGORIES | none* |
MSP_WEB_VIEW_REPORTCATEGORIES | none* |
MSP_WEB_VIEW_REPORTS | WVIEW_ |
MSP_WEB_VIEW_REPORTS_FIELDS | none* |
MSP_WEB_VIEW_RESOURCES | WRES_ID_ |
MSP_WEB_VIEW_TABLES | WTABLE_ |
MSP_WEB_WORK | WWORK_ |
MSP_WEB_WORKGROUP_FIELDS | none* |
MSP_WEB_WORKGROUP_FIELDS_INFO | none* |
* Some tables are intersection, or association, tables that inherit columns from other tables. These tables do not have their own prefixes.
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 |
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).
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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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) |
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 |
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 |
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) |
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 |
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 |
This table links Projects and Categories.
Key | Column Name | Data Type | Description |
---|---|---|---|
1 | WPROJ_ID | int | Project ID |
2 | WCAT_ID | int | Category ID |
This table links Views and Categories.
Key | Column Name | Data Type | Description |
---|---|---|---|
1 | WVIEW_ID | int | View ID |
2 | WCAT_ID | int | Category ID |
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 |
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 |
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 |
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 |
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 |
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 |
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 |