ZCA_ES_ACTIONS

Details

Schema: FUSION
Object owner: ZCA
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
ZCA_ES_ACTIONS_PK	ACTION_UUID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ACTION_UUID	VARCHAR2	36		Yes	the primary key
META_MODEL_VERSION_UUID	VARCHAR2	36			Obsolete: the meta model version that this action is for	Obsolete
ENTITY_UUID	VARCHAR2	36		Yes	the entity that this action is for
ACTION_NAME	VARCHAR2	120		Yes	the unique name for the action
ACTION_TYPE_NAME	VARCHAR2	80		Yes	the name of the action type, one of CREATE, EDIT, CREATE_RELATED_OBJECT
ENABLED_FLAG	VARCHAR2	1		Yes	Y if the action is enabled, otherwise N
TASKFLOW_REFERENCE	VARCHAR2	254			the fully qualified taskflow reference
FUNCTIONAL_PERMISSION_NAME	VARCHAR2	120			the name of the functional permission required to perform this action, if any
METHOD_PERMISSION_NAMES	VARCHAR2	1023			The names of the method permissions for the action. If non-null, then user must have at least one of these method permissions
PRIVILEGE_NAMES	VARCHAR2	1023			The names of all the priviliges that are required for the user to invoke the action
PARAMETERS	VARCHAR2	1023			The serialized JSON for the paramters for the taskflow that implements the action
KEY_PATH_FOR_PK_OF_ENTITY	VARCHAR2	80			The key path in the parameters that holds the primary key of the entity that the action is for
RESOURCE_BUNDLE_ID	VARCHAR2	500			The resource bundle for this action
RESOURCE_KEY_NAME	VARCHAR2	500			the resource key in the RESOURCE_BUNDLE_ID for the localized name
RESOURCE_KEY_DESCRIPTION	VARCHAR2	500			the resource key in the RESOURCE_BUNDLE_ID for the localized description
DISPLAY_SEQUENCE	NUMBER		3	Yes	Specifies the order in which the actions should be displayed for an entity
DELETED_FLAG	VARCHAR2	1		Yes	Y iff the row was deleted, otherwise N
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
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.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZCA_ES_ACTIONS_PK	Unique	FUSION_TS_SEED	ACTION_UUID, ORA_SEED_SET1
ZCA_ES_ACTIONS_PK1	Unique	FUSION_TS_SEED	ACTION_UUID, ORA_SEED_SET2
ZCA_ES_ACTIONS_U1	Unique	FUSION_TS_SEED	META_MODEL_VERSION_UUID, ENTITY_UUID, ACTION_NAME	Obsolete
ZCA_ES_ACTIONS_U2	Unique	Default	ENTITY_UUID, ACTION_NAME, ORA_SEED_SET1
ZCA_ES_ACTIONS_U21	Unique	Default	ENTITY_UUID, ACTION_NAME, ORA_SEED_SET2