CSO_TASK_STATUS
This table contains the status history.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_TASK_STATUS_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COMMENTS | VARCHAR2 | 4000 | Comments associated with the history record. | ||
| 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. | ||
| PRIORITY | NUMBER | Priority of the task at this moment in time (0-Low, 1-Med, 2- High). | |||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| 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). | |||
| TASK_ID | VARCHAR2 | 32 | Yes | This is the GUID for the task the task status is assigned to. | |
| 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 created the status record. | ||
| 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. | |
| 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. | ||
| USER_ASSIGNED_PARTY_ID | NUMBER | 18 | This is the ID for the user the task is assigned to, null if unassigned. | ||
| USER_MODIFIED_PARTY_ID | NUMBER | 18 | This is the ID for the user that modified the status record. | ||
| 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 |
|---|---|---|
| cso_task | cso_task_status | STATUS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_TASK_STATUS_N2 | Non Unique | Default | TASK_ID, STATUS |
| CSO_TASK_STATUS_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_TASK_STATUS_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |