Skip to main content
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 NameData TypeDescription
SubjectStringTitle of the event.
BodyStringDescription of the event (Optionally included).
UniqueBodyStringShows the body part that is unique to the conversation this item is part of.
ImportanceStringPriority of the event (High, Normal, Low).
StartDateStart date and time of the event.
Start_DayOfWeekIntegerNumeric representation of the start day of the week.
EndDateEnd date and time of the event.
End_DayOfWeekIntegerNumeric representation of the end day of the week.
LocationStringPhysical or virtual location where the event occurs.
DurationIntegerDuration of the event (default unit: minutes).
DurationInSecondsIntegerDuration of the event in seconds.
DurationInMinutesIntegerDuration of the event in minutes.
DurationInHoursIntegerDuration of the event in hours.
DurationInDaysIntegerDuration of the event in days.
MinutesLeftBeforeStartIntegerNumber of minutes left before the event starts.
MinutesLeftBeforeEndIntegerNumber of minutes left before the event ends.
OrganizerStringName of the person who organized the event.
IsAllDayEventBooleanIndicates if the event lasts the entire day (True/False).
IsAssociatedBooleanIndicates if the event is associated with another item (True/False).
IsMeetingBooleanIndicates if the event is a meeting (True/False).
IsOnlineMeetingBooleanIndicates if the event is an online meeting (True/False).
IsRecurringBooleanIndicates if the event is a recurring event (True/False).
RecurrentStartDateDateStart date of the recurring event series.
RecurrentEndDateDateEnd date of the recurring event series.
IsReminderSetBooleanIndicates if a reminder is set for this event (True/False).
NetShowUrlStringURL of the Microsoft NetShow online meeting.
OriginalStartDateThe original start date before any changes were made.
DateTimeCreatedDateThe date and time the event was created.
DateTimeSentDateThe date and time the event invitation was sent.
DateTimeReceivedDateThe date and time the event invitation was received.
AppointmentTypeStringType of appointment (Single, RecurringMaster, Occurrence, Exception).
HasAttachmentsBooleanIndicates if the event has attachments (True/False).
SensitivityStringVisibility of the event (Normal, Personal, Private, Confidential).
StatusStringLegacy Free/Busy status of the event.
CategoriesStringCategories associated with this event.
IsUnmodifiedBooleanIndicates if the event has been modified after creation (True/False).
LastModifiedTimeDateThe date and time the event was last modified.
LastModifiedNameStringThe name of the person who last modified the event.
RequiredAttendeesStringList of mandatory attendees.
OptionalAttendeesStringList of optional attendees.
ResourcesStringList 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.