1. Administering Oracle Payroll Interface
  2. Delivered Lookups

Delivered Lookups

The delivered LOVs are either lookup codes with specific lookup types or value sets. For example, Pay Frequency Code is a lookup code, but Company Code and Client Code are value set values.

Note: You can add lookup values to the extensible lookups or user defined lookups and not to system lookups.

Attribute

Oracle-LOVs

Description

Gender

  • M

  • F

  • Male

  • Female

Pay Frequency

  • Bi Month

  • Bi Weekly

  • Calendar Month

  • Quarter

  • Semi Month

  • Semi Year

  • Week

  • Year

  • Bimonthly

  • Biweekly

  • Monthly Calendar

  • Quarterly

  • Semimonthly

  • Semiannually

  • Weekly

  • Yearly

Education Level

  • BACHELOR

  • CA_10

  • CA_20

  • CA_80

  • DOCTORAL MASTERS

  • Bachelor Degree

  • High school graduate

  • Associate Degree

  • Other education level

  • Doctorate Master Degree

EEO Ethnic Code

  • 1

  • 2

  • 3

  • 4

  • 5

  • 6

  • 7

  • 8

  • White

  • Two or More races

  • Black or African

  • American

  • Hispanic or Latino Asian

  • Native Hawaiian or Other Pacific Islander

  • America Indian or Alaska native

  • Not disclosed

Salutation

  • DR

  • MS

  • MISS

  • MRS

  • MR

  • Doctor

  • Ms

  • Miss

  • Mrs

  • Mr

Actual Marital Status

  • S

  • M

  • DE_FACTO

  • RDP

  • CL

  • CU

  • D

  • L

  • W

  • Single

  • Married

  • Domestic Partner

  • Registered domestic partner

  • Common-Law

  • Civil union

  • Divorced

  • Legally Separated

  • Widowed

EEOC Job Code

  • FIR/MIDOFFICIAL

  • PROFESSIONAL

  • TECHNICIAN

  • SALES

  • ADMIN

  • CRAFTWORKER

  • OPERATIVE

  • LABOURER

  • SERVICE

  • EXECS

  • MIDLEVEL

  • First, middle level officials and managers

  • Professionals

  • Technicians

  • Sales workers

  • Administrative support workers

  • Craft workers

  • Operatives

  • Laborers and helpers

  • Service workers

  • Executive or senior level officials and managers

  • First or mid level officials and managers

Employee Type

  • PR

  • PT

  • FT

  • FR

  • Part time regular

  • Part time temporary

  • Full time temporary

  • Full time regular

FLSA Code

  • EXEMPT

  • NONEXEMPT

  • Exempt

  • Nonexempt

Hire Reason

  • CDD

  • CDI

  • NEWHIRE

  • Fixed term - CDD

  • Permanent - CDI

  • Hire to fill vacant position.

Termination Reason

  • WORK_RELATED

  • DISMISAL WORK_RELATED

  • REDUND_ECONOMIC

  • RESIGNATION

  • RESIGN_PERSONAL

  • RETIRE_VOLUNTARY

  • RETIRE_UNVOLUNTARY

  • WORK_RELATED

  • TERMINATE_END _CDD

  • TERMINATE_MUTUAL

  • Work Incident or Work Related Illness

  • Dismissal work Incident or Work Related illness

  • Redundancy following economic recovery

  • Resignation

  • Personal Reasons

  • Voluntary retirement

  • Involuntary retirement

  • Work Incident or Work Related Illness

  • End of fixed term contract

  • Contract breach by mutual agreement

Bank Deposit Deduction Type

  • CHECKING

  • MONEYMRKT

  • SAVINGS

  • Checking

  • Money Market

  • Savings