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

RSF_ACC_FROM_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.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 FROM_USER Character(15) VARCHAR2(15) NOT NULL Current Owner

4 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	FROM_USER	Character(15)	VARCHAR2(15) NOT NULL	Current Owner
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object