Workforce Planning

Workforce Planning is used to develop budgets related to Employees. Items might include Salary and Benefits. The data that you find in this section comes from the Human Capital Management (HCM) pillar in ctcLink. The Workforce database contains all of the dimensions of the financial database in addition to the Employee dimension as this database is used to plan expenses by employee.

Workforce Planning will help to calculate people-related costs by updating the information associated with the employees in your Department on an individual basis. This section includes:

  • Making changes to employee-level attributes which affect financial calculations
  • Reviewing and updating factors (or drivers) that are used to calculate financial results (such as health care costs, pension allocations, and grade level steps)
  • Modeling and reviewing the results of these changes
  • Updating the financial impact of your employee model

The workforce planning broadly categorized in two components: Workforce Assumption and Workforce Expense

In order for data to populate the tables, you must first set your Business Unit.

Workforce Assumption

Local Annual Assumptions

Purpose:  Use this document as a reference for overriding Global Drivers in PBCS.

Audience:  Budget Development Staff

The Local annual Assumption form can be used to override global assumption. An example, Health care cost may be different by college by college. So college may provide own health care cost to calculate correct benefit.

Navigation: Main landing Page > Workforce > Drivers Icon > Global Assumption

  1. From the Main Landing or Home page, select the Workforce button.
on the home page, select Workforce icon
  1. On the left side of the page, select the Workforce Drivers icon (looks like a building under construction and appears  below  the  icon  of  the  person  with  the  graph). The Workforce Drivers words displays when you hover over the icon.
  2. Select the Local Assumption by College tab. Enter the cost. The amount will be shaded or highlighted yellow. Select the Save button to save the data.
local assumption by college tab

UAT Test Case:

Verify that you are able to update your HealthPlanAnnualCost.

Local Step Rate

Purpose: Use this document as a reference for how to view Step Data in PBCS.

Audience: Budget Development Staff

Step Rates are used to calculate the increased salary costs when a classified employee reaches their step anniversary date. The salaries for all qualifying employees are calculated at an individual level and roll up to a department total that map to your financial line items.

Navigation: Home Page > Workforce > Drivers > Local Step Rate by College

  1. Select the Local Step Rate by College tab to view the Salary Step Rate By College page. Understanding the step data will help accurately determine the cost of an employee for the year, so that your can budget for the step increase in the middle of the year if needed.
  2. First time users will need to set their college Business Unit. Select the BusinessUnit NoBU link to open the Select a Member window.
  3. Under the BusinessUnit section, use the search bar or select your college business unit by selecting the arrow icon.
  4. You may have to select the arrow icon twice to populate the business unit check mark.
  5. Select the OK button to return to the Salary Step Rate By College.
First time use, set Business Unit
  1. The Salary Step Rate By College displays. You may have to refresh the page (select another tab and back to Local Step Rate by College tab) to view results. Use the scroll bars to review data.
review results

The SBCTC administrator has already entered the Step Rate table data used to calculate Classified Employee compensation in the form for you.

This form simply allows you to review the Step Rate schedule for Classified employees. This step rate table applies to all classified employees for your college.

UAT Test Case

Verify that you are able to see all of your Classified Salary Rate Schedule.

Local COLA% by college

Purpose:  Use this document as a reference for Editing Local COLA % for your college in PBCS.

Audience:  Budget Development Staff

In this college specific form, you may review the monthly COLA%’s. COLA% was made a monthly assumption so that it could be applied only in the months that are relevant to the respective GL account classification. Using this form and selecting your college, you may override the previously defined global COLA% Assumptions form. You must input a value if you wish to consider a local value.

Navigation: Home Page > Workforce > Drivers > Local COLA% By College

  1. Select the Local COLA% By College tab to view COLA% Assumptions by College.
  2. As an example, if in the local COLA% assumptions form the value are set to each GL account from January to June and you wish to override it with a 0%, you must enter and save a 0 to that month on this form. If the cell is left as a #Missing value (undefined or blank), then the originally entered local COLA% assumption entered by SBCTC administration will apply when the calculation is performed so it is best to enter a value for every period if you are trying to override the global assumptions, even if it is a 0.
  3. Enter the percentage data, i.e. ".03".

When you enter values into the input cell, it will be "shaded" or highlighted in yellow. This indicates that the data has not been saved.

Enter COLA% data
  1. Select the Save button located in the upper right hand of the screen to save the global assumption that you have entered. Once you have saved the data, the background color of the cells will change by "unshaded" or in white to indicate that the data has been saved to the database.
