PC_PARNT_ACT_LG

(SQL View)
Index Back

Parent Activity Prompt Lang VW

This is the related language view for PC_PARNT_ACT_VW (prompt table for summary activities).

SELECT %Substring(A.SETCNTRLVALUE, 1, 15) , A.TREE_NAME , A.EFFDT , %Substring(A.TREE_NODE, 1, 15) , B.LANGUAGE_CD , B.DESCR FROM PSTREENODE A , PS_PROJ_ACTIVTY_LG B WHERE A.SETCNTRLVALUE = B.PROJECT_ID AND A.TREE_NODE = B.ACTIVITY_ID AND A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PSTREEDEFN C WHERE C.EFFDT <= %CurrentDateIn AND A.SETCNTRLVALUE = C.SETCNTRLVALUE AND A.TREE_NAME = C.TREE_NAME)

  • Related Language Record for PC_PARNT_ACT_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    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