RSEC_FSIFNCM_VW (SQL View)	Index Back
Functional Option Messages This is a view that gets the description of the function code, and the associated messages.

RSEC_FSIFNCM_VW

(SQL View)

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 , FM.MESSAGE_NBR , FD.DESCR , FD.DESCRLONG , FD.RSEC_REVOKE_OVRIDE , FD.RSEC_AMT_OVRIDE , FD.RSEC_FP_USE_AMT , FD.BASE_CURRENCY , MG.MESSAGE_TEXT FROM PS_RSEC_FUNC_DEFN FD , PS_RSEC_FUNCMSGCAT FM , PSMSGCATDEFN MG 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SRTY_FUNCTION_CD Character(30) VARCHAR2(30) NOT NULL secutiy transaction code

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRLONG Long Character CLOB Long Description

6 RSEC_REVOKE_OVRIDE Character(1) VARCHAR2(1) NOT NULL Flag used to determine the revoke over ride winner.

7 RSEC_AMT_OVRIDE Character(1) VARCHAR2(1) NOT NULL Maximum Amount Over ride winner.

8 RSEC_FP_USE_AMT Character(1) VARCHAR2(1) NOT NULL Currency Related Function Privilege.
Y/N Table Edit
Default Value: N

9 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL

10 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	SRTY_FUNCTION_CD	Character(30)	VARCHAR2(30) NOT NULL	secutiy transaction code
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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRLONG	Long Character	CLOB	Long Description
6	RSEC_REVOKE_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine the revoke over ride winner.
7	RSEC_AMT_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Maximum Amount Over ride winner.
8	RSEC_FP_USE_AMT	Character(1)	VARCHAR2(1) NOT NULL	Currency Related Function Privilege. Y/N Table Edit Default Value: N
9	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " Prompt Table: CURRENCY_CD_TBL
10	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.