| 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
|
| PTPG_SHOWLSTVW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show List View
|
| PTPG_LSTMSG_USE_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Use
E=Use Description Text
T=Use Message Text
Default: E
|
| PTPG_LST_MSGSET_S |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default: 0
|
| PTPG_LST_MSGNBR_S |
Number(5,0) |
INTEGER NOT NULL |
Message Number
Default: 0
|
| PTPG_SUM_BINDVLIST |
Character(254) |
VARCHAR2(254) NOT NULL |
List Vw Summary Bind Val List
|
| PTPG_LSTMSG_USE_T |
Character(1) |
VARCHAR2(1) NOT NULL |
Title Use
E=Use DescriptionText
T=Use Message Text
Default: T
|
| PTPG_LST_MSGSET_T |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default: 0
|
| PTPG_LST_MSGNBR_T |
Number(5,0) |
INTEGER NOT NULL |
Message Number
Default: 0
|
| PTPG_TITL_BINDLIST |
Character(254) |
VARCHAR2(254) NOT NULL |
List View Title Bind LIst
|
| PTPG_TIT_BINDVLIST |
Character(254) |
VARCHAR2(254) NOT NULL |
List Vw Title Bind Value List
|
| PTPG_LSTIMGNAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Image Dimension Name
Prompt Table:
PSPGNUIOPT
|
| PTPG_COMPMAPPING |
Character(254) |
VARCHAR2(254) NOT NULL |
Component Name
|
| PTPG_COMPMARKETMAP |
Character(254) |
VARCHAR2(254) NOT NULL |
Component Market
|
| PTPG_RESULTVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Result View
B=Grid and List
G=Grid
L=List
N=None
Default: G
|
| PTPG_RESULTVWDEF |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Result View
G=Grid
L=List
Default: G
|
| TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| ACCESS_GROUP |
Character(20) |
VARCHAR2(20) NOT NULL |
Access Group
|
| PTPG_ONLYDETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Simple Table
Y/N Table Edit
Default: N
|
| PTPG_GRIDINTERACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pivot Grid drives Chart
Y/N Table Edit
Default: Y
|
| PTPG_FACETSINGLSEL |
Character(254) |
VARCHAR2(254) NOT NULL |
Single Select Facets
|
| PTPG_XCLDCOLS |
Long Character |
CLOB |
Excluded Results Columns
|
| PTPG_ALLOWMULYAXIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multiple Y Axes
N=No
Y=Yes
Default: N
|
| PTPG_ALLOWPUBTILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow publish
Y/N Table Edit
Default: Y
|
| PTPG_ALLOWSHARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow sharing
Y/N Table Edit
Default: Y
|
| PTPG_FACETS_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Facets State
C=Collapsed
E=Expanded
Default: E
|
| PTPG_FACETS_STEP |
Character(3) |
VARCHAR2(3) NOT NULL |
Facet Count
0=All
10=Ten
20=Twenty
30=Thrity
40=Forty
50=Fifty
Default: 10
|
| PTPG_SHOWDETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Detailed View
N=Show
Y=Hide
Y/N Table Edit
Default: N
|