Creating a cycle-based limit table

Use this procedure to define cycle-based tables to use for ongoing balance limits, annual accrual limits, or carryover limits on Limit 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 limit table.
    Description
    Specify a description to further define the limit 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 Hours or Earnings.
    Rule Type
    Select Limit.
    Cycle Frequency
    Specify the frequency for the cycle based table. Frequency determines the unit of time for which length of service is measured at the point where limits are applied. It is used as a reference for the service level values in the From Cycle field.
    Cycle Service Type
    Select whether the From Cycle fields pertain to amounts within the Plan Type or Plan.When a table basis is selected, additional fields are displayed.

    For example, if you select Plan Type, the length of service is based on the earliest Service Begin date on all Resource Plan records with the same plan type. If you select Plan, the length of service is based on the earliest Service Begin date on each specific Resource Plan record.

  5. Click Save.The Absence Table Details tab is available.
  6. Click New.
  7. Specify this information:
    From
    When a table basis is selected, additional fields areSpecify the start of the range. Leave this field blank on the first record if limits should begin from cycle zero. No length of service is required.
    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 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.