| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
|
| 3 |
VMS_SUPPLIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Supplier ID
|
| 4 |
VMS_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Location - This is the Vendor Managed Service Supplier's office location
|
| 5 |
MS_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 7 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 8 |
MS_RATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
|
| 9 |
SPA_USE_EXPENSES |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to indicate if the expenses is allowed in the transcation or not.
D=Default from Business Unit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
EDUCATION_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Education Level
1=No Formal Education
10=Associate Degree
11=Three Years College
12=Four Years College
13=Bachelor Degree
14=Post Bachelors
15=First Professional
16=Post-First Professional
17=Masters Degree
18=Post Masters
19=Sixth Year Degree
2=Elementary School Completed
20=Post Sixth Year
21=Doctorate Degree
22=Post Doctorate
3=Some High School
4=High School Graduate
5=Terminal Occupation Prog DNC
6=Terminal Occupation Program
7=Some College - Less than 1 Yr
8=One Year College
9=Two Years College
A=University - Advanced
T=Trade School
U=University
|
| 11 |
SPF_YRS_EXPERIENCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table:
SP_EXPERIENCE
Set Control Field: BUSINESS_UNIT
|
| 12 |
COMPETENCY_DESC |
Long Character |
CLOB |
Competencies Required
|
| 13 |
TRAVEL_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Travel Required
N=No
Y=Yes
Default Value: N
|
| 14 |
TRAVEL_FREQUENCY |
Number(3,0) |
SMALLINT NOT NULL |
Travel Frequency
|
| 15 |
TELECOMMUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines if the user telecommutes or not
N=No
Y=Yes
|
| 16 |
SP_RATES_BY_SC |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Rate definition by SC - Translate values
D - Rate defined by SC
N - Not applicable
P - Pending Rate Synchronization
R - Ready for rate definition.
S - Sent to SC for rate definition.
D=Rate Defined by SC
N=Not Applicable
P=Pending Rate Synchronization
R=Ready for rate
S=Sent to SC for Rate
|
| 17 |
SP_REQ_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Request type - reason code
|
| 18 |
SP_ALLOW_OVRIDE_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used in the rate sheet page. It will indicated whether to allow rate override on the requisition page.
Y/N Table Edit
Default Value: Y
|
| 19 |
SPF_JUSTIFICATION |
Character(254) |
VARCHAR2(254) NOT NULL |
Requisition Justification
|
| 20 |
SP_USE_WO_ALERTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Using Work Order Alerts flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 21 |
WO_NOTIFY_BY |
Character(2) |
VARCHAR2(2) NOT NULL |
WorkOrder Alert Notification Method
EM=Email and Worklist
WL=Worklist Only
|
| 22 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_REGION_TBL
|
| 23 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 24 |
BUSINESS_UNIT_HR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit HR
Prompt Table:
BUS_UNIT_TBL_HR
|
| 25 |
DEPTID_JOB_SP |
Character(10) |
VARCHAR2(10) NOT NULL |
HCM Department ID
Prompt Table:
DEPT_TBL_EFF_VW
Set Control Field: BUSINESS_UNIT_HR
|
| 26 |
LOCATION_JOB_SP |
Character(10) |
VARCHAR2(10) NOT NULL |
HCM Job Location
Prompt Table:
LOCATION_TBL
Set Control Field: BUSINESS_UNIT_HR
|
| 27 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
SP_JOBCODE_VW1
Set Control Field: BUSINESS_UNIT_HR
|
| 28 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
SP_LBR_AGRMT_VW
Set Control Field: BUSINESS_UNIT_HR
|
| 29 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
%EDITTABLE40
|
| 30 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 31 |
SPF_WO_HCM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Spro-HCM integration status on work order
C=HCM Job Record Created
P=Pending
T=Terminated
|
| 32 |
SP_HCM_DEFLT_ADMIN |
Character(30) |
VARCHAR2(30) NOT NULL |
Default HCM Administrator
Prompt Table:
PSOPRDEFN_VW
|
| 33 |
WO_SOURCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Sourcing Status
C=Closed
F=Filled
I=Sourcing Initiated
N=New
R=Ready for Sourcing
S=Sourced
X=Cancel
Default Value: R
|
| 34 |
INTERVIEWREQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Interview Required
N=No
Y=Yes
Default Value: N
|
| 35 |
PV_SP_ORIGIN |
Character(2) |
VARCHAR2(2) NOT NULL |
RM -> Resource Management
LB --> ePro Left Browser.
SR --> Services Request Icon.
Date Initials Reference # Description
10/10/2007 Raja 1621990009 Build C314 audit errors are resolved.
LB=Left Browser
RM=Resource Management
RS=Recruiting Solutions
RS=Recruiting Solutions
SR=Service Request Icon
|
| 36 |
HCR_JOB_ADDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No field
N=No
Y=Yes
|
| 37 |
HRS_CAND_WDRAW |
Character(1) |
VARCHAR2(1) NOT NULL |
HRS_CAND_WDRAW
|