| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 3 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 4 |
RS_ATTRIBUTE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
RS_QUALIF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Qulaiifcation Types for SO
ANY=Any Type
ATT=Attribute
CMP=Competency
DEG=Degree
FAC=Other
LIC=License
LNG=Language
MEM=Membership
|
| 7 |
RS_QUALIF_VALUE |
Character(10) |
VARCHAR2(10) NOT NULL |
Code
|
| 8 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
Prompt Table:
COMPETENCY_TBL
|
| 9 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 10 |
PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency
Prompt Table:
REVW_RATING_VW
|
| 11 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 12 |
YEARSOFEXP |
Character(2) |
VARCHAR2(2) NOT NULL |
Year of work experiences.
01=One Year
02=Two Years
03=Three Years
04=Four Years
05=Five Years
06=Six Years
07=Seven Years
08=Eight Years
09=Nine Years
|
| 13 |
RS_ATTR_VAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Attribute Value ID
Prompt Table:
%EDITTABLE3
|
| 14 |
REQUIRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
ACCOMP_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test
|
| 16 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table:
ACCOMP_TBL
|
| 17 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
Prompt Table:
MAJOR_TBL
|
| 18 |
DESCR_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 19 |
SPEAK_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low
2=Moderate
3=High
|
| 20 |
READ_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low
2=Moderate
3=High
|
| 21 |
WRITE_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low
2=Moderate
3=High
|
| 22 |
SPEAK_PROF_NUM |
Number(1,0) |
SMALLINT NOT NULL |
The numeric version of the SPEAK_PROFICIENCY field.
|
| 23 |
READ_PROF_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Numeric version of the READ_PROFICIENCY field.
|
| 24 |
WRITE_PROF_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Numeric version of the WRITE_PROFICIENCY field.
|
| 25 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 26 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 27 |
WEIGHT_POINTS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Factor Weight Points
|
| 28 |
IMPORTANCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Importance
EIM=Desired
REQ=Required
|
| 29 |
IMPORTANCE_NO_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Importance
EIM=1 - Extremely Important
IMP=3 - Important
SLI=Desirable
SOI=Very Desirable
VIM=2 - Very Important
|
| 30 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 31 |
GRR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Generic Resource Request ID.
|
| 32 |
SRCH_RESUME |
Character(1) |
VARCHAR2(1) NOT NULL |
Search in resume.
N=Inactive
Y=Active
Default Value: Y
|