SETIDPrompt Table: SETID_TBL
PROJ_ROLESERVICE_METHODD=Deliverable
M=Multi Resource
R=Resource
COMPETENCYPrompt Table: SP_CMP_SETID_VW
Prompt Table: REVW_RATING_TBL
Prompt Table: SP_EXPERIENCE
B=Block
N=No Action
W=Warn
SPB_ROLECOMPDET(SQL Table) |
Index Back |
|---|---|
Competencies by Project roleCompetencies by Project role |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | SERVICE_METHOD |
Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 4 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: SP_CMP_SETID_VW |
| 5 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency
Prompt Table: REVW_RATING_TBL |
| 6 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table: SP_EXPERIENCE |
| 7 | SP_MATRIX_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Track Skill level actions
B=Block N=No Action W=Warn |