Footprints Data Model

Table
Name life_cycle_event
Comment
This may come into play for the "First Contact" which is defined as:

From Ursula Strahm (3/23/2012)
First Call from the Executive Dashboard SRS:

 

First Call.-  The elapsed time between the From and To Event is 0 for the
current Widget configuration. Examples of this are:

i.              The Issue is created in the “To Event” status.  In this case,
the Issue will always show in the First Call bucket.

ii.             Issue went from Created to “To Event” status outside of working
hours and the Widget is configured to display “Work Hours”

iii.            Issue was Created in a “does not count for time” status and it
stay in “does not count for time status” until it reached the to “To Event” and
the Widget is configured to “only account for time spent in statuses included in
the Issue Lifecycle Time Measurements”   

Column
Name Datatype Comment Is PK Is FK
life_cycle_event_id int The automatically generated primary key of the life_cycle_event table. Yes No
life_cycle_event_name varchar(255) The name of the Life Cycle Event. No No
life_cycle_event_descr varchar(512)
A descriptive name of the Life Cycle Event.  This descriptive name may be
localized.
No No