PC_ACTEAM_TR_LG

(SQL View)
 Index Back

Activity Time Report Language

Language record for PC_ACTEAM_TR_VW. This provides an easy to use on-line prompt for the Project Activities for Time Reporting in Expenses. This prompt view should only be used if the project's charging level is set to '1', '2', or '3' (costing), and the project's time report charging level is set to 'D' (detail). This prompt will list all activities at or below the project's charging level and is also based on enforce team setting.

SELECT B.EMPLID ,A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ROW_NUMBER_5 ,A.WBS_ID ,A.ACTIVITY_ID ,D.LANGUAGE_CD ,D.DESCR FROM PS_PROJ_ACTIVITY A , PS_PERSONAL_DATA B , PS_PROJECT C , PS_PROJ_ACTIVTY_LG D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND A.ACTIVITY_ID = D.ACTIVITY_ID AND C.CHARGING_LEVEL <> 'D' AND %NumToChar(A.LEVEL_NUM) >= C.CHARGING_LEVEL AND A.EFF_STATUS = 'A' AND A.SUMMARY_ACT = 'N' 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 for PC_ACTEAM_TR_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 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description