EOEW_FIELD_VW

(SQL View)
 Index Back

Field List from EOEW_ETLC_FLST

Field list from PSRECFIELD where subrecords are resolve by application class FIELDLIST.

SELECT DISTINCT A.FIELDNAME , A.EOEW_SRCCOLALIAS FROM PS_EOEW_ETLC_FLST A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND A.EOEW_SRC_TYP='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias