Footprints Data Model

Table
Table Name Time Dimension
Table Definition A table with a generic timestamp. The timestamp is broken up into the specific pieces that the reports need to slice the information according to the user specifications.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
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
Day of Week Integer Day of Week. INTEGER Yes
Day of Month Integer Day of Month. INTEGER No
Day of Quarter Integer Day of Quarter. INTEGER No
Day of Year Integer Day of Year INTEGER No
Week of Month Integer Week of month based on the ISO 8601 system used for calculating the week of the year. The first week of the month corresponds to the first week in the month of the Gregorian calendar that contains 4 days starting on a Monday. INTEGER No
Week of Quarter Integer Week of quarter based on the ISO 8601 system used for calculating the week of the year. The first week of the quarter corresponds to the first week in the first quarter month of the Gregorian calendar that contains 4 days starting on a Monday. INTEGER No
TD Hour Integer value for the hour portion of the date hour local. INTEGER Yes
TD Day Integer value for the day portion of the date hour local. INTEGER Yes
TD Week Integer value for the week of the year based on the ISO 8601 system used for calculating the week of the year. The first week of the year corresponds to the first week in the year of the Gregorian calendar that contains 4 days starting on a Monday. Weeks are then incremented each Monday, until the next years count starts INTEGER Yes
TD Month Integer value for the month portion of the date hour local. INTEGER Yes
TD Quarter Integer value for the quarter of the year. This is based on divding 12 months into 4 quarters of three consecutive months. INTEGER Yes
TD Year Integer value for the year portion of the date hour local. INTEGER Yes
Day Date Today's date with time truncated. TIMESTAMP Yes
Start of Week Date The start of the week that contains the current date hour local time. TIMESTAMP Yes
Start of Month Date The start of the month that contains the current date hour local time. TIMESTAMP Yes
Start of Quarter Date The start of the quarter that contains the current date hour local time. TIMESTAMP Yes
Start of Year Date The start of the year that contains the current date hour local time. TIMESTAMP Yes
End of Hour Date The next hour increment of the current date hour local time. DATE No
End of Day Date The next day increment of the current date hour local time. DATE No
End of Week Date The next week increment of the current date hour local time. DATE No
End of Month Date The next month increment of the current date hour local time. DATE No
End of Quarter Date The next quarter increment of the current date hour local time. DATE No
End of Year Date The next year increment of the current date hour local time. DATE No