Project Risk Register

The Project Risk Register report displays comprehensive information for each project risk. The risk register also provides the option to display items that are associated to the risk such as notes, action items, tasks, and other risks and issues. The report can  be grouped by project or not grouped.
ccppmop156
The Project Risk Register report displays comprehensive information for each project risk. The risk register also provides the option to display items that are associated to the risk such as notes, action items, tasks, and other risks and issues. The report can  be grouped by project or not grouped.
The following image displays the Project Risk Register report with details about each risk.
Image displaying the Project Risk Register report with details about each risk.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The project must have at least one risk for the project to display in the report.
  • The risk properties must have fields such as description, category, probability, impact, response type, resolution, target resolution, impact date, and originating ID completed for them to display data in the report. The risk name, risk ID, priority, status, and owner are required in
    Clarity PPM
    so they always display data.
Report Properties
The following values list the report properties
:
Name:
Project Risk Register
Resource ID:
CSK_PRJ_RiskRegister
Description:
Project Management (PMO Accelerator)
Folder:
CA PPM/Reports/Project Management/Project Risk Register
Path:
/ca_ppm/reports/project_management/CSK_PRJ_RiskRegister
Data Source:
CA PPM Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Project OBS Type
projectOBSTypeKey_1
Single-select
Query
Project OBS Type
projectOBSTypeKey_1
No
Project OBS Unit
projectOBSUnitKey_1
Single-select
Query
Project OBS Unit
projectOBSUnitKey_1
No
Project Type
projectTypeKey_1
Multiple-select
Query
Project Type
projectTypeKey_1
No
Project Manager
projectManagerKey_1
Multiple-select
Query
Project Manager
projectManagerKey_1
No
Sponsor
sponsorKey_1
Multiple-select
Query
Sponsor
sponsorKey_1
No
Project
projectKey_1
Multiple-select
Query
Project
projectKey_1
No
Project Status
projectStatusKey_1
Multiple-select
Query
Project Status
projectStatusKey_1
No
Work Status
workStatusKey_1
Multiple-select
Query
Work Status
workStatusKey_1
No
Risk Priority
riskPriorityKey_1
Multiple-select
Query
Risk Priority
riskPriorityKey_1
Yes
Low, Medium, and High
Risk Status
riskStatusKey_1
Multiple-select
Query
Risk Status
riskStatusKey_1
Yes
Open, Work in Progress, and Resolved
Sort By
sortRiskIssue
Single-select
List of Values
Sort By
sortRiskIssue
Yes
Created Date
Group By
groupProject
Single-select
List of Values
Group By
groupProject
Yes
Project
Show Notes?
showNotes
Boolean
Show Notes?
showNotes
No
Checked
Show Associated Action Items?
showAssociatedActionItems
Boolean
Show Associated Action Items?
showAssociatedActionItems
No
Checked
Shows Associated Tasks?
showAssociatedTasks
Boolean
Shows Associated Tasks?
showAssociatedTasks
No
Checked
Show Associated Risks and Issues?
showAssociatedRisksAndIssues
Boolean
Show Associated Risks and Issues?
showAssociatedRisksAndIssues
No
Checked
Include Programs?
includePrograms
Boolean
Include Programs?
includePrograms
No
Checked
Include Inactive Projects?
includeInactiveProjects
Boolean
Include Inactive Projects?
includeInactiveProjects
No
Unchecked
Database Schema
ppmDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity PPM
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
The following values list the lookup values:
Project Type:
Major Project, Application Change, Infrastructure Deployment
Work Status:
Requested, Active, On Hold, Cancelled, Complete
Risk Priority:
Low, Medium, High
Risk Status:
Open, Work in Progress, Resolved, Closed
Sort By:
ID, Created Date, Target Resolution Date
Group By:
No Grouping, Project
Parameter Explanations
The following list describes the parameters:
  • The Project OBS Type is a cascading parameter that determines which units are listed in the Project OBS Unit parameter. This parameter is not used to control directly which projects display in the report.
  • The Project OBS Unit parameter displays values that are based on the Project OBS Type selected. When you select an OBS unit in this parameter, the report displays the projects that are attached to the OBS unit and descendants of the unit you select.
  • The Project Type parameter is associated to the Idea and Project Type lookup in
    Clarity PPM
    . This lookup is configurable so lookup values might be added, modified, or deactivated.
  • The Work Status parameter is associated to the Work Status lookup in
    Clarity PPM
    . This lookup is configurable so lookup values might be added, modified, or deactivated.
  • The Show Notes parameter controls whether notes associated to risks are included in the report. If the parameter is checked, then notes display at the bottom of each risk section in the report. If the parameter is not checked, notes do not display.
  • The Show Associated Action Items parameter controls whether action items associated to risks are included in the report. If the parameter is checked, then action items display at the bottom of each risk section in the report. If the parameter is not checked, action items do not display.
  • The Show Associated Tasks parameter controls whether tasks that are associated to risks are included in the report. If the parameter is checked, then tasks display at the bottom of each risk section in the report. If the parameter is not checked, tasks do not display.
  • The Show Associated Risks and Issues parameter controls whether risks or issues that are associated to risks within the project are included in the report. If the parameter is checked, risks or issues display at the bottom of each risk section in the report. If the parameter is not checked, risks or issues do not display.
    Note:
    Risks and issues can be associated through the multi-select browse fields on the risk properties.
  • The report has an Include Programs parameter to include programs. If the parameter is checked, then program risks are included in the report. If the parameter is not checked, then program risks are not included in the report.
  • The report has a Sort By parameter that allows you to control how the report is sorted. The following sort options are available:
    ID
    . This option sorts the report by the risk ID in ascending order.
    Created Date.
    This option sorts the report by the create date in descending order.
    Target Resolution Date
    . This option sorts the report by the target resolution date in ascending order.
  • The report has a Group By parameter that allows you to control how the report is grouped. The following group options are available:
    No Grouping.
    This option does not group risks so you should select this value if you do not want to group the report. 
    Project
    . This option groups the risks by the project.
  • The project statuses are displayed based on the existing project statuses in the environment such as test, dev, or prod. For example, if there are projects with only Approved status, then only the Approved project status displays.
Report Fields and Calculations
The report displays the risk ID, created date, risk name, target resolution date, impact date, probability, response type, category, status, project name, owner, description, resolution, impact, calculated risk, priority, and originating ID. If the report is grouped by project, then the project name displays as a group heading instead of a column.
  • If the show notes parameter is checked, then the report displays the following columns for the risks that have notes: date entered, subject, description, and entered by. They are sorted by date entered, in descending order.
  • If the show associated action items parameter is checked, then the report displays the following columns for the risks that have action items associated to them: due date, subject, description, assigned to, and status. They are sorted by due date, in descending order.
  • If the show associated tasks parameter is checked, then the report displays the following columns for the risks that have tasks associated to them: task ID, task name, start, finish, % complete, and status. They are sorted by task ID, in ascending order. If there is no task ID, they are sorted by WBS sequence in ascending order.
  • If the show associated risks and issues parameter is checked, then the report displays the following columns for the risks that have other risks or issues associated to them: risk or issue ID, name, description, type (risk or issue), and status. They are sorted by risk or issue ID, in ascending order. Templates are excluded from the report.
This report contains the following calculations:
  • Calculated Risk.
    Calculated risk is a score that is based on risk probability and impact, which have the following levels: low (1), medium (2), and high (3).
    Formula:
    Probability * Impact
    Calculated risk background color is determined as follows:
    Red= The calculated risk is greater than the system-level risk threshold.
    White= The calculated risk is equal to or less than the system-level risk threshold.
The system-level risk threshold is defined in CA PPM Administration (Administration, Project Management, Risk Settings).
Database view and column:
odf_risk_v2.calculated_risk
odf_risk_v2.is_above_threshold
Report Security
Security is determined by project view rights.