POSITION_NBRJOB_FAMILYSETIDJOBCODEJOB_TASKEFFDTACCOMPLISHMENTPrompt Table: ACCOMP_TBL
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
Default Value: 3
RS_ROLE_ACCOMPS(SQL Table) |
Index Back |
|---|---|
Accomplishments of RoleCM_ROLE_ACCOMPS is a table that contains the accomplishments that profile a role (position, jobcode, job task, or job family). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | JOB_FAMILY |
Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL | Job Task |
| 6 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 7 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table: ACCOMP_TBL |
| 8 | RS_IMPORTANCE | Character(1) | VARCHAR2(1) NOT NULL |
Competency Importance
1=1-Low 2=2-Below Average 3=3-Average 4=4-Above Average 5=5-High Default Value: 3 |
| 9 | RS_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL | Competency Importance |