PORTAL_NAMEPTCXM_CREF_OBJPTCS_CREF_PRMPT(SQL View) |
Index Back |
|---|
| SELECT A.PORTAL_NAME ,A.PORTAL_OBJNAME ,A.PORTAL_LABEL ,B.PORTAL_LABEL ,A.PORTAL_CNTPRV_NAM FROM PSPRSMDEFN A , PSPRSMDEFN B WHERE A.PORTAL_CREF_USGT='TARG' AND A.PORTAL_PRNTOBJNAME <> 'PORTAL_BASE_DATA' AND A.PORTAL_PRNTOBJNAME <> 'PORTAL_TEMPLATE_PAGELETS' AND A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_CREF_URLT='UPGE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | PTCXM_CREF_OBJ |
Character(30) | VARCHAR2(30) NOT NULL | Menu Item Name |
| 3 | PTCXM_CREF_LBL | Character(30) | VARCHAR2(30) NOT NULL | Content Reference label (PORTAL_LABEL) |
| 4 | PTCXM_FLD_LBL | Character(30) | VARCHAR2(30) NOT NULL | Content Folder Label (PORTAL_LABEL) |
| 5 | PTCXM_CNTPRV_NAM | Character(30) | VARCHAR2(30) NOT NULL | Content Provider Name |