EOPCMIG_FVAL_VW

(SQL View)
Index Back

SELECT DISTINCT MD.EOPCDEFN_ID , MF.FIELDNAME , MF.EOPCKEYVALUE FROM PS_EOPCMAIN_DISP MD , PS_EOPCMAIN_FIELDS MF WHERE MD.EOPCMAIN_ID = MF.EOPCMAIN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 EOPCKEYVALUE Character(100) VARCHAR2(100) NOT NULL Field Value