RS_ALLORGTRE_VW

(SQL View)
 Index Back

View used for RS Org Tree


SELECT DISTINCT F.SETID , F.DESCR , A.DESCR , A.EFFDT FROM PSTREEDEFN A , %Table(SET_CNTRL_TREE) B , PSTREESTRCT C , %Table(INSTALLATION_RS) D , %Table(SETID_TBL) F WHERE A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.TREE_NAME = D.TREE_NAME AND A.TREE_STRCT_ID = C.TREE_STRCT_ID AND (C.NODE_RECNAME = D.ORG_RECNAME OR C.DTL_RECNAME = D.ORG_RECNAME) AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN E WHERE E.SETID = A.SETID AND E.TREE_NAME = A.TREE_NAME AND E.SETCNTRLVALUE = A.SETCNTRLVALUE AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND A.SETID = F.SETID

  • Related Language Record: RS_ALLORGTR_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_NAME_SETID Character(5) VARCHAR2(5) NOT NULL TableSet
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Prompt Table: %EDITTABLE

    3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date