Add or edit an Enterprise Custom Lookup Table

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:

1. On the PWA Server Settings page, click Enterprise Custom fields and Lookup Tables.

2. 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.

3. For a new table, type a name for the lookup table in the Name box.

4. 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.

5. 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.

Top of Page

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.

Top of Page

Lookup Table

Use the Lookup Table section of the New Lookup table page to specify the values in the lookup table.

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.

Top of Page