MERCHANTIDRS_USERIDSEQNUM1=Beginner
2=Intermediate
3=Advanced
0=0 Years
1=1 Year
11=10+ Years
2=2 Years
3=3 Years
4=4 Years
5=5 Years
6=6-10 Years
1=Strong
2=Some
3=Neutral
4=None
RS_COMPETEN_EXT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL | Merchant ID |
| 2 | RS_USERID |
Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | RS_COMPETENCY_EXT | Character(20) | VARCHAR2(20) NOT NULL | Competency |
| 5 | RS_SKILL_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Skill Proficiency Level
1=Beginner 2=Intermediate 3=Advanced |
| 6 | YR_LAST_USED | Number(4,0) | SMALLINT NOT NULL | Year Last Used |
| 7 | RS_YR_EXP_EXT | Character(2) | VARCHAR2(2) NOT NULL |
Years of Experience
0=0 Years 1=1 Year 11=10+ Years 2=2 Years 3=3 Years 4=4 Years 5=5 Years 6=6-10 Years |
| 8 | RS_INTEREST_EXT | Character(1) | VARCHAR2(1) NOT NULL |
Interest Level
1=Strong 2=Some 3=Neutral 4=None |
| 9 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |