PT_IQLEVEL4

Return to Index

View: PS_PT_IQLEVEL4

Registry Folder Struct Level 4

PlatformView Text
DefaultSELECT 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 NameDescription
    PORTAL_NAMEPortal Name
    PORTAL_OBJNAMEPortal Object Name
    PORTAL_PRODUCTProduct for Foler or Content Reference
    PORTAL_CNTPRV_NAMContent Provider Name
    PORTAL_TEMPL_NAMETemplate Name
    PORTAL_CREF_URLTURL 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_USGTUsage Type
    FRMT=Frame template
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    LINK=Content Reference Link
    TARG=Target
    PORTAL_ISPUBLICIs Public

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

    OPRIDA user's ID
    PT_IQLEVEL1_SEQSequence number
    PT_IQLEVEL1_OBJPortal Object Name
    PT_IQLEVEL1_LBLPortal Label
    PT_IQLEVEL1_DESDescription of length 254
    PT_IQLEVEL2_SEQSequence number
    PT_IQLEVEL2_OBJPortal Object Name
    PT_IQLEVEL2_LBLPortal Label
    PT_IQLEVEL2_DESDescription of length 254
    PT_IQLEVEL3_SEQSequence number
    PT_IQLEVEL3_OBJPortal Object Name
    PT_IQLEVEL3_LBLPortal Label
    PT_IQLEVEL3_DESDescription of length 254
    PT_IQLEVEL4_SEQSequence number
    PT_IQLEVEL4_OBJPortal Object Name
    PT_IQLEVEL4_LBLPortal Label
    PT_IQLEVEL4_DESDescription of length 254
    PT_IQLEVEL5_SEQSequence number
    PT_IQLEVEL5_OBJPortal Object Name
    PT_IQLEVEL5_LBLPortal Label
    PT_IQLEVEL5_DESDescription of length 254
    PT_IQLEVEL6_SEQSequence number
    PT_IQLEVEL6_OBJPortal Object Name
    PT_IQLEVEL6_LBLPortal Label
    PT_IQLEVEL6_DESDescription of length 254
    PORTAL_SEQ_NUMSequence number
    PORTAL_LABELPortal Label
    DESCR254Description of length 254
    PORTAL_URLTEXTPortal URL Logical Text

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010