MS Project Download
Имя: Пароль:
Забыли пароль?

Статьи

Методика управления проектами [86]

Методические пособия и книги [28]

Готовые отраслевые решения [60]

Обзоры программ для управления проектами [63]

События в мире Управлениия Проектами [129]

Сравнение разных программ для управления проектами [26]

Обучение и сертификация [54]

Управление рисками [4]

Опыт внедрения [38]

Разрешение проблем MS Project и др. системах [4]

Скачать Microsoft Project [3]

Администрирование MS Project Server [36]

Разработка для Microsoft Project [5]


18 пользователей нашли статью интересной, если согласны нажмите тут 
02.12.2003

Microsoft Office Project Server 2003 Data Reference


Overview
B B What's new in Project Server 2003

About the Project Server Database
B B Supported databases
B B Database permissions and configuration
B B Ensuring data integrity
B B DSN requirements and limitations

Accessing Data in the Project Server Database
B B Find all projects currently stored in the Project Server database
B B Find all resources that have assignments currently stored in the Project Server database
B B Find all resources that have undeleted messages stored in the Project Server database
B B Find all requested status reports currently stored in the Project Server database
B B Find all status reports and their most recent responses
B B Find the names of all resources assigned to each assignment in each project
B B Find all timephased data for a particular resource
B B Find all timephased data for a particular project
B B Find a list of assignments and assignment data for a team member
B B Find all overdue assignments
B B Find all assignments that have been delegated to another user

Appendix
B B Table naming conventions
B B Key columns
B B Column naming conventions
B B Column name abbreviations
B B Column data types
B B Indicator symbols
B B MSP_WEB_ADMIN
B B MSP_WEB_ADMIN_AD
B B MSP_WEB_ADMIN_CUBE
B B MSP_WEB_ADMIN_LINKS
B B MSP_WEB_ASSIGNMENTS
B B MSP_WEB_CALENDAR_TRANSACTIONS
B B MSP_WEB_CONVERSIONS
B B MSP_WEB_DELEGATION_ASSIGNMENTS
B B MSP_WEB_DELEGATIONS
B B MSP_WEB_GANTT_SCHEMES
B B MSP_WEB_GANTT_SETTINGS
B B MSP_WEB_GANTT_STYLES
B B MSP_WEB_GROUP_SCHEMES
B B MSP_WEB_GROUP_SETTINGS
B B MSP_WEB_GROUP_STYLES
B B MSP_WEB_INSTALLED_LANGUAGES
B B MSP_WEB_MESSAGES
B B MSP_WEB_MESSAGES_ASSIGNMENTS
B B MSP_WEB_MESSAGES_NONWORKING
B B MSP_WEB_MGR_RULES
B B MSP_WEB_MGR_RULES_LISTS
B B MSP_WEB_MODELS
B B MSP_WEB_NONWORKING
B B MSP_WEB_NONWORKING_CATEGORIES
B B MSP_WEB_NOTIFICATION_EVENTS
B B MSP_WEB_NOTIFICATIONS
B B MSP_WEB_OBJECTS
B B MSP_WEB_OBJECT_LINKS
B B MSP_WEB_PROJECT_WORKGROUP_INFO
B B MSP_WEB_PROJECTS
B B MSP_WEB_REMINDER_TYPES
B B MSP_WEB_REMINDERS
B B MSP_WEB_REMINDERS_TEMP
B B MSP_WEB_RESERVED_DATA
B B MSP_WEB_RESOURCE_SETTINGS
B B MSP_WEB_RESOURCES
B B MSP_WEB_SECURITY_CATEGORIES
B B MSP_WEB_SECURITY_CATEGORY_OBJECTS
B B MSP_WEB_SECURITY_CATEGORY_RULES
B B MSP_WEB_SECURITY_FEATURES_ACTIONS
B B MSP_WEB_SECURITY_GROUP_MEMBERS
B B MSP_WEB_SECURITY_GROUPS
B B MSP_WEB_SECURITY_MENUS
B B MSP_WEB_SECURITY_OBJECT_RULES
B B MSP_WEB_SECURITY_OBJECT_TYPES
B B MSP_WEB_SECURITY_ORG_PERMISSIONS
B B MSP_WEB_SECURITY_PAGES
B B MSP_WEB_SECURITY_SP_CAT_PERMISSIONS
B B MSP_WEB_SECURITY_SP_CAT_RELATIONS
B B MSP_WEB_SECURITY_TEMPLATE_PERMISSIONS
B B MSP_WEB_SECURITY_TEMPLATES
B B MSP_WEB_SECURITY_USERDEFINED
B B MSP_WEB_STATUS_DISTRIBUTION
B B MSP_WEB_STATUS_FREQUENCIES
B B MSP_WEB_STATUS_REPORTS
B B MSP_WEB_STATUS_REQUESTS
B B MSP_WEB_STATUS_RESPONSES
B B MSP_WEB_STRING_TYPES
B B MSP_WEB_STS_SERVERS
B B MSP_WEB_TIME_PERIODS
B B MSP_WEB_TRANSACTIONS
B B MSP_VERSIONS
B B MSP_WEB_VIEW_DSNS
B B MSP_WEB_VIEW_FAVORITES
B B MSP_WEB_VIEW_FIELDS
B B MSP_WEB_VIEW_REPORTS
B B MSP_WEB_VIEW_REPORTS_FIELDS
B B MSP_WEB_VIEW_TABLES
B B MSP_WEB_WORK
B B MSP_WEB_WORK_ADJUSTED
B B MSP_WEB_WORK_APPROVAL
B B MSP_WEB_WORKGROUP_FIELDS
B B MSP_WEB_WORKGROUP_FIELDS_INFO
B B MSP_WEB_WSS_LIST_SYNCHRONIZATION_TIMES

Project and Resource View Tables
B B Unique aspects of the Project Server view tables
B B MSP_VIEW_PROJ_ASSN_CF
B B MSP_VIEW_PROJ_ASSN_ENT
B B MSP_VIEW_PROJ_ASSN_STD
B B MSP_VIEW_PROJ_ASSN_TP_BY_DAY
B B MSP_VIEW_PROJ_CAL
B B MSP_VIEW_PROJ_CAL_DATA
B B MSP_VIEW_PROJ_CAL_EXCEPTIONS
B B MSP_VIEW_PROJ_PRED
B B MSP_VIEW_PROJ_PROJECTS_ENT
B B MSP_VIEW_PROJ_PROJECTS_STD
B B MSP_VIEW_PROJ_RES_CF
B B MSP_VIEW_PROJ_RES_ENT
B B MSP_VIEW_PROJ_RES_STD
B B MSP_VIEW_PROJ_SUCC
B B MSP_VIEW_PROJ_TASKS_CF
B B MSP_VIEW_PROJ_TASKS_ENT
B B MSP_VIEW_PROJ_TASKS_STD
B B MSP_VIEW_PROJ_TASK_TP_BY_DAY
B B MSP_VIEW_PROJ_TASKSPLITS
B B MSP_VIEW_RES_CF
B B MSP_VIEW_RES_ENT
B B MSP_VIEW_RES_STD
B B MSP_VIEW_RES_TP_BY_DAY

Assignment and Resource Cube Tables
B B MSP_CUBE_ASSN_BOOKING
B B MSP_CUBE_ASSN_FACT
B B MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n
B B MSP_CUBE_ENTERPRISE_PROJECT_OUTLINE_n
B B MSP_CUBE_RESOURCE_OUTLINE_CODE_n
B B MSP_CUBE_PROJ_VERSIONS
B B MSP_CUBE_PROJECTS
B B MSP_CUBE_RES_AVAIL_FACT
B B MSP_CUBE_RESOURCES
B B MSP_CUBE_TIME_BY_DAY

Overview

This document provides information about how data is stored in the Microsoft Office Project Server 2003 database, including how to access some of the most relevant data. Microsoft SQL Server 2000 script examples are provided for you to use when accessing this data. Run these script examples against either Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) or SQL Server 2000 databases or use them as part of a stored procedure if you plan to run these scripts on a regular basis. All of these scripts can be easily modified or expanded to extract information that may be more relevant to your organization.

NoteB B The scripts WEBTBLS.sql, VIEWTBLS.sql, and CUBETBLS.sql create the database tables described in this document. They can be found on the Project Server CD-ROM in the \SUPPORT\DATABASE folder.

What's new in Project Server

The Project Server database has been expanded and includes the following overall improvements:

  • Security tables
  • Dedicated view tables
  • Support for the creation of Assignment and Resource cubes
  • Support for enterprise features

The following tables have been added to the Project Server database:

Top

About the Project Server database

The following sections detail the databases that are supported by Project Server and describe how to work with data stored in the database.

Supported databases

Project Server supports the following databases:

  • Microsoft SQL Server 2000, Service Pack 3 or higher; (SQL Server 2000 is required for full enterprise functionality of Project Server.)
  • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) or later, Service Pack 3 or higher
Top

Database permissions and configuration

Project Server performs several types of operations on a database, each requiring DATA READER or DATA WRITER permissions in SQL Server 2000. Individual users access the data through Microsoft Office Project Web Access 2003 and therefore do not need permission for direct access to the Project Server.

Ensuring data integrity

Placing triggers on Project Server database tables may cause data corruption or return unexpected results. It is important to note the following:

  • Any procedure fired by an INSERT or UPDATE trigger does not alter the @@identity property.
  • A procedure fired by an INSERT or UPDATE trigger must not perform an INSERT into a table with an Identity column or otherwise cause an Identity value to be generated by SQL Server 2000.
Top

DSN requirements and limitations

Project Server supports an integrated database. Users of Microsoft Office Project Professional B  2003 and Project Web Access will be able to use the database to store their data.

Project supports using a database source name (DSN) to connect to a server using Project Professional in offline mode.

DSN limitations in Project:

  • Project caches logon passwords and other connection information. The same DSN cannot be used by more than one user ID on a single computer for different, simultaneous logons to the database. When a connection is established, that connection is reused even if a different logon name and/or password is entered at logon time. To log on with a different user ID, you must close all projects opened with the DSN. If there are simultaneous connections, you must create additional alternate DSNs for use with each user ID.
  • You should never open the enterprise global template with a DSN. This can cause conflicts with the database and can cause data to be placed in unintended locations.
Top

Accessing Data in the Project Server Database

This group of scripts returns general statistical data about the information stored in the Project Server database tables.

Find all projects currently stored in the Project Server database

The following script extracts a list of all of the projects that are currently stored in the Project Server database, the name of the project manager for each project, and the total number of assignments for each project.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
WRES_ID Refers to a valid ID in the MSP_WEB_RESOURCES table
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_ASSIGNMENTS PROJ_ID Refers to a valid ID in the MSP_WEB_PROJECTS table
select
   PROJ_NAME as Project,
   RES_NAME as Project_Manager,
   (select count(*) from MSP_WEB_ASSIGNMENTS a 
      where  a.WPROJ_ID = p.WPROJ_ID) as Assignments
from
   MSP_WEB_PROJECTS p,
   MSP_WEB_RESOURCES r
where
      p.WRES_ID = r.WRES_ID
and   p.WPROJ_ID <> 1 
order by
   PROJ_NAME,
   RES_NAME

Find all resources that have assignments currently stored in the Project Server database

The following script extracts a list of all of the resources that have assignments currently stored in the Project Server database, the name of the project that each resource is assigned to, and the total number of assignments for each project.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_ASSIGNMENTS WPROJ_ID Refers to a valid project in the MSP_WEB_PROJECTS table
WRES_ID Refers to a valid resource in the MSP_WEB_RESOURCES table
select
   RES_NAME as Resource,
   PROJ_NAME as Project,
   count(*) as Assignments
from
   MSP_WEB_PROJECTS p,
   MSP_WEB_ASSIGNMENTS a,
   MSP_WEB_RESOURCES r
where
      r.WRES_ID = a.WRES_ID
and   a.WPROJ_ID = p.WPROJ_ID
and   p.WPROJ_ID <> 1
group by
   PROJ_NAME,
   RES_NAME

Find all resources that have undeleted messages stored in the Project Server database

The following script extracts a list of all resources that have undeleted Project Server messages currently stored in the Project Server database, the name of the project that is associated with the messages, and the total number of undeleted messages for each project.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_MESSAGES WRES_ID_RECEIVER Refers to a valid resource in the MSP_WEB_RESOURCES table
WPROJ_ID Refers to a valid project in the MSP_WEB_PROJECTS table
select
   r.RES_NAME as Receiver,
   PROJ_NAME as Project,
   count(*) as Undeleted_Messages
from
   MSP_WEB_PROJECTS p,
   MSP_WEB_MESSAGES m,
   MSP_WEB_RESOURCES r
where
      r.WRES_ID = m.WRES_ID_RECEIVER
and   m.WPROJ_ID = p.WPROJ_ID
and   p.WPROJ_ID <> 1
group by
   RES_NAME,
   PROJ_NAME

Find all requested status reports currently stored in the Project Server database

The following script extracts a list of all status reports that have been requested and are currently stored in the Project Server database, the name of the project manager that requested the report, and the name of the resource who was requested to make the report.

Tables Fields Description
MSP_WEB_STATUS_REPORTS WSR_ID Refers to a valid ID in the MSP_WEB_STATUS_REQUESTS table
WRES_ID_MGR Refers to a valid ID in the MSP_WEB_RESOURCES table
WREPORT_NAME The name of the status report
MSP_WEB_STATUS_REQUESTS WSR_ID The unique ID for the status request
WRES_ID_RECEIVER Refers to a valid ID in the MSP_WEB_RESOURCES table
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
select
   WREPORT_NAME as Report,
   m.RES_NAME as Project_Manager,
   r.RES_NAME as Resource
from
   MSP_WEB_STATUS_REPORTS p,
   MSP_WEB_STATUS_REQUESTS q,
   MSP_WEB_RESOURCES m,
   MSP_WEB_RESOURCES r
where
   p.WRES_ID_MGR = m.WRES_ID
and   p.WSR_ID = q.WSR_ID
and   q.WRES_ID_RECEIVER = r.WRES_ID

Find all status reports and their most recent responses

The following script extracts a list of all status reports and their most recent response dates before the

@cur_date
(current date) variable. Also, the status reports that are listed must have a frequency start date between the
@start_date
and
@end_date
variables.

Tables Fields Description
MSP_WEB_STATUS_REPORTS WSR_ID The unique ID of the status report
WREPORT_NAME The name of the status report
MSP_WEB_STATUS_RESPONSES WSR_ID Refers to a valid WSR_ID in the MSP_WEB_STATUS_REPORTS table
WSUBMIT_DATE The date a status report was submitted
MSP_WEB_STATUS_FREQUENCIES WSR_ID Refers to a valid WSR_ID in the MSP_WEB_STATUS_REPORTS table
WREPORT_START_DATE The date that status reporting is to begin
--declare the variables
declare @start_date as datetime
declare @end_date as datetime
declare @cur_date as datetime
--set the variable values
set @start_date = '2003-09-09'
set @end_date = '2003-10-10'
set @cur_date = '2003-09-09'
--select the fields
select
   s.WREPORT_NAME as 'Status Report',
   max(r1.WSUBMIT_DATE) as 'Last Response'
from
   MSP_WEB_STATUS_REPORTS s,
   MSP_WEB_STATUS_RESPONSES r1,
   MSP_WEB_STATUS_FREQUENCIES f
where
      s.WSR_ID = f.WSR_ID
and   s.WSR_ID = r1.WSR_ID
and   f.WREPORT_START_DATE between @start_date and @end_date
and   not exists (select r2.WSR_ID 
      from MSP_WEB_STATUS_RESPONSES r2 
         where r2.WSUBMIT_DATE > @cur_date 
            and s.WSR_ID = r2.WSR_ID)
group by 
   s.WREPORT_NAME

NoteB B You can use the getdate() function instead of the cur_date variable if you want the date to be today's date.

Find the names of all resources assigned to each assignment in each project

The following script extracts a list of all projects that are currently stored in the Project Server database, the name of each assignment, and the team member assigned. The nonworking assignment time is excluded from the results.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_ASSIGNMENTS WASSN_ID The unique ID for the assignment
WRES_ID Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table
WPROJ_ID Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table
WNWRK_ID Refers to a valid ID in the MSP_WEB_NONWORKING table
TASK_NAME The name of the task
select
   PROJ_NAME as Project,
   TASK_NAME as Task_Name,   
   RES_NAME as Team_Member
from
   MSP_WEB_PROJECTS p,
   MSP_WEB_RESOURCES r,
   MSP_WEB_ASSIGNMENTS a
where
      a.WRES_ID = r.WRES_ID
and   a.WPROJ_ID = p.WPROJ_ID
and   a.WNWRK_ID is NULL
order by
   PROJ_NAME,
   TASK_NAME

Find all timephased data for a particular resource

The following script extracts a grouped, rolled-up list of timephased data for a specified team member over a specified date range. The work type (scheduled, actual, or overtime) is also specified as a variable. The rolled-up data is grouped first by project name, then by task name, and finally by date with rolled-up work totals for each grouping level. The work values are displayed in hours.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
MSP_WEB_ASSIGNMENTS WASSN_ID The unique ID for the assignment
WPROJ_ID Refers to a valid ID in the MSP_WEB_PROJECTS table
WRES_ID Refers to a valid ID in the MSP_WEB_RESOURCES table
MSP_WEB_WORK WASSN_ID Refers to a valid ID in the MSP_WEB_ASSIGNMENTS table
WWORK_START The start date for the work
WWORK_FINISH The finish date for the work
cursor Used for initial filtering and computation for the process of expanding the compact timephased data
temporary table Used to store, group, sum, and roll up the expanded timephased data
declare @res_name as nvarchar(510)
declare @begin_date as datetime
declare @end_date as datetime
declare @work_type as int
-- set these variables
select @res_name = 'Team Member'
select @begin_date = '2003-09-09'
select @end_date = '2003-12-09'
select @work_type = 0 -- 0=scheduled, 1=actual, 2=overtime
-- end user variables
-- function variables
declare @assn_id as int
declare @td_start as datetime
declare @total_days as int
declare @td_value as decimal(25,6)
declare @td_cur_date as datetime
declare @p_name as nvarchar(510)
declare @t_name as nvarchar(510)
-- end function variables
-- create temporary table
create table #tp_data ( td_date datetime, td_hours decimal(25,9), 
   task_name nvarchar(510), proj_name nvarchar(510) )
-- create cursor for data collection
declare td cursor for
select
   a.WASSN_ID, 
   WWORK_START,
   datediff(day, WWORK_START, WWORK_FINISH)+1,
   WWORK_VALUE
from
   MSP_WEB_WORK w,
   MSP_WEB_RESOURCES r,
   MSP_WEB_ASSIGNMENTS a
where
      a.WRES_ID = r.WRES_ID
and   a.WASSN_ID = w.WASSN_ID
and   r.RES_NAME = @res_name
and   w.WWORK_TYPE = @work_type
and   (@begin_date <= WWORK_FINISH or @end_date >= WWORK_START)
order by
   WWORK_START
-- loop through cursor to explode timephased data
open td
fetch next from td into @assn_id, @td_start, @total_days, @td_value
while @@fetch_status <> -1
begin
   select @td_cur_date = @td_start
   while @total_days > 0
   begin
      -- get the task name
      select @t_name = 
         ( select TASK_NAME
         from MSP_WEB_ASSIGNMENTS
         where WASSN_ID = @assn_id )
      -- get the project name
      select @p_name = 
         ( select PROJ_NAME
         from MSP_WEB_PROJECTS p, MSP_WEB_ASSIGNMENTS a
         where a.WASSN_ID = @assn_id and a.WPROJ_ID = p.WPROJ_ID )
      -- insert the data row into the temp table
      insert #tp_data values ( @td_cur_date, @td_value, 
         @t_name, @p_name )
      select @td_cur_date = DATEADD(d, 1, @td_cur_date)
      select @total_days = @total_days - 1
   end
   -- get next row from cursor
   fetch next from td into @assn_id, @td_start, @total_days, @td_value
end
close td
deallocate td
-- display data from temporary table with grouping and rollup
select 
   proj_name as Project,
   task_name as Task,
   td_date as 'Date',
   SUM(td_hours/60000) as 'Total_Work'
from    
   #tp_data
group by proj_name, task_name, td_date with rollup
-- clean up that temporary table
drop table #tp_data

Find all timephased data for a particular project

The following script extracts a grouped, rolled-up list of timephased data for a specified project name over a specified date range. Also, the work type (scheduled, actual, or overtime) is specified as a variable. The rolled-up data is grouped first by team member name, then by task name, and finally by date with rolled-up work totals for each grouping level. The work values are displayed in hours.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_ASSIGNMENTS WASSN_ID The unique ID for the assignment
WPROJ_ID Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table
TASK_NAME The name of the task
MSP_WEB_WORK WASSN_ID Refers to a valid WASSN_ID in the MSP_WEB_ASSIGNMENTS table
WWORK_START The start date for the work
WWORK_FINISH The end date for the work
WWORK_VALUE The number of hours worked, measured as minutes * 1000
WWORK_TYPE Indicates the type of work
declare @proj_name as nvarchar(510)
declare @begin_date as datetime
declare @end_date as datetime
declare @work_type as int
-- set these variables
select @proj_name = 'Project Name'
select @begin_date = '2003-01-01'
select @end_date = '2003-03-31'
select @work_type = 0 -- 0=scheduled, 1=actual, 2=overtime
-- end user variables
-- function variables
declare @assn_id as int
declare @td_start as datetime
declare @total_days as int
declare @td_value as decimal(25,6)
declare @td_cur_date as datetime
declare @tm_name as nvarchar(510)
declare @t_name as nvarchar(510)
-- end function variables
-- create temporary table
create table #tp_data ( td_date datetime, td_hours decimal(25,9), 
   task_name nvarchar(510), team_member nvarchar(510) )
-- create cursor for data collection
declare td cursor for
select
   a.WASSN_ID, 
   WWORK_START,
   datediff(day, WWORK_START, WWORK_FINISH)+1,
   WWORK_VALUE
from
   MSP_WEB_WORK w,
   MSP_WEB_RESOURCES r,
   MSP_WEB_ASSIGNMENTS a,
   MSP_WEB_PROJECTS p
where
      a.WPROJ_ID = p.WPROJ_ID
and   a.WASSN_ID = w.WASSN_ID
and   r.WRES_ID = a.WRES_ID
and   p.PROJ_NAME = @proj_name
and   w.WWORK_TYPE = @work_type
and   (@begin_date <= WWORK_FINISH or @end_date >= WWORK_START)
order by
   WWORK_START
-- loop through cursor to explode timephased data
open td
fetch next from td into @assn_id, @td_start, @total_days, @td_value
while @@fetch_status <> -1
begin
   select @td_cur_date = @td_start
   while @total_days > 0
   begin
      -- get the task name
      select @t_name = 
         ( select TASK_NAME
         from MSP_WEB_ASSIGNMENTS
         where WASSN_ID = @assn_id )
      -- get the team member name
      select @tm_name = 
         ( select RES_NAME 
         from MSP_WEB_RESOURCES r, MSP_WEB_ASSIGNMENTS a
         where a.WASSN_ID = @assn_id and a.WRES_ID = r.WRES_ID )
      -- insert the data row into the temp table
      insert #tp_data values ( @td_cur_date, @td_value, 
         @t_name, @tm_name )
      select @td_cur_date = DATEADD(d, 1, @td_cur_date)
      select @total_days = @total_days - 1
   end
   -- get next row from cursor
   fetch next from td into @assn_id, @td_start, @total_days, @td_value
end
close td
deallocate td
-- display data from temporary table with grouping and rollup
select 
   team_member as Team_Member,
   task_name as Task,
   td_date as 'Date',
   SUM(td_hours/60000) as 'Total_Work'
from    
   #tp_data
group by team_member, task_name, td_date with rollup
-- clean up that temporary table
drop table #tp_data

Find a list of assignments and assignment data for a team member

The following script extracts a list of all of the assignments and related, associated assignment data for a specified team member over a specified date range. The results script will include summary assignments that may be excluded by adding MSP_WEB_ASSIGNMENTS.TASK_IS_SUMMARY = 0 to the where clause of this script.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
MSP_WEB_ASSIGNMENTS WASSN_ID The unique ID for the assignment
ASSN_START_DATE The start date for the assignment
ASSN_FINISH_DATE The finish date for the assignment
WASSN_COMMENTS Contains user comments about the assignment
WASSN_PCT_COMP The current status of the assignment, expressed as the percentage of the assignment's work that has been completed
ASSN_WORK The total amount of work scheduled to be performed by a resource on a task
ASSN_REM_WORK The amount of time required by a resource assigned to a task to complete the assignment
WRES_ID Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table
WPROJ_ID Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table
TASK_IS_SUMMARY Indicates whether the task is a summary task
TASK_NAME The name of the task
declare @res_name as nvarchar(510)
declare @begin_date as datetime
declare @end_date as datetime
 -- set these variables
select @res_name = 'Team Member'
select @begin_date = '2003-09-09'
select @end_date = '2003-10-10'
 -- end variables
