| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEXT
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 6 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTNREASONT_UPG
|
| 7 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: OPRDEFTBL_UPG.COMPANY
Prompt Table:
COMPANYTBL_UPG
|
| 8 |
PRIMARY_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Primary BU/Branch
Default Value: OPRDEFTBL_UPG.BUSINESS_UNIT
Prompt Table:
BUSUNITTBLF_UPG
|
| 9 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Default Value: OPRDEFTBL_UPG.LOCATION
Prompt Table:
LOCATION_TBL
|
| 10 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Benefit Program
Prompt Table:
BEN_DEFN_PGM
|
| 11 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPRDEFTBL_UPG.SETID
|
| 12 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Default Value: OPRDEFTBL_UPG.DEPTID
Prompt Table:
DEPT_TBL_VW2
|
| 13 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPRDEFTBL_UPG.SETID
|
| 14 |
PRIMARY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
Default Value: OPRDEFTBL_UPG.OPRID
Prompt Table:
OPRID_VW
|
| 15 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Status
A=Active
D=Deceased
I=Inactive
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 16 |
CAREER_PLMT1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Placement Desire
B=Temp & Career
C=Career
L=Leasing
N=Contract
P=Payrolling
T=Temp
Y/N Table Edit
Default Value: N
|
| 17 |
FO_AFFILIATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Contractor
Y/N Table Edit
Default Value: N
|
| 18 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE
|
| 19 |
ELIG_FOR_REHIRE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible for Rehire
Y/N Table Edit
|
| 20 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUPTBL_UPG
|
| 21 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
TAX_LOCATION1
|
| 22 |
USER_STATUS |
Character(6) |
VARCHAR2(6) NOT NULL |
User Status
Prompt Table:
USER_STATUS_VW3
|
| 23 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODETBL_UPG
|
| 24 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 25 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 26 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
|
| 27 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 28 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 29 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 30 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Default Value: H
|
| 31 |
BENEFIT_SYSTEM |
Character(2) |
VARCHAR2(2) NOT NULL |
A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration
BN=Base Benefits
|
| 32 |
WORKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table:
TL_WRKGRP_TBL
|
| 33 |
TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table:
TL_TASKGRP_TBL
|
| 34 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GB=European
GP=Global Payroll
GS=German/Swiss Payroll
NA=North American Payroll
OT=Other
PI=Payroll Interface
Default Value: NA
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPRDEFTBL_UPG.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 36 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 37 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
Prompt Table:
FREQUENCY_TBL
|
| 38 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
COMP_RATECD_TBL
|
| 39 |
REFERRAL_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
EE=Employee
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search
Default Value: UK
|
| 40 |
PREV_EMPL_BY_COMPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Previously Employed by Company
Y/N Table Edit
Default Value: N
|
| 41 |
CAN_VISBL_MINORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Visible Minority
B=Black
C=Chinese
F=Filipino
I=Indo-Pakistani
J=Japanese
K=Korean
N=Not a Visible Minority
O=Other
S=Southeast Asian
W=West Asian, Arab
Default Value: N
|
| 42 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Group
Prompt Table:
GP_PYGRP
|
| 43 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 44 |
SETID_LBR_AGRMNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Labor Agreement SetId
|
| 45 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|