PTBR_PORTAL_PVW(SQL View) |
Index Back |
---|---|
Portal Name Prompt |
SELECT 'LOCAL_PORTAL' , MESSAGE_TEXT FROM %Table(PSMSGCATDEFN) WHERE MESSAGE_SET_NBR = 219 AND MESSAGE_NBR = 7466 UNION SELECT PORTAL_NAME , DESCR254 FROM %Table(PSPRDMDEFN) WHERE PORTAL_TYPE = ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |