CSO_TASK
This table contains the task records.
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 |