| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
|
| 2 |
PORTAL_REFTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content
F=Folder
|
| 3 |
PORTAL_OBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Object Name
|
| 4 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 5 |
PORTAL_URL_CHKSUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
URL CheckSum
|
| 6 |
PORTAL_PRNTOBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Parent Object Name
|
| 7 |
PORTAL_SEQ_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Sequence number
|
| 8 |
PORTAL_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Label
|
| 9 |
PORTAL_CNTPRV_NAM |
Character(30) |
VARCHAR2(30) NOT NULL |
Content Provider Name
|
| 10 |
PORTAL_CREF_USGT |
Character(4) |
VARCHAR2(4) NOT NULL |
Usage Type
FRMT=Frame template
GRPT=Fluid Homepage
HPGC=Pagelet
HPGT=Homepage tab
HTMT=HTML template
IFRM=Inline frame template
LINK=Content Reference Link
SECT=Section template
TARG=Target
Default Value: TARG
|
| 11 |
PORTAL_CREF_TMPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Content Ref Template Type
FRAM=Frame template
HTML=HTML template
NONE=No template
Default Value: HTML
|
| 12 |
PORTAL_CREF_STGT |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Type
LOCL=Local (in HTML Catalog)
RMTE=Remote by URL
Default Value: RMTE
|
| 13 |
PORTAL_CREF_URLT |
Character(4) |
VARCHAR2(4) NOT NULL |
URL Type
NONE=None
UEXT=Non-PeopleSoft URL
UGEN=PeopleSoft Generic URL
UMPG=PeopleSoft Mobile Page
UPGE=PeopleSoft Component
UPHP=PeopleSoft Portal Homepage Tab
UPTM=PeopleSoft Portal Template
USCR=PeopleSoft Script
WRKL=PeopleSoft Worklist URL
Default Value: UPGE
|
| 14 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 15 |
PORTAL_PRODUCT |
Character(4) |
VARCHAR2(4) NOT NULL |
Product for Foler or Content Reference
|
| 16 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 17 |
PORTAL_EFFDT |
Date(10) |
DATE |
Portal Effective Date
|
| 18 |
PORTAL_CREATION_DT |
Date(10) |
DATE |
Creation date of folder or content reference
|
| 19 |
PORTAL_EXPIRE_DT |
Date(10) |
DATE |
Expiration date of folder or content reference
|
| 20 |
PORTAL_TEMPL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Name
|
| 21 |
PORTAL_STG_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Registry Storage Name
|
| 22 |
PORTAL_ISPUBLIC |
Number(1,0) |
SMALLINT NOT NULL |
Is Public
|
| 23 |
PORTAL_LINKOBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Linked Object Name
|
| 24 |
PORTAL_LINK_PORTAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Linked Portal Name
|
| 25 |
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.
|
| 26 |
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.
|
| 27 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 28 |
PORTAL_URI_SEG1 |
Character(30) |
VARCHAR2(30) NOT NULL |
URI Segment 1
|
| 29 |
PORTAL_URI_SEG2 |
Character(30) |
VARCHAR2(30) NOT NULL |
URI Segment 2
|
| 30 |
PORTAL_URI_SEG3 |
Character(30) |
VARCHAR2(30) NOT NULL |
URI Segment 3
|
| 31 |
PORTAL_URI_SEG4 |
Character(30) |
VARCHAR2(30) NOT NULL |
URI Segment 4
|
| 32 |
FLUIDMODE |
Number(1,0) |
SMALLINT NOT NULL |
Fluid Mode
|
| 33 |
SMALLFFOPT |
Number(1,0) |
SMALLINT NOT NULL |
Display on Small Form Factor
|
| 34 |
PORTAL_URLTEXT |
Long Character |
CLOB |
Portal URL Logical Text
|