PT_IQ_VWLNG

index back

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

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
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
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