PTSF_KIB_FUL_VW

(SQL View)
 Index Back

SELECT A.PORTAL_OBJNAME , A.PORTAL_LABEL FROM PSPRSMDEFN A , PSPRSMNUI B WHERE A.PORTAL_URI_SEG2 = 'PTSF_KIBANA_COMP' AND A.PORTAL_OBJNAME <> 'PTMDF_DASHBOARD' AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND A.PORTAL_REFTYPE='C' AND A.PORTAL_URLTEXT LIKE '%PTSF_KIBANA_COMP%DASHBOARD=%' AND B.PORTAL_URLTEXT IS NULL

# 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