RSEC_SL_PER_VW (SQL View)	Index Back
Membership List Records Contains all records that are defined as 'Membership List' records for application security.

RSEC_SL_PER_VW

(SQL View)

Membership List Records

Contains all records that are defined as 'Membership List' records for application security.

SELECT DISTINCT SYNCID , PERSON_ID , BO_ID FROM PS_RD_PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_REL_SYNCID Number(10,0) DECIMAL(10) NOT NULL The related synchronization id stores the syncid of the primary record of the security object. This field is used in creating the security list record.

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

3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_REL_SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The related synchronization id stores the syncid of the primary record of the security object. This field is used in creating the security list record.
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID