Calendar
Displays calendar data for scheduled landing page activities.
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 LandingPageAnalysis.Calendar;
Columns
| Name | Type | References | SupportedOperators | Description |
| dateHour [KEY] | Datetime | =,<>,>,<,>=,<=,IN,NOT IN | Exact date and hour value used as the base time unit for Eloqua reporting. | |
| calendarDayId | Datetime | Unique identifier for the calendar day, stored as a date value. | ||
| calendarMonth | Int | Numeric value of the calendar month (1–12). | ||
| calendarMonthDesc | String | Full name 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 (1–4). | ||
| calendarQtrDesc | String | Text description of the 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 year (in YYYY format). | ||
| calendarYearDesc | String | Text description of the year, typically displayed as YYYY. | ||
| dayOfMonthNum | Int | Numeric value representing the day of the month (1–31). | ||
| dayOfWeekDesc | String | Full name of the day of the week, such as Monday or Tuesday. | ||
| dayOfWeekNum | Int | Numeric value representing the day of the week (1–7). | ||
| dayOfYearNum | Int | Numeric value representing the day of the year (1–365, or 366 for leap years). | ||
| displayDayOfWeek | String | Abbreviated or display-friendly version of the weekday (Mon, Tue, etc.). | ||
| hourOfDayNum | Int | Numeric value representing the hour of the day (0–23). |