PTSF_KIB_TIL_VW

(SQL View)
 Index Back

SELECT A.PORTAL_OBJNAME , A.PORTAL_LABEL FROM PSPRSMDEFN A ,PSPRSMNUI B WHERE A.PORTAL_URLTEXT NOT LIKE '%PTSF_KIBANA_COMP%DASHBOARD=%' AND B.portal_urltext LIKE '%PTSF_KIBANA_COMP%' AND A.PORTAL_OBJNAME=B.PORTAL_OBJNAME AND A.PORTAL_REFTYPE='C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
2 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label