| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTPPB_PAGELET_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Pagelet ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 4 |
PTPPB_DATA_SOURCE |
Character(254) |
VARCHAR2(254) NOT NULL |
Data Source
Prompt Table:
%EDITTABLE
|
| 5 |
PTPPB_DATATYPE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Data Type
Prompt Table:
PTPPB_DATATYPE
|
| 6 |
PTPPB_DISPFRMT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Display Format ID
Prompt Table:
PTPPB_DISP_FRMT
|
| 7 |
PTPPB_HEADER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Header ID
Prompt Table:
PTPPB_HEADER
|
| 8 |
PTPPB_FOOTER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Footer ID
Prompt Table:
PTPPB_FOOTER
|
| 9 |
PTPPB_PGLT_CATG_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Category ID
Prompt Table:
PTPPB_PGLT_CATG
|
| 10 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
Default Value: PTPP_OPTIONS.OBJECTOWNERID
|
| 11 |
PTPPB_OPENTXTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Opening Text Type
MSG=Message Catalog Entry
TXT=Freeform Text/HTML
Default Value: TXT
|
| 12 |
PTPPB_OPENTXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Opening Text
|
| 13 |
PTPPB_OPENMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Opening Message Set
|
| 14 |
PTPPB_OPENMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Opening Message Number
|
| 15 |
PTPPB_CLOSETXTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Closing Text Type
MSG=Message Catalog Entry
TXT=Freeform Text/HTML
Default Value: TXT
|
| 16 |
PTPPB_CLOSETXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Closing Text
|
| 17 |
PTPPB_CLOSEMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Closing Message Set
|
| 18 |
PTPPB_CLOSEMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Closing Message Number
|
| 19 |
PTPPB_VIEW_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show "View Source Data" Link
Y/N Table Edit
Default Value: N
|
| 20 |
PTPPB_CUSTOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customized
Y/N Table Edit
Default Value: N
|
| 21 |
PTPPB_ORIG_DISP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Original Display Format
|
| 22 |
STYLESHEETNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Style Sheet Name (see PSSTYLSHEETDEFN).
|
| 23 |
PTPPB_EMBEDDABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
API Accessible
Y/N Table Edit
Default Value: N
|
| 24 |
PTPPB_PERSTXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 25 |
PTPPB_REQ_PERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Personalization
Y/N Table Edit
Default Value: N
|
| 26 |
PTPPB_KEY_BEHAV |
Character(3) |
VARCHAR2(3) NOT NULL |
Template Pagelet Behavior
DEF=Use Specified Defaults
HID=Hide Pagelet
MSG=Display Message
Default Value: DEF
|
| 27 |
PTPPB_SEC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Security Type
PUBL=Public Access
SECR=Select Security Access
SYNC=Allow Data Source Sync
Default Value: PUBL
|
| 28 |
PTPPB_AUTH_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Author Access
Y/N Table Edit
Default Value: N
|
| 29 |
CREATEDTTM |
DateTime(26) |
TIMESTAMP |
DateTime of Query Creation
|
| 30 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 31 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 32 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 33 |
PTPPB_SRCH_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Search Options
BL=Bottom Left
BR=Bottom Right
NON=No Search Box
TL=Top Left
TR=Top Right
XSL=Inline XSL
Default Value: NON
|
| 34 |
PTPPB_SRCH_NEWWIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Display results in new window
Y/N Table Edit
Default Value: N
|
| 35 |
PTPPB_SRCH_AP_PKG |
Character(30) |
VARCHAR2(30) NOT NULL |
Package Name
|
| 36 |
PTPPB_SRCH_AP_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
|
| 37 |
PTPPB_SRCH_APCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
|
| 38 |
PTPPB_HELP_URL |
Long Character |
CLOB |
Pagelet Help URL
|