EP_REC_ITEM_VW

(SQL View)
 Index Back

Records that contain Item Id

View of all records that contain the field EP_ITEM_ID. Used as a prompt for the EP_ITEM_PROMPT field.

SELECT A.RECNAME , A.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_TITLE') AND NOT EXISTS ( SELECT 'X' FROM PSRECFIELD D WHERE D.RECNAME = A.RECNAME AND ( D.FIELDNAME = 'LANGUAGE_CD' OR D.FIELDNAME = 'EP_SUB_ID' ) ) AND A.RECNAME NOT IN ('EP_COMP_ITEM_VW','EP_GOAL_TBL','EP_GOAL_TBLX','EP_INIT_TBL', 'EP_INIT_TBLX', 'EP_ITEM_SRCH_VW', 'EP_MISSION_TBL', 'EP_MISSION_TBLX', 'EP_RESP_TBL', 'EP_RESP_TBLX', 'HRS_EP_RESP_I')

# 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