select    WASSN_ID as Assignment_ID,
      TASK_IS_SUMMARY as Summary,
   TASK_NAME as Task_Name,
       ASSN_START_DATE as Start,
      ASSN_FINISH_DATE as Finish,
       WASSN_COMMENTS as Comments,
      WASSN_PCT_COMP as Percent_Complete,
       ASSN_WORK/60000 as Assigned_Work,
      ASSN_REM_WORK/60000 as Remaining_Work,
       PROJ_NAME as Project
from    MSP_WEB_ASSIGNMENTS a, 
      MSP_WEB_PROJECTS p
where    a.WRES_ID = (Select WRES_ID from MSP_WEB_RESOURCES 
         Where RES_NAME = @res_name)
and    a.WPROJ_ID = p.WPROJ_ID
and    ASSN_START_DATE Between @begin_date And @end_date

Find all overdue assignments

The following script extracts a list of all assignments that are late as of a specific date. The date for determining a late assignment is a variable, so any date can be inserted. The variable

@days_late
determines how late the assignment is; the script can be changed to report only those assignments that are five or ten days late, for example. An assignment is considered late when remaining work and the
@check_date
occur after the assignment's finish date.

Tables Fields Description
MSP_WEB_PROJECTS WPROJ_ID The project names from the project IDs
PROJ_NAME The name of the project
MSP_WEB_RESOURCES WRES_ID The team member names from the resource IDs
RES_NAME The name of the resource
MSP_WEB_ASSIGNMENTS WASSN_ID The task names, assignment IDs, project IDs, and the resource IDs
WPROJ_ID Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table
WRES_ID Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table
ASSN_WORK The total amount of work scheduled to be performed by a resource on a task
ASSN_REM_WORK The amount of time required by a resource assigned to a task to complete an assignment
ASSN_FINISH_DATE The finish date for the assignment
TASK_NAME The name of the task
declare @check_date as datetime
declare @days_late as int
 -- set these variables
select @check_date = GETDATE()
select @days_late = 0
 -- end variables
select
   PROJ_NAME as Project,
   TASK_NAME as Task,
   RES_NAME as Resource,
   ASSN_WORK/60000 as Work_Assigned,
   (ASSN_WORK/60000 - ASSN_REM_WORK/60000) as Work_Complete,
   ASSN_REM_WORK/60000 as Work_Remaining,
   ASSN_FINISH_DATE as Scheduled_Finish
from
   MSP_WEB_PROJECTS p, 
   MSP_WEB_ASSIGNMENTS a,
   MSP_WEB_RESOURCES r
where
      a.ASSN_REM_WORK > 0
and   DATEDIFF(day, a.ASSN_FINISH_DATE, @check_date) > @days_late
and   a.WPROJ_ID = p.WPROJ_ID
and   a.WRES_ID = r.WRES_ID

Find all assignments that have been delegated to another user

The following script extracts a list of all assignments that have been delegated from one user to another, including the task name, delegator, delegatee, and the project manager. The script lists all delegations, approved or not, and could easily be extended to list only approved delegations or those delegations awaiting approval.

Tables Fields Description
MSP_WEB_ASSIGNMENTS WASSN_ID The unique ID for the assignment
WPROJ_ID Refers to a valid ID in the MSP_WEB_PROJECTS table
TASK_NAME The name of the task
MSP_WEB_RESOURCES WRES_ID The unique ID for the resource
RES_NAME The name of the resource
MSP_WEB_DELEGATION_ASSIGNMENTS WASSN_ID Refers to a valid ID in the MSP_WEB_ASSIGNMENTS table
WDELEG_ID Refers to a valid ID in the MSP_WEB_DELEGATIONS table
MSP_WEB_DELEGATIONS WDELEG_ID The unique ID for the delegation
WRES_ID_DELEGATOR Refers to a valid ID in the MSP_WEB_RESOURCES table
WRES_ID_DELEGATEE Refers to a valid ID in the MSP_WEB_RESOURCES table
MSP_WEB_PROJECTS WPROJ_ID The unique ID for the project
WRES_ID Refers to a valid ID in the MSP_WEB_RESOURCES table
select
   TASK_NAME as Task_Name,
   r1.RES_NAME as Delegator,
   r2.RES_NAME as Delegatee,
   r3.RES_NAME as Project_Manager
from
   MSP_WEB_ASSIGNMENTS a,
   MSP_WEB_RESOURCES r1,
   MSP_WEB_RESOURCES r2,
   MSP_WEB_RESOURCES r3,
   MSP_WEB_DELEGATION_ASSIGNMENTS da,
   MSP_WEB_DELEGATIONS d,
   MSP_WEB_PROJECTS p
where
   a.WASSN_ID = da.WASSN_ID
and   da.WDELEG_ID = d.WDELEG_ID
and   d.WRES_ID_DELEGATOR = r1.WRES_ID
and   d.WRES_ID_DELEGATEE = r2.WRES_ID
and   a.WPROJ_ID = p.WPROJ_ID
and   p.WRES_ID = r3.WRES_ID

Appendix

Table naming conventions

The following conventions apply to table names:

  • Table names are all uppercase.
  • All table names begin with the MSP_WEB_ prefix to identify them as Project Server tables, except tables used with Assignment and Resource cube data (MSP_CUBE_n) or Project Web Access view tables (MSP_VIEW_n).
  • Underscores separate all words.
Top

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 primary key for each table are indicated by a PK in the left column.

Top

Column naming conventions

The following conventions apply to column names:

  • Column names are all uppercase.
  • Words are generally separated by underscores.
  • Column names are generally prefixed with a unique identifier for their tables.

If a table is not listed in the table shown below, then any of the following may apply:

  • Columns in the table do not have a consistent naming convention.
  • The table is a view table (MSP_VIEW_n).
  • The table is an Assignment or Resource cube table (MSP_CUBE_n).
Table Name Column Prefix
MSP_WEB_ADMIN WADMIN_
MSP_WEB_ADMIN_CUBE WADMIN_CUBE_
MSP_WEB_ADMIN_LINKS WLINKS_
MSP_WEB_ASSIGNMENTS WASSN_
MSP_WEB_CALENDAR_TRANSACTIONS WCTRANS_
MSP_WEB_DELEGATION_ASSIGNMENTS WDELEG_
MSP_WEB_DELEGATIONS WDELEG_
MSP_WEB_GANTT_n WGANTT_
MSP_WEB_GROUP_n WGROUP_
MSP_WEB_MESSAGES WMSG_
MSP_WEB_MGR_RULES WRULE_
MSP_WEB_MODELS WMOD_
MSP_WEB_NONWORKING WNONWORK_
MSP_WEB_NONWORKING_CATEGORIES WNWRK_
MSP_WEB_NOTIFICATION_EVENTS WNTFY_
MSP_WEB_NOTIFICATIONS WNTFY_
MSP_WEB_OBJECTn WOBJn
MSP_WEB_PROJECTS WPROJ_
MSP_WEB_REMINDER_OPTIONS WRMND_
MSP_WEB_REMINDERn WRMND_
MSP_WEB_RESOURCES WRES_
MSP_WEB_SECURITY_n WSEC_n_
MSP_WEB_STATUS_FREQUENCIES WFREQn
MSP_WEB_STATUS_REPORTS WREPORT_
MSP_WEB_STATUS_REQUESTS WREQ_
MSP_WEB_STATUS_RESPONSES WRESP_
MSP_WEB_STS_SERVERS WSTS_
MSP_WEB_TRANSACTIONS WTRANS_
MSP_WEB_VIEW_DSNS WDSN_
MSP_WEB_VIEW_FAVORITES WVIEW_
MSP_WEB_VIEW_FIELDS WFIELD_
MSP_WEB_VIEW_REPORTS WVIEW_
MSP_WEB_WORK WWORK_
Top

Column name abbreviations

To keep the word components of column names short and consistent, use the following abbreviations when naming columns:

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

Column data types

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

Field Type Description
char Character.
datetime Date, including time.
decimal Decimal.
float Floating point number.
image Binary data greater than 255 bytes.
integer Integer.
smallint SQL Server system data type that holds whole numbers from -2^31 (-2,147,483,647) through 2^31-1 (2,147,483,647). Its storage size is 2 bytes.
tinyint SQL Server system data type that holds whole numbers from 0 through 255. Its storage size is 1 byte.
text Longest text field available; 8000 bytes in SQL Server.
nvarchar(n) Variable-length character text unless otherwise indicated.
uniqueidentifier Contains a unique identification number stored as a 16-byte binary string; a globally unique identifier (GUID).

Where Project Server 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

Indicator symbols

The following indicator symbols are available in Project:

Value Indicator symbol
0 None
1 Sphere, Lime
2 Sphere, Yellow
3 Sphere, Red
4 Sphere, Black
5 Sphere, White
6 Sphere, Aqua
7 Sphere, Green
8 Sphere, Blue
9 Sphere, Fuchsia
10 Sphere, Purple
11 Sphere, Maroon
12 Sphere, Silver
13 Sphere, Gray
14 Flag, Lime
15 Flag, Yellow
16 Flag, Red
17 Flag, White
18 Flag, Aqua
19 Flag, Blue
20 Flag, Fuchsia
21 Flag, Gray
22 Square, Lime
23 Square, Yellow
24 Square, Red
25 Square, Black
26 Square, White
27 Plus, Lime
28 Plus, Yellow
29 Plus, Red
30 Plus, Black
31 Plus, White
32 Minus, Lime
33 Minus, Yellow
34 Minus, Red
35 Minus, Black
36 Minus, White
37 Diamond, Lime
38 Diamond, Yellow
39 Diamond, Red
40 Arrow, Left
41 Arrow, Right
42 Arrow, Double
43 Arrow, Up
44 Arrow, Down
45 Circle, Solid Fill
46 Circle, Bottom Fill
47 Circle, Left Fill
48 Circle, Top Fill
49 Circle, Right Fill
50 Circle, Outer Fill
51 Circle, No Fill (Hollow)
52 Light Bulb, Off
53 Light Bulb, On
54 Check Mark
55 Delete Mark
56 Question Mark
57 Clock
58 Push Pin
59 Happy Face, Yellow
60 Happy Face, Lime
61 Straight Face, Yellow
62 Straight Face, Aqua
63 Sad Face, Yellow
64 Sad Face, Red
65 Dash
Top

MSP_WEB_ADMIN

This table stores settings for Project Web Access and Project Server. You can manage many of the settings in this table through the Admin page of Project Web Access.

Column Name Data Type Description
WADMIN_IDFAKE integer The primary key for the MSP_WEB_ADMIN table.
WADMIN_AUTHENTICATION_TYPE integer The type of authentication used by Project Web Access when users log on:
1 Windows Authentication only
2 Project Server authentication only
3 Mixed (default)
WADMIN_NEW_ACCOUNT_PRIVILEGE integer Indicates whether managers and/or resources are allowed to create user accounts:
0 Neither managers or resources are allowed to create user accounts
1 Only managers are allowed to create user accounts
2 Only resources are allowed to create user accounts
3 Both managers and resources are allowed to create user accounts (default)
This field is obsolete now with the new security model.
WADMIN_IS_DELEGATION_ALLOWED tinyint Indicates whether a resource assigned a task can delegate that task to another resource.
WADMIN_AUTH_REQUIRED_FOR_PUBLISH tinyint Indicates whether users are required to authenticate to Project Server before publishing projects.
WADMIN_WEEK_STARTS_ON integer The day of the week that a time period begins:
0 Sunday
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
WADMIN_MIN_PASSWORD_LENGTH integer The minimum length for passwords in Project Web Access. The default is eight characters; changing this will not affect existing password lengths.
WADMIN_NTFY_FROM_EMAIL nvarchar(100) The contents of the From address field as defined on the Notifications and reminders page (Customize Project Web Access activity) in the Admin center of Project Web Access.
WADMIN_NTFY_EMAIL_TRAILER nvarchar(255) The contents of the Company e-mail address field as defined on the Notifications and reminders page (Customize Project Web Access activity) in the Admin center of Project Web Access.
WADMIN_ORG_EMAIL_ADDRESS nvarchar(100) The company's e-mail address as defined on the Notifications and reminders page (Customize Project Web Access activity) in the Admin center of Project Web Access.
WADMIN_DEFAULT_LANGUAGE integer Indicates the default language for e-mail; see MSP_WEB_INSTALLED_LANGUAGES for more information.
WADMIN_DEFAULT_TRACKING_METHOD integer Indicates the tracking method used for reporting hours worked on tasks:
1 Hours of work done per day or per week
2 Percent of work complete (default)
3 Actual work done and work remaining
WADMIN_CAN_PUBLISH_CONSOLIDATED _PROJECTS tinyint Indicates whether a project plan for a master project can be published.
WADMIN_IS_TRACKING_METHOD_LOCKED tinyint Indicates whether project managers are allowed to change the default tracking method; see WADMIN_DEFAULT_TRACKING_METHOD.
WADMIN_TRANS_HISTORY_DAYS integer Sets the number of days (1-30) to keep in the transaction history.
WADMIN_TIMESHEET_SPAN tinyint Indicates whether a timesheet spans a weekly or monthly time period:
0 Weekly
1 Monthly
WADMIN_WEEKLY_TIMESHEET_NUM_WEEKS tinyint Indicates the number of weeks spanned (1-4) for each time period; only available if timesheets span a weekly time as specified in WADMIN_TIMESHEET_SPAN.
WADMIN_MONTHLY_REPORTS_PER_MONTH tinyint Indicates the number of time reporting periods (1-3) in a month; only available if timesheets span a monthly time as specified in WADMIN_TIMESHEET_SPAN:
1 One reporting period per month
2 Two reporting periods per month
3 Three reporting periods per month
WADMIN_MONTHLY_1PRD_1ST_START tinyint Indicates the day of the month the first reporting period is to begin.
WADMIN_MONTHLY_2PRDS_1ST_START tinyint Indicates the day of the month the first reporting period begins and the day of the month the second reporting period ends; only available if there are two reporting periods per month as specified in WADMIN_MONTHLY_REPORTS_PER_MONTH.
WADMIN_MONTHLY_2PRDS_1ST_END tinyint Indicates the day of the month the first reporting period ends and the day of the month the second reporting period begins; only available if there are two reporting periods per month as specified in WADMIN_MONTHLY_REPORTS_PER_MONTH.
WADMIN_MONTHLY_3PRDS_1ST_START tinyint Indicates the day of the month the first reporting period begins and the day of the month the third reporting period ends; only available if there are three reporting periods per month as specified in WADMIN_MONTHLY_REPORTS_PER_MONTH.
WADMIN_MONTHLY_3PRDS_1ST_END tinyint Indicates the day of the month the first reporting period ends and the day of the month the second reporting period begins; only available if there are three reporting periods per month as specified in WADMIN_MONTHLY_REPORTS_PER_MONTH.
WADMIN_MONTHLY_3PRDS_2ND_END tinyint Indicates the day of the month the second reporting period ends and the day of the month the third reporting period begins; only available if there are three reporting periods per month as specified in WADMIN_MONTHLY_REPORTS_PER_MONTH.
WADMIN_MAX_HOUR_PER_DAY decimal Indicates the maximum number of hours per day (1-24 or unlimited) that resources can enter in their timesheet.
WADMIN_LOOKAHEAD integer Indicates the number of days ahead of a task's actual start date that a task will appear in an assigned resource's current task list; default is 10.
WADMIN_TIMEPERIOD_GRANULARITY tinyint Indicates the frequency that resources will report hours worked:
0 Resources should report total hours worked for a specified time period
1 Resources should report hours worked every day
2 Resources should report total hours worked for a week
WADMIN_LICENSES integer The current number of licensed copies of Project Web Access that are available.

NoteB B For details about licensing for Project Server and Project Web Access, see the Microsoft end-user license agreements for the products.

WADMIN_AUTO_CREATE_SUBWEBS tinyint Indicates whether Windows SharePoint Services sites are created automatically when a project is first published in Project Server (default) or whether they are created manually by the administrator.
WADMIN_AUTO_ADD_USER_TO_SUBWEB tinyint Indicates whether Project Server users are automatically added to the public site when it is created.
WADMIN_AUTO_ADD_USER_AS _ADV_AUTHOR_TO_SUBWEB tinyint Indicates whether new Project Server users are automatically added into the Web Designer role on the current server running Windows SharePoint Services (see WADMIN_CURRENT_STS_SERVER_ID).
WADMIN_CURRENT_STS_SERVER_ID integer Refers to a valid WSTS_SERVER_ID in the MSP_WEB_STS_SERVERS table; set to -1 if there is no current server.
WADMIN_ENABLE_ENTERPRISE tinyint Indicates whether enterprise features are enabled. If set to 1, users will be granted access to building Assignment and Resource cubes, will be able to check in enterprise projects and enterprise resources, and will be able to manage enterprise versions.
WADMIN_DISPLAY_MASTER_IN_ENTERPRISE tinyint Indicates whether master projects are allowed in Project Server.
WADMIN_ALLOW_LOCAL_BASE_CALS _IN_ENTERPRISE tinyint Indicates whether projects are allowed to use local base calendars.
WADMIN_NPE_LAST_RUN datetime The last date and time the NPE was run; the NPE has not been run if this field is NULL.
WADMIN_NPE_NEXT_RUN datetime The next date and time the NPE will be run; the date and time has not been set if this field is NULL.
WADMIN_NPE_SCHEDULED_TIME integer The scheduled time (in integer, time only, no date). For example: 233030 = 23:30:30.
WADMIN_PUBDOCS_STS_SUBWEB_NAME nvarchar(128) The name of the subweb associated with the server running Windows SharePoint Services. The default value is (N'MS_ProjectServer_PublicDocuments').
WADMIN_ENFORCE_CURRENCY tinyint Indicates whether the user has to use the default currency set in the enterprise global template.
WADMIN_LAST_STS_ADMIN_SYNCH_TIME nvarchar(50) The last time the administrators between Project Server and servers running Windows SharePoint Services were synchronized.
WADMIN_SMTP_SERVER_NAME nvarchar(256) The name of the SMTP server.
WADMIN_SMTP_SERVER_PORT integer The port used by the SMTP server.
WADMIN_INTRANET_SERVER_URL nvarchar(255) Intranet URL for the Project Server computer.
WADMIN_EXTRANET_SERVER_URL nvarchar(255) Extranet URL for the Project Server computer.
WADMIN_ONLY_PRO_PUBLISH tinyint Indicates whether only projects created with Project Professional may be published to Project Server.
WADMIN_PROTECT_ACTUALS tinyint Indicates whether actuals should be protected.
WADMIN_STS_TEMPLATE_LCID integer The language ID for the Windows SharePoint Services template used to create a site.
WADMIN_STS_TEMPLATE_ID nvarchar(50) The ID for the Windows SharePoint Services template used to create a site in Project Web Access.
WADMIN_STS_PRIMARY_OWNER_EMAIL nvarchar(100) The e-mail address for the primary owner of Windows SharePoint Services.
WADMIN_STS_SECONDARY_OWNER_NAME nvarchar(255) The name of the secondary owner of Windows SharePoint Services.
WADMIN_STS_SECONDARY_OWNER_EMAIL nvarchar(100) The e-mail address for the secondary owner of Windows SharePoint Services.
WADMIN_STS_PORTAL_URL nvarchar(1024) The URL for the SharePoint Portal Server associated with Project Server.
WADMIN_STS_PORTAL_NAME nvarchar(255) The name of the SharePoint Portal Server associated with Project Server.
WADMIN_BUILD_TEAM_BY_RBS tinyint Indicates whether users can assign resources they manage; this is used with the Team Builder Lite feature of Project Server.
WADMIN_VERSION_MAJOR tinyint This field is used with WADMIN_VERSION_MINOR, WADMIN_VERSION_BUILD, and WADMIN_VERSION_REVISION to identify the Project Server build number.
WADMIN_VERSION_MINOR tinyint This field is used with WADMIN_VERSION_MAJOR, WADMIN_VERSION_BUILD, and WADMIN_VERSION_REVISION to identify the Project Server build number.
WADMIN_VERSION_BUILD integer This field is used with WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, and WADMIN_VERSION_REVISION to identify the Project Server build number.
WADMIN_VERSION_REVISION tinyint This field is used with WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, and WADMIN_VERSION_BUILD to identify the Project Server build number.
WADMIN_IS_HOSTED_ORG tinyint Indicates whether Project Server is part of a hosted organization (multiple Project Server sites accessing a single server running Windows SharePoint Services) or a standalone organization (a single Project Server site accessing a single server running Windows SharePoint Services).
Top

MSP_WEB_ADMIN_AD

This table stores information that is used when synchronizing Project Server security groups and members of the Project Server enterprise resource pool with resources in Active Directory.

Column Name Data Type Description
WADMIN_AD_ID integer The unique ID for the Active Directory settings.
WADMIN_AD_GRP_ENABLE_UPDATE tinyint Indicates whether Active Directory synchronization is enabled.
WADMIN_AD_GRP_AUTO_LAST_RUN datetime The date and time of the most recent Active Directory synchronization.
WADMIN_AD_GRP_LOG_TIMESTAMP datetime The data and time of the most recent log entry for Active Directory synchronization.
WADMIN_AD_GRP_LOG_STATUS integer The status of the Active Directory log:
0 Never
1 Success
2 Failure
WADMIN_AD_GRP_LOG_STATUS_TEXT nvarchar(255) The text of the error message in the Active Directory synchronization log.
WADMIN_AD_GRP_UPDATE_FREQ_EVERY integer Indicates the rate of Active Directory synchronization.
WADMIN_AD_GRP_UPDATE_FREQ_UNIT integer Indicates the frequency of Active Directory synchronization:
0 Day (Default)
1 Week
2 Month
WADMIN_AD_GRP_START_DATE datetime The day of the week that Active Directory synchronization is scheduled to begin; based on WADMIN_AD_GRP_UPDATE_FREQ_UNIT.
WADMIN_AD_GRP_START_TIME integer The start time for Active Directory; based on WADMIN_AD_GRP_UPDATE_FREQ_UNIT.
WADMIN_AD_GRP_UPDATE tinyint Indicates whether Active Directory synchronization is in progress.
WADMIN_AD_ERESPOOL_ENABLE_UPDATE tinyint Indicates whether the Active Directory synchronization process is tied to population of the Project Server enterprise resource pool.
WADMIN_AD_ERESPOOL_GROUP nvarchar(64) The name of the Active Directory security group that the enterprise resource pool is mapped to.
WADMIN_AD_ERESPOOL_AUTO_LAST_RUN datetime The date and time of the most recent synchronization between Active Directory and the enterprise resource pool.
WADMIN_AD_ERESPOOL_LOG_TIMESTAMP datetime The data and time of the most recent log entry for Active Directory synchronization, related to the enterprise resource pool.
WADMIN_AD_ERESPOOL_LOG_STATUS integer The status of the Active Directory log, related to the enterprise resource pool:
0 Never
1 Success
2 Failure
WADMIN_AD_ERESPOOL_LOG_STATUS_TEXT nvarchar(255) The text of the error message in the Active Directory synchronization log, related to the enterprise resource pool.
WADMIN_AD_ERESPOOL_UPDATE_FREQ_EVERY integer Inidicates the rate of Active Directory synchronization.
WADMIN_AD_ERESPOOL_UPDATE_FREQ_UNIT integer Indicates the frequency of Active Directory synchronization:
0 Day (Default)
1 Week
2 Month
WADMIN_AD_ERESPOOL_START_DATE datetime The day of the week that Active Directory synchronization to the enterprise resource pool is scheduled to begin; based on WADMIN_AD_ERESPOOL_UPDATE_FREQ_UNIT.
WADMIN_AD_ERESPOOL_START_TIME integer The start time for Active Directory synchronization to the enterprise resource pool; based on WADMIN_AD_ERESPOOL_UPDATE_FREQ_UNIT.
WADMIN_AD_ERESPOOL_UPDATE tinyint Indicates whether Active Directory synchronization to the enterprise resource pool is in progress.
Top

MSP_WEB_ADMIN_CUBE

This table stores information related to setting up the Assignment and Resource cubes, which help provide analysis and reporting functionality in Project Web Access. The following tables are generated when building an Assignment or Resource cube. Please see each table's description for more information about the type of data stored in them:

Column Name Data Type Description
PK WADMIN_CUBE_ID integer The unique ID for the Assignment or Resource cube.
WADMIN_CUBE_BUILD tinyint Indicates whether to build an Assignment or Resource cube of data.
WADMIN_CUBE_OLAP_SERVER nvarchar(100) The name of the OLAP server; required if building an OLAP cube of data.
WADMIN_CUBE_NAME nvarchar(100) The name of the cube.
WADMIN_CUBE_DESCRIPTION nvarchar(255) The description of the cube; optional if building an OLAP cube of data.
WADMIN_CUBE_DATE_RANGE integer Indicates the date range to use when building an OLAP cube:
0 Use the earliest project start date and the latest project finish date (default)
1 Use a rolling date range that begins "x" days before and ends "y" days after the current date
2 Use a date range with fixed start and fixed end dates
WADMIN_CUBE_DATE_RANGE_NEXT_NUM integer Indicates the number of units (days, weeks, or months) to use after the current date when building an OLAP cube; required if you use a rolling date range when building an OLAP cube.
WADMIN_CUBE_DATE_RANGE_NEXT_UNIT integer Indicates the timescale for a rolling date range when building an OLAP cube:
0 Day (default)
1 Week
2 Month
WADMIN_CUBE_DATE_RANGE_PAST_NUM integer Specifies the number of units (days, weeks, or months) to use before the current date when building an OLAP cube; required if you use a rolling date range when building an OLAP cube.
WADMIN_CUBE_DATE_RANGE_PAST_UNIT integer Indicates the timescale for a rolling date range when building an OLAP cube:
0 Day (default)
1 Week
2 Month
WADMIN_CUBE_DATE_RANGE_FROM datetime Specifies the start date to use when building an OLAP cube; required if you use a date range with a fixed start and end date.
WADMIN_CUBE_DATE_RANGE_TO datetime Specifies the end date to use when building an OLAP cube; required if you use a date range with a fixed start and end date.
WADMIN_CUBE_LOG_STATUS_TIMESTAMP datetime The most recent date and time that the admin cube log was accessed.
WADMIN_CUBE_LOG_STATUS integer The status of the log timestamp:
-1 Warning; the cube was built, but not everything was built correctly
0 The cube was built correctly
Any The cube was built incorrectly (failed); refer to WADMIN_CUBE_LOG_STATUS_TEXT for the specific error message
WADMIN_CUBE_LOG_STATUS_TEXT nvarchar(255) The text of the error message.
WADMIN_RES_DATE_RANGE integer Indicates the date range to use for resource availability when building a resource cube:
0 Use a rolling date range that begins "x" days before and ends "y" days after the current date
1 Use a date range with a fixed start and end date
WADMIN_RES_DATE_RANGE_NEXT_NUM integer Specifies the number of units (days, weeks, or months) to use after the current date when building a resource cube; required if you use a rolling date range when building a resource cube.
WADMIN_RES_DATE_RANGE_NEXT_UNIT integer Indicates the timescale for a rolling date range when building a resource cube:
0 Day (default)
1 Week
2 Month
WADMIN_RES_DATE_RANGE_PAST_NUM integer Specifies the number of units (days, weeks, or months) to use before the current date when building a resource cube; required if you use a rolling date range when building a resource cube.
WADMIN_RES_DATE_RANGE_PAST_UNIT integer Indicates the timescale for a rolling date range when building a resource cube:
0 Day (default)
1 Week
2 Month
WADMIN_RES_DATE_RANGE_FROM datetime Specifies the availability start date to use when building a Resource cube; required if you use a data range with a fixed start and end date.
WADMIN_RES_DATE_RANGE_TO datetime Specifies the availability end date to use when building a Resource cube; required if you use a data range with a fixed start and end date.
WADMIN_AUTO_LAST_RUN datetime The date and time that the Assignment or Resource cube was last created automatically by the cube generation process built into Project Server and Project Web Access. This field is not changed by manual updates.
WADMIN_UPDATE_RECUR tinyint Indicates whether updates occur every "x" number of days, weeks, or months (default), or only when specified.
WADMIN_UPDATE_FREQ_EVERY integer Specifies the number of units (days, weeks, or months) that are used when automatically updating an Assignment or Resource cube.
WADMIN_UPDATE_FREQ_UNIT integer Indicates the timescale for the units that are used when automatically updating an Assignment or Resource cube:
0 Day (default)
1 Week
2 Month
WADMIN_UPDATE_FREQ_START_DATE datetime The day of the week that the WADMIN_UPDATE_FREQ_UNIT begins.
WADMIN_UPDATE_FREQ_START_TIME integer The time of day that the WADMIN_UPDATE_FREQ_UNIT begins.
WADMIN_UPDATE_RES tinyint Indicates whether a resource cube is being built; this field should be 0 unless you look at the database while building a cube. If this field is set to 1 and you are not building a cube, then an error has occurred.
WADMIN_UPDATE_CUBE tinyint Indicates whether an OLAP cube is being built; this field should be 0 unless you look at the database while building a cube. If this field is set to 1 and you are not building a cube, then an error has occurred.
WADMIN_CUBE_EXTRANET_OLAP_SERVER nvarchar(255) The name of the extranet OLAP server.
WADMIN_CUBE_BUILD_GUID uniqueidentifier Stores a GUID used to validate user access to the OLAP cube. You should not modify the contents of this field.
Top

MSP_WEB_ADMIN_LINKS

This table stores information needed to display links and content on the Project Web Access Home page. This information can be managed by clicking Admin, Customize Project Web Access, and then Home page format in Project Web Access.

NoteB B Use caution when adding content from an external Web site to your Project Web Access Home page. You should perform a thorough security check on all external content you want to add to Project Web Access. If you do not perform this security check, you may leave your Project Web Access site open to unnecessary security risks.

Column Name Data Type Description
PK WLINKS_ID integer The unique ID for the link or content.
WLINKS_HREF nvarchar(500) The full path for the link or content, including the http:// or full path name.
WLINKS_NAME nvarchar(255) The name of the link or content file.
WLINKS_HEIGHT nvarchar(255) The height in pixels that a content section occupies on the Project Web Access Home page; this field should not be used for links.
WLINKS_TYPE integer Indicates whether the row is a link or content:
0 Link
1 Content
Top

MSP_WEB_ASSIGNMENTS

This table contains assignment data plus project summary records.

Column Name Data Type Description
PK WASSN_ID integer The unique ID for the assignment.
WRES_ID integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WASSN_PARENT_ID integer Refers to a valid WASSN_ID in the MSP_WEB_ASSIGNMENTS table if this assignment has a parent assignment.
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
WRES_ID_MGR integer The ID of the project manager for this task. Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
ASSN_UID integer Refers to a valid ASSN_ID in the MSP_ASSIGNMENTS table.
TASK_UID integer Refers to a valid TASK_UID in the MSP_TASKS table.
TASK_ID integer Refers to a valid TASK_ID in the MSP_TASKS table.
TASK_UID_SUMMARY integer Refers to a valid TASK_UID in the MSP_ASSIGNMENTS table if this task is a summary task.
TASK_NAME nvarchar(255) Refers to a valid TASK_NAME field in the MSP_TASKS table.
ASSN_START_DATE datetime The date and time that an assigned resource is scheduled to begin working on a task.
ASSN_FINISH_DATE datetime The date and time that an assigned resource is scheduled to complete work on a task.
ASSN_WORK decimal The total amount of work scheduled to be performed by a resource on a task.
ASSN_ACT_WORK decimal The amount of work that has already been done by a resource on a task.
ASSN_REM_WORK decimal The amount of time required by a resource assigned to a task to complete an assignment.
WASSN_LAST_WORK decimal The scheduled work from the last update from Project.
WASSN_COMMENTS ntext Contains user comments about the assignment; archived to WASSN_HISTORY_NOTES when a manager updates the assignment.
WASSN_HISTORY_NOTES ntext Contains history notes about the assignment.
WASSN_NOTE_STATUS integer Indicates whether a note has been entered for the assignment:
0 There are no notes for this assignment
1 There are current notes for this assignment
2 There are only history notes for this assignment
TASK_IS_MILESTONE tinyint Indicates whether a task is a milestone.
TASK_IS_SUMMARY tinyint Indicates whether a task is a summary task.
WASSN_IS_CONFIRMED tinyint Indicates whether a resource assigned to a task has accepted or rejected the task assignment.
WASSN_MGR_UPDATED tinyint Indicates whether the assignment has been updated by a manager.
WASSN_CREATED_BY_RES integer Indicates whether a new task was created by a resource:
0 Not a new task created by a resource
1 A new task created by a resource
2 A new task sent to a Project Manager, but not yet updated
WASSN_REMOVED_BY_RESOURCE integer Indicates whether the assignment has been removed from a resource's timesheet by that resource.
WASSN_CURRENT_TRACKING_MODE integer Indicates the current method used to track projects:
0 None (default)
1 Timephased actuals
2 Percent complete tracking
3 Total actual work and remaining work tracking
WASSN_UPDATE_TRACKING_MODE integer Indicates the updated method used to track projects:
0 None (default)
1 Timephased actuals
2 Percent complete tracking
3 Total actual work and remaining work tracking
WASSN_SEND_UPDATE_NEEDED tinyint Indicates whether an update should be sent to resources for this assignment.
WASSN_DELETED_IN_PROJ tinyint Indicates whether an assignment has been deleted by the manager.
WASSN_RESOURCE_UPDATE tinyint Indicates whether a team resource has submitted actuals.
WASSN_REQUEST_UPDATE tinyint Indicates whether an actuals update was requested.
WASSN_UPDATES_ACCEPTED tinyint Indicates whether a task update has been accepted by the resource or manager.
WASSN_DELEG_ACCEPTED tinyint Indicates whether task delegation has been accepted by the resource.
WASSN_DELEG_APPROVED tinyint Indicates whether task delegation has been approved by the manager.
WASSN_ACTUALS_PENDING tinyint Indicates whether actuals have been submitted, but not yet updated by the manager.
WASSN_DELEG_PENDING tinyint Indicates whether task delegation is pending manager approval.
WASSN_IS_DELEGATED tinyint Indicates whether an assignment has been delegated since the last update.
WASSN_IS_NEW_ASSN tinyint Indicates whether the assignment is a new assignment.
WASSN_UPDATE_STATUS integer Indicates the status of an assignment:
0 Not edited by resource
1 Edited by resource but not updated to the project manager yet
WASSN_LAST_DELEG_ID integer The last delegation performed on this assignment; refers to a valid ID in the MSP_WEB_DELEGATIONS table.
WASSN_PCT_COMP integer The percent work complete value of the assignment.
WASSN_SEND_UPDATE_DATE datetime The date and time that an assignment update was sent by a resource to a manager.
WASSN_SUMMARY_PROGRESS datetime Shows progress on a summary task, based on the progress of its subtasks and where these subtasks have been scheduled.
WRES_ID_TEAM_LEAD integer The ID of the team lead; refers to a valid ID in the MSP_WEB_RESOURCES table.
WNWRK_ID integer Refers to a valid WNWRK_ID in the MSP_WEB_NONWORKING_CATEGORIES table.
WNWRK_ENTRY_ID nvarchar(300) The entry ID of the appointment in Microsoft Outlook.
RESERVED_DATA1 integer Used to temporarily store editable, calculated values; you should not edit the values in this field.
RESERVED_DATA2 integer Used to temporarily store editable, calculated values; you should not edit the values in this field.
RESERVED_DATA3 integer Used to temporarily store editable, calculated values; you should not edit the values in this field.
ASSN_BOOKING_TYPE smallint Indicates the booking type of an assignment:
0 Hard
2 Soft
WASSN_ASSIGNED_TO_EXISTING tinyint Indicates whether a new assignment has been created by a resource using the assign self to existing task feature.
Top

MSP_WEB_CALENDAR_TRANSACTIONS

This table tracks calendar transactions, including the date of each transaction and the WRES_IDs of all senders and receivers.

Column Name Data Type Description
PK WCTRANS_ID integer The unique ID for the calendar transaction.
WNONWORK_ID integer Refers to a valid WNONWORK_ID in the MSP_WEB_NONWORKING table.
WCTRANS_DATE datetime The date of the calendar transaction.
WCTRANS_ACTION integer Indicates the action taken for the transaction:
0 No action taken
1 Accept
2 Reject
WRES_ID_CTRANS_RECEIVER integer Manager who receives the calendar transaction. Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WRES_ID_CTRANS_SENDER integer Resource that submits a calendar transaction. Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
Top

MSP_WEB_CONVERSIONS

This table stores the static text in Project Server 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.

Column Name Data Type Description
PK STRING_TYPE_ID integer Refers to a valid STRING_TYPE_ID in the MSP_WEB_STRING_TYPES table.
PK CONV_VALUE integer The ID value of the string.
PK LANG_ID integer The ID of the language in which the conversion text is displayed, for example: 1033 is the language ID for English, the default language for the database.
CONV_STRING nvarchar(1000) The text value of the string.
Top

MSP_WEB_DELEGATION_ASSIGNMENTS

This table normalizes delegation information for assignments, including whether an assignment has been approved, whether it has been accepted, and whether a copy of the assignment is being kept in order to track progress.

Column Name Data Type Description
PK WDELEG_ID integer The unique ID for the delegation assignment.
PK WASSN_ID integer Refers to a valid WASSN_ID in the MSP_WEB_ASSIGNMENTS table.
WDELEG_APPROVE tinyint Indicates whether an assignment delegation has been approved by the manager.
WDELEG_ACCEPT tinyint Indicates whether an assignment delegation has been accepted by the resource who received the assignment.
WDELEG_KEEP_COPY tinyint Indicates whether the delegator chose to keep a copy of the assignment after delegation to track its progress.
Top

MSP_WEB_DELEGATIONS

This table stores information about delegations, including who sent the message, who received the message, the data that was sent in the message, whether to keep a copy of the message, and whether the delegation was rejected by the assigned resource.

Column Name Data Type Description
PK WDELEG_ID integer The unique ID for the delegation.
WRES_ID_DELEGATOR integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WRES_ID_DELEGATEE integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WDELEG_KEEP_COPY tinyint Indicates whether to keep a copy of a delegated assignment in the delegator's timesheet.
WDELEG_DATE datetime The date and time the assignment delegation was sent to the resource.
WDELEG_REJECT tinyint Indicates whether the resource accepts or rejects the assignment.
Top

MSP_WEB_GANTT_SCHEMES

This table contains all of the possible grouping schemes available for use in Project Web Access.

Column Name Data Type Description
PK WGANTT_SCHEME_ID integer Refers to a valid WGANTT_SCHEME_ID in the MSP_WEB_GANTT_SETTINGS table.
WGANTT_SCHEME_TYPE integer Indicates the type of Gantt scheme:
0 Personal Gantt (default)
1 Assignment or Portfolio views Gantt
2 Project views Gantt
WGANTT_SCHEME_NAME nvarchar(50) The name of the Gantt scheme.
Top

MSP_WEB_GANTT_SETTINGS

Project Server has nine default Gantt Chart styles and eleven customizable Gantt Chart styles.

This information is managed from the Admin tab in Project Server. Though it is possible to modify this information directly in the database, it is recommended that you use the interface provided in Project Server.

Column Name Data Type Description
PK WGANTT_SCHEME_ID integer The unique ID for the Gantt scheme.
PK WGANTT_STYLE_ID integer The unique ID for the Gantt bar:
0 Normal task
1 Critical task
2 External task
3 Delegated task
4 Milestone
5 Summary task
6 Project summary (default)
7 Group by summary
8 Progress
9 Summary progress
10 Baseline task
11 Baseline summary
12 Baseline milestone
13 Pre-leveled task
14 Pre-leveled summary
15 Pre-leveled 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 tinyint Indicates whether the Gantt bar is shown.
WGANTT_BAR_TYPE integer The type of line drawn for the Gantt bar:
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 integer The fill pattern for the Gantt bar:
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 integer The color for the Gantt bar pattern:
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 integer The start shape of the Gantt bar:
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 integer The color for the Gantt bar start shape:
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_END_SHAPE integer The end shape of the Gantt bar:
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_END_COLOR integer The color for the Gantt bar end shape:
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
Top

MSP_WEB_GANTT_STYLES

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

Column Name Data Type Description
PK WGANTT_STYLE_ID integer Refers to a valid WGANTT_STYLE_ID in the MSP_WEB_GANTT_SETTINGS table.
WGANTT_STYLE_CONV_VALUE integer Each Gantt Chart style has an associated text ID. This field references the actual string that is stored in the MSP_WEB_CONVERSIONS table by joining with the CONV_VALUE field in that table.
Top

MSP_WEB_GROUP_SCHEMES

This table contains all of the possible grouping styles available for use in Project Server. Timesheet and Views are default styles; there are nine custom grouping styles. See MSP_WEB_GROUP_SETTINGS for more information about how to customize the grouping styles.

Column Name Data Type Description
PK WGROUP_SCHEME_ID integer Refers to a valid WGROUP_SCHEME_ID in the MSP_WEB_GROUP_SETTINGS table
WGROUP_SCHEME_NAME nvarchar(50) The name of the grouping style, for example: "Timesheet" or "Views"
Top

MSP_WEB_GROUP_SETTINGS

Project Server can display a personal grouping style on the Tasks page and can display up to 10 different styles of grouping level color schemes in the Views section.

This information is managed from the Admin tab in Project Server. Though it is possible to modify this information directly in the database, it is recommended that you use the interface provided in Project Server.

Column Name Data Type Description
PK WGROUP_SETTING_ID integer The unique ID for the Group setting
PK WGROUP_SCHEME_ID integer The unique ID for the Group scheme
WGROUP_STYLE_ID integer The unique ID for the Group style
WGROUP_ROW_COLOR integer Indicates the background color for cells that appear in the grids:
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 (default)
16 Silver
WGROUP_ROW_PATTERN integer Indicates the color pattern for cells that appear in the grids:
0 Hollow
1 Solid fill
2 Light fill
3 Medium fill
4 Dark fill (default)
5 Diagonal left
6 Diagonal right
7 Diagonal cross
8 Line vertical
9 Line horizontal
10 Line cross
WGROUP_TEXT_COLOR integer Indicates the text color for cells that appear in the grids:
1 Black
2 Red
3 Yellow
4 Lime
5 Aqua
6 Blue
7 Fuchsia
8 White (default)
9 Maroon
10 Green
11 Olive
12 Navy
13 Purple
14 Teal
15 Gray
16 Silver
WGROUP_FONT_STYLE integer Indicates the text style color for cells that appear in the grids:
1 Regular (default)
2 Italic
3 Bold
4 Bold italic
Top

MSP_WEB_GROUP_STYLES

This table indicates the level of the grouping style (Level 1, Level 2, Level 3, or Level 4) and maps the grouping style to the MSP_WEB_CONVERSIONS table.

Column Name Data Type Description
PK WGROUP_STYLE_ID integer Refers to a valid WGROUP_STYLE_ID in the MSP_WEB_GROUP_STYLES table
WGROUP_STYLE_CONV_VALUE integer Links the group style to a corresponding value in the CONV_VALUE field in the MSP_WEB_CONVERSIONS table
Top

MSP_WEB_INSTALLED_LANGUAGES

This table stores information for all installed languages for Project Server and links the language to the localized strings in the MSP_WEB_CONVERSIONS table.

Column Name Data Type Description
PK WLANG_LCID integer The LCID for the language, for example: 1033 (English)
CONV_VALUE integer Refers to a localized language name string in the MSP_WEB_CONVERSIONS table
Top

MSP_WEB_MESSAGES

This table is no longer used for messaging. Its only remaining purpose is to support calendar transactions to link entries in MSP_WEB_NONWORKING and MSP_CALENDAR_TRANSACTIONS. Most of the fields are obsolete but are kept for backward compatibility.

Column Name Data Type Description
PK WMSG_ID integer The unique ID for the message.
WMSG_PROJ_TYPE integer Indicates the type of message. This value is always 2 for nonworking notification.
WRES_ID_SENDER integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WRES_ID_RECEIVER integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WMSG_SUBJECT nvarchar(255) This field is obsolete but kept for backward compatibility.
WMSG_BODY nvarchar(3000) This field is obsolete but kept for backward compatibility.
WMSG_TIME datetime This field is obsolete but kept for backward compatibility.
WPROJ_ID integer This field is obsolete but kept for backward compatibility.
WMSG_ACTUAL_TYPE integer This field is obsolete but kept for backward compatibility.
WMSG_PERIOD_START datetime This field is obsolete but kept for backward compatibility.
WMSG_PERIOD_FINISH datetime This field is obsolete but kept for backward compatibility.
WMSG_PERIOD_BROKEN_BY integer This field is obsolete but kept for backward compatibility.
WMSG_PERIOD_WEEK_STARTS_ON integer This field is obsolete but kept for backward compatibility.
WMSG_WAS_READ tinyint This field is obsolete but kept for backward compatibility.
WMSG_PROCESS_ST integer This field is obsolete but kept for backward compatibility.
WMSG_RES_CAN_DECLINE tinyint This field is obsolete but kept for backward compatibility.
Top

MSP_WEB_MESSAGES_ASSIGNMENTS

This table is used to link an entry in the MSP_WEB_ASSIGNMENTS table to an entry in the MSP_WEB_MESSAGES table.

Column Name Data Type Description
PK WMSG_ID integer The unique ID for the assignment message
WASSN_ID integer Refers to a valid WASSN_ID in the MSP_WEB_ASSIGNMENTS table
WASSN_IS_PROCESSED tinyint Indicates whether the message has been sent.
Top

MSP_WEB_MESSAGES_NONWORKING

This table is used to link a nonworking entry in the MSP_WEB_NONWORKING table to the MSP_WEB_MESSAGES table.

Column Name Data Type Description
PK WMSGNONWORK_ID integer The unique ID for the nonworking message; used by calendar transactions when deleting multiple calendar transactions
WMSG_ID integer Refers to a valid WMSG_ID in the MSP_WEB_MESSAGES table
WNONWORK_ID integer Refers to a valid WNONWORK_ID in the MSP_WEB_NONWORKING table
Top

MSP_WEB_MGR_RULES

This table stores information about message rules for the manager, including the type of message and the specific rules associated with that message.

Column Name Data Type Description
PK WRULE_ID integer The unique ID for the rule
WRULE_NAME nvarchar(255) The name of the rule
WRES_ID_MGR integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table
WRULE_IS_ENABLED tinyint Indicates whether the message rule is enabled
WRULE_TYPE integer Indicates the type of rule:
1 All of the below message types
2 All New Task Requests
3 All Task Delegation Requests
4 All Task Updates and replies to messages requesting status
20 Only Task Updates and replies to messages requesting status that fit the criteria for the message rule, as defined in WRULE_CONDITION_TYPE
WRULE_CONDITION_TYPE integer The condition for the rule:
0 Do not check for condition (default)
1 Field1 operator value (see WRULE_FIELD1_ID, WRULE_VALTYPE, and WRULE_OPERATOR)
2 Field1 operator Field2 (see WRULE_FIELD1_ID, WRULE_FIELD2_ID, and WRULE_OPERATOR)
WRULE_FIELD1_ID integer The field ID used for the first condition type
WRULE_FIELD2_ID integer The field ID used for the second condition type
WRULE_OPERATOR integer Indicates the type of operator used when determining the condition type for the rule:
= Equal to
!= Not equal to
> Greater than
< Less than
>= Greater than or equal to (default)
<= Less than or equal to
WRULE_VALTYPE integer Indicates the value type of the data entered:
4 datetime (see WRULE_DATE_VAL)
5 integer (see WRULE_INT_VAL)
6 decimal (see WRULE_DECIMAL_VAL)
21 String (see WRULE_VARCHAR_VAL)
WRULE_INT_VAL integer The value if WRULE_VALTYPE = 4
WRULE_DATE_VAL datetime The value if WRULE_VALTYPE = 5
WRULE_DECIMAL_VAL decimal The value if WRULE_VALTYPE = 6
WRULE_VARCHAR_VAL nvarchar(255) The value if WRULE_VALTYPE = 21
WRULE_IS_EXCL_PROJID tinyint Indicates whether all current projects are included in the rule (default) or only with current, specified projects
WRULE_IS_EXCL_RES1ID tinyint Indicates whether all future resources are included in the rule
WRULE_IS_EXCL_RES2ID tinyint Indicates whether all future resources are included in the rule for task delegation requests only
WRULE_DESCRIPTION nvarchar(255) The description of the rule
Top

MSP_WEB_MGR_RULES_LISTS

This table links included or excluded rules to resources and projects:

  • 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 0 then no projects and/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 1 then all current and future projects and/or resources are included in that rule.

Column Name Data Type Description
PK WRULE_ID integer Refers to a valid WRULE_ID in the MSP_WEB_MGR_RULES table.
PK ITEM_TYPE integer Indicates whether the rule is applied to a project or resource:
0 Project
1 Resource
2 Resource delegated to (used for task delegation rules only)
PK ITEM_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table or a valid WRES_ID in the MSP_WEB_RESOURCES table, depending on the type of rule.

The project or resource is either included in the rule or excluded from the rule, depending on the WRULE_IS_EXCL_n fields in the MSP_WEB_MGR_RULES table. For example, if WRULE_IS_EXCL_PROJID for the same WRULE_ID is set to 0, this project is included for that rule. If it is set to 1, this project is excluded from that rule.

Top

MSP_WEB_MODELS

This table is used by the Portfolio Modeling feature.

Column Name Data Type Description
PK WMOD_MODEL_UID integer The unique ID for the web model.
WMOD_MODEL_NAME nvarchar(255) The name of the web model.
WMOD_MODEL_DESC nvarchar(255) The description of the web model.
WMOD_CREATE_DATE datetime The date the web model was created.
WMOD_UPDATE_DATE datetime The date the web model was last updated.
WMOD_CREATED_BY nvarchar(255) The name of the person who created the model.
WMOD_LAST_UPDATED_BY nvarchar(255) The name of the person who last updated the model.
WMOD_LOCKED_BY nvarchar(255) The name of the person who locked the model.
WMOD_CREATED_BY_ID integer The ID of the resource who created the web model; refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WMOD_LAST_UPDATED_BY_ID integer The ID of the resource who last updated the web model; refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WMOD_LOCKED_BY_ID integer The ID of the resource who locked the web model; refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WMOD_RESERVED_BINARY_DATA image Contains the list of projects, scheduling options, and resources for the model. Reserved for use by Project Server; do not change the values in this field.
WMOD_MODEL image Contains the project definition details used by Portfolio Modeler. Reserved for use by Project Server; do not change the values in this field.
Top

