HCR_CM_RL_ACC_I(SQL View) |
Index Back |
---|---|
Accomplishments Role Interf.VInterface View for accomplishments that profile a role |
SELECT A.POSITION_NBR , A.JOB_FAMILY , A.SETID , A.JOBCODE , A.JOB_TASK , A.EFFDT , A.ACCOMPLISHMENT , A.CM_IMPORTANCE FROM PS_CM_ROLE_ACCOMPS A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: %RECNAME_EDIT |
2 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL |
Job Family
Prompt Table: JOB_FAMILY_TBL |
3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
5 | JOB_TASK | Character(6) | VARCHAR2(6) NOT NULL |
Job Task
Prompt Table: JOB_TASK_TBL |
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 |