PC_ACTDETAIL_LG

(SQL View)
 Index Back

Activity ID Detail lang view

Language view for PC_ACT_DETAIL

SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,L.LANGUAGE_CD ,L.DESCR FROM PS_PROJ_ACTIVITY A , PS_PROJ_ACTIVTY_LG L WHERE A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.PROJECT_ID = L.PROJECT_ID AND A.ACTIVITY_ID = L.ACTIVITY_ID AND A.SUMMARY_ACT = 'N' AND A.EFF_STATUS = 'A'

  • Related Language Record for PC_ACT_DETAIL

    • # 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 ACTIVITY_ID_DETAIL Character(15) VARCHAR2(15) NOT NULL This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description