RSEC_DYNMEMB_VW (SQL View)	Index Back
Dynamic Memberships Membership definition to be used to related to a Security Key.

RSEC_DYNMEMB_VW

(SQL View)

Dynamic Memberships

Membership definition to be used to related to a Security Key.

SELECT RSEC_MEMBER_ID , RSEC_OBJECT_ID , DESCR FROM %Table(RSEC_MEMBERDEFN) WHERE RSEC_DOMAIN_TYPE = '0001' AND SQLID <> ' ' AND STATUS = 'A'

Related Language Record: RSEC_DYNMEMBLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_MEMBER_ID Character(30) VARCHAR2(30) NOT NULL Security Membership ID for application security membership definition.

2 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.
Prompt Table: RSEC_MEM_OBJ_VW

3 RSEC_DESCR Character(30) VARCHAR2(30) NOT NULL Membership or view list description field used in application security views.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_MEMBER_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Membership ID for application security membership definition.
2	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects. Prompt Table: RSEC_MEM_OBJ_VW
3	RSEC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Membership or view list description field used in application security views.