MSP_WEB_NONWORKING

This table stores nonworking time data, including the subject, start time, finish time, whether the nonworking time is an all-day event, and whether the nonworking time is an exception.

Column Name Data Type Description
PK WNONWORK_ID integer Refers to a valid WNWRK_ID in the MSP_WEB_NONWORKING_CATEGORIES table.
WNONWORK_SUBJECT nvarchar(255) The subject of the nonworking time.
WNONWORK_START datetime The date and time that a nonworking time begins.
WNONWORK_END datetime The date and time that a nonworking time ends.
WNONWORK_IS_ALL_DAY tinyint Indicates whether the nonworking time is an all-day event.
WNONWORK_IS_WORKING tinyint Indicates whether the nonworking time is a working time exception.
Top

MSP_WEB_NONWORKING_CATEGORIES

This table assigns a unique ID to each nonworking time category. Sick Leave and Vacation are included as standard, default nonworking time categories in Project Server. All nonworking time categories contained in this table will appear in a resource's timesheet in the order determined by the WNWRK_ORDER field.

Column Name Data Type Description
PK WNWRK_ID integer The unique ID for the nonworking time category.
WNWRK_NAME nvarchar(255) The name of a nonworking time category.
WNWRK_CODE nvarchar(255) Used to assign a code to a category that can be in numeric, text, or Project outline code format.
WNWRK_ORDER integer Determines the order of nonworking time categories appearing in the grid.
Top

MSP_WEB_NOTIFICATION_EVENTS

This table stores e-mail notification messages related to new, updated, or cancelled task assignments.

Column Name Data Type Description
PK WNTFY_EVENT_ID integer The ID for a notification; any notification followed by ** is a notification that is sent automatically and is not available in the user interface:
1001 Sent when I receive a new task assignment
1002 Sent when I receive a task update request **
1003 Sent when my tasks are updated by my project manager
1004 Sent when a new issue is assigned to me
1005 Sent when I receive a new status report
1006 Sent when I become the lead on a task **
1007 Sent when my resources submit new tasks
1008 Sent when my resources delegate their tasks
1009 Sent when my resources update their tasks
1010 Sent when my resources submit working and nonworking time changes
1011 Sent when my resources submit a status report
1016 Sent when a resource rejects an assignment **
1017 Sent when a task update has been rejected by a manager **
1018 Sent when a task request has been rejected by a manager **
1020 Sent to delegator when a manager rejects a task delegation **
1021 Sent to delegatee when a manager rejects a task delegation **
1022 Sent to delegator when a resource rejects a task delegation **
1023 Sent to manager when a resource rejects a task delegation **
1024 Sent when a resource declines their assignment and a manager rejects the declined assignment on the Task Changes page **
1025 Sent when a resource delegates a lead role to another resource **
1026 Sent when a manager removes a resource from an assignment **
1027 Sent when a new team lead has been assigned to the task **
1028 Sent when a status report has been removed **
1030 Sent when I receive a new to-do list task assignment
1031 Sent when a task on my to-do list has been modified
1032 Sent when a task on my to-do list has been cancelled **
1033 Sent when my tasks are delegated **
1034 Sent when an issue created or owned by me is modified
1035 Sent when a new issue is added to the project
1036 Sent when an issue is updated to the project
1038 Sent when new documents are added to my projects
1039 Sent when documents associated with my projects are modified
1040 Sent when documents associated with my projects are deleted
WNTFY_EVENT_DEFAULT tinyint Indicates whether permission is required for the notification:
0 Do not check security for a resource
1 Check the security for a resource; if a resource does not have permission, then a notification will not be sent or shown in the user interface
WNTFY_EVENT_ACTION_ID integer Refers to a valid WSEC_FEA_ACT_ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table.
WNTFY_EVENT_SHOW_UI tinyint Indicates whether this notification is shown in the user interface.
WNTFY_EVENT_QUERY nvarchar(1000) Stores the SQL query statement which is used by this notification.
WNTFY_EMAIL_SUBJECT integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WNTFY_EMAIL_TITLE integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WNTFY_EMAIL_CONTENT integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WNTFY_EMAIL_TAIL1 integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WNTFY_EMAIL_TAIL2 integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WNTFY_EVENT_DESC nvarchar(100) The description for the notification message.
Top

MSP_WEB_NOTIFICATIONS

This table links a resource to a notification stored in the MSP_WEB_NOTIFICATION_EVENTS table.

Column Name Data Type Description
PK WNTFY_OWNER_ID integer Refers to a valid WRES_ID in the MSP_RESOURCES table.
PK WNTFY_EVENT_ID integer Refers to a valid WNTFY_EVENT_ID in the MSP_WEB_NOTIFICATIONS_EVENTS table.
WNTFY_IS_ENABLED tinyint Indicates whether the notification is enabled.
Top

MSP_WEB_OBJECTS

This table stores each object that appears at least once in the MSP_WEB_OBJECT_LINKS table and links external objects to an internal project. External objects include documents, issues, and risks stored on servers running Windows SharePoint Services, external tasks and projects, and anything else that can be linked together, including third party applications. Objects are first described in this table, then linked to each other in the MSP_WEB_OBJECT_LINKS table.

Column Name Data Type Description
PK WOBJ_ID integer The unique ID for the object.
WOBJ_TYPE integer Indicates the type of object:
1 Project
2 Task
3 Windows SharePoint Services Document
4 Windows SharePoint Services Issue
5 Windows SharePoint Services Risk
WOBJ_PROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
WOBJ_TASK_ID integer Refers to a valid TASK_UID in the MSP_WEB_ASSIGNMENTS table.
WOBJ_TP_ID integer Refers to individual objects, documents, and issues stored on a server running Windows SharePoint Services.
WOBJ_LIST_NAME uniqueidentifier The name of the document library.
WOBJ_DESC ntext Reserved for future use.
WOBJ_DOC_REF_CNT integer The number of Windows SharePoint Services documents linked to this object.
WOBJ_ISSUE_REF_CNT integer The number of Windows SharePoint Services issues linked to this object.
WOBJ_OTHER_REF_CNT integer The number of projects or tasks linked to this object.
WOBJ_RISK_REF_CNT integer The number of Windows SharePoint Services risks linked to this object.
Top

MSP_WEB_OBJECT_LINKS

This table links objects to each other; see the MSP_WEB_OBJECTS table for a description of the actual objects. There can only be one link type between any two objects, however any object can be linked to any number of objects.

Column Name Data Type Description
PK WOBJLINK_ID integer The unique ID for the link
WOBJLINK_OBJECT1 integer The object ID of the first object; refers to a valid WOBJ_ID in the MSP_WEB_OBJECTS table
WOBJLINK_OBJECT2 integer The object ID of the second object; refers to a valid WOBJ_ID in the MSP_WEB_OBJECTS table
WOBJLINK_TYPE integer Indicates the type of link:
1 General (default)
2 Affected task (Issues, Risks, and Tasks only)
3 Action item (Issues, Risks, and Tasks only)
Top

MSP_WEB_PROJECT_WORKGROUP_INFO

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

Column Name Data Type Description
PK WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
PK CUSTFIELD_INFO_ID integer Links to MSP_WEB_WORKGROUP_FIELDS_INFO.
PICKLIST_INFO ntext Reserved for future use.
Top

MSP_WEB_PROJECTS

This table stores the list of projects published to Project Server.

Column Name Data Type Description
PK WPROJ_ID integer The unique ID for the project.
PROJ_NAME nvarchar(255) The name of the project.
PROJ_TIMESTAMP nvarchar(32) The timestamp identifier for when the project was most recently published.
WPROJ_DESCRIPTION nvarchar(255) Stores a URL, PATH, or XML blob that uniquely describes a document that is not stored on a server running Windows SharePoint Services.
WLOCAL_PATH nvarchar(260) The network path to the file on the manager's computer.
WPATH nvarchar(260) The UNC path of the file.
WRES_ID integer Refers to a valid ID in the MSP_WEB_RESOURCES table.
WDSN_ID integer The WDSN ID from MSP_WEB_VIEW_DSNS (if the project file is stored in a database).
WPROJ_DELEG_ALLOWED tinyint Indicates whether task delegation is allowed for this project.
WPROJ_IS_NONWORKING tinyint Indicates whether the project is a nonworking project.
WPROJ_SCOPE tinyint Indicates the scope of the project in terms of who gets to view the project. This applies only to to-do lists.
WPROJ_IS_CONSOLIDATED_PROJECT tinyint Indicates whether the project is a consolidated project.
WPROJ_RES_CAN_DECLINE tinyint Indicates whether a resource can decline an assigned task.
WPROJ_DEFAULT_WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table; this maps a version to a default version.
WPROJ_TRACKING_METHOD integer Indicates the tracking method used for reporting hours worked on a specific project:
1 Hours of work done per day or per week
2 Percent of work complete (default)
3 Actual work done and work remaining
WPROJ_LAST_PUB datetime The date and time that a project was last published.
PROJ_ID integer Refers to a valid PROJ_ID in the MSP_PROJECTS table.
WPROJ_TYPE integer Indicates the type of project:
0 Microsoft Project 2000 project
1 Workgroup
2 Enterprise project
3 To-do List project
OPT_DEF_START_TIME datetime The default start time for all new tasks.
OPT_DEF_FINISH_TIME datetime The default finish time for all new tasks.
WPROJ_STS_SUBWEB_NAME nvarchar(128) The name of the subweb that a server running Windows SharePoint Services belongs to.
WSTS_SERVER_ID integer Refers to a valid ID for a server running SharePoint Team Services in the MSP_WEB_STS_SERVERS table.
WPROJ_ISSUE_LIST_NAME uniqueidentifier The Windows SharePoint Services Issues list associated with a project.
WPROJ_RISK_LIST_NAME uniqueidentifier The Windows SharePoint Services Risks list associated with a project.
WPROJ_ADMINPROJECT tinyint Indicates whether this is an admin project.
Top

MSP_WEB_REMINDER_TYPES

This table links reminders to either status reports or assignments, including whether the reminder is a self-reminder and provides the localized e-mail text that is part of the automatic reminder.

Column Name Data Type Description
PK WRMND_TYPE_ID integer The unique ID for the reminder type.
WRMND_TABLE_ID integer Refers to a valid WTABLE_ID in the MSP_WEB_VIEW_TABLES table; only the following WTABLE_IDs are used for this table:
2 Assignments
4 Status reports
WRMND_IS_SELF tinyint Indicates whether a reminder is from a manager (0) or is a self-reminder (1).
WRMND_QUERY nvarchar(1000) Stores the SQL query statement which is used by this reminder.
WRMND_EMAIL_TITLE integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WRMND_EMAIL_TAIL1 integer Refers to a localized CONV_STRING in the MSP_WEB_CONVERSIONS table.
WRMND_TYPE_DESC nvarchar(100) The description for the reminder.
Top

MSP_WEB_REMINDERS

This table contains all the reminders that users create while using Project Web Access. WFREQ is a variable with seven possible dependencies based on the initial setting of WFREQ.

Column Name Data Type Description
PK WRMND_OWNER_ID integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
PK WRMND_TYPE_ID integer Refers to a valid WRMND_TYPE_ID in the MSP_WEB_REMINDER_TYPES table.
WRMND_IS_ENABLED tinyint Indicates whether the reminder is enabled.
WRMND_SEND_TO smallint Indicates who the reminder is sent to:
0 Send to self
1 Send to resource
2 Send to both
WRMND_PARAMETERS nvarchar(20) The parameters for the reminder, as described in the user interface; this field contains a numerical representation of the user interface, for example 1,2 is the same as one week.
WRMND_CRITERIA nvarchar(510) This field contains SQL used to query the database based on the information set in WRMND_PARAMETERS; you should not modify the values in this field.
WRMND_START_DATE datetime The date that a reminder is set to begin.
WFREQ integer Indicates how frequently the reminder to be sent:
0 Weekly (default)
1 Monthly
2 Yearly
WFREQPAR1 integer Variable, depending on the value of WFREQ:
0 1 = Every week
2 = Every other week
3 = Every third week
4 = Every fourth week
5 = Every fifth week
6 = Every sixth week
7 = Every seventh week
8 = Every eighth week
9 = Every ninth week
10 = Every tenth week
11 = Every eleventh week
12 = Every twelfth week
1 0 = First option of yearly
1 = Second option of yearly
2 0 = First option of yearly
1 = Second option of yearly
WFREQPAR2 integer Variable, depending on the value of WFREQ:
0 Each bit represents a day of the week selected with the lowest bit being Sunday (that is, 9 means Sunday and Wednesday are selected)
1 Day of the month; used by first option:

1 = First day of the month
2 = Second day of the month
3 = Third day of the month and so on up until 28, 29, 30 or 31 (depending on the last day of the month).
2 1 = First, used by first option
2 = Second, used by first option
3 = Third, used by first option
4 = Fourth, used by first option
5 = Last, used by second option
WFREQPAR3 integer Variable, depending on the value of WFREQ:
0 Not used
1 Every x months; used by second option:

1 = Every month
2 = Every two months
3 = Every three months
4 = Every four months
5 = Every five months
6 = Every six months
7 = Every seven months
8 = Every eight months
9 = Every nine months
10 = Every ten months
11 = Every eleven months
12 = Every twelve months
2 Day of the week; used by second option:

1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
WFREQPAR4 integer Variable, depending on the value of WFREQ:
0 Not used
1 1 = First, used by first option
2 = Second, used by first option
3 = Third, used by first option
4 = Fourth, used by first option
5 = Last, used by second option
2 Month of year; used by second option:

1 = January
2 = February
3 = March
4 = April
5 = May
6 = June
7 = July
8 = August
9 = September
10 = October
11 = November
12 = December
WFREQPAR5 integer Variable, depending on the value of WFREQ:
0 Not used
1 Day of the week; used by second option:

1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
2 Not used
WFREQPAR6 integer Variable, depending on the value of WFREQ:
0 Not used
1 Every x months; used by second option:

1 = Every month
2 = Every two months
3 = Every three months
4 = Every four months
5 = Every five months
6 = Every six months
7 = Every seven months
8 = Every eight months
9 = Every nine months
10 = Every ten months
11 = Every eleven months
12 = Every twelve months
2 Not used
WFREQ_DATE datetime Variable frequency date parameter, depending on the value of WFREQ:
0 Not used
1 Not used
2 Date in the first option of yearly; used by first option
WRMND_NEXT_UPDATE datetime The date and time that the next notification is to be sent. This is calculated from the WFREQn fields described above and is used by the Notification Processing Engine (NPE) to determine whether the reminder should be processed.

This value is calculated from the frequency information shown above. It is used by NPE to check whether this reminder should be processed today. There are two occasions when it will be modified: (1) When a user saves changes to the reminders from the user interface and (2) after NPE processes this reminder, NPE will update this field for the next running time.

Top

MSP_WEB_REMINDERS_TEMP

This table is used as temporary data storage to hold and consolidate e-mail text while the Notification Processing Engine (NPE) works through all of the reminders. This process creates a record for each receiver, then attaches e-mail messages to generate a single, unified e-mail message.

Column Name Data Type Description
PK WRMND_ID_RECEIVER integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
PK WRMND_TABLE_ID integer Refers to a valid WTABLE_ID in the MSP_WEB_VIEW_TABLES table; only the following WTABLE_IDs are used for this table:
2 Assignments
4 Status reports
WRMND_MSG_SENT tinyint Indicates whether the message has been sent.
WRMND_MESSAGE ntext The text of the reminder message.
Top

MSP_WEB_RESERVED_DATA

This table is reserved for internal use; do not modify the values in this table.

Column Name Data Type Description
PK RESERVED_IDFAKE integer The unique ID for the row in the MSP_WEB_RESERVED_DATA table.
PK RESERVED_DATA1 integer This field is reserved for internal use; do not modify the values in this field
RESERVED_DATA2 integer This field is reserved for internal use; do not modify the values in this field
RESERVED_DATA3 integer This field is reserved for internal use; do not modify the values in this field
RESERVED_DATA4 integer This field is reserved for internal use; do not modify the values in this field
Top

MSP_WEB_RESOURCE_SETTINGS

This table stores the properties for a resource for a particular page in Project Web Access.

Column Name Data Type Description
PK WSET_ID integer The unique ID for the resource setting
WSEC_PAGE_ID integer Refers to a valid ID in the MSP_SEC_SECURITY_PAGES table; -1 for generic or global settings
WRES_GUID uniqueidentifier Refers to a valid WRES_GUID in the MSP_WEB_RESOURCES table
WSET_VALUE ntext Contains an XML blob that contains the resource settings and properties for a particular resource and page in Project Web Access
Top

MSP_WEB_RESOURCES

This table stores a record for every unique resource, including material resources, generic resources, local resources subject to being assigned to a task, and project managers assigning a resource to a task.

Column Name Data Type Description
PK WRES_ID integer The unique ID for the resource.
WRES_GUID uniqueidentifier The globally unique ID for the resource; automatically created by SQL Server 2000 when a user is created.
RES_NAME nvarchar(255) The friendly name of the resource; this also is the Project Web Access user name if WRES_USE_NT_LOGON is set to 0.
RES_EUID integer The unique enterprise ID for the resource; this maps the resource to the enterprise resource global.
WRES_USE_NT_LOGON tinyint Indicates whether a resource uses a Project Web Access user name and password (0) or a Windows NT user account name (1).
WRES_NT_ACCOUNT nvarchar(255) The Windows NT user account name; this field is not used unless WRES_USE_NT_LOGON is set to 1.
WRES_EMAIL nvarchar(255) Stores the e-mail address for the resource.
WRES_EMAIL_LANGUAGE integer Indicates which installed language is the default language for e-mail; see MSP_WEB_INSTALLED_LANGUAGES for all available languages
WRES_LAST_UPDATE_TIME datetime Reserved for future use.
WRES_LAST_CHECKED_TIME datetime Reserved for future use.
WRES_IS_OFFLINE tinyint Indicates whether a resource is working offline.
WRES_LAST_CONNECT datetime Stores the last time the user logged on.
WRES_IS_MANAGER tinyint Indicates whether a resource has manager permissions. This field is obsolete now with the new security model.
WRES_IS_ADMIN tinyint Indicates whether a resource has administrator permissions. This field is obsolete now with the new security model.
WRES_IS_ENABLED tinyint Indicates whether the resource is an Active (Enabled) or Inactive user.
WRES_IS_PC2000 tinyint Indicates whether the resource has been migrated from a Microsoft Project Central 2000 installation or whether the resource was newly created.
WRES_PASSWORD nvarchar(255) The password for the user if WRES_USE_NT_LOGON is set to 0; not used for users of Microsoft Project 2000.
WRES_DEL_TASKUPDATE_MSG tinyint Obsolete field.
WRES_DEL_DELEG_MSG tinyint Obsolete field.
WRES_DEL_NEWTASK_MSG tinyint Obsolete field.
WRES_DEL_REASSN_MSG tinyint Obsolete field.
WRES_INCL_TEAMLEAD_RESOURCES tinyint Reserved for future use.
WRES_INCL_TEAMASSIGN_RESOURCES tinyint Obsolete field.
WRES_CAN_LOGIN tinyint Indicates whether the resource has permission to log on to Project Web Access; material resources cannot log on.
WRES_COUNT_LICENSE tinyint Indicates whether the resource counts as a licensed user of Project Web Access; material resources do not count as licensed users.

NoteB B For details about licensing for Project Server and Project Web Access, see the Microsoft end-user license agreements for the products.

RES_PHONETICS nvarchar(255) Contains phonetic information in either Hiragana or Katakana for resource names; used only in the Japanese version of Project.
RESERVED_DATA1 integer Reserved for internal use. Do not change this field.
RESERVED_DATA2 integer Reserved for internal use. Do not change this field.
RESERVED_DATA3 integer Reserved for internal use. Do not change this field.
RESERVED_DATA4 integer Reserved for internal use. Do not change this field.
WRES_AD_GUID uniqueidentifier The AD GUID used to map a Project Server resource from Active Directory.
WRES_RBS_GUID integer The RBS GUID used to map a Project Server enterprise resource to their RBS values.
WRES_WSS_VALIDATOR_GUID nvarchar(100) Stores a GUID that is used to verify a specific resource when they are accessing data stored in the Project Server database.
Top

MSP_WEB_SECURITY_CATEGORIES

This table stores the name and description of each security category in Project Server, including the following default categories: My Organization, My Projects, and My Tasks. This information can be managed from the Manage Security link in the Admin center of Project Web Access.

See MSP_WEB_SECURITY_CATEGORY_RULES for more information about specific category types and rules associated with the category.

Column Name Data Type Description
PK WSEC_CAT_ID integer The unique ID for the security category.
WSEC_CAT_NAME nvarchar(255) The name of the security category:
1 My Organization
2 My Projects
3 My Tasks
WSEC_CAT_DESC nvarchar(255) The description of the security category, for example: Project Web Access pre-defined category.
Top

MSP_WEB_SECURITY_CATEGORY_OBJECTS

This table links categories and objects, including the type of object.

Column Name Data Type Description
PK WSEC_CAT_ID integer Refers to a valid project in the MSP_WEB_SECURITY_CATEGORIES table.
WSEC_OBJ_TYPE tinyint Indicates the type of object:
1 Project
2 Resource
3 View
4 Model
WSEC_OBJ_ID integer Refers to a valid ID in the MSP_WEB_OBJECT_RULE_TYPES table.
Top

MSP_WEB_SECURITY_CATEGORY_RULES

This table provides the information that determines whether a category or permission is allowed or denied.

Column Name Data Type Description
PK WSEC_CAT_ID integer Refers to a valid project in the MSP_WEB_SECURITY_CATEGORIES table.
WSEC_OBJ_TYPE tinyint Indicates the type of object:
1 Project
2 Resource
3 View
4 Model
WSEC_OBJ_RULE_TYPE tinyint Depending on the selection in WSEC_OBJ_TYPE, the rule that is associated with the object:
0 All current and future projects
1 All selected projects
2 All current and future projects that I manage
3 All current and future projects for which I am a resource
Top

MSP_WEB_SECURITY_FEATURES_ACTIONS

This table stores information related to security objects in Project Server and Project Web Access.

NoteB B If you customize any of the default pages in Project Web Access, you may also want to modify the WSEC_FEA_ACT_NAME in the database for the corresponding center or activity.

Column Name Data Type Description
PK WSEC_FEA_ACT_ID integer The ID for the security feature. See WSEC_FEA_ACT_NAME, left column for a list of all available security feature IDs.
WSEC_FEA_ACT_NAME_ID integer The name of a security feature. Access to centers and activities is based on allowing or denying access to the security features in Project Server and Project Web Access for each user, category, group, or organization. The names of available security features are in the right column:
100 General
101 View Home
102 Log On
103 Change Password
104 Set Personal Notifications
105 Set Resource Notifications
106 Go Offline
107 Integration with External Timesheet System
150 User defined 1
151 User defined 2
152 User defined 3
200 Tasks
201 View Timesheet
202 New Project Task
203 Delegate Task
204 Hide Task From Timesheet
205 Transfer Calendar Entries
207 Create Administrative Projects
206 Change Work Days
210 New Task Assignment
211 Timesheet Approval
212 Approve Timesheets for Resources
300 To-Do List
301 Create and Manage To-Do List
302 Publish To-Do List to All Users
303 Assign To-Do List Tasks
400 Transactions
401 Manage Task Changes
402 Manage Calendar Changes
403 Manage Rules
500 Views
501 View Project View
502 View Assignments View
503 View Project Center
504 View Resource Center
505 View Portfolio Analyzer
506 View Models
507 View Resource Allocation
508 See Projects in Project Center
509 See Projects in Project Views
510 See Resource Assignments in Assignment Views
512 View Risks, Issues, and Documents
513 Adjust Actuals
514 View Adjust Actuals
600 Status Reports
601 View Status Report List
602 Submit Status Report
604 Manage Status Report Request
700 Admin
710 Manage users and groups
720 Manage security
730 Manage views
740 Manage organization
750 Customize Project Web Access
760 Manage enterprise features
770 About Microsoft Office Project Server 2003
780 Clean up Project Server database
790 Manage Windows SharePoint Services
800 Workgroup
801 Publish / update / status
900 Account Creation
901 Create Accounts from Microsoft Office Project
902 Create Manager Accounts from Project
903 Create Accounts when Delegating Tasks
904 Create Accounts when Requesting Status Reports
1000 Enterprise Portfolio Management
1004 New Project
1005 New Resource
1006 Read Enterprise Global
1007 Save Enterprise Global
1008 Backup Global
1010 Assign Resource to Project Team
1011 Save Project Template
1012 Save Project
1013 Open Project
1014 See Enterprise Resource Data
1015 Edit Enterprise Resource Data
1016 Open Project Template
1017 Check In My Projects
1018 Save Baseline
1100 Collaboration
1101 View Documents
1102 View Issues
1103 View Risks
WSEC_FEA_ACT_PARENT integer Refers to a valid ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table; all activities must have a parent. If the security feature is a parent, the value in this field is 0. Available parent IDs:
100 General
200 Tasks
300 To-Do List
400 Transactions
500 Views
600 Status Reports
700 Admin
800 Workgroup
900 Account Creation
1000 Enterprise Portfolio Management
1100 Windows SharePoint Services Collaboration
WSEC_IS_ACTION tinyint Indicates whether a security feature is a top level (0) or side pane (1) feature. All side pane security features must belong to a parent.
WSEC_ON_OBJECT tinyint Indicates whether a permission is a global (0) or category (1) level permission.
WSEC_OBJ_TYPE_ID integer The type of object:
1 Project
2 Resource
3 View
4 Model
Top

