PTPP_SCLOOKUPVW

index back

SELECT PORTAL_NAME , PORTAL_LABEL , %TrimSubstr(PORTAL_OBJNAME,1,30) %Concat ':' %Concat %TrimSubstr(PORTAL_NAME,1,30) FROM PSPRSMDEFN WHERE PORTAL_PRNTOBJNAME = 'CO_NAVIGATION_COLLECTIONS' AND PORTAL_REFTYPE = 'F'

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PTPP_SCNAME Character(30) VARCHAR2(30) NOT NULL Name
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19