Oracle HRMS includes the row types Age Range, Salary Range and Job Class, already set up and ready for use for payroll tables holding deduction amounts.

If the rows of your payroll table do not reference employee age, pay or job class, you set up the additional row type you require. You set up a new row type using the application utilities Lookups window.

The new row type may reference information already in the HRMS database as a database item. For example, a new row type can reference employees' positions.

Alternatively, the new type might reference information not previously existing in the database. For example, the rows of a table holding amounts of union dues deductions might refer to union-defined skill levels not found elsewhere in your HRMS database:

Example Payroll Table where Rows do not Represent Pay, Age or Job

   To set up row types that reference database items:

1. In the application utilities Lookups window, query the Lookup type US_TABLE_ROW_TYPES in the Type field.

2. Enter a suitable short code for the new row type, and the meaning of the code. For example, if the new row type references employees' positions, you could enter the code POS and the meaning Position.

3. Optionally, enter a description for the new row type. The start date defaults to the effective date. You can change this default. Save your work.

   To set up row types that do not reference database items:

1. In the application utilities Lookups window, enter an appropriate Lookup type for the new row type. For example, to set up a row type for the table holding union dues deduction amounts that vary by employees' union-defined skill levels, set up a Lookup type SKILL_LEVEL.

2. Enter a short code and meaning for each code belonging to the type.

   These are example Lookup entries for the Lookup type SKILL_LEVEL:

   Example Lookup Entries for a New Row Type

   Code	Meaning
   APP	Apprentice
   JRN	Journeyman
   CRFT	Craftsman

3. Optionally, enter a description for each code. The start date defaults to the effective date. You can change this default.

4. Save your work.

5. Clear the entries in the application utilities Lookups window, and query the Lookup type US_TABLE_ROW_TYPES in the Type field. Then add the new Lookup type to the list of codes and meanings available as Lookups for the type US_TABLE_ROW_TYPE.

   Note: After setting up a deduction whose amount comes from a table using the new row type, you must use the Formulas window to modify the formula generated for the deduction so that it references the new row type. The formula has the name of the deduction with the words PAYROLL_TABLE added.

   See: Adding Lookup Types and Values