Defining an hours-based GL liability table

Use the following procedure to define an hours-based allotment table use ongoing balance limits, annual accrual limits, or carryover limits on General Ledger Rule (LP03.6).

To define an hours-based GL liability table

  1. Access Hours Based GL Liability Table (LP04.9).
  2. Complete the form using the following guidelines:
    GL Liability Table

    Type or select a table code.

    Effective Date

    Type an effective date for the table.

    If you need to change a value on the table, add a new effective date to the table to preserve the historical table data.

    Table Type

    Select whether the table is for hours or earnings.

    Hours Service Class

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

    Length of Service Hours Update (LP188) calculates the length of service hours according to the Hours Service Class and Hours Service Type and stores them as length of service records. The length of service records can be viewed on Length of Service Hours (LP88.1) and are used by General Ledger Liability Update (LP198) when GL liability amounts 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 also defines if the From Hours values pertain to amounts within the plan, plan: employee group, plan: employee group: position, 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 positions in the plan are counted. Qualified positions are held on either Employee Absence Plan Master (LP31.1)or Employee Absence Plan Enrollment (LP32.1) for this plan. Length of Service Hours Update (LP188) calculates the length of service hours according to the Hours Service Class and Hours Service Type and stores them as length of service records. The length of service records can be viewed on Length of Service Hours (LP88.1) and are used by General Ledger Liability Update (LP198) when GL liability amounts are calculated.

    From Hours

    Type the start of the range. Leave this field blank on the first record if amounts to post to GL apply when no length of service hours have been recorded.

    Percent

    Type a percent to be used for the calculation.

    Note: To enter 50 percent, enter 50.0000. A percent should not be entered without a calculation.
    Calculation

    Select a calculation to be used by the table. The percent is applied to the result of the calculation.