PERSON_IDTREE_NAMETERRITORY_IDRSF_TR_ORG_S_VW(SQL View) |
Index Back |
|---|---|
View of Manager TerritoriesView that shows all manager territories. This view is used as a search record going into view or add child territories. |
| SELECT A.PERSON_ID_MANAGER , A.TREE_NAME , A.TERRITORY_ID FROM PS_RSF_ACC_SUSER A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | TERRITORY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Territory ID |