PC_TEAM_REMV_VW

(SQL View)
 Index Back

# of Proj Team Early Removals

This view shows the total number of team member early removals per project. If the same employee is removed more than once, each removal is counted.

SELECT BUSINESS_UNIT , PROJECT_ID , COUNT(*) FROM PS_PROJ_TEAM_SCHED WHERE TEAM_MEMBER_CLASS = 'L' AND TEAM_MEMBER_IND = 'E' AND REMOVAL_FLAG = 'Y' GROUP BY BUSINESS_UNIT, 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

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT_VW

    3 PC_NUM_TEAM_REMOVE Number(5,0) INTEGER NOT NULL Number of Team Member Early Removals