EODP_CTGR_FL_VW

(SQL View)
Index Back

Category Code description vw

Category Code from Rec Field tablae and description form Category table, to be used in pages

SELECT DISTINCT RF.EODP_CTGRY_CD ,CT.EODP_CTGRY_DESC FROM ps_EODP_RECFIELD RF , PS_EODP_CTGRY_CODE CT WHERE CT.EODP_CTGRY_CD = RF.EODP_CTGRY_CD

  • Related Language Record: EODP_CGFLVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
    2 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name