| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CANDIDATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Used as a general ID for anything from Employee id to other types of ID like asset and material.
|
| 2 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 3 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 4 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
|
| 5 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 6 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 7 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 8 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 9 |
FO_DESCR_CUREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Staffing Front Office Recruiting Funnel Current Event Field
|
| 10 |
END_ACTUAL_REASON |
Character(2) |
VARCHAR2(2) NOT NULL |
End Reason
C1=Cancelled: Rate too High
C2=Cancelled: Slow in Response
C3=Cancelled: Job Delayed
C4=Cancelled: Order Not Needed
C5=Cancelled: Unknown or Other
CF=Competitor Filled Position
D1=Declined: Work Hazard
D2=Declined: Credit Problem
D3=Declined: Undesirable
D4=Declined: Unknown or Other
E1=Employee Dissatisfaction
F1=Unable to Fill: Candidate N/A
F2=Unable to Fill: Skills N/A
F3=Unable to Fill: Undesirable
FP=Filled Position
IC=Inquiry Closed
OC=Order Closed
OT=Other Reason
S1=Satisfactory: Work Completed
U1=Unsatisfactory: Employee Perf
U2=Unsatisfactory: Employ No Show
|
| 11 |
TRAFFIC_LIGHT |
Image Reference(30) |
VARCHAR2(30) |
Traffic Light
|
| 12 |
REG_PAY_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Pay Rate
|
| 13 |
REG_BILL_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Bill Rate
|
| 14 |
SALARY |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Salary Accepted
|
| 15 |
COMPENSATION |
Number(12,3) |
DECIMAL(11,3) NOT NULL |
Compensation
|
| 16 |
MARKUP |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Markup Percent
|
| 17 |
MARGIN_PCT_EXP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Margin Percent
|
| 18 |
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.
|