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 |