PSPGVIEWOPT

 index back

Pivot Grid View Options


  • Related language record: PSPGVIEWOPTLANG

    • PeopleSoft Field Name Field Type Column Type Description
    PTPG_PGRIDNAME Character(30) VARCHAR2(30) NOT NULL Pivot Grid Name (see PSPGCORE).

    Prompt Table: PSPGCORE

    PTPG_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name

    Prompt Table: PSPGVIEWOPT

    USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    PTPG_FLR_SEQNO Number(4,0) SMALLINT NOT NULL Filter Sequence Number
    PTPVG_VIEWDESCR Character(254) VARCHAR2(254) NOT NULL View Description
    PTPG_DISPLAYOPT Character(4) VARCHAR2(4) NOT NULL Display Options
    CHT=Chart Only
    GNC=Pivot Grid and Chart
    GRD=Pivot Grid Only
    PTPG_ROWS_GRID Character(254) VARCHAR2(254) NOT NULL Row Fields
    PTPG_CLMNS_GRID Character(254) VARCHAR2(254) NOT NULL Column Fields
    PTPG_FLRS_GRID Character(254) VARCHAR2(254) NOT NULL Filter Fields
    PTPG_FLRS_GRID_EX Long Character(1333) VARCHAR2(1333) Grid Filters
    PTPG_XFIELD_CHART Character(254) VARCHAR2(254) NOT NULL X Axis Fields
    PTPG_YFIELD_CHART Character(254) VARCHAR2(254) NOT NULL Y Axis Fields
    PTPG_FLRS_CHART Character(254) VARCHAR2(254) NOT NULL Filter Fields
    PTPG_SERIES_CHART Character(254) VARCHAR2(254) NOT NULL Series Field
    PTPG_OLAY_CHART Character(254) VARCHAR2(254) NOT NULL Overlay Field
    PTPG_PRIMARYFILTER Character(254) VARCHAR2(254) NOT NULL Primary Filter
    PTPG_DISPLAY_MODE Character(1) VARCHAR2(1) NOT NULL Display Mode
    C=Classic Mode
    D=Default
    F=Fluid Mode

    Default: D

    PTPG_CHART_DUALY Character(254) VARCHAR2(254) NOT NULL Dual Y Axis
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20