| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 PTPG_PGRIDNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Pivot Grid Name (see PSPGCORE).
|
| PTPG_VIEWGRID |
Character(1) |
VARCHAR2(1) NOT NULL |
View Grid
Y/N Table Edit
Default: Y
|
| PTPG_HORIZONTALBAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Horizontal Bar Chart
Y/N Table Edit
Default: Y
|
| PTPVG_LINECHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Chart
Y/N Table Edit
Default: Y
|
| PTPVG_BARCHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Bar Chart
Y/N Table Edit
Default: Y
|
| PTPVG_PIECHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Pie Chart
Y/N Table Edit
Default: Y
|
| PTPVG_EXPORT_EXCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Data
Y/N Table Edit
Default: Y
|
| PTPG_DISPCHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Chart
C=Chart
G=Grid
Y/N Table Edit
Default: Y
|
| PTPG_CHART_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Chart Options
Y/N Table Edit
Default: Y
|
| PTPG_RESETPERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset to Default Order
Y/N Table Edit
Default: Y
|
| PTPVG_SAVE_LAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Layout
Y/N Table Edit
Default: Y
|
| PTPG_NUI_FACETUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Filters
Y/N Table Edit
Default: Y
|
| PTPG_SHOWHELP |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Help
Y/N Table Edit
Default: Y
|
| MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default: 268
Prompt Table:
PSMSGSETDEFN
|
| MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default: 315
Prompt Table:
PSMSGCATDEFN
|
| PTPG_SAVEAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Model
Default: Y
|
| PTPG_SORTENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Enabled
Default: Y
|
| PTPG_THRPERENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold Options
N=No
Y=Yes
Y/N Table Edit
Default: Y
|
| PTPG_ALLOWUSRADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow User Addition
N=No
Y=Yes
Y/N Table Edit
Default: Y
|
| PTPVG_EXP_FIL_EXCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Filtered Data
Y/N Table Edit
Default: Y
|
| PTPVG_ADD_HOMEPAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to HomePage
Y/N Table Edit
Default: Y
|