Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Item Transition Id |
The automatically generated primary key of the :item_shortname_transn table. |
LONG |
Yes |
From Item Status Id |
A Foreign Key to the :item_shortname Status table. |
LONG |
Yes |
To Item Status Id |
A Foreign Key to the :item_shortname Status table. |
LONG |
Yes |
From Item Status Name |
The name of the From Status. |
VARCHAR(255) |
Yes |
To Item Status Name |
The name of the To Status. |
VARCHAR(255) |
Yes |
Hop Count |
The number of transitions. Open to Active to Closed will be stored additionally as Open to Closed with a hop count of 2.
|
INTEGER |
Yes |
Is Longest Hop |
Indicates that this transition is a 'longest hop' transition. Many reports will want to find the longest transition between two states, and ignore cycles within the two.
|
BOOLEAN |
Yes |