PC_ACTEAM_TLLVW

(SQL View)
 Index Back

Activity team view for T&L

Activity team language view for use in Time and Labor product

SELECT B.EMPLID ,A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,C.LANGUAGE_CD ,C.DESCR FROM PS_PROJ_ACTIVITY A , PS_PERSONAL_DATA B , PS_PROJ_ACTIVTY_LG C WHERE A.EFF_STATUS = 'A' AND A.SUMMARY_ACT = 'N' AND %Join(COMMON_KEYS, PROJ_ACTIVITY A, PROJ_ACTIVTY_LG C) AND ( A.ENFORCE IN ('N','E') 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 for PC_ACTEAM_TL_VW

    • # 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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description