EP_REC_SUB_VW

(SQL View)
 Index Back

Records that contain SubItem

View of all records that contain the field EP_SUB_ID. Used as a prompt for the EP_SUB_PROMPT field.

SELECT RECNAME , RECDESCR FROM PSRECDEFN A WHERE EXISTS ( SELECT 'X' FROM PSRECFIELD B WHERE B.RECNAME = A.RECNAME AND B.FIELDNAME = 'EP_ITEM_ID' AND (B.FIELDNUM = 1 OR B.FIELDNUM = 2)) AND EXISTS ( SELECT 'X' FROM PSRECFIELD C WHERE C.RECNAME = A.RECNAME AND C.FIELDNAME = 'EP_SUB_ID' AND (C.FIELDNUM = 3 OR C.FIELDNUM = 4)) AND EXISTS ( SELECT 'X' FROM PSRECFIELD D WHERE D.RECNAME = A.RECNAME AND D.FIELDNAME = 'EP_TITLE') AND NOT EXISTS ( SELECT 'X' FROM PSRECFIELD E WHERE E.RECNAME = A.RECNAME AND E.FIELDNAME = 'LANGUAGE_CD' )

# 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