SPF_PROL_LG_VW

(SQL View)
 Index Back

Project Role & Compenencies VW

Related Language view 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 ,C.LANGUAGE_CD , L.DESCR , C.DESCR , L.DESCRLONG FROM PS_SPB_ROLE_ATTRIB A ,PS_SPB_RATTRIB_LNG L , PS_SPB_ROLECOMPDET B , PS_COMPETENCY_LANG C WHERE A.SETID = B.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND B.COMPETENCY = C.COMPETENCY AND A.SETID =L.SETID AND A.PROJ_ROLE =L.PROJ_ROLE AND A.SERVICE_METHOD =L.SERVICE_METHOD AND L.LANGUAGE_CD =C.LANGUAGE_CD

  • Related Language Record for SPF_PROJROLE_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    7 DESCRLONG Long Character CLOB Long Description