PTPG_PGRIDNAMEPTPG_VIEWNAMEPTPG_DSUNIQUEFLDB=Bar Chart
H=Horizontal Bar Chart
L=Line Chart
P=Pie Chart
F=Full Page Modal
M=Modal Window
N=New Window
R=Replace Window
C=Collapsed
E=Expanded
I=Invisible
PSPGNUIDIMOPT(SQL Table) |
Index Back |
|---|---|
Pivot Grid Dimension Options |
| # | 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 | PTPG_DSUNIQUEFLD |
Character(254) | VARCHAR2(254) NOT NULL | Unique Heading |
| 4 | PTS_NUI_FCTCHT | Character(1) | VARCHAR2(1) NOT NULL | Show as Chart |
| 5 | PTS_NUI_FCTCHTTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Chart Type
B=Bar Chart H=Horizontal Bar Chart L=Line Chart P=Pie Chart |
| 6 | PTPG_DRILLURLDISP | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
F=Full Page Modal M=Modal Window N=New Window R=Replace Window |
| 7 | PTPG_SEQ_EDIT | Number(10,0) | DECIMAL(10) NOT NULL | Sequence No. |
| 8 | PTPG_STATE_DROP | Character(1) | VARCHAR2(1) NOT NULL |
State
C=Collapsed E=Expanded I=Invisible |