IBM InfoSphere Master Data Management, Version 11.3The TASKDEFINITIONNLS table defines the task definition in localized form.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| TASK_DEFINITION_NLS_ID | A unique, system-generated key that identifies a locale-specific task definition 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 |
| LANG_TP_CD | Identifies a spoken language, such as English, French, Spanish, or German. When used as part of the primary key of a code value lookup table, the Language Type Code also represents the language of the code name. | BIGINT | Not Null | No |
| TASK_NAME | The name of the task in the specific language. | VARCHAR(255) | Not 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 |