IBM InfoSphere Master Data Management, Version 10.1The TASKROLEASSOC table stores the association between a task definition and a user role. A task definition can have associations to multiple users, and each association is a record in this table which is used in each task instance. The task can only be assigned to a task owner who belongs to a role which already has a association with the task.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| task_role_assoc_id | A unique, system-generated key that identifies the association between a task and the role of the user entitled to that task in the system. | BIGINT | Not Null | Yes |
| task_definition_id | A unique, system-generated key that identifies a task definition in the system. | BIGINT | Not Null | No |
| task_owner_role | Name given to the user role. | VARCHAR(80) | Not Null | No |
| start_dt | The date when this record becomes active. | TIMESTAMP | Not Null | No |
| end_dt | The date when this record becomes inactive. | TIMESTAMP | Null | No |
| last_update_dt | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| last_update_user | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| last_update_tx_id | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
