Excel Spreadsheets Reports - Excel - Excel

Document Sample
Excel Spreadsheets Reports - Excel - Excel Powered By Docstoc
					Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                     No of
                                                                                                     Reports/Files                    Production/                           In
                                                       Requesting                                    Produced from                    Recurring/                            Document
Job ID      Report Name                                Dept                Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments


                                                                                                                         Corporate
                                                                                                                         Personnel/D
            Report and Labels for Overage              HR&B-Program        Benefits analysis and     1 report, 5 sets of ependent
DEPRPT1     Dependents                                 Planning & Design   employee notification     labels              Data system Production    Monthly      MVS          Yes

                                                                                                                          Corporate
                                                                                                                          Personnel/D
            Counts of Emps and Deps by Location,       HR&B-Program                                                       ependent
DEPRPT2     Coverage Plan, Dep Relationship            Planning & Design   Benefits analysis         2 reports            Data system Production   Monthly      MVS          Yes

                                                                                                                          Corporate
                                                                                                                          Personnel/D
            Average Number of Dependents by            HR&B-Program                                                       ependent
DEPRPT3     Location, Health Plan                      Planning & Design   Benefits analysis         2 reports            Data system Production   Monthly      MVS          Yes

                                                                                                                          Corporate
                                                                                                                          Personnel/D
            Average Number of Children by Location     HR&B-Program                                                       ependent
DEPRPT4     by Personnel Program                       Planning & Design   Benefits analysis         1 report             Data system Production   Monthly      MVS          Yes

                                                                                                                          Corporate
                                                                                                                          Personnel/D
            Listing of all Dependents Enrolled as      HR&B-Program                                                       ependent
DEPRPT5     Wards                                      Planning & Design   Benefits analysis         1 report             Data system Production   Monthly      MVS          Yes

            Listing and labels for all Spouses and                                                                        Corporate
            Adult Dependent Relatives who will be                                                                         Personnel/D
            turning 65, or employees who are turning   HR&B-Program        Benefits analysis and     1 report, 1 set of   ependent
DEPRPT6     65                                         Planning & Design   employee notification     labels               Data system Production   Quarterly    MVS          Yes

                                                                                                                        Corporate
            Medical coverage and premium                                                                                Personnel/D
            information for domestic partners, adult   HR&B-Program                                  3 reports, 3 Excel ependent
DEPRPT8     dependent relatives,                       Planning & Design   Benefits analysis         spreadsheets       Data system Production     Quarterly    MVS          Yes




2/3/2011                                                                                           Page 1 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                       No of
                                                                                                       Reports/Files            Production/                             In
                                                       Requesting                                      Produced from            Recurring/                              Document
Job ID      Report Name                                Dept                 Purpose of Report          this job      System     One-Time    Frequency       Environment Direct   Comments
                                                       Academic
                                                       Advancement, HR                                              Corporate
                                                       Client Relations &   Provides required data                  Personnel
FCPAA2      EE06 - Supplement Rpts.                    Diversity            for EEOC                   3 reports    System      Production   Semi-annual    MVS          Yes
                                                       Academic
                                                       Advancement, HR      Error report to be used                 Corporate
            Invalid Sex, Ethnicity, and Citizenship    Client Relations &   to request corrections to               Personnel
FCPAA3      Codes                                      Diversity            Payroll                   1 report      System      Production   Monthly        MVS          No
                                                                                                                    Corporate
            Profile of Professorial Series & Equiv.    Academic             Faculty/Academic                        Personnel
FCPAA5      Ranks                                      Advancement          Profile                    1 report     System      Production   Annual         MVS          No
                                                                                                                    Corporate
            Age Distribution within Prof. Series,      Academic                                                     Personnel
FCPAA6      Equiv., SOE/FTE                            Advancement          Faculty analysis           6 reports    System      Production   Annual         MVS          No
                                                       HR&B Sr Mgmt
                                                       Compensation,                                                Corporate
                                                       Policy, and                                                  Personnel
FCPAA7      Undupl. Cnt. of Handicapped Employees      Recruitment          Workforce analysis         1 report     System      Production   Monthly        MVS          Yes
                                                                                                                    Corporate
            New Appointees - Disc., Rank, Salary,      Academic                                                     Personnel
FCPAA10     Sex, Ethnicity                             Advancement          Faculty analysis           4 reports    System      Production   Annual         MVS          No
                                                                                                                    Corporate
                                                       Academic                                                     Personnel
FCPAA11     New Appointees - Origins of Recruitment    Advancement          Faculty analysis           1 report     System      Production   Annual         MVS          No
                                                                                                                    Corporate
            New Appointees - Disc., Rank, Yr. of       Academic                                                     Personnel
FCPAA12     Doctorate, Sex, Ethnicity                  Advancement          Faculty analysis           1 report     System      Production   Annual         MVS          No
                                                                                                                    Corporate
                                                       Academic                                                     Personnel
FCPAA13     Faculty Promoted - Disc., Sex, Ethnicity   Advancement          Faculty analysis           3 reports    System      Production   Annual         MVS          No
                                                                                                                    Corporate
            Counts of MSP & SMG Emps. by Sal.          HR Client Relations Workforce diversity                      Personnel
FCPAA16     Range, Ethnicity & Gender                  & Diversity         analysis                    1 report     System      Production   Semi-annual    MVS          Yes
                                                                                                                    Corporate
            DOE Lab Headcount by Gender and            HR Client Relations Workforce diversity                      Personnel
FCPAA17     Ethnicity                                  & Diversity         analysis                    1 report     System      Production   Semi-annual    MVS          Yes




2/3/2011                                                                                             Page 2 of 23                                          d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                         No of
                                                                                                         Reports/Files                   Production/                             In
                                                         Requesting                                      Produced from                   Recurring/                              Document
Job ID      Report Name                                  Dept                Purpose of Report           this job      System            One-Time    Frequency       Environment Direct   Comments
                                                                                                                             Corporate
                                                         HR Client Relations                             1 report, 6 Excel   Personnel
FCPAA19     Composition of UC Workforce                  & Diversity         Affirmative Action Plan     spreadsheets        System      Production   Semi-annual    MVS          Yes
                                                                                                                             Corporate
                                                         Academic                                                            Personnel
FCPAP1      Headcnt. & FTE - Acad - By CTO               Advancement         Faculty analysis            1 report            System      Production   Semi-annual    MVS          No
                                                                                                                             Corporate
            Headcnt. & FTE - Acad - by Health            Academic                                                            Personnel
FCPAP2      Sci./General Campus                          Advancement         Faculty analysis            1 report            System      Production   Semi-annual    MVS          No
                                                                                                                             Corporate
            FTE, HDCT, Ave. Salary - General             Academic                                                            Personnel
FCPAP3      Campus/Health Sci.                           Advancement         Faculty analysis            1 report            System      Production   Semi-annual    MVS          No
                                                                                                                             Corporate
            Appointments, Promotions/Separations -       Academic                                                            Personnel
FCPAP4      Sex, FTE                                     Advancement         Faculty analysis            4 reports           System      Production   Annual         MVS          No
                                                                                                                             Corporate
            Full/Part Time - HDCT, FTE, General          Academic                                                            Personnel
FCPAP5      Campus/Health Sci                            Advancement         Faculty analysis            1 report            System      Production   Semi-annual    MVS          No
                                                                                                                             Corporate
            Ave. Age within Faculty - General            Academic                                                            Personnel
FCPAP6      Campus/Health Sci.                           Advancement         Faculty analysis            1 report            System      Production   Annual         MVS          No
                                                                                                                             Corporate
                                                         Academic                                                            Personnel
FCPAP9      Age Distribution - Professorial Series       Advancement         Faculty analysis            1 report            System      Production   Annual         MVS          No
                                                                                                                             Corporate
            Origins of New Appointees - General          Academic                                                            Personnel
FCPAP10     Campus                                       Advancement         Faculty analysis            3 reports           System      Production   Annual         MVS          No
                                                                                                                             Corporate
            Destination of Voluntary Separations -       Academic                                                            Personnel
FCPAP11     General Campus                               Advancement         Faculty analysis            3 reports           System      Production   Annual         MVS          No
                                                                                                                             Corporate
                                                         Academic                                                            Personnel
FCPAP12     Reasons for Separations                      Advancement         Faculty analysis            6 reports           System      Production   Annual         MVS          No
                                                                                                                             Corporate
            Profile of Prof. Series - Disc., Sex, FTE,   Academic                                                            Personnel
FCPAP13     Salary, Age                                  Advancement         Faculty analysis            6 reports           System      Production   Semi-annual    MVS          No




2/3/2011                                                                                               Page 3 of 23                                                 d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                   No of
                                                                                                   Reports/Files                   Production/                             In
                                                     Requesting                                    Produced from                   Recurring/                              Document
Job ID      Report Name                              Dept                 Purpose of Report        this job      System            One-Time    Frequency       Environment Direct   Comments
                                                                                                                       Corporate
            Comparison of Above Scale with Tot.      Academic                                                          Personnel
FCPAP16     Population                               Advancement          Faculty analysis         1 report            System      Production   Annual         MVS          No
                                                                                                                       Corporate
                                                     Academic                                                          Personnel
FCPAP17     Above Scale Salaries by Rank             Advancement          Faculty analysis         1 report            System      Production   Annual         MVS          No
                                                                                                                       Corporate
                                                     Academic                                                          Personnel
FCPAP18     New Appointments                         Advancement          Faculty analysis         6 reports           System      Production   Annual         MVS          No
                                                                                                                       Corporate
                                                     Academic                                                          Personnel
FCPAP19     Faculty Appointed since July 1           Advancement          Faculty analysis         1 report            System      Production   Annual         MVS          No
                                                                                                                       Corporate
            Produce faculty salary survey report   Academic Planning US News & World                                   Personnel
FCPAP21     used for US News & World Report survey and Analysis      Report survey                 12 reports          System      Production   Annual         MVS          No
                                                                                                   15 reports, 15      Corporate
            Produce faculty instructional activity   Academic Planning                             Excel               Personnel
FCPAP22     reports                                  and Analysis      Faculty FTE reports         spreadsheets        System      Production   Semi-annual    MVS          No
                                                                                                                       Corporate
            Actual Salary Expenditures - by Fund &                                                                     Personnel
FCPBAP1     LOC                                      Budget Office        Budget analysis          2 reports           System      Production   Annual         MVS          No
                                                                                                                       Corporate
                                                                                                   1 report, 1 Excel   Personnel
FCPBAP4     Actual I & R Salary Expenditures         Budget Office        Budget analysis          spreadsheet         System      Production   Annual         MVS          No
                                                                                                                       Corporate
                                                     Payroll             Pre-publication analysis                      Personnel
FCPCDTL     Chronicle detail file                    Coordination, Audit of UC compensation       1 extract file       System      Recurring    On request     MVS          No
                                                                                                                       Corporate
            Academic Compensation Budget Request Academic                                                              Personnel                5 times per
FCPCER1     - FTE/Salary                         Advancement              Budget analysis          1 report            System      Production   year           MVS          Yes
                                                                                                                       Corporate
            Academic Compensation Budget Request Academic                                                              Personnel                5 times per
FCPCER2     - General Campus                     Advancement              Budget analysis          1 report            System      Production   year           MVS          Yes
                                                                                                                       Corporate
            Campus Linkage Code Tables (on           HR Compensation      Compensation and labor                       Personnel
FCPCER3     request)                                 Policy               analysis               3 reports             System      Production   On request     MVS          Yes




2/3/2011                                                                                         Page 4 of 23                                                 d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                     No of
                                                                                                     Reports/Files                      Production/                             In
                                                        Requesting                                   Produced from                      Recurring/                              Document
Job ID      Report Name                                 Dept              Purpose of Report          this job      System               One-Time    Frequency       Environment Direct   Comments
                                                                                                                            Corporate
                                                        HR Compensation                                                     Personnel
FCPCER4     Incumbents in Frozen Titles                 Policy            Compensation analysis      1 report               System      Production   Monthly        MVS          Yes
                                                                                                                            Corporate
                                                        HR Compensation                                                     Personnel
FCPCER5     Incumbents in Abolished Titles              Policy            Compensation analysis      1 report               System      Production   Monthly        MVS          Yes
                                                                                                                            Corporate
            HDCT by LOC, Citzenship Status & Fund Laboratory                                                                Personnel
FCPCGX1     Source                                Administration          Lab staffing analysis      1 report               System      Production   Quarterly      MVS          No
                                                  Payroll
                                                  Coordination,                                      1 extract file, 1 to   Corporate
                                                  Strategic               Public disclosure of       11 pdf files, 1        Personnel
FCPCSUM     Chronicle summary file                Communications          compensation               report                 System      Recurring    On request     MVS          No



                                                                          Used for various
                                                                          statistical summary
                                                                          reports,publication on
                                                                          Statistical Summary
                                                                          website, and for the       1 Excel
                                                      Multiple            annual Statistical         spreadsheet, 7         Corporate
            Stat. Sum. - Admin., Acad., & Staff - FTE departments,        Summary of Students        reports, 26 pdf        Personnel
FCPER1      & Headcnt.                                Regents             and Staff                  files                  System      Production   Semi-annual    MVS          No



                                                                          Used for various
                                                                          statistical summary
                                                                          reports,publication on
                                                                          Statistical Summary
                                                                          website, and for the
                                                        Multiple          annual Statistical                            Corporate
            Stat. Sum. - Admin., Acad., & Staff - Sex   departments,      Summary of Students        2 reports, 1 Excel Personnel
FCPER2      & Ethnicity                                 Regents           and Staff                  spreadsheet        System          Production   Monthly        MVS          No
                                                                                                                        Corporate
            AAUP Faculty Salary & Fringe Benefits       Academic          Used for annual AAUP                          Personnel
FCPER3      Survey                                      Advancement       survey                     1 report           System          Production   Semi-annual    MVS          No




2/3/2011                                                                                           Page 5 of 23                                                    d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                     No of
                                                                                                     Reports/Files            Production/                             In
                                                     Requesting                                      Produced from            Recurring/                              Document
