ZCA_SALES_CONTENTS

This table stores content items from Oracle Content Experience system along with information about related parent objects like lead,campaign etc.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZCA_SALES_CONTENTS_PK	SALES_CONTENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SALES_CONTENT_ID	NUMBER		18	Yes	Auto generated Primary Key of the table
PARENT_OBJECT_TYPE	VARCHAR2	128		Yes	Type of the parent object like Lead/Campaign etc. that owns this content item
PARENT_OBJECT_ID	NUMBER		18	Yes	Id of the Parent Object like Lead/Campaign etc. that owns this content item
CONTENT_ITEM_ID	VARCHAR2	64		Yes	Content Item Id of the content from Oracle Content and Experience - this content is used inside the organization
PUBLIC_CONTENT_ITEM_ID	VARCHAR2	64			Public Content Item Id of the content from Oracle Content and Experience - this content is for public consumption and visible via outbound channels
CONTENT_ITEM_NAME	VARCHAR2	4000		Yes	Name of the Content Item
PUBLIC_CONTENT_ITEM_NAME	VARCHAR2	4000			Content Item name for public profiles
PUBLIC_CUSTOMER_NAME	VARCHAR2	4000			Name of the customer represented via this content - used for public profiles
PUBLIC_CONTENT_PUBLISHED_DATE	TIMESTAMP				Content publish date for public profiles
PUBLIC_CONTENT_LINK	VARCHAR2	4000			Content link for public profiles
DELETED_IN_SOURCE_FLAG	VARCHAR2	1			Flag indicating if deleted in OCE
DISPLAY_SEQUENCE	NUMBER		9		Display sequnece for the Content item
CONTENT_SOURCE_SYSTEM	VARCHAR2	50			Content source system like 'OCE'
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.
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_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
ZCA_SALES_CONTENTS_U1	Unique	Default	SALES_CONTENT_ID
ZCA_SALES_CONTENTS_U2	Unique	Default	PARENT_OBJECT_TYPE, PARENT_OBJECT_ID, CONTENT_ITEM_ID