MSP_WEB_SECURITY_GROUP_MEMBERS

This table stores information that links Project Web Access users with the groups they belong to. For each resource, Project Server creates a group that contains that resource.

Column Name Data Type Description
PK WSEC_GRP_GUID uniqueidentifier Refers to a valid WSEC_GRP_GUID in the MSP_WEB_SECURITY_GROUPS table.
PK WRES_GUID uniqueidentifier Refers to a valid WRES_GUID in the MSP_WEB_RESOURCES table.
Top

MSP_WEB_SECURITY_GROUPS

This table stores a name and description for each group in Project Server, including the following default groups: Administrators, Executives, Portfolio Managers, Project Managers, Resource Managers, Team Leads, and Team Members.

Column Name Data Type Description
PK WSEC_GRP_ID integer The unique ID for the group.
WSEC_GRP_GUID uniqueidentifier The globally unique ID for the group; automatically assigned by Project Server.
WSEC_GRP_NAME nvarchar(100) The name of the group.
WSEC_GRP_DESC nvarchar(255) The description of the group.
WSEC_GRP_DASHBOARD_URL nvarchar(255) The Digital Dashboard URL for the group.
WSEC_GRP_AD_GROUP nvarchar(64) The name of the Active Directory group associated with the Project Server security group.
WSEC_GRP_AD_LOG smallint The status of Active Directory synchronization with Project Server:
0 Never
1 Success
2 Failure
Top

MSP_WEB_SECURITY_MENUS

This table stores information found in the top-level menus in Project Web Access, including the name of the menu, its parent, its description, and whether the menu is a custom menu.

Column Name Data Type Description
PK WSEC_MENU_ID integer The unique ID for the security menu.
WSEC_MENU_NAME_ID integer Refers to the CONV_VALUE field in the MSP_WEB_CONVERSIONS table and provides the localized string for the menu.
WSEC_MENU_CUSTOM_NAME nvarchar(100) The customized name of the top link or sub link menu item.
WSEC_MENU_PARENT_ID integer Refers to a valid ID in the MSP_WEB_SECURITY_MENUS table:
-1 Indicates this menu item is a parent menu item
any Refers to the parent menu; this number must be a valid ID in this table
WSEC_MENU_SEQ smallint The order in which the fields will appear in Project Web Access.
WSEC_MENU_DESC_ID integer Refers to CONV_VALUE in the MSP_WEB_CONVERSIONS table and provides the localized string for the menu.
WSEC_MENU_CUSTOM_DESC nvarchar(100) The description of the custom menu item.
WSEC_MENU_PAGE_ID integer Refers to a valid WSEC_PAGE_ID in the MSP_WEB_SECURITY_PAGES table.
WSEC_MENU_IS_CUSTOM tinyint Indicates whether the menu item is a custom menu item.
WSEC_MENU_IS_TOP_LEVEL tinyint Indicates whether the menu item appears across the top of the Project Web Access browser window.
WSEC_MENU_LINKGROUP_NAME_ID integer Refers to a localized string in the MSP_WEB_CONVERSIONS table; displayed as the saved links' type in the actions pane.
Top

MSP_WEB_SECURITY_OBJECT_RULES

This table stores information related to security object rules.

Column Name Data Type Description
PK WSEC_OBJ_TYPE tinyint The type of object:
1 Project
2 Resource
3 View
4 Model
PK WSEC_OBJ_RULE_TYPE tinyint Depending on the selection in WSEC_OBJ_TYPE, the rule that is associated with the object:
0 All current and future projects
1 All selected projects
2 All current and future projects that I manage
3 All current and future projects for which I am a resource
WSEC_OBJ_RULE_DESC nvarchar(255) The description of the object rule.
Top

MSP_WEB_SECURITY_OBJECT_TYPES

This table is used to associate the object type name with the objects.

Column Name Data Type Description
PK WSEC_OBJ_TYPE_ID integer The unique ID for the object.
WSEC_OBJ_TYPE_NAME nvarchar(100) The type of object:
1 Project
2 Resource
3 View
4 Model
Top

MSP_WEB_SECURITY_ORG_PERMISSIONS

This table specifies which Project Web Access features are available to an organization.

Column Name Data Type Description
PK WSEC_FEA_ACT_ID integer Refers to a valid ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table.
WSEC_ALLOW tinyint Indicates that the security principle or security object has been granted permission to perform the selected activity.
WSEC_DENY tinyint Indicates that the security principle or security object has been denied permission to perform the selected activity; if a user is denied anywhere in Project Web Access, a user will be denied everywhere.
WSEC_ACCESS tinyint Reserved for future use in Project Web Access; you should not modify the values in this field.
WSEC_PAID tinyint Reserved for future use in Project Web Access; you should not modify the values in this field.
Top

MSP_WEB_SECURITY_PAGES

This table links security features with the ASP pages in Project Web Access.

Column Name Data Type Description
PK WSEC_PAGE_ID integer The unique ID for the page.
WSEC_PAGE_MENU_ID integer Refers to a valid WSEC_MENU_ID in the MSP_WEB_SECURITY_MENUS table.
WSEC_PAGE_URL nvarchar(255) The URL for the page.
WSEC_PAGE_CUSTOM_URL nvarchar(255) The custom URL for the page.
WSEC_PAGE_HELP_URL nvarchar(255) The URL for the help page associated with a page in Project Web Access.
WSEC_PAGE_ACT_ID integer Refers to a valid WSEC_FEA_ACT_ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table.
WSEC_PAGE_MASTER_PAGE_ID integer Refers to a valid WSEC_PAGE_ID in the MSP_WEB_SECURITY_PAGES table.
WSEC_PAGE_SESSION_SETTINGS ntext Contains the initial settings for this page; this information is persisted only within the session.
WSEC_PAGE_DATABASE_SETTINGS ntext Contains the initial settings for this page; this information is persisted across sessions and all changes are stored in the MSP_WEB_RESOURCE_SETTINGS table.
WSEC_PAGE_CAN_OFFLINE tinyint Indicates whether the page can be viewed offline.
Top

MSP_WEB_SECURITY_SP_CAT_PERMISSIONS

This table defines which users and groups have permissions for each category.

Column Name Data Type Description
PK WSEC_REL_ID integer Refers to a valid WSEC_REL_ID in the MSP_WEB_SECURITY_SP_CAT_RELATIONS table.
PK WSEC_FEA_ACT_ID integer Refers to a valid WSEC_FEA_ACT_ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table.
WSEC_ALLOW tinyint Indicates that a user has been granted permission to perform the selected activity.
WSEC_DENY tinyint Indicates that a user has been denied permission to perform the selected activity; if a user is denied anywhere in Project Web Access, a user will be denied everywhere.
WSEC_ACCESS tinyint This field is used internally by Project Server; you should not modify the contents of this field.
Top

MSP_WEB_SECURITY_SP_CAT_RELATIONS

This table links the MSP_WEB_SECURITY_GROUPS and MSP_WEB_SECURITY_SP_CAT_PERMISSIONS tables.

Column Name Data Type Description
PK WSEC_REL_ID integer The unique ID for the category relation.
WSEC_SP_GUID uniqueidentifier Refers to a valid WSEC_GRP_GUID in the MSP_WEB_SECURITY_GROUPS table.
WSEC_CAT_ID integer Refers to a valid WSEC_CAT_ID in the MSP_WEB_SECURITY_CATEGORIES table.
Top

MSP_WEB_SECURITY_TEMPLATE_PERMISSIONS

This table stores a list of permissions that are either allowed or denied for each security template.

Column Name Data Type Description
PK WSEC_TMPL_ID integer Refers to a valid WSEC_TMPL_ID in the MSP_WEB_SECURITY_TEMPLATES table.
PK WSEC_ACT_ID integer Refers to a valid WSEC_FEA_ACT_ID in the MSP_WEB_SECURITY_FEATURES_ACTIONS table.
WSEC_ALLOW tinyint Indicates that a user has been granted permission to perform the selected activity.
WSEC_DENY tinyint Indicates that a user has been denied permission to perform the selected activity; if a user is denied anywhere in Project Web Access, a user will be denied everywhere.
WSEC_ACCESS tinyint This field is used internally by Project Server; you should not modify the contents of this field.
Top

MSP_WEB_SECURITY_TEMPLATES

This table stores the name and description of each security template in Project Server. This information is managed on the Admin, Manage Security page in Project Web Access.

Project Server includes the following default security templates: Administrator, Executive, Portfolio Manager, Project Manager, Resource Manager, Team Lead, and Team Member. See MSP_WEB_SECURITY_TEMPLATE_PERMISSIONS for more information about specific permissions allowed or denied for each security table.

Column Name Data Type Description
PK WSEC_TMPL_ID integer The unique ID for the security template.
WSEC_TMPL_NAME nvarchar(100) The name of the security template, for example: Resources.
WSEC_TMPL_DESC nvarchar(255) Contains a description of the security template, for example: Permissions template for Resources.
Top

MSP_WEB_SECURITY_USERDEFINED

This table stores information about the three custom, user-defined permissions in Project Web Access. Information in this table should only be accessed using the Project Data Service to run a query against the table, for example:

SELECT * FROM MSP_WEB_SECURITY_USERDEFINED WHERE WSEC_PERMISSION_NUMBER = n
Column Name Data Type Description
WSEC_PERMISSION_NUMBER integer The user-defined permission:
1 User defined 1
2 User defined 2
3 User defined 3
4 ... User defined 4 ... etc.
WSEC_ITEM_TYPE integer The type of item that is being disabled with the user-defined permission:
0 X-Command
1 Grid
2 Field
3 Dialog
4 Feature
WSEC_ITEM_ID integer The actual item being disabled, an X-Command ID or Field PID, for example.
Top

MSP_WEB_STATUS_DISTRIBUTION

This table links resources and status reports, including report distribution information and which status report was sent to whom.

Column Name Data Type Description
PK WRES_ID_DISTR_RECIP integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
PK WRESP_ID integer 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 a variable with seven possible dependencies based on the initial setting of WFREQ.

Column Name Data Type Description
PK WSR_ID integer Refers to a valid WSR_ID in the MSP_WEB_STATUS_REPORTS table.
PK WREPORT_START_DATE datetime The date that status reporting is to begin.
WFREQ integer Indicates how often the status report is to be submitted by resources:
0 Weekly (default)
1 Monthly
2 Yearly
WFREQPAR1 integer Variable, depending on the value of WFREQ:
0 1 = Every week
2 = Every other week
3 = Every third week
4 = Every fourth week
5 = Every fifth week
6 = Every sixth week
7 = Every seventh week
8 = Every eighth week
9 = Every ninth week
10 = Every tenth week
11 = Every eleventh week
12 = Every twelfth week
1 0 = First option of yearly
1 = Second option of yearly
2 0 = First option of yearly
1 = Second option of yearly
WFREQPAR2 integer Variable, depending on the value of WFREQ:
0 Each bit represents a day of the week selected with the lowest bit being Sunday (that is, 9 means Sunday and Wednesday are selected)
1 Day of the month; used by first option:

1 = First day of the month
2 = Second day of the month
3 = Third day of the month and so on up until 28, 29, 30 or 31 (depending on the last day of the month).
2 1 = First, used by first option
2 = Second, used by first option
3 = Third, used by first option
4 = Fourth, used by first option
5 = Last, used by second option
WFREQPAR3 integer Variable, depending on the value of WFREQ:
0 Not used
1 Every x months; used by second option:

1 = Every month
2 = Every two months
3 = Every three months
4 = Every four months
5 = Every five months
6 = Every six months
7 = Every seven months
8 = Every eight months
9 = Every nine months
10 = Every ten months
11 = Every eleven months
12 = Every twelve months
2 Day of the week; used by second option:

1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
WFREQPAR4 integer Variable, depending on the value of WFREQ:
0 Not used
1 1 = First, used by first option
2 = Second, used by first option
3 = Third, used by first option
4 = Fourth, used by first option
5 = Last, used by second option
2 Month of year; used by second option:

1 = January
2 = February
3 = March
4 = April
5 = May
6 = June
7 = July
8 = August
9 = September
10 = October
11 = November
12 = December
WFREQPAR5 integer Variable, depending on the value of WFREQ:
0 Not used
1 Day of the week; used by second option:

1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
2 Not used
WFREQPAR6 integer Variable, depending on the value of WFREQ:
0 Not used
1 Every x months; used by second option:

1 = Every month
2 = Every two months
3 = Every three months
4 = Every four months
5 = Every five months
6 = Every six months
7 = Every seven months
8 = Every eight months
9 = Every nine months
10 = Every ten months
11 = Every eleven months
12 = Every twelve months
2 Not used
WFREQPAR_DATE datetime Variable frequency date parameter, depending on the value of WFREQ:
0 Not used
1 Not used
2 Date in the first option of yearly; used by first option
Top

MSP_WEB_STATUS_REPORTS

This table stores general information about status reports.

Column Name Data Type Description
PK WSR_ID integer The unique ID for the status report.
WRES_ID_MGR integer The resource ID of the manager who created the status report; refers to a valid ID in the MSP_WEB_RESOURCES table.
WREPORT_NAME nvarchar(255) The name of the status report.
WREPORT_UNREQUESTED tinyint Indicates whether the status report is an unrequested status report.
WREPORT_IS_ENABLED tinyint Indicates whether the status report is enabled (0); the status report becomes disabled (1) if a manager deletes the report.
WREPORT_FORMAT ntext The status report contained within XML.
Top

MSP_WEB_STATUS_REQUESTS

This table stores detailed information about status requests and links each request with resources.

Column Name Data Type Description
PK WRES_ID_RECEIVER integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
PK WSR_ID integer The unique ID for a status request.
WDUE_ON datetime The next date the report is due for this request.
WREQ_IS_AUTOMERGE tinyint Indicates whether the status request is an auto-merge response.
WREQ_IS_NEW_REQUEST tinyint Indicates whether the status request is a new status request.
WREQ_IS_SENT tinyint Indicates whether the status request has been sent.
WREQ_IS_ENABLED tinyint Indicates whether a status request is enabled; a status request becomes unenabled if a manager deletes a resource from that status request.
Top

MSP_WEB_STATUS_RESPONSES

This table stores the responses for status reports.

Column Name Data Type Description
PK WRESP_ID integer The unique ID for a status response.
WRES_ID integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WSR_ID integer Refers to a valid WSR_ID in the MSP_WEB_STATUS_REPORTS table.
WSRESP_PERIOD_START datetime The start date for the date range covering the status report.
WSRESP_PERIOD_FINISH datetime The end date for the date range covering the status report.
WSUBMIT_STATUS integer Indicates whether the status report has been submitted or saved:
0 Not submitted
1 Saved
2 Submitted
WSUBMIT_DATE datetime The date a status report was submitted.
WUPDATE_STATUS integer Indicates whether the status report has been updated or if it is an original:
0 No updates
1 Original
2 Update
WNUM_SECTIONS integer The number of sections that can't be removed.
WRESP_IS_MATCHING tinyint Indicates whether the time period for a status response matches the time period for the status request.
WRESP_IS_NEW_RESPONSE tinyint Indicates whether a manager has seen the status response.
WRESP_IS_MERGED tinyint Indicates whether a status report has been merged into a manager's compiled report.
WRESP_TEXT ntext The text of the status response message.
Top

MSP_WEB_STRING_TYPES

This table maps certain strings used in Project Server to their language locale IDs. This is used only for Gantt bar styles and field names in Project views.

Column Name Data Type Description
PK STRING_TYPE_ID integer The unique ID for the string type.
PK STRING_LANG_ID integer The language locale ID for the string, for example: 1033 is the language ID for English, the default language for the database.
STRING_TYPE nvarchar(200) The localized name of the string type, for example: Gantt Bar Styles for the English version.
Top

MSP_WEB_STS_SERVERS

This table contains all the information related to servers running Windows SharePoint Services. This information is automatically populated to this table (along with WADMIN_PUBDOCS_STS_SERVER_ID and WADMIN_CURRENT_STS_SERVER_ID in the MSP_WEB_ADMIN table) during the installation of Project Server and Windows SharePoint Services. This information is entered and maintained on the Admin page in Project Web Access.

NoteB B When migrating from Microsoft Project Server 2002 to Project Server 2003, the 2002 version of this table is renamed to MSP_WEB_STS_SERVERS_P2002 and a new MSP_WEB_STS_SERVERS table is created with the updated information required for Project Server 2003. Then 2002 information is added to this table.

Column Name Data Type Description
PK WSTS_SERVER_ID integer The unique ID for the server running Windows SharePoint Services.
WSTS_SERVER_NAME nvarchar(255) The name of the server running Windows SharePoint Services.
WSTS_SERVER_WEB_PORT integer The web port number required to access the server running Windows SharePoint Services; default is 80.
WSTS_SERVER_ADMIN_PORT integer The admin port number required to access the administration pages on the server running Windows SharePoint Services; default is None.
WSTS_WEB_PORT_IS_SSL tinyint Indicates whether the web port for the server running Windows SharePoint Services is an SSL port. If this is true, then all connections to WSTS_SERVER_WEB_PORT will be HTTPS.
WSTS_ADMIN_PORT_IS_SSL tinyint Indicates whether the admin port for the server running Windows SharePoint Services is an SSL port. If this is true, then all connections to WSTS_SERVER_ADMIN_PORT will be HTTPS.
WSTS_MANAGED_PATH nvarchar(60) The managed path for the server running Windows SharePoint Services; default value is Projects. This is used to logically group URLs related to Windows SharePoint Services.
WSTS_EXTRANET_SERVER_NAME nvarchar(255) The name of the Windows SharePoint Services extranet server.
WSTS_ADMIN_SERVER_NAME integer The name of the Windows SharePoint Services administrative server.
WSTS_NETBIOS_SERVER_NAME nvarchar(255) Stores the NETBIOS (friendly) name of a server running Window SharePoint Services when MSP_WEB_STS_SERVERS.WSTS_SERVER_NAME is saved in an IP/FQDN/host header format.
Top

MSP_WEB_TIME_PERIODS

This table stores data for manually created reporting time periods.

Column Name Data Type Description
WPRD_ID integer The unique ID for the reporting time period.
WPRD_START_DATE datetime The start date for the reporting time period.
WPRD_FINISH_DATE datetime The finish date for the reporting time period.
WPRD_STATE integer The state of the reporting time period:
0 Open
1 Closed
RESERVED_DATA1 float Reserved for internal use. Do not change this field.
Top

MSP_WEB_TRANSACTIONS

This table stores resource task updates, including details such as whether they have been reviewed by a project manager, updated to Project Server, or information about updated timesheet entries.

Column Name Data Type Description
PK WTRANS_ID integer The unique ID for the transaction.
WASSN_ID integer Refers to a valid WASSN_ID in the MSP_WEB_ASSIGNMENTS table.
WTRANS_DATE datetime The date the resource task update was sent.
WTRANS_PROJ_UPDATE_DATE datetime The date the resource task update was updated to Project Server by a project manager.
WTRANS_STATE integer Indicates the state of the transaction:
0 Pending
1 Processed, but not yet updated
2 Updated, but not yet sent to history
3 Sent to history
WTRANS_TYPE integer Indicates the type of transaction:
0 Task update
1 Declined tasks
2 New tasks
3 Task delegation
WTRANS_ACTION integer Indicates the action taken for the transaction:
0 No action taken
1 Accept
2 Reject
WRES_ID_TRANS_SENDER integer Refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
WDELEG_ID integer Refers to a valid WDELEG_ID in the MSP_WEB_DELEGATIONS table.
WTRANS_DESC nvarchar(255) Depending on the type of transaction selected in WTRANS_TYPE, the user will see the following messages:
0 Task update by [resource]
1 New task created by [resource]
2 Task declined by [resource]
3 Task delegated from [delegator] to [delegatee]
WTRANS_ADJUST tinyint Indicates whether the transaction contains actuals that have been adjusted by a manager; if 0, then this is a normal, non-adjusted transaction.
Top

MSP_VERSIONS

A project may have multiple versions in Project. The lowest level of a project is each version of each project, for example: 90-001 Windows XP Upgrade.Published is the published version of the Project 90-001 Windows XP Upgrade. One record for each available version is stored in this table. All enterprise-level projects will have an associated version.

NoteB B This table is not accessed directly by Project Professional.

Column Name Data Type Description
VERS_ID integer The position identifier of the version in the list of versions.
VERS_VERSION varchar(50) The name of the version, for example: Published.
VERS_DEFAULT Tinyint Indicates whether this version is the default version.
VERS_TYPE integer The version type:
0 Editable version
10 Archive version; disallows all editing, project is read-only, resource records are not refreshed
1000 Inactive version
VERS_WGANTT_STYLE_ID integer The ID for the Gantt bar style:
0 Normal task
1 Critical task
2 External task
3 Delegated task
4 Milestone
5 Summary task
6 Project summary (default)
7 Group by summary
8 Progress
9 Summary progress
10 Baseline task
11 Baseline summary
12 Baseline milestone
13 Pre-leveled task
14 Pre-leveled summary
15 Pre-leveled 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
Top

MSP_WEB_VIEW_DSNS

This table stores data source names (DSNs) used by projects in Project Server. Any DSN listed in this table must also exist in Project Server. You can create DSNs in Project Server using the ODBC Data Source Administrator in Control Panel. For each DSN, you must specify a user ID and password for Project Server to use when accessing projects stored in the database that each DSN points to. Specifying a user ID and password allows users to look at information from Project Server views without necessarily having direct access to the database itself.

Column Name Data Type Description
PK WDSN_ID integer The unique ID for the DSN.
WDSN_NAME nvarchar(255) The name of the DSN.
WDSN_DESCRIPTION nvarchar(255) The description of the DSN.
WDSN_LOGIN_ID nvarchar(255) The user ID Project Server uses to access projects stored in the database that the DSN points to.
WDSN_PASSWORD nvarchar(255) The password Project Server uses to access projects stored in the database that the DSN points to.
Top

MSP_WEB_VIEW_FAVORITES

This table stores favorite views.

Column Name Data Type Description
PK WVIEW_FAV_ID integer The unique ID for the view favorite.
WRES_ID integer Refers to a valid ID in the MSP_WEB_RESOURCES table.
WVIEW_TYPE integer Indicates the type of view:
0 Project view
1 Portfolio view
2 Assignment view
3 Resource view
4 Portfolio Analyzer view
WPROJ_ID integer Refers to a valid ID in the MSP_WEB_PROJECTS table.
WVIEW_OWC_PIVOT_XML ntext Contains an XML blob that stores the default settings for a PivotTable or chart in Project Web Access; used only for Portfolio Analyzer views.
WVIEW_OWC_CHART_XML ntext Contains the settings of the chart; used only for Portfolio Analyzer views.
WVIEW_FAV_NAME nvarchar(100) The name of the favorite view.
WVIEW_FAV_URL ntext The URL parameter for the view.
WVIEW_FAV_COLUMN_ORDER ntext The grid column order for that particular view; only used if the view is a grid.
WVIEW_FAV_AUTOFILTER ntext The autofilter clause; used only if the autofilter is applied to the view.
WSEC_MENU_ID integer Refers to a valid WSEC_MENU_ID in the MSP_WEB_SECURITY_MENUS table.
WVIEW_DEFAULT_SETTINGS ntext Contains an XML blob that carries the default view settings for Show Field List and Show Toolbar in Project Web Access.
WVIEW_TIMESTAMP uniqueidentifier The timestamp from the MSP_WEB_VIEW_REPORTS table; if this is not the same value as WVIEW_TIMESTAMP in MSP_WEB_VIEW_REPORTS, this view is out of date.
Top

MSP_WEB_VIEW_FIELDS

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

