PSPGGRIDOPTPERS

index back

PVG Grid Options Record


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
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PTPG_AXISINFO Character(4) VARCHAR2(4) NOT NULL Axis Information
COL=Column Axis
ROW=Row Axis
PTPG_NONDIMAXIS Character(4) VARCHAR2(4) NOT NULL Value Axis
PTPG_CHARTONLY Number(3,0) SMALLINT NOT NULL Chart Only
PTPG_GRIDNCHART Number(3,0) SMALLINT NOT NULL Grid and Chart
PTPG_GRIDONLY Number(3,0) SMALLINT NOT NULL Grid Only
PTPG_INACTIVE Number(3,0) SMALLINT NOT NULL Grid Inactive
PTPG_EXPAND Number(3,0) SMALLINT NOT NULL Expanded State
PTPG_DISPLAY Number(3,0) SMALLINT NOT NULL Display Only
PTPG_WRAPLABEL Number(3,0) SMALLINT NOT NULL Wrap Column Label
PTPG_COLLAPSIBLE Number(3,0) SMALLINT NOT NULL Collapsible Data Area
PTPG_DRAGDROP Number(3,0) SMALLINT NOT NULL No Drag and Drop
PTPG_EXPANDALLCOLS Character(1) VARCHAR2(1) NOT NULL Expand
N=No
Y=Yes

Default: N

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