1. Tables and Views for SCM
  2. CMK_COLLAB_MSG_ATTACHMENTS

CMK_COLLAB_MSG_ATTACHMENTS

This table is used to store attachment source and target xpath details

Details

  • Schema: FUSION

  • Object owner: CMK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CMK_COLLAB_MSG_ATTACHMENTS_PK

MSG_ATTACHMENT_ID

Columns

Name Datatype Length Precision Not-null Comments
MSG_ATTACHMENT_ID NUMBER 18 Yes Primary key of Collaboration Message Attachments
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
MESSAGE_ID NUMBER 18 Yes Foreign Key to Collaboration Message
RET_SEQUENCE NUMBER 18 Yes Sequence in which the documents should be retrived and embedded. Autogenerated, read only, unique for a Collaboration Message
ENTITY_KEY_XPATH VARCHAR2 2000 XPath of a unique key that identifies the entity e.g. PO Line for which attachments are being processed
PARENT_KEY1_XPATH VARCHAR2 2000 XPath of a unique key that identifies the root parent of the entity. This will not have a value if the entity is the root
PARENT_KEY2_XPATH VARCHAR2 2000 XPath of a unique key that identifies the first level child of the root parent of the entity. This will not have a value if the entity is itself a first level child of the object
PARENT_KEY3_XPATH VARCHAR2 2000 XPath of a unique key that identifies the second level child of the root parent of the entity. This will not have a value if the entity is itself a first level child of the object
PARENT_KEY4_XPATH VARCHAR2 2000 XPath of a unique key that identifies the third level child of the root parent of the entity. This will not have a value if the entity is itself a third level child of the object
PARENT_KEY5_XPATH VARCHAR2 2000 XPath of a unique key that identifies the fourth level child of the root parent of the entity. This will not have a value if the entity is itself a fourth level child of the object
PARENT_KEY6_XPATH VARCHAR2 2000 XPath of a unique key that identifies the fifth level child of the root parent of the entity. This will not have a value if the entity is itself a fifth level child of the object
SOURCE_UCM_ID_XPATH VARCHAR2 2000 XPath of the field in the source object that contains the ID of the attachment in UCM
TARGET_ELEMENT_XPATH VARCHAR2 2000 XPath of External Message element where the attachment will be embedded. Data Type of the target field must be xsd:base64Binary or a derivative of this type.
TARGET_NAME_XPATH VARCHAR2 2000 XPath of External Message element where the name of the attached file will be embedded.
TARGET_TYPE_XPATH VARCHAR2 2000 XPath of External Message element where the type of the attached file will be embedded.
TARGET_SIZE_XPATH VARCHAR2 2000 XPath of External Message element where the size of the attached file will be embedded.
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.
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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CMK_COLLAB_MSG_ATTACHMENTS cmk_collab_messages_b MESSAGE_ID

Indexes

Index Uniqueness Tablespace Columns
CMK_COLLAB_MSG_ATTACH_U1 Unique FUSION_TS_SEED MSG_ATTACHMENT_ID, ORA_SEED_SET1
CMK_COLLAB_MSG_ATTACH_U11 Unique FUSION_TS_SEED MSG_ATTACHMENT_ID, ORA_SEED_SET2