PC_TEAM_EMP_VW

(SQL View)
 Index Back

Project Team Member Empl View

View of assigned members (employees) in project team. Shows the project role that is relevant as of the current date. Though an employee can have multiple roles in the team, at any given time, the employee has just one role.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER , PD.NAME , SC.PROJ_ROLE , SC.START_DT , SC.END_DT , SC.RES_UID , PT.SOURCE_REQ , PT.EMAILID FROM PS_PROJECT_TEAM PT , PS_PROJ_TEAM_SCHED SC , PS_PERSONAL_DATA PD WHERE PT.BUSINESS_UNIT = SC.BUSINESS_UNIT AND PT.PROJECT_ID = SC.PROJECT_ID AND PT.TEAM_MEMBER_CLASS = SC.TEAM_MEMBER_CLASS AND PT.TEAM_MEMBER_IND = SC.TEAM_MEMBER_IND AND PT.TEAM_MEMBER = SC.TEAM_MEMBER AND PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND %CurrentDateIn BETWEEN SC.START_DT AND SC.END_DT AND PD.EMPLID = PT.TEAM_MEMBER

  • Parent record: PROJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJECT.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT_VW

    3 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PC_TEAM_SUMR_VW

    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    6 START_DT Date(10) DATE Start Date
    7 END_DT Date(10) DATE End Date
    8 RES_UID Character(15) VARCHAR2(15) NOT NULL Resource ID
    9 SOURCE_REQ Character(25) VARCHAR2(25) NOT NULL Source Requirement ID
    10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address