PT_IQLEVEL4(SQL View) |
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' |
| # | 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 |