EODP_CMP_RF_LVW

(SQL View)
 Index Back

View References Page record

View Refernces Main Record used in Data Privacy Component

SELECT B1.LANGUAGE_CD , A.PNLGRPNAME , E1.DESCR , A.PNLNAME , D1.ITEMLABEL , A.RECNAME , B1.RECDESCR , A.FIELDNAME , F1.LBLTEXT , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , A.EODP_PERS_IDFR , A.EODP_SNSTV ,G1.EODP_PRODUCT_CD , G1.EODP_PROD_DESCR , C1.MENUNAME , C1.MARKET , C1.PORTAL_NAME , C1.PORTAL_OBJNAME , C1.PORTAL_NAVPATH FROM PSRECDEFN B , PSRECDEFNLANG B1 , PSPNLGROUP D , PSPNLGROUPLANG D1 , PSPNLGRPDEFN E , PSPNLGDEFNLANG E1 , PS_EODP_CMPRF_LANG F1 , PS_EODP_CTR_CD_LNG CTG , PS_EODP_CLSFCN_LNG CLS , PS_EODP_PROD_VW G , PS_EODP_PROD_LVW G1 , PS_EODP_COMP_REF A LEFT OUTER JOIN PS_EODP_DETRF_LANG C1 ON A.PNLGRPNAME = C1.PNLGRPNAME WHERE A.RECNAME = B.RECNAME AND B.RECNAME = B1.RECNAME AND A.PNLGRPNAME = E.PNLGRPNAME AND A.PNLGRPNAME = F1.PNLGRPNAME AND A.PNLNAME = F1.PNLNAME AND A.RECNAME = F1.RECNAME AND A.FIELDNAME = F1.FIELDNAME AND E.PNLGRPNAME = E1.PNLGRPNAME AND E.MARKET = E1.MARKET AND A.PNLGRPNAME = D.PNLGRPNAME AND A.PNLNAME = D.PNLNAME AND D.PNLGRPNAME = D1.PNLGRPNAME AND D.PNLNAME = D1.PNLNAME AND D.MARKET = D1.MARKET AND D.MARKET = E.MARKET AND CTG.EODP_CTGRY_CD =A.EODP_CTGRY_CD AND CLS.EODP_CLFNCD = A.EODP_CLFNCD AND E.OBJECTOWNERID = G.EODP_PRODUCT_CD AND G.EODP_PRODUCT_CD = G1.EODP_PRODUCT_CD AND B1.LANGUAGE_CD = D1.LANGUAGE_CD AND D1.LANGUAGE_CD = E1.LANGUAGE_CD AND E1.LANGUAGE_CD = G1.LANGUAGE_CD AND G1.LANGUAGE_CD = C1.LANGUAGE_CD AND C1.LANGUAGE_CD = F1.LANGUAGE_CD AND CTG.LANGUAGE_CD = D1.LANGUAGE_CD AND CLS.LANGUAGE_CD = CTG.LANGUAGE_CD

  • Related Language Record for EODP_CMP_REF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 EODP_COMP_DESCR Character(30) VARCHAR2(30) NOT NULL Component Description
    3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    4 EODP_PAGE_DESCR Character(30) VARCHAR2(30) NOT NULL Page Description
    5 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    6 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 EODP_FIELD_DESCR Character(60) VARCHAR2(60) NOT NULL Field Description
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category Name
    11 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification Name
    12 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    14 EODP_PRODUCT_CD Character(4) VARCHAR2(4) NOT NULL PeopleSoft Product Code. Created for Sensitive Data Framework
    15 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    16 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    17 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    18 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    19 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    20 PORTAL_NAVPATH Long Character CLOB Navigation Path