PORTAL_NAMEPORTAL_OBJNAMEPrompt Table: PTCS_CREF_PRMPT
PTAL_CFG_SRCH(SQL View) |
Index Back |
|---|
| SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , B.PORTAL_LABEL FROM PS_PTAL_PAGE A , PSPRSMDEFN B WHERE A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND B.PORTAL_REFTYPE = 'C' |
| # | 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 |
Content Reference Name
Prompt Table: PTCS_CREF_PRMPT |
| 3 | PTAL_CREF_LABEL | Character(1) | VARCHAR2(1) NOT NULL | Content Reference label |