|
|
|
|
|
|
|
|
|
|
|
|
|
Key: |
|
|
|
|
|
|
|
|
|
|
|
Environment: MVS = produced automatically from
mainframe |
|
|
|
|
|
|
|
|
CSG = report run by customers from Corporate
Systems Gateway |
|
|
|
|
|
|
|
|
Document Direct: a web-based report repository owned by Human
Resources and Benefits |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Job ID |
Report Name |
Requesting Dept |
Purpose of Report |
No of Reports/Files Produced from this job |
System |
Production/Recurring/ One-Time |
Frequency |
Environment |
In Document Direct |
Comments |
|
|
|
|
|
|
|
|
|
|
|
|
|
DEPRPT1 |
Report and Labels for Overage Dependents |
HR&B-Program Planning & Design |
Benefits analysis and employee notification |
1 report, 5 sets of labels |
Corporate Personnel/Dependent Data system |
Production |
Monthly |
MVS |
Yes |
|
|
DEPRPT2 |
Counts of Emps and Deps by Location, Coverage Plan, Dep Relationship |
HR&B-Program Planning & Design |
Benefits analysis |
2 reports |
Corporate Personnel/Dependent Data system |
Production |
Monthly |
MVS |
Yes |
|
|
DEPRPT3 |
Average Number of Dependents by Location, Health Plan |
HR&B-Program Planning & Design |
Benefits analysis |
2 reports |
Corporate Personnel/Dependent Data system |
Production |
Monthly |
MVS |
Yes |
|
|
DEPRPT4 |
Average Number of Children by Location by Personnel Program |
HR&B-Program Planning & Design |
Benefits analysis |
1 report |
Corporate Personnel/Dependent Data system |
Production |
Monthly |
MVS |
Yes |
|
|
DEPRPT5 |
Listing of all Dependents Enrolled as Wards |
HR&B-Program Planning & Design |
Benefits analysis |
1 report |
Corporate Personnel/Dependent Data system |
Production |
Monthly |
MVS |
Yes |
|
|
DEPRPT6 |
Listing and labels for all Spouses and Adult Dependent Relatives who
will be turning 65, or employees who are turning 65 |
HR&B-Program Planning & Design |
Benefits analysis and employee notification |
1 report, 1 set of labels |
Corporate Personnel/Dependent Data system |
Production |
Quarterly |
MVS |
Yes |
|
|
DEPRPT8 |
Medical coverage and premium information for domestic partners, adult
dependent relatives, |
HR&B-Program Planning & Design |
Benefits analysis |
3 reports, 3 Excel spreadsheets |
Corporate Personnel/Dependent Data system |
Production |
Quarterly |
MVS |
Yes |
|
|
FCPAA2 |
EE06 - Supplement Rpts. |
Academic Advancement, HR Client Relations & Diversity |
Provides required data for EEOC |
3 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPAA3 |
Invalid Sex, Ethnicity, and Citizenship Codes |
Academic Advancement, HR Client Relations & Diversity |
Error report to be used to request corrections to Payroll |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
No |
|
|
FCPAA5 |
Profile of Professorial Series & Equiv. Ranks |
Academic Advancement |
Faculty/Academic Profile |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA6 |
Age Distribution within Prof. Series, Equiv., SOE/FTE |
Academic Advancement |
Faculty analysis |
6 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA7 |
Undupl. Cnt. of Handicapped Employees |
HR&B Sr Mgmt Compensation, Policy, and Recruitment |
Workforce analysis |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPAA10 |
New Appointees - Disc., Rank, Salary, Sex, Ethnicity |
Academic Advancement |
Faculty analysis |
4 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA11 |
New Appointees - Origins of Recruitment |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA12 |
New Appointees - Disc., Rank, Yr. of Doctorate, Sex, Ethnicity |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA13 |
Faculty Promoted - Disc., Sex, Ethnicity |
Academic Advancement |
Faculty analysis |
3 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAA16 |
Counts of MSP & SMG Emps. by Sal. Range, Ethnicity & Gender |
HR Client Relations & Diversity |
Workforce diversity analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPAA17 |
DOE Lab Headcount by Gender and Ethnicity |
HR Client Relations & Diversity |
Workforce diversity analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPAA19 |
Composition of UC Workforce |
HR Client Relations & Diversity |
Affirmative Action Plan |
1 report, 6 Excel spreadsheets |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPAP1 |
Headcnt. & FTE - Acad - By CTO |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPAP2 |
Headcnt. & FTE - Acad - by Health Sci./General Campus |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPAP3 |
FTE, HDCT, Ave. Salary - General Campus/Health Sci. |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPAP4 |
Appointments, Promotions/Separations - Sex, FTE |
Academic Advancement |
Faculty analysis |
4 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP5 |
Full/Part Time - HDCT, FTE, General Campus/Health Sci |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPAP6 |
Ave. Age within Faculty - General Campus/Health Sci. |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP9 |
Age Distribution - Professorial Series |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP10 |
Origins of New Appointees - General Campus |
Academic Advancement |
Faculty analysis |
3 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP11 |
Destination of Voluntary Separations - General Campus |
Academic Advancement |
Faculty analysis |
3 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP12 |
Reasons for Separations |
Academic Advancement |
Faculty analysis |
6 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP13 |
Profile of Prof. Series - Disc., Sex, FTE, Salary, Age |
Academic Advancement |
Faculty analysis |
6 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPAP16 |
Comparison of Above Scale with Tot. Population |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP17 |
Above Scale Salaries by Rank |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP18 |
New Appointments |
Academic Advancement |
Faculty analysis |
6 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP19 |
Faculty Appointed since July 1 |
Academic Advancement |
Faculty analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP21 |
Produce faculty salary survey report used for US News & World Report
survey |
Academic Planning and Analysis |
US News & World Report survey |
12 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPAP22 |
Produce faculty instructional activity reports |
Academic Planning and Analysis |
Faculty FTE reports |
15 reports, 15 Excel spreadsheets |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPBAP1 |
Actual Salary Expenditures - by Fund & LOC |
Budget Office |
Budget analysis |
2 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPBAP4 |
Actual I & R Salary Expenditures |
Budget Office |
Budget analysis |
1 report, 1 Excel spreadsheet |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPCDTL |
Chronicle detail file |
Payroll Coordination, Audit |
Pre-publication analysis of UC compensation |
1 extract file |
Corporate Personnel System |
Recurring |
On request |
MVS |
No |
|
|
FCPCER1 |
Academic Compensation Budget Request - FTE/Salary |
Academic Advancement |
Budget analysis |
1 report |
Corporate Personnel System |
Production |
5 times per year |
MVS |
Yes |
|
|
FCPCER2 |
Academic Compensation Budget Request - General Campus |
Academic Advancement |
Budget analysis |
1 report |
Corporate Personnel System |
Production |
5 times per year |
MVS |
Yes |
|
|
FCPCER3 |
Campus Linkage Code Tables (on request) |
HR Compensation Policy |
Compensation and labor analysis |
3 reports |
Corporate Personnel System |
Production |
On request |
MVS |
Yes |
|
|
FCPCER4 |
Incumbents in Frozen Titles |
HR Compensation Policy |
Compensation analysis |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPCER5 |
Incumbents in Abolished Titles |
HR Compensation Policy |
Compensation analysis |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPCGX1 |
HDCT by LOC, Citzenship Status & Fund Source |
Laboratory Administration |
Lab staffing analysis |
1 report |
Corporate Personnel System |
Production |
Quarterly |
MVS |
No |
|
|
FCPCSUM |
Chronicle summary file |
Payroll Coordination, Strategic Communications |
Public disclosure of compensation |
1 extract file, 1 to 11 pdf files, 1 report |
Corporate Personnel System |
Recurring |
On request |
MVS |
No |
|
|
FCPEPRSM |
Extract for Mercer ePRISM database |
HR Compensation Policy and Programs |
Compensation analysis and comparisons |
1 extract file |
Corporate Personnel System |
Production |
Quarterly |
MVS |
No |
|
|
FCPER1 |
Stat. Sum. - Admin., Acad., & Staff - FTE & Headcnt. |
Multiple departments, Regents |
Used for various statistical summary reports,publication on Statistical
Summary website, and for the annual Statistical Summary of Students and
Staff |
1 Excel spreadsheet, 7 reports, 26 pdf files |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPER2 |
Stat. Sum. - Admin., Acad., & Staff - Sex & Ethnicity |
Multiple departments, Regents |
Used for various statistical summary reports,publication on Statistical
Summary website, and for the annual Statistical Summary of Students and
Staff |
2 reports, 1 Excel spreadsheet |
Corporate Personnel System |
Production |
Monthly |
MVS |
No |
|
|
FCPER3 |
AAUP Faculty Salary & Fringe Benefits Survey |
Academic Advancement |
Used for annual AAUP survey |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPER5 |
Census Bureau Survey of Govt. Employment |
Submitted to Census Bureau by IR&C |
Annual survey provided to Census Bureau |
2 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPER7 |
(same as ER2 - by Personnel Prog & Appt type) |
HR Client Relations & Diversity |
Affirmative Action Plan |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPER8 |
Employees with more than one appointment |
Multiple departments |
To troubleshoot possible problems in payroll |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
No |
|
|
FCPER9 |
Stat. Summ by Fundsource |
Multiple departments, campus IR units |
Staff funding analysis |
4 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPER10 |
Stat. Summ Excl. Health Sci. |
Multiple departments, campus IR units |
FTE and headcount analysis |
2 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPICS |
Salaries & Wages of Professionals & Non-Professionals |
Financial Management |
Indirect cost reporting |
3 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPIMX3 |
Academic Health Sciences Edit |
Academic Advancement |
Data verification |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
No |
|
|
FCPMP4 |
Top 100 Paid Faculty |
HR Client Relations & Diversity, HR Sr Mgmt Compensation, Policy, and
Recruitment |
Compensation analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPMP5 |
Executive Program - Affirmative Action Report |
HR Sr Mgmt Compensation, Policy, and Recruitment |
Diversity analysis |
3 reports |
Corporate Personnel System |
Production |
Quarterly |
MVS |
No |
|
|
FCPIPEDS |
IPEDS Human Resources Survey |
Submitted directly by IR&C on behalf of Academic Advancement and HR
Client Relations & Diversity |
NCES IPEDS surveys |
32 extract files |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPNIHSC |
NIH Salary Cap Extract file |
Financial Management |
NIH Salary Cap reporting |
1 extract file |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPOER1 |
Employee Headcount by Personnel Program and Appointment Type |
HR Labor Relations |
Labor relations analysis |
compound pdf containing 5 reports |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPOER2 |
Ethnic Composition of MSP and PSS Employees |
HR Compensation Policy |
Labor relations analysis |
compound pdf containing 10 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPOER3 |
Statistical Summary - FT/PT Headcount (same as FCPER1 except studenta
are excluded) |
HR Compensation Policy |
Labor relations analysis |
compound pdf containing 6 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPOFA1 |
Headcnt & Tot. Dollars of RA's & TA's |
Student Academic Services-Financial Aid |
Student workforce analysis |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPOFA2 |
Headcnt & Tot. Dollars and Tot. FTE of RA's and TA's |
Student Academic Services-Financial Aid |
Student workforce analysis |
2 reports |
Corporate Personnel System |
Production |
Monthly |
MVS |
No |
|
|
FCPOIR1 |
Same as ER1.3 - excl students - BK only |
UCB Institutional Research unit |
Institutional research |
1 report |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
No |
|
|
FCPOLR1 |
Title Unit Code by Location |
HR Labor Relations |
Labor relations analysis |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPOLR2 |
% of dues deductions authorized for employees, by represented certified
bargaining unit |
HR Labor Relations |
Labor relations analysis |
3 reports |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPOLR3 |
Empls. represented/not represented by certified bargaining unit |
HR Labor Relations |
Labor relations analysis |
3 reports |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRA01 |
Indirect Cost Calculations |
Financial Management |
Indirect cost reporting |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
No |
|
|
FCPRB1 |
Unemployment Insurance Covered Wages |
HR&B Financial Services |
Financial analysis of benefits |
1 report |
Corporate Personnel System |
Production |
Quarterly |
MVS |
Yes |
|
|
FCPRB6 |
Active Members of Retirement System |
HR&B Financial Services |
Financial analysis of benefits |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB7 |
Benefits Enrollment and Premiums (campuses, labs, & Hastings) |
HR&B-Program Planning & Design |
Benefits planning |
108 reports, 12 Excel spreadsheets |
Corporate Personnel System |
Production |
Quarterly |
MVS |
Yes |
|
|
FCPRB8 |
HDCT of Empl. Status/Elig./Partic. in TIP, Depcare, Medplus |
HR&B Financial Services |
Financial analysis of benefits |
3 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB9A |
Headcount of Employees Participating in TIP |
HR&B Financial Services |
Financial analysis of benefits |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB9B |
Headcnt. of Empl. Participating in TIP/Depcare rpts. |
HR&B Financial Services |
Financial analysis of benefits |
1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB11 |
Open Enrollment (campus, labs, Hastings, & ASUCLA) |
HR&B-Program Planning & Design |
Open Enrollment analysis |
39 reports, 7 Excel spreadsheets |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB12 |
Employee Turnover reports - by Personnel Prog & Appt Type |
HR&B-Program Planning & Design |
Staff turnover analysis |
14 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB13 |
Prudential Enrollees - Tape |
HR&B-Program Planning & Design |
To provide information to insurance carriers |
1 report, 1 extract file |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB14 |
List of Executive Program Employees |
HR Sr Mgmt Compensation, Policy, and Recruitment |
Senior management analysis |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB21 |
S89-Eligibility Test reports |
HR&B-Program Planning & Design |
To ensure compliance with IRS regulations |
28 reports, 1 Excel spreadsheet |
Corporate Personnel System |
Production |
Quarterly |
MVS |
Yes |
|
|
FCPRB22 |
S89-Special Status reports |
HR&B-Program Planning & Design |
To ensure compliance with IRS regulations |
|
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPRB23 |
S89-Depcare 55% Ave. Benefits Test reports |
HR&B-Program Planning & Design |
To ensure compliance with IRS regulations |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB24 |
S89-Empl. on Leave of Absence |
HR&B-Program Planning & Design |
Benefits eligibility analysis |
8 reports |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB26 |
BELI Reports |
HR&B-Program Planning & Design |
Benefits eligibility analysis |
10 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPRB27 |
Benefits Status Qualification Code Reports |
HR&B-Program Planning & Design |
Benefits eligibility analysis |
2 reports |
Corporate Personnel System |
Production |
Semi-annual |
MVS |
Yes |
|
|
FCPRB31/32 |
COBRA - Campus Extract and Report |
HR Client Relations & Diversity |
Notify new employees of COBRA eligibility |
3 reports, 1 extract file |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB33 |
Employee Headcount, Average Age, and Average Wage |
HR&B Info Systems |
Workforce analysis |
2 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB34/35 |
COBRA - Lab, Hastings & ASUCLA Extract and Report |
HR Client Relations & Diversity |
Notify new employees of COBRA eligibility |
3 reports, 1 extract file |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB36 |
COBRA - Campus, Lab, Hastings & ASUCLA mailing files |
HR Client Relations & Diversity |
Provide UC Mailing Services with file to use for mailing COBRA notices |
1 report, 2 extract files |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB37 |
Benefits Enrollment and Premiums (campuses, labs, & Hastings) by title
unit code |
HR&B-Program Planning & Design |
Benefits planning |
21 reports, 11 Excel spreadsheets |
Corporate Personnel System |
Production |
Quarterly |
MVS |
Yes |
|
|
FCPRB38 |
TIP Average Benefits Test A |
HR&B-Program Planning & Design |
To ensure compliance with IRS regulations |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB39 |
HCRA Average Benefits Test B |
HR&B-Program Planning & Design |
To ensure compliance with IRS regulations |
1 report |
Corporate Personnel System |
Production |
Monthly |
MVS |
Yes |
|
|
FCPRB41 |
Benefits Open Enrollment reports by bargaining unit |
HR&B-Program Planning & Design |
Benefits planning |
7 Excel spreadsheets, 16 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB42 |
Benefits Open Enrollment reports -changes to coverage codes by
bargaining unit |
HR&B-Program Planning & Design |
Benefits planning |
2 Excel spreadsheets, 6 reports |
Corporate Personnel System |
Production |
Annual |
MVS |
Yes |
|
|
FCPRB44 |
HR Benefits Briefing mailing files |
HR Client Relations & Diversity |
Provide UC Mailing Services with file to use for mailing HR Benefits
Briefing mailings |
2 extract files, 1 report |
Corporate Personnel System |
Production |
Approx 6 times per year on request |
MVS |
|
|
|
FCPRB45 |
HR Benefits Active Employee Open Enrollment Mailing files |
HR Client Relations & Diversity |
Provide UC Mailing Services with file to use for mailing HR Benefits
communications to employees |
1 extract file |
Corporate Personnel System |
Production |
On request |
MVS |
Record counts only |
|
|
FCPRB46 |
Imputed Income Employee mailing file |
HR Client Relations & Diversity |
Provide UC Mailing Services with file to use for mailing to employees
with benefits coverage for domestic partners/domestic partners'
dependents |
2 extract files, 2 Excel spreadsheets, 1 report |
Corporate Personnel System |
Production |
Annual |
MVS |
Record counts only |
|
|
FCPRB47 |
Counts of employees and dependents by dependent relation code |
HR&B-Program Planning & Design |