PC_TEAM_NAV_VW

(SQL View)
 Index Back

Project Team NavBar

Project Team NavBar

SELECT PT.OPRID , PT.TEAM_MEMBER , JOB.JOBCODE , PT.PERSON_NAME , JOB.DESCR , PT.PHONE , CASE WHEN PT.EMAILID IS NULL THEN OPRDEFN.EMAILID ELSE PT.EMAILID END , PHOTO.EMPLOYEE_PHOTO FROM PS_PC_TEAM_UNQ_VW PT LEFT OUTER JOIN PS_PC_EMPLJOB_VW JOB ON JOB.EMPLID = PT.TEAM_MEMBER LEFT OUTER JOIN PS_EMPL_PHOTO PHOTO ON PHOTO.EMPLID = PT.TEAM_MEMBER AND PHOTO.PHOTO_SIZENAME = 'PAGE' LEFT OUTER JOIN PSOPRDEFN OPRDEFN ON OPRDEFN.EMPLID = PT.TEAM_MEMBER AND OPRDEFN.ACCTLOCK = 0 WHERE (OPRDEFN.OPRID IS NULL OR OPRDEFN.OPRID = ( SELECT MAX(OPRDEFN2.OPRID) FROM PSOPRDEFN OPRDEFN2 WHERE OPRDEFN2.EMPLID = OPRDEFN.EMPLID))

  • Related Language Record: PC_TEAM_NAV_LVW

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    4 PERSON_NAME Character(100) VARCHAR2(100) NOT NULL Name
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    8 EMPLOYEE_PHOTO Image / Attachment(256) VARCHAR2(256) Employee Photograph