RSF_TERR_NODEV2

(SQL View)
Index Back

Territory Prompt

Territory Prompt for New Territory

SELECT R.REORG_ID , A.TREE_NAME , A.TERRITORY_ID , A.DESCR FROM PS_RSF_TERRITORY A , PSTREENODE B ,PS_RSF_TR_NEW_TREE C , PS_RSF_TR_REORG R WHERE B.EFFDT = R.EFFDT_TO AND A.TREE_NAME = C.TREE_NAME AND B.TREE_NAME = A.TREE_NAME AND A.TERRITORY_ID = B.TREE_NODE AND B.TREE_NAME = R.TO_TREE

  • Related Language Record: RSF_TER_NOD_LN2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REORG_ID Character(15) VARCHAR2(15) NOT NULL Reorganization ID
    2 TO_TREE Character(18) VARCHAR2(18) NOT NULL New Tree Name

    Prompt Table: RSF_TR_TREE_VW

    3 TO_TERRITORY Character(20) VARCHAR2(20) NOT NULL New Territory
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description