EODP_CLFN_FL_VW

(SQL View)
Index Back

Classification filter View


SELECT DISTINCT RF.EODP_CLFNCD ,CF.EODP_CFCN_NAME FROM PS_EODP_RECFIELD RF , ps_EODP_CLSFCN CF WHERE CF.EODP_CLFNCD = RF.EODP_CLFNCD

  • Related Language Record: EODP_CNFLVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code
    2 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name