EODP_PVT_DWN_VW

(SQL View)
 Index Back

Pivot reference View

Download record for Pivot reference

SELECT PR.PTPG_PGRIDNAME ,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 LEFT OUTER JOIN PS_EODP_CLSFCN CL ON RF.EODP_CLFNCD = CL.EODP_CLFNCD LEFT OUTER JOIN PS_EODP_CTGRY_CODE CT ON RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD , PSPGCORE PC LEFT OUTER JOIN PS_EODP_PVT_PRD_VW PD ON PD.PTPG_PGRIDNAME = PC.PTPG_PGRIDNAME WHERE PR.RECNAME = RF.RECNAME AND PR.FIELDNAME = RF.FIELDNAME AND PR.PTPG_PGRIDNAME = PC.PTPG_PGRIDNAME

  • Related Language Record: EODP_PVT_DW_LVW

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