EODP_PVT_DW_LVW

(SQL View)
 Index Back

Pivot reference View

Download record for Pivot reference

SELECT PR.PTPG_PGRIDNAME ,PC.LANGUAGE_CD ,PC.PTPG_PGRIDTITLE ,PR.PTPG_DSTYPE ,PR.PTPG_DSVALUE , PR.RECNAME , PR.FIELDNAME ,PR.EODP_IS_PGLT , PR.EODP_PGLT_SEC ,PR.EODP_IS_TILE , PR.EODP_IS_TIL_SEC ,TL.PORTAL_NAME ,TL.PORTAL_OBJNAME ,TL.PORTAL_LABEL ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,PD.EODP_PROD_DESCR ,PL.EODP_QUERYNAME FROM ((PS_EODP_PIVOT_REF PR LEFT OUTER JOIN PS_EODP_PIVOT_DTL PL ON PR.PTPG_PGRIDNAME = PL.PTPG_PGRIDNAME AND PR.PTPG_DSVALUE = PL.PTPG_DSVALUE AND PR.RECNAME = PL.RECNAME AND PR.FIELDNAME = PL.FIELDNAME )LEFT OUTER JOIN PS_EODP_PG_TILE_VW TL ON PR.PTPG_PGRIDNAME= %Substring(%SQL(EODP_CONVERT_TO_STRING,TL.PORTAL_URLTEXT,4000), 37, %Sql(EODP_GETCHARLENGTH,PR.PTPG_PGRIDNAME))) , PS_EODP_RECFLDDB RF , PSPGCORELANG PC LEFT OUTER JOIN PS_EODP_PVTPRD_LVW PD ON PD.PTPG_PGRIDNAME = PC.PTPG_PGRIDNAME AND PC.LANGUAGE_CD = PD.LANGUAGE_CD ,PS_EODP_CLSFCN_LNG CL ,PS_EODP_CTR_CD_LNG CT WHERE RF.EODP_CLFNCD = CL.EODP_CLFNCD AND PC.LANGUAGE_CD = CL.LANGUAGE_CD AND RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD AND PC.LANGUAGE_CD = CT.LANGUAGE_CD

  • Related Language Record for EODP_PVT_DWN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PTPG_PGRIDTITLE Character(30) VARCHAR2(30) NOT NULL Pivot Grid Title
    4 PTPG_DSTYPE Character(30) VARCHAR2(30) NOT NULL Data Source Type (see PSPGDTYPE).
    5 PTPG_DSVALUE Character(30) VARCHAR2(30) NOT NULL Data Source Value
    6 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    8 EODP_IS_PGLT Character(1) VARCHAR2(1) NOT NULL Published As Pagelet
    N=No
    Y=Yes
    9 EODP_PGLT_SEC Character(1) VARCHAR2(1) NOT NULL Secured
    N=No
    Y=Yes
    10 EODP_IS_TILE Character(1) VARCHAR2(1) NOT NULL Published As Tile
    N=No
    Y=Yes
    11 EODP_IS_TIL_SEC Character(1) VARCHAR2(1) NOT NULL Secured
    N=No
    Y=Yes
    12 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    13 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    14 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    15 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    16 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    17 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    18 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    19 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    20 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field