Description: A list of active and terminated employees.
Filters: Employee ID, Status, Employee Group, Employee Class, Division/College, Home Organization, Bargaining Unit, *Gender, *Birth Date, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Status, Employee Class, Employee Class Description, Employee Group, Employee Group Description, Original Hire Date, Current Hire Date, Adjusted Service Date, Seniority Date, First Work Date, Last Work Date, Termination Date, *Termination Code, *Termination Reason, Division, Division Description, Home Organization Code, Home Organization Description, Distribution Organization, Bargaining Unit, Bargaining Unit Description, Email, Citizen, Confidential Indicator, Deceased Indicator, I9 Indicator, I9 Date, I9 Expire Date, *Gender, *Birth Date, *W2 Consent, *W2 Consent Date, *Ethnic Code (Old), *Ethnic Code (New), *Race, *Race 1, *Race 2, *Race 3, *Race 4, *Race 5, *Ethnic Confirm, *Ethnic Confirm Date, *Veteran Code, *Special Disabled Veteran, *Armed Forces Service Medal, *Active Duty Separation Date
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: Information for a specific employee. This is also the report that is linked to (drill-down) from many of the other reports.
Filters: Employee ID
Columns: Name, Employee ID, Date of Birth*, Gender*, Employee Class, Home Organization, Employee Group Code, First Hire Date, Current Hire Date, Seniority Date, Service Date, Address Type, Address, City, Zip Code, Phone Number, Email Code, Email Address, Bargaining Unit, Bargaining Unit Description, Bargaining Unit Relationship Code, Bargaining Unit Relationship Description, Seniority, End Date, Position, Suffix, Status, Description, Annual Salary, Employee Code, Job Class, Begin Date, End Date, Salary Grade, Class, Job Appointment Percent, Job FTE
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of active employees with an active job(s).
Filters: Employee ID, Employee Class, Job Class, Division/College, Home Organization, Bargaining Unit, Original Hire Date, Current Hire Date, *Gender
Columns: Employee ID, Name, Last Name, First Name, Preferred First Name, Status, Employee Class, JobClass, Employee Class Description, Original Hire Date, Current Hire Date, Division, Division Description, Home Organization, Home Organization Description, Bargaining Unit, Bargaining Unit Description, Position, Suffix, Job Title, *Gender
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of terminated employees (see notes below).
Filters: Employee ID, Employee Class, Division/College, Home Organization, Date Terminated, Last Worked Date, *Gender, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Preferred First Name, Employee Class, Employee Class Description, Last Work Date, *Termination Code, *Termination Reason, Termination Date, Division, Division Description, Home Organization, Home Organization Description, *Gender, *DOB, *Age at Term, Status, Deceased Indicator
Filters or Columns identified with an asterisk are restricted data elements.
Notes:
This list includes individuals that have terminated and come back at a later point. See the 'Status" column for an employee's current status.
The employee class is the individual's "current" class, which may not be the same as what their class was when they terminated.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of employees that includes their anniversary date (adjusted service date).
Filters: Employee ID, Job Status, Employee Class, Division/College, Home Organization, Adjusted Service Month (Anniversary), Adjusted Service Date (Anniversary), Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Preferred First name, Status, Employee Class, Employee Class Description, Division, Division Description, Home Organization, Home Organization Description, Adjusted Service, *Gender, Deceased Indicator
Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of employees, active and terminated, and their office contact information.
Filters: Address Type, Employee ID, Status, Employee Group, Employee Class, Division/College, Home Organization, Bargaining Unit, Deceased Indicator
Columns: Employee ID, Last Name, First Name, Preferred First name, Professional Name, Employee Class, Employee Class Description, Employee Group, Employee Group Description, Division, Division Description, Home Organization, Home Organization Description, Bargaining Unit, Bargaining Unit Description, Address Type, Address, Address 2, Address 3, City, County, State, Zip Code, Nation, Email, Phone Number, Add. Type, Seq, Source, Deceased Indicator
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A report of employees, their reviewer, and review dates.
Filters: Employee ID, Status, Employee Group, Employee Class, Division/College, Home Organization, Reviewer ID, Reviewer Class, Review Type, Due Date, Completed Date, Completed Indicator, Deceased Indicator
Columns: Employee ID, Last Name, First Name, Status, Employee Class, Employee Class Description, Employee Group, Employee Group Description, Home Organization, Home Organization Description, Division, Review Type, Review Type Description, Review Due Date, Review Completed, Review Completed Date, Reviewer ID, Reviewer Last Name, Reviewer First Name, Reviewer Employee Class, Reviewer Employee Class Description, Deceased Indicator, Review Rating, Review Comments, Activity Date
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, August 2011
Last Updated: October 2012
Description: A list of all current active positions and the incumbent employee in the position. One row per position.
Filters: Employee ID, Position Status, Position Employee Class, Position Class, Position, Position Start Date, Bargaining Unit, Position End Date, Position Organization
Columns: Position, Suffix, Position Title, Position Type, Position Status, Employee ID, Name, Last name, First Name, Preferred First Name, Position Employee Class, Employee Class Description, Position Class, Position Class Description, Position Organization, Position Organization Description, Begin Date, End Date, Appointment %, Bargaining Code, Bargaining Description, Reports To ID, Reports To Last Name, Reports To First Name, Reports To Title, Position History, Incumbent History
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of positions and changes in the position. A position may appear more than once depending on changes made in the past to a position.
Filters: Position Employee Class, Position Class, Position
Columns: Position, Position Title, Position Class, Position Class Description, Position Employee Class, Employee Class Description, *Salary Table, Salary Grade, Step, Appointment %, Bargaining Unit, Bargaining Unit Description, Budget Type, FLSA Exempt Indicator, FLSA Exempt Reason Code, Activity Date
Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of positions and the incumbent employee is the position. A position may appear more than once depending on changes made in the past to a position.
Filters: Position Employee Class, Position Class, Position
Columns: Position, Suffix, Position Title, Status, Employee ID, Name, Last Name, First Name, Preferred First Name, Job Class, Position Employee Class, Employee Class Description, Position Class, Position Class Description, *Salary Table, Salary Grade, Salary Step, Annual Salary, Personnel Date
Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of pay grades for the current fiscal year <<HR Only>>
Filters: Group Code, Salary Group
Columns: Year, Group, Grade, Group Description, Low Point, Mid Point, High Point
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of active employees and their "Primary" job.
Filters: Employee ID, Job Status, Position, Suffix, Employee Group, Job Class, Employee Class, Change Reason, Job Change Type, Division/College, Home Organization, Time Sheet Organization, *Effective Date
Columns: Position, Suffix, Job Title, Job Type, Status, Employee ID, Name, Last name, First Name, Preferred First Name, Job Class, Job Class Description, Job Change Type, Job Change Type Description, Job Change Reason, Job Change Reason Description, Employee Class, Employee Class Description, Employee Group, Employee Group Description, Division, Division Description, Home Organization, Home Organization Description, Time Sheet Organization, Time Sheet Description, Distribution Organization, Effective Date, Begin Date, End Date, Contract Begin Data, Contract End Date, Change Date, Inc Day, Inc Month, Time Entry Method, *Salary Table, Salary Grade, Salary Step, Factors, Pays, Appointment Length, Annual Basis, Base Units, Job Appointment %, Appointment %, Job FTE, Annual FTE, Hourly Rate, Semi-Monthly Salary, Annual Salary, Actual Salary, Last Date Paid, Labor Codes
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: November 2012
Description: A list of active employees and their current job or jobs (primary, secondary and overload).
Filters: Employee ID, Job Status, Job Type, Position, Suffix, Employee Group, Job Class, Employee Class, Change Reason, Job Change Type, Division/College, Home Organization, Time Sheet Organization, *Effective Date
Columns: Position, Suffix, Job Title, Job Type, Job Status, Employee ID, Name, Last name, First Name, Preferred First Name, Job Class, Job Class Description, Job Change Type, Job Change Type Description, Job Change Reason, Job Change Reason Description, Employee Class, Employee Class Description, Employee Group Code, Employee Group Description, Division, Division Description, Home Organization, Home Organization Description, Time Sheet Organization, Time Sheet Description, Effective Date, Begin Date, End Date, Change Date, Contract Begin Data, Contract End Date, Increment Month, Increment Day, Time Entry Method, *Salary Table, Salary Grade, Salary Step, Factors, Pays, Appointment Length, Annual Basis, Base Units, Job Appointment %, Appointment %, Job FTE, Annual FTE, Hourly Rate, Semi-Monthly Salary, Annual Salary, Actual Salary, Last Date Paid, Labor Codes
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of active and terminated employees and their job or jobs (primary, secondary and overload).
Filters: Employee ID, Job Status, Current Employee Class, Job Type, Position, Suffix, Employee Group, Job Class, Change Reason, Job Change Type, Current Division/College, Current Home Organization, Time Sheet Organization, *Effective Date, End Date, Deceased Indicator
Columns: Position, Suffix, Job Title, Job Type, Job Status, Employee ID, Name, Last name, First Name, Preferred First Name, *Contract Number, Job Class, Job Class Description, Job Change Type, Job Change Type Description, Job Change Reason, Job Change Reason Description, Current Employee Class, Current Employee Class Description, Employee Group Code, Employee Group Description, Current Division, Current Division Description, Current Home Organization, Current Home Organization Description, Time Sheet Organization, Time Sheet Description, Distribution Organization, Effective Date, Begin Date, End Date, Job Change Date, Contract Begin Data, Contract End Date, Increment Month, Increment Day, Time Entry Method, *Salary Table, Salary Grade, Salary Step, Factors, Pays, Appointment Length, Annual Basis, Base Units, Job Appointment %, Appointment %, Job FTE, Annual FTE, Hourly Rate, Semi-Monthly Salary, Annual Salary, Actual Salary, Last Date Paid
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: Provides job labor distribution based on search.
Filters: Employee ID, Position, Suffix, Division/College, Fund, Organization, Account, Program
Columns: Position, Suffix, Position Description, Employee ID, Name, Employee Class, Employee Class Description, Division, Division Description, Chart, Fund, Organization, Account, Program, Activity, Location, Labor Distribution %, Change Index, Activity Date
Created by: Millennium, September 2010
Last Updated: October 2012
Description: A list of active employees and their current leave balances.
Filters: Employee ID, Home Organization, Division/College, Employee Class
Columns: Employee ID, Name, Last Name, First Name, Sick Balance, Vacation Balance, Personal Holiday Balance, Personal Leave Day Balance, Comp Balance, Holiday Comp Balance, Shared Leave Balance, Employee Class, Employee Class Description, Division, Division Description, Home Organization, Home Organization Description
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of active employees with their leave balance, accrued, taken and available by a specific leave code
Filters: Leave Type (Required Entry), Employee ID, Status, Division/College, Home Organization, Employee Class, Adjusted Service Date, Vacation Anniversary Month
Columns: Employee ID, Name, Last Name, First Name, Beginning Balance, Accrued, Hours Banked, Taken, Available, Anniversary Month, Adjusted Service Date, Status, Job Class, Employee Class Description, Division, Division Description, Home Organization, Home Organization Description, Distribution Organization
Notes:
In this report the vacation (VAC) leave amounts are calculated from the anniversary (adjusted service) date. All other leave calculation are based on the calendar year.
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of employee's leave, accrued and taken by pay period.
Filters: Employee ID, Employee Class, Division/College, Pay Number, Calendar, Leave Code, Home Organization
Columns: Year, Employee ID, Name, Last Name, First Name, Leave Code, Accrued, Taken, Activity Date, Pay Number, Employee Class, Employee Class Description, Division, Division Description, Home Organization, Home Organization Description
Created by: Millennium, September
2010
Last Updated: October 2012
Description: A list of employees pay by earning job and earn code
Filters: Earn Code, Employee ID, Employee Class, Calendar, Pay Number, Pay Sequence, Division/College, Fiscal Year, Home Organization, Time Sheet Organization, Effective Date, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Fiscal Year, Pref First, Status, Employee Class, Employee Class Description, Earn Code, Earn Code Description, Year, Pay No, Sequence Number, Last Paid Date, Hours, Step Inc Mon, Rate, Amount, Step Inc Day, Job Sal Table, Job Sal Grade, Job Sal Step, Job Appt Pct, Job FTE, Position Number, Suffix, Job Title, Effective Date, Division, Division Description, Home Organization, Home Organization Description, TS Organization, Time Sheet Description, *DOB, *SSN, Deceased
Columns identified with an asterisk are restricted data elements.
Created by: Millennium, September
2010
Last Updated: November 2012
Description: A summary of Faculty members.
Filters: Employee ID, Status, Employee Class, Faculty Type, Primary Activity, Emeritus Status, Division/College, Home Organization, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Status, Employee Class, Employee Class Description, Academic Title, Emeritus Status, Faculty Type, Primary Activity, Begin Date, End Date, Division/College, Division/College Description, Home Organization, Home Organization Description, RK, TN, LV, Deceased
Created by: Millennium, December 2011
Last Updated: October 2012
Description: A list of Faculty with their leave information.
Filters: Employee ID, Status, Employee Class, Leave Code, Academic Year, Academic Term, Requested Begin Date, Requested End Date, Approved Begin Date, Approved End Date, Division/College, Home Organization, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Status, Employee Class, Employee Class Description, Tenure Code, Tenure Description, Rank, Rank Description, Leave Code, Leave Description, SBTY, SBTY Description, Requested Begin Date, Requested End Date, Approved Begin Date, Approved End Date, Action, Academic Term, Academic Term Description, Academic Year, Comment, Division/College, Division/College Description, Home Organization, Home Organization Description, Deceased Indicator
Created by: Millennium, December 2011
Last Updated: November 2012
Description: A list of Faculty with their rank information.
Filters: Employee ID, Status, Employee Class, Rank, Emeritus Status, Division/College, Home Organization, Deceased Indicator
Columns: Employee ID, Last Name, First Name, Status, Employee Class, Employee Class Description, Academic Title, Emeritus Status, Rank, Rank Description, Rank Effective Date, Tenure Description, Appointment Next Review Date, Activity Date, Division/College, Division/College Description, Home Organization, Home Organization Description, Deceased Indicator
Created by: Millennium, December 2011
Last Updated: October 2012
Description: A list of Faculty with their appointment and tenure information.
Filters: Employee ID, Status, Employee Class, Faculty Type, Tenure, Begin Date, End Date, Division/College, Home Organization, Deceased Indicator
Columns: Employee ID, Name, Last Name, First Name, Status, Employee Class, Employee Class Description, Faculty Type, Tenure Code, Tenure Description, Begin Date, End Date, Appointment Effective Date, Tenure On Date, Tenure Review Date, Appointment Next Review Date, Division/College, Division/College Description, Home Organization, Home Organization Description, Deceased Indicator
Created by: Millennium, December 2011
Last Updated: October 2012
Description: A list of active employees and their current job or jobs (primary, secondary and overload) at a specific time (i.e., Fall, Winter and Spring quarters).
Filters: Employee ID, Status, Job Type, Position, Suffix, Effective Date, Employee Group, Job Class, Employee Class, Change Reason, Home Organization, Time Sheet Organization, Bargaining Unit, Snapshot Number, Snapshot Date, Snapshot Quarter, Snapshot Year
Columns: Position, Suffix, Job Title, Job Type, Status, Employee ID, Name, Last name, First Name, Job Class, Job Class Description, Job Change Reason, Job Change Description, Employee Class, Employee Class Description, Employee Group Code, Employee Group Description, Division, Division Description, Home Organization, Home Organization Description, Time Sheet Organization, Time Sheet Organization Description, Effective Date, Personnel Date, Begin Date, End Date, Contract Begin Data, Contract End Date, Increment Month, Increment Day, Time Entry Method, *Salary Table, Salary Grade, Salary Step, Hours per Day, Hours per Pay, Factors, Pays, Job Appointment %, Job FTE, Hourly Rate, Semi-Monthly Salary, Annual Salary, Last Paid Date, *Accure Lv, Bargaining Unit, Bargaining Unit Description, *Bargaining Unit Membership, Snapshot Year, Snapshot Quarter, Snapshot Month, Snapshot Date, Snapshot No, Snapshot Term, Snapshot Description
Filters or Columns identified with an asterisk are restricted data elements.
Created by: Millennium, October 2012
Last Updated: October 2012
Page Updated 11.26.2012