SPF_PROJROLE_VW

(SQL View)
 Index Back

Project Role & Competencies VW

Retrieves Role information and it associate competencies. SELECT A.SETID , A.PROJ_ROLE , A.EFFDT , A.DESCR , A.EFF_STATUS , A.SPF_YRS_EXPERIENCE , A.EDUCATION_LVL , B.SETID , B.PROJ_ROLE , B.EFFDT , B.COMPETENCY , C.DESCR , B.EFF_STATUS , A.DESCRLONG FROM PS_SPB_ROLE_ATTRIB A , PS_SPB_ROLECOMPDET B , PS_COMPETENCY_TBL C WHERE A.SETID = B.SETID AND A.EFFDT = B.EFFDT AND A.PROJ_ROLE = B.PROJ_ROLE AND B.COMPETENCY = C.COMPETENCY

SELECT A.SETID , A.PROJ_ROLE , A.SERVICE_METHOD , A.DESCR , A.SPF_YRS_EXPERIENCE , A.EDUCATION_LVL , B.SETID , B.PROJ_ROLE , B.COMPETENCY , C.DESCR , A.DESCRLONG , A.INTERVIEWREQUIRED , A.SP_BILL_METHOD , A.SP_SHOW_BID , A.SP_ADD_ACTIVITY FROM PS_SPB_ROLE_ATTRIB A , PS_SPB_ROLECOMPDET B , PS_COMPETENCY_TBL C WHERE A.SETID = B.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND B.COMPETENCY = C.COMPETENCY

  • Related Language Record: SPF_PROL_LG_VW

    • # 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

    Default Value: R

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SPF_YRS_EXPERIENCE Character(4) VARCHAR2(4) NOT NULL Years Experience

    Prompt Table: SP_EXPERIENCE
    Set Control Field: BUSINESS_UNIT

    6 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
    7 SETID2 Character(5) VARCHAR2(5) NOT NULL 2nd SetId
    8 PROJ_ROLE2 Character(15) VARCHAR2(15) NOT NULL Added for SPF_PROJROLE_VW. Just a view column with no functional value except to narrow down the criteria.
    9 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    10 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    11 DESCRLONG Long Character CLOB Long Description
    12 INTERVIEWREQUIRED Character(1) VARCHAR2(1) NOT NULL Interview Required
    N=No
    Y=Yes
    13 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
    F=Fixed Amount
    M=Milestone
    P=Percentage
    R=Rate Based
    14 SP_SHOW_BID Character(1) VARCHAR2(1) NOT NULL Show Bid
    N=Hide Rate
    Y=Display Rate
    15 SP_ADD_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Allow add activities