Name |
Datatype |
Comment |
Is PK |
Is FK |
item_status_id |
bigint |
The automatically generated primary key of the :item_shortname_status table. |
Yes |
No |
item_status_name |
varchar(255) |
The name of the :item_shortname Status. |
No |
No |
is_active |
bit |
Indicates if the state is an Activated state, used only to calculate Activated
event date. Do not confuse with UnClosed, UnResolved.
|
No |
No |
is_resolved |
bit |
Indicates if the state is an Resolved state, Used to calculate Resolved event
date.
|
No |
No |
is_closed |
bit |
Indicates if the state is an Closed state, Used to calculate Closed event
date. Currently, only one status is allow to be the Closed state.
|
No |
No |
is_responded |
bit |
Indicates if the state is an Responded state, Used to calculate Responded
event date.
|
No |
No |
does_ct_for_time |
bit |
Indicates that this state does not count for time expended. This is used for
the measures that do not include the ALL designation. It is anticipated that
WAITING ON CUSTOMER RESPONSE and similar states would use this flag to show
agent metrics without such states included in the time.
|
No |
No |