ZCA_ORCH_DT

Details

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

Primary Key

Name	Columns
ZCA_ORCH_DT_B_PK	ORCHESTRATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ORCHESTRATION_ID	NUMBER		18	Yes	Unique identifier (Primary Key) of the Orchestrations object.
ORCHESTRATION_NUMBER	VARCHAR2	64		Yes	Public unique identifier (Alternate Key) of the Orchestrations object.
OBJECT_CODE	VARCHAR2	100		Yes	Language independent code for the current row of the Orchestrations object.
STRIPING_ATTR_NAME	VARCHAR2	100			Striping attribute name. The striping attribute name determines which orchestration process will be used.
STRIPING_ATTR_DISPLAY_LABEL	VARCHAR2	1000			Striping attribute display label from the source object view definition.
STRIPING_ATTR_VALUE	VARCHAR2	2000			Striping attribute value in JSON format.
LIFECYCLE_ATTR_NAME	VARCHAR2	100		Yes	Specifies the lifecycle attr name.
LIFECYCLE_ATTR_DISPLAY_LABEL	VARCHAR2	1000			Lifecycle attribute display label from the source object view definition.
ASSOCIATION_CRITERIA_EXPR	CLOB				Criteria expression (in JSON format) used to associate Orchestration objects to transactional objects.
SIMULATION_CRITERIA_EXPR	CLOB				Criteria expression (in JSON format) used to simulate Orchestration against transactional objects.
ORCHESTRATION_JSON_STRUCTURE	CLOB				JSON structure for the whole Orchestration object.
ORCHESTRATION_TYPE	VARCHAR2	30		Yes	Type of Orchestration object.Possible values are guided selling, guidance builder,etc.
SOURCE_ORCHESTRATION_ID	NUMBER		18		Identifier of the cloned source Orchestration when the current Orchestration row is cloned.
STATUS_CODE	VARCHAR2	30		Yes	Status of the Orchestration object. Possible values are DRAFT, ACTIVE, ARCHIVED, etc.
ASSOCIATION_RANK	NUMBER	8			Rank in which the Orchestrations need to be processed during association.
ACTIVATION_DATETIME	TIMESTAMP				Date and timestamp on which the Orchestration is activated.
IMPORTED_DATETIME	TIMESTAMP				Date and timestamp on which the Orchestration is last imported from a different env.
ACTIVITY_RELATION_ATTR_NAME	VARCHAR2	100			Custom object's primary key field name on activity object for orchestration to stamp custom object id when activity is being generated.
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).
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).

Indexes

Index	Uniqueness	Tablespace	Columns
ZCA_ORCH_DT_B_N1	Non Unique	Default	OBJECT_CODE, STATUS_CODE
ZCA_ORCH_DT_B_PK	Unique	Default	ORCHESTRATION_ID
ZCA_ORCH_DT_B_U1	Unique	Default	ORCHESTRATION_NUMBER
ZCA_ORCH_DT_B_U2	Unique	Default	OBJECT_CODE, ASSOCIATION_RANK