BUSINESS_UNITSO_IDSO_LINEMERCHANTIDRS_USERIDH=H1B Visa
N=Other
T=NAFTA
U=US Citizen
N=No
X=No preference
Y=Yes
1=Less than 1 month
2=1 to 3 months
3=3 to 6 months
4=6 to 12 months
5=More than 1 year
6=No preference
N=No
X=No preference
Y=Yes
RS_CANDIDATE(SQL Table) |
Index Back |
|---|---|
Candidate detailRecord to store the detail pertaining to Service Order for a particular Employee. |
| # | 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 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL | Merchant ID |
| 5 | RS_USERID |
Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
| 6 | RS_USERNAME | Character(20) | VARCHAR2(20) NOT NULL | User Name |
| 7 | RS_USER_CMT | Character(60) | VARCHAR2(60) NOT NULL | User Comments |
| 8 | RS_ROLE_STR | Character(30) | VARCHAR2(30) NOT NULL | Role |
| 9 | RS_AVAILABLE | Character(15) | VARCHAR2(15) NOT NULL | Available Date |
| 10 | RS_RATE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | External Resource Rate |
| 11 | RS_RATING | Number(3,0) | SMALLINT NOT NULL | Match Rating |
| 12 | RS_BUYER_RATING | Signed Number(4,0) | DECIMAL(3) NOT NULL | Customer Satisfaction |
| 13 | RS_CITY | Character(20) | VARCHAR2(20) NOT NULL | City |
| 14 | RS_STATE | Character(10) | VARCHAR2(10) NOT NULL | State |
| 15 | RS_ZIP | Character(12) | VARCHAR2(12) NOT NULL | Location Postal Code |
| 16 | RS_LOC_STR | Character(30) | VARCHAR2(30) NOT NULL | Location String |
| 17 | RS_DESIREDLOC_STR | Character(20) | VARCHAR2(20) NOT NULL | Desired Location |
| 18 | RS_WORKSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Status
H=H1B Visa N=Other T=NAFTA U=US Citizen |
| 19 | RS_TELECOMMUTE | Character(1) | VARCHAR2(1) NOT NULL |
Telecommute Desired
N=No X=No preference Y=Yes |
| 20 | RS_DURATION_PREF | Character(1) | VARCHAR2(1) NOT NULL |
Desired Project Duration
1=Less than 1 month 2=1 to 3 months 3=3 to 6 months 4=6 to 12 months 5=More than 1 year 6=No preference |
| 21 | RS_PERM_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Perm Position Desired
N=No X=No preference Y=Yes |
| 22 | RS_PB_RESUME_EXT | Character(30) | VARCHAR2(30) NOT NULL | See Resume |
| 23 | RS_BESTSKILL | Character(200) | VARCHAR2(200) NOT NULL | Best Skills |
| 24 | RS_BESTOVERALL | Character(200) | VARCHAR2(200) NOT NULL | Best Overall |
| 25 | RS_DESIREDSKILL | Character(200) | VARCHAR2(200) NOT NULL | Desired Skill |
| 26 | RS_BESTPROJ | Character(200) | VARCHAR2(200) NOT NULL | Best Project |
| 27 | RS_IDEALPROJ | Character(200) | VARCHAR2(200) NOT NULL | Ideal Project |