PTPG_PGVW_VW

(SQL View)
 Index Back

PVG Viewer View


SELECT DISTINCT A.PTPG_PGRIDNAME ,C.PTPG_VIEWNAME ,C.PTPVG_VIEWDESCR ,B.PTPG_DSVALUE , A.USERID , A.PTPG_PGRIDTYPE ,A.PTPG_DSTYPE , A.PTPG_ISVALIDMODEL ,A.PTPG_PGRIDTITLE ,C.PTPG_DISPLAY_MODE FROM PSPGCORE A , PSPGSETTINGS B , PSPGVIEWOPT C WHERE A.PTPG_PGRIDNAME=B.PTPG_PGRIDNAME AND A.PTPG_PGRIDNAME=C.PTPG_PGRIDNAME

  • Related Language Record: PTPG_PGVW_VWLNG

    • # 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_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name
    3 PTPVG_VIEWDESCR Character(254) VARCHAR2(254) NOT NULL View Description
    4 PTPG_DSNAME Character(30) VARCHAR2(30) NOT NULL Data Source Name
    5 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    6 PTPG_PGRIDTYPE Character(4) VARCHAR2(4) NOT NULL Pivot Grid Type
    PUB=Public
    PVT=Private
    7 PTPG_DSTYPE Character(30) VARCHAR2(30) NOT NULL Data Source Type (see PSPGDTYPE).
    8 PTPG_ISVALIDMODEL Character(1) VARCHAR2(1) NOT NULL Valid Model
    N=No
    Y=Yes
    9 PTPG_PGRIDTITLE Character(30) VARCHAR2(30) NOT NULL Pivot Grid Title
    10 PTPG_DISPLAY_MODE Character(1) VARCHAR2(1) NOT NULL Display Mode
    C=Classic Mode
    D=Default
    F=Fluid Mode