Footprints Data Model

Table
Table Name Previous Timing
Table Definition A table with a generic timestamp. The timestamp is used to give the timestamps of previous and second previous timestamps according to a step as specified in the choices the user has for comparison reports.

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, This ties the previous and second previous dates to the date hour local of the time dimesnion table. DATE Yes
Previous Day The date for the start of the previous day for the start of the day that contains the current date hour local time. DATE No
Previous Day of Week The date for the start of the day one week back from the current date hour local time. DATE No
Previous Day of Month The date for the start of the day one month back from the current date hour local time. DATE No
Previous Day of Quarter The date for the start of the day one quarter back from the current date hour local time. DATE No
Previous Day of Year The date for the start of the day one year back from the current date hour local time. DATE No
Previous Week The date for the start of the week one week back from the start of the week that contains the current date hour local time. DATE No
Previous Week of Month The date for the start of the week whose number in the previous month corresponds to the week number in the current month of the current date hour local time. DATE No
Previous Week of Quarter The date for the start of the week whose number in the previous quarter corresponds to the week number in the current quarter of the current date hour local time. DATE No
Previous Week of Year The date for the start of the week whose number in the previous year corresponds to the week number in the current year of the current date hour local time. DATE No
Previous Month The start of the month one month before the month of the current date hour local time. DATE No
Previous Month of Quarter The start of the month three months before the month of the current date hour local time. DATE No
Previous Month of Year The start of the month twelve months before the month of the current date hour local time. DATE No
Previous Quarter The start of the quarter three months before the quarter of the current date hour local time. DATE No
Previous Quarter of Year The start of the quarter twelve months before the quarter of the current date hour local time. DATE No
Previous Year The start of the year one year before the year of the current date hour local time. DATE No
Second Previous Day The date for the start of the second previous day for the start of the day that contains the current date hour local time. DATE No
Second Previous Day of Week The date for the start of the day two weeks back from the current date hour local time. DATE No
Second Previous Day of Month The date for the start of the day two months back from the current date hour local time. DATE No
Second Previous Day of Quarter The date for the start of the day two quarters back from the current date hour local time. DATE No
Second Previous Day of Year The date for the start of the day two years back from the current date hour local time. DATE No
Second Previous Week The date for the start of the week two weeks back from the start of the week that contains the current date hour local time. DATE No
Second Previous Week of Month The date for the start of the week whose number in the second previous month corresponds to the week number in the current month of the current date hour local time. DATE No
Second Previous Week of Quarter The date for the start of the week whose number in the second previous quarter corresponds to the week number in the current quarter of the current date hour local time. DATE No
Second Previous Week of Year The date for the start of the week whose number in the second previous year corresponds to the week number in the current year of the current date hour local time. DATE No
Second Previous Month The start of the month two months before the month of the current date hour local time. DATE No
Second Previous Month of Quarter The start of the month six months before the month of the current date hour local time. DATE No
Second Previous Month of Year The start of the month 24 months before the month of the current date hour local time. DATE No
Second Previous Quarter The start of the quarter six months before the quarter of the current date hour local time. DATE No
Second Previous Quarter of Year The start of the quarter 24 months before the quarter of the current date hour local time. DATE No
Second Previous Year The start of the year two years before the year of the current date hour local time. DATE No