Add or edit an Enterprise Custom Lookup Table (Project Server 2010)
Applies to: Project Server 2010
Topic Last Modified: 2011-11-18
The New Lookup table page in Microsoft Project Server 2010 lets you specify the options for a custom lookup table. Use the following procedure to create or edit an enterprise custom lookup table.
To create or edit Enterprise Custom Lookup Tables
On the PWA Server Settings page, click Enterprise Custom fields and Lookup Tables.
Under Lookup Tables for Custom Fields, click New Lookup Table to create a new lookup table, or click the lookup table that you want to edit.
For a new table, type a name for the lookup table in the Name box.
Fill out the Custom Lookup Table page by specifying the options that you want to use. See the descriptions for each field in the following sections.
Click Save.
Type
For a new lookup table, you must specify a data type for the table. It is not possible to mix field types in a table.
The following table describes the options for data types in a custom lookup table.
| Attribute | Description |
|---|---|
Cost |
Each field in the table is a cost value. |
Date |
Each field in the table is a date value. |
Duration |
Each value in the table is treated as a duration. |
Number |
Each value in the table is a number. |
Text |
Each value in the table is text. Choosing Text also allows a hierarchy of values to be specified if you want. |
Code mask
The code mask option only appears when a field type of Text has been selected.
The code mask lets you specify what types of text characters appear in the lookup table, the length of the string, and what characters to use to separate levels in a hierarchy. If you are creating a hierarchical lookup table, you must specify a code mask for each level of the hierarchy.
The following table describes the options available for configuring code masks.
| Attribute | Description |
|---|---|
Code preview |
Displays a preview of the code mask for the table. |
Sequence |
Specify the type of text characters to allow. Choose Numbers, Uppercase characters, Lowercase characters, or Characters. |
Length |
Specify the maximum length of the string. Choose a number from 1 to 255 or Any. |
Separator |
Specify from one to three characters to use as a separator between levels of the table hierarchy. |
Lookup Table
Use the Lookup Table section of the New Lookup table page to specify the values in the lookup table.
Note
If you are having difficulty editing the grid, make sure that you have applied the latest updates for Internet Explorer 9 on your workstation.
Type each value that you want in the lookup table in the Value column. Create as many rows as needed to accommodate the values that you want to include. Optionally, include a description for the value in the Description column.
The following table describes the options for creating lookup table values.
| Attribute | Description |
|---|---|
Level |
Denotes the level in the hierarchy. This is a read-only field. Select the row and use the Indent and Outdent buttons to change levels. |
Value |
Specify the value of the field. |
Description |
Describes what the field represents. (Optional) |
Move |
Use the Move buttons to change the position of rows in the table. Select a row and then click the Up or Down Move button to move a row. |
Display order for lookup table |
Specifies how to sort the lookup table. If you select By row number, the table remains sorted as you specify it. If you choose to sort ascending or descending, the table is sorted based on the values in the Value column. |