Column Name Data Type Description
PK WFIELD_ID integer The unique ID for the field.
WFIELD_NAME_OLEDB nvarchar(255) The name of the field used in the Project OLE DB Provider.
WFIELD_NAME_SQL nvarchar(255) The name of the field in the Project Server database.
WFIELD_NAME_CONV_VALUE integer Refers to the CONV_VALUE field in the MSP_WEB_CONVERSIONS table, and provides the localized description of the field.
WFIELD_TEXTCONV_TYPE integer The type of field:
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 Cost rate (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 midnight)
24 Long
25 Link type (SS, FF, FS, or SF)
28 Elapsed duration (for example, 5ed)
29 Task type (for example, fixed units, fixed work, fixed duration)
30 Hyperlink (friendly name)
31 Hyperlink (target)
32 Hyperlink (location)
33 Hyperlink (HREF)
WTABLE_ID integer Indicates the type of view:
0 Project view
1 Tasks
2 Assignments
3 Resources
4 Portfolio Analyzer view
WFIELD_IN_PROJECT_VIEW tinyint Indicates whether the field is in a Project view.
WFIELD_IN_PORTFOLIO_VIEW tinyint Indicates whether the field is in a Portfolio view.
WFIELD_IN_WEBCLIENT_VIEW tinyint Indicates whether the field is in an Assignment view.
WFIELD_IS_CUSTOM_FIELD tinyint Indicates whether the field is a custom field in the Project Server database.
WFIELD_IS_GANTT_DEFAULT tinyint Indicates whether the field is required to draw a Gantt bar (such as Start, Finish, Baselines).
WFIELD_IS_ENTRES_FIELD tinyint Indicates whether the field is an enterprise resource field.
Top

MSP_WEB_VIEW_REPORTS

This table stores information about views, including the type of view and how that view will be seen by end users in Project Web Access.

Column Name Data Type Description
PK WVIEW_ID integer The unique ID of the view report.
WVIEW_NAME nvarchar(255) The name of the report.
WVIEW_DESCRIPTION nvarchar(255) The description of the report.
WVIEW_TYPE integer Indicates the type of view:
0 Project Center view
1 Portfolio view
2 Assignment Center view
3 Resource Center view
4 Portfolio Analyzer view
WVIEW_DISPLAY_TYPE integer Specifies the type of chart used to display the information in the report:
0 PivotTable only (default)
1 Chart only
2 Both PivotTable and Chart
WVIEW_WORK_TYPE integer Reserved for future use; not used for Portfolio Analyzer views.
WGANTT_SCHEME_ID integer Refers to a valid ID in the MSP_WEB_GANTT_SCHEMES table; not used for Portfolio Analyzer views.
WTABLE_ID integer Refers to a valid ID in the MSP_WEB_VIEW_TABLES table; not used for Portfolio Analyzer views.
WVIEW_FILTER_PARAM1 nvarchar(255) SQL clause for the first filter of the project view; not used for Portfolio Analyzer views.
WVIEW_FILTER_PARAM2 nvarchar(255) SQL clause for the second filter of the project view; not used for Portfolio Analyzer views.
WVIEW_FILTER_PARAM3 nvarchar(255) SQL clause for the third filter of the project view; not used for Portfolio Analyzer views.
WVIEW_REPORT_KIND integer Specifies the method used to display the report:
0 Normal (default)
1 Active Server Page
2 HTML
3 Data Access Page
WVIEW_PATH nvarchar(1024) URL defined in the Get Additional Views section on the Specify Views page; not used for Portfolio Analyzer views.
WVIEW_OWC_PIVOT_XML ntext Office Web Components (OWC); the XML blob that stores the settings of the Pivot control.
WVIEW_OWC_CHART_XML ntext Office Web Components (OWC); the XML blob that stores the settings of the Chart control.
WGROUP_SCHEME_ID integer Refers to a valid ID in the MSP_WEB_GROUP_SCHEMES table; not used for Portfolio Analyzer views.
WVIEW_DEFAULT_SETTINGS ntext Contains an XML blob that carries the default view settings for Show Field List and Show Toolbar in Project Web Access.
WVIEW_TIMESTAMP uniqueidentifier The timestamp of the view; stored as a GUID.
WVIEW_GROUPING_SORTING_PARAMS nvarchar(256) The default grouping and sorting information for a view. This information is saved as XML and includes information about three grouping fields, one sorting field, and one sorting direction.
WVIEW_FILTER_BY_RBS tinyint Indicates whether views are filtered by Resource Breakdown Structure (RBS); this field is used specifically for Resource Center views (WVIEW_TYPE is set to 3).
WVIEW_OUTLINE_LEVEL smallint The ouline level in the Project Web Access grid for a particular view.
WVIEW_SPLITTER_POS integer The position of the splitter in Project Web Access reports.
Top

MSP_WEB_VIEW_REPORTS_FIELDS

This table specifies the fields displayed for each view, links the fields with their associated view, and determines the order in which the fields appear.

Column Name Data Type Description
PK WVIEW_ID integer Refers to a valid WVIEW_ID in the MSP_WEB_VIEW_REPORTS table.
PK WFIELD_ID integer Refers to the CONV_VALUE field in the MSP_WEB_WORKGROUP_FIELDS_INFO table.
WVIEW_FIELD_ORDER integer The order in which the fields will appear; for each unique WVIEW_ID.
WVIEW_FIELD_WIDTH integer The width of the field in Project Web Access views; default of 100.
WVIEW_FIELD_AUTOSIZE tinyint Indicates whether the field's size is determined automatically.
Top

MSP_WEB_VIEW_TABLES

This table specifies which table to view. This table is currently not used in any specific query in Project Server.

Column Name Data Type Description
PK WTABLE_ID integer Indicates which table (1, 2, 3, or 4) to use.
WTABLE_NAME nvarchar(255) The name of the table selected in WTABLE_ID:
1 Tasks
2 Assignments
3 Resources
4 Status Report
Top

MSP_WEB_WORK

This table stores all of the hours worked by a resource on an assignment, including actual work, scheduled work, and overtime actual work.

Column Name Data Type Description
WRES_ID integer Refers to a valid ID in the MSP_WEB_RESOURCES table.
PK WASSN_ID integer Refers to a valid ID in the MSP_WEB_ASSIGNMENTS table.
PK WWORK_START datetime The start date for the work.
PK WWORK_FINISH datetime The finish date for the work.
PK WWORK_TYPE integer Indicates the type of work performed:
0 Scheduled work
1 Actual work
2 Overtime actual work
WWORK_VALUE decimal The number of hours worked, measured as minutes * 1000; for example: 8 hours worked is stored as 480000.
WWORK_UPDATE_STATUS integer Indicates whether the work entry has been edited by the resource.
0 Not edited by resource
1 Edited by resource but not updated to the project manager yet
RESERVED_DATA1 integer Reserved for use by Project Server; do not change the values in this field.
WWORK_READONLY tinyint Indicates whether the work entry is editable or read-only.
WWORK_APPROVAL_STATUS integer The status of the timesheet work entry.
Top

MSP_WEB_WORK_ADJUSTED

Stores information about timesheet work entries that have been adjusted.

Column Name Data Type Description
WADJUST_ID integer The unique ID for the adjusted work entry.
WASSN_ID integer Refers to a valid ID in the MSP_WEB_ASSIGNMENTS table.
WWORK_DATE datetime The date the work entry was adjusted.
WWORK_TYPE integer Indicates the type of work performed:
0 Scheduled work
1 Actual work
2 Overtime actual work
WWORK_VALUE decimal The number of hours worked, measured as minutes * 1000; for example: 8 hours worked is stored as 480000.
WWORK_VALUE_ADJUSTED decimal The amount of work for the assignment after adjustment.
WWORK_ADJUST_DATE datetime The date that an assignment was adjusted.
WRES_ID integer The resource assigned to the adjusted assignment; refers to a valid WRES_ID in the MSP_WEB_RESOURCES table.
Top

MSP_WEB_WORK_APPROVAL

This table stores all timesheet approvals for Project Server uses, including who approved the timesheet entry, the assignment, start and finish dates, and approval status.

Column Name Data Type Description
WAPPROVAL_ID integer The unique ID for the approved work entry.
WASSN_ID integer Refers to a valid ID in the MSP_WEB_ASSIGNMENTS table.
WRES_ID integer Refers to a valid ID in the MSP_WEB_RESOURCES table.
WPRD_START_DATE datetime The start date for the approved time period.
WPRD_FINISH_DATE datetime The finish date for the approved time period.
WRES_ID_APPROVER integer The ID for the resource who approved or rejected the work entry; refers to a valid ID in the MSP_WEB_RESOURCES table.
WAPPROVAL_STATUS tinyint Indicates whether the work entry was approved or rejected.
WAPPROVAL_NOTIFICATION_SENT tinyint Indicates whether a notification has been sent regarding the work entry.
Top

MSP_WEB_WORKGROUP_FIELDS

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

Column Name Data Type Description
PK WASSN_ID integer Refers to a valid assignment in the MSP_WEB_ASSIGNMENTS table
PK FIELD_ID integer The unique ID for the workgroup field.
CUSTFIELD_TYPE integer Indicates the type of field; same as WFIELD_TEXTCONV_TYPE in the MSP_WEB_VIEW_FIELDS table:
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 Cost rate (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 midnight)
24 Long
25 Link type (SS, FF, FS, or SF)
28 Elapsed duration (for example, 5ed)
29 Task type (for example, fixed units, fixed work, fixed duration)
30 Hyperlink (friendly name)
31 Hyperlink (target)
32 Hyperlink (location)
33 Hyperlink (HREF)
INT_VAL integer The value of CUSTFIELD_TYPE if the value is an integer.
DATE_VAL datetime The value of CUSTFIELD_TYPE if the value is an date.
DECIMAL_VAL decimal The value of CUSTFIELD_TYPE if the value is an decimal.
VARCHAR_VAL nvarchar(255) The value of CUSTFIELD_TYPE if the value is an string.
INDICATOR_VAL integer The enumerated value of CUSTFIELD_TYPE if the value is an indicator.
DURATION_UNIT integer The value of CUSTFIELD_TYPE if the value is a duration.
WWORKGRP_UPDATE_STATUS integer Indicates whether the custom field entry has been edited by the resource.
0 Not edited by resource
1 Edited by resource but not updated to the project manager yet
WWORKGRP_INFO_IS_READONLY tinyint Indicates whether 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.

Column Name Data Type Description
PK CUSTFIELD_INFO_ID integer The unique ID for the custom workgroup field.
FIELD_ID integer The field ID for the custom workgroup field. Refers to a valid ID in the MSP_WEB_WORKGROUP_FIELDS table.
CUSTFIELD_NAME nvarchar(255) The name of the custom workgroup field.
CONV_VALUE integer Refers to a valid CONV_VALUE in the MSP_WEB_CONVERSIONS table.
Top

MSP_WEB_WSS_LIST_SYNCHRONIZATION_TIMES

This table stores information used to synchronize Project Server with Windows SharePoint Services.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
WOBJ_LIST_NAME uniqueidentifier The name of the document library.
WPROJ_WSS_LAST_LIST_SYNC_TIME nvarchar(50) The time of the last Project Server synchronization with Windows SharePoint Services.
Top

Project and Resource View Tables

The Project Server view tables combine the friendly format of the Project OLE DB Provider schema with the more powerful SQL OLE DB provider and adds the ability to perform cross-project reporting. These tables are used to generate the staging tables for the OLAP cube (Portfolio Analyzer and Portfolio Modeler) and to create the project drill-down views from the Project Center in Project Web Access. When these tables are written out, they will have an additional column for the Project Server Project ID, and the OLE DB tables will expose the enterprise project UID. Resource view tables contain the latest information and the availability of each resource and are only created for enterprise resources.

Unique aspects of the Project Server View tables

Some aspects of the Project Server View tables are unique:

  • Duration fields return minutes * 10 (for example, 8 hours is 4800) and Work fields return minutes * 1000 (for example, 8 hours is 480000).
  • Dates that would be be displayed as NA in the interface are returned as 0.
  • A formula in a custom field that would be displayed as #ERROR in the interface returns the default value for the field.
  • Custom fields where no value has been set return the default value.
  • Custom field indicator fields where no indicator has been set return "-1".
  • Work values for material resources are returned in the units defined in the interface, rather than minutes * 1000.

NoteB B The MSP_VIEW_SERVICE_NEW_DROPS and MSP_VIEW_SERVICE_PUBLISH_STATUS tables are used internally by Project Server to manage the Views Publishing service and to queue publish requests. These tables should only be accessed and modified by Project Server.

MSP_VIEW_PROJ_ASSN_CF

This table contains custom field information for assignments. Information in this table is obtained from the Assignments table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
CF_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CF_AssignmentUniqueID integer Refers to a valid AssignmentUniqueID in the MSP_VIEW_PROJ_ASSN_STD table.
CF_ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
AssignmentCost1-10 decimal Custom cost information.
AssignmentDate1-10 datetime Custom date information.
AssignmentDuration1-10 integer Custom duration information.
AssignmentFinish1-10 datetime Custom finish information.
AssignmentFlag1-20 tinyint Custom flag information.
AssignmentNumber1-20 decimal Custom number information.
AssignmentStart1-10 datetime Custom start information.
AssignmentText1-30 ntext Custom text information.
Top

MSP_VIEW_PROJ_ASSN_ENT

This table contains enterprise information for assignments. Information in this table is obtained from the Assignments table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ENT_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
ENT_AssignmentUniqueID integer Refers to a valid AssignmentUniqueID in the MSP_VIEW_PROJ_ASSN_STD table.
ENT_ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
AssignmentEnterpriseCost1-10 decimal Custom enterprise-level cost information.
AssignmentEnterpriseDate1-30 datetime Custom enterprise-level date information.
AssignmentEnterpriseDuration1-10 integer Custom enterprise-level duration information.
AssignmentEnterpriseFlag1-20 tinyint Custom enterprise-level flag information.
AssignmentEnterpriseNumber1-40 decimal Custom enterprise-level number information.
AssignmentOutlineCode1-30ID integer Enterprise custom outline code information. Enterprise outline codes 20-29 correspond to an AssignmentEnterpriseRMV outline code. Enterprise outline code 30 is used for Resource Breakdown Structure (RBS).
AssignmentEnterpriseText1-40 ntext Custom enterprise-level text information.
AssignmentEnterpriseRMV20-29ID ntext Enterprise resource multi-value outline code information. AssignmentEnterpriseRMV outline codes 20-29 correspond to an AssignmentEnterpriseOutlineCode outline code.
Top

MSP_VIEW_PROJ_ASSN_STD

This table contains standard information for assignments. Information in this table is obtained from the Assignments table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
AssignmentUniqueID integer The unique ID for the assignment.
ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_PROJ_RES_STD table.
TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
AssignmentPercentWorkComplete smallint The current status of an assignment, expressed as the percentage of the assignment's work that has been completed.
AssignmentActualCost decimal The cost incurred for work already performed by a resource on a task.
AssignmentActualFinish datetime The date and time when an assignment was actually completed.
AssignmentActualOvertimeCost decimal The cost incurred for overtime work already performed by a resource on a task.
AssignmentActualOvertimeWork decimal The actual amount of overtime work already performed by a resource on an assigned task.
AssignmentActualStart datetime The date and time that an assignment actually began.
AssignmentActualWork decimal The amount of work that has already been done by a resource on a task.
AssignmentACWP decimal The costs incurred for work already performed by a resource on a task up to the project status date or today's date; also called Actual Cost of Work Performed.
AssignmentBaselineCost decimal The total planned cost for work to be performed by a resource on a task.
AssignmentBaseline1-10Cost decimal Custom baseline cost information.
AssignmentBaselineFinish datetime The planned completion date for an assignment at the time a baseline is saved.
AssignmentBaseline1-10Finish decimal Custom baseline finish information.
AssignmentBaselineStart datetime The planned beginning date for an assignment at the time a baseline is saved.
AssignmentBaseline1-10Start decimal Custom baseline start information.
AssignmentBaselineWork decimal The originally planned amount of work to be performed by a resource on a task.
AssignmentBaseline1-10Work decimal Custom baseline work information.
AssignmentBCWP decimal The cumulative value of the assignment's timephased percentage of work complete multiplied by the assignment's timephased baseline cost up to the status date or today's date; also known as Earned Value.
AssignmentBCWS decimal The cumulative timephased baseline costs up to the status date or today's date.
AssignmentConfirmed tinyint Indicates whether a resource assigned to a task has accepted or rejected the task assignment in response to a message notifying a resource of an assignment.
AssignmentCost decimal The total scheduled (or projected) cost for an assignment based on costs already incurred for work performed by the resource on a task, in addition to the costs planned for the remaining work for the assignment.
CostRateTable smallint Indicates which cost rate table to use for a resource on an assignment:
0 A (default)
1 B
2 C
3 D
4 E
AssignmentCostVariance decimal The difference between the baseline cost and total cost for an assignment.
AssignmentCV decimal The difference between how much it should have cost to achieve the current level of completion on the assignment and how much it has actually cost to achieve the current level of completion up to the status date or today's date.
AssignmentDelay integer The amount of time a resource is to wait after the task start date before starting work on an assignment.
AssignmentFinish datetime The date and time that an assigned resource is scheduled to complete work on a task.
AssignmentFinishVariance integer The difference between an assignment's baseline finish date and its scheduled finish date.
AssignmentFixedMaterial tinyint Indicates whether the consumption of the assigned material resource occurs in a single, fixed amount.
AssignmentHasFixedRateUnits tinyint Indicates whether an assignment has fixed rate units.
AssignmentHyperlink ntext The title or explanatory text for a hyperlink associated with an assignment.
AssignmentHyperlinkAddress ntext The address for a hyperlink associated with an assignment.
AssignmentHyperlinkHref ntext The combination, or concatenation, of the hyperlink address and hyperlink sub-address fields associated with an assignment.
AssignmentHyperlinkScreenTip ntext The text contained in a ScreenTip associated with a hyperlink.
AssignmentHyperlinkSubAddress ntext The specific location in a document within a hyperlink associated with an assignment.
AssignmentLevelingDelay integer The amount of time that an assignment is to be delayed from the scheduled start date as a result of resource leveling.
AssignmentLinkedFields tinyint Indicates whether there are OLE links to the assignment.
AssignmentMilestone tinyint Indicates whether the assignment task is a milestone.
AssignmentNotes ntext Contains notes about an assignment.
AssignmentOtherType smallint Indicates the type of assignment:
0 Regular
1 Task-only work
2 Fixed cost
3 Fixed cost and task-only work
AssignmentOverallocated tinyint Indicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity.
AssignmentOvertimeCost decimal The total overtime cost for a resource assignment.
AssignmentOvertimeWork decimal The amount of overtime to be performed by a resource on a task; charged at the resource's overtime rate.
AssignmentPeakUnits decimal The maximum percentage of units for which a resource is assigned to a task for a given period of time.
AssignmentRegularWork decimal The total amount of non-overtime work scheduled to be performed by a resource assigned to a task.
AssignmentRemainingCost decimal The costs associated with completing all remaining scheduled work by any resources on a specific task.
AssignmentRemainingOvertimeCost decimal The remaining scheduled overtime expense for an assignment.
AssignmentRemainingOvertimeWork decimal The amount of overtime work that remains on an assignment.
AssignmentRemainingWork decimal The amount of time required by a resource assigned to a task to complete an assignment.
AssignmentRemainingWorkContour image Indicates how remaining work for an assignment is to be distributed across the duration of the assignment:
0 Flat (default)
1 Back Loaded
2 Front Loaded
3 Double Peak
4 Early Peak
5 Late Peak
6 Bell
7 Turtle
8 Contoured
AssignmentResourceID integer Refers to a valid ResourceID in the MSP_VIEW_PROJ_RES_STD table.
AssignmentResourceName nvarchar(255) The name of the resource associated with the assignment.
AssignmentResourceRequestType smallint The type of request:
0 None (default)
1 Request
2 Demand
AssignmentResourceType smallint The resource type:
0 Material; consumable supplies like steel, concrete, or soil
1 Work (default); people and equipment
AssignmentResponsePending tinyint Indicates whether an answer has been received from a message notifying a resource of an assignment sent to a resource assigned to a task.
AssignmentStart datetime The date and time that an assigned resource is scheduled to begin working on a task.
AssignmentStartVariance integer The difference between an assignment's baseline start date and its currently scheduled start date.
AssignmentSummary tinyint Indicates whether the assignment is part of a summary task.
AssignmentSV decimal The difference in cost terms between the current progress and the baseline plan of the assignment up to the status date or today's date.
AssignmentTaskID integer Refers to a valid TaskID in the MSP_VIEW_PROJ_TASKS_STD table.
AssignmentTaskName nvarchar(255) The name of the task associated with the assignment.
AssignmentTaskSummaryName nvarchar(255) The name of the summary task for the task associated with the assignment.
AssignmentTeamStatusPending tinyint Indicates whether a status message has been received in response to a message requesting status that was sent to a resource assigned to a task.
AssignmentUnits decimal The number of units for which a resource is assigned to a task, expressed as a percentage of 100%, assuming a resource's MaxUnits value is 100%.
AssignmentUpdateNeeded tinyint Indicates whether a message notifying a resource of changes that affect tasks should be sent to the resource assigned to a task because of changes to the start date, finish date, or resource reassignments.
AssignmentVAC decimal The variance at completion (VAC) between the baseline cost and the total cost for an assignment on a task.
AssignmentWork decimal The total amount of work scheduled to be performed by a resource on a task.
AssignmentWorkContour smallint Indicates how work for an assignment is to be distributed across the duration of the assignment:
0 Flat (default)
1 Back Loaded
2 Front Loaded
3 Double Peak
4 Early Peak
5 Late Peak
6 Bell
7 Turtle
8 Contoured
AssignmentWorkVariance decimal The difference between an assignment's baseline work and the currently scheduled work.
AssignmentBookingType smallint Indicates the booking type of an assignment:
0 Hard
2 Soft
AssignmentActualOvertimeWorkProtected decimal The actual overtime work that has been protected.
AssignmentActualWorkProtected decimal The actual work that has been protected.
Top

MSP_VIEW_PROJ_ASSN_TP_BY_DAY

This table contains timephased information for assignments. Information in this table is obtained from the AssignmentsTimephasedByDay table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
AssignmentUniqueID integer Refers to a valid AssignmentUniqueID in the MSP_VIEW_PROJ_ASSN_STD table.
AssignmentTimeStart datetime The date and time that an assigned resource is scheduled to begin working on a task.
AssignmentTimeFinish datetime The date and time that an assigned resource is scheduled to complete work on a task.
AssignmentTimeActualCost decimal Shows costs incurred for work already performed by a resource on a task.
AssignmentTimeActualOvertimeWork decimal The actual amount of overtime work already performed by a resource on an assigned task.
AssignmentTimeActualWork decimal The amount of work that has already been done by a resource on a task.
AssignmentTimeBaselineCost decimal Specifies the total planned cost for work to be performed by a resource on a task.
AssignmentTimeBaselineWork decimal The originally planned amount of work to be performed by a resource on a task.
AssignmentTimeCost decimal The total scheduled (or projected) cost for a resource assignment based on costs already incurred for work performed by the resource on a task, in addition to the costs planned for the remaining work for the assignment.
AssignmentTimeCumulativeCost decimal The scheduled cumulative timephased cost for a resource assignment to date, based on costs already incurred for work performed by the resource on the task, in addition to the costs planned for the remaining work for the assignment.
AssignmentTimeCumulativeWork decimal The total amount of work scheduled to be performed by a resource on a task.
AssignmentTimeOvertimeWork decimal The amount of overtime to be performed by a resource on a task; charged at the resource's overtime rate.
AssignmentTimePeakUnits decimal The maximum percentage of units for which a resource is assigned to a task for a given period of time.
AssignmentTimeRegularWork decimal The total amount of non-overtime work scheduled to be performed by a resource assigned to a task.
AssignmentTimeWork decimal The total amount of time for work scheduled to be performed by a resource on a task.
Top

MSP_VIEW_PROJ_CAL

This table contains information about calendars. Information in this table is obtained from the Calendars table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CalendarUniqueID integer The unique ID for the calendar.
ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_PROJ_RES_STD table.
ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
CalendarName nvarchar(255) The name of the calendar; empty if this calendar is a resource calendar.
CalendarIsBaseCalendar tinyint Indicates whether this calendar is a base calendar; a resource calendar cannot be a base calendar.
CalendarBaseCalendarUniqueID integer Refers a calendar to its parent base calendar (required for all resource calendars).
Top

MSP_VIEW_PROJ_CAL_DATA

This table contains calendar data. Information in this table is obtained from the CalendarData table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CalendarUniqueID integer Refers to a valid CalendarUniqueID in the MSP_VIEW_PROJ_CAL table.
CalendarWeekday integer Indicates the defined working day for the calendar:
0 Exception
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
CalendarWorking integer Indicates whether the selected days are working or nonworking days.
CalendarFromDate datetime The date the exception begins.
CalendarToDate datetime The date the exception ends.
CalendarFromTime1-5 datetime The time the first, second, third, fourth, or fifth shift begins.
CalendarToTime1-5 datetime The time the first, second, third, fourth, or fifth shift ends.
Top

MSP_VIEW_PROJ_CAL_EXCEPTIONS

This table contains calendar data. Information in this table is obtained from the CalendarExceptions table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CalendarUniqueID integer Refers to a valid CalendarUniqueID in the MSP_VIEW_PROJ_CAL table.
CalendarExceptionFromDate datetime The date the calendar exception begins.
CalendarExceptionToDate datetime The date the calendar exception ends.
CalendarExceptionWorking integer Indicates whether the days contained in the calendar exception date range are working or nonworking days.
CalendarExceptionFromTime1-3 datetime The time the first, second, or third time period begins.
CaldnearExceptionToTime1-3 datetime The time the first, second, or third time period ends.
Top

