PTPG_PGRIDNAMEPTPG_VIEWNAMECOL=Column Axis
ROW=Row Axis
N=No
Y=Yes
Default Value: N
PSPGGRIDOPTPERS(SQL Table) |
Index Back |
|---|---|
PVG Grid Options Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPG_PGRIDNAME |
Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Name (see PSPGCORE). |
| 2 | PTPG_VIEWNAME |
Character(40) | VARCHAR2(40) NOT NULL | View Name |
| 3 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | PTPG_AXISINFO | Character(4) | VARCHAR2(4) NOT NULL |
Axis Information
COL=Column Axis ROW=Row Axis |
| 5 | PTPG_NONDIMAXIS | Character(4) | VARCHAR2(4) NOT NULL | Value Axis |
| 6 | PTPG_CHARTONLY | Number(3,0) | SMALLINT NOT NULL | Chart Only |
| 7 | PTPG_GRIDNCHART | Number(3,0) | SMALLINT NOT NULL | Grid and Chart |
| 8 | PTPG_GRIDONLY | Number(3,0) | SMALLINT NOT NULL | Grid Only |
| 9 | PTPG_INACTIVE | Number(3,0) | SMALLINT NOT NULL | Grid Inactive |
| 10 | PTPG_EXPAND | Number(3,0) | SMALLINT NOT NULL | Expanded State |
| 11 | PTPG_DISPLAY | Number(3,0) | SMALLINT NOT NULL | Display Only |
| 12 | PTPG_WRAPLABEL | Number(3,0) | SMALLINT NOT NULL | Wrap Column Label |
| 13 | PTPG_COLLAPSIBLE | Number(3,0) | SMALLINT NOT NULL | Collapsible Data Area |
| 14 | PTPG_DRAGDROP | Number(3,0) | SMALLINT NOT NULL | No Drag and Drop |
| 15 | PTPG_EXPANDALLCOLS | Character(1) | VARCHAR2(1) NOT NULL |
Expand
N=No Y=Yes Default Value: N |