EODP_SR_DWN_LVW

(SQL View)
 Index Back

Search reference View

Download language record for search reference grid

SELECT SR.PTSF_SRCCAT_NAME ,SL.DESCR100 ,SR.PTSF_SBO_NAME ,SR.PTSF_SOURCE_NAME , SR.RECNAME , SR.FIELDNAME ,SL.LANGUAGE_CD ,SR.EODP_ISCOMSRCH , SR.PTSF_ISGBLSRCH ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,PD.EODP_PROD_DESCR ,SD.EODP_QUERYNAME ,QD.EODP_QUERY_DESCR FROM PS_EODP_SRCH_REF SR LEFT OUTER JOIN PS_EODP_SRCH_DTL SD ON SR.PTSF_SRCCAT_NAME = SD.PTSF_SRCCAT_NAME AND SR.PTSF_SBO_NAME = SD.PTSF_SBO_NAME AND SR.PTSF_SOURCE_NAME = SD.PTSF_SOURCE_NAME AND SR.RECNAME = SD.RECNAME AND SR.FIELDNAME = SD.FIELDNAME , PS_EODP_RECFLDDB RF , PSPTSF_CAT_LANG SL LEFT OUTER JOIN PS_EODP_SRHPRD_LVW PD ON PD.PTSF_SRCCAT_NAME = SL.PTSF_SRCCAT_NAME AND SL.LANGUAGE_CD = PD.LANGUAGE_CD ,PS_EODP_QRYDSC_LVW QD ,PS_EODP_CLSFCN_LNG CL ,PS_EODP_CTR_CD_LNG CT WHERE SR.RECNAME = RF.RECNAME AND SR.FIELDNAME = RF.FIELDNAME AND SL.PTSF_SRCCAT_NAME = SR.PTSF_SRCCAT_NAME AND QD.EODP_QUERYNAME = SD.EODP_QUERYNAME AND SL.LANGUAGE_CD = QD.LANGUAGE_CD AND RF.EODP_CLFNCD = CL.EODP_CLFNCD AND SL.LANGUAGE_CD = CL.LANGUAGE_CD AND RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD AND SL.LANGUAGE_CD = CT.LANGUAGE_CD

  • Related Language Record for EODP_SR_DWN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_SRCCAT_NAME Character(65) VARCHAR2(65) NOT NULL Search Category
    2 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    3 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
    4 PTSF_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Connected Query Name
    5 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 EODP_ISCOMSRCH Character(1) VARCHAR2(1) NOT NULL Component Search

    Y/N Table Edit

    9 EODP_ISGBLSRCH Character(1) VARCHAR2(1) NOT NULL Global Search
    10 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    11 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    12 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    13 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    14 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    15 EODP_QRY_CHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
    16 EODP_QUERY_DESCR Character(30) VARCHAR2(30) NOT NULL Query Description