RD_ACCTM_DST_VW (SQL View)	Index Back
Account Team Member View Account Team Member View which contain both account owner and account team member

RD_ACCTM_DST_VW

(SQL View)

Account Team Member View

Account Team Member View which contain both account owner and account team member

SELECT A.PERSON_ID , B.ACCT_OWNER , C.SYNCID FROM PS_RD_PERSON A , PS_RD_ACCT_TM_VW B , PS_BO_ROLE C 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ACCT_OWNER Character(1) VARCHAR2(1) NOT NULL Account Team Owners....................
N=No
Y=Yes

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