This table holds the description of actions that can be performed on to-do items.
Column Descriptions
| Column Name
| Column Type
| Description
|
| TKLACTHIST_ID
| BIGINT NOT NULL
| Generated unique key.
|
| TICKLER_ID
| BIGINT NOT NULL
| Pointer to tickler for which this action applies.
|
| TKLRACTION_ID
| INTEGER NOT NULL
| Codified tickler action.
|
| ACTIONDATE
| TIMESTAMP NOT NULL
| Date action was taken.
|
| CREATEDBY_ID
| BIGINT NOT NULL
| Human who created record of action.
|
| LASTUPDATE
| TIMESTAMP NOT NULL
| Last modification date.
|
| FIELD1
| INTEGER
| Customizable
|
| FIELD2
| VARCHAR(254)
| Customizable
|
| FIELD3
| BIGINT
| Customizable
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| LANGUAGE_ID
| INTEGER NOT NULL
| Language in-use when this action was recorded.
|
| ACTIONCOMMENT
| VARCHAR(1024)
| Notes on the action taken.
|