RD_ACCMN_DST_VW (SQL View)	Index Back
Account as Manager View Shows all the Manager's acount team members

RD_ACCMN_DST_VW

(SQL View)

Account as Manager View

Shows all the Manager's acount team members

SELECT D.PERSON_ID_MANAGER , A.PERSON_ID , B.ACCT_OWNER , C.SYNCID FROM PS_RD_PERSON A , PS_RD_ACCT_TM_VW B , PS_BO_ROLE C , PS_RSF_ACC_SUSER D WHERE B.BO_ID_1 = A.BO_ID AND B.BO_ID_2 = C.BO_ID AND B.ROLE_TYPE_ID_2 = C.ROLE_TYPE_ID AND D.PERSON_ID = A.PERSON_ID

# 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 ACCT_OWNER Character(1) VARCHAR2(1) NOT NULL Account Team Owners....................
N=No
Y=Yes

4 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	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	ACCT_OWNER	Character(1)	VARCHAR2(1) NOT NULL	Account Team Owners.................... N=No Y=Yes
4	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.