SBS_WF_CHASM_NODE_MAPS

Stores workflow CHASM node mapping data by shard, namespace, workflow/run, and CHASM path, including encoded metadata and payload blobs

Details

• Schema: FUSION

• Object owner: FND

• Object type: TABLE

• Tablespace: DEFAULT

Primary Key

Name	Columns
SBS_WF_CHASM_NODE_MAPS_PK	SHARD_ID, NAMESPACE_ID, WORKFLOW_ID, RUN_ID, CHASM_PATH

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SHARD_ID	NUMBER		10	Yes	The identifier value for a shard where Workflow instance is getting executed
NAMESPACE_ID	RAW	16		Yes	The identifier value for a given namespace under which Workflow instance is getting executed
WORKFLOW_ID	VARCHAR2	255		Yes	The identifier value for a given workflow instance run
RUN_ID	RAW	16		Yes	The identifier value for a given workflow instance run
CHASM_PATH	RAW	16		Yes	To store the json object
METADATA	BLOB			Yes	The workflow metadata in BLOB format
METADATA_ENCODING	VARCHAR2	16			The associated metadata encoding of the BLOB data
DATA	BLOB				The workflow execution data in BLOB format
DATA_ENCODING	VARCHAR2	16			The associated data encoding of the BLOB data
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
SBS_WF_CHASM_NODE_MAPS_U1	Unique	DEFAULT	SHARD_ID, NAMESPACE_ID, WORKFLOW_ID, RUN_ID, CHASM_PATH