1. Home
  2. UCPath
  3. UCLA ODS Subject Area Data Models

UCLA ODS Subject Area Data Models

With UCPath, HR and payroll concepts are grouped into categories, called subject areas, that gather related data together based on usage and business process. The subject areas being introduced with UCPath are:

Subject AreaOverviewCentral-Level Access
Data Model		Dept-Level Access
Data Model		Last Updated
Central-Level		Last updated
Depart-Level

Absence Management
Data about any absence from an employee’s job.

viewviewview11/27/201711/27/2017
Benefits
Data about employees and their dependent’s benefits elections as well as data about plan types and deductions.		viewviewview11/27/201711/27/2017
Budget Ledger
Data about employee budget including data about job, position and funding.		-viewview11/27/201711/27/2017
Identity Management
Data that contains UC identifiers that enable access to external systems throughout UC and matches to UCLA’s UID system.		-viewview11/27/201711/27/2017
Job
Data about an employee’s position(s) with the university as well as attributes that describe the job itself.		viewviewview11/27/201711/27/2017
Job Profile Management
Data to track Person’s honors and awards, degrees, licenses and certifications.		-viewview11/27/201711/27/2017
Labor Ledger
Data about payroll transactions at an employee level, including associated accounting unit, earnings and deductions.		-viewview11/27/201711/27/2017
Lookup Subject Area
Lookup Tables		-viewview11/27/201711/27/2017
Payroll and Commitment Accounting
Data about the pay process from a point prior to funding to actuals.		viewviewview11/27/201711/27/2017
Person
Data that are unique to a person such as employee ID, name, citizenship attributes, etc.		viewviewview11/27/201711/27/2017

Data Dictionary and Data Mapping

UCLA ODS Data Dictionary
Last updated: 11/27/2017

UCLA ODS Data Mapping (all subject areas)
Last updated: 10/24/2016

Warning: In an effort to provide the most updated information, the ODS models are subject to change as the UC-wide model changes. Please check back frequently for updates.

For questions about UCLA ODS data models, contact support@qdb.ucla.edu for more information.