PSNUITILE_VW

(SQL View)
 Index Back

NUI Tile View

View: Left outer join of PSPRSM_SRCH_VW and PSPRSMNUI to grab the Fluid Attributes tab info from portal registry

SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_REFTYPE , CASE WHEN (B.IMAGE_FIELD=' ' OR B.IMAGE_FIELD IS NULL) THEN 'PTNAVSRCH_DEF_ICN' ELSE B.IMAGE_FIELD END AS DEFAULT_IMAGE FROM PSPRSM_SRCH_VW A LEFT OUTER JOIN PSPRSMNUI B ON A.PORTAL_NAME=B.PORTAL_NAME AND ((A.PORTAL_OBJNAME=B.PORTAL_OBJNAME) OR (A.PORTAL_LINKOBJNAME=B.PORTAL_OBJNAME)) AND A.PORTAL_REFTYPE=B.PORTAL_REFTYPE

# 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 Portal Object Name
3 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
4 IMAGE_FIELD Image Reference(30) VARCHAR2(30) Image Reference Field to display images used in Personalizations explanations.