PT_IQLEVEL0 | 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' |
| 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 |