Footprints Data Model

Table
Table Name :item_shortname Transition Sum
Table Definition The fact table for state transitions. It holds all transitions, whether they are transitive or not. Transitions with a hop count of 1 are traditional transitions. There can be multiple cycles between two states for a single ticket. The Is Longest Hop can be used to identify the distinct longest paths. Work Hours and Clock Hours are calculated for all transitions. In addition to the built-in reporting, this table can be used in any dimensional BI tool to produce useful reports.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Id The automatically generated primary key of the :item_shortname_transn_sum table. LONG Yes
Item Transition Id A Foreign Key to the :item_shortname Transition table. LONG Yes
Date Hour Local A date time in UTC that cooresponds to a whole hour date in the local timezone for the Date Hour Local. The Minutes portion of the date will usually be 00 but can be 30, 15, 45 in the case of half hour or quarter hour time zones. UTC never has daylight savings is in effect, DATE Yes
Transition DateTime The exact event date and time in UTC. This is used to calculate exact times and durations. It is within the hour that is bound by the local hour. DATE Yes
Clock Hours Count The elapsed clock hours for the transistion between the from and to states. This does not include the time spent in DOES NOT COUNT FOR TIME states. NUMBER(13,2) Yes
Work Hours Count The elapsed work hours for the transistion between the from and to states. This does not include the time spent in DOES NOT COUNT FOR TIME states. Work hours are defined by the schedule actual period table. NUMBER(13,2) Yes
All Clock Hours Count The elapsed clock hours for the transistion between the from and to states. The status flag DOES NOT COUNT FOR TIME is ignored here. NUMBER(13,2) Yes
All Work Hours Count The elapsed clock hours for the transistion between the from and to states. The status flag DOES NOT COUNT FOR TIME is ignored here. Work hours are defined by the schedule actual period table. NUMBER(13,2) Yes