PT_IQ_VW

index back

SELECT A.PORTAL_NAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_OBJNAME , A.PORTAL_CNTPRV_NAM , A.PORTAL_PRODUCT , A.PORTAL_TEMPL_NAME , A.PORTAL_CREF_URLT , A.PORTAL_CREF_USGT , A.PORTAL_ISPUBLIC , A.OPRID , A.PORTAL_SEQ_NUM , A.PORTAL_LABEL , A.DESCR254 , A.PORTAL_URLTEXT FROM PSPRSMDEFN A WHERE A.PORTAL_REFTYPE = 'C'

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name
PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
PORTAL_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
PORTAL_CREF_URLT Character(4) VARCHAR2(4) NOT NULL URL Type
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
PORTAL_CREF_USGT Character(4) VARCHAR2(4) NOT NULL Usage Type
FRMT=Frame template
GRPT=Landing page
HPGC=Pagelet
HPGT=Homepage tab
HTMT=HTML template
IFRM=Inline frame template
LINK=Content Reference Link
TARG=Target
PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19