EODP_CTGR_S_LNG

(SQL View)
 Index Back

Search rec - Maintain Category


SELECT CT.EODP_CTGRY_CD , CD.EODP_CLFNCD ,CTL.LANGUAGE_CD ,CTL.EODP_CTGRY_DESC ,CL.EODP_CFCN_NAME FROM PS_EODP_CTGRY_CODE CT LEFT OUTER JOIN PS_EODP_CTGRY_DTLS CD ON CT.EODP_CTGRY_CD = CD.EODP_CTGRY_CD LEFT OUTER JOIN PS_EODP_CLSFCN_LNG CL ON CL.EODP_CLFNCD=CD.EODP_CLFNCD LEFT OUTER JOIN PS_EODP_CTR_CD_LNG CTL ON CT.EODP_CTGRY_CD = CTL.EODP_CTGRY_CD

  • Related Language Record for EODP_CTGR_SR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
    2 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

    Default Value: 1

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name
    5 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name