Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Item Id |
The ticket item id for this dynamic summary table that was generated for the item name. |
LONG |
Yes |
Begin Date Hour Local |
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.
|
DATE |
Yes |
Activated Count |
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.
|
NUMBER(13,2,) |
Yes |
End Date Hour Local |
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.
|
DATE |
Yes |
Resolved Count |
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.
|
NUMBER(13,2,) |
Yes |
UnResolved Count |
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.
|
NUMBER(13,2,) |
Yes |