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