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

RSEC_MLK_REC_VW

(SQL View)

Membership List Records

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

SELECT DISTINCT A.RECNAME FROM PSRECFIELD A WHERE A.FIELDNAME = 'RSEC_MLIST_SBR' AND EXISTS( SELECT 'X' FROM PSRECFIELD WHERE RECNAME = A.RECNAME AND FIELDNAME = 'RSEC_PROFILE_ID')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).