| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEXT
|
| 2 |
CAREER_PLMT1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Placement Desire
B=Temp & Career
C=Career
L=Leasing
N=Contract
P=Payrolling
T=Temp
Default Value: T
|
| 3 |
TYPE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Career Type Status
Default Value: A
|
| 4 |
REGISTRATION_DT |
Date(10) |
DATE NOT NULL |
Registration Date
Default Value: %date
|
| 5 |
DESIRED_START_DT |
Date(10) |
DATE NOT NULL |
Desired Start Date
|
| 6 |
DESIRED_END_DT |
Date(10) |
DATE |
Last Date Available
|
| 7 |
MIN_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Minimum Acceptable Pay Rate
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 9 |
FREQUENCY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table:
FREQUENCY_TBL
|
| 10 |
DESIRED_REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
E=Either
R=Regular
T=Temporary
|
| 11 |
DESIRED_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part-Time
E=Either
F=Full-Time
P=Part-Time
|
| 12 |
DESIRED_HOURS |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Desired Hours Per Week
|
| 13 |
OVERTIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Overtime OK?
|
| 14 |
NOTICE |
Character(2) |
VARCHAR2(2) NOT NULL |
Notice Required
01=Not Applicable
05=Same Day
10=One Day
15=More than One Day
20=One Week
25=Two Weeks
30=Three Weeks
|
| 15 |
ASSIGN_DURATION |
Character(2) |
VARCHAR2(2) NOT NULL |
Assignment Duration
D=Direct Hire
L=Long Term (> 3 months)
M=Moderate Term (< 3 months)
S=Short Term (< 2 weeks)
Z=Not Investigated
|
| 16 |
TRAVELLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Willing to Travel
Y/N Table Edit
Default Value: N
|
| 17 |
OVERNIGHT_TRAV |
Character(1) |
VARCHAR2(1) NOT NULL |
Willing to Travel Overnight
Y/N Table Edit
Default Value: N
|
| 18 |
TRAVEL_DISTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Travel Distance
|
| 19 |
TRAVEL_MINUTES |
Number(5,0) |
INTEGER NOT NULL |
Travel Minutes
|
| 20 |
TRAVEL_MILES |
Number(5,0) |
INTEGER NOT NULL |
Travel Miles
|
| 21 |
COMMENT1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 22 |
TRANSPORT |
Character(60) |
VARCHAR2(60) NOT NULL |
Transport
|
| 23 |
LAYOFF |
Character(1) |
VARCHAR2(1) NOT NULL |
Layoff/Recall
|
| 24 |
RESTRICTIONS |
Long Character |
CLOB |
Restrictions
|
| 25 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
|
| 26 |
DESIRED_SHIFT_M |
Character(1) |
VARCHAR2(1) NOT NULL |
Monday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 27 |
DESIRED_SHIFT_T |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuesday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 28 |
DESIRED_SHIFT_W |
Character(1) |
VARCHAR2(1) NOT NULL |
Wednesday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 29 |
DESIRED_SHIFT_TH |
Character(1) |
VARCHAR2(1) NOT NULL |
Thursday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 30 |
DESIRED_SHIFT_FR |
Character(1) |
VARCHAR2(1) NOT NULL |
Friday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 31 |
DESIRED_SHIFT_SA |
Character(1) |
VARCHAR2(1) NOT NULL |
Saturday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 32 |
DESIRED_SHIFT_SU |
Character(1) |
VARCHAR2(1) NOT NULL |
Sunday Shift
Prompt Table:
SHIFT_CODE_TBL
|
| 33 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|