Footprints Data Model

Table
Table Name :item_shortname Status
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Status Id The automatically generated primary key of the :item_shortname_status table. LONG Yes
Item Status Name The name of the :item_shortname Status. VARCHAR(255) Yes
Is Active Indicates if the state is an Activated state, used only to calculate Activated event date. Do not confuse with UnClosed, UnResolved. BOOLEAN Yes
Is Resolved Indicates if the state is an Resolved state, Used to calculate Resolved event date. BOOLEAN Yes
Is Closed 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. BOOLEAN Yes
Is Responded Indicates if the state is an Responded state, Used to calculate Responded event date. BOOLEAN Yes
Does Count for Time 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. BOOLEAN Yes