RSEC_VLK_REC_VW

(SQL View)
 Index Back

View List Records

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

SELECT DISTINCT A.RECNAME FROM PSRECFIELD A WHERE A.FIELDNAME = 'RSEC_VLIST_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).