Cognos & UCPath Division / Department Hierarchy Project

Change Overview Resources

Cognos & UCPath Division / Department Hierarchy Project

Launching June 9, 2025

Project Goal

  •  Update UCPath data to be an accurate reflection of the UC Davis organization (department roll up to sub-division to school / division).  Update Cognos to provide reporting based on UCPath without any customization.

Project Timeline

  • June 6: UCPath data will not be loaded on this date. Reports run on this date will display the same UCPath data as June 5.
  • June 9: Implementation of the new division/department hierarchy in UCPath.
  • June 9-20: Stabilization period. No changes to department name / status / realignment changes other than defects)
  • June 23: Department change requests will reopen for submission. 

Note: While changes will be visible in Cognos on Monday, June 9, downstream systems that consume UCPath data may reflect the changes at a later date based on their refresh schedule.

Project Benefits

  • Accurate department / sub-division / division / school roll up for both campus and health

  • Remove custom coding in UCDavis Cognos that groups data differently than how data is set up in UCPath 

  • Provide the ability in Cognos to filter by School / Division, Sub-Division and Department

  • Implement an updated process with appropriate oversight / approvals for future changes to the UCPath (department, sub-division, school/division data)

  • Identify an owner for each School / Division for future updates / oversight

  • Document the downstream impacts of realignments (changes in the department roll up)

What's Changing

  • Cognos will have an additional field for data selection. The current state includes Business Unit, School/Division, and Department. In the future state there will be a fourth selection. Future state will include Business Unit, School/Division, Sub-Division, and Department.

    Cognos Future State Selection Boxes showing Sub-Division.

Impacts

  • All requests for changes to department names, statuses, or realignments will freeze, effective Friday May 9.
  • UCPath Data will not be loaded Friday June 6
    • Reports run Friday June 6 will display the data as of Thursday June 5.
    • All reports will resume updating Monday June 9th.

Resources

FAQ

  • What impact will the change have on funding?
  • There are no changes to funding with this project. Funding is in UCPath at the position and department level. No changes are being made to departments or positions.
  • Is there any employee impact?
  • No, there is no impact to employees. There are no changes to position or job data. No changes to supervisor assignments or schedules.
  • Will there be any impact to payroll?
  • No, there are no impacts to payroll.