Add Employees to a Workforce Template and Process
  • 7 Minutes to read
  • Dark
    Light
  • PDF

Add Employees to a Workforce Template and Process

  • Dark
    Light
  • PDF

Article summary

You can add employees to a Workforce template for planning purposes. After a new employee has been added, you must process the employee for the scenario and related entity.

Note:
Admin users can make changes to all the fields in the Roster view, and these changes are then reflected for end users.

To add an employee and process it, follow these steps:

  1. From the Planning Control Panel, open a Workforce template.

  2. On the Employees page, click Add.

  3. Enter the employee's name, employee number to identify the employee (you can later edit this number after it has been saved), and then select the Home Budget Entity to which the employee will belong.

  4. For Hire Date, select the date on which the employee was hired. The Hire Date and the Position Start Date are the same in most cases. However, in some cases, an employee can be tied to two different positions within the same organization making multiple Position Start Dates a possibility. The expense of the employee is always driven by the Position Start Date value.

  5. Under the Position Info. tab, specify the required information for the following fields:

    • Position Description - Name of the employee's job description.

    • Position Budget Entity - The home budget entity, which can be edited if an employee moves to another department. This selection is tied to allocations and is populated in the Company Allocations column.

    • Position Start - Select the start date of the position.

    • Current Raise Percent - Determined by employee type. Intended to have raise calculations when the raise dates are prior to the budget scenario start date (since the payroll upload date).

    • Next Review Date - Select the date for the employee's next review.

    • Review Type - Select whether there will be single or multiple reviews for the employee. If you select Multiple, the Date and Percentage fields are displayed. Select the date of the review and enter the raise percentage. Add and delete raise dates and percentages as needed by clicking Add or Delete respectively.

    • Budget Raise Percent - Based on anniversary dates. The Next Review Date determines the Budget Raise Date. For example, the next review date falls between the Scenario Start and End Dates. Type the percentage increase in merit that employees will receive.
      A valid raise percentage must be between -100 and 100, which is consistent with multi-raise percent. Budget raise can be managed and administered centrally at the employee type level rather than at the employee level.

    • Budget Raise Amount – Adjust the employee’s salary raise by amount.

      When an Admin adjusts an employee’s raise by amount, the system calculates the percentage automatically based on the amount entered. In the example below, raise is entered for a single employee as an amount versus percentage. The results is that the system keeps the yearly raise constant and adjusts the percentages accordingly.

      imagea3jz123hz1239uz151.png

      In the following example, the budget raise amount is specified multiple times for an employee with Review Type set as Multiple.

      WFPWPFNew54.png

      Budget Raise as Amount functionality is available on the Employee Add/Edit pages (for single and multiple employee raise amount) and Employees page (for single employee raise amount).

      Also, Admins can access the Employee Add/Edit pages from the Maintenance menu (accessed by navigating to Maintenance > WFP > Workforce Planning Setup). End users can access the Employee Add/Edit and List pages via the template opened from the Planning Control Panel.

      For an employee, after you have specified the Budget Raise Amount and selected Review Type as Single, you can view the details in the Roster view (Employees page).

      WFPWPFNew55.png

      After you have entered Budget Raise Amount and set Review Type as Multiple, the details are not available in the Roster view as shown here.

      WFPWPFNew56.png

      You cannot load data for budget raise amount by using Data Load Rules. If you enter budget raise amount for an employee and then data is loaded for that employee via Data Load Rules, the setting will be reverted to Budget Raise as Percentage.

      • Employee Type - Select an employee type, which determines the compensation items associated with the employee.

      • Pay Plan - The salary plan of the employee: monthly, weekly, and so on.

      • Position End - Select the end, or termination, date of the position.

      • Salary Class - Select hourly and provide hours/month and rate entry information. Alternatively, select Annualized and type an annual salary amount.

      • Adjusted Annual Salary - This field displays the annual salary impact of employees each year, including the additional cost after calculating budget reviews. For instance, you may want to compute the yearly annual salary impact of an employee for different budget/forecast years starting with a $100K salary and an annual raise of 4.5%. End users can view and edit the adjusted annual salary of an employee by following these steps:

        1. From the Planning Control Panel, open a Workforce template.

        2. To add an employee, click Add. To edit an employee, click the required employee number hyperlink.

        3. From the Review Type list box, select Single or Multiple.

          If you select Single, follow these steps:

          1. Select Budget Raise Date, Budget Review, and then type the Budget Raise Percent/Amount value.

          2. In the Adjusted Annual Salary list box, select the required year.

          3. The Adjusted Annual Salary value is displayed for the selected year.

            WFPWPFNew57.png

          If you select Multiple, follow these steps:

          1. Select Budget Review as either Percent or Amount.

          2. In the Budget Raise table, specify the budget raise date and Budget Raise Percent/Amount.

            Tip!
            You can add and delete raise dates and percentages/amounts by clicking the Add Budget Raise or Delete icons.
          3. In the Adjusted Annual Salary list box, select the required year.

          4. The latest Adjusted Annual Salary value is displayed for the selected year.

            WFPWPFNew58.png

            • Add Notes - Add notes and attachments to employee positions for reporting purposes. For example, you can add a requisition for employee-related costs or make notes for new hires.

            • Type notes in the Notes field. To attach a document, click Browse. Attachments are listed based on the date and time they were added along with the user who added the attachment.

            • You can print notes by clicking Print.

            • After attaching documents and/or entering notes, click Save. The following document types are supported: .gif, .png, .jpeg, .jpg, .tif, .tga, .doc, .docx, .xls, .xlsx, .ppt, .pptx, .txt, .rtf, .pdf, .csv, and .vsd

            • Reporting Attributes - Used for managing additional information for employee position. Not used in compensation cost calculations.

  1. Click the Compensation Items tab, and then complete the following actions:

    Note:
    Compensation items are displayed based on the employee type assigned to the employee. Associated rates, amounts, and percentages cannot be modified by budget users and are set by Admins.
    • To associate compensation items with an employee, from the Customize Compensation list box, select the Compensation Items option.

    • For the compensation items that vary annually, additional details are displayed. You can modify the Effective Date and Percentage amounts for these compensation items.

    • These modifications will not affect the compensation item setup and will only be modified for the employee that you are adding or editing.

  2. In the Compensation Attributes section, the Attributes available to you will vary based on your setup.
    Attributes are based on the compensation items mapped to the employee (and set up by your Admin user on the Add Attribute page).

  3. Click I/P Comp Items, and then perform the following actions:

    • Input amounts by month: Cells for the periods outside of the scenario projection start or the periods outside of the position start/end date are locked from data input.

    • Click Copy Forward to copy the cell data to other periods on any given row. Displays two decimal values by default.

  4. To distribute employees amongst budget entities/segments (Department, Company, and so on) and compensation items, click Allocations. To add additional allocation lines, click Add New Allocation.

  5. Specify the required information in the fields as required. You can enter allocation percentages (Alloc Pct) with decimals. The Allocations grid displays up to two decimal values by default.

    • Employees can be allocated to multiple budget entities. Allocations contain compensation item-level detail when your Admin user selects the By Compensation Item option as the employee allocation method on the Define Workforce Planning Budgeting Criteria page. Instead, if your Admin user selects the By Department option, the Compensation Item column will not be displayed.

      Note:
      If you create a duplicate allocation (same compensation item, same segment combinations on multiple rows) on the Allocations setup page, Planful will identify the duplicates and consolidate the allocation to a single entry with an aggregated allocation of 100 percent.

    Allocation Periods for Time-based Compensation Allocations:

    • Allocation periods are set up so that you can select from a planning scenario start period and allocate through the end date of the scenario, irrespective of the position start or projection start date. This flexibility allows you to set up allocations for employees associated with Forecast scenarios and assists with a copy back of allocations from a Forecast scenario to the Default scenario. All compensation calculations for employees still take place according to the position start and project start date setup.

    • You must set up allocations for the entire active duration of the employee position (position start and position end).
      For example, if an employee's position starts on 6/4/2018 and ends on 1/5/2019, allocations for this employee position must cover all periods between Jun-18 and Jan-19. If allocations are not provided, an error will occur and this error message will be displayed: “Allocation not provided for all periods.”

  1. Click either Save or Save & New.

    1. Use Save to save employee details.

    2. Use Save & New to save employee details and add a new employee.

    3. Process: Employees are automatically processed when employee data is updated from the Roster view (Employees page), Employee Add, Employee Edit, and Mass Update pages.

      Note:
      Processing is performed in the cloud. You will receive a message after the processing has been completed.

Was this article helpful?