GM_TEAM_EMP_VW

(SQL View)
 Index Back

Project Team Member Empl View

Grants 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 one role. New in Rel 89

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 , PT.PERCENTAGE , PT.APPT_TYPE_MTH_ACAD , PT.APPT_TYPE_MTH_CAL , PT.APPT_TYPE_MTH_SUMR 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_IND = SC.TEAM_MEMBER_IND AND PT.TEAM_MEMBER = SC.TEAM_MEMBER 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
    11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    12 APPT_TYPE_MTH_ACAD Number(6,2) DECIMAL(5,2) NOT NULL Academic Appointment Months
    13 APPT_TYPE_MTH_CAL Number(6,2) DECIMAL(5,2) NOT NULL Calendar Appointment Months
    14 APPT_TYPE_MTH_SUMR Number(6,2) DECIMAL(5,2) NOT NULL Summer Appointment Months