PSPGNUIOPT

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_VIEWNAME Character(40) VARCHAR2(40) NOT NULL View Name
PTPG_SHOWLSTVW Character(1) VARCHAR2(1) NOT NULL Show List View
PTPG_LSTMSG_USE_S Character(1) VARCHAR2(1) NOT NULL Summary Use
E=Use Description Text
T=Use Message Text

Default: E

PTPG_LST_MSGSET_S Number(5,0) INTEGER NOT NULL Message Set Number

Default: 0

PTPG_LST_MSGNBR_S Number(5,0) INTEGER NOT NULL Message Number

Default: 0

PTPG_SUM_BINDVLIST Character(254) VARCHAR2(254) NOT NULL List Vw Summary Bind Val List
PTPG_LSTMSG_USE_T Character(1) VARCHAR2(1) NOT NULL Title Use
E=Use DescriptionText
T=Use Message Text

Default: T

PTPG_LST_MSGSET_T Number(5,0) INTEGER NOT NULL Message Set Number

Default: 0

PTPG_LST_MSGNBR_T Number(5,0) INTEGER NOT NULL Message Number

Default: 0

PTPG_TITL_BINDLIST Character(254) VARCHAR2(254) NOT NULL List View Title Bind LIst
PTPG_TIT_BINDVLIST Character(254) VARCHAR2(254) NOT NULL List Vw Title Bind Value List
PTPG_LSTIMGNAME Character(254) VARCHAR2(254) NOT NULL Image Dimension Name

Prompt Table: PSPGNUIOPT

PTPG_COMPMAPPING Character(254) VARCHAR2(254) NOT NULL Component Name
PTPG_COMPMARKETMAP Character(254) VARCHAR2(254) NOT NULL Component Market
PTPG_RESULTVIEW Character(1) VARCHAR2(1) NOT NULL Result View
B=Grid and List
G=Grid
L=List
N=None

Default: G

PTPG_RESULTVWDEF Character(1) VARCHAR2(1) NOT NULL Default Result View
G=Grid
L=List

Default: G

TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
ACCESS_GROUP Character(20) VARCHAR2(20) NOT NULL Access Group
PTPG_ONLYDETAIL Character(1) VARCHAR2(1) NOT NULL Detail View Only

Y/N Table Edit

Default: N

PTPG_GRIDINTERACT Character(1) VARCHAR2(1) NOT NULL Pivot Grid drives Chart

Y/N Table Edit

Default: Y

PTPG_FACETSINGLSEL Character(254) VARCHAR2(254) NOT NULL Single Select Facets
PTPG_XCLDCOLS Long Character CLOB Excluded Results Columns
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19