Beginning with the launch of UCPath later this year, campus financial managers and analysts will be able to drill-down into detailed payroll data from related KFS e-documents and reports. The new drill downs will appear as hyperlinks in KFS and will lead directly into detail data in UCPath Distribution of Payroll Expense (DOPE) reports.
This powerful new functionality was one of UCI’s most often requested reporting enhancements and teams from Accounting & Fiscal Services, the Budget Office, OIT, Business Intelligence and UCPath put three years of hard work into delivering a unified, comprehensive financial reporting solution that supports full drill-down and drill-across functionality for all sources of financial data. The achievement of this major milestone will also make it much easier to reconcile payroll data with KFS.
Many projects contributed to this success, starting in 2016 with the rebuild of the KFS labor ledger to UCPath specifications and the construction of the UCPath Data Store (ODS). Some, but not all, of the predecessor projects were:
KFS Organizational Hierarchy reorganization and synchronization with UCPath departments
Adoption of the Common Data Mart (CDM) model for unified reporting