PRODUCTPrompt Table: EOTR_PROD
PORTAL_NAMEPrompt Table: PSPRSMDEFN
PORTAL_OBJNAMEPrompt Table: PSPRSMDEFN
EOTR_PORTL_SRCH(SQL View) |
Index Back |
|---|---|
Portal search recordinternal use only - search record for portals |
| SELECT DISTINCT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME FROM PSPRSMDEFN WHERE PORTAL_REFTYPE = 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRODUCT |
Character(6) | VARCHAR2(6) NOT NULL |
Product
Prompt Table: EOTR_PROD |
| 2 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: PSPRSMDEFN |
| 3 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Portal Object Name
Prompt Table: PSPRSMDEFN |