PC_PTEAM_CNT_VW

(SQL View)
 Index Back

Number of Project Team Members

View that shows the number of team members per project.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , COUNT(*) FROM PS_PROJECT_TEAM PT WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' GROUP BY PT.BUSINESS_UNIT, PT.PROJECT_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 TEAM_COUNT Number(4,0) SMALLINT NOT NULL Project Team Count