PV_SP_PJROLE_WK(SQL Table) |
Index Back |
|---|---|
Service Project Role Work tblService Project Role Work tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 3 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 6 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 7 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL | Years Experience |
| 8 | EDUCATION_LVL | Character(2) | VARCHAR2(2) NOT NULL |
Education Level
1=No Formal Education 10=Associate Degree 11=Three Years College 12=Four Years College 13=Bachelor Degree 14=Post Bachelors 15=First Professional 16=Post-First Professional 17=Masters Degree 18=Post Masters 19=Sixth Year Degree 2=Elementary School Completed 20=Post Sixth Year 21=Doctorate Degree 22=Post Doctorate 3=Some High School 4=High School Graduate 5=Terminal Occupation Prog DNC 6=Terminal Occupation Program 7=Some College - Less than 1 Yr 8=One Year College 9=Two Years College A=University - Advanced T=Trade School U=University |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |