UPG_CM_ACMP_TAO(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 | CM_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 | CM_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL | Competency Importance |