PSPGDISPOPT

index back

Pivot Grid Display Options


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

Y/N Table Edit

Default: Y

PTPG_HORIZONTALBAR Character(1) VARCHAR2(1) NOT NULL Horizontal Bar Chart

Y/N Table Edit

Default: Y

PTPVG_LINECHART Character(1) VARCHAR2(1) NOT NULL Line Chart

Y/N Table Edit

Default: Y

PTPVG_BARCHART Character(1) VARCHAR2(1) NOT NULL Bar Chart

Y/N Table Edit

Default: Y

PTPVG_PIECHART Character(1) VARCHAR2(1) NOT NULL Pie Chart

Y/N Table Edit

Default: Y

PTPVG_EXPORT_EXCEL Character(1) VARCHAR2(1) NOT NULL Export Data

Y/N Table Edit

Default: Y

PTPG_DISPCHART Character(1) VARCHAR2(1) NOT NULL Display Chart
C=Chart
G=Grid

Y/N Table Edit

Default: Y

PTPG_CHART_OPT Character(4) VARCHAR2(4) NOT NULL Chart Options

Y/N Table Edit

Default: Y

PTPG_RESETPERS Character(1) VARCHAR2(1) NOT NULL Reset Personalization

Y/N Table Edit

Default: Y

PTPVG_SAVE_LAYOUT Character(1) VARCHAR2(1) NOT NULL Save Layout

Y/N Table Edit

Default: Y

PTPG_NUI_FACETUPD Character(1) VARCHAR2(1) NOT NULL Update Filters

Y/N Table Edit

Default: Y

PTPG_SHOWHELP Character(1) VARCHAR2(1) NOT NULL Show Help

Y/N Table Edit

Default: Y

MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Default: 268

Prompt Table: PSMSGSETDEFN

MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Default: 315

Prompt Table: PSMSGCATDEFN

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