Job ID      Report Name                              Dept                Purpose of Report           this job      System     One-Time    Frequency       Environment Direct   Comments
                                                     Submitted to                                                 Corporate
            Census Bureau Survey of Govt.            Census Bureau by    Annual survey provided                   Personnel
FCPER5      Employment                               IR&C                to Census Bureau       2 reports         System      Production   Annual         MVS          No
                                                                                                                  Corporate
            (same as ER2 - by Personnel Prog & Appt HR Client Relations                                           Personnel
FCPER7      type)                                   & Diversity         Affirmative Action Plan      1 report     System      Production   Monthly        MVS          Yes
                                                                                                                  Corporate
            Employees with more than one             Multiple            To troubleshoot possible                 Personnel
FCPER8      appointment                              departments         problems in payroll      1 report        System      Production   Monthly        MVS          No
                                                     Multiple                                                     Corporate
                                                     departments,                                                 Personnel
FCPER9      Stat. Summ by Fundsource                 campus IR units     Staff funding analysis      4 reports    System      Production   Semi-annual    MVS          No
                                                     Multiple                                                     Corporate
                                                     departments,        FTE and headcount                        Personnel
FCPER10     Stat. Summ Excl. Health Sci.             campus IR units     analysis                    2 reports    System      Production   Semi-annual    MVS          No
                                                                                                                  Corporate
            Salaries & Wages of Professionals & Non- Financial                                                    Personnel
FCPICS      Professionals                            Management          Indirect cost reporting     3 reports    System      Production   Annual         MVS          No
                                                                                                                  Corporate
                                                     Academic                                                     Personnel
FCPIMX3     Academic Health Sciences Edit            Advancement         Data verification           1 report     System      Production   Monthly        MVS          No

                                                     HR Client Relations
                                                     & Diversity, HR Sr
                                                     Mgmt
                                                     Compensation,                                                Corporate
                                                     Policy, and                                                  Personnel
FCPMP4      Top 100 Paid Faculty                     Recruitment         Compensation analysis       1 report     System      Production   Annual         MVS          No
                                                     HR Sr Mgmt
                                                     Compensation,                                                Corporate
            Executive Program - Affirmative Action   Policy, and                                                  Personnel
FCPMP5      Report                                   Recruitment         Diversity analysis          3 reports    System      Production   Quarterly      MVS          No




2/3/2011                                                                                           Page 6 of 23                                          d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                      No of
                                                                                                      Reports/Files                  Production/                             In
                                                      Requesting                                      Produced from                  Recurring/                              Document
Job ID      Report Name                               Dept                 Purpose of Report          this job      System           One-Time    Frequency       Environment Direct   Comments

                                                      Submitted directly
                                                      by IR&C on behalf
                                                      of Academic
                                                      Advancement and                                                    Corporate
                                                      HR Client Relations                                                Personnel
FCPIPEDS    IPEDS Human Resources Survey              & Diversity         NCES IPEDS surveys          32 extract files   System      Production   Annual         MVS          No
                                                                                                                         Corporate
                                                      Financial            NIH Salary Cap                                Personnel
FCPNIHSC    NIH Salary Cap Extract file               Management           reporting              1 extract file         System      Production   Annual         MVS          No
                                                                                                  compound pdf           Corporate
            Employee Headcount by Personnel                                                       containing 5           Personnel
FCPOER1     Program and Appointment Type              HR Labor Relations Labor relations analysis reports                System      Production   Monthly        MVS          Yes
                                                                                                  compound pdf           Corporate
            Ethnic Composition of MSP and PSS         HR Compensation                             containing 10          Personnel
FCPOER2     Employees                                 Policy             Labor relations analysis reports                System      Production   Semi-annual    MVS          Yes
            Statistical Summary - FT/PT Headcount                                                 compound pdf           Corporate
            (same as FCPER1 except studenta are       HR Compensation                             containing 6           Personnel
FCPOER3     excluded)                                 Policy             Labor relations analysis reports                System      Production   Semi-annual    MVS          Yes

                                                      Student Academic                                                   Corporate
                                                      Services-Financial   Student workforce                             Personnel
FCPOFA1     Headcnt & Tot. Dollars of RA's & TA's     Aid                  analysis                   1 report           System      Production   Annual         MVS          No
                                                      Student Academic                                                   Corporate
            Headcnt & Tot. Dollars and Tot. FTE of    Services-Financial   Student workforce                             Personnel
FCPOFA2     RA's and TA's                             Aid                  analysis                   2 reports          System      Production   Monthly        MVS          No
                                                                                                                         Corporate
                                                      UCB Institutional                                                  Personnel
FCPOIR1     Same as ER1.3 - excl students - BK only   Research unit        Institutional research     1 report           System      Production   Semi-annual    MVS          No
                                                                                                                         Corporate
                                                                                                                         Personnel
FCPOLR1     Title Unit Code by Location               HR Labor Relations Labor relations analysis 1 report               System      Production   Monthly        MVS          Yes
            % of dues deductions authorized for                                                                          Corporate
            employees, by represented certified                                                                          Personnel
FCPOLR2     bargaining unit                           HR Labor Relations Labor relations analysis 3 reports              System      Production   Monthly        MVS          Yes
                                                                                                                         Corporate
            Empls. represented/not represented by                                                                        Personnel
FCPOLR3     certified bargaining unit                 HR Labor Relations Labor relations analysis 3 reports              System      Production   Monthly        MVS          Yes




2/3/2011                                                                                            Page 7 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                      No of
                                                                                                      Reports/Files                   Production/                           In
                                                      Requesting                                      Produced from                   Recurring/                            Document
Job ID      Report Name                               Dept                Purpose of Report           this job      System            One-Time    Frequency     Environment Direct   Comments
                                                                                                                          Corporate
                                                      Financial                                                           Personnel
FCPRA01     Indirect Cost Calculations                Management          Indirect cost reporting     1 report            System      Production   Annual       MVS          No
                                                                                                                          Corporate
            Unemployment Insurance Covered            HR&B Financial      Financial analysis of                           Personnel
FCPRB1      Wages                                     Services            benefits                    1 report            System      Production   Quarterly    MVS          Yes
                                                                                                                          Corporate
                                                      HR&B Financial      Financial analysis of                           Personnel
FCPRB6      Active Members of Retirement System       Services            benefits                    1 report            System      Production   Monthly      MVS          Yes
                                                                                                      108 reports, 12     Corporate
            Benefits Enrollment and Premiums          HR&B-Program                                    Excel               Personnel
FCPRB7      (campuses, labs, & Hastings)              Planning & Design   Benefits planning           spreadsheets        System      Production   Quarterly    MVS          Yes
                                                                                                                          Corporate
            HDCT of Empl. Status/Elig./Partic. in TIP, HR&B Financial     Financial analysis of                           Personnel
FCPRB8      Depcare, Medplus                           Services           benefits                    3 reports           System      Production   Annual       MVS          Yes
                                                                                                                          Corporate
            Headcount of Employees Participating in   HR&B Financial      Financial analysis of                           Personnel
FCPRB9A     TIP                                       Services            benefits                    1 report            System      Production   Annual       MVS          Yes
                                                                                                                          Corporate
            Headcnt. of Empl. Participating in        HR&B Financial      Financial analysis of                           Personnel
FCPRB9B     TIP/Depcare rpts.                         Services            benefits                    1 report            System      Production   Annual       MVS          Yes
                                                                                                                          Corporate
            Open Enrollment (campus, labs, Hastings, HR&B-Program         Open Enrollment             39 reports, 7 Excel Personnel
FCPRB11     & ASUCLA)                                Planning & Design    analysis                    spreadsheets        System      Production   Annual       MVS          Yes
                                                                                                                          Corporate
            Employee Turnover reports - by Personnel HR&B-Program                                                         Personnel
FCPRB12     Prog & Appt Type                         Planning & Design    Staff turnover analysis     14 reports          System      Production   Annual       MVS          Yes
                                                                                                                          Corporate
                                                      HR&B-Program        To provide information      1 report, 1 extract Personnel
FCPRB13     Prudential Enrollees - Tape               Planning & Design   to insurance carriers       file                System      Production   Annual       MVS          Yes
                                                      HR Sr Mgmt
                                                      Compensation,                                                       Corporate
                                                      Policy, and         Senior management                               Personnel
FCPRB14     List of Executive Program Employees       Recruitment         analysis                    1 report            System      Production   Monthly      MVS          Yes
                                                                                                                          Corporate
                                                      HR&B-Program        To ensure compliance        28 reports, 1 Excel Personnel
FCPRB21     S89-Eligibility Test reports              Planning & Design   with IRS regulations        spreadsheet         System      Production   Quarterly    MVS          Yes




2/3/2011                                                                                            Page 8 of 23                                               d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                         No of
                                                                                                         Reports/Files                    Production/                             In
                                                          Requesting                                     Produced from                    Recurring/                              Document
Job ID       Report Name                                  Dept                  Purpose of Report        this job      System             One-Time    Frequency       Environment Direct   Comments
                                                                                                                              Corporate
                                                          HR&B-Program          To ensure compliance                          Personnel
FCPRB22      S89-Special Status reports                   Planning & Design     with IRS regulations                          System      Production   Semi-annual    MVS          Yes
                                                                                                                              Corporate
             S89-Depcare 55% Ave. Benefits Test           HR&B-Program          To ensure compliance                          Personnel
FCPRB23      reports                                      Planning & Design     with IRS regulations      1 report            System      Production   Monthly        MVS          Yes
                                                                                                                              Corporate
                                                          HR&B-Program          Benefits eligibility                          Personnel
FCPRB24      S89-Empl. on Leave of Absence                Planning & Design     analysis                  8 reports           System      Production   Monthly        MVS          Yes
                                                                                                                              Corporate
                                                          HR&B-Program          Benefits eligibility                          Personnel
FCPRB26      BELI Reports                                 Planning & Design     analysis                  10 reports          System      Production   Semi-annual    MVS          Yes
                                                                                                                              Corporate
             Benefits Status Qualification Code           HR&B-Program          Benefits eligibility                          Personnel
FCPRB27      Reports                                      Planning & Design     analysis                  2 reports           System      Production   Semi-annual    MVS          Yes
                                                                                                                              Corporate
                                                          HR Client Relations   Notify new employees of 3 reports, 1 extract Personnel
FCPRB31/32   COBRA - Campus Extract and Report            & Diversity           COBRA eligibility         file                System      Production   Monthly        MVS          Yes
                                                                                                                              Corporate
             Employee Headcount, Average Age, and                                                                             Personnel
FCPRB33      Average Wage                                 HR&B Info Systems     Workforce analysis        2 reports           System      Production   Annual         MVS          Yes
                                                                                                                              Corporate
             COBRA - Lab, Hastings & ASUCLA               HR Client Relations   Notify new employees of 3 reports, 1 extract Personnel
FCPRB34/35   Extract and Report                           & Diversity           COBRA eligibility         file                System      Production   Monthly        MVS          Yes
                                                                                Provide UC Mailing
                                                                                Services with file to use                     Corporate
             COBRA - Campus, Lab, Hastings &              HR Client Relations   for mailing COBRA         1 report, 2 extract Personnel
FCPRB36      ASUCLA mailing files                         & Diversity           notices                   files               System      Production   Monthly        MVS          Yes
             Benefits Enrollment and Premiums                                                             21 reports, 11      Corporate
             (campuses, labs, & Hastings) by title unit   HR&B-Program                                    Excel               Personnel
FCPRB37      code                                         Planning & Design     Benefits planning         spreadsheets        System      Production   Quarterly      MVS          Yes
                                                                                                                              Corporate
                                                          HR&B-Program          To ensure compliance                          Personnel
FCPRB38      TIP Average Benefits Test A                  Planning & Design     with IRS regulations      1 report            System      Production   Monthly        MVS          Yes
                                                                                                                              Corporate
                                                          HR&B-Program          To ensure compliance                          Personnel
FCPRB39      HCRA Average Benefits Test B                 Planning & Design     with IRS regulations      1 report            System      Production   Monthly        MVS          Yes




2/3/2011                                                                                               Page 9 of 23                                                  d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                       No of
                                                                                                       Reports/Files                    Production/                            In
                                                       Requesting                                      Produced from                    Recurring/                             Document
Job ID      Report Name                                Dept                 Purpose of Report          this job      System             One-Time    Frequency      Environment Direct   Comments
                                                                                                       7 Excel              Corporate
            Benefits Open Enrollment reports by        HR&B-Program                                    spreadsheets, 16     Personnel
FCPRB41     bargaining unit                            Planning & Design    Benefits planning          reports              System      Production   Annual        MVS          Yes
            Benefits Open Enrollment reports -                                                         2 Excel              Corporate
            changes to coverage codes by bargaining    HR&B-Program                                    spreadsheets, 6      Personnel
FCPRB42     unit                                       Planning & Design    Benefits planning          reports              System      Production   Annual        MVS          Yes

                                                                           Provide UC Mailing
                                                                           Services with file to use                        Corporate                Approx 6
                                                       HR Client Relations for mailing HR Benefits 2 extract files, 1       Personnel                times per year
FCPRB44     HR Benefits Briefing mailing files         & Diversity         Briefing mailings         report                 System      Production   on request     MVS

                                                                           Provide UC Mailing
                                                                           Services with file to use
                                                                           for mailing HR Benefits                          Corporate
            HR Benefits Active Employee Open           HR Client Relations communications to                                Personnel                                           Record
FCPRB45     Enrollment Mailing files                   & Diversity         employees                 1 extract file         System      Production   On request    MVS          counts only

                                                                           Provide UC Mailing
                                                                           Services with file to use
                                                                           for mailing to
                                                                           employees with benefits     2 extract files, 2
                                                                           coverage for domestic       Excel                Corporate
                                                       HR Client Relations partners/domestic           spreadsheets, 1      Personnel                                           Record
FCPRB46     Imputed Income Employee mailing file       & Diversity         partners' dependents        report               System      Production   Annual        MVS          counts only

                                                                                                                            Corporate
                                                                                                                            Personnel
                                                                                                                            System,
            Counts of employees and dependents by      HR&B-Program        Open Enrollment                                  Dependent
FCPRB47     dependent relation code                    Planning & Design   analysis                    69 reports           Data System Production   Annual        MVS          Yes
                                                                           Notify employees of                              Corporate
            Family Medical Verification mailing file   HR Client Relations family medical                                   Personnel
