RSEC_FUNC_MGLNG (SQL View)	Index Back
Functional Option Messages Related language view that gets the description of the function code, and the associated messages.

RSEC_FUNC_MGLNG

(SQL View)

Functional Option Messages

Related language view that gets the description of the function code, and the associated messages.

SELECT FD.RSEC_FUNC_CD , FD.MESSAGE_SET_NBR , FM.MESSAGE_NBR , ML.LANGUAGE_CD , ML.MESSAGE_TEXT FROM PS_RSEC_FUNC_DEFN FD , PS_RSEC_FUNCMSGCAT FM , PSMSGCATDEFN MG , PSMSGCATLANG ML WHERE FD.RSEC_FUNC_CD = FM.RSEC_FUNC_CD AND FD.MESSAGE_SET_NBR = MG.MESSAGE_SET_NBR AND FM.MESSAGE_NBR = MG.MESSAGE_NBR AND MG.MESSAGE_SET_NBR = ML.MESSAGE_SET_NBR AND MG.MESSAGE_NBR = ML.MESSAGE_NBR

Related Language Record for RSEC_FUNC_MG_VW

# 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

3 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	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
3	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.