REORG_IDTO_TREETO_USERRSF_ACC_TOREPVW(SQL View) |
Index Back |
|---|---|
To Rep PromptPurpose of this view is to select new reps in reorganization worksheet. |
| SELECT DISTINCT R.REORG_ID , A.TREE_NAME , A.PERSON_ID , B.BO_NAME FROM PS_RSF_TR_TEAM A , PS_RD_PERSON P , PS_BO_NAME B ,PS_RSF_SUSER_A_VW S ,PSTREENODE X , PS_RSF_TR_REORG R WHERE A.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.PERSON_ID = S.PERSON_ID AND A.TREE_NAME <> ' ' AND A.TREE_NAME = X.TREE_NAME AND A.TERRITORY_ID = X.TREE_NODE AND X.EFFDT = R.EFFDT_TO AND X.TREE_NAME = R.TO_TREE |
| # | 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 |
| 3 | TO_USER |
Character(15) | VARCHAR2(15) NOT NULL | New Sales Rep |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |