EODP_CTGR_SR_VW

(SQL View)
 Index Back

Search rec - Maintain Category


SELECT CT.EODP_CTGRY_CD , CD.EODP_CLFNCD , CT.EODP_CTGRY_DESC ,CL.EODP_CFCN_NAME , CD.EODP_PERS_IDFR ,CD.EODP_SNSTV , CD.EODP_SYS_FLG ,CD.EODP_CLFNCD 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 CL ON CL.EODP_CLFNCD=CD.EODP_CLFNCD

  • Related Language Record: EODP_CTGR_S_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_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

    Default Value: 1

    3 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name
    4 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name
    5 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    6 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    7 EODP_SYS_FLG Character(1) VARCHAR2(1) NOT NULL Delivered
    A=All
    N=No
    Y=Yes
    8 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number