COLA% data is saved

UAT Test Case

Verify that you are able to select your college and enter different COLA%’s by month and GL account driven employee classification.  

Workforce Expense

Employee Management By Classification

Purpose: Use this document as a reference for reviewing and modeling Employee Data in the workforce module of PBCS.

Audience: Budget Development staff

This form has the college Business Unit in the page drop down and Employee Classification. It displays all of the employees that work for a college BU of selected Employee Classification.

Navigation: Main landing Page > Workforce > Workforce Expense Model > All Employees Form By Employee Classification

  1. From the Main Landing or Home page, select the Workforce button.
on the home page, select Workforce icon
  1. Select the Workforce Expense Model icon.
Workforce Expense Model icon

The first time you login, the form may be blank or it display last visited data form. This is because PBCS will default to the first data point in the hierarchies for the dimensions. Once the dimensions values are updated, PBCS will remember your selections as you navigate between forms.

  1. At the bottom of the page, select the form Employee Management By Classification tab.
  2. If you need to set your college, select the BusinessUnit Select a Member link.
  3. The Select a Member-BusinessUnit window displays. Locate your college business unit and select the side arrow icon. Then select the check mark icon next to your college business unit.
  4. Select the OK button to close out the window.
Select Bus Unit

NOTE:

  • You should always select Level 0 member of Business Unit, which is your Business Unit and Operating Unit i.e. WA050_7050.
  • When you change the value in POV (Point of View) then you must click GO button (right arrow) to refresh the data. i.e. if You want to view the data of FAC Employee classification then you must select FAC from EmployeeClassification drop down and Click GO button.
  1. Select the Dept-EmplClass link to set the Employee Classification. The Select a Member-Department window displays.
  2. Locate the HCM Classification and select a checkbox next to desired HCM Classification. Select the OK box to close out the window.
  3. Select the Save button and then the Refresh button to refresh the data.
Select Dept-EmplClass
  1. The page refreshes and displays a confirmation box. Select the OK box to close window. Note the updated Dept-EmplClass is now 'FAC'.
  2. The first column (IncludeEmployeeCostElement ) has been added to this form to allow you to activate or de-activate an employee’s expenses from calculating.  If the first column is blank or has a value of Y then the monthly expenses for the employee will calculate when you save the form.  If the first column is N, then the expenses for that employee record will not calculate.
  3. By Default, employee record associated with GL Account 5000090 (Part time Faculty) has flag set to N.

Once you select any new value from any POV drop down, the background color will change to "shaded" or highlighted yellow to tell you that you have to select the Save button to save changes.

Saved page
  1. This form has a business rule attached to it that runs when the rule is saved that will recalculate all of the expenses for the employees listed on the form for the business unit/Classification that is in the form drop down point of view.

The Employee salary expenses have been calculated. You can verify the salary by using the scroll bar to scroll to the right of the page. The salary will display in yearly as well as monthly.

Updated salaries

UAT Test Case

Change the IncludeEmployeeCostElement flag to N and save the form, the salary expenses for that employee record that are displayed by month on the far right of the planning form should be cleared.  If you change the flag back to Y and save the form again, then the calculated salary should return.

Change the Employee attribute and save the form, the salary expenses for that employee record should be updated based on updated attributes.  

Change the Pay Rate of an Employee and verify the calculated salary for the same Employee.

Employee Allocation

Purpose:  Use this document to review and update Employee Combo code allocation slices.

Audience:  Budget Development Staff

Each employee record may have one or more Combo Codes consisting of GL Account, Finance Department, Class, Fund, Program etc. that employee records costs are allocated to in the Finance database. Selecting this menu allows you to navigate to Employee Combo Code Allocation Slices form where you may review and/or update all of the allocation slices associated with a specific employee record.

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

OR

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management -  All Employee

  1. Select the Employee Management By Classification tab. Verify both the BusinessUnit and Dept-EmplClass config values are set.
Verify Bus Unit and Dept-Emp Class is set
  1. Select the All Employee Allocation Detail tab.
  2. Right click on an employee name and select “Employee Allocation Slices” from menu. You will be taken to the Employee Allocation Slices (Combo Codes) Form.
Select Employee Allocation Slices

For the selected Employee, there is just one Combo Code that defines the employee record cost element allocation. The record, the GL Account is 5000090, which is why to the right in the greyed-out column you see the calculated employee expense in account AC5000010.  

