> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pads4.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting a Microsoft Exchange Server Calendar Table

The **Calendar table** in Microsoft Exchange Server contains detailed information about **scheduled events, meetings, and appointments**. Below is a breakdown of the table's **columns and data types**.

***

### **Calendar Table Columns and Descriptions**

| **Column Name**            | **Data Type** | **Description**                                                              |
| -------------------------- | ------------- | ---------------------------------------------------------------------------- |
| **Subject**                | String        | Title of the event.                                                          |
| **Body**                   | String        | Description of the event (*Optionally included*).                            |
| **UniqueBody**             | String        | Shows the body part that is unique to the conversation this item is part of. |
| **Importance**             | String        | Priority of the event (**High, Normal, Low**).                               |
| **Start**                  | Date          | Start date and time of the event.                                            |
| **Start\_DayOfWeek**       | Integer       | Numeric representation of the start day of the week.                         |
| **End**                    | Date          | End date and time of the event.                                              |
| **End\_DayOfWeek**         | Integer       | Numeric representation of the end day of the week.                           |
| **Location**               | String        | Physical or virtual location where the event occurs.                         |
| **Duration**               | Integer       | Duration of the event (default unit: minutes).                               |
| **DurationInSeconds**      | Integer       | Duration of the event in seconds.                                            |
| **DurationInMinutes**      | Integer       | Duration of the event in minutes.                                            |
| **DurationInHours**        | Integer       | Duration of the event in hours.                                              |
| **DurationInDays**         | Integer       | Duration of the event in days.                                               |
| **MinutesLeftBeforeStart** | Integer       | Number of minutes left before the event starts.                              |
| **MinutesLeftBeforeEnd**   | Integer       | Number of minutes left before the event ends.                                |
| **Organizer**              | String        | Name of the person who organized the event.                                  |
| **IsAllDayEvent**          | Boolean       | Indicates if the event lasts the entire day (**True/False**).                |
| **IsAssociated**           | Boolean       | Indicates if the event is associated with another item (**True/False**).     |
| **IsMeeting**              | Boolean       | Indicates if the event is a meeting (**True/False**).                        |
| **IsOnlineMeeting**        | Boolean       | Indicates if the event is an online meeting (**True/False**).                |
| **IsRecurring**            | Boolean       | Indicates if the event is a recurring event (**True/False**).                |
| **RecurrentStartDate**     | Date          | Start date of the **recurring event series**.                                |
| **RecurrentEndDate**       | Date          | End date of the **recurring event series**.                                  |
| **IsReminderSet**          | Boolean       | Indicates if a reminder is set for this event (**True/False**).              |
| **NetShowUrl**             | String        | URL of the **Microsoft NetShow** online meeting.                             |
| **OriginalStart**          | Date          | The original start date before any changes were made.                        |
| **DateTimeCreated**        | Date          | The date and time the event was created.                                     |
| **DateTimeSent**           | Date          | The date and time the event invitation was sent.                             |
| **DateTimeReceived**       | Date          | The date and time the event invitation was received.                         |
| **AppointmentType**        | String        | Type of appointment (**Single, RecurringMaster, Occurrence, Exception**).    |
| **HasAttachments**         | Boolean       | Indicates if the event has attachments (**True/False**).                     |
| **Sensitivity**            | String        | Visibility of the event (**Normal, Personal, Private, Confidential**).       |
| **Status**                 | String        | **Legacy Free/Busy status** of the event.                                    |
| **Categories**             | String        | Categories associated with this event.                                       |
| **IsUnmodified**           | Boolean       | Indicates if the event has been modified after creation (**True/False**).    |
| **LastModifiedTime**       | Date          | The date and time the event was last modified.                               |
| **LastModifiedName**       | String        | The name of the person who last modified the event.                          |
| **RequiredAttendees**      | String        | List of **mandatory** attendees.                                             |
| **OptionalAttendees**      | String        | List of **optional** attendees.                                              |
| **Resources**              | String        | List of **resources** (rooms, equipment) booked for this meeting.            |

***

### **Notes:**

* This table structure is used in **PADS4** when retrieving calendar data from **Microsoft Exchange Server**.
* Some fields (like **Body, UniqueBody**) may be **optional** depending on your Exchange settings.
* **Recurring events** have additional properties like **RecurrentStartDate, RecurrentEndDate**.
* **Online meetings** have specific attributes like **IsOnlineMeeting and NetShowUrl**.