Missing Time

The Missing Time report displays resource available hours, timesheet hours entered, and timesheet hours missing by resource and time period. The report can be grouped by resource manager or OBS level. The report also has an option to calculate missing time based on timesheet status or resource availability. The charts include a summary of timesheets across the periods included in the report. The Timesheet Count Summary displays the number of timesheets that are completed, partially completed, or missing for the time periods. The Timesheet Hours Summary displays the number of hours grouped by resource availability, timesheets entered, timesheets missing, and overage.
ccppmop143
The Missing Time report displays resource available hours, timesheet hours entered, and timesheet hours missing by resource and time period. The report can be grouped by resource manager or OBS level. The report also has an option to calculate missing time based on timesheet status or resource availability. The charts include a summary of timesheets across the periods included in the report. The Timesheet Count Summary displays the number of timesheets that are completed, partially completed, or missing for the time periods. The Timesheet Hours Summary displays the number of hours grouped by resource availability, timesheets entered, timesheets missing, and overage.
The following image displays the Missing Time report with Timesheet Count Summary and Timesheet Hours Summary.
Image displaying the Missing Time report with Timesheet Count Summary and Timesheet Hours Summary.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • Run the Load Data Warehouse and Load Data Warehouse Access Rights jobs. If the data warehouse is not populated, the report displays a message that there are no matching records and most of the report parameters show no options.
  • The report displays resources that are set up to enter time in
    Clarity Project and Portfolio Management (PPM)
    . If the resource does not have a timesheet in 
    Clarity Project and Portfolio Management (PPM)
    for the time period and timesheet status selected when running the report, then the resource displays in the report with a timesheet status of Open with zero hours. You do not need to have at least one timesheet for the resource to display in the report.
  • Configure the resource for time entry. The resource is considered set up for time entry if the following conditions are met on the resource: the Open for Time entry field is checked; Track Mode set to
    PPM
    (formerly
    Clarity
    ) or
    Other
    ; date of hire is blank, before the time period, or within the time period; and date of termination is blank, after the time period, or within the time period. If the resource is not considered open for time entry based on the above criteria, but the resource does have a timesheet for the period in question, the resource will appear on the report.
  • Create time reporting periods (
    Administration/Project Management-Time Reporting Periods
    ). The time reporting period must have a status of
    open
    to enter time in the period.
  • The investment must have the Open for Time entry field checked and the Track Mode set to PPM to enter time against the investment. If the investment is a project, then the Open for Time entry field on the task must also be checked to enter time against the task.
  • The investment must have at least one resource that is assigned to a task for the resource to enter time against the investment and for it to display in the report. For projects, the resource must be assigned to a task in the Gantt unless the project has an effort task with resources automatically assigned. For investments other than the project, resources added to the team are automatically assigned to an effort task for the investment. 
    Note:
    Effort task is a task with the Task ID of "~rmw".
In a timesheet, resources can also assign themselves to tasks if they are team members on the project and the Prevent Unassigned Timesheet Tasks field is unchecked on the project. This field is in the time and staff section of the settings properties on the project. They can also create unplanned tasks in a timesheet if they are team members on the project and if they have the appropriate permissions (Project – Edit Project Plan).
  • The resource available hours are calculated based on the time slice with the name DAILYRESOURCEAVAILCURVE (
    Administration/Data Administration-Time Slices
    ). This time slice is not a Data Warehouse request, therefore, it must be configured to cover the dates that are displayed in this report or the report does not display data for those dates.
Report Properties
The following values list the report properties:
Name:
Missing Time
Resource ID:
CSK_TME_MissingTime
Description:
Time Management (PMO Accelerator)
Folder:
CA PPM/Reports/Time Management/Missing Time
Path:
/ca_ppm/reports/time_management/CSK_TME_MissingTime
Data Source:
CA PPM Data Warehouse 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
Resource OBS Type
resourceOBSTypeKey_1
Single-select
Query
Resource OBS Type
resourceOBSTypeKey_1
No
Resource OBS Unit
resourceOBSUnitKey_1
Single-select
Query
Resource OBS Unit
resourceOBSUnitKey_1
No
Resource Manager
resourceManagerKey_1
Multiple-select
Query
Resource Manager
resourceManagerKey_1
No
Resource Role
roleKey_1
Multiple-select
Query
Resource Role
roleKey_1
No
Resource
resourceKey_1
Multiple-select
Query
Resource
resourceKey_1
No
Employment Type
employmentTypeKey_1
Multiple-select
Query
Employment Type
employmentTypeKey_1
No
Time Period
timePeriod
Multiple-select
Query
Time Period
timePeriod
Yes
Timesheet Status
timesheetStatusKey_1
Multiple-select
Query
Timesheet Status
timesheetStatusKey_1
Yes
Open, Submitted, Returned, Approved, and Posted
Group By
groupResManagerOBS
Single-select
List of Values
Group By
groupResManagerOBS
Yes
Resource Manager
Calculate Missing Time Based on Timesheet Status?
calculateMissingTime
Boolean
Calculate Missing Time Based on Timesheet Status?
calculateMissingTime
No
Unchecked
Include Inactive Resources?
includeInactiveResources
Boolean
Include Inactive Resources?
includeInactiveResources
No
Unchecked
Show Timesheet Summary Graph?
showTimesheetSummaryGraph
Boolean
Show Timesheet Summary Graph?
showTimesheetSummaryGraph
No
Checked
Database Schema
ppmDBSchema
dwhDBSchema
Hidden
Database:
CA PPM
Data Warehouse
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Passed through
Clarity Project and Portfolio Management (PPM)
Database Vendor
dwhDBVendor
Hidden
Database:
Data Warehouse
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Database Link
dwhDBLink
Hidden
Data Warehouse database Link to CA PPM database
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Database Username
ppmDBName
Hidden
MS SQL Server only
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:
Employment Type:
Contractor, Employee
Time Period:
Current Time Period, Next Time Period, Previous Time Period, List of Time Periods
Timesheet Status:
Open, Submitted, Returned, Approved, Posted, Adjusted
Group By:
Resource Manager, OBS Level 1-10
Parameter Explanations
The following list describes the parameters:
  • The Resource OBS Type is a cascading parameter that determines which units are listed in the Resource OBS Unit parameter. This parameter does not directly control which resources display in the report.
  • The Resource OBS Unit parameter displays values based on the Resource OBS Type selected. When you select an OBS unit in this parameter, the report displays the resources that are attached to the OBS unit and descendants of the unit you select.
  • The Time Period parameter allows you to determine which time periods display on the report. Select at least one time period when running the report.
  • The Timesheet Status parameter works with the time period parameter. The report only displays time periods with the timesheet status you select when running the report. One of the values in the timesheet status parameter is Adjusted and this status requires some additional explanation. An adjusted timesheet is a timesheet that has been posted in
    Clarity Project and Portfolio Management (PPM)
    , but then changes are made to the timesheet and it is reposted. As a rule, it does not make sense to display adjusted timesheets in reports because these timesheets have been replaced with more recently posted timesheets. While the status of Adjusted is available as an option to allow visibility into adjusted timesheets, it should not normally be selected when running the report.
  • The Calculate Missing Time Based on Timesheet Status parameter determines how missing time is calculated in the report. This allows you to determine if you want to calculate missing time based on timesheet status or resource time entered being less than availability.
When this parameter is checked, the timesheet statuses that are selected in the timesheet status parameter determine missing time and the available hours are not used to determine missing timesheets. For example, if you select timesheet statuses of open and submitted, then only timesheets with a status of open and submitted are considered missing time in the report. Timesheets with a status of returned, approved, posted or adjusted are not considered missing.
When this parameter is not checked, the report compares the hours that are entered on a timesheet to the resource available hours to determine missing time. For example, if a resource enters 32 hours on a timesheet, but is available for 40 hours in the time period, then 8 hours are considered missing time.
  • The Show Timesheet Summary Graph parameter controls whether the Timesheet Count Summary and Timesheet Hours Summary charts display on the report. If the parameter is checked, the charts display on the top of the first page of the report. If the parameter is not checked, the charts do not display.
  • The report has a Group By parameter that allows you to control how the report is grouped. The following group options are available:
    Resource Manager
    –This option groups the report by resource manager. 
    OBS Level 1-10
    –This option groups the report by OBS level and requires that you also select a unit in the resource OBS parameter. The resource OBS parameter and grouping by an OBS level work with one another. The resource OBS parameter determines which OBS you group by when you select a group by level. You can group by any OBS level from 1 to 10, which is the maximum number of levels for an OBS supported in CA PPM. OBS level 1 is the top level in the hierarchy and OBS level 10 is the bottom level in the hierarchy. When you group by an OBS level, the resources that are attached to OBS units at the level you select and any units below the level you select are rolled up to the group by level of the report.
    If you group by an OBS level that is lower in the hierarchy, then the report groups the resources by this level (for example, OBS Level 4). If resources are associated to units above level 4 (for example, resources are attached to levels 2 and 3), then the resources that are associated to units higher in the hierarchy display in the report in an Undefined grouping. The Undefined grouping indicates that no OBS unit is defined for the resource at the level by which you are grouping.
    If you group by an OBS level but you do not select a unit in the resource OBS parameter, then the report returns results; however, it will not group by an OBS level because it relies on the resource OBS parameter to determine which OBS to use for grouping. 
Report Fields and Calculations
The report includes only resources with missing time and displays the following columns: resource name, employment type, primary role, available hours, entered hours, missing hours, timesheet status, and email address. The report can  be grouped by resource manager or OBS level. Resources must have Open for Time Entry checked and Track Mode set to Clarity or Other to be included in the report. Resources must be employed during the time period that is selected in the parameter to be included in the report, which means that resources must have a hire date less than the report time period finish date or no hire date. Moreover, resources must also have a date of termination greater than the report time period start date or no date of termination. Resources only are included; roles are excluded.
The report has two charts: Timesheet Count Summary and Timesheet Hours Summary. The charts include all resources that meet the parameter criteria, not only resources with missing time. This gives you visibility into all of the timesheets for the periods selected when running the report. Therefore, the charts do not tie to the numbers represented in the body of the report. The amounts in the charts are summary numbers for all resources who should be entering time in the time periods of the report.
The Timesheet Count Summary chart displays timesheet counts for the categories of Completed, Partial, and Missing. A completed timesheet is a timesheet where the hours entered on the timesheet are greater than or equal to the resource available hours for the time period. A partial timesheet is a timesheet where the hours entered on the timesheet are less than the resource available hours for the time period. A missing timesheet means that the timesheet has zero hours entered for the time period or a timesheet has not been created for the time period. If a resource meets the following criteria and the resource does not have a timesheet entered for the time period, then the resource is included in the report as having missing time: open for time entry, track mode of
Clarity Project and Portfolio Management (PPM)
, either no date of hire or a date of hire less than the period end date, and either no termination date or a termination date greater than the period start date.
The Timesheet Hours Summary chart displays hours grouped by the categories of Available, Entered, Missing, and Overage. Available hours are the sum of available hours for the resources that meet the parameter criteria. Entered hours are the sum of the hours entered on the timesheets. Missing hours is the sum of available hours per time period minus hours entered on each timesheet. Overage hours are the sum of hours entered on each timesheet that are greater than the available hours per time period.
Report Security
Security is determined by resource view rights.