HR_PSEL_CREF_VW

(SQL View)
Index Back

Cref definition view

Person selector Row Security Search uses the view to get information about the passed cref

SELECT PORTAL_OBJNAME , PORTAL_URI_SEG1 , PORTAL_URI_SEG2 , PORTAL_URI_SEG3 FROM PSPRSMDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 MARKET Character(3) VARCHAR2(3) NOT NULL Market