PC_ATEAM_CNT_VW

(SQL View)
 Index Back

# of Activity Team Members

View that shows the number of team members per activity.

SELECT PA.BUSINESS_UNIT , PA.PROJECT_ID , PA.ACTIVITY_ID , COUNT(*) FROM PS_PROJ_ACT_TEAM PA WHERE PA.TEAM_MEMBER_CLASS = 'L' AND PA.TEAM_MEMBER_IND = 'E' GROUP BY PA.BUSINESS_UNIT, PA.PROJECT_ID, PA.ACTIVITY_ID

  • 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_COUNT Number(4,0) SMALLINT NOT NULL Project Team Count