PV_SP_PJROLE_VW (SQL View)	Index Back
Requisition sPro Search View

PV_SP_PJROLE_VW

(SQL View)

Requisition sPro Search View

SELECT T.SETID , T.ROLE_TYPE , T.DESCR , R.PROJ_ROLE , R.DESCR , RA.SERVICE_METHOD , X.XLATLONGNAME , RA.SPF_YRS_EXPERIENCE , RA.EDUCATION_LVL , RA.DESCRLONG FROM PS_PROJ_ROLE R , PS_SPB_ROLESBYTYPE RT , PS_SPB_ROLE_TYPE T , PS_SET_CNTRL_GROUP S , PS_SPB_ROLE_ATTRIB RA , PSXLATITEM X WHERE S.SETCNTRLVALUE = T.SETID AND RT.SETID = T.SETID AND RT.ROLE_TYPE = T.ROLE_TYPE AND S.REC_GROUP_ID = 'PC_18' AND S.SETID = R.SETID AND R.PROJ_ROLE = RT.PROJ_ROLE AND RA.SETID = R.SETID AND RA.PROJ_ROLE = R.PROJ_ROLE AND X.FIELDNAME = 'SERVICE_METHOD' AND X.FIELDVALUE = RA.SERVICE_METHOD AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

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 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

8 SPF_YRS_EXPERIENCE Character(4) VARCHAR2(4) NOT NULL Years Experience

9 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

10 DESCRLONG Long Character CLOB Long Description

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
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	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
8	SPF_YRS_EXPERIENCE	Character(4)	VARCHAR2(4) NOT NULL	Years Experience
9	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
10	DESCRLONG	Long Character	CLOB	Long Description