EONC_CREF_DESCRC=Content
F=Folder
EONC_CREF_VW(SQL View) |
Index Back |
|---|---|
CREF Search ViewCREF Search View |
| SELECT PORTAL_LABEL , PORTAL_OBJNAME , PORTAL_NAME , PORTAL_REFTYPE , PORTAL_URI_SEG1 , PORTAL_URI_SEG2 , PORTAL_URI_SEG3 FROM PSPRSMDEFN WHERE PORTAL_REFTYPE = 'C' AND PORTAL_CREF_USGT = 'TARG' AND PORTAL_NAME <> 'HC_REGISTRY' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EONC_CREF_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | CREF description. |
| 2 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 3 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 4 | PORTAL_REFTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content F=Folder |
| 5 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 6 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 7 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |