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.

Attribute

WFN-LOVs

GPI-LOVs

Description

Remarks

Gender

  • M- MALE

  • F- FEMALE

  • N- Not Specified

  • F

  • M

  • Female

  • Male

If you don't specify a value, the ADP application translates it as N.

Pay Frequency Code

  • B-Biweekly

  • D-Daily

  • M-Monthly

  • S-Semimonthly

  • W-Weekly

  • Bi-monthly

  • Bi-week

  • Calendar Month

  • Quarter

  • Semi-month

  • Semi-year

  • Week

  • Year

  • Bimonthly

  • Biweekly

  • Monthly Calendar

  • Quarterly

  • Semimonthly

  • Semiannually

  • Weekly

The application creates these time periods.

  • Bimonthly: Time periods occurring once in two months.

  • Biweekly: Time periods every 14 days.

  • Semimonthly: Time periods occurring twice a month.

  • The application doesn't support Daily.

Education Level

  • ASC- Associate

  • DOC- Doctorate and above

  • DPL- Diploma

  • GRD- Graduate

  • MS- **

  • NI- Not Indicates

  • UGR - Under Graduate

  • BACHELOR

  • CA_10

  • CA_20

  • CA_80

  • DOCTORAL MASTERS

  • Bachelor Degree

  • High school graduate

  • Associate degree

  • Other education level

  • Doctorate Master Degree

This is a 3 character field.

EEO Ethnic Code

  • White

  • African American

  • Hispanic or Latino

  • Asian

  • Indian or Alaskan

  • Hawaiian/Pacific Islander

  • Two or more races

  • 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

  • American Indian or Alaska Native

  • Not disclosed

The application translates '2' to '9', '3' to '2', '4' to '3', '5' to '4', '7' to '5'.

Salutation

  • Dr.

  • Hon.

  • Miss.

  • Mrs.

  • Mr.

  • Ms.

  • Msgr.

  • Rabbi.

  • DR.

  • MS.

  • MISS

  • MRS.

  • MR.

  • Doctor.

  • Ms.

  • Miss.

  • Mrs.

  • Mr.

The application checks if upper or lower case makes a difference.

EEOC Job Code

  • 1- First/Mid-Level Officials and Managers

  • 2- Professionals

  • 3- Technicians

  • 4- Sales Workers

  • 5- Administrative Support Workers

  • 7- Operatives

  • 8- Laborers and Helpers

  • 9- Service Workers

  • A- Executive/Senior Level Officials and Managers

  • 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

If you don't specify a value, the ADP application translates it as N.

Employee Type

  • Full Time

  • Part Time

  • PR

  • PT

  • FT

  • FR

  • Part time regular

  • Part time

  • Temporary

  • Fulltime temporary

  • Fulltime regular

User defined. 4 characters. The application doesn't translate. Ensure that the values are in the ADP table.

Hire Reason

  • CDD

  • CDI

  • NEWHIRE

  • Fixed term - CDD

  • Permanent - CDI Hire to fill vacant position.

Pass the Action Code and Action Reason to WFN for reference.

Termination Reason

  • WORK_RELATED

  • DISMISSAL 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

  • S-Saving

  • C-Checking

CHECKING MONEYMRKT SAVINGS

Checking Money market Savings

The application translates Checking to C and Savings to S. MONEYMRKT is invalid.