Creating hours-based allotment tables

Use this procedure to define an hours-based allotment table for use in Allotment Rules.

  1. Select Absence Management > Set Up > Plans and Components > Tables.
  2. Click New.
  3. Specify an Absence Table code and description.
  4. Specify this information:
    Absence Table
    Specify a code for the table.
    Description
    Specify a description to further define the allotment table.
    Version Date
    Specify a version date for the table. If you must change a value on the table, add a new version date to the table to preserve the historical table data. The processing date on the calculation programs determine what version of the table is used.
    Table Type
    Select whether table is for Hours or Earnings.
    Rule Type
    Select Allotment.
    Table Basis
    Select Hours.

    When a table basis is selected, additional fields are displayed.

    Hours Service Class
    Specify the service class that contains the hours which count toward the service levels values in the From Hours field.

    Length of Service Calculate uses the Hours Service Class and Hours Service Type to create length of service records. The records can be viewed on Length of Service Hours and are used by Employee Absence Plan Calculation when accruals are calculated.

    Hours Service Type
    Select whether the values in the From Hours fields pertain to life to date (LTD), year to date (YTD), or prior year total (PYT) amounts since the Service Begin Date.

    The service type defines if the From Hours values pertain to amounts within the plan type, plan, or all.

    For example, if you select the 01 LTD plan, all hours in the service class from the service begin date for all qualified plans are counted.

  5. Click Save. The Absence Table Details tab is available.
  6. Click New.
  7. Specify this information:
    From
    Specify the start of the range. Leave this field blank on the first record if allotments should begin when no length of service hours have been calculated.
    Amount or Percent
    Specify an amount or percent use in the table.
    • Amounts are added as flat accruals or can be added to a calculation or formula
    • Percents are multiplied by a calculation or formula.
      Note: Specify 50 percent as 50.0000.
    Calculation
    Specify a calculation use in the table. If an amount or percent is also specified, it is applied to the result of the calculation.
    Maximum
    Specify the maximum value for the combined result of the amount, percent, or calculation.
  8. Click Save.