Change Orders by Participant Status Dashboard

The Change Orders by Participant Status dashboard displays the change order details by participant statuses.

The dashboard uses the Project Management - Change Management Real Time subject area.

The dashboard consists of Change Orders by Participant Status Report.

Key Insights

This dashboard answers the following business questions:

  • What's the current stage and status of the change order?

  • What are the various participant statuses for the change order?

Frequently Asked Questions

The following table lists the frequently asked questions about this dashboard.

FAQ

Answer

How do I find this dashboard?

Reports and Analytics - Shared Folders - Projects - Project Execution Sample Reports

Who uses this dashboard?

  • Project Manager

  • Change Order Owner

  • Change Order Participant

When do I use this dashboard?

When you want to review the details of pending change orders for:

  • Your projects or the change orders that you own.

  • Which you are a participant.

What can I do with this dashboard?

You can view the participant details by:

  • Project Name

  • Change Order Priority

What type of dashboard is this?

Oracle Transactional Business Intelligence

Details

The following table lists the prompts and filters used in the dashboard.

Column

Type

Rules

Project Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Priority

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Reason

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Owner

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

  • Default selection SQL:

    SELECT "Change Order Status"."Change Order Status Name" FROM "Project Management - Change Management Real Time" WHERE "Change Order Status"."Change Order Status Code" IN ('IN_PROGRESS', 'APPROVED') FETCH FIRST 65001 ROWS ONLY

Change Order Stage

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

  • Default selection SQL:

    SELECT "Change Order Stage"."Change Order Stage Name" FROM "Project Management - Change Management Real Time" WHERE "Change Order Stage"."Change Order Stage Code" IN ('APPROVAL','IMPACT_ANALYSIS','IMPLEMENTATION','REVIEW') FETCH FIRST 65001 ROWS ONLY

Participant

Dashboard prompt

  • Choice list

  • Select multiple values enabled

The following table lists the views in the Change Orders by Participant Status analysis.

View

Displayed Information

View Name

Change Orders By Participant Status

View Sections

None

Table Column and Measures

  1. Project Name

  2. Change Order Owner

  3. Change Order Priority

  4. Change Order Name

  5. Change Order Status

  6. Change Order Stage

  7. Participant Name

  8. Assessor Status

  9. Reviewer Status

  10. Approver Status

  11. Implementor Status