PC_OPRID_PRJVW

(SQL View)
 Index Back

My Projects list

FROM PS_PC_OPRID_PRJACT A , PS_PROJECT B Excludes Summary Projects

SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , B.DESCR , B.PROJECT_TYPE , B.START_DT , B.END_DT , C.PROJECT_MANAGER , %Substring(D.FIRST_NAME %Concat ' ' %Concat D.LAST_NAME, 1, 50) , EMAIL.EMAIL_ADDR FROM PS_PC_OPRID_PRJACT A , PS_PROJECT B LEFT OUTER JOIN PS_PROJECT_MGR C ON B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID LEFT OUTER JOIN PS_PERSONAL_DATA D ON D.EMPLID = C.PROJECT_MANAGER LEFT OUTER JOIN PS_EMAIL_ADDRESSES EMAIL ON D.EMPLID = EMAIL.EMPLID AND EMAIL.E_ADDR_TYPE = 'BUSN' WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.SUMMARY_PRJ = 'N' AND (C.EFFDT IS NULL OR C.EFFDT=( SELECT MAX(EFFDT) FROM PS_PROJECT_MGR A_ED WHERE A_ED.BUSINESS_UNIT = C.BUSINESS_UNIT AND A_ED.PROJECT_ID = C.PROJECT_ID AND A_ED.EFFDT <= %CurrentDateIn))

  • Related Language Record: PC_OPRID_PRJLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment
    6 START_DT Date(10) DATE Start Date
    7 END_DT Date(10) DATE End Date
    8 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
    9 PROJ_MGR_NAME Character(50) VARCHAR2(50) NOT NULL Project Manager Name
    10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address