PORTAL_NAMEPORTAL_OBJNAMELANGUAGE_CDPT_IQ3_VWLNG(SQL View) |
Index Back |
|---|---|
Rel Lang View for Reg Level 0Related Language View for Registry Folder Structure Level 0 |
| SELECT F1.PORTAL_NAME ,C3.PORTAL_OBJNAME , B1.LANGUAGE_CD ,B1.PORTAL_LABEL ,B1.DESCR254 ,B2.PORTAL_LABEL ,B2.DESCR254 ,B3.PORTAL_LABEL ,B3.DESCR254 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' , C3.PORTAL_LABEL , C3.DESCR254 FROM PSPRSMDEFN F1 , PSPRSMDEFN F2 , PSPRSMDEFN F3 , PSPRSMDEFNLANG B1 , PSPRSMDEFNLANG B2 , PSPRSMDEFNLANG B3 , PS_PT_IQ_VWLNG C3 WHERE F3.PORTAL_OBJNAME = C3.PORTAL_PRNTOBJNAME AND F3.PORTAL_PRNTOBJNAME = F2.PORTAL_OBJNAME AND F2.PORTAL_PRNTOBJNAME = F1.PORTAL_OBJNAME AND F3.PORTAL_NAME = C3.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' AND B1.PORTAL_NAME = F1.PORTAL_NAME AND B1.PORTAL_OBJNAME = F1.PORTAL_OBJNAME AND B2.PORTAL_NAME = F2.PORTAL_NAME AND B2.PORTAL_OBJNAME = F2.PORTAL_OBJNAME AND B3.PORTAL_OBJNAME = F3.PORTAL_OBJNAME AND B1.LANGUAGE_CD = B2.LANGUAGE_CD AND B2.LANGUAGE_CD = B3.LANGUAGE_CD AND C3.LANGUAGE_CD = B1.LANGUAGE_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | PT_IQLEVEL1_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 5 | PT_IQLEVEL1_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | PT_IQLEVEL2_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 7 | PT_IQLEVEL2_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | PT_IQLEVEL3_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 9 | PT_IQLEVEL3_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 10 | PT_IQLEVEL4_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 11 | PT_IQLEVEL4_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 12 | PT_IQLEVEL5_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 13 | PT_IQLEVEL5_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 14 | PT_IQLEVEL6_LBL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 15 | PT_IQLEVEL6_DES | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 16 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 17 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |