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