Skip to main content
Planview Customer Success Center

About Lookup Lists and Status Lists

Users with administrative privileges can add/edit values for existing lookup or status lists, and create new lookup lists.

Lookup lists and Status lists are lists of values that you can associate with fields. Users can then select a value from a list when specifying a value for the field. You view and configure status and lookup lists on Admin/Setup/Lookup Lists.

Status Lists

You can associate status lists with Status fields only (standard LL Status List type fields). You cannot create new status lists, but you can update the values of the provided list.

PPM Pro provides the following set of status lists:

  • Asset Status
  • Department Status
  • Enterprise Status (was Account)
  • HRIssue Status
  • Material Estimate Status
  • Portfolio Status
  • Project Status
  • Request Status
  • Task Status

Lookup Lists

Lookup Lists can be associated with user-defined fields on request, portfolio, asset, task, or project entities.

PPM Pro provide the following set of lookup lists

Addl Contact Email/Phone Email Type Contact Type Material Estimate Type Project Log Priority Request Priority Task Complexity
Addl Contact Email/Phone Phone Type Dashboard Type Project Business Objective Project Log Type Request Status Task Phase
Associated Address Type Division Type Project Investment Type Project Phase Resource Lookup list TBD Task Priority
Associated Contact Type Enterprise Activity Type Project Log Budget Impact Project Priority Resource Type Task Type
Attachment Category Enterprise Lead Source Project Log Complexity Project Risk Roles Task Work Effort
Baseline Type Enterprise Type Project Log Phase Project Type Task Budget Impact Timesheet Administrative Time Types

Default values are provided for almost all lookup and status Lists; you can edit or delete the default values as you see fit to better match your organizational terminology and processes.

Implied Status

Status lists have a property called "implied status". An implied status is an umbrella status that maps to one or more statuses. Its a way to consolidate multiple status types to one type.  For example, imagine you have the following project statuses: proposed, in progress, paused, and late. All of those statuses relate to projects that are open - in other words they have an implied status of Open (because they are not closed).

There are three implied status values:  Open, Closed, and Proposed. You must map every status value you create to one of these implied status values. The notion of implied status simplifies reporting and filtering because it gives you a way to aggregate like entities. Implied status is also useful for driving some business logic for timesheets. 

For example, you might need the granularity of status values such as "Planning", "In Review", or "Phase 1," but they all have the commonality of referring to an open entity (project, for example), and as such, have an implied status of Open. Likewise, "Canceled" and "Complete" both refer to Closed tasks or projects.

For filters, implied status simplifies the filter statement by allowing you to use "entity: Implied Status" instead of listing every single status value that might apply.

Special Behavior for Closed Project Status

There are various views in the user interface that automatically filter out projects with an implied status of Closed; that is, Closed projects are not displayed and their data is not included in capacity and demand calculations. For example, the Resource Workbench does not include closed projects in capacity and demand calculations. Remember that you can give other statuses and implied status of Closed and they too will be withheld. For example, perhaps you do not want to see or include any projects with a status of Hold (which is an Implied Closed status) in capacity and demand calculations. The following areas/features do not consider projects with status of Implied Closed:

  • Resource Workbench
  • Find Demand
  • KPI reports
  • Home/Issues
  • Home/Tasks
  • What If
  • PPA

Note that timesheet rules can be written to include/exclude closed projects; reports, Capacity & Demand facility can use filters to include/exclude closed projects.

Lookup Lists and Reports

If you include a lookup list field in a list report, you will have the option to configure the visual display of the list value in the report. While you configure the visual treatment in the report definition, the actual colors and icons are configured in Admin/Setup/Lookup Lists. See Colors and Icons, and Configure Lookup Lists (in reports). Note that color/icons are not available for multi-select lists (it's not feasible to specify a color when choosing multiple items).