HCSC_CLK_CREFVW

(SQL View)
 Index Back

Fluid Cref View


SELECT A.PORTAL_NAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_OBJNAME , A.PORTAL_URI_SEG1 , A.PORTAL_URI_SEG2 , %Substring(A.PORTAL_URI_SEG3,1,3) , CASE WHEN B.SEARCHRECNAME = ' ' THEN C.SEARCHRECNAME ELSE B.SEARCHRECNAME END AS SEARCHRECNAME FROM PSPRSMDEFN A , PSMENUITEM B , PSPNLGRPDEFN C WHERE A.PORTAL_URI_SEG1 = B.MENUNAME AND A.PORTAL_URI_SEG2 = B.PNLGRPNAME AND %Substring(A.PORTAL_URI_SEG3,1,3) = B.MARKET AND A.PORTAL_URI_SEG2 = C.PNLGRPNAME AND %Substring(A.PORTAL_URI_SEG3,1,3) = C.MARKET AND A.PORTAL_REFTYPE = 'C' AND A.PORTAL_CREF_URLT IN ('UPGE','UGEN')

# 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_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
4 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
5 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
6 MARKET Character(3) VARCHAR2(3) NOT NULL Market
7 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name