Skip to main content
Skip table of contents

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

AssignedGroupIdentifier

24.3.0

VARCHAR2(50 CHAR)

Group identified value. Optional. Either this or AssignedUsersDcid is required.

AssignedTimestamp

24.3.0

TIMESTAMP(6)

Record creation timestamp. Default to system date and time. Required.

AssignedUsersDcid

24.3.0

NUMBER(19,0)

Dcid of the user assigned to the task instance. Optional. Either this or AssignedGroupIdentifier is required.

CurrentStatusCode

24.3.0

NUMBER(19,0)

Current status of the task instance. Refers the codeset.codesetid. Required.

DueDateTimestamp

24.3.0

TIMESTAMP(6)

Due date of the assigned task instance.

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.