EODI_CON_REC_VW

(SQL View)
Index Back

Dynamic Record Prompt View


SELECT A.RECNAME , A.RECDESCR FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND B.FIELDNAME = 'EODI_CON_SBR' AND A.RECNAME <> 'EODI_CON' AND A.RECNAME <> 'EODI_DYN_CONTEX'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EODI_RECNAME Character(15) VARCHAR2(15) NOT NULL Recname
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description