You may need to set up your own tables in your Oracle HRMS system to hold data such as wage codes, shift differentials, or the amounts of certain deductions. You can set up all the tables you require using the Table Structure window. Using Oracle FastFormula, you can write simple formulas for validating entries made in table columns.
The Oracle HRMS user-defined tables are different from the database tables of the Oracle Relational Database Management System. When you set up a user table, you define the rows as well as the columns, like a matrix. For example, you could set up a table showing bonus amounts (the column) against years of service (the rows).
Attention: Do not use the Table Structure window to set up tables holding information on medical, dental, or vision benefit plans (benefits with the benefits classification Medical, Dental, or Vision).
The Oracle HRMS database includes a special table, the Benefits Table, already set up to hold information on benefit plans with coverage levels, and the employee and employer contributions at each level. To enter information into this table you use the Benefit Contributions window.
See: Establishing Plan Coverage and Default Contributions (Basic Benefits)
Use the Table Values window to enter values in tables. Table entries and rows are both datetracked, so you can delete existing entries or rows and add new ones, as of an effective date.
Oracle HRMS provides the GET_TABLE_VALUE function to access table values. You can write formulas that include calls to this function, perhaps for QuickPaint inquiries. For example, IT personnel can write PL/SQL statements that call this function, to include in the code for a form or report process.
Tables set up to hold deduction amounts are payroll tables. You need a payroll table when the amount of a deduction varies in accordance with a factor such as employee age, pay, or job class.
To initiate a deduction with the amount rule Payroll Table, you must establish a row type. The formula for the deduction uses the row type to help determine which row of the table to go to for each employee's deduction amount. Your startup data includes three predefined row types: Age Range, Salary Range and Job Class. You can set up any additional types you require.