PT_IQLEVEL4

index back

Registry Folder Struct Level 4


SELECT F1.PORTAL_NAME ,C4.PORTAL_OBJNAME ,C4.PORTAL_PRODUCT ,C4.PORTAL_CNTPRV_NAM ,C4.PORTAL_TEMPL_NAME ,C4.PORTAL_CREF_URLT ,C4.PORTAL_CREF_USGT ,C4.PORTAL_ISPUBLIC ,C4.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 ,F3.PORTAL_SEQ_NUM ,F3.PORTAL_OBJNAME ,F3.PORTAL_LABEL ,F3.DESCR254 ,F4.PORTAL_SEQ_NUM ,F4.PORTAL_OBJNAME ,F4.PORTAL_LABEL ,F4.DESCR254 ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' , C4.PORTAL_SEQ_NUM , C4.PORTAL_LABEL , C4.DESCR254 , C4.PORTAL_URLTEXT FROM PSPRSMDEFN F1 , PSPRSMDEFN F2 , PSPRSMDEFN F3 , PSPRSMDEFN F4 , PS_PT_IQ_VW C4 WHERE F4.PORTAL_OBJNAME = C4.PORTAL_PRNTOBJNAME AND F4.PORTAL_PRNTOBJNAME = F3.PORTAL_OBJNAME AND F3.PORTAL_PRNTOBJNAME = F2.PORTAL_OBJNAME AND F2.PORTAL_PRNTOBJNAME = F1.PORTAL_OBJNAME AND F4.PORTAL_NAME = C4.PORTAL_NAME AND F3.PORTAL_NAME = F4.PORTAL_NAME AND F2.PORTAL_NAME = F3.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_IQ4_VWLNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PORTAL_PRODUCTCharacter(4)VARCHAR2(4) NOT NULLProduct for Foler or Content Reference
    PORTAL_CNTPRV_NAMCharacter(30)VARCHAR2(30) NOT NULLContent Provider Name
    PORTAL_TEMPL_NAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Name
    PORTAL_CREF_URLTCharacter(4)VARCHAR2(4) NOT NULLURL 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_USGTCharacter(4)VARCHAR2(4) NOT NULLUsage 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_ISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public

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

    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PT_IQLEVEL1_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL1_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL1_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL1_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PT_IQLEVEL2_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL2_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL2_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL2_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PT_IQLEVEL3_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL3_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL3_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL3_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PT_IQLEVEL4_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL4_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL4_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL4_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PT_IQLEVEL5_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL5_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL5_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL5_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PT_IQLEVEL6_SEQNumber(4,0)SMALLINT NOT NULLSequence number
    PT_IQLEVEL6_OBJCharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PT_IQLEVEL6_LBLCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PT_IQLEVEL6_DESCharacter(254)VARCHAR2(254) NOT NULLDescription of length 254
    PORTAL_SEQ_NUMNumber(4,0)SMALLINT NOT NULLSequence number
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    PORTAL_URLTEXTLong CharacterCLOBPortal URL Logical Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19