List of basic job-related information for all employees current as of the prompted date.
Prompts:

• Department – Select one Department
• Include All Org Levels?
  • Y – Include all Departments that report to the selected Department
  • N – Only include the selected Department
• Roster Date – Enter as of date.
• Org Hierarchy as of:
  • Today – Hierarchy as of the report run date
  • Roster – Hierarchy as of the Roster Date
• Employee Group(s) – Select one or more of the options
• Union(s) – Select one or more of the options.
• Employee Type(s) – Select one or more the options.
  • Faculty – Unclassified (Employee Group UNCL) with an Academic Rank of Professor, Assistant Professor, Associate Professor, Extension Educator, Instructor or Lecturer.
  • Staff – All other Unclassified (Employee Group UNCL)
  • Grads – Employee Group UGR
  • Special Payroll – Employee Group USPN or USPT
  • Student Payroll – Employee Group USL or UWS
• Title(s) – Select one or more of the options.
• Include Gratis?
  • Y – Include Gratis Appointments
  • N – Exclude Gratis Appointments
• Output – Select one of the options.

Produces an Excel file with two worksheets – “Net Hires” and “All Hire & Cancel Hire Actions”.
Prompts:

• Department – Select one Department
• Include All Org Levels?
  • Y – Include all Departments that report to the selected Department
  • N – Only include the selected Department
• Employee Group(s) – Select one or more of the options
• Union(s) – Select one or more of the options.
• Title(s) – Select one or more of the options.
• Include Gratis?
  • Y – Include Gratis Appointments
  • N – Exclude Gratis Appointments
• Job Rows Effective From – (optional) Set the starting/oldest Action Effective Date
• Job Rows Effective Through – (optional) Set the ending/newest Action Effective Date
• Job Rows Posted From – (optional) Set the starting/oldest Action Posted Date
• Job Rows Posted Through – (optional) Set the ending/oldest Action Posted Date
  Note – if no dates are entered the report will evaluate job rows from CoreCT go-live (9/16/2016) through the date on which the report is run.
• Still Active?
  • Y – Employee is still active in some capacity at UConn. May be on a different job.
  • N – Employee is not active in any capacity at UConn.

Produces Excel file with two worksheets – “Net Separations” and “All Seps & Cancel Sep Actions”.
Prompts:

• Department – Select one Department.
• Include All Org Levels?
  • Y – Include all Departments that report to the selected Department
  • N – Only include the selected Department
• Employee Group(s) – Select one or more of the options.

• Union(s) – Select one or more of the options.
• Title(s) – Select one or more of the options.
• Include Gratis?
  • Y – Include Gratis Appointments
  • N – Exclude Gratis Appointments
• Job Rows Effective From – (optional) Set the starting/oldest Action Effective Date
• Job Rows Effective Through – (optional) Set the ending/newest Action Effective Date
• Job Rows Posted From – (optional) Set the starting/oldest Action Posted Date
• Job Rows Posted Through – (optional) Set the ending/oldest Action Posted Date
  Note – if no dates are entered the report will evaluate job rows from CoreCT go-live (9/16/2016) through the date on which the report is run.
• Still Active?
  • Y – Employee is still active in some capacity at UConn. May be on a different job.

N – Employee is not active in any capacity at UConn.

Probation End Date Monitoring
List of active unclassified employees whose Probation End Date has expired or will expire within 30 days.
Prompts:

• Department – Select one Department
• Include All Org Levels?
  • Y – Include all Departments that report to the selected Department
  • N – Only include the selected Department
    • Output – Select one option.

Employee History
List of all CoreCT job rows for one employee at a time.
Prompts:

• Employee ID – Enter 6-digit Emplid and/or NetID.
• Empl Record – Select one or more of the options.
• NetID – Enter 8-character NetID and/or Employee ID.
• Employee Group(s) – Select one or more of the options.
• Union(s) – Select one or more of the options.
• History
  • All – All job history rows
  • Corrected – Only display the newest job row for each Effective Date (aka job rows with max Effective Sequence by Employee ID, Employee Record & Effective Date)
• Output – Select one of the options.

Lookup Employees by Legal Name, NetID or Emplid.
Output always runs to HTML and you can enter all of part of any fields.
Prompts:

• Employee Last Name (optional)
• Employee First Name (optional)
• Employee ID (123456) – Enter 6-digit Emplid (optional)
• NetID (abc12345) – UConn NetID (optional)

Lookup Employees by Legal Name, NetID or Emplid.
Output always runs to HTML and you can enter all or part of any fields.
Note: If you click the link to Employee History there will be additional prompts.
Prompts:

• Employee Last Name (optional)
• Employee First Name (optional)
• Employee ID (123456) – Enter 6-digit Emplid (optional)
• NetID (abc12345) – UConn NetID (optional)
  Note: If you click the link to Employee History or Employee Latest Info there may be additional prompts.

Descriptive list of fields available in the datamart.
Prompts:

• Output – Select one option.

• Need to add text
  

List of Jobcode and Titles based on prompts.
Prompt:

• Jobcode and Title – Enter any part of the Jobcode or Title.

List of the Organization Hierarchy as of the prompted date.
Prompts:

• Tree Date – Select one of the options.
• Department – Type the full department code. (optional)
• Output – Select one of the options.

Daily snapshot of the university-wide employee population broken down by generation.
Prompts:

• Employee Type – Select one or more Employee Type

Daily snapshot of the university-wide employee population broken down by Employee Type.
Prompts:

• Employee Type – Select one or more Employee Type

November 1^st snapshot of the headcount over the last 10 years. The most recent year is updated daily.
Prompts:

• Employee Type – Select one or more Employee Type