CSO_TASK

Details

Schema: FUSION
Object owner: CSO
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_TASK_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	This is the datetime that the record was modified.
MODIFIED_BY_USER	VARCHAR2	50			The name of the user that last updated the task.
USER_ID	VARCHAR2	32			This is the obsolete GUID of the user associated with this record.
OWNER_SITE_ID	VARCHAR2	32		Yes	This is the GUID of the repository that the task belongs to.
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
ROLE_ID	VARCHAR2	32			This has been deprecated from the schema.
JOB_START	TIMESTAMP				Datetime the batch job ran that created task if created by a batch process.
STATUS_ID	VARCHAR2	32		Yes	This is the GUID to the current status record.
TASK_NAME	VARCHAR2	1000		Yes	This is the name for the task in this record.
TASK_TYPE	NUMBER				Numeric value used as indicator of the lookupcode for the type of task.
WORKFLOW_STEP_ID	VARCHAR2	32			This is the GUID to the workflow step associated with the task if task is a workflow related task.
LOCALE_ID	VARCHAR2	32			This is the Reference to locale table record.
CONTENT_ID	VARCHAR2	32			This is the Reference to content table record.
CONTENT_TEXT_ID	VARCHAR2	32			This is the GUID to the content record the task is associated with if applicable.
TOPIC_ID	VARCHAR2	32			This is the GUID to the DBTOPIC record the task is associated with if applicable.
MESSAGE_ID	VARCHAR2	32			This is the GUID to the DBMESSAGE record the task is associated with if applicable.
FORUM_ID	VARCHAR2	32			This is the GUID to the DBFORUM record the task is associated with if applicable.
SYSTEM_COMMENTS	VARCHAR2	500			Comments dynamically created by system.
COMMENTS	VARCHAR2	4000			Comments entered by a user while performing a task if applicable.
RESOLUTION	VARCHAR2	500			System created comments based on the resolution of a task.
TASK_ID	VARCHAR2	255			This is the ID assigned to the task.
TASK_ID_NUMBER	NUMBER				The numeric portion of the task ID used for sorting.
RECOMMENDATION_ID	VARCHAR2	32			This is the GUID to a content recommendation associated with the task if applicable.
PRIORITY	NUMBER				Priority of the task at this moment in time (0-Low, 1-Med, 2- High).
STATUS	NUMBER				Numeric value used as indicator of the lookupcode for status of task at this moment in time (0-New, 1-Open, 2-Unassigned, 3-Ignored, 4-Closed).
USER_ASSIGNED_ID	VARCHAR2	32			This is the obsolete GUID for the user the task is assigned to, null if unassigned.
USER_ASSIGNED_NAME	VARCHAR2	100			The name of the user the task is assigned to.
USER_MODIFIED_ID	VARCHAR2	32			This is the obsolete GUID for the user that modified the status record.
USER_MODIFIED_NAME	VARCHAR2	100			The name of the user that modified the status record.
TASK_SUB_TYPE	VARCHAR2	64			This is a custom task sub type for the record.
USER_ASSIGNED_PARTY_ID	NUMBER		18		This is the ID for the user the task is assigned to, null if unassigned.
USER_PARTY_ID	NUMBER		18		This is the ID of the user associated with this record.
USER_MODIFIED_PARTY_ID	NUMBER		18		This is the ID for the user that modified the status record.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_TASK	cso_site	OWNER_SITE_ID
CSO_TASK	cso_task_status	STATUS_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_TASK_N1	Non Unique	Default	STATUS_ID
CSO_TASK_N3	Non Unique	Default	TASK_TYPE, CONTENT_ID
CSO_TASK_N4	Non Unique	Default	WORKFLOW_STEP_ID, LOCALE_ID, STATUS
CSO_TASK_N5	Non Unique	Default	LOCALE_ID, STATUS
CSO_TASK_N6	Non Unique	Default	STATUS
CSO_TASK_N7	Non Unique	Default	OWNER_SITE_ID
CSO_TASK_N8	Non Unique	Default	TASK_TYPE, STATUS, OWNER_SITE_ID, USER_ASSIGNED_PARTY_ID
CSO_TASK_U1	Unique	Default	RECORD_ID