CDTASKSTATUSTP
The CDTASKSTATUSTP table contains the various status types, with their respective definitions, that are available to represent the lifecycle of a task instance, such as New, Pending or Completed.
This table is used by the following functional feature.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| 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 | Yes |
| TASK_STATUS_TP_CD | A code that identifies the status of a task instance. For example,"New", "Pending", "In Progress", and "Completed". | BIGINT | Not Null | Yes |
| NAME | A short, meaningful label for the value of the type code. | VARCHAR(120) | Not Null | No |
| DESCRIPTION | Provides extra information that can be used either as an additional definition of the type code value or as free form comments used by the user to provide further meaning to the type code. | VARCHAR(255) | Null | No |
| IS_ACTIVE | Indicates whether the task status is active or inactive. | CHAR(1) | Not Null | No |
| EXPIRY_DT | The date that the type code is no longer valid. | 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 |