CSO_SECURED_APP_ITEM

This table contains application specific actions that will be tied into role permissions. By default the class name and method are used to identify areas that can be secured. This table should not be changed except by IM developers.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_SECURED_APP_ITEM_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments	Status
CLASS_METHOD	VARCHAR2	50		An identifier that can be used to create a unique application item
CLASS_NAME	VARCHAR2	50		An identifier that can be used to create a unique application item. This is combined with the classmethod column.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
SEED_DATA_SOURCE	VARCHAR2	512		Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.	Obsolete

Foreign Keys

Table	Foreign Table	Foreign Key Column
cso_secured_app_activity	cso_secured_app_item	APP_ITEM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_SECURED_APP_ITEM_N1	Non Unique	Default	CLASS_NAME, CLASS_METHOD, DATE_ADDED, DATE_MODIFIED, RECORD_ID
CSO_SECURED_APP_ITEM_U1	Unique	Default	RECORD_ID