Calendar
Provides campaign calendar details, including scheduled activities and timing data.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM CampaignAnalysis.Calendar;
Columns
| Name | Type | References | SupportedOperators | Description |
| dateHour [KEY] | Datetime | =,<>,>,<,>=,<=,IN,NOT IN | Exact date and hour used as the base time unit for reporting. | |
| calendarDayId | Datetime | Unique identifier for the calendar day, represented as a date value. | ||
| calendarMonth | Int | Numeric value of the calendar month, ranging from 1 to 12. | ||
| calendarMonthDesc | String | Text description of the month, such as January or February. | ||
| calendarMonthId | Int | Unique identifier assigned to the month within the calendar dimension. | ||
| calendarQtr | Int | Numeric value of the calendar quarter, ranging from 1 to 4. | ||
| calendarQtrDesc | String | Text description of the calendar quarter, such as Q1 or Q2. | ||
| calendarQtrId | Int | Unique identifier assigned to the quarter within the calendar dimension. | ||
| calendarWeek | Int | Numeric value of the calendar week within the year. | ||
| calendarWeekDesc | String | Text description of the calendar week, often including start and end dates. | ||
| calendarWeekId | Int | Unique identifier assigned to the week within the calendar dimension. | ||
| calendarYear | Int | Numeric value representing the calendar year. | ||
| calendarYearDesc | String | Text description of the year, often displayed in YYYY format. | ||
| dayOfMonthNum | Int | Numeric value representing the day of the month, ranging from 1 to 31. | ||
| dayOfWeekDesc | String | Text description of the day of the week, such as Monday or Tuesday. | ||
| dayOfWeekNum | Int | Numeric value representing the day of the week, ranging from 1 to 7. | ||
| dayOfYearNum | Int | Numeric value representing the day of the year, ranging from 1 to 365 (or 366 for leap years). | ||
| displayDayOfWeek | String | Display-friendly version of the day of the week, often abbreviated (Mon, Tue, etc.). | ||
| hourOfDayNum | Int | Numeric value representing the hour of the day, ranging from 0 to 23. |