PGM_EPT_TREE_VW

(SQL View)
 Index Back

View of all BU/EPT

This view returns all business units with an enterprise program tree.

SELECT A.BUSINESS_UNIT , C.DESCR , B.TREE_NAME , B.EFFDT FROM PS_BUS_UNIT_OPT_PC A , PSTREEDEFN B , PS_BUS_UNIT_TBL_FS C WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.TREE_NAME = A.PGM_EPT_NAME AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSTREEDEFN D WHERE D.SETCNTRLVALUE = B.SETCNTRLVALUE AND D.TREE_NAME = B.TREE_NAME AND D.EFFDT <= %CurrentDateIn )

  • Related Language Record: PGM_EPTREE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    4 EFFDT Date(10) DATE Effective Date