PSPGVIEWOPT

index back

Pivot Grid View Options


  • Related language record: PSPGVIEWOPTLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).

    Prompt Table: PSPGCORE

    PTPG_VIEWNAMECharacter(40)VARCHAR2(40) NOT NULLView Name

    Prompt Table: PSPGVIEWOPT

    USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    PTPG_FLR_SEQNONumber(4,0)SMALLINT NOT NULLFilter Sequence Number
    PTPVG_VIEWDESCRCharacter(254)VARCHAR2(254) NOT NULLView Description
    PTPG_DISPLAYOPTCharacter(4)VARCHAR2(4) NOT NULLDisplay Options
    CHT=Chart Only
    GNC=Pivot Grid and Chart
    GRD=Pivot Grid Only
    PTPG_ROWS_GRIDCharacter(254)VARCHAR2(254) NOT NULLRow Fields
    PTPG_CLMNS_GRIDCharacter(254)VARCHAR2(254) NOT NULLColumn Fields
    PTPG_FLRS_GRIDCharacter(254)VARCHAR2(254) NOT NULLFilter Fields
    PTPG_FLRS_GRID_EXLong Character(1333)VARCHAR2(1333)Grid Filters
    PTPG_XFIELD_CHARTCharacter(254)VARCHAR2(254) NOT NULLX Axis Fields
    PTPG_YFIELD_CHARTCharacter(254)VARCHAR2(254) NOT NULLY Axis Fields
    PTPG_FLRS_CHARTCharacter(254)VARCHAR2(254) NOT NULLFilter Fields
    PTPG_SERIES_CHARTCharacter(254)VARCHAR2(254) NOT NULLSeries Field
    PTPG_OLAY_CHARTCharacter(254)VARCHAR2(254) NOT NULLOverlay Field
    PTPG_PRIMARYFILTERCharacter(254)VARCHAR2(254) NOT NULLPrimary Filter
    PTPG_DISPLAY_MODECharacter(1)VARCHAR2(1) NOT NULLDisplay Mode
    C=Classic Mode
    D=Default
    F=Fluid Mode

    Default: D

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19