MSP_VIEW_PROJ_PRED

This table contains information about predecessor projects. Information in this table is obtained from the Predecessors table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
PredecessorTaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
PredecessorLag integer The amount of lead (negative number) or lag (positive number) time for the predecessor task; for example: -3d or +4d.
PredecessorPath nvarchar(260) The path to the predecessor task (even if the successor task is contained in another project); for example: C:\My Documents\Bldg E Construction.mpp\3FF.
PredecessorType smallint The type of predecessor task:
0 FF (finish-to-finish)
1 FS (finish-to-start)
2 SF (start-to-finish)
3 SS (start-to-start)
PredecessorLagType smallint Indicates the format for the amount of lag specified in PredecessorLag:
3 m
4 em
5 h
6 eh
7 d
8 ed
9 w
10 ew
11 mo
12 emo
19 %
20 e%
35 m?
36 em?
37 h?
38 eh?
39 d?
40 ed?
41 w?
42 ew?
43 mo?
44 emo?
51 %?
52 e%?
Top

MSP_VIEW_PROJ_PROJECTS_ENT

This table contains enterprise information for projects. Information in this table is obtained from the Project table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ENT_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
ProjectEnterpriseName nvarchar(255) The name of the project within the enterprise.
ProjectEnterpriseVersion nvarchar(255) The version of the project within the enterprise.
ProjectEnterpriseCost1-10 decimal Custom project-level enterprise cost information.
ProjectEnterpriseCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ProjectEnterpriseDate1-30 datetime Custom project-level enterprise date information.
ProjectEnterpriseDate1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ProjectEnterpriseDuration1-10 integer Custom project-level enterprise duration information.
ProjectEnterpriseDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ProjectEnterpriseFlag1-20 tinyint Custom project-level enterprise flag information.
ProjectEnterpriseFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ProjectEnterpriseNumber1-40 integer Custom project-level enterprise number information.
ProjectEnterpriseNumber1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ProjectEnterpriseOutlineCode1-30ID integer Custom project-level enterprise outline code information.
ProjectEnterpriseText1-40 ntext Custom project-level enterprise text information.
ProjectEnterpriseText1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
Top

MSP_VIEW_PROJ_PROJECTS_STD

This table contains standard information for projects. Information in this table is obtained from the Project table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer The unique ID for the project.
ProjectCurrencyDigits smallint The number of digits that are to appear after the decimal when currency values are shown in Project:
0 No digits after the decimal; $0
1 One digit after the decimal; $0.0
2 Two digits after the decimal (default); $0.00
ProjectCurrencyPosition smallint Indicates the placement of the currency symbol in relation to the currency value:
0 Before, no space (default); $0
1 After, no space; 0$
2 Before, with space; $ 0
3 After, with space; 0 $
ProjectCurrencySymbol nvarchar(10) The currency symbol used to represent the type of currency used in the project.
ProjectDefaultFinishTime smallint The default finish time for all new tasks.
ProjectDefaultStartTime smallint The default start time for all new tasks.
ProjectTitle nvarchar(255) The title of the project; used to group similar projects together.
ProjectCalendarName nvarchar(255) The name of the calendar associated with the project.
ProjectFinishDate datetime The date and time that a project is scheduled for completion.
ProjectStartDate datetime The date and time that a project is scheduled to begin.
ProjectStatusDate datetime The project status date.
Top

MSP_VIEW_PROJ_RES_CF

This table contains custom field information for resources. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
CF_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CF_ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_PROJ_RES_STD table.
CF_ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
ResourceCost1-10 decimal Custom cost information.
ResourceCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDate1-10 datetime Custom date information.
ResourceDate1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDuration1-10 integer Custom duration information.
ResourceDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceFinish1-10 datetime Custom finish date information.
ResourceFinish1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceFlag1-20 tinyint Indicates whether a resource is marked for further action or identification of some kind.
ResourceFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceNumber1-20 decimal Custom numeric information.
ResourceNumber1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceOutlineCode1-10 ntext An alphanumeric code defined to represent a hierarchical structure of resources.
ResourceStart1-10 datetime Custom start date information.
ResourceStart1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceText1-30 ntext Custom text information.
ResourceText1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
Top

MSP_VIEW_PROJ_RES_ENT

This table contains enterprise information for resources. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ENT_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
ENT_ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_PROJ_RES_STD table.
ENT_ResourceEnterpriseUniqueID integer Refers to a valid ResourceEnterpriseUniqueID in the MSP_VIEW_PROJ_RES_STD table.
ResourceEnterpriseCost1-10 decimal Custom enterprise-level cost information.
ResourceEnterpriseCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseDate1-30 datetime Custom enterprise-level date information.
ResourceEnterpriseDate1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseDuration1-10 integer Custom enterprise-level duration information.
ResourceEnterpriseDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseFlag1-20 tinyint Custom enterprise-level flag information.
ResourceEnterpriseFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseGeneric smallint Indicates whether the resource is an enterprise-level generic resource.
ResourceEnterpriseNumber1-40 decimal Custom enterprise-level number information.
ResourceEnterpriseNumber1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseOutlineCode1-30ID integer Enterprise custom outline code information. Enterprise outline codes 20-29 correspond to an ResourceEnterpriseRMV outline code. Enterprise outline code 30 is used for Resource Breakdown Structure (RBS).
ResourceEnterpriseText1-40 ntext Custom enterprise-level text information.
ResourceEnterpriseText1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseRMV20-29ID ntext Enterprise resource multi-value outline code information. ResourceEnterpriseRMV outline codes 20-29 correspond to an ResourceEnterpriseOutlineCode outline code.
Top

MSP_VIEW_PROJ_RES_STD

This table contains standard information for resources. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
ResourceUniqueID integer The unique ID for the resource.
ResourceEnterpriseUniqueID integer The unique enterprise ID for the resource.
ResourcePercentWorkComplete smallint The current status of all tasks assigned to a resource, expressed as the total percentage of the resource's work that has been completed.
ResourceAccrueAt smallint Indicates how and when resource standard and overtime costs are to be charged, or accrued, to the cost of a task:
1 Start; costs are accrued as soon as the task starts, as indicated by a date entered in the ActualStart field.
2 End; costs are not incurred until remaining work is zero.
3 Pro-rated (default); costs accrue as work is scheduled to occur and as actual work is reported.
ResourceActualCost decimal The sum of costs incurred for the work already performed by a resource for all assigned tasks.
ResourceActualOvertimeCost decimal The cost incurred for overtime work already performed by a resource for all assigned tasks.
ResourceActualOvertimeWork decimal The actual amount of overtime work already performed for all assignments assigned to a resource.
ResourceActualWork decimal The actual amount of work that has already been done for all assignments assigned to a resource.
ResourceACWP decimal The sum of Actual Cost of Work Performed (ACWP) values for all of a resource's assignments, up to the status date or today's date.
ResourceAvailableFrom datetime The starting date that a resource is available for work at the units specified for the current time period.
ResourceAvailableTo datetime The ending date in which a resource will be available for work at the units specified for the current time period.
ResourceBaseCalendar ntext Lists all calendars available to be applied to a resource, including the standard calendar and any custom calendars:
0 Standard (default)
1+ Custom calendar
ResourceBaselineCost decimal The total planned cost for a resource for all assigned tasks; also called Budget At Completion (BAC).
ResourceBaselineCost1-10 decimal Custom baseline cost information.
ResourceBaselineFinish datetime The planned finish date for assignments.
ResourceBaselineFinish1-10 datetime Custom baseline finish information.
ResourceBaselineStart datetime The planned beginning date for assignments.
ResourceBaselineStart1-10 datetime Custom baseline start information.
ResourceBaselineWork decimal The originally planned amount of work to be performed for all assignments assigned to a resource.
ResourceBaselineWork1-10 decimal Custom baseline work information.
ResourceBCWP decimal The rolled-up summary of a resource's BCWP values for all assigned tasks, calculated up to the status date or today's date; also called Budgeted Cost of Work Performed.
ResourceBCWS decimal The rolled-up summary of a resource's BCWS values for all assigned tasks; also called Budgeted Cost of Work Scheduled.
ResourceCanLevel tinyint Indicates whether resource leveling can be done with a resource.
ResourceCode ntext A code, initials, or number entered as part of a resource's information.
ResourceConfirmed tinyint Indicates whether a resource has accepted or rejected all task assignments in response to a message notifying a resource of an assignment.
ResourceCost decimal The total scheduled cost for a resource for all assigned tasks, based on costs already incurred for work performed by the resource on all assigned tasks in addition to the costs planned for all remaining work.
ResourceCostPerUse decimal The cost that accrues each time a resource is used.
ResourceCostVariance decimal The difference between the baseline cost and total cost for a resource.
ResourceCV decimal The difference between how much it should have cost for the resource to achieve the current level of completion, and how much it has actually cost to achieve the current level of completion, up to the status date or today's date.
ResourceEmailAddress ntext The e-mail address of a resource; if this field is left blank, Project will use the name in the ResourceName field as the e-mail address.
ResourceFinish datetime The date and time that a resource is scheduled to complete work on all assigned tasks.
ResourceGroup ntext The name of the group associated with the resource.
ResourceHyperlink ntext The title or explanatory text for a hyperlink associated with a resource.
ResourceHyperlinkAddress ntext The address for a hyperlink associated with a resource.
ResourceHyperlinkHref ntext The combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a resource.
ResourceHyperlinkScreenTip ntext The text contained in a ScreenTip associated with a hyperlink.
ResourceHyperlinkSubAddress ntext The specific location in a document within a hyperlink associated with a resource.
ResourceID integer Indicates the position of a resource in relation to other resources.
ResourceInitials ntext The initials for a resource name.
ResourceIsNull tinyint Indicates whether the resource is a null resource.
ResourceLinkedFields tinyint Indicates whether there are OLE links to the resource, either from elsewhere in the active project, another Project file, or from another program.
ResourceMaterialLabel ntext The unit of measurement entered for a material resource, for example: tons, boxes, or cubic yards. This is used in conjunction with the material resource's Assignment Units and is only available if ResourceType is set to Material.
ResourceMaxUnits decimal The maximum percentage, or number of units, that represents the maximum capacity that a resource is available to accomplish any tasks during the current time period. This can exceed 100%.
ResourceName nvarchar(255) The name of the resource; must be unique within the enterprise whether or not the resource is active.
ResourceNotes ntext Notes about a resource.
ResourceNTAccount ntext The Windows NT Account name for a resource; for example: domain name\user name.
ResourceObjects integer The number of objects associated with a resource, not including those in notes.
ResourceOverallocated tinyint Indicates whether a resource is assigned to do more work on all assigned tasks than can be done within the resource's normal work capacity.
ResourceOvertimeCost decimal The total overtime cost for a resource on all assigned tasks.
ResourceOvertimeRate decimal The rate of pay for overtime work performed by a resource.
ResourceOvertimeWork decimal The amount of overtime to be performed for all tasks assigned to a resource and charged at the resource's overtime rate.
ResourcePeakUnits decimal The maximum percentage, or number of units, for which a resource is assigned at any one time for all tasks assigned to the resource.
ResourcePhonetics ntext Contains phonetic information in either Hiragana or Katakana for resource names; used only in the Japanese version of Project.
ResourceRegularWork decimal The total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource.
ResourceRemainingCost decimal The remaining scheduled expense that will be incurred in completing the remaining work assigned to a resource.
ResourceRemainingOvertimeCost decimal The remaining scheduled overtime expense of a resource that will be incurred in completing the remaining planned overtime work by a resource on all assigned tasks.
ResourceRemainingOvertimeWork decimal The remaining amount of overtime required by a resource to complete all tasks.
ResourceRemainingWork decimal The amount of time, or person-hours, still required by a resource to complete all assigned tasks.
ResourceResponsePending tinyint Indicates whether an answer has been received from all messages notifying a resource of an assignment sent to a resource about assigned tasks.
ResourceStandardRate decimal The rate of pay for regular, non-overtime work performed by a resource.
ResourceStart datetime The date and time that an assigned resource is scheduled to begin working on all assigned tasks.
ResourceSV decimal The difference in cost terms between the current progress and the baseline plan of all the resource's assigned tasks up to the status date or today's date; also called Earned Value Schedule Variance.
ResourceTeamStatusPending tinyint Indicates whether an answer has been received in response to a message requesting status that was sent to a resource about an assigned task.
ResourceType smallint The resource type (Work or Material):
0 Material; consumable supplies like steel, concrete, or soil
1 Work (default); people and equipment
ResourceUpdateNeeded tinyint Indicates whether a message notifying a resource of changes that affect tasks should be sent to a resource because of changes to any of the resource's assigned tasks.
ResourceVAC decimal The difference between the baseline cost and the total cost for a resource.
ResourceWork decimal The total amount of work scheduled to be performed by a resource on all assigned tasks.
ResourceWorkgroup smallint The messaging method used to communicate with a project workgroup:
0 Default
1 None
3 Project Server
ResourceWorkVariance decimal The difference between a resource's total baseline work and the currently scheduled work.
ResourceBookingType smallint Indicates the booking type for a resource:
0 Hard
2 Soft
ResourceActualOvertimeWorkProtected decimal The actual overtime work that has been protected.
ResourceActualWorkProtected decimal The actual work that has been protected.
Top

MSP_VIEW_PROJ_SUCC

This table contains information about successor projects. Information in this table is obtained from the Successors table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
SuccessorTaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
SuccessorLag integer The amount of lead (negative number) or lag (positive number) time for the successor task; for example: -3d or +4d.
SuccessorPath nvarchar(260) The path to the successor task (even if the successor task is contained in another project); for example: C:\My Documents\Bldg E Construction.mpp\3FF.
SuccessorType smallint The type of successor task:
0 FF (finish-to-finish)
1 FS (finish-to-start)
2 SF (start-to-finish)
3 SS (start-to-start)
Top

MSP_VIEW_PROJ_TASKS_CF

This table contains custom field information for tasks. Information in this table is obtained from the Tasks table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
CF_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
CF_TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
TaskCost1-10 decimal Custom cost information.
TaskCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskDate1-10 datetime Custom date information.
TaskDate1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskDuration1-10 integer Custom duration information.
TaskDuration1-10Estimated tinyint Indicates whether the corresponding TaskDuration1-10 field is estimated.
TaskDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskFinish1-10 datetime Custom finish date information.
TaskFinish1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskFlag1-20 tinyint Custom flag information.
TaskFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskNumber1-20 decimal Custom numeric information.
TaskNumber1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskOutlineCode1-10 ntext An alphanumeric code that represents a hierarchical structure of tasks.
TaskStart1-10 datetime Custom start date information.
TaskStart1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskText1-30 ntext Custom text information.
TaskText1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
Top

MSP_VIEW_PROJ_TASKS_ENT

This table contains enterprise information for tasks. Information in this table is obtained from the Tasks table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ENT_ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
ENT_TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
TaskEnterpriseCost1-10 decimal Custom enterprise-level cost information.
TaskEnterpriseCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEnterpriseDate1-30 datetime Custom enterprise-level date information.
TaskEnterpriseDate1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEnterpriseDuration1-10 integer Custom enterprise-level duration information.
TaskEnterpriseDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEnterpriseFlag1-20 tinyint Custom enterprise-level flag information.
TaskEnterpriseFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEnterpriseNumber1-40 decimal Custom enterprise-level number information.
TaskEnterpriseNumber1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
TaskEnterpriseOutlineCode1-30ID integer Custom enterprise-level outline code information.
TaskEnterpriseText1-40 ntext Custom enterprise-level text information.
TaskEnterpriseText1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
Top

MSP_VIEW_PROJ_TASKS_STD

This table contains standard information for tasks. Information in this table is obtained from the Tasks table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
TaskUniqueID integer The unique ID for the task.
TaskPercentComplete smallint The current status of a task, expressed as the percentage of the task's duration that has been completed.
TaskPercentWorkComplete smallint The current status of a task, expressed as the percentage of the task's work that has been completed.
TaskActualCost decimal The costs incurred for work already performed by all resources on a task, along with any other recorded costs associated with the task.
TaskActualDuration integer The span of actual working time for a task so far, based on the scheduled duration and current remaining work or completion percentage.
TaskActualFinish datetime The date and time that a task actually finished.
TaskActualOvertimeCost decimal The costs incurred for overtime work already performed on a task by all assigned resources.
TaskActualOvertimeWork decimal The actual amount of overtime work already performed by all resources assigned to a task.
TaskActualStart datetime The date and time that a task actually began.
TaskActualWork decimal The amount of work that has already been done by the resources assigned to a task.
TaskACWP decimal The costs incurred for work already done on a task, up to the project status date or today's date.
TaskBaselineCost decimal The total planned cost for a task; also referred to as Budget At Completion (BAC).
TaskBaselineCost1-10 decimal Custom baseline cost information.
TaskBaselineDuration integer The original span of time planned to complete a task.
TaskBaselineDuration1-10 integer Custom baseline duration information.
TaskBaselineDurationEstimated tinyint Indicates whether the baseline duration is estimated.
TaskBaselineDurationEstimated1-10 tinyint Custom baseline estimated duration information.
TaskBaselineFinish datetime The planned completion date for a task at the time a baseline is saved.
TaskBaselineFinish1-10 datetime Custom baseline finish information.
TaskBaselineStart datetime The planned beginning date for a task at the time a baseline is saved.
TaskBaselineStart1-10 datetime Custom baseline start information.
TaskBaselineWork decimal The originally planned amount of work to be performed by all resources assigned to a task.
TaskBaselineWork1-10 decimal Custom baseline work information.
TaskBCWP decimal The cumulative value of the task's timephased percent complete multiplied by the task's timephased baseline cost, up to the status date or today's date; also known as Earned Value.
TaskBCWS decimal The cumulative timephased baseline costs up to the status date or today's date.
TaskCalendar ntext Lists all calendars available to be applied to a task, including the standard calendar and any custom calendars:
0 Standard (default)
1+ Custom calendar
TaskCompleteThrough datetime The progress of a task on the Gantt Chart, up to the point that actuals have been reported for the task.
TaskConfirmed tinyint Indicates whether all resources assigned to a task have accepted or rejected the task assignment in response to a message notifying a resource of an assignment.
TaskConstraintDate datetime Indicates the constrained start or finish date as defined in TaskConstraintType. Required unless TaskConstraintType is set to As late as possible or As soon as possible.
TaskConstraintType smallint The constraint on a scheduled task:
0 As soon as possible
1 As late as possible
2 Must start on; TaskConstraintDate is required
3 Must finish on; TaskConstraintDate is required
4 Start no earlier than; TaskConstraintDate is required
5 Start no later than; TaskConstraintDate is required
6 Finish no earlier than; TaskConstraintDate is required
7 Finish no later than; TaskConstraintDate is required
TaskContact ntext The name of the individual who is responsible for a task.
TaskCost decimal The total scheduled, or projected, cost for a task, based on costs already incurred for work performed by all resources assigned to the task, in addition to the costs planned for the remaining work for the assignment.
TaskCostVariance decimal The difference between the baseline cost and the total cost for a task.
TaskCPI decimal The cost performance index, or the ratio of budget to actual cost.
TaskCreated datetime The date and time that a task was added to a project.
TaskCritical tinyint Indicates whether a task has room in the schedule to slip, or if it is on the critical path.
TaskCV decimal The difference between how much it should have cost to achieve the current level of completion on the task and how much it has actually cost to achieve the current level of completion up to the status date or today's date; also called cost variance.
TaskCVP smallint The cost variance percentage for a task.
TaskDeadline datetime The date entered as a deadline for the task.
TaskDuration integer The total span of active working time for a task.
TaskDurationElapsed integer Indicates which field is used to base BCWP values on.
TaskDurationVariance integer The difference between the baseline duration of a task and the total duration (current estimate) of a task.
TaskEarlyFinish datetime The earliest date that a task could possibly finish, based on early finish dates of predecessor and successor tasks, other constraints, and any leveling delay.
TaskEarlyStart datetime The earliest date that a task could possibly begin, based on the early start dates of predecessor and successor tasks, and other constraints.
TaskEffortDriven tinyint Indicates whether scheduling for a task is effort-driven.
TaskEstimated tinyint Indicates whether the task's duration is flagged as an estimate.
TaskExternalTask tinyint Indicates whether the task is linked from another project or whether it originated in the current project.
TaskEAC decimal The total scheduled or projected cost for a task, resource, or assignment based on costs already incurred, in addition to the costs planned for remaining work.
TaskFinish datetime The date and time that a task is scheduled to be completed.
TaskFinishSlack integer The duration between the Early Finish and Late Finish dates.
TaskFinishVariance integer The amount of time that represents the difference between a task's baseline finish date and its current finish date.
TaskFixedCost decimal A task expense that is not associated with a resource cost.
TaskFixedCostAccrual smallint Indicates how fixed costs are to be charged, or accrued, to the cost of a task:
1 Start; costs are accrued as soon as the task starts, as indicated by a date entered in the ActualStart field.
2 End; costs are not incurred until remaining work is zero.
3 Pro-rated (default); costs accrue as work is scheduled to occur and as actual work is reported.
TaskFreeSlack integer The amount of time that a task can be delayed without delaying any successor tasks; if a task has zero successor tasks, then free slack is the amount of time a task can be delayed without delaying the entire project.
TaskHideBar tinyint Indicates whether the Gantt bars and Calendar bars for a task are hidden.
TaskHyperlink ntext The title or explanatory text for a hyperlink associated with a task.
TaskHyperlinkAddress ntext The address for a hyperlink associated with a task.
TaskHyperlinkHref ntext The combination, or concatenation, of the hyperlink address and hyperlink sub-address fields associated with a task.
TaskHyperlinkScreenTip ntext The text contained in a ScreenTip associated with a hyperlink.
TaskHyperlinkSubAddress ntext The specific location in a document within a hyperlink associated with a task.
TaskID integer Indicates the position of a task in relation to other tasks.
TaskIgnoreResourceCalendar tinyint Indicates whether the scheduling of the task takes into account the calendars of the resources assigned to the task.
TaskIsNull tinyint Indicates whether a task is a null task.
TaskLateFinish datetime The latest date that a task can finish without delaying the finish of the project.
TaskLateStart datetime The latest date that a task can start without delaying the finish of the project.
TaskLevelAssignments tinyint Indicates whether the leveling function can delay and split individual assignments (rather than the entire task) in order to resolve overallocations.
TaskLevelingCanSplit tinyint Indicates whether the resource leveling function can cause splits on remaining work on a task.
TaskLevelingDelay integer The amount of time that a task is to be delayed from its early start date as a result of resource leveling.
TaskLinkedFields tinyint Indicates whether there are OLE links to a task, either from elsewhere in the active project, another Project file, or from another program.
TaskMarked tinyint Indicates whether a task is marked for further action or identification of some kind.
TaskMilestone tinyint Indicates whether a task is a milestone.
TaskName nvarchar(255) The name of a task.
TaskNotes ntext Notes entered about a task.
TaskObjects integer The number of objects attached to a task.
TaskOutlineLevel smallint The number that indicates the level of a task in the project outline hierarchy.
TaskOutlineNumber ntext Indicates the exact position of a task in the outline. For example, 7.2 indicates that a task is the 2nd subtask under the 7th top-level summary task.
TaskOverallocated tinyint Indicates whether an assigned resource on a task has been assigned to more work on the task than can be done within the normal working capacity.
TaskOvertimeCost decimal The actual overtime cost for a task.
TaskOvertimeWork decimal The amount of overtime scheduled to be performed by all resources assigned to a task and charged at overtime rates.
TaskPredecessors ntext The task ID numbers for the predecessor tasks to this task.
TaskPreleveledFinish datetime The finish date of a task as it was before resource leveling was done.
TaskPreleveledStart datetime The start date of a task as it was before resource leveling was done.
TaskPriority smallint Indicates the level of importance assigned to a task; the higher the number, the higher the priority:
0 Lowest priority; task will always be leveled
500 Default value
1000 Highest priority; task will never be leveled
TaskRecurring tinyint Indicates whether a task is a recurring task.
TaskRegularWork decimal The total amount of non-overtime work scheduled to be performed by all resources assigned to a task.
TaskRemainingCost decimal The remaining scheduled expense of a task that will be incurred in completing the remaining scheduled work by all resources assigned to a task.
TaskRemainingDuration integer The amount of time required to complete the unfinished portion of a task. Remaining duration can be calculated in two ways (either based off of Percent (%) Complete or Actual Duration).
TaskRemainingOvertimeCost decimal The remaining scheduled overtime expense for a task.
TaskRemainingOvertimeWork decimal The amount of remaining overtime scheduled by all assigned resources to complete a task.
TaskRemainingWork decimal The amount of time still required by all assigned resources to complete a task.
TaskResourceGroup ntext The list of resource groups to which the resources assigned to a task belong.
TaskResourceInitials ntext Lists the initials for the names of resources assigned to a task.
TaskResourceNames ntext Lists the names of all resources assigned to a task.
TaskResourcePhonetics ntext Contains information in either Hiragana or Katakana for the names of resources assigned to a task; used only in the Japanese version of Project.
TaskResponsePending tinyint Indicates whether an answer has been received from all messages notifying a resource of an assignment sent to the resources assigned to a task.
TaskResume datetime The date the remaining portion of a task is scheduled to resume after you enter a new value for the Percent (%) Complete field.
TaskRollup tinyint Indicates whether the summary task bar displays rolled-up bars or whether information on the sub-task Gantt bars will be rolled up to the summary task bar; must be set to True for sub-tasks to be rolled up to summary tasks.
TaskSPI decimal The schedule performance index or the ratio of performed to scheduled work.
TaskStart datetime The date and time that a task is scheduled to begin; this value is automatically calculated if a task has a predecessor.
TaskStartSlack integer The amount of time a task can be delayed without affecting the start date of a successor task or the project finish date.
TaskStartVariance integer The difference between a task's baseline start date and its currently scheduled start date.
TaskStop datetime The date that represents the end of the actual portion of a task; contains NA until you enter actual work or a completion percentage.
TaskStatus smallint The current status of a task.
TaskSubprojectFile ntext The name of a project inserted into the active project file including the sub-project's path and file name.
TaskSubprojectReadOnly tinyint Indicates whether the sub-project of this task is a read-only project.
TaskSuccessors ntext The task ID numbers for the successor tasks to this task.
TaskSummary tinyint Indicates whether a task is a summary task.
TaskSummaryProgress datetime The progress on a summary task, based on the progress of its sub-tasks.
TaskSV decimal The difference between the current progress and the baseline plan of the task up to the status date or today's date; also known as Earned Value Schedule Variance.
TaskSVP smallint The Schedule Variance Percentage (SVP) for a task.
TaskTCPI decimal The To Complete Performance Index (TCPI) for a task.
TaskTeamStatusPending tinyint Indicates whether an answer has been received in response to a message requesting status that was sent to the resources assigned to a task.
TaskTotalSlack integer The amount of time a task can be delayed without delaying a project's finish date.
TaskType smallint Indicates the effect that editing work, assignment units, or duration has on the calculations of the other two fields:
0 Fixed units (default); the number of Assignment Units remains constant, regardless of the amount of work or duration on the task
1 Fixed duration; the duration of the task remains constant, regardless of the number of resources (Assignment Units) assigned or the amount of work
2 Fixed work; the amount of work remains constant, regardless of any change in duration or the number of resources (Assignment Units) assigned to the task
TaskUniqueIDPredecessors ntext The unique IDs for predecessor tasks. For example, 15FS+3d means that this task's predecessor is task ID 15, with a finish-to-start dependency, and 3 days lag time.
TaskUniqueIDSuccessors ntext The unique IDs for successor tasks. For example, 15FS+3d means that this task's successor is task ID 15, with a finish-to-start dependency, and 3 days lag time.
TaskUpdateNeeded tinyint Indicates whether a message notifying a resource of changes that affect tasks should be sent to the assigned resources because of changes to the start date, finish date, or resource reassignments of the task.
TaskVAC decimal The difference between the baseline cost and the total cost for a task; also called Variance At Completion (VAC).
TaskWBS ntext A unique code (WBS) used to represent a task's position within the hierarchical structure of the project.
TaskWBSPredecessors ntext The WBS codes associated with a predecessor task on which the task depends before it can start or finish.
TaskWBSSuccessors ntext Lists the WBS codes associated with the successor tasks.
TaskWork decimal The total amount of work scheduled to be performed on a task by all assigned resources.
TaskWorkVariance decimal The difference between a task's baseline work and the currently scheduled work.
TaskParentUID integer Refers to a valid TaskUniqueID in the Tasks table; the unique ID for a task's parent task.
TaskActualOvertimeWorkProtected decimal The actual overtime work that has been protected.
TaskActualWorkProtected decimal The actual work that has been protected.
Top

