EMPLIDSKILLCODEPrompt Table: FO_SKILLCODE_VW
Y/N Table Edit
Default Value: N
AL=Advanced
BL=Beginner
IL=Intermediate
NI=Not Investigated
FOEMPLSKILL_UPG(SQL Table) |
Index Back |
|---|---|
Employee SkillsSkills the Employee has obtained at previous employers and at their current employer. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | RS_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Skill Type |
| 3 | SKILLCODE |
Character(10) | VARCHAR2(10) NOT NULL |
Skill Code
Prompt Table: FO_SKILLCODE_VW |
| 4 | YEARS_OF_EXP | Number(5,1) | DECIMAL(4,1) NOT NULL | Years of Work Experience |
| 5 | JOB_RELATED | Character(1) | VARCHAR2(1) NOT NULL |
Job Related
Y/N Table Edit Default Value: N |
| 6 | CONFIDENCE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Confidence
AL=Advanced BL=Beginner IL=Intermediate NI=Not Investigated |
| 7 | SKILL_LAST_USED | Date(10) | DATE | Last Used |
| 8 | COMMENTS | Long Character | CLOB | Comment |