SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
YEARSOFEXP01=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
Prompt Table: SP_EXPERIENCE
RS_SPRO_YOE_MAP(SQL Table) |
Index Back |
|---|---|
RS_SPRO_YOE_MAP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | 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 |
| 3 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table: SP_EXPERIENCE |