Calendar
Lists calendar details related to form submission campaigns.
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 FormSubmission.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 reporting. | |
| calendarDayId | Datetime | Unique identifier for the calendar day, represented 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 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 week within the calendar year. | ||
| calendarWeekDesc | String | Text description of the calendar week, often showing start and end dates. | ||
| calendarWeekId | Int | Unique identifier assigned to the week within the calendar dimension. | ||
| calendarYear | Int | Numeric value representing the calendar year (YYYY). | ||
| calendarYearDesc | String | Text description of the year, often displayed in YYYY format. | ||
| 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 day of the week (Mon, Tue, etc.). | ||
| hourOfDayNum | Int | Numeric value representing the hour of the day (0–23). |