Data Administration › Datamart Stoplights

Datamart Stoplights

Stoplights allow you to flag projects that meet certain criteria. For example, you may want to use a red stoplight to flag all projects with actual hours that are greater than or equal to budgeted hours. You can store up to 15 stoplights in the NBI_PROJECT_CURRENT_FACTS (STOPLIGHT_1 through STOPLIGHT_15) table. The stoplights that are defined in CA Clarity PPM stock data are system stoplights.

Stoplight values are as follows:

• one (1) = green
• two (2) = yellow
• three (3) = red

Stoplight conditions are defined using ANSI SQL and include only columns that are provided in the NBI_PROJECT_CURRENT_FACTS table.

Note: See the Technical Reference Guide for more information.

Examples

• A project that is less than 90% complete:

  PCT_COMPLETE < 90
  

• More than 50 tasks remain open:

  PCT_COMPLETE < 90
  

• Actual hours are 95% of budgeted hours or greater:

  ACTUAL_HOURS > (0.95 * BUDGET_HOURS)
  

• Actual equipment costs exceed labor cost:

  COST_ACT_EQUIP > COST_ACT_LAB
  

More information:

Create Datamart Stoplights

Change Datamart Stoplights

Delete Datamart Stoplights