TaskAssignment (ver24.3.0)
This table stores the task assignment records. The task can be assigned to admin/teacher users or to a specific group identified by the group identifier name.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AssignedUsersDcid | 24.3.0 | NUMBER(19,0) | Dcid of the user assigned to the task instance. Optional. Either this or AssignedGroupIdentifier is required. |
IsAssigned | 24.6.0 | NUMBER(1) | Indicates if the record is assigned to a user. For individual assignments this flag will be 1 as there is only one assignment record. For group assignments there will be more than one assignment records for the same task instance and isAssigned flag will be one for at most one assignment record. |
TaskAssignmentId | 24.3.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
TaskInstanceId | 24.3.0 | NUMBER(19,0) | Refers the TaskInstance.TaskInstanceId. Required. |
WhenCreated | 24.3.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 24.3.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 24.3.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 24.3.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |