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

RSEC_SL_ROLE_VW

(SQL View)

Membership List Records

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

SELECT 0 , ROLENAME FROM %Table(PSROLEDEFN)

# 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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

#	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	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).