RSF_TR_SRCH_VW

(SQL View)
 Index Back

Territory Tree Search View

This is view is a clone of RSF_TR_BRCH_VW, except there is an extra join on RSF_TERRITORY to show the decription and related language description. This view is primarily used in the configurable search definition for RSF_TR_SRCH component where the user is prompting for a Tree Name. The tree name should be secure to only those tree names the user is authorized.

SELECT DISTINCT E.OPRID , A.TREE_NAME , A.EFFDT , F.DESCR , A.TREE_BRANCH FROM PSTREEPROMPT A ,PSTREEDEFN B , PS_RSF_TR_NEW_TREE C , PS_RSF_TR_TEAM_VW D ,PSOPRALIAS E , PS_RSF_TERRITORY F WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = B.EFFDT AND B.TREE_STRCT_ID = 'TERRITORY_TREE' AND C.TREE_NAME = A.TREE_NAME AND D.TREE_NAME = A.TREE_NAME AND E.OPRALIASTYPE = 'PER' AND D.PERSON_ID = E.PERSON_ID AND C.TREE_NAME = F.TREE_NAME AND C.TREE_NODE = F.TERRITORY_ID

  • Related Language Record: RSF_TR_S_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 TREE_BRANCH Character(20) VARCHAR2(20) NOT NULL Tree Branch