RSEC_FMSGSET_VW

(SQL View)
 Index Back

Functional Option Messages

This is a view that gets the description of the function code, and the associated messages.

SELECT FD.RSEC_FUNC_CD , FD.MESSAGE_SET_NBR FROM PS_RSEC_FUNC_DEFN FD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges
2 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: PSMSGSETDEFN