Skip to content

Production Reports

Produced from Corporate Personnel System and Corporate Personnel Data Warehouse effective 09/06/2018

Here is an Excel version of this list.

Key:
  Environment:  MVS = produced automatically from mainframe  
                     CSG = report run by customers from Corporate Systems Gateway
  Document Direct: a web-based report repository owned by Human Resources and Benefits
Job ID Report Name Requesting         Dept Purpose of Report No of Reports/Files Produced from this job System Production/Recurring/ One-Time Frequency Environment In Document Direct Comments
                     
DEPRPT1 Report and Labels for Overage Dependents HR&B-Program Planning & Design Benefits analysis and employee notification 1 report, 5 sets of labels Corporate Personnel/Dependent Data system Production Monthly MVS Yes  
DEPRPT2 Counts of Emps and Deps by Location, Coverage Plan, Dep Relationship HR&B-Program Planning & Design Benefits analysis 2 reports Corporate Personnel/Dependent Data system Production Monthly MVS Yes  
DEPRPT3 Average Number of Dependents by Location, Health Plan HR&B-Program Planning & Design Benefits analysis 2 reports Corporate Personnel/Dependent Data system Production Monthly MVS Yes  
DEPRPT4 Average Number of Children by Location by Personnel Program HR&B-Program Planning & Design Benefits analysis 1 report Corporate Personnel/Dependent Data system Production Monthly MVS Yes  
DEPRPT5 Listing of all Dependents Enrolled as Wards HR&B-Program Planning & Design Benefits analysis 1 report Corporate Personnel/Dependent Data system Production Monthly MVS Yes  
DEPRPT6 Listing and labels for all Spouses and Adult Dependent Relatives who will be turning 65, or employees who are turning 65 HR&B-Program Planning & Design Benefits analysis and employee notification 1 report, 1 set of labels Corporate Personnel/Dependent Data system Production Quarterly MVS Yes  
DEPRPT8 Medical coverage and premium information for domestic partners, adult dependent relatives, HR&B-Program Planning & Design Benefits analysis 3 reports, 3 Excel spreadsheets Corporate Personnel/Dependent Data system Production Quarterly MVS Yes  
FCPAA2 EE06 - Supplement Rpts. Academic Advancement, HR Client Relations & Diversity Provides required data for EEOC 3 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPAA3 Invalid Sex, Ethnicity, and Citizenship Codes Academic Advancement, HR Client Relations & Diversity Error report to be used to request corrections to Payroll  1 report Corporate Personnel System Production Monthly MVS No  
FCPAA5 Profile of Professorial Series & Equiv. Ranks Academic Advancement Faculty/Academic Profile 1 report Corporate Personnel System Production Annual MVS No  
FCPAA6 Age Distribution within Prof. Series, Equiv., SOE/FTE Academic Advancement Faculty analysis 6 reports Corporate Personnel System Production Annual MVS No  
FCPAA7 Undupl. Cnt. of Handicapped Employees HR&B Sr Mgmt Compensation, Policy, and Recruitment Workforce analysis 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPAA10 New Appointees - Disc., Rank, Salary, Sex, Ethnicity Academic Advancement Faculty analysis 4 reports Corporate Personnel System Production Annual MVS No  
FCPAA11 New Appointees - Origins of Recruitment Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAA12 New Appointees - Disc., Rank, Yr. of Doctorate, Sex, Ethnicity Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAA13 Faculty Promoted - Disc., Sex, Ethnicity Academic Advancement Faculty analysis 3 reports Corporate Personnel System Production Annual MVS No  
FCPAA16 Counts of MSP & SMG Emps. by Sal. Range, Ethnicity & Gender HR Client Relations & Diversity Workforce diversity analysis 1 report Corporate Personnel System Production Semi-annual MVS Yes  
FCPAA17 DOE Lab Headcount by Gender and Ethnicity HR Client Relations & Diversity Workforce diversity analysis 1 report Corporate Personnel System Production Semi-annual MVS Yes  
FCPAA19 Composition of UC Workforce  HR Client Relations & Diversity Affirmative Action Plan 1 report, 6 Excel spreadsheets Corporate Personnel System Production Semi-annual MVS Yes  
FCPAP1 Headcnt. & FTE - Acad - By CTO Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPAP2 Headcnt. & FTE - Acad - by Health Sci./General Campus Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPAP3 FTE, HDCT, Ave. Salary - General Campus/Health Sci. Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPAP4 Appointments, Promotions/Separations - Sex, FTE Academic Advancement Faculty analysis 4 reports Corporate Personnel System Production Annual MVS No  
FCPAP5 Full/Part Time - HDCT, FTE, General Campus/Health Sci Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPAP6 Ave. Age within Faculty - General Campus/Health Sci. Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAP9 Age Distribution - Professorial Series Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAP10 Origins of New Appointees - General Campus Academic Advancement Faculty analysis 3 reports Corporate Personnel System Production Annual MVS No  
FCPAP11 Destination of Voluntary Separations - General Campus Academic Advancement Faculty analysis 3 reports Corporate Personnel System Production Annual MVS No  
FCPAP12 Reasons for Separations Academic Advancement Faculty analysis 6 reports Corporate Personnel System Production Annual MVS No  
FCPAP13 Profile of Prof. Series - Disc., Sex, FTE, Salary, Age Academic Advancement Faculty analysis 6 reports Corporate Personnel System Production Semi-annual MVS No  
FCPAP16 Comparison of Above Scale with Tot. Population Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAP17 Above Scale Salaries by Rank Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAP18 New Appointments Academic Advancement Faculty analysis 6 reports Corporate Personnel System Production Annual MVS No  
FCPAP19 Faculty Appointed since July 1 Academic Advancement Faculty analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPAP21 Produce  faculty salary survey report  used for US News & World Report survey Academic Planning and Analysis US News & World Report survey 12 reports Corporate Personnel System Production Annual MVS No  
FCPAP22 Produce faculty instructional activity reports Academic Planning and Analysis Faculty FTE reports 15 reports, 15 Excel spreadsheets Corporate Personnel System Production Semi-annual MVS No  
FCPBAP1 Actual Salary Expenditures - by Fund & LOC Budget Office Budget analysis 2 reports Corporate Personnel System Production Annual MVS No  
FCPBAP4 Actual I & R Salary Expenditures Budget Office Budget analysis 1 report, 1 Excel spreadsheet Corporate Personnel System Production Annual MVS No  
FCPCDTL Chronicle detail file - Replaced by Annual Wage detail data in DSS Payroll Coordination, Audit Pre-publication analysis of UC compensation 1 extract file Corporate Personnel System Recurring On request MVS No  
FCPCER1 Academic Compensation Budget Request - FTE/Salary Academic Advancement Budget analysis 1 report Corporate Personnel System Production 5 times per year MVS Yes  
FCPCER2 Academic Compensation Budget Request - General Campus Academic Advancement Budget analysis 1 report Corporate Personnel System Production 5 times per year MVS Yes  
FCPCER3 Campus Linkage Code Tables (on request) HR Compensation Policy Compensation and labor analysis 3 reports Corporate Personnel System Production On request MVS Yes  
FCPCER4 Incumbents in Frozen Titles HR Compensation Policy Compensation analysis 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPCER5 Incumbents in Abolished Titles HR Compensation Policy Compensation analysis 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPCGX1 HDCT by LOC, Citzenship Status & Fund Source Laboratory Administration Lab staffing analysis 1 report Corporate Personnel System Production Quarterly MVS No  
FCPCSUM Chronicle summary file - Replaced by Annual Wage database available to public Payroll Coordination, Strategic Communications Public disclosure of compensation 1 extract file, 1 to 11 pdf files, 1 report Corporate Personnel System Recurring On request MVS No  
FCPEPRSM Extract for Mercer ePRISM database HR Compensation  Policy and Programs Compensation analysis and comparisons 1 extract file Corporate Personnel System Production Monthly MVS No  
FCPER1 Stat. Sum. - Admin., Acad., & Staff - FTE & Headcnt. Multiple departments, Regents Used for various statistical summary reports,publication on Statistical Summary website, and for the annual Statistical Summary of Students and Staff 1 Excel spreadsheet, 7 reports, 26 pdf files Corporate Personnel System Production Semi-annual MVS No  
FCPER2 Stat. Sum. - Admin., Acad., & Staff - Sex & Ethnicity Multiple departments, Regents Used for various statistical summary reports,publication on Statistical Summary website, and for the annual Statistical Summary of Students and Staff 2 reports, 1 Excel spreadsheet Corporate Personnel System Production Monthly MVS No  
FCPER3 AAUP Faculty Salary  & Fringe Benefits Survey Academic Advancement Used for annual AAUP survey 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPER5 Census Bureau Survey of Govt. Employment Submitted to Census Bureau by IR&C Annual survey provided to Census Bureau 2 reports Corporate Personnel System Production Annual MVS No  
FCPER7 (same as ER2 - by Personnel Prog & Appt type) HR Client Relations & Diversity Affirmative Action Plan 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPER8 Employees with more than one appointment Multiple departments To troubleshoot possible problems in payroll 1 report Corporate Personnel System Production Monthly MVS No  
FCPER9 Stat. Summ by Fundsource Multiple departments, campus IR units Staff funding analysis 4 reports Corporate Personnel System Production Semi-annual MVS No  
FCPER10 Stat. Summ Excl. Health Sci. Multiple departments, campus IR units FTE and headcount analysis 2 reports Corporate Personnel System Production Semi-annual MVS No  
FCPICS Salaries & Wages of Professionals & Non-Professionals Financial Management Indirect cost reporting 3 reports Corporate Personnel System Production Annual MVS No  
FCPIMX3 Academic Health Sciences Edit Academic Advancement Data verification 1 report Corporate Personnel System Production Monthly MVS No  
FCPMP4 Top 100 Paid Faculty HR Client Relations & Diversity, HR Sr Mgmt Compensation, Policy, and Recruitment Compensation analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPMP5 Executive Program - Affirmative Action Report HR Sr Mgmt Compensation, Policy, and Recruitment Diversity analysis 3 reports Corporate Personnel System Production Quarterly MVS No  
FCPIPEDS IPEDS Human Resources Survey Submitted directly by IR&C on behalf of Academic Advancement and HR Client Relations & Diversity  NCES IPEDS surveys 32 extract files Corporate Personnel System Production Annual MVS No  
FCPNIHSC NIH Salary Cap Extract file Financial Management NIH Salary Cap reporting 1 extract file Corporate Personnel System Production Annual MVS No  
FCPOER1 Employee Headcount by Personnel Program and Appointment Type  HR Labor Relations Labor relations analysis compound pdf containing 5 reports Corporate Personnel System Production Monthly MVS Yes  
FCPOER2 Ethnic Composition of MSP and PSS Employees HR Compensation Policy Labor relations analysis compound pdf containing 10 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPOER3 Statistical Summary - FT/PT Headcount (same as FCPER1 except studenta are excluded) HR Compensation Policy Labor relations analysis compound pdf containing 6 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPOFA1 Headcnt & Tot. Dollars of RA's & TA's Student Academic Services-Financial Aid Student workforce analysis 1 report Corporate Personnel System Production Annual MVS No  
FCPOFA2 Headcnt & Tot. Dollars and Tot. FTE of RA's and TA's Student Academic Services-Financial Aid Student workforce analysis 2 reports Corporate Personnel System Production Monthly MVS No  
FCPOIR1 Same as ER1.3 - excl students - BK only UCB Institutional Research unit Institutional research 1 report Corporate Personnel System Production Semi-annual MVS No  
FCPOLR1 Title Unit Code by Location HR Labor Relations Labor relations analysis 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPOLR2 % of dues deductions authorized for employees,  by represented certified bargaining unit   HR Labor Relations Labor relations analysis 3 reports Corporate Personnel System Production Monthly MVS Yes  
FCPOLR3 Empls. represented/not represented by certified bargaining unit HR Labor Relations Labor relations analysis 3 reports Corporate Personnel System Production Monthly MVS Yes  
FCPRA01 Indirect Cost Calculations Financial Management Indirect cost reporting 1 report Corporate Personnel System Production Annual MVS No  
FCPRB1 Unemployment Insurance Covered Wages HR&B Financial Services Financial analysis of benefits 1 report Corporate Personnel System Production Quarterly MVS Yes  
FCPRB6 Active Members of Retirement System HR&B Financial Services Financial analysis of benefits 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPRB7 Benefits Enrollment and Premiums (campuses, labs, & Hastings) HR&B-Program Planning & Design Benefits planning 108 reports, 12 Excel spreadsheets Corporate Personnel System Production Quarterly MVS Yes  
FCPRB8 HDCT of Empl. Status/Elig./Partic. in TIP, Depcare, Medplus HR&B Financial Services Financial analysis of benefits 3 reports Corporate Personnel System Production Annual MVS Yes  
FCPRB9A Headcount of Employees Participating in TIP HR&B Financial Services Financial analysis of benefits 1 report Corporate Personnel System Production Annual MVS Yes  
FCPRB9B Headcnt. of Empl. Participating in TIP/Depcare rpts. HR&B Financial Services Financial analysis of benefits 1 report Corporate Personnel System Production Annual MVS Yes  
FCPRB11 Open Enrollment (campus, labs, Hastings, & ASUCLA) HR&B-Program Planning & Design Open Enrollment analysis 39 reports, 7 Excel spreadsheets Corporate Personnel System Production Annual MVS Yes  
FCPRB12 Employee Turnover reports - by Personnel Prog & Appt Type HR&B-Program Planning & Design Staff turnover analysis 14 reports Corporate Personnel System Production Annual MVS Yes  
FCPRB13 Prudential Enrollees - Tape HR&B-Program Planning & Design To provide information to insurance carriers 1 report, 1 extract file Corporate Personnel System Production Annual MVS Yes  
FCPRB14 List of Executive Program Employees HR Sr Mgmt Compensation, Policy, and Recruitment Senior management analysis 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPRB21 S89-Eligibility Test reports HR&B-Program Planning & Design To ensure compliance with IRS regulations 28 reports, 1 Excel spreadsheet Corporate Personnel System Production Quarterly MVS Yes  
FCPRB22 S89-Special Status reports HR&B-Program Planning & Design To ensure compliance with IRS regulations   Corporate Personnel System Production Semi-annual MVS Yes  
FCPRB23 S89-Depcare 55% Ave. Benefits Test reports HR&B-Program Planning & Design To ensure compliance with IRS regulations 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPRB24 S89-Empl. on Leave of Absence HR&B-Program Planning & Design Benefits eligibility analysis 8 reports Corporate Personnel System Production Monthly MVS Yes  
FCPRB26 BELI Reports HR&B-Program Planning & Design Benefits eligibility analysis 10 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPRB27 Benefits Status Qualification Code Reports HR&B-Program Planning & Design Benefits eligibility analysis 2 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPRB31/32 COBRA - Campus Extract and Report HR Client Relations & Diversity Notify new employees of COBRA eligibility 3 reports, 1 extract file Corporate Personnel System Production Monthly MVS Yes  
FCPRB33 Employee Headcount, Average Age, and Average Wage HR&B Info Systems Workforce analysis 2 reports Corporate Personnel System Production Annual MVS Yes  
FCPRB34/35 COBRA - Lab, Hastings & ASUCLA Extract and Report HR Client Relations & Diversity Notify new employees of COBRA eligibility 3 reports, 1 extract file Corporate Personnel System Production Monthly MVS Yes  
FCPRB36 COBRA - Campus, Lab, Hastings & ASUCLA mailing files HR Client Relations & Diversity Provide UC Mailing Services with file to use for mailing COBRA notices 1 report, 2 extract files Corporate Personnel System Production Monthly MVS Yes  
FCPRB37 Benefits Enrollment and Premiums (campuses, labs, & Hastings) by title unit code HR&B-Program Planning & Design Benefits planning 21 reports, 11 Excel spreadsheets Corporate Personnel System Production Quarterly MVS Yes  
FCPRB38 TIP Average Benefits Test A HR&B-Program Planning & Design To ensure compliance with IRS regulations 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPRB39 HCRA Average Benefits Test B HR&B-Program Planning & Design To ensure compliance with IRS regulations 1 report Corporate Personnel System Production Monthly MVS Yes  
FCPRB41 Benefits Open Enrollment reports by bargaining unit HR&B-Program Planning & Design Benefits planning 7 Excel spreadsheets, 16 reports Corporate Personnel System Production Annual MVS Yes  
FCPRB42 Benefits Open Enrollment reports -changes to coverage codes by bargaining unit HR&B-Program Planning & Design Benefits planning 2 Excel spreadsheets, 6 reports Corporate Personnel System Production Annual MVS Yes  
FCPRB44 HR Benefits Briefing mailing files HR Client Relations & Diversity Provide UC Mailing Services with file to use for mailing HR Benefits Briefing mailings 2 extract files, 1 report Corporate Personnel System Production Approx 6 times per year on request MVS    
FCPRB45 HR Benefits Active Employee Open Enrollment Mailing files HR Client Relations & Diversity Provide UC Mailing Services with file to use for mailing HR Benefits communications to employees 1 extract file Corporate Personnel System Production On request MVS Record counts only  
FCPRB46 Imputed Income Employee mailing file HR Client Relations & Diversity Provide UC Mailing Services with file to use for mailing  to employees with benefits coverage for domestic partners/domestic partners' dependents 2 extract files, 2 Excel spreadsheets, 1 report Corporate Personnel System Production Annual MVS Record counts only  
FCPRB47 Counts of employees and dependents by dependent relation code HR&B-Program Planning & Design Open Enrollment analysis 69 reports Corporate Personnel System, Dependent Data System Production Annual MVS Yes  
FCPRB48 Family Medical Verification mailing file and extract file for database HR Client Relations & Diversity Notify employees  of family medical verification activity 2 extract files Corporate Personnel System Production Annual MVS No  
FCPRB49 Annual Hewitt census file HR & B Provide selected employment and benefits data to consultants 1 employee extract and 1 dependent extract Corporate Personnel System Production Annual MVS No UCRS extract is scheduled to be run at the end of December and June
FCPRB50 Rehired Retirees Report HR&B Compliance Provide information on retirees who have returned to work at any UC location 1 spreadsheet UCRS, Corporate Personnel System Production Semi-annual MVS Planned  
FCPRMS1 FTE & Cnts. of FT & PT by Loc AND Earnings by location and fundsource. Risk Management Worker's compensation insurance analysis 3 reports Corporate Personnel System Production Monthly MVS No  
FCPRMS2 Semi Annual Base Pay Risk Management Worker's compensation insurance analysis 1 report, 2 Excel spreadsheets Corporate Personnel System Production Annual MVS No Salary ranges are based on total gross from W2 for previous calendar year
FCPRMS9 Headcount by Salary Category Risk Management Employment Practices Liability insurance renewal  2 reports Corporate Personnel System Production Semi-annual MVS No Total gross is from the W2 for the prior calendar year
FCPRMS10 Prior Year Total Gross by Location and Department Risk Management Provide information to Worker's Compensation carrier on total payroll 1 report Corporate Personnel System Production Annual MVS  No  
FCPSCHCD FCP School codes for academic file Academic Advancement Provides campus Academic Personnel staff with listings of valid school codes for annual academic file submission 4 electronic files copied to website Corporate Personnel System Production On request MVS No  
FCPSP1 Staff Personnel Listings by Org. Unit and Title HR&B Compensation Policy Workforce analysis 3 reports in one electronic file Corporate Personnel System Production Annual MVS Yes  
FCPSP2 Salary & FTE Series for Mgmt., Staff, & Acad. HR&B Compensation Policy Workforce analysis 5 reports Corporate Personnel System Production Semi-annual MVS Yes  
FCPSP3 HDCT, FTE & Career Weighted Ave. Salary rpt. HR&B Compensation Policy Workforce analysis 6 reports Corporate Personnel System Production 5 times per year MVS Yes  
FCPSP6 Employee Turnover reports - by CTO/OSC HR&B Workforce Planning Workforce analysis 3 reports Corporate Personnel System Production Annual MVS Yes  
FCPSP10 FTE by Title Use Designation HR&B Workforce Planning Workforce analysis 2 reports Corporate Personnel System Production Annual MVS Yes  
FCPSP11 New Hires report HR&B Workforce Planning Workforce analysis 2 reports Corporate Personnel System Production Annual MVS Yes  
FCPSP31 HDCT, FTE & Weighted Ave. Salary FTE & Weighted Ave. Salary HR&B Workforce Planning Workforce analysis 2 reports Corporate Personnel System Production Quarterly MVS Yes  
FCPTR02 Ethics Briefing Training extract HR&B Systemwide Strategy Provide data needed to identify employees requiring ethics training for Workplace Answers 1 extract file Corporate Personnel System Production Annual MVS No  
FCPYR03 Ethics Training for Researchers report and extract Ethics, Compliance & Audit Services Provide headcounts of researchers identified for this training, produce file with information on these employees to be used by the  LMS system 1 report, 1 extract file Corporate Personnel System Pending in production Biennial MVS No  
FCPUCOP UCOP Employee id labels-discontinued - cards no longer display expiration dates UCOP HR  Produce stickers with new expiration date  for UCOP employee id cards  1 set of labels with employee name and id, 1 set of blank labels for new employees Corporate Personnel System Production Annual MVS No  
FCPVT100 VETS-100 Report for EEOC - Replaced by PERG0021 run from Corporate Systems Gateway HR Client Relations & Diversity Report to submit to the EEOC 1 report Corporate Personnel System Production Annual MVS Yes  
FCPXCRSC & D CRIS extracts for Indirect Cost Reporting Financial Management Indirect cost reporting 12 extract files, 1 report Corporate Personnel System Production Annual MVS No  
FCPXCSS Extract of all earnings for fiscal year to be used by Corporate Student System to identify all students who had earnings during the academic year Student Academic Services-Financial Aid Student earnings reporting process 1 annual extract Corporate Personnel System Production Annual MVS No  
PERA0011 Title Unit Code by Location (same as FCPOLR1) HR Labor Relations Labor relations analysis 1 report, choice of Excel or pdf Corporate Personnel data warehouse On demand On request CSG No  
PERA0021 % of dues deductions. authorized for employees,  by represented certified bargaining unit (same as FCPOLR2) HR Labor Relations Labor relations analysis Compound pdf Corporate Personnel data warehouse On demand On request CSG No  
PERA0031 Empls. represented/not represented by certified bargaining unit (same as FCPOLR3) HR Labor Relations Labor relations analysis Compound pdf Corporate Personnel data warehouse On demand On request CSG No  
PERA0101 Employee Detail by Bargaining Unit HR Labor Relations Labor relations analysis Compound Excel Corporate Personnel data warehouse On demand On request CSG No  
PERA5501 W2, Total Gross & Base Pay Earnings by TUC and Calendar Year HR-Labor Relations Use selection parameters to retrieve earnings data for employees by bargaining unit 1 Excel spreadsheet Corporate Personnel data warehouse On demand On request CSG No  
PERD0011 Labor Statistics National Compensation Survey HR Information Systems and Support Government survey Compound Excel Corporate Personnel data warehouse On demand On request CSG No  
PERE0011 Employee Headcount by Personnel Program and Appointment Type (same as FCPOER1) HR Labor Relations Labor relations analysis Compound pdf Corporate Personnel data warehouse On demand On request CSG No  
PERE0021 Ethnic Composition of MSP and PSS Employees HR Compensation Policy Labor relations analysis 10 reports Corporate Personnel data warehouse On demand On request CSG No  
PERE0031 Statistical Summary - FT/PT Headcount (excludes students- same as FCPOER3) HR Compensation Policy Labor relations analysis 6 reports Corporate Personnel data warehouse On demand On request CSG No  
PERG0011 Composition of UC Workforce (same as FCPAA19 on MVS) HRB-Strategic Planning and Workforce Development Provide ethnicity and gender data for career staff employees Compound PDF which contains same data as Excel spreadsheets produced by MVS job Corporate Personnel data warehouse On demand On request CSG No  
PERG0021 Federal Contractor Veterans Employment - VETS-100A HR-Diversity Federal reporting on employees who are veterans Compound PDF which contains same data as Excel spreadsheets produced by MVS job Corporate Personnel data warehouse On demand On request CSG No  
PERG0101 Counts of Career Staff by Age distribution, gender, and ethnicity HRB-Strategic Planning and Workforce Development Provide ethnicity and gender data for career staff employees by age range 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERG0111 Counts of Career Staff Employees by Ethnicity, Gender, and Length of Service HRB-Strategic Planning and Workforce Development Provide ethnicity and gender data for career staff employees by length of service Compound PDF which contains same data as Excel spreadsheets produced by MVS job Corporate Personnel data warehouse On demand On request CSG No  
PERG0121 Counts of New Hires by Age at Hire - Career Staff Employees - by Ethnicity and Gender HRB-Strategic Planning and Workforce Development Provide ethnicity and gender data for career staff employees by age at hire Compound PDF which contains same data as Excel spreadsheets produced by MVS job Corporate Personnel data warehouse On demand On request CSG No  
PERG0131 Counts of Career Staff Employees by ethnicity, Gender, and Annual Salary range HRB-Strategic Planning and Workforce Development Provide ethnicity and gender data for career staff employees Compound PDF which contains same data as Excel spreadsheets produced by MVS job Corporate Personnel data warehouse On demand On request CSG No  
PERI0011 S89-Depcare 55% Ave. Benefits Test reports (same as FCPRB23) HR&B-Program Planning & Design To monitor compliance with IRS regulations 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERI0021 TIP Average Benefits Test A (same as FCPRB38) HR&B-Program Planning & Design To monitor compliance with IRS regulations 1 report Corporate Personnel data warehouse On demand On request CSG No  
PERI0031 TIP Average Benefits Test B (same as FCPRB39) HR&B-Program Planning & Design To monitor compliance with IRS regulations 1 report Corporate Personnel data warehouse On demand On request CSG No  
PERM0011 Academic Compensation Budget Request (same as FCPCER2 on MVS) Academic Personnel Provide General Campus FTE and Salary detail Compound PDF  Corporate Personnel data warehouse On demand On request CSG No  
PERO011 TCS Spreadsheet Compensation Policy and Planning, campus compensation units Use selection parameters to retrieve  title code data from data warehouse for the University Title Code System 1 Excel spreadsheet Title Code System in data warehouse On demand On request CSG No  
PERQ0011 FCPRMS8 - Hours Worked for FY - By Campus By Dept Risk Management UCOP workforce analysis multiple pdf reports depending on parameters selected Corporate Personnel data warehouse On demand Annual CSG No  
PERX0011   OPPPERR - Audit of Sex,Ethnic Codes (Error Report)   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0131    OPPP13 - Office of the President by Division  UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0151   OPPP15 - Office of the President by Department   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0161    OPPP16 - Workforce Analysis Reports  UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0181   OPPP18 - Workforce Array Reports   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0221   OPPP22 - Mgt & Sr Professional Employees Reports   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0231   OPPP23 - Tier 2 Merit Reports   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0241   OPPP24 - Statistical Summary by Sex, Ethnicity   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0251   OPPP25 - Workforce Representation Availability   UCOP HR
Not currently in use
UCOP workforce analysis 1 pdf report Corporate Personnel data warehouse On demand On request CSG No  
PERX0301 UCOP Workforce Data Committee on the Status of Women UCOP workforce analysis for presentation to President Yudof 1 Excel spreadsheet Corporate Personnel data warehouse On demand On request CSG No  
PERY0011 Headcount by Personnel Program and Representation-Staff HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0012 Headcount and FTE by Personnel Program HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0021 Headcount by Appointment Type-Staff HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0022 Headcount and FTE by Appointment Type HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0031 Staff Personnel by Personnel Program and Appointment Type HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0041 Distribution of Campus and Medical Center Staff within Personnel Program HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0042 Distribution of Campus and Medical Center Staff Employees With Casual Restricted Total HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0043 Dist of Campus and Medical Center Staff with Appt Type HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0051 Minority Representation of Staff Workforce HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0061 Ethnic Groups as a Percentage of Staff Career Workforce HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0071 Staff Career Workforce by Personnel Program HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0081 Staff Career Workforce by Ethnicity and Sex HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0091 Age Distribution of Staff Employees HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0101 Length of Service of Staff Employees HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0102 Length of Service of PSS Employees HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0111 Staff New Hires by Occupational Group HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0121 Staff New Hires by Age at Hire HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0131 Staff Employees by Union Representation HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0141 Staff Employees by Collective Bargaining Unit HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0151 Academic Employees by Union Representation HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0161 Academic Employees by Collective Bargaining Unit HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0171 Staff Weighted Average Annual Salaries HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0181 Staff Career Workforce by Occupational Group HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0191 Turnover Rates of Career Staff by Occupational Group HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
PERY0201 Staff FTE by Fund Source HRB-Strategic Planning and Workforce Development UCOP Workforce Analysis for publication on web and in Accountability Framework.  Excel output will be converted to graph format. 1 report, in pdf or Excel based on selection Corporate Personnel data warehouse On demand On request CSG No  
SLISAR01 SLIS Annual Report of Executive Compensation Compensation Programs and Strategy To present executive total compensation to Regents and to publish on web 1 pdf report Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLISARD1 Annual Report Addendum Compensation Programs and Strategy To explain in further detail information in the AREC; to present to Regents and to publish on web 1 pdf report Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1061 Outside Prof Activities Audit Report Compensation Programs and Strategy Used for certification of OPA by employee and by campus multiple pdf reports depending on parameters selected Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1062 Outside Prof Activities Final Report - Compensated Compensation Programs and Strategy To present SMG compensated OPA to Regents and to publish on web 1 pdf report Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1063 Outside Prof Activities Final Rept - Uncompensated Compensation Programs and Strategy To present SMG uncompensated OPA to President and to publish on web 1 pdf report Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1101 AREC Audit Report - Salary & Oth Cash Compensation Compensation Programs and Strategy For campuses to audit the compensation data they have entered into SLIS before the AREC is final 1 Excel spreadsheet Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1111 AREC Audit Report - Benefits and Perquisites Compensation Programs and Strategy For campuses to audit the compensation data they have entered into SLIS before the AREC is final 1 Excel spreadsheet Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1121 AREC Audit Report - One Time Payments Compensation Programs and Strategy For campuses to audit the compensation data they have entered into SLIS before the AREC is final 1 Excel spreadsheet Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1131 AREC Audit Report - Future and Other Benefits Compensation Programs and Strategy For campuses to audit the compensation data they have entered into SLIS before the AREC is final 1 Excel spreadsheet Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1141 AREC Audit Report - Multiple Compensation Types Compensation Programs and Strategy For campuses to audit the compensation data they have entered into SLIS before the AREC is final 1 Excel spreadsheet Senior Leadership Information System On demand Annual process; multiple runs CSG No  
SLIS1201 Action Tracking Report Compensation Programs and Strategy To report to the Regents campus-approved salary actions for SLCG employees 1 pdf report with variety of paramaters Senior Leadership Information System On demand On request CSG No  
SLIS1202 Action Tracking Report Addendum Compensation Programs and Strategy Footnotes/comments related toapproved salary actions for SLCG employees 1 pdf report with variety of paramaters Senior Leadership Information System On demand On request CSG No  
SLIS1301 Active Employees for Calendar Year Compensation Programs and Strategy For auditors and Compensation unit to identify all SMG's to ensure they are included in annual reports 1 Excel spreadsheet Senior Leadership Information System On demand On request CSG No  
SR16336A One Percent Legislative Report Budget Office Retrieve data used for 1% Budget Report for the legislature 1 Excel spreadsheet or pdf report Corporate Personnel data warehouse On demand Annual CSG No  
SR16336F One Percent Legislative Report-Tenure Track Faculty Budget Office Retrieve data used for 1% Budget Report for the legislature 1 Excel spreadsheet or pdf report Corporate Personnel data warehouse On demand Annual CSG No  
SR16336N One Percent Legislative Report - Non-Faculty Budget Office Retrieve data used for 1% Budget Report for the legislature 1 Excel spreadsheet or pdf report Corporate Personnel data warehouse On demand Annual CSG No  
TCSH0101 Appendix A-Barg Unit Comp Rates Rept-Open Range Compensation Policy and Planning, campus compensation units Produce Appendix A report for labor union contracts 1 Excel spreadsheet or pdf report Title Code System in data warehouse On demand On request CSG No Run every three months
Enterprise Risk Management extract   Extract of employee data for the Enterprise Risk Management dashboard implemented by IBM Risk Management units at UCOP and Campuses Provide data for ERM dashboard 1 comma-delimited file Corporate Personnel data warehouse Production Monthly WebFocus MRE (will be in CSG) No Runs automatically each month, transfers files to vsftp
Davis employee, appointment, and distribution extracts Extract of all Davis employee, appointment, and earnings data for past 10 years and ongoing Consortium of departments at UC Davis Provide data for analysis 3 comma-delimited files for each cycle Corporate Personnel data warehouse Production Monthly WebFocus MRE  No