RSP_TP_TEAM_VW (SQL View)	Index Back
Account Plans as Team Member Account Plans as Team Member View

RSP_TP_TEAM_VW

(SQL View)

Account Plans as Team Member

Account Plans as Team Member View

SELECT A.SYNCID , C.PERSON_ID , B.OWNER FROM PS_RSP_TP_HEADER A , PS_RSP_TP_TEAM B , PS_RD_PERSON C WHERE A.RSP_UID20 = B.RSP_UID20 AND B.BO_ID_PERSON = C.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

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

3 OWNER Character(1) VARCHAR2(1) NOT NULL Owner
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	OWNER	Character(1)	VARCHAR2(1) NOT NULL	Owner N=No Y=Yes