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 |
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 |
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.