Have your ever wondered where does Oracle HRMS stores the data for annual limits for various benefit contributions and taxes.

Their is a table in Oracle called PAY_US_FEDERAL_TAX_INFO_F which stores this information.

A column called Fed_information_category stores the type of limit - for example '403B LIMITS'  or fed_information_category = '401K LIMITS' signified the type that you are looking for.

Values are stored in columns fed_information1,  fed_information2 etc.

For example, if you are looking for 401(k) limits, then fed_information1 is the Annual_Limit for 401(k) and fed_information2 is the 401(k) Catchup Limit for the year.

For each year, their is one row uniquely identified by the effective_start_date.

So, if you want to find the limits for 401k in the year 2009, then you will simply run this query:

select * from pay_us_federal_tax_info_f
where effective_start_date = '1-JAN-2009'
where fed_information_category = '401K LIMITS'

select * from pay_us_federal_tax_info_f