| # |
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_VIEWGRID |
Character(1) |
VARCHAR2(1) NOT NULL |
View Grid
Y/N Table Edit
Default Value: Y
|
| 3 |
PTPG_HORIZONTALBAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Horizontal Bar Chart
Y/N Table Edit
Default Value: Y
|
| 4 |
PTPVG_LINECHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Chart
Y/N Table Edit
Default Value: Y
|
| 5 |
PTPVG_BARCHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Bar Chart
Y/N Table Edit
Default Value: Y
|
| 6 |
PTPVG_PIECHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Pie Chart
Y/N Table Edit
Default Value: Y
|
| 7 |
PTPVG_EXPORT_EXCEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Data
Y/N Table Edit
Default Value: Y
|
| 8 |
PTPG_DISPCHART |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Chart
C=Chart
G=Grid
Y/N Table Edit
Default Value: Y
|
| 9 |
PTPG_CHART_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Chart Options
Y/N Table Edit
Default Value: Y
|
| 10 |
PTPG_RESETPERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset to Default Order
Y/N Table Edit
Default Value: Y
|
| 11 |
PTPVG_SAVE_LAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Layout
Y/N Table Edit
Default Value: Y
|
| 12 |
PTPG_NUI_FACETUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Filters
Y/N Table Edit
Default Value: Y
|
| 13 |
PTPG_SHOWHELP |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Help
Y/N Table Edit
Default Value: Y
|
| 14 |
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 Value: 268
Prompt Table:
PSMSGSETDEFN
|
| 15 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 315
Prompt Table:
PSMSGCATDEFN
|
| 16 |
PTPG_SAVEAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Model
Default Value: Y
|
| 17 |
PTPG_SORTENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Enabled
Default Value: Y
|
| 18 |
PTPG_THRPERENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold Options
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 19 |
PTPG_ALLOWUSRADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow User Addition
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 20 |
PTPVG_EXP_FIL_EXCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Filtered Data
Y/N Table Edit
Default Value: Y
|
| 21 |
PTPVG_ADD_HOMEPAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to HomePage
Y/N Table Edit
Default Value: Y
|