Employment Lookups

This topic identifies common lookups that are employment-related and have user or extensible configuration levels. Review these lookups, and update them as appropriate to suit enterprise requirements. You review lookups using the Manage Common Lookups task in the Setup and Maintenance work area.

Worker Contract Lookups

Lookup Type

Description

Configuration Level

CONTRACT_TYPE

Type values, such as fixed-term, full-time, and seasonal

User

Assignment Lookups

Lookup Type

Description

Configuration Level

BARGAINING_UNIT_CODE

Codes that identify bargaining units, such as health professionals, steel workers, and public service workers

User

BUDGET_MEASUREMENT_TYPE

Work measure values, such as headcount and FTE

Extensible

EMP_CAT

Assignment categories, such as full-time regular and part-time temporary

User

EMPLOYEE_CATG

Worker type values, such as white collar, blue collar, and civil servant

User

HOURLY_SALARIED_CODE

Identifier for the hourly assignment or salary assignment

Extensible

PER_NON_WORKER_TYPES Lists all nonworker system person types Extensible

PER_SUPERVISOR_TYPE

Manager types, such as line manager, project manager, and technical manager

Extensible

Note: If your enterprise uses matrix management (where a worker assignment has multiple managers of different types), then you must review the predefined manager types in the PER_SUPERVISOR_TYPE lookup and add any missing types. You may also need to create job roles for managers other than line managers and ensure that they have appropriate access to the records of workers who report to them.

Seniority Dates Lookups

Lookup Type

Description

Configuration Level

ORA_PER_SENIORITY_ITEMS

Seniority date rules, such as enterprise seniority, legal employer seniority, and so on.

User

Terminations Lookups

Lookup Type

Description

Configuration Level

ORA_PER_YES_NO_NOT_SPECIFIED For rehire recommendation Extensible

PER_PDS_REHIRE_REASON

Reasons, such as misconduct and poor performance, for not recommending rehire of a worker

User

Areas of Responsibility Lookups

Lookup Type

Description

Configuration Level

PER_RESPONSIBILITY_TYPES

Worker responsibilities, such as benefits representative, union representative and fire warden

Extensible

Note: For Lookups in general, a relatively small number of lookup codes are created. Responsibility types lookups are to support your typical responsibility classifications. The lookup codes must not exceed 500 values, or you'll run into errors where the responsibility type is referenced.