PTPG_PGVW_VW

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 Field Type Column Type Description
    PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).
    PTPG_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name
    PTPVG_VIEWDESCR Character(254) VARCHAR2(254) NOT NULL View Description
    PTPG_DSNAME Character(30) VARCHAR2(30) NOT NULL Data Source Name
    USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    PTPG_PGRIDTYPE Character(4) VARCHAR2(4) NOT NULL Pivot Grid Type
    PUB=Public
    PVT=Private
    PTPG_DSTYPE Character(30) VARCHAR2(30) NOT NULL Data Source Type (see PSPGDTYPE).
    PTPG_ISVALIDMODEL Character(1) VARCHAR2(1) NOT NULL Valid Model
    N=No
    Y=Yes
    PTPG_PGRIDTITLE Character(30) VARCHAR2(30) NOT NULL Pivot Grid Title
    PTPG_DISPLAY_MODE Character(1) VARCHAR2(1) NOT NULL Display Mode
    C=Classic Mode
    D=Default
    F=Fluid Mode
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19