State of Connecticut
Core-CT Project
Application:HRMS
Module:Human Resources
Business Process:Meet Regulatory Requirements
Requirement Number:HR205
Requirement Title:Ability to generate Workforce Analysis report sorted by part and full time employees for job codes with less than 25 employees.
Module Leads: Lina Simonu, Lisa Lagus
- Requirement Description
Describe the requirement (gap). Include a description of the delivered PeopleSoft functionality.
The Commission of Human Rights and Opportunities (CHRO) requires that the Workforce Analysis report generate counts of full and part time employees by job group within each agency on an annual basis for job codes with fewer than 25 employees. UCONN has the same requirement. Connecticut’s Workforce Analysis report counts full and part time employees by headcount, not by FTE. PeopleSoft delivers a Workforce Analysis report that counts the number of employees by job title within job group in each department, but does not track the breakdown of full and part time employees.
- Business Need
Provide a justification for the requirement. Include information about frequency, volume, number of users impacted, etc.
The Affirmative Action Regulations (46a-68) determined by the Commission of Human Rights and Opportunities requires that each Agency produce an annual Workforce Analysis report of full and part time employees for each job group . Currently, this information is gathered by the agencies through queries.
- Required By: (Y/N)
Federal ___Agency ____Bargaining Unit ___
State Statutory Y State Regulatory ____State Procedural ____
- Requirement Priority
Medium (High, Medium, Low – please see “Requirements Prioritization Criteria”)
- Recommended Solution
Enter an “X” next to the appropriate category
__X___Process Solution
1__Option Number
______Application Modification
__Option Number
- Explanation for Recommendation
Provide reasons for recommendation. Please do not re-state the description of the solution itself.
Agencies will run queries to produce information needed. This process is currently handled manually except for UCONN/UCONN Health.
- Organizational Impact of Recommendation
Describe the changes to the organization that result from the recommended solution. Include a description of any role, process, statute, or bargaining unit agreement affected.
The Agency HR Specialist would need to be trained to run the query.
- Process Solutions
Describe the possible Process Solutions. Include a description of impacts and benefits of each solution.
Option 1. Create a query to select counts of full and part time employees for each agency by job code, job group, race and gender where the total count of employees within a job code is fewer than 25 employees.
- Application Modifications
Describe the possible Application Modifications. Include a description of impacts and benefits of each solution.
Option 1.
Modification Type (On-line, Batch, Interface, Report, Workflow): Report
Complexity (Easy, Medium, Difficult): Difficult
Description: Modify the PeopleSoft delivered Workforce Analysis Report (PER025) to create a two part report. The first part generates results for job titles within each job group for each agency for only full time employees within a job code with fewer than 25 employees. The second part generates results for job titles within each job group for each agency for only part time employees within a job code with fewer than 25 employees. The full/part time status is pulled from the employee’s job record. In addition, modify the report to run by Agency instead of Company or Establishment.
1 of 210/29/18