FCPRB48     and extract file for database              & Diversity         verification activity       2 extract files      System      Production   Annual        MVS          No
                                                                           Provide selected
                                                                           employment and              1 employee        Corporate
                                                                           benefits data to            extract and 1     Personnel      Pending in
FCPRB49     Annual Hewitt census file                  HR &B               consultants                 dependent extract System         production   Annual        MVS          No




2/3/2011                                                                                           Page 10 of 23                                                  d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                    No of
                                                                                                    Reports/Files                     Production/                             In
                                                        Requesting                                  Produced from                     Recurring/                              Document
Job ID      Report Name                                 Dept              Purpose of Report         this job      System              One-Time    Frequency       Environment Direct   Comments
                                                                                                                        Corporate
            FTE & Cnts. of FT & PT by Loc AND                             Worker's compensation                         Personnel
FCPRMS1     Earnings by location and fundsource.        Risk Management   insurance analysis    3 reports               System        Production   Monthly        MVS          No
                                                                                                                        Corporate
                                                                          Worker's compensation 1 report, 2 Excel       Personnel
FCPRMS2     Semi Annual Base Pay                        Risk Management   insurance analysis    spreadsheets            System        Production   Annual         MVS          No

                                                                                                                                                                                          Salary ranges
                                                                                                                                                                                          are based on
                                                                                                                                                                                          total gross from
                                                                          Employment Practices                          Corporate                                                         W2 for
                                                                          Liability insurance                           Personnel                                                         previous
FCPRMS9     Headcount by Salary Category                Risk Management   renewal                   2 reports           System        Production   Semi-annual    MVS          No         calendar year
                                                                                                                                                                                          Total gross is
                                                                          Provide information to                        Corporate                                                         from the W2
            Prior Year Total Gross by Location and                        Worker's Compensation                         Personnel                                                         for the prior
FCPRMS10    Department                                  Risk Management   carrier on total payroll 1 report             System        Production   Annual         MVS          No         calendar year
                                                                          Provides campus
                                                                          Academic Personnel
                                                                          staff with listings of valid
                                                                          school codes for annual                         Corporate
                                                        Academic          academic file                4 electronic files Personnel
FCPSCHCD    FCP School codes for academic file          Advancement       submission                   copied to website System       Production   On request     MVS          No
                                                        HR&B                                                              Corporate
            Staff Personnel Listings by Org. Unit and   Compensation                                   3 reports in one   Personnel
FCPSP1      Title                                       Policy            Workforce analysis           electronic file    System      Production   Annual         MVS          Yes
                                                        HR&B                                                              Corporate
            Salary & FTE Series for Mgmt., Staff, &     Compensation                                                      Personnel
FCPSP2      Acad.                                       Policy            Workforce analysis           5 reports          System      Production   Semi-annual    MVS          Yes
                                                        HR&B                                                              Corporate
            HDCT, FTE & Career Weighted Ave.            Compensation                                                      Personnel                5 times per
FCPSP3      Salary rpt.                                 Policy            Workforce analysis           6 reports          System      Production   year           MVS          Yes
                                                                                                                          Corporate
            Employee Turnover reports - by              HR&B Workforce                                                    Personnel
FCPSP6      CTO/OSC                                     Planning          Workforce analysis           3 reports          System      Production   Annual         MVS          Yes
                                                                                                                          Corporate
                                                        HR&B Workforce                                                    Personnel
FCPSP10     FTE by Title Use Designation                Planning          Workforce analysis           2 reports          System      Production   Annual         MVS          Yes




2/3/2011                                                                                         Page 11 of 23                                                   d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                      No of
                                                                                                      Reports/Files                   Production/                            In
                                                       Requesting                                     Produced from                   Recurring/                             Document
Job ID        Report Name                              Dept                 Purpose of Report         this job      System            One-Time    Frequency      Environment Direct   Comments
                                                                                                                        Corporate
                                                       HR&B Workforce                                                   Personnel
FCPSP11       New Hires report                         Planning             Workforce analysis        2 reports         System        Production   Annual        MVS          Yes
                                                                                                                        Corporate
              HDCT, FTE & Weighted Ave. Salary FTE HR&B Workforce                                                       Personnel
FCPSP31       & Weighted Ave. Salary               Planning                 Workforce analysis        2 reports         System        Production   Quarterly     MVS          Yes

                                                                       Provide data needed to
                                                                       identify employees                               Corporate
                                                       HR&B Systemwide requiring ethics training                        Personnel
FCPTR02       Ethics Briefing Training extract         Strategy        for Workplace Answers          1 extract file    System        Production   Annual        MVS          No

                                                                          Provide headcounts of                                                                                          Selection
                                                                          researchers identified for                                                                                     criteria and
                                                                          this training, produce file                                                                                    headcounts still
                                                                          with information on                                                                                            being reviewed
                                                                          these employees to be                           Corporate                                                      by Academic
              Ethics Training for Researchers report   Ethics, Compliance used by the LMS             1 report, 1 extract Personnel   Pending in                                         Personnel
FCPYR03       and extract                              & Audit Services   system                      file                System      production   Biennial      MVS          No         Directors

                                                                                                   1 set of labels with
                                                                            Produce stickers with  employee name
                                                                            new expiration date forand id, 1 set of     Corporate
              UCOP Employee id labels-now in                                UCOP employee id       blank labels for     Personnel
FCPUCOP       production                               UCOP HR              cards                  new employees        System        Production   Annual        MVS          No
                                                                                                                        Corporate
                                                       HR Client Relations Report to submit to the                      Personnel
FCPVT100      VETS-100 Report for EEOC                 & Diversity         EEOC                    1 report             System        Production   Annual        MVS          Yes
                                                                                                                        Corporate
FCPXCRSC &                                             Financial                                   12 extract files, 1 Personnel
D          CRIS extracts for Indirect Cost Reporting   Management          Indirect cost reporting report               System        Production   Annual        MVS          No
                                                                                                                        Corporate
                                                                                                                        Personnel
              Title Unit Code by Location (same as                                                 1 report, choice of data
PERA0011      FCPOLR1)                                 HR Labor Relations Labor relations analysis Excel or pdf         warehouse     On demand    On request    CSG          No




2/3/2011                                                                                          Page 12 of 23                                                 d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                   No of
                                                                                                   Reports/Files                 Production/                           In
                                                     Requesting                                    Produced from                 Recurring/                            Document
Job ID      Report Name                              Dept               Purpose of Report          this job      System          One-Time    Frequency     Environment Direct   Comments
                                                                                                                     Corporate
            % of dues deductions. authorized for                                                                     Personnel
            employees, by represented certified                                                                      data
PERA0021    bargaining unit (same as FCPOLR2)        HR Labor Relations Labor relations analysis Compound pdf        warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
            Empls. represented/not represented by                                                                    Personnel
            certified bargaining unit (same as                                                                       data
PERA0031    FCPOLR3)                                 HR Labor Relations Labor relations analysis Compound pdf        warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
                                                                                                                     Personnel
                                                                                                                     data
