| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID
Prompt Table:
PERS_SRCH_GBL
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 4 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 5 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSN_DATA_VW
|
| 6 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
Default Value: R
|
| 7 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
Default Value: F
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
BUSUNIT_HR_VW
|
| 9 |
PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: PER_ORG_ASGN.PER_ORG
|
| 10 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 11 |
HR_SRCH_POS_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Position Description
|
| 12 |
HR_SRCH_LOC_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Location
|
| 13 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 14 |
HR_SRCH_DEPT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Department
|
| 15 |
HR_SRCH_JBCD_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Job Title
|
| 16 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 17 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 18 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 19 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 20 |
SECOND_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 21 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 22 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 23 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime
|
| 24 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 25 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
%EDITTABLE5
|
| 26 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 27 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG
|
| 28 |
HR_SRCH_PYGP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Paygroup Description
|
| 29 |
HR_SRCH_GPPY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
GP paygroup Description
|
| 30 |
ABSENCE_SYSTEM_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
What Absence System this Assignment is tied to.
AM=Absence Management
OT=Other
Default Value: OT
|
| 31 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 32 |
HR_SRCH_GP_XLAT |
Character(30) |
VARCHAR2(30) NOT NULL |
GP paysytem xlatlongname
|
| 33 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 34 |
HR_SRCH_ABS_STM_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
SES: Absence system code referenced in HR_SRCH_JOBDATA query
|
| 35 |
HR_SRCH_ABS_XLAT |
Character(30) |
VARCHAR2(30) NOT NULL |
Abs paysytem xlatlongname
|
| 36 |
HR_SRCH_CMP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Company Descr
|
| 37 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 38 |
SECOND_LAST_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Second Last Name
|
| 39 |
NAME_DISPLAY_SRCH |
Character(50) |
VARCHAR2(50) NOT NULL |
Uppercase version of Name to improve performance on searches.
|
| 40 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
|
| 41 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 42 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 43 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 44 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Status
A=Active
I=Inactive
|
| 45 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
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
|
| 46 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 47 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 48 |
SUPERVISOR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Supervisor Name
|
| 49 |
REPORTS_TO_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Reports To
|
| 50 |
BUSINESS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Title
|
| 51 |
MILITARY_SERVICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Service
|
| 52 |
MIL_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Military Rank
|
| 53 |
MIL_WORN_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Worn Rank
|
| 54 |
BUSINESS_DESCR |
Character(60) |
VARCHAR2(60) NOT NULL |
Business Description
|
| 55 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
|
| 56 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 57 |
HR_RW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remote Worker Type(Fully remote/Hybrid)
F=Fully Remote
H=Hybrid
|
| 58 |
HR_RW_REASON |
Character(60) |
VARCHAR2(60) NOT NULL |
Remote Worker Reason
|
| 59 |
HR_RW_LOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remote Worker Location Type
H=Home
O=Other
W=Workplace
|
| 60 |
HR_RW_LOCATION |
Character(30) |
VARCHAR2(30) NOT NULL |
Remote Work Location
|
| 61 |
RW_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 62 |
RW_PERCENT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Remote Work Percent
|
| 63 |
RW_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Remote Worker Type
|
| 64 |
RW_DAY1 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Monday
A=Active
I=Inactive
|
| 65 |
RW_DAY2 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Monday
A=Active
I=Inactive
|
| 66 |
RW_DAY3 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Wednesday
A=Active
I=Inactive
|
| 67 |
RW_DAY4 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Thursday
A=Active
I=Inactive
|
| 68 |
RW_DAY5 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Friday
A=Active
I=Inactive
|
| 69 |
RW_DAY6 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Saturday
A=Active
I=Inactive
|
| 70 |
RW_DAY7 |
Character(1) |
VARCHAR2(1) NOT NULL |
New fiedl to display Sunday
A=Active
I=Inactive
|
| 71 |
WF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
|
| 72 |
GENDER_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Description for Diversity Types (Age, Ethnic Disability, Ethnic Group, Gender, and Veteran Status).
|
| 73 |
HR_VET_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Veteran Description
|
| 74 |
HR_RW_LTYP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Remote Location Type
|
| 75 |
HR_JF_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Job Family Description
|