RSF_TER_USR2_VW (SQL View)	Index Back
From Rep Security All the people that report to a manager based on the territory tree.

RSF_TER_USR2_VW

(SQL View)

From Rep Security

All the people that report to a manager based on the territory tree.

SELECT DISTINCT A.TREE_NAME ,A.PERSON_ID_MANAGER , A.TERRITORY_ID , A.PERSON_ID , B.BO_NAME_DISPLAY FROM PS_RSF_ACC_SUSER A , PS_RD_PERSON P , PS_BO_NAME B , PS_RSF_SUSER C WHERE A.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.PERSON_ID = C.PERSON_ID AND C.STATUS = 'A' AND A.TREE_NAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

2 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

3 TO_TERRITORY Character(20) VARCHAR2(20) NOT NULL New Territory

4 TO_USER Character(15) VARCHAR2(15) NOT NULL New Sales Rep

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
3	TO_TERRITORY	Character(20)	VARCHAR2(20) NOT NULL	New Territory
4	TO_USER	Character(15)	VARCHAR2(15) NOT NULL	New Sales Rep
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object