RSEC_OBJECTDEFN (SQL Table)	Index Back
Security Object Definition Security Object Definition is a record that is setup to definition a security object. The object type can be an 'Membership' or a 'View Privilege'. The source to create a dynamic membership or view privilege is defined using a configurable search.

RSEC_OBJECTDEFN

(SQL Table)

Security Object Definition

Security Object Definition is a record that is setup to definition a security object. The object type can be an 'Membership' or a 'View Privilege'. The source to create a dynamic membership or view privilege is defined using a configurable search.

Related Language Record: RSEC_OBJECT_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRLONG Long Character CLOB Long Description

4 RSEC_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL Security object type of membership or view list translate field. The field value on the security object definition determines if the security object is considered as a membership or view object.
0001=Membership
0002=View Privilege
Default Value: 0002

5 RSEC_OBJECT_SOURCE Character(4) VARCHAR2(4) NOT NULL Dynamic definition source for creating dynamic criteria for a given security object.
0001=Configurable Search

6 RSEC_MAX_DOMAINS Number(3,0) SMALLINT NOT NULL Field used to indicate the maximum number of dynamic membership or view lists can be created for a given security object.

7 RSEC_ALLOW_ALL Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if a dynamic domain of 'All' is permitted for the given security object while creating a security key.
Y/N Table Edit
Default Value: Y

8 RSEC_ALLOW_DYNAMIC Character(1) VARCHAR2(1) NOT NULL Allow creation of dynamic domains for the security object.
Y/N Table Edit
Default Value: Y

9 RSEC_ALLOW_MULTI Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if adding multiple domains for a security key is allowed.
Y/N Table Edit
Default Value: Y

10 RSEC_ALLOW_REUSE Character(1) VARCHAR2(1) NOT NULL Allow reuse of a security domain is determined using this flag.
Y/N Table Edit
Default Value: N

11 RSEC_ALLOW_SINGLE Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.
Y/N Table Edit
Default Value: Y

12 RSEC_SECURE_ALL Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if security should be skipped in case a Security Key with 'All' domain is found.
Y/N Table Edit
Default Value: N

13 RSEC_SHOW_IN_WIZ Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.
Y/N Table Edit
Default Value: Y

14 RSEC_CACHE_OPTION Character(4) VARCHAR2(4) NOT NULL This field is used for CRM application security to determine when to run the list build AE process.
0001=Immediate on Add
0002=Immediate Always
0003=Immediate on Update
0004=Scheduled Always
Default Value: 0004

15 RSEC_RECNAME_LIST Character(15) VARCHAR2(15) NOT NULL This field is used to store the view record associated with application security.
Prompt Table: %EDITTABLE

16 RSEC_RECNAME_VIEW Character(15) VARCHAR2(15) NOT NULL This field is used to store the view record associated with application security.
Prompt Table: RSEC_SL_REC_VW

17 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

18 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

19 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

20 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name

21 BARNAME_TRN Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

22 MENUNAME_TRN Character(30) VARCHAR2(30) NOT NULL Menu Name

23 ITEMNAME_TRN Character(60) VARCHAR2(60) NOT NULL Menu/Bar/Item

24 PNLITEMNAME_SEC Character(30) VARCHAR2(30) NOT NULL Panel Item Name

25 RSEC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Field used to determine owner data information.
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
3=PeopleSoft Sample Data
Default Value: 2

26 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

27 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

28 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

29 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

30 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

31 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description
4	RSEC_OBJECT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Security object type of membership or view list translate field. The field value on the security object definition determines if the security object is considered as a membership or view object. 0001=Membership 0002=View Privilege Default Value: 0002
5	RSEC_OBJECT_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Dynamic definition source for creating dynamic criteria for a given security object. 0001=Configurable Search
6	RSEC_MAX_DOMAINS	Number(3,0)	SMALLINT NOT NULL	Field used to indicate the maximum number of dynamic membership or view lists can be created for a given security object.
7	RSEC_ALLOW_ALL	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if a dynamic domain of 'All' is permitted for the given security object while creating a security key. Y/N Table Edit Default Value: Y
8	RSEC_ALLOW_DYNAMIC	Character(1)	VARCHAR2(1) NOT NULL	Allow creation of dynamic domains for the security object. Y/N Table Edit Default Value: Y
9	RSEC_ALLOW_MULTI	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if adding multiple domains for a security key is allowed. Y/N Table Edit Default Value: Y
10	RSEC_ALLOW_REUSE	Character(1)	VARCHAR2(1) NOT NULL	Allow reuse of a security domain is determined using this flag. Y/N Table Edit Default Value: N
11	RSEC_ALLOW_SINGLE	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed. Y/N Table Edit Default Value: Y
12	RSEC_SECURE_ALL	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if security should be skipped in case a Security Key with 'All' domain is found. Y/N Table Edit Default Value: N
13	RSEC_SHOW_IN_WIZ	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed. Y/N Table Edit Default Value: Y
14	RSEC_CACHE_OPTION	Character(4)	VARCHAR2(4) NOT NULL	This field is used for CRM application security to determine when to run the list build AE process. 0001=Immediate on Add 0002=Immediate Always 0003=Immediate on Update 0004=Scheduled Always Default Value: 0004
15	RSEC_RECNAME_LIST	Character(15)	VARCHAR2(15) NOT NULL	This field is used to store the view record associated with application security. Prompt Table: %EDITTABLE
16	RSEC_RECNAME_VIEW	Character(15)	VARCHAR2(15) NOT NULL	This field is used to store the view record associated with application security. Prompt Table: RSEC_SL_REC_VW
17	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
18	BARNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Bar Name
19	ITEMNAME	Character(30)	VARCHAR2(30) NOT NULL	Item Name
20	PNLITEMNAME	Character(30)	VARCHAR2(30) NOT NULL	Panel Item Name
21	BARNAME_TRN	Character(30)	VARCHAR2(30) NOT NULL	Menu Bar Name
22	MENUNAME_TRN	Character(30)	VARCHAR2(30) NOT NULL	Menu Name
23	ITEMNAME_TRN	Character(60)	VARCHAR2(60) NOT NULL	Menu/Bar/Item
24	PNLITEMNAME_SEC	Character(30)	VARCHAR2(30) NOT NULL	Panel Item Name
25	RSEC_MAINT_OWNER	Character(1)	VARCHAR2(1) NOT NULL	Field used to determine owner data information. 0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer 3=PeopleSoft Sample Data Default Value: 2
26	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
27	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
28	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
29	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
30	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
31	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time