PT_IQLEVEL2

index back

Registry Folder Struct Level 2


SELECT F1.PORTAL_NAME ,C2.PORTAL_OBJNAME ,C2.PORTAL_PRODUCT ,C2.PORTAL_CNTPRV_NAM ,C2.PORTAL_TEMPL_NAME ,C2.PORTAL_CREF_URLT ,C2.PORTAL_CREF_USGT ,C2.PORTAL_ISPUBLIC ,C2.OPRID ,F1.PORTAL_SEQ_NUM ,F1.PORTAL_OBJNAME ,F1.PORTAL_LABEL ,F1.DESCR254 ,F2.PORTAL_SEQ_NUM ,F2.PORTAL_OBJNAME ,F2.PORTAL_LABEL ,F2.DESCR254 ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' , C2.PORTAL_SEQ_NUM , C2.PORTAL_LABEL , C2.DESCR254 , C2.PORTAL_URLTEXT FROM PSPRSMDEFN F1 , PSPRSMDEFN F2 , PS_PT_IQ_VW C2 WHERE F2.PORTAL_OBJNAME = C2.PORTAL_PRNTOBJNAME AND F2.PORTAL_PRNTOBJNAME = F1.PORTAL_OBJNAME AND F2.PORTAL_NAME = C2.PORTAL_NAME AND F1.PORTAL_NAME = F2.PORTAL_NAME AND F2.PORTAL_OBJNAME NOT IN ('PORTAL_USERS','PORTAL_TEMPLATES') AND F1.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'

  • Related language record: PT_IQ2_VWLNG
  • PeopleSoft Field Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
    PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name
    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

    1/0 Table Edit (1=True, 0=False)

    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PT_IQLEVEL1_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL1_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL1_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL1_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PT_IQLEVEL2_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL2_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL2_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL2_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PT_IQLEVEL3_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL3_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL3_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL3_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PT_IQLEVEL4_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL4_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL4_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL4_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PT_IQLEVEL5_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL5_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL5_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL5_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PT_IQLEVEL6_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    PT_IQLEVEL6_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PT_IQLEVEL6_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PT_IQLEVEL6_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    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