PERA0101    Employee Detail by Bargaining Unit       HR Labor Relations Labor relations analysis Compound Excel      warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
                                                     HR Information                                                  Personnel
            Labor Statistics National Compensation   Systems and                                                     data
PERD0011    Survey                                   Support            Government survey          Compound Excel    warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
            Employee Headcount by Personnel                                                                          Personnel
            Program and Appointment Type (same as                                                                    data
PERE0011    FCPOER1)                              HR Labor Relations Labor relations analysis Compound pdf           warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
                                                                                                                     Personnel
            Ethnic Composition of MSP and PSS        HR Compensation                                                 data
PERE0021    Employees                                Policy             Labor relations analysis 10 reports          warehouse   On demand   On request    CSG          No
                                                                                                                     Corporate
                                                                                                                     Personnel
            Statistical Summary - FT/PT Headcount    HR Compensation                                                 data
PERE0031    (excludes students- same as FCPOER3)     Policy             Labor relations analysis 6 reports           warehouse   On demand   On request    CSG          No
                                                                                                   Compound PDF
                                                                                                   which contains
                                                                                                   same data as
                                                     HRB-Strategic                                 Excel             Corporate
                                                     Planning and       Provide ethnicity and      spreadsheets      Personnel
            Composition of UC Workforce (same as     Workforce          gender data for career     produced by MVS   data
PERG0011    FCPAA19 on MVS)                          Development        staff employees            job               warehouse   On demand   On request    CSG          No




2/3/2011                                                                                         Page 13 of 23                                            d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                     No of
                                                                                                     Reports/Files                    Production/                           In
                                                   Requesting                                        Produced from                    Recurring/                            Document
Job ID      Report Name                            Dept                   Purpose of Report          this job      System             One-Time    Frequency     Environment Direct   Comments
                                                                                                                         Corporate
                                                                                                                         Personnel
            S89-Depcare 55% Ave. Benefits Test     HR&B-Program           To monitor compliance                          data
PERI0011    reports (same as FCPRB23)              Planning & Design      with IRS regulations       1 pdf report        warehouse    On demand   On request    CSG          No
                                                                                                                         Corporate
                                                                                                                         Personnel
            TIP Average Benefits Test A (same as   HR&B-Program           To monitor compliance                          data
PERI0021    FCPRB38)                               Planning & Design      with IRS regulations       1 report            warehouse    On demand   On request    CSG          No
                                                                                                                         Corporate
                                                                          Provide General                                Personnel
            Academic Compensation Budget Request Academic                 Campus FTE and Salary                          data
PERM0011    (same as FCPCER2 on MVS)             Personnel                detail                Compound PDF             warehouse    On demand   On request    CSG          No

                                                                          Use selection
                                                   Compensation           parameters to retrieve                         Title Code
                                                   Policy and Planning,   title code data from                           System in
                                                   campus                 University Title Code      1 Excel             data
PERO011     TCS Spreadsheet                        compensation units     System                     spreadsheet         warehouse    On demand   On request    CSG          No

                                                                                                     multiple pdf        Corporate
                                                                                                     reports depending   Personnel
            FCPRMS8 - Hours Worked for FY - By                            UCOP workforce             on parameters       data
PERQ0011    Campus By Dept                         Risk Management        analysis                   selected            warehouse    On demand   Annual        CSG          No
                                                                                                                         Corporate
                                                                                                                         Personnel
            OPPPERR - Audit of Sex,Ethnic Codes                           UCOP workforce                                 data
PERX0011    (Error Report)                         UCOP HR                analysis                   1 pdf report        warehouse    On demand   On request    CSG          No
                                                                                                                         Corporate
                                                                                                                         Personnel
            OPPP13 - Office of the President by                           UCOP workforce                                 data
PERX0131    Division                               UCOP HR                analysis                   1 pdf report        warehouse    On demand   On request    CSG          No
                                                                                                                         Corporate
                                                                                                                         Personnel
            OPPP15 - Office of the President by                           UCOP workforce                                 data
PERX0151    Department                             UCOP HR                analysis                   1 pdf report        warehouse    On demand   On request    CSG          No




2/3/2011                                                                                           Page 14 of 23                                               d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                  No of
                                                                                                  Reports/Files                    Production/                           In
                                                   Requesting                                     Produced from                    Recurring/                            Document
Job ID      Report Name                            Dept                 Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments
                                                                                                                       Corporate
                                                                                                                       Personnel
                                                                        UCOP workforce                                 data
PERX0161    OPPP16 - Workforce Analysis Reports    UCOP HR              analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                                                                       Personnel
                                                                        UCOP workforce                                 data
PERX0181    OPPP18 - Workforce Array Reports       UCOP HR              analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                                                                       Personnel
            OPPP22 - Mgt & Sr Professional                              UCOP workforce                                 data
PERX0221    Employees Reports                      UCOP HR              analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                                                                       Personnel
                                                                        UCOP workforce                                 data
PERX0231    OPPP23 - Tier 2 Merit Reports          UCOP HR              analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                                                                       Personnel
            OPPP24 - Statistical Summary by Sex,                        UCOP workforce                                 data
PERX0241    Ethnicity                              Affirmative Action   analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                                                                       Personnel
            OPPP25 - Workforce Representation                           UCOP workforce                                 data
PERX0251    Availability                           Affirmative Action   analysis                  1 pdf report         warehouse   On demand   On request    CSG          No
                                                                                                                       Corporate
                                                                        UCOP workforce                                 Personnel
                                                   Committee on the     analysis for presentation 1 Excel              data
PERX0301    UCOP Workforce Data                    Status of Women      to President Yudof        spreadsheet          warehouse   On demand   On request    CSG          No
                                                                                                                                                                                     Still in
                                                                        UCOP Workforce                                                                                               development
                                                                        Analysis for publication                                                                                     process -
                                                                        on web and in                                                                                                optional
                                                   HRB-Strategic        Accountability                                 Corporate                                                     ethnicity and
                                                   Planning and         Framework. Excel         1 report, in pdf or   Personnel                                                     gender
            Headcount by Personnel Program and     Workforce            output will be converted Excel based on        data                                                          breakdowns to
PERY0011    Representation-Staff                   Development          to graph format.         selection             warehouse   On demand   On request    CSG          No         be added




2/3/2011                                                                                       Page 15 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                              No of
                                                                                              Reports/Files                    Production/                           In
                                                    Requesting                                Produced from                    Recurring/                            Document
Job ID      Report Name                             Dept            Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments
                                                                                                                                                                                 Still in
                                                                    UCOP Workforce                                                                                               development
                                                                    Analysis for publication                                                                                     process -
                                                                    on web and in                                                                                                optional
                                                    HRB-Strategic   Accountability                                 Corporate                                                     ethnicity and
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     gender
                                                    Workforce       output will be converted Excel based on        data                                                          breakdowns to
PERY0021    Headcount by Appointment Type-Staff     Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         be added
                                                                                                                                                                                 Still in
                                                                    UCOP Workforce                                                                                               development
                                                                    Analysis for publication                                                                                     process -
                                                                    on web and in                                                                                                optional
                                                    HRB-Strategic   Accountability                                 Corporate                                                     ethnicity and
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     gender
            Staff Personnel by Personnel Program    Workforce       output will be converted Excel based on        data                                                          breakdowns to
