RSF_ACC_TO_VW (SQL View)	Index Back
To Rep Security View to show only active sales reps to whom I have security access.

RSF_ACC_TO_VW

(SQL View)

To Rep Security

View to show only active sales reps to whom I have security access.

SELECT DISTINCT A.TREE_NAME , A.PERSON_ID_MANAGER , A.PERSON_ID , B.BO_NAME , 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 TO_TREE Character(18) VARCHAR2(18) NOT NULL New Tree Name

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

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

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	TO_TREE	Character(18)	VARCHAR2(18) NOT NULL	New Tree Name
2	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
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
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object