You are creating an accrual calculation that returns accrual amounts based on employees’ years of...

Years of service resolves as a numeric calculation, so the appropriate table is Advanced Lookup Table – Numeric Calculation Search Criteria . The lookup table uses the calculated years-of-service value to locate the applicable range and return the corresponding accrual amount. For example, the table might return three hours for one through five years, five hours for six through ten years, and eight hours for service greater than ten years.

Advanced Lookup Table – Report Field Search Criteria is used when the search value comes directly from a single-instance or multi-instance report field, such as Job Profile. Text Report Field Search Criteria applies when the source is a text field, such as a city name. No Search Criteria provides only a default value and cannot differentiate results according to service bands.

The numeric table should define complete, non-overlapping service ranges and include a suitable response for every expected value. The resulting lookup calculation can then be selected as the accrual amount. Effective dating can be used when service-based accrual rates change over time without requiring the entire accrual configuration to be rebuilt.

Study Guide reference: Calculations for Time Off Plans – Advanced Lookup Tables in Lookup Calculations .