CAF_PERSRECS_VW

(SQL View)
Index Back

My Personalizations records

This view contains the records that can be considered My Personalization records. it is used as Prompt View of CAF_FCT_PVPTTBL. The My Personalization records should have the field OPRID.

SELECT R.RECNAME , R.RECDESCR FROM PSRECDEFN R WHERE R.INDEXCOUNT > 0 AND R.RECTYPE = 0 AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB F WHERE R.RECNAME = F.RECNAME AND F.FIELDNAME = 'OPRID')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description