EOEW_SFLDTTM_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 EOEW_SRC_OBJ , EOEW_SRCCOLALIAS , FIELDNAME FROM PS_EOEW_ETLC_FLST WHERE EOEW_SRC_TYP='2' AND FIELDTYPE = 6

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