Select employee
  1. You may add additional allocation slices up to 10 Combo Code for this employee by adding them and then making sure that the sum total of all of the Alloc%Segment’s is 100%.  If the sum total of the Allocation %’s is not 100% then the employee’s costs will not be fully allocated.
Add more lines
  1. Select the Save button if you have changed anything in this form.
  2. To close out the selected employee select the 'X' on the WFPXX Allocation Slices Form tab and return to the prior page 'All Employee Allocation Slices Form'.
Close out the form

OR Select the Employee Management by Classification tab to return to Previous form.

select Employee Management by Classification tab

UAT Test Case

Verify that you are able to Add/update and save employee combo code allocation form  

Add New Employees

Purpose: Use this document as a reference to add employees in PBCS.

Audience: Budget Development staff

This form is used to add New Employees from scratch It means you have to enter all mandatory Employee Attributes as well Employee combo code allocation manually. That is why it is not recommended. Instead, use the Copy Employee function to add new Employee.

There are two way to open the “Add New Employee” form.

Prerequisite: On the Employee Management by Classification tab, verify the correct BusinessUnit and Dept-EmplClass values are selected.

Verify correct Business Unit and Dept-EmplClass are selected

Method 1 – Using Employee Management Form

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

  1. If you are already in the Workforce model, select the WFP_Employee_Management By Classification data form.
  2. Right click on any employee to open the action menu window. Select the “Add New Employee” from menu to open the WFP04.00 New Employee Form.
select add new employee

Method 2 – Directly

Navigation: Home Page > Workforce > Workforce Expense Model > Add New Employee

  1. From the Employee Management By Classification tab page select the “Add New Employee" tab.
select the Add new Employee tab
  1. You should have been taken to form WFP04.00  New Employee Form. Here you are able to define the new employee properties for up to 10 New Hires. You will want to first select the appropriate Employee Classification from the page drop down and click the arrow to make your selection so that the employee you enter has the appropriate employee classification. Select the Ok button.
Select Dept-EmplClass
  1. Select the first empty new hire record on the form and enter following data:
    1. New Position Description: This is Optional. Provide new position description if you have any.
    2. PositionID: This is Optional. Provide old or new position ID if you have any.
    3. AccountSegment: This is Mandatory field. Select respective GL Account Details from drop down.
    4. PayGrade: This is mandatory field for Classified Employee. For other Employee classification, you can skip.
    5. PayStep: This is mandatory field for only Classified Employee. For other Employee classification, you can skip.
    6. CompensationFrequency: This is mandatory field. Select respective value from drop down.
    7. PayRate: This is mandatory field. Provide Pay rate value.
    8. AnnualHours: This is mandatory field for only Classified Employee.
    9. HireDate: This is mandatory field. Provide Hire date in the format MM/DD/YY or select desired date.
    10. FTE: This is Optional.
    11. HealthCareCode: This is mandatory field. Select Y if health Benefit is applicable else N
    12. RetirementPlan: This is mandatory field. Select respective retirement Plan from drop down.
  2. Use the scroll bar to view all available columns. Select the Save button to save the data. A message window displays that the data was saved and business rule was run successfully. Select the OK button to close out the window.
Enter new employee form data

Scroll to the right of the form, you will see that the monthly Salary expenses for the employee have been calculated.

Salary data populates

If you want to enter more new employees then select corresponding rows and add above data element.

Whenever you Add a New employee from scratch, you must also create that Employee’s Allocation Slices.  If no combo codes are entered for new employees, their calculated costs will not be allocated to the Finance database.  

  1. In order to define an allocation slice for the new employee, simply right click on the new employee record in the new employee form and select Employee Allocation Slices. This will take you to the Employee Allocation Slices form where you may enter the relevant Combo Codes.
Right click to open the action box. Select the Employee Allocation Slices
  1. On the Employee Allocation Slices tab page for the new hire employee displays and there are no combo codes defined (The Account Segment will be populated if you entered it on the previous New Employee form). Enter a value for each element of the Combo Code and make sure that the total of the allocation segment %’s is 100% and save your entries.  The calculation should run and the Salary that is calculated should be calculated in the appropriate GL account.
  • FundSegment: Select Fund and Appropriation value from drop down. You may search by providing the data in search field and hit enter.
select Fund
  • DepartmentSegment: Select your finance department ID value from drop down. Your Department ID should show in the format (COMPANY CODE_DEPARTMENT ID). You may search by providing the data in search field and hit enter.
Select Department
  • ProgramSegment: Select Program code value drop down. If your college is not using Program code then you must select “NoProg” from drop down else your program code from drop down in the format (COMPANY CODE_PROGRAM CODE).
  • ClassSegment: Select Class code value drop down.
  • ProjectSegment: Select Project code value drop down.
  • **NOTE:  When selecting NoProg or NoProj from the drop down options, select the second entry from the drop down Selection.  
  1. Newly entered data will be shaded or highlighted yellow. Select the Save button to save the data.

Hover between the row names ComboCode01 and ComboCode02 to see up/down arrow icon that enables you to expand the row width.

Enter Combo Code data and select save
  1. A message displays that the data you entered was saved and that the business rule was run successfully. Select the OK button to close out the message box.
Select OK to close the box

If you wish to delete a newly added employee, then please follow Remove Employee

UAT Test Case

Verify that you are able to Add new Employees as well their combo code allocations

Verify that you are able to calculate salary expenses for those new employees, were you taken back to the original form when you used the ReturnToPreviousForm menu option?

Copy Employee

Purpose:  Use this document as a reference to add employees by copying exiting employee in PBCS.

Audience:  Budget Development Staff

In most cases, you will likely wish to copy an existing employee’s properties to add a new hire employee. When you copy existing employee to New employee, all the employee’s data with combo code allocation gets copied into new employee.

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

OR

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management -  All Employee

Prerequisite: On the Employee Management by Classification tab, verify the correct BusinessUnit and Dept-EmplClass values are selected.

Verify correct Business Unit and Dept-EmplClass are selected
  1. From the Employee Management By Classification tab, right click on desired employee record(s) to open the action window. Select the Copy Employee link.
select add new employee
  1. The WFT_Copy Employee window displays. By default, the Business Unit from the forms page selection is specified in the run time prompt.  By default, the employee record that you right clicked on is displayed as both the source record to copy from and too.  You will need to update the target to be a New Hiring Requisition.  This rule also allows you to copy an employee’s data from one employee classification to another.
  2. Review/Update Target Employee Classification by selecting the accordion icon. The Select a Member window opens to update using the side arrows and check mark. Select OK to save changes and return to WFT_CopyEmployee.

To update the target employee record, click on the member selection icon and select a new hire that you have not already populated with data previously.  

Note: If you select a new hire that you previously populated, the employee’s data will overwrite the data that is there when the rule is executed.

Review or update fields
  1. The WFT_CopyEmployee window displays. Business rules run time prompt values should look something similar to the following. This will ensure that existing employee’s data is copied to HiringReq1. When edits/updates are complete, select the Launch button.
Select the launch button
  1. You will see message pop window that says “The CopyEmployee was successful”. Select the OK button. As needed, use the Refresh button to update page.
copy info was saved
  1. From the Employee Management - All Employees tab use the scroll bar to scroll to the bottom of the list of employees. The newly added 'HiringRequisition1' has been populated with existing employee’s data at the bottom of the form.

All New Hire employees are at the bottom of the employee hierarchy which is why they show up at the bottom of the All Employees form.

New data was added

Next, review/update the allocation slices using the Employee Allocation Slices right click menu. For Details follow Employee Allocation.

You may also use the Remove Employee right click menu to remove employees that have been previously copied that you wish to remove. For Details, Follow Remove Employee.

UAT Test Case

Verify that you are able to copy existing employee to the New Hiring Requisition, were the allocation slices copied to the New Hiring Requisition as you would expect?

Remove Employee

Purpose:  Use this document as a reference for Editing Global Assumptions for your college in PBCS.

Audience:  Budget Development Staff

You may wish to Delete a new employee employee or if an employee has multiple lines already in place. In order to delete a new employee and all of that employee’s data, including the combo code allocation slices, right click on the new employee and click “Remove New Employee”. You can one new employee by navigating below navigation.

Navigation: Home Page > Workforce > Workforce Expense Model > Add New Employee

OR

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

Prerequisite: On the Employee Management - All Employees tab, verify the correct BusinessUnit and Dept-EmplClass values are selected.

Verify correct Business Unit and Dept-EmplClass are selected
  1. From the Employee Management By Classification tab, right click on the employee (or Hiring Requisition) that you wish to delete and select Remove New Employee.
select add new employee
  1. The WFP_RemoveNewHire window displays. Review/verify the information. Select the accordion icon.
  2. The Select a Member window opens for that specific employee. Select the TotalEmployees arrow icon. Then select NewEmployees arrow icon.
  3. Select the HiringReq number to remove.

