SharePoint Events

 ProjectReady Applications for Project Management and Document Control in SharePoint
 5/24/2017 - Webcast: Regulatory Compliant Document Generation in SharePoint & Office 365
 6/01/2017 - Webcast: Sneak Peek – The NEW ProjectReady Central: Project Management & Document Control in SharePoint & Office 365
 6/14/2017 - Webcast: Hybrid Best Practices with SharePoint and Office 365
 7/19/2017 - Webcast: The NEW ProjectReady Central Launch – Project Management and Document Control in SharePoint
 8/09/2017 - Webcast: Understanding the Features and Benefits of Microsoft Azure & the Microsoft Cloud
(More Links...)

 SharePoint Videos

 Security & Sharing in SharePoint 2016, Online & Office 365
 Enterprise Records Management in SharePoint & Office 365
 Best New Features of SharePoint 2016
 The Value of the Microsoft Cloud: Understanding the Scalability, Affordable Storage & Security Advantages of Office 365
 Task, Resource & Utilization Management & Reporting for the AEC with SharePoint and Office 365
 Legal Matter Task Management and Reports in SharePoint and Office 365
 What’s Coming in Office 365 & SharePoint 2016
 Automating Contract Management with Workflow in the Cloud or On-Premise
 Manage Email in the Cloud or On-Premise with SharePoint & Office 365
 Governance Essentials for SharePoint 2013 and SharePoint Online
 Easily Move Email, Files and SharePoint to Office 365
 Enterprise Workflow in the cloud with SharePoint & Office 365
 Why SharePoint 2013
 SharePoint 2013 vs SharePoint Online and Office 365 Security, Compliance and eDiscovery
 Expanding the Use, Potential and Value of SharePoint and Office 365 through 3rd Party Applications
 Keys to Successful SharePoint Initiatives and User Adoption
 SharePoint 2013 vs. SharePoint Online: Workflow
 Ensure Auditability and Compliance with Advanced Workflows in SharePoint
 SharePoint 2013 vs. SharePoint Online and Office 365: Enterprise Content Management
 SharePoint 2013 vs. SharePoint Online and Office 365: Business Intelligence
(More Links...)

 Archives ‭[1]‬

Opening SharePoint Links in a new window
Mail Enabled Lists vs. The Missing Windows 2008 POP3/IMAP Server 
7 Tools for SharePoint Developers
Public Facing Masterpage Techniques
How to Quickly Deploy and Activate a Timer Service to Your Site Collection
Custom SharePoint Master Page Feature with WSP Builder
Date Math with InfoPath
Enterprise Search Tricks and Tips Part 1
Populating Word Documents With SharePoint Data. Try The DIP!
Programmatic Deep Dive into Blank SharePoint Lookup Columns
1 - 10Next
How Project Server 2010 Store Custom Field Values

By: Yi Fan Tang

Project Server 2010 comes as a web application to a SharePoint 2010 Farm, along with a service application for provisioning and managing. Although it is a web application, large part of the data are not stored in the web application’s content database. They are stored in a separated database created during the provision of the project server web application. I will use the custom fields as an example to show briefly how Project Server 2010 stores the data in that database.


Basically, a custom field value for a project will involve four tables, the project field values table, the custom fields table, the lookup tables table and the lookup tables values table. The following table shows the roles of each table.


The following diagram shows the relationship of all the four tables.


The “Project Field Values” table only stores the custom field values. If the custom field is a look up field, the “Project Field Values” table stores the lookup table value ID. The value’s actual display name, for example, is stored in the “Lookup Table Values” table. Given a project ID and a custom field ID, you can get the name of the custom field in the “Custom Fields” table and its value in the “Project Field Values” table, or further the value’s display information in the “Lookup Table Values” table.

For developers to access the project custom fields’ information programmatically, the following out of box Project Server 2010 web service will come in handy:


Please check the following MSDN article for the full information of each web service:

By: Yi Fan Tang



  GigWerks RSS  Gig Werks Mailing List 

 Contact Us



 On Demand SharePoint Webcast Recordings
 Upcoming Webinars
 SharePoint Resources
 Business Intelligence Resources
 Gig Werks Website

©2009 Gig Werks. All rights reserved. Privacy Policy