Footprints Data Model

Table
Name :item_shortname_status
Comment The configuration settings for the item status and item lifecycle flags are maintained in this table for performance and history reasons. They are replicated here at the beginning of the data mart load process. Even a retired status will be in this table in order to support historical entries. :item_shortname will be substituted at publish.

Column
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