PERY0031    and Appointment Type                    Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         be added
                                                                                                                                                                                 Still in
                                                                    UCOP Workforce                                                                                               development
                                                                    Analysis for publication                                                                                     process -
                                                                    on web and in                                                                                                optional
                                                    HRB-Strategic   Accountability                                 Corporate                                                     ethnicity and
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     gender
            Distribution of Campus and Medical      Workforce       output will be converted Excel based on        data                                                          breakdowns to
PERY0041    Center Staff within Personnel Program   Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         be added

                                                                    UCOP Workforce
                                                                    Analysis for publication
                                                                    on web and in
                                                    HRB-Strategic   Accountability                                 Corporate
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Minority Representation of Staff        Workforce       output will be converted Excel based on        data                                                          development
PERY0051    Workforce                               Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process




2/3/2011                                                                                   Page 16 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                No of
                                                                                                Reports/Files                    Production/                           In
                                                      Requesting                                Produced from                    Recurring/                            Document
Job ID      Report Name                               Dept            Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments

                                                                      UCOP Workforce
                                                                      Analysis for publication
                                                                      on web and in
                                                      HRB-Strategic   Accountability                                 Corporate
                                                      Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Ethnic Groups as a Percentage of Staff    Workforce       output will be converted Excel based on        data                                                          development
PERY0061    Career Workforce                          Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                      UCOP Workforce
                                                                      Analysis for publication
                                                                      on web and in
                                                      HRB-Strategic   Accountability                                 Corporate
                                                      Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Staff Career Workforce by Personnel       Workforce       output will be converted Excel based on        data                                                          development
PERY0071    Program                                   Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                      UCOP Workforce
                                                                      Analysis for publication
                                                                      on web and in
                                                      HRB-Strategic   Accountability                                 Corporate
                                                      Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Staff Career Workforce by Ethnicity and   Workforce       output will be converted Excel based on        data                                                          development
PERY0081    Sex                                       Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process
                                                                                                                                                                                   Still in
                                                                      UCOP Workforce                                                                                               development
                                                                      Analysis for publication                                                                                     process -
                                                                      on web and in                                                                                                optional
                                                      HRB-Strategic   Accountability                                 Corporate                                                     ethnicity and
                                                      Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     gender
                                                      Workforce       output will be converted Excel based on        data                                                          breakdowns to
PERY0091    Age Distribution of Staff Employees       Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         be added




2/3/2011                                                                                     Page 17 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                              No of
                                                                                              Reports/Files                    Production/                           In
                                                    Requesting                                Produced from                    Recurring/                            Document
Job ID      Report Name                             Dept            Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments
                                                                                                                                                                                 Still in
                                                                    UCOP Workforce                                                                                               development
                                                                    Analysis for publication                                                                                     process -
                                                                    on web and in                                                                                                optional
                                                    HRB-Strategic   Accountability                                 Corporate                                                     ethnicity and
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     gender
                                                    Workforce       output will be converted Excel based on        data                                                          breakdowns to
PERY0101    Length of Service of Staff Employees    Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         be added

                                                                    UCOP Workforce
                                                                    Analysis for publication
                                                                    on web and in
                                                    HRB-Strategic   Accountability                                 Corporate
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
                                                    Workforce       output will be converted Excel based on        data                                                          development
PERY0111    Staff New Hires by Occupational Group   Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                    UCOP Workforce
                                                                    Analysis for publication
                                                                    on web and in
                                                    HRB-Strategic   Accountability                                 Corporate
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
                                                    Workforce       output will be converted Excel based on        data                                                          development
PERY0121    Staff New Hires by Age at Hire          Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                    UCOP Workforce
                                                                    Analysis for publication
                                                                    on web and in
                                                    HRB-Strategic   Accountability                                 Corporate
                                                    Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
                                                    Workforce       output will be converted Excel based on        data                                                          development
PERY0131    Staff Employees by Union Representation Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process




2/3/2011                                                                                   Page 18 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                               No of
                                                                                               Reports/Files                    Production/                           In
                                                     Requesting                                Produced from                    Recurring/                            Document
Job ID      Report Name                              Dept            Purpose of Report         this job      System             One-Time    Frequency     Environment Direct   Comments

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                 Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Staff Employees by Collective Bargaining Workforce       output will be converted Excel based on        data                                                          development
PERY0141    Unit                                     Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                 Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Academic Employees by Union              Workforce       output will be converted Excel based on        data                                                          development
PERY0151    Representation                           Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                 Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
            Academic Employees by Collective         Workforce       output will be converted Excel based on        data                                                          development
PERY0161    Bargaining Unit                          Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                 Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or   Personnel                                                     Still in
                                                     Workforce       output will be converted Excel based on        data                                                          development
PERY0171    Staff Weighted Average Annual Salaries   Development     to graph format.         selection             warehouse   On demand   On request    CSG          No         process




2/3/2011                                                                                    Page 19 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                 No of
                                                                                                 Reports/Files                     Production/                              In
                                                     Requesting                                  Produced from                     Recurring/                               Document
Job ID      Report Name                              Dept            Purpose of Report           this job      System              One-Time    Frequency        Environment Direct   Comments

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                  Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or    Personnel                                                          Still in
            Staff Career Workforce by Occupational   Workforce       output will be converted Excel based on         data                                                               development
PERY0181    Group                                    Development     to graph format.         selection              warehouse     On demand   On request       CSG          No         process

                                                                     UCOP Workforce
                                                                     Analysis for publication
                                                                     on web and in
                                                     HRB-Strategic   Accountability                                  Corporate
                                                     Planning and    Framework. Excel         1 report, in pdf or    Personnel                                                          Still in
            Turnover Rates of Career Staff by        Workforce       output will be converted Excel based on         data                                                               development
PERY0191    Occupational Group                       Development     to graph format.         selection              warehouse     On demand   On request       CSG          No         process

                                                     Sr Mgmt                                     multiple pdf        Senior
                                                     Compensation    Used for certification of   reports depending   Leadership                Annual
                                                     Policy and      OPA by employee and         on parameters       Information               process;
SLIS1061    Outside Prof Activities Audit Report     Recruitment     by campus                   selected            System        On demand   multiple runs    CSG          No
                                                     Sr Mgmt         To present SMG                                  Senior
                                                     Compensation    compensated OPA to                              Leadership                Annual
            Outside Prof Activities Final Report -   Policy and      Regents and to publish                          Information               process;
SLIS1062    Compensated                              Recruitment     on web                      1 pdf report        System        On demand   multiple runs    CSG          No
                                                     Sr Mgmt         To present SMG                                  Senior
                                                     Compensation    uncompensated OPA to                            Leadership                Annual
            Outside Prof Activities Final Rept -     Policy and      President and to publish                        Information               process;
SLIS1063    Uncompensated                            Recruitment     on web                      1 pdf report        System        On demand   multiple runs    CSG          No
                                                     Sr Mgmt         To present executive                            Senior
                                                     Compensation    total compensation to                           Leadership                Annual
            SLIS Annual Report of Executive          Policy and      Regents and to publish                          Information               process;
