RB_TSK_SLSMG_VW (SQL View)	Index Back
Manager Access Rollup View This view returns all distinct sales team members for a given sales manager.

RB_TSK_SLSMG_VW

(SQL View)

Manager Access Rollup View

This view returns all distinct sales team members for a given sales manager.

SELECT DISTINCT A.PERSON_ID_MANAGER , A.PERSON_ID , C.BO_NAME_DISPLAY FROM PS_RSF_ACC_SUSER A , PS_RD_PERSON B , PS_BO_NAME C WHERE B.PERSON_ID = A.PERSON_ID AND C.BO_ID = B.BO_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 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	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object