Overview
This section has higher-level content on multiple dashboards done in a single recording. Navigate to the individual dashboards in the sections below for detailed-level content.
Cal Assessment Network (CAN) HR and Payroll Dashboards 6.5.20
- You want to know how Cal Answers UCPath reporting can help you get the information you need to do your work
- You want a demonstration of the following dashboards
- You want to know more about the work that was done to make UCPath data accessible through Cal Answers
PI Portfolio - We will show enhancements in PI Portfolio that allow users to create accurate projections of all compensation expenses including CBR, UCRP Supplemental Interest Assessment, and GAEL.
Human Resources Reporting - We will show HR reports sourced from UCPath.
HR Dashboards Walk Through 7.16.20
This walk through covers the following dashboards:
Staff Compensation Summary
Workforce Detail
Employee Change Tracking
Position Management
HR Workforce Detail
Employee Change Tracking
This report is for UCPath data from March 2019 going forward.
Personnel Changes
This tab identifies active and inactive employees who entered and left your organization within the date range and indicates if they are hires, terminations, and/or transfers. This tab displays results only when one of these changes has happened. Run the Job Data by Date Range report tab in the Workforce Detail Dashboard to see full details for individual employees and the histories of their records.
Employee Job Changes
This tab identifies active employees who had a change in employee class, job code, supervisor, pay rate, employee status, and/or position number within the date range. This tab displays results only when one of these changes has happened, and shows the final-state change for the effective date. Run the Job Data by Date Range report tab in the Workforce Detail Dashboard to see final-state and non-final-state changes broken out by effective sequence.
- Employee Change Tracking Webinar 3.18.2020: Overview of the Employee Change Tracking dashboard
-
Employee Change Tracking job aid: Overview of the Employee Change Tracking dashboard and key call-outs
Hours Towards Eligibility
This report is for UCPath data for a 12-month timeframe back from today.
Career Status Eligibility
This tab identifies limited employees who are progressing towards attaining career status or have recently converted to career status within the past 90 days.
Full Benefits Eligibility
This tab identifies all employees who are progressing towards attaining full benefits or have recently attained full benefits within the past 90 days.
- Hours Towards Eligibility Webinar 10.22.2020 (will be posted): Overview of the Hours Towards Eligibility dashboard
- Hours Towards Eligibility Webinar 10.27.2020 (will be posted): Overview of the Hours Towards Eligibility dashboard
-
Hours Towards Eligibility job aid: Overview of the Hours Towards Eligibility dashboard and key call-outs
Legacy Campus Position Management
Due to conversion to UCPath, data in this report is frozen as of March 8, 2019.
Position Funding
This tab displays the list of positions in your organization and their chartstring distribution-level information as of the date in the “As of Date” filter field. That means that it pulls from the effective row for that date (the one with the most recent effective date that is equal to or less than the date indicated).
Position Exception
This tab displays position-level and associated job-level data about current positions that are flagged as having one or more "exceptions." Exceptions include: Reports To Mismatch, FTE Mismatch, Position Override in Use, Position Overallocated, Appt End Dt Passed, Dept ID Mismatch, Job Code Mismatch, and Location Code Mismatch.
Position Roster
This tab shows information about the positions and their employees in your organization. It displays position-level as well as associated job-level data, such as the incumbent employee, drawing only on current rows.
Legacy Workforce Detail Dashboard
Due to conversion to UCPath, data in this report is frozen as of March 8, 2019.
Job Data
This tab displays job-level information about Employees, Contingent Workers, and Persons of Interest as of the date in the “As of Date” filter field. That means that it pulls from the effective row for that date (the one with the most recent effective date that is equal to or less than the date indicated) for each record in HCM.
Job Data by Date Range
This tab displays the same information as above, but allows the user to search for HCM rows that fall within a user-entered date range. The date range can refer to the effective dates of the rows,the date on which the rows were entered, or the appointment end date associated with the rows, depending on which option the user selects. The user can also select whether they want to include only current records (records that are still effective as of the date the report is run) or show all records, including historical and future records.
Job Earnings Distribution
This tab displays some job-level data as well as distribution-level data for employees as of the date in the “As of Date” filter field. That means that it pulls from the effective HCM row for that date (the one with the most recent effective date that is equal to or less than the date indicated) for each record in HCM. This report shows each chartstring distribution and its associated percentage that will be used for an employee’s payroll activity.
Job Earnings Distribution by Date Range
This tab displays the same information as above, but allows the user to search for HCM rows that fall within a user-entered date range. The date range can refer to the effective dates of the rows, the date on which the rows were entered, or the appointment end date associated with the rows, depending on which option the user selects. The user can also select whether they want to include only current records (records that are still effective as of the date the report is run), include only records with salary changes, or include all records.
Termination and Org Change
This tab displays the Employees who had a change from one Org Node to another, or were terminated from University employment. You must select a range of Effective Dates to run this report. Additional filters are available to look up individuals by various criteria. The report includes current information as well as the Prior Org Node, Prior Supervisor, Prior Job Code and Prior Job Description.
- Legacy HR Workforce Detail job aid: Overview of the Legacy Workforce Detail dashboards and key call-outs about the reports.
Position Management
This report is for UCPath data from March 2019 going forward.
Position Roster
This tab shows your organization's roster of filled and vacant positions as well as information about position incumbents to help you manage your personnel and determine your remaining capacity to hire.
Position Funding
This tab shows your organization's roster of filled and vacant positions as well the associated funding for each of those positions to help you manage the chartstrings payroll is charged to. Filled and vacant positions that have no funding associated with them will not show in this tab.
Position Location
This tab shows the location associated with each position to help you ensure current data is reported to unions and manage personnel by physical location.
Exceptions
This tab shows the actions you need to take for the position in UCPath, as indicated by the various exception flags.
- Position Management Webinar 12.5.2019: Overview of the Position Management dashboard.
- Position Management Webinar 12.12.2019: Overview of the Position Management dashboard.
- Position Management job aid: Overview of the UCPath Position Management dashboard and key call-outs.
Workforce Detail Dashboard
Job Data As of Date
This tab displays job and position level data about Employees and Contingent Workers as of the date in the “As of Date” filter field. That means that it pulls from the effective row for that date.
Job Data by Date Range
This tab displays job and position level data about Employees and Contingent Workers, but allows the user to search for rows that fall within a user-entered date range. The date range can refer to the effective dates of the rows, the dates on which the rows were entered, the expected end dates associated with the rows, the visa end dates associated with the rows, or the probation end dates associated with the rows, depending on which option the user selects. The user can also select whether they want to include only current records (records that are still effective as of the date the report is run), show only rows showing jobs that will be automatically terminated on their end date, show only rows with salary changes, or show all records, including historical and future records.
Compensation Data As of Date
This tab displays information about the components of employee pay. It shows information from the position and job level, and associates it with the various compensation types and rates that make up the salaries of employees as of the date in the “As of Date” filter field. That means that it pulls from the effective row for that date.
Compensation Data by Date Range
This tab displays information about the components of employee pay. It shows information from the position and job level, and associates it with the various compensation types and rates that make up the salaries of employees. It allows the user to search for rows that fall within a user-entered date range. The date range can refer to the effective dates of the rows, the dates on which the rows were entered, the expected end dates associated with the rows, the visa end dates associated with the rows, or the probation end dates associated with the rows, depending on which option the user selects. The user can also select whether they want to include only current records (records that are still effective as of the date the report is run), show only rows showing jobs that will be automatically terminated on their end date, show only rows with salary changes, or show all records, including historical and future records.
Job Funding Information As of Date
This tab displays job-level data, distribution-level data, and additional pay for employees as of the date in the “As of Date” filter field. This means it pulls from the effective UCPath or legacy HCM row for that date (the one with the most recent effective date that is equal to or less than the date indicated). This report shows each chartstring distribution and its associated distribution percentage used for an employee’s payroll activity.
Job Funding Information by Date Range
This tab displays the same information as above, but allows the user to search for UCPath and legacy HCM rows that fall within a user-entered date range. The date range can refer to various dates, depending on which option the user selects. The user can also select what type of records to include.
- HR Workforce Detail Webinar 8.15.2019: Overview of the Workforce Detail Dashboard's Job Data, Compensation Data, and Job Funding Information tabs.
- HR Workforce Detail Webinar 8.8.2019: Overview of the Workforce Detail Dashboard's Job Data, Compensation Data, and Job Funding Information tabs.
- HR Workforce Detail Job Data Webinar 5.13.2019: Overview of changes for the UCPath Workforce Detail Dashboard's Job Data tabs.
- HR Workforce Detail job aid: (updated 7.25.19) Overview of the UCPath Workforce Detail Dashboard and key call-outs.
HR Workforce Summary
Staff Compensation Summary
Select Staff
This tab shows the average salary and average compa-ratio for job codes across campus based on the methodology used by the Central HR Compensation Team for its compensation recommendations.
- Staff Compensation Summary Webinar 6.18.20: Overview of the Staff Compensation Summary dashboard
- Staff Compensation Summary job aid: Overview of the Staff Compensation Summary dashboard
- HR Compensation Summary job aid: Overview of the legacy Compensation Summary dashboard and key call-outs about the reports. This dashboard is no longer available.
Employee Crosswalk
Employee Crosswalk
Use this lookup to see the UCPath Employee ID and Legacy Employee ID for a particular or list of employees. Employees will have legacy employee IDs if they were active in legacy HCM on or before 1/1/2019.
- Employee Crosswalk job aid: Overview of Employee Crosswalk dashboard.
Contact
-
If you have technical questions about using Cal Answers, please contact the Cal Answers Help Desk at 664-9000 ( option 1, then option 2) or calanswers-help@berkeley.edu
- Please contact the HR Help Desk with questions about HR reporting at 664-9000 (option 3)or submit a ticket through the HR/APS Service Request Catalog using “Ask an HR Question or Report an HR Problem” to submit your question.