EODP_CSECRF_VW

(SQL View)
 Index Back

View Reference Secondary/Popup

View Refernces Main Record used in Data Privacy Component

SELECT 'BLANK_DP' , ' ' , A.PNLNAME , C.DESCRLONG , A.RECNAME , B.RECDESCR , A.FIELDNAME , A.LBLTEXT , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , A.EODP_PERS_IDFR , A.EODP_SNSTV , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EODP_COMP_REF A , PSRECDEFN B , PSPNLDEFN C , PS_EODP_CTGRY_CODE CTG , PS_EODP_CLSFCN CLS WHERE A.PNLGRPNAME = 'BLANK_DP' AND A.RECNAME = B.RECNAME AND A.PNLNAME = C.PNLNAME AND A.EODP_CTGRY_CD = CTG.EODP_CTGRY_CD AND A.EODP_CLFNCD = CLS.EODP_CLFNCD

  • Related Language Record: EODP_CSECRF_LVW

    • # 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 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    10 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    11 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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