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 NameField TypeColumn TypeDescription
    PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).
    PTPG_VIEWNAMECharacter(40)VARCHAR2(40) NOT NULLView Name
    PTPVG_VIEWDESCRCharacter(254)VARCHAR2(254) NOT NULLView Description
    PTPG_DSNAMECharacter(30)VARCHAR2(30) NOT NULLData Source Name
    USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    PTPG_PGRIDTYPECharacter(4)VARCHAR2(4) NOT NULLPivot Grid Type
    PUB=Public
    PVT=Private
    PTPG_DSTYPECharacter(30)VARCHAR2(30) NOT NULLData Source Type (see PSPGDTYPE).
    PTPG_ISVALIDMODELCharacter(1)VARCHAR2(1) NOT NULLValid Model
    N=No
    Y=Yes
    PTPG_PGRIDTITLECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Title
    PTPG_DISPLAY_MODECharacter(1)VARCHAR2(1) NOT NULLDisplay Mode
    C=Classic Mode
    D=Default
    F=Fluid Mode
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19