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 Area | Overview | Central-Level Access Data Model | Dept-Level Access Data Model | Last Updated Central-Level | Last updated Depart-Level |
|---|---|---|---|---|---|
Absence Management | view | view | view | 8/4/2018 | 8/4/2018 |
| Benefits Data about employees and their dependent’s benefits elections as well as data about plan types and deductions. | view | view | view | 8/4/2018 | 8/4/2018 |
| Budget Ledger Data about employee budget including data about job, position and funding. | - | view | view | 2/23/2019 | 2/23/2019 |
| Identity Management Data that contains UC identifiers that enable access to external systems throughout UC and matches to UCLA’s UID system. | - | view | view | 8/4/2018 | 8/4/2018 |
| Job Data about an employee’s position(s) with the university as well as attributes that describe the job itself. | view | view | view | 8/4/2018 | 8/4/2018 |
| Job Profile Management Data to track Person’s honors and awards, degrees, licenses and certifications. | - | view | view | 2/23/2019 | 2/23/2019 |
| Labor Ledger Data about payroll transactions at an employee level, including associated accounting unit, earnings and deductions. | - | view | view | 8/4/2018 | 8/4/2018 |
| Lookup Subject Area Lookup Tables | - | view | view | 2/23/2019 | 2/23/2019 |
| Payroll and Commitment Accounting Data about the pay process from a point prior to funding to actuals. | view | view | view | 2/23/2019 | 2/23/2019 |
| Person Data that are unique to a person such as employee ID, name, citizenship attributes, etc. | view | view | view | 2/23/2019 | 2/23/2019 |
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.