SLISAR01    Compensation                             Recruitment     on web                      1 pdf report        System        On demand   multiple runs    CSG          No
                                                                     To explain in further
                                                     Sr Mgmt         detail information in the                       Senior
                                                     Compensation    AREC; to present to                             Leadership                Annual
                                                     Policy and      Regents and to publish                          Information               process;
SLISARD1    Annual Report Addendum                   Recruitment     on web                      1 pdf report        System        On demand   multiple runs    CSG          No




2/3/2011                                                                                    Page 20 of 23                                                      d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                            No of
                                                                                            Reports/Files                   Production/                              In
                                                    Requesting                              Produced from                   Recurring/                               Document
Job ID      Report Name                             Dept           Purpose of Report        this job      System            One-Time    Frequency        Environment Direct   Comments

                                                                   For campuses to audit
                                                    Sr Mgmt        the compensation data                      Senior
                                                    Compensation   they have entered into                     Leadership                Annual
            AREC Audit Report - Salary & Oth Cash   Policy and     SLIS before the AREC     1 Excel           Information               process;
SLIS1101    Compensation                            Recruitment    is final                 spreadsheet       System        On demand   multiple runs    CSG          No

                                                                   For campuses to audit
                                                    Sr Mgmt        the compensation data                      Senior
                                                    Compensation   they have entered into                     Leadership                Annual
            AREC Audit Report - Benefits and        Policy and     SLIS before the AREC     1 Excel           Information               process;
SLIS1111    Perquisites                             Recruitment    is final                 spreadsheet       System        On demand   multiple runs    CSG          No

                                                                   For campuses to audit
                                                  Sr Mgmt          the compensation data                      Senior
                                                  Compensation     they have entered into                     Leadership                Annual
                                                  Policy and       SLIS before the AREC     1 Excel           Information               process;
SLIS1121    AREC Audit Report - One Time Payments Recruitment      is final                 spreadsheet       System        On demand   multiple runs    CSG          No

                                                                   For campuses to audit
                                                    Sr Mgmt        the compensation data                      Senior
                                                    Compensation   they have entered into                     Leadership                Annual
            AREC Audit Report - Future and Other    Policy and     SLIS before the AREC     1 Excel           Information               process;
SLIS1131    Benefits                                Recruitment    is final                 spreadsheet       System        On demand   multiple runs    CSG          No

                                                                   For campuses to audit
                                                    Sr Mgmt        the compensation data                      Senior
                                                    Compensation   they have entered into                     Leadership                Annual
            AREC Audit Report - Multiple            Policy and     SLIS before the AREC     1 Excel           Information               process;
SLIS1141    Compensation Types                      Recruitment    is final                 spreadsheet       System        On demand   multiple runs    CSG          No

                                                    Sr Mgmt        To report to the Regents                   Senior
                                                    Compensation   campus-approved salary 1 pdf report with   Leadership
                                                    Policy and     actions for SLCG         variety of        Information
SLIS1201    Action Tracking Report                  Recruitment    employees                paramaters        System        On demand   On request       CSG          No




2/3/2011                                                                                Page 21 of 23                                                   d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                         No of
                                                                                                         Reports/Files                    Production/                              In
                                                          Requesting                                     Produced from                    Recurring/                               Document
Job ID           Report Name                              Dept                Purpose of Report          this job      System             One-Time    Frequency        Environment Direct   Comments
                                                          Sr Mgmt             Footnotes/comments                            Senior
                                                          Compensation        related toapproved      1 pdf report with     Leadership
                                                          Policy and          salary actions for SLCG variety of            Information
SLIS1202         Action Tracking Report Addendum          Recruitment         employees               paramaters            System        On demand    On request      CSG             No
                                                                                                                            Corporate
                                                                              Retrieve data used for     1 Excel            Personnel
                                                                              1% Budget Report for       spreadsheet or pdf data
SR16336A         One Percent Legislative Report           Budget Office       the legislature            report             warehouse     On demand    Annual          CSG
                                                                                                                            Corporate
                                                                           Retrieve data used for        1 Excel            Personnel
                 One Percent Legislative Report-Covered                    1% Budget Report for          spreadsheet or pdf data
SR16336B         Comp                                   Budget Office      the legislature               report             warehouse     On demand    Annual          CSG             No
                                                                           Use selection
                                                                           parameters to retrieve                           Corporate
                                                                           earnings data for                                Personnel
                 W2, Total Gross & Base Pay Earnings by                    employees by                  1 Excel            data
SR81462          TUC and Calendar Year                  HR-Labor Relations bargaining unit               spreadsheet        warehouse     On demand    On request      CSG             No



                                                       Compensation                                                         Title Code
                                                       Policy and Planning, Produce Appendix A           1 Excel            System in
                 Appendix A-Barg Unit Comp Rates Rept- campus               report for labor union       spreadsheet or pdf data
TCSH0101         Open Range                            compensation units contracts                      report             warehouse     On demand    On request      CSG             No
                                                                                                                            Corporate
                                                                                                                            Personnel                                                            Report has
                                                                                                                            System                                                               been run for
                                                                              Produce spreadsheet for                       (CPS) and                                                            December
                                                                              distribution to campuses                      UC                                                                   2008; future
Rehired                                                                       to ensure compliance                          Retirement                                                           schedule is
Retirees         Employees who are Employed at any UC     HR Compliance       with new policy on       1 Excel              System        Not yet in   Quarterly or    MVS (CPS and              undetermined
Report           location after retiring from UCRP        Unit                rehired retirees         spreadsheet          (UCRS)        production   semi-snnual     UCRS)           Not yet   at this time
Enterprise
Risk                                                                                                                        Corporate
Management       Extract of employee data for the         Risk Management                                                   Personnel
extract (no      Enterprise Risk Management dashboard     units at UCOP and   Provide data for ERM       1 comma-           data          Not yet in                   WebFocus MRE
report id yet)   implemented by IBM                       Campuses            dashboard                  delimited file     warehouse     production   Monthly         (will be in CSG) No




2/3/2011                                                                                               Page 22 of 23                                                  d9602e34-3686-4150-864e-deae27380209.xls
Production Reports Produced from Corporate Personnel System and Corporate Personnel Data Warehouse
effective 2/3/2011




 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

                                                                                                        No of
                                                                                                        Reports/Files                    Production/                          In
                                                         Requesting                                     Produced from                    Recurring/                           Document
Job ID         Report Name                               Dept                Purpose of Report          this job      System             One-Time    Frequency    Environment Direct   Comments

                                                                                                                                                                                          Historical
                                                                                                                                                                                          extracts have
                                                                                                                                                                                          been run and
Davis                                                                                                                                                                                     provided;
employee,                                                                                                                                                                                 monthly
appointment,                                                                                                                 Corporate                                                    extracts will be
and            Extract of all Davis employee,            Consortium of                                 3 comma-              Personnel                                                    created and
distribution   appointment, and earnings data for past   departments at UC                             delimited files for   data        Not yet in               WebFocus MRE            ftp'd to Davis
extracts       10 years                                  Davis               Provide data for analysis each cycle            warehouse   production   Monthly     (will be in CSG) No     indefinitely




2/3/2011                                                                                            Page 23 of 23                                                d9602e34-3686-4150-864e-deae27380209.xls

				
DOCUMENT INFO
Description: Excel Spreadsheets Reports document sample