EODP_FIELDSLIST

(SQL View)
 Index Back

Field Prompt View

Field Prompt View 3 Unions Union 1: Fields from subrecord + Main Record from EODP_RECFIELD Union 2: Fields that are categorized/classified from subrecord used in Main Record. This includes sub-record fields categorized/classified in Main Record + sub-record fields categorized/classified in any other record Union 3: Records which do not have any fields categorized/classified, but subrecord fields used in main record are categorized/classified using other Main Records

SELECT DISTINCT B.RECNAME , B.FIELDNAME , C.LONGNAME FROM PS_EODP_RECFLDDB B , PSDBFLDLABL C WHERE B.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1 UNION SELECT DISTINCT A.RECNAME ,A.FIELDNAME ,C.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL C WHERE A.FIELDNAME=C.FIELDNAME AND C.DEFAULT_LABEL=1 AND EXISTS ( SELECT 'X' FROM PS_EODP_RECFLDDB1 X WHERE X.RECNAME_PARENT=A.RECNAME_PARENT AND X.RECNAME<>A.RECNAME AND X.RECNAME_PARENT<>' ' AND X.FIELDNAME=A.FIELDNAME) UNION SELECT DISTINCT A.RECNAME ,A.FIELDNAME ,C.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL C WHERE A.FIELDNAME=C.FIELDNAME AND C.DEFAULT_LABEL=1 AND NOT EXISTS ( SELECT 'X' FROM PS_EODP_RECFLDDB1 X WHERE X.RECNAME=A.RECNAME) AND EXISTS( SELECT 'X' FROM PS_EODP_RECFLDDB1 X1 WHERE X1.RECNAME_PARENT=A.RECNAME_PARENT AND X1.FIELDNAME=A.FIELDNAME)

  • Related Language Record: EODP_FIELDS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 EODP_FIELD_DESCR Character(60) VARCHAR2(60) NOT NULL Field Description