PSPRSMDEFN_VW

Platform

View Text

Default

SELECT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME , VERSION , PORTAL_URL_CHKSUM , PORTAL_PRNTOBJNAME , PORTAL_SEQ_NUM , PORTAL_LABEL , PORTAL_CNTPRV_NAM , PORTAL_CREF_USGT , PORTAL_CREF_TMPT , PORTAL_CREF_STGT , PORTAL_CREF_URLT , DESCR254 , PORTAL_PRODUCT , OPRID , PORTAL_EFFDT , PORTAL_CREATION_DT , PORTAL_EXPIRE_DT , PORTAL_TEMPL_NAME , PORTAL_STG_NAME , PORTAL_ISPUBLIC , PORTAL_LINKOBJNAME , PORTAL_LINK_PORTAL , LASTUPDOPRID , LASTUPDDTTM , OBJECTOWNERID , PORTAL_URI_SEG1 , PORTAL_URI_SEG2 , PORTAL_URI_SEG3 , PORTAL_URI_SEG4 , PORTAL_URLTEXT FROM PSPRSMDEFN WHERE PORTAL_NAME = 'MOBILE' AND PORTAL_REFTYPE = 'F'

PeopleSoft Field Name	Description
PORTAL_NAME	Portal Name Default: MOBILE
PORTAL_REFTYPE	Portal Reference Type C=Content F=Folder (default)
PORTAL_OBJNAME	Portal Object Name
VERSION	Internal PeopleTools version to control reloading of objects in cache.
PORTAL_URL_CHKSUM	URL CheckSum Default: 0
PORTAL_PRNTOBJNAME	Portal Parent Object Name Default: MOBILE
PORTAL_SEQ_NUM	Sequence number
PORTAL_LABEL	Portal Label
PORTAL_CNTPRV_NAM	Content Provider Name
PORTAL_CREF_USGT	Usage Type FRMT=Frame template HPGC=Pagelet HPGT=Homepage tab HTMT=HTML template LINK=Content Reference Link TARG=Target (default)
PORTAL_CREF_TMPT	Content Ref Template Type FRAM=Frame template HTML=HTML template (default) NONE=No template
PORTAL_CREF_STGT	Storage Type LOCL=Local (in HTML Catalog) RMTE=Remote by URL (default)
PORTAL_CREF_URLT	URL Type UEXT=Non-PeopleSoft URL UGEN=PeopleSoft Generic URL UMPG=PeopleSoft Mobile Page UPGE=PeopleSoft Component (default) UPHP=PeopleSoft Portal Homepage Tab UPTM=PeopleSoft Portal Template USCR=PeopleSoft Script WRKL=PeopleSoft Worklist URL
DESCR254	Description of length 254
PORTAL_PRODUCT	Product for Foler or Content Reference
OPRID	A user's ID
PORTAL_EFFDT	Portal Effective Date
PORTAL_CREATION_DT	Creation date of folder or content reference Default: %date
PORTAL_EXPIRE_DT	Expiration date of folder or content reference
PORTAL_TEMPL_NAME	Template Name
PORTAL_STG_NAME	Portal Registry Storage Name
PORTAL_ISPUBLIC	Is Public
PORTAL_LINKOBJNAME	Portal Linked Object Name
PORTAL_LINK_PORTAL	Linked Portal Name
LASTUPDOPRID	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.
LASTUPDDTTM	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.
OBJECTOWNERID	Object owner identifier translate values
PORTAL_URI_SEG1	URI Segment 1
PORTAL_URI_SEG2	URI Segment 2
PORTAL_URI_SEG3	URI Segment 3
PORTAL_URI_SEG4	URI Segment 4
PORTAL_URLTEXT	Portal URL Logical Text

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010