PC_ACTEAM_TE_VW

(SQL View)
 Index Back

Project Activity Prompt View

This provides an easy to use on-line prompt for the Project Activities. The activity list that shows in the prompt is based on the team based enforce setting.

SELECT B.EMPLID ,A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ROW_NUMBER_5 ,A.WBS_ID ,A.ACTIVITY_ID ,A.DESCR FROM PS_PROJ_ACTIVITY A , PS_PERSONAL_DATA B WHERE A.EFF_STATUS = 'A' AND A.COSTING_ACT_SW = 'Y' AND ( A.ENFORCE IN ('N','T') OR EXISTS ( SELECT 'X' FROM PS_PROJ_ACT_TEAM PT WHERE A.BUSINESS_UNIT = PT.BUSINESS_UNIT AND A.PROJECT_ID = PT.PROJECT_ID AND A.ACTIVITY_ID = PT.ACTIVITY_ID AND PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND B.EMPLID = PT.TEAM_MEMBER))

  • Related Language Record: PC_ACTEAM_TELVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
    5 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID
    6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description