PSPRSMNAVMODE (SQL View)	Index Back
Cref Navigation Modes View to return Target Cref's Properties such as Classic, FLUID, SFF. Mainly used by PORTALREGISTRY_CQ Connected Query for Menu Search Returns '1' for Classic , '2' for Fluid, and 3 for SFF (Small Form Factor)

PSPRSMNAVMODE

(SQL View)

Cref Navigation Modes

View to return Target Cref's Properties such as Classic, FLUID, SFF. Mainly used by PORTALREGISTRY_CQ Connected Query for Menu Search Returns '1' for Classic , '2' for Fluid, and 3 for SFF (Small Form Factor)

SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , CASE WHEN (A.FLUIDMODE = 1) THEN '2' ELSE '1' END FROM %Table(PSPRSMDEFN) A WHERE (A.PORTAL_CREF_USGT = 'TARG') UNION SELECT B.PORTAL_NAME , B.PORTAL_OBJNAME , '3' FROM %Table(PSPRSMDEFN) B WHERE (B.PORTAL_CREF_USGT = 'TARG') AND B.SMALLFFOPT=1

# 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 PTSF_NAV_MODE Character(1) VARCHAR2(1) NOT NULL Navigation Modes

#	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	PTSF_NAV_MODE	Character(1)	VARCHAR2(1) NOT NULL	Navigation Modes