RC_CNCT_SITE_VW (SQL View)	Index Back
Person and Site Link View The Following View lists all the sites where the Person is linked to.

RC_CNCT_SITE_VW

(SQL View)

Person and Site Link View

The Following View lists all the sites where the Person is linked to.

SELECT A.BO_ID_1 , C.BO_ID FROM PS_BO_REL A , PS_RD_SITE C , PS_BO_NAME D WHERE A.REL_TYPE_ID IN (11, 12) AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND A.BO_ID_2 = C.BO_ID AND C.BO_ID = D.BO_ID AND D.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

2 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
2	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID