Name |
Datatype |
Comment |
Is PK |
Is FK |
item_id |
bigint |
The ticket item id for this dynamic summary table that was generated for the
item name.
|
Yes |
No |
begin_date_hour_local |
datetime |
The begin whole hour of the time period for which this ticket is unclosed at
the last minute of the first hour through the last minute of the end hour.
Joins to TIME DIM.
|
Yes |
No |
activated_ct |
numeric(13,2) |
Indicates if the Activation Event occured prior to the end of the period. A one
or zero integer count flag for the Item, designed to be summed in a query. It
is important to identify the ONE ROW in this table which has the correct count
flag by date joining, so that summing the count flag will not double count. That
is the method of high performance aggregation.
|
No |
No |
end_date_hour_local |
datetime |
The end whole hour of the time period for which this ticket is unclosed at the
last minute of the first hour through the last minute of the end hour. Joins to
TIME DIM.
|
No |
No |
resolved_ct |
numeric(13,2) |
Indicates if the Resolved Event occured prior to the end of the period. A one
or zero integer count flag for the Item, designed to be summed in a query. It
is important to identify the ONE ROW in this table which has the correct count
flag by date joining, so that summing the count flag will not double count. That
is the method of high performance aggregation.
|
No |
No |
unresolved_ct |
numeric(13,2) |
Indicates if the Resolved Event had not occured prior to the end of the period.
This is the inverse of the Resolved Ct, and makes it easier to count UnResolved.
A one or zero integer count flag for the Item, designed to be summed in a query.
It is important to identify the ONE ROW in this table which has the correct
count flag by date joining, so that summing the count flag will not double
count. That is the method of high performance aggregation.
|
No |
No |