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 |
---|---|---|---|
![]() |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
![]() |
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
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 |
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 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |