RSEC_PRFFUNCVW (SQL View)	Index Back
Security profile function view View that shows the function option groups associated to application security profile.

RSEC_PRFFUNCVW

(SQL View)

Security profile function view

View that shows the function option groups associated to application security profile.

SELECT PF.RSEC_PROFILE_ID , FGD.RSEC_FUNC_CD , FGD.MESSAGE_SET_NBR , FGD.MESSAGE_NBR , FGD.EOEC_MP_OPERATOR , FGD.RSEC_REVOKE_FLG , FGD.RSEC_FUNC_STATE , FD.RSEC_REVOKE_OVRIDE , FD.RSEC_AMT_OVRIDE , FGD.AMOUNT , FD.RSEC_FP_USE_AMT , FD.BASE_CURRENCY , FD.APPCLASSID , FD.APPCLASS_PATH FROM %Table(RSEC_PROFILEFNC) PF , %Table(RSEC_FUNCGP_DTL) FGD , %Table(RSEC_FUNC_DEFN) FD WHERE PF.RSEC_FUNC_GRP_ID=FGD.RSEC_FUNC_GRP_ID AND FGD.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_FUNC_CD Character(30) VARCHAR2(30) NOT NULL Security privilege code. Used by CRM self-service to define security privileges

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

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

5 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

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

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

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

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

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

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

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

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

14 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_FUNC_CD	Character(30)	VARCHAR2(30) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges
3	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
4	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
5	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
6	RSEC_REVOKE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine if the functional option is revoked in application security.
7	RSEC_FUNC_STATE	Character(4)	VARCHAR2(4) NOT NULL	Field to as drop down to capture the translate fied value of a functional option.
8	RSEC_REVOKE_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determine the revoke over ride winner.
9	RSEC_AMT_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	Maximum Amount Over ride winner.
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	RSEC_FP_USE_AMT	Character(1)	VARCHAR2(1) NOT NULL	Currency Related Function Privilege.
12	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. "
13	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
14	APPCLASS_PATH	Character(254)	VARCHAR2(254) NOT NULL	Application Class Full Path