RSEC_VIEWFUNCVW (SQL View)	Index Back
Profile View Function options Specific Functional options associated to a security profile.

RSEC_VIEWFUNCVW

(SQL View)

Profile View Function options

Specific Functional options associated to a security profile.

SELECT VF.RSEC_PROFILE_ID , VF.RSEC_VIEW_ID , VF.RSEC_FUNC_CD , VF.MESSAGE_SET_NBR , VF.MESSAGE_NBR , VF.EOEC_MP_OPERATOR , VF.RSEC_REVOKE_FLG , VF.RSEC_FUNC_STATE , FD.RSEC_REVOKE_OVRIDE , FD.RSEC_AMT_OVRIDE , VF.AMOUNT , FD.RSEC_FP_USE_AMT , FD.BASE_CURRENCY , FD.APPCLASSID , FD.APPCLASS_PATH FROM PS_RSEC_VIEW_FUNC VF , PS_RSEC_FUNC_DEFN FD WHERE VF.RSEC_FUNC_CD=FD.RSEC_FUNC_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_PROFILE_ID Character(30) VARCHAR2(30) NOT NULL A unique identifier of security profile for application security.

2 RSEC_VIEW_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier of a view list used in application security.

3 RSEC_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges

4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

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

6 EOEC_MP_OPERATOR Character(4) VARCHAR2(4) NOT NULL the conditional operator of the sql condition (<,<=,>,>=,=,<>, LIKE,...)
EAR=Earlier Than
EQT=Equal To
GTE=Greater Than or Equal To
GTN=Greater Than
LAT=Later Than
LIK=Like
LTE=Less Than or Equal To
LTN=Less Than
NEQ=Not Equal To

7 RSEC_REVOKE_FLG Character(1) VARCHAR2(1) NOT NULL Flag used to determine if the functional option is revoked in application security.

8 RSEC_FUNC_STATE Character(4) VARCHAR2(4) NOT NULL Field to as drop down to capture the translate fied value of a functional option.

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

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

11 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

12 RSEC_FP_USE_AMT Character(1) VARCHAR2(1) NOT NULL Currency Related Function Privilege.

13 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. "

14 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

15 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_PROFILE_ID	Character(30)	VARCHAR2(30) NOT NULL	A unique identifier of security profile for application security.
2	RSEC_VIEW_ID	Character(30)	VARCHAR2(30) NOT NULL	Unique identifier of a view list used in application security.
3	RSEC_FUNC_CD	Character(30)	VARCHAR2(30) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges
4	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
6	EOEC_MP_OPERATOR	Character(4)	VARCHAR2(4) NOT NULL	the conditional operator of the sql condition (<,<=,>,>=,=,<>, LIKE,...) EAR=Earlier Than EQT=Equal To GTE=Greater Than or Equal To GTN=Greater Than LAT=Later Than LIK=Like LTE=Less Than or Equal To LTN=Less Than NEQ=Not Equal To
7	RSEC_REVOKE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if the functional option is revoked in application security.
8	RSEC_FUNC_STATE	Character(4)	VARCHAR2(4) NOT NULL	Field to as drop down to capture the translate fied value of a functional option.
9	RSEC_REVOKE_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine the revoke over ride winner.
10	RSEC_AMT_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Maximum Amount Over ride winner.
11	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
12	RSEC_FP_USE_AMT	Character(1)	VARCHAR2(1) NOT NULL	Currency Related Function Privilege.
13	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. "
14	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
15	APPCLASS_PATH	Character(254)	VARCHAR2(254) NOT NULL	Application Class Full Path