MSP_VIEW_PROJ_TASK_TP_BY_DAY

This table contains timephased information for tasks. Information in this table is obtained from the TaskTimephasedByDay table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASK_STD table.
TaskTimeStart datetime The date and time that a task is scheduled to begin.
TaskTimeFinish datetime The date and time that a task is scheduled to be completed.
TaskTimeFixedCost decimal A task expense that is not associated with a resource cost.
TaskTimeActualFixedCost decimal The actual timephased non-resource task expenses, charged over time according to the selected cost accrual method.
Top

MSP_VIEW_PROJ_TASKSPLITS

This table contains information for split tasks. Information in this table is obtained from the TaskSplits table in the Project OLE DB Provider.

Column Name Data Type Description
WPROJ_ID integer Refers to a valid WPROJ_ID in the MSP_WEB_PROJECTS table.
ProjectUniqueID integer Refers to a valid ProjectUniqueID in the MSP_VIEW_PROJ_PROJECTS_STD table.
TaskUniqueID integer Refers to a valid TaskUniqueID in the MSP_VIEW_PROJ_TASKS_STD table.
SplitStart datetime The date the task split begins.
SplitFinish datetime The date the task split ends.
Top

MSP_VIEW_RES_CF

This table contains custom field information for resources and is used to determine resource availability for Assignment and Resource cube generation. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
CF_ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_RES_STD table.
ResourceCost1-10 decimal Custom cost information.
ResourceCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDate1-10 datetime Custom date information.
ResourceDate1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDuration1-10 integer Custom duration information.
ResourceDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceFinish1-10 datetime Custom finish date information.
ResourceFinish1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceFlag1-20 tinyint Indicates whether a resource is marked for further action or identification of some kind.
ResourceFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceNumber1-20 decimal Custom numeric information.
ResourceNumber1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceOutlineCode1-10 ntext An alphanumeric code defined to represent a hierarchical structure of resources.
ResourceStart1-10 datetime Custom start date information.
ResourceStart1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceText1-30 ntext Custom text information.
ResourceText1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
Top

MSP_VIEW_RES_ENT

This table contains enterprise information for resources and is used to determine resource availability for Assignment and Resource cube generation. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
ENT_ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_RES_STD table.
ResourceEnterpriseCost1-10 decimal Custom enterprise-level cost information.
ResourceEnterpriseCost1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseDate1-30 datetime Custom enterprise-level date information.
ResourceEnterpriseDate1-30Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceDuration1-10 integer Custom duration information.
ResourceDuration1-10Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseFlag1-20 tinyint Custom enterprise-level flag information.
ResourceEnterpriseFlag1-20Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseGeneric smallint Indicates whether the resource is an enterprise-level generic resource.
ResourceEnterpriseNumber1-40 decimal Custom enterprise-level number information.
ResourceEnterpriseNumber1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseOutlineCode1-30ID integer Enterprise custom outline code information. Enterprise outline codes 20-29 correspond to an ResourceEnterpriseRMV outline code. Enterprise outline code 30 is used for Resource Breakdown Structure (RBS).
ResourceEnterpriseText1-40 ntext Custom enterprise-level text information.
ResourceEnterpriseText1-40Indicator smallint The indicator symbol for the corresponding custom field. See Indicator symbols for more information.
ResourceEnterpriseRMV20-29ID ntext Enterprise resource multi-value outline code information. ResourceEnterpriseRMV outline codes 20-29 correspond to an ResourceEnterpriseOutlineCode outline code.
Top

MSP_VIEW_RES_STD

This table contains standard information for resources and is used to determine resource availability for Assignment and Resource cube generation. Information in this table is obtained from the Resources table in the Project OLE DB Provider.

Column Name Data Type Description
ResourceUniqueID integer The unique ID for the resource.
ResourcePercentWorkComplete smallint The current status of all tasks assigned to a resource, expressed as the total percentage of the resource's work that has been completed.
ResourceAccrueAt smallint Indicates how and when resource standard and overtime costs are to be charged, or accrued, to the cost of a task:
1 Start; costs are accrued as soon as the task starts, as indicated by a date entered in the ActualStart field.
2 End; costs are not incurred until remaining work is zero.
3 Pro-rated (default); costs accrue as work is scheduled to occur and as actual work is reported.
ResourceActualCost decimal The sum of costs incurred for the work already performed by a resource for all assigned tasks.
ResourceActualOvertimeCost decimal The cost incurred for overtime work already performed by a resource for all assigned tasks.
ResourceActualOvertimeWork decimal The actual amount of overtime work already performed for all assignments assigned to a resource.
ResourceActualWork decimal The actual amount of work that has already been done for all assignments assigned to a resource.
ResourceACWP decimal The sum of Actual Cost of Work Performed (ACWP) values for all of a resource's assignments, up to the status date or today's date.
ResourceAvailableFrom datetime The starting date that a resource is available for work at the units specified for the current time period.
ResourceAvailableTo datetime The ending date in which a resource will be available for work at the units specified for the current time period.
ResourceBaseCalendar ntext Lists all calendars available to be applied to a resource, including the standard calendar and any custom calendars:
0 Standard (default)
1+ Custom calendar
ResourceBaselineCost decimal The total planned cost for a resource for all assigned tasks; also called Budget At Completion (BAC).
ResourceBaselineCost1-10 decimal Custom baseline cost information.
ResourceBaselineFinish datetime The planned finish date for assignments.
ResourceBaselineFinish1-10 datetime Custom baseline finish information.
ResourceBaselineStart datetime The planned beginning date for assignments.
ResourceBaselineStart1-10 datetime Custom baseline start information.
ResourceBaselineWork decimal The originally planned amount of work to be performed for all assignments assigned to a resource.
ResourceBaselineWork1-10 decimal Custom baseline work information.
ResourceBCWP decimal The rolled-up summary of a resource's BCWP values for all assigned tasks, calculated up to the status date or today's date; also called Budgeted Cost of Work Performed.
ResourceBCWS decimal The rolled-up summary of a resource's BCWS values for all assigned tasks; also called Budgeted Cost of Work Scheduled.
ResourceCanLevel tinyint Indicates whether resource leveling can be done with a resource.
ResourceCode ntext A code, initials, or number entered as part of a resource's information.
ResourceConfirmed tinyint Indicates whether a resource has accepted or rejected all task assignments in response to a message notifying a resource of an assignment.
ResourceCost decimal The total scheduled cost for a resource for all assigned tasks, based on costs already incurred for work performed by the resource on all assigned tasks in addition to the costs planned for all remaining work.
ResourceCostPerUse decimal The cost that accrues each time a resource is used.
ResourceCostVariance decimal The difference between the baseline cost and total cost for a resource.
ResourceCV decimal The difference between how much it should have cost for the resource to achieve the current level of completion, and how much it has actually cost to achieve the current level of completion, up to the status date or today's date.
ResourceEmailAddress ntext The e-mail address of a resource; if this field is left blank, Project will use the name in the ResourceName field as the e-mail address.
ResourceFinish datetime The date and time that a resource is scheduled to complete work on all assigned tasks.
ResourceGroup ntext The name of the group associated with the resource.
ResourceHyperlink ntext The title or explanatory text for a hyperlink associated with a resource.
ResourceHyperlinkAddress ntext The address for a hyperlink associated with a resource.
ResourceHyperlinkHref ntext The combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a resource.
ResourceHyperlinkScreenTip ntext The text contained in a ScreenTip associated with a hyperlink.
ResourceHyperlinkSubAddress ntext The specific location in a document within a hyperlink associated with a resource.
ResourceID integer Indicates the position of a resource in relation to other resources.
ResourceInitials ntext The initials for a resource name.
ResourceIsNull tinyint Indicates whether the resource is a null resource.
ResourceLastPublished datetime The date and time that a resource was last published.
ResourceLinkedFields tinyint Indicates whether there are OLE links to the resource, either from elsewhere in the active project, another Project file, or from another program.
ResourceMaterialLabel ntext The unit of measurement entered for a material resource, for example: tons, boxes, or cubic yards. This is used in conjunction with the material resource's Assignment Units and is only available if ResourceType is set to Material.
ResourceMaxUnits decimal The maximum percentage, or number of units, that represents the maximum capacity that a resource is available to accomplish any tasks during the current time period. This can exceed 100%.
ResourceName nvarchar(255) The name of the resource; must be unique within the enterprise whether or not the resource is active.
ResourceNotes ntext Notes about a resource.
ResourceNTAccount ntext The Windows NT Account name for a resource; for example: domain name\user name.
ResourceObjects integer The number of objects associated with a resource, not including those in notes.
ResourceOverallocated tinyint Indicates whether a resource is assigned to do more work on all assigned tasks than can be done within the resource's normal work capacity.
ResourceOvertimeCost decimal The total overtime cost for a resource on all assigned tasks.
ResourceOvertimeRate decimal The rate of pay for overtime work performed by a resource.
ResourceOvertimeWork decimal The amount of overtime to be performed for all tasks assigned to a resource and charged at the resource's overtime rate.
ResourcePeakUnits decimal The maximum percentage, or number of units, for which a resource is assigned at any one time for all tasks assigned to the resource.
ResourcePhonetics ntext Contains phonetic information in either Hiragana or Katakana for resource names; used only in the Japanese version of Project.
ResourceRegularWork decimal The total amount of non-overtime work scheduled to be performed for all assignments assigned to a resource.
ResourceRemainingCost decimal The remaining scheduled expense that will be incurred in completing the remaining work assigned to a resource.
ResourceRemainingOvertimeCost decimal The remaining scheduled overtime expense of a resource that will be incurred in completing the remaining planned overtime work by a resource on all assigned tasks.
ResourceRemainingOvertimeWork decimal The remaining amount of overtime required by a resource to complete all tasks.
ResourceRemainingWork decimal The amount of time, or person-hours, still required by a resource to complete all assigned tasks.
ResourceResponsePending tinyint Indicates whether an answer has been received from all messages notifying a resource of an assignment sent to a resource about assigned tasks.
ResourceStandardRate decimal The rate of pay for regular, non-overtime work performed by a resource.
ResourceStart datetime The date and time that an assigned resource is scheduled to begin working on all assigned tasks.
ResourceSV decimal The difference in cost terms between the current progress and the baseline plan of all the resource's assigned tasks up to the status date or today's date; also called Earned Value Schedule Variance.
ResourceTeamStatusPending tinyint Indicates whether an answer has been received in response to a message requesting status that was sent to a resource about an assigned task.
ResourceType smallint The resource type (Work or Material):
0 Material; consumable supplies like steel, concrete, or soil
1 Work (default); people and equipment
ResourceUpdateNeeded tinyint Indicates whether a message notifying a resource of changes that affect tasks should be sent to a resource because of changes to any of the resource's assigned tasks.
ResourceVAC decimal The difference between the baseline cost and the total cost for a resource.
ResourceWork decimal The total amount of work scheduled to be performed by a resource on all assigned tasks.
ResourceWorkgroup smallint The messaging method used to communicate with a project workgroup:
0 Default
1 None
3 Project Server
ResourceWorkVariance decimal The difference between a resource's total baseline work and the currently scheduled work.
ResourceBookingType smallint Indicates the booking type for a resource:
0 Hard
2 Soft
ResourceActualWorkOvertimeProtected decimal The actual overtime work that has been protected.
ResourceActualWorkProtected decimal The actual work that has been protected.
Top

MSP_VIEW_RES_TP_BY_DAY

This table contains timephased information for resources and is used to determine resource availability for Assignment and Resource cube generation. Information in this table is obtained from the ResourcesTimephasedByDay table in the Project OLE DB provider.

Column Name Data Type Description
ResourceUniqueID integer Refers to a valid ResourceUniqueID in the MSP_VIEW_RES_STD table.
ResourceTimeStart datetime The date and time that an assigned resource is scheduled to begin working on all assigned tasks.
ResourceTimeFinish datetime The date and time that an assigned resource is scheduled to finish working on all assigned tasks.
ResourceTimeWorkAvailability decimal The maximum amount of time a work resource is available to be scheduled for work during any selected time period.
Top

Assignment and Resource Cube Tables

Assignment and Resource cubes are used to provide project and resource drill down views in Project Web Access. Assignment and Resource cubes pull data from the project, assignment, and resource view tables (see Project and Resource View Tables for more information).

MSP_CUBE_ASSN_BOOKING

This table links the term for booking type to the stored value for the booking type.

Column Name Data Type Description
ASSN_BOOKING_TYPE smalling Indicates the booking type of an assignment:
0 Hard
2 Soft
ASSN_BOOKING_DESC nvarchar(255) The description of the booking type.
Top

MSP_CUBE_ASSN_FACT

The Assignments Cube is made up of this table and all of its associated dimension tables:

Column Name Data Type Description
PROJ_UID integer Refers to a valid PROJ_UID in the MSP_CUBE_PROJECTS table.
RES_ENTUID integer Refers to a valid RES_ENTRUID in the MSP_CUBE_RESOURCES table.
TIME_ID integer Refers to a valid TIME_ID in the MSP_CUBE_TIME_BY_DAY table.
TIME_DATE datetime Refers to the TIME_DATE field for the same TIME_ID row in the MSP_CUBE_TIME_BY_DAY table.
ENT_ASSIGNMENT_CODEn integer Refers to a valid ASSN_OUTLINECODE_ID in the MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n table; n is represented by a number ranging from 1-30.
ASSN_ACTUALCOST float Refers to the AssignmentActualCost field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_ACTUALOVERTIMEWORK float Refers to the AssignmentActualOvertimeWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_ACTUALWORK float Refers to the AssignmentActualWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_BASELINECOST float Refers to the AssignmentBaselineCost field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_BASELINEWORK float Refers to the AssignmentBaselineWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_COST float Refers to the AssignmentCost field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_OVTERTIMEWORK float Refers to the AssignmentOvertimeWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_REGULARWORK float Refers to the AssignmentRegularWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_WORK float Refers to the AssignmentWork field in the MSP_VIEW_PROJ_ASSN_STD table.
ASSN_MATERIAL_ACTUALWORK float Refers to the AssignmentActualWork field in the MSP_VIEW_PROJ_ASSN_STD table if this resource is a material resource.
ASSN_MATERIAL_BASELINEWORK float Refers to the AssignmentBaselineWork field in the MSP_VIEW_PROJ_ASSN_STD table if this resource is a material resource.
ASSN_MATERIAL_WORK float Refers to the AssignmentWork field in the MSP_VIEW_PROJ_ASSN_STD table if this resource is a material resource.
ASSN_BOOKING_TYPE smallint Indicates the booking type of an assignment:
0 Hard
2 Soft
Top

MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n

There is one MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n table generated for each existing ENT_ASSIGNMENT_CODEn in the MSP_CUBE_ASSN_FACT table.

Column Name Data Type Description
ASSN_OUTLINECODE_NAME nvarchar(255) The name of the Assignment Outline Code.
ASSN_OUTLINECODE_DESCRIPTION ntext The description of the Assignment Outline Code.
ASSN_OUTLINECODE_ID integer Refers to a valid ENT_ASSIGNMENT_CODEn in the MSP_CUBE_ASSN_FACT table.
ASSN_OUTLINECODE_PARENTID integer Refers to a valid ASSN_OUTLINECODE_ID in an MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n table; set to 0 for top-level codes without parents.
Top

MSP_CUBE_ENTERPRISE_PROJECT_OUTLINE_n

There is one MSP_CUBE_ENTERPRISE_PROJECT_OUTLINE_n table generated for each existing ENTERPRISE_PROJECT_CODEn in the MSP_CUBE_PROJECTS table.

Column Name Data Type Description
PROJ_OUTLINECODE_NAME nvarchar(255) The name of the Project Outline Code.
PROJ_OUTLINECODE_DESCRIPTION ntext The description of the Project Outline Code.
PROJ_OUTLINECODE_ID integer Refers to a valid ENTERPRISE_PROJECT_CODEn in the MSP_CUBE_PROJECTS table.
PROJ_OUTLINECODE_PARENTID integer Refers to a valid ASSN_OUTLINECODE_ID in an MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n table; set to "0" for top-level codes without parents.
Top

MSP_CUBE_ENTERPRISE_RESOURCE_OUTLINE_n

There is one MSP_CUBE_ENTERPRISE_RESOURCE_OUTLINE_n table generated for each ENTERPRISE_RESOURCE_CODEn in the MSP_CUBE_RESOURCES table.

Column Name Data Type Description
RES_OUTLINECODE_NAME nvarchar(255) The name of the Resource Outline Code.
RES_OUTLINECODE_DESCRIPTION ntext The description of the Resource Outline Code.
RES_OUTLINECODE_ID integer Refers to a valid ENTERPRISE_RESOURCE_CODEn in the MSP_CUBE_RESOURCES table.
RES_OUTLINECODE_PARENTID integer Refers to a valid ASSN_OUTLINECODE_ID in an MSP_CUBE_ENTERPRISE_ASSIGNMENT_OUTLINE_n table; set to 0 for top-level codes without parents.
Top

MSP_CUBE_PROJ_VERSIONS

This table gets all available project versions stored in the MSP_VERSIONS table and assigns them a unique ID to use with the Assignment or Resource cubes.

Column Name Data Type Description
PROJ_VERSION_UID integer Refers to a valid PROJ_VERSION_UID in the MSP_CUBE_PROJECTS table.
PROJ_VERSION nvarchar(120) The name of the project version, as indicated by the VERS_VERSION field in the MSP_VERSIONS table.
Top

MSP_CUBE_PROJECTS

This table links specific information in the MSP_WEB_PROJECTS table with project versions and enterprise outline codes for use in Assignment and Resource cube generation.

Column Name Data Type Description
PROJ_UID integer Refers to a valid PROJ_UID in the MSP_WEB_PROJECTS table.
PROJ_NAME nvarchar(255) Refers to a valid PROJ_NAME in the MSP_WEB_PROJECTS table.
PROJ_PROP_TITLE ntext Refers to a valid PROJ_PROP_TITLE in the MSP_WEB_PROJECTS table.
PROJ_VERSION_UID integer The unique ID for the project version.
ENTERPRISE_PROJECT_CODEn integer Where n is represented by a number ranging from 1-30
Top

MSP_CUBE_RES_AVAIL_FACT

The Resources Cube is made up of the Resource Availability Fact table and all of its associated dimension tables: MSP_CUBE_RESOURCES, MSP_CUBE_ENTERPRISE_RESOURCE_OUTLINE_n, and MSP_CUBE_TIME_BY_DAY.

Column Name Data Type Description
RES_ENTRUID integer Refers to a valid RES_ENTRUID in the MSP_CUBE_RESOURCES table.
TIME_ID integer Refers to a valid TIME_ID in the MSP_CUBE_TIME_BY_DAY table.
TIME_DATE datetime Refers to a valid TIME_DATE in the MSP_CUBE_TIME_BY_DAY table.
RES_AVAIL float This value is generated by comparing the resource availability table to the date range specified when building the Assignment or Resource cube. This value represents the total available time for a resource on a given day that falls within the specified date range.
Top

MSP_CUBE_RESOURCES

Stores enterprise resource data based on specific information stored in the MSP_WEB_RESOURCES table.

Column Name Data Type Description
RES_ENTRUID integer Refers to a valid WRES_EUID in the MSP_WEB_RESOURCES table.
RESOURCENAME nvarchar(255) The name of the resource as specified in the RES_NAME field in the MSP_WEB_RESOURCES table.
ENTERPRISE_RESOURCE_CODEn integer The ID for the enterprise resource code; n is represented by a number ranging from 1-30.
RES_IS_ACTIVE nvarchar(255) Indicates whether the resource is an Active or Inactive user.
Top

MSP_CUBE_TIME_BY_DAY

Stores the time dimension for both the Assignments and Resource Availability cubes. This dimension is the date range selected when building the Assignment or Resource cube.

Column Name Data Type Description
TIME_ID integer The unique ID for the time dimension. Each day in the specified date range will have a unique ID.
TIME_DATE datetime The number of days in the time period; for example, if an OLAP cube is built around three days, then the value in this field would be 3.
TIME_DAY nvarchar(32) The name of the day of the week, for example: Monday.
TIME_MONTH nvarchar(32) The name of the month of the year, for example: August.
TIME_YEAR integer The year, for example: 2001.
TIME_DAY_OF_MONTH integer The day of the month (1-31).
TIME_WEEK_OF_YEAR integer The week of the year (1-53).
TIME_MONTH_OF_YEAR integer The month of the year (0-11).
TIME_QTR nvarchar(2) The fiscal quarter, for example: 1 for the first quarter.
Top

Расскажите о статье друзьям

Вы не вошли под своим пользователем на MicrosoftProject.ru.
Рекомендуется нажать "Закрыть" и зарегистрироваться на сайте.
Зарегистрированные пользователи, выступающие как редакторы,
имеют различные бонусы по доступу к закрытым материалам.
Если Вам не важны бонусы, можете отправить правку прямо сейчас.

Фрагмент, требующий улучшения
Ваша версия фрагмента. Отредактируйте текст
Степень серьезности проблемы
Проблемы содержания
Стилистические проблемы
Синтаксические и орфографические проблемы
Ваш комментарий:

Если вы заметили любую ошибку в статье, вы можете сообщить об этой ошибке редакторам сайта, выделив мышью отрывок текста с ошибкой и нажав Ctrl+Enter. Ваша помощь в улучшении материалов для нас неоценима!

© 2003-2017, Портал MicrosoftProject.Ru. Все права защищены.

E-mail: обратная связь