PTS_CREF_FL_VW

(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 , C.ADDSRCHRECNAME , B.BARNAME , B.ITEMNAME , A.FLUIDMODE , C.ACTIONS , C.PRIMARYACTION , C.DFLTACTION , CASE WHEN C.FLUIDMODE = 0 AND C.INCSEARCH = 0 THEN 1 WHEN C.FLUIDMODE = 1 AND C.INCSEARCH = 1 AND C.COMP_TYPE = 0 THEN 1 ELSE 0 END AS SEARCHFLAG 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
8 ADDSRCHRECNAME Character(15) VARCHAR2(15) NOT NULL Additional Search Record Name
9 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
10 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
11 FLUIDMODE Number(1,0) SMALLINT NOT NULL Fluid Mode
12 ACTIONS Number(4,0) SMALLINT NOT NULL Actions
13 PRIMARYACTION Number(3,0) SMALLINT NOT NULL Main action for internet panel
14 DFLTACTION Number(5,0) INTEGER NOT NULL Default srch action-internet
15 INCSEARCH Number(3,0) SMALLINT NOT NULL Include Search Page