Project Issue Register

The Project Issue Register report displays comprehensive information for each project issue. The issue register also provides the option to display items that are associated to the issue such as notes, action items, and tasks. The report can  be grouped by project or not grouped.
ccppmop144
The Project Issue Register report displays comprehensive information for each project issue. The issue register also provides the option to display items that are associated to the issue such as notes, action items, and tasks. The report can  be grouped by project or not grouped.
The following image displays the Project Issue Register with details about the issues.
Image displaying the Project Issue Register with details about the issues.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The project must have at least one issue for the project to display in the report.
  • The issue properties must have fields such as description, category, resolution, target resolution, impact date, and originating ID completed for them to display data in the report. The issue name, issue ID, priority, status, and owner are required in
    Clarity Project and Portfolio Management (PPM)
    so they always display data.
Report Properties
The following values list the report properties.
Name:
Project Issue Register
Resource ID:
CSK_PRJ_IssueRegister
Description:
Project Management (PMO Accelerator)
Folder:
CA PPM/Reports/Project Management/Project Issue Register
Path:
/ca_ppm/reports/project_management/CSK_PRJ_IssueRegister
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
Business Owner
businessOwnerKey_1
Multiple-select
Query
Business Owner
businessOwnerKey_1
No
Project
projectKey_1
Multiple-select
Query
Project
projectKey_1
No
Project Status
projectStatusKey_1
Multiple-select
Query
Project Status
projectStatusKey_1
Yes
Approved, Cancelled, On Hold, Unapproved
Work Status
workStatusKey_1
Multiple-select
Query
Work Status
workStatusKey_1
No
Issue Priority
issuePriorityKey_1
Multiple-select
Query
Issue Priority
issuePriorityKey_1
Yes
Low, Medium, and High
Issue Status
issueStatusKey_1
Multiple-select
Query
Issue Status
issueStatusKey_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
Show Associated Tasks?
showAssociatedTasks
Boolean
Show Associated Tasks?
showAssociatedTasks
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 Project and Portfolio Management (PPM)
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Parameter Lookup Values
The following values list the lookup values.
Project Type:
Major Project, Application Change, Infrastructure Deployment
Project Status:
Approved, Cancelled, On Hold, Unapproved
Work Status:
Requested, Active, On Hold, Cancelled, Complete
Issue Priority:
Low, Medium, High
Issue 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 selected Project OBS Type. 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 Project and Portfolio Management (PPM)
    . This lookup is configurable so lookup values can be added, modified, or deactivated.
  • The Work Status parameter is associated to the Work Status lookup in
    Clarity Project and Portfolio Management (PPM)
    . This lookup is configurable so lookup values can be added, modified, or deactivated.
  • The Show Notes parameter controls whether notes that are associated to issues are included in the report. If the parameter is checked, then notes display at the bottom of each issue 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 issues are included in the report. If the parameter is checked, then action items display at the bottom of each issue section in the report. If the parameter is not checked, action items do not display.
  • The Show Associated Tasks parameter controls whether tasks associated to issues are included in the report. If the parameter is checked, then tasks display at the bottom of each issue section in the report. If the parameter is not checked, tasks do not display.
  • The report has an Include Programs parameter to include programs. If the parameter is checked, then program issues are included in the report. If the parameter is not checked, then program issues 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 issue 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 issues, so select this value if you do not want to group the report. 
    Project.
    This option groups the issues by the project.
Report Fields and Calculations
The report displays the issue ID, created date, issue name, target resolution date, impact date, category, status, project name, owner, description, resolution, 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 issues 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 issues 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 issues 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. Templates are excluded from the report.
Report Security
Security is determined by project view rights.