PSPGNUIOPT

index back

Pivot Grid Display Options


PeopleSoft Field NameField TypeColumn TypeDescription
PTPG_PGRIDNAMECharacter(30)VARCHAR2(30) NOT NULLPivot Grid Name (see PSPGCORE).
PTPG_VIEWNAMECharacter(40)VARCHAR2(40) NOT NULLView Name
PTPG_SHOWLSTVWCharacter(1)VARCHAR2(1) NOT NULLShow List View
PTPG_LSTMSG_USE_SCharacter(1)VARCHAR2(1) NOT NULLSummary Use
E=Use Description Text
T=Use Message Text

Default: E

PTPG_LST_MSGSET_SNumber(5,0)INTEGER NOT NULLMessage Set Number

Default: 0

PTPG_LST_MSGNBR_SNumber(5,0)INTEGER NOT NULLMessage Number

Default: 0

PTPG_SUM_BINDVLISTCharacter(254)VARCHAR2(254) NOT NULLList Vw Summary Bind Val List
PTPG_LSTMSG_USE_TCharacter(1)VARCHAR2(1) NOT NULLTitle Use
E=Use DescriptionText
T=Use Message Text

Default: T

PTPG_LST_MSGSET_TNumber(5,0)INTEGER NOT NULLMessage Set Number

Default: 0

PTPG_LST_MSGNBR_TNumber(5,0)INTEGER NOT NULLMessage Number

Default: 0

PTPG_TITL_BINDLISTCharacter(254)VARCHAR2(254) NOT NULLList View Title Bind LIst
PTPG_TIT_BINDVLISTCharacter(254)VARCHAR2(254) NOT NULLList Vw Title Bind Value List
PTPG_LSTIMGNAMECharacter(254)VARCHAR2(254) NOT NULLImage Dimension Name

Prompt Table: PSPGNUIOPT

PTPG_COMPMAPPINGCharacter(254)VARCHAR2(254) NOT NULLComponent Name
PTPG_COMPMARKETMAPCharacter(254)VARCHAR2(254) NOT NULLComponent Market
PTPG_RESULTVIEWCharacter(1)VARCHAR2(1) NOT NULLResult View
B=Grid and List
G=Grid
L=List
N=None

Default: G

PTPG_RESULTVWDEFCharacter(1)VARCHAR2(1) NOT NULLDefault Result View
G=Grid
L=List

Default: G

TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name
ACCESS_GROUPCharacter(20)VARCHAR2(20) NOT NULLAccess Group
PTPG_ONLYDETAILCharacter(1)VARCHAR2(1) NOT NULLDetail View Only

Y/N Table Edit

Default: N

PTPG_GRIDINTERACTCharacter(1)VARCHAR2(1) NOT NULLPivot Grid drives Chart

Y/N Table Edit

Default: Y

PTPG_FACETSINGLSELCharacter(254)VARCHAR2(254) NOT NULLSingle Select Facets
PTPG_XCLDCOLSLong CharacterCLOBExcluded Results Columns
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19