PT_IQLEVEL0

(SQL View)
 Index Back

Registry Folder Struct Level 0


SELECT F1.PORTAL_NAME ,F1.PORTAL_OBJNAME ,F1.PORTAL_PRODUCT ,F1.PORTAL_CNTPRV_NAM ,F1.PORTAL_TEMPL_NAME ,F1.PORTAL_CREF_URLT ,F1.PORTAL_CREF_USGT ,F1.PORTAL_ISPUBLIC ,F1.OPRID ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' ,0 ,' ' ,' ' ,' ' , F1.PORTAL_SEQ_NUM , F1.PORTAL_LABEL , F1.DESCR254 ,%textIn(F1.PORTAL_URLTEXT) FROM PSPRSMDEFN F1 WHERE PORTAL_REFTYPE = 'C' AND F1.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'

  • Related Language Record: PT_IQ0_VWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
    4 PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name
    5 PORTAL_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    6 PORTAL_CREF_URLT Character(4) VARCHAR2(4) NOT NULL URL Type
    NONE=None
    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
    7 PORTAL_CREF_USGT Character(4) VARCHAR2(4) NOT NULL Usage Type
    FRMT=Frame template
    GRPT=Fluid Homepage
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    IFRM=Inline frame template
    LINK=Content Reference Link
    SECT=Section template
    TARG=Target
    8 PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public

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

    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    10 PT_IQLEVEL1_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    11 PT_IQLEVEL1_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    12 PT_IQLEVEL1_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    13 PT_IQLEVEL1_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    14 PT_IQLEVEL2_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    15 PT_IQLEVEL2_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    16 PT_IQLEVEL2_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    17 PT_IQLEVEL2_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    18 PT_IQLEVEL3_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    19 PT_IQLEVEL3_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    20 PT_IQLEVEL3_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    21 PT_IQLEVEL3_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    22 PT_IQLEVEL4_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    23 PT_IQLEVEL4_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    24 PT_IQLEVEL4_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    25 PT_IQLEVEL4_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    26 PT_IQLEVEL5_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    27 PT_IQLEVEL5_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    28 PT_IQLEVEL5_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    29 PT_IQLEVEL5_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    30 PT_IQLEVEL6_SEQ Number(4,0) SMALLINT NOT NULL Sequence number
    31 PT_IQLEVEL6_OBJ Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    32 PT_IQLEVEL6_LBL Character(30) VARCHAR2(30) NOT NULL Portal Label
    33 PT_IQLEVEL6_DES Character(254) VARCHAR2(254) NOT NULL Description of length 254
    34 PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
    35 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    36 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    37 PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text