Notice the breadcrumbs or navigation path near the bottom of the page.

Remove new hire
  1. Make sure the checkbox is marked next to the line item that you want to remove. Select the OK button.
select checkbox and ok
  1. The WFP_RemoveNewHire window displays with the updated field to remove. Select the Launch button.
select launch
  1. The All Employees Form By Employee Classification tab displays with a window confirming the removal was successful. Select the OK button to close out the window.
removal was successful, select ok

UAT Test Case

Verify that you are able to remove newly added employee data as well as its combo code allocations 

Review Employee Details

Purpose:  Use this document to review employee details in PBCS.

Audience:  Budget Development Staff

The Employee Details form contains all of the employee’s details regarding their calculated salary and benefit expenses.  

There are two way to open “Review Employee Details” form.

Prerequisite: On the Employee Management - All Employees tab, verify the correct BusinessUnit and Dept-EmplClass values are selected.

Verify correct Business Unit and Dept-EmplClass are selected

Method 1 – Using Employee Management Form

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

OR

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management -  All Employee

  1. Right click on desired employee and Click Employee Details. You should have been taken to form WFP03.00  Employee Details.
select add new employee
  1. The Employee Details page displays for selected employee. You will find all the details like base salary, salary, COLA, benefit details, GL Account details etc.

Scroll the page both up/down and left/right to view all the data.

Selected employee details displayed

Method 2 – Directly

Navigation: Home Page > Workforce > Workforce Expense Model > Review Employee Details

  1. From the Employee Management By Classification tab, select the employee.
  2. Select the Review Employee Details tab.
select review employee details
  1. The Employee Details page displays for selected employee. You will find all the details like base salary, salary, COLA, benefit details, GL Account details etc.

Scroll the page both up/down and left/right to view all the data.

Selected employee details displayed
  1. Select the Employee Management By Classification tab to return to original view.

UAT Test Case

Verify that you are able to review employee data with salary and benefit details 

Terminate Employee

Purpose:  Use this document to terminate an employee in PBCS.

Audience:  Budget Development Staff

The terminate employee function is used to end an employee’s tenure within the Department or, optionally, to transfer them to a Business Unit or Department outside the user’s domain. When there is a planned employee departure, or if you need to transfer an employee to another Department outside of the area, which you manage, you can use this function to end all salary and benefit costs associated with the employee. In the case of a transfer, you will need to coordinate manually with the Department budget authority to which the employee will be transferred so that that department budget authority can correctly add the employee to their model.

Navigation: Home Page > Workforce > Workforce Expense Model > Employee Management By Classification (Recommended)

  1. Select the employee to terminate in the list of employees on the left side of the form. Once you have scrolled to the employee whom you would like to terminate, scroll to the right until you see the Term Date column. The cell should be empty.
  2. Select the calendar icon to open a calendar window. Select the Term Date.
Select term date
  1. In the Term Date cell that corresponds to the employee, enter the date (format MM/DD/YY) or select the date for which you would like to terminate the employee. The cell is shaded or highlighted in yellow.
  2. Select the Save button.
save page
  1. A message should appear indicating that data has been saved and the rule has been run successfully. Select the OK button.
data is saved

The Employee salary expenses have been calculated. You can verify the salary by scrolling right. There is no salary will calculated after specified term date.

verify term date and no future salaries listed

Note:  The Termination Date is the last full day that the terminated employee works in a position.  The Hire Date is the first full day that an employee works in a position.

UAT Test Case

Enter termination date and ensure that employee is property terminated by verifying monthly expenses are not calculated after the termination date 

Review All Employee Combo Code Allocations

Purpose:  Use this document to review combo code allocations for all employees in PBCS.

Audience:  Budget Development Staff

This form displays every single Combo Code allocation slice for all of the employee records associated with a specific business unit.  The sum of all of the individual allocation slices for any given employee record should be 100% so that 100% of an employee’s costs will be properly allocated and accounted for.  

Navigation: Home Page > Workforce > Workforce Expense Model > All Employee Allocation Details

  1. From the Employee Management By Classification tab, select the All Employee Allocation Details tab.
all employee details tab

NOTE:  Some allocation slices cross business units so you may need to review multiple business units in some cases to ensure that all employees are 100% allocated within a specific college.

UAT Test Case

Verify that you are able to see all Employee combo code allocations 

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.