PC_ACTEAM_EMPVW

(SQL View)
 Index Back

Activity Team Member Empl View

View of assigned members (employees) in activity team. Only the team members that are in the activity as of the current date will be shown.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.ACTIVITY_ID , PT.TEAM_MEMBER , PT.PROJ_ROLE FROM PS_PROJ_ACT_TEAM PT , PS_PROJ_ACTIVITY PA WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND PT.BUSINESS_UNIT = PA.BUSINESS_UNIT AND PT.PROJECT_ID = PA.PROJECT_ID AND PT.ACTIVITY_ID = PA.ACTIVITY_ID AND %CurrentDateIn BETWEEN PA.START_DT AND PA.END_DT

  • 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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PC_TEAM_SUMR_VW

    5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE