dBookedResources (new 2014-02-26)

Based on (table.column) Type Column alias Localised english name Comment
appointment_id E appointment_id appointment_id May be used for filtering by column filter. Not for display.
mother_id E mother_id mother_id May be used for filtering by column filter. Not for display.
activeDate E Date Date The date the meeting is scheduled to start
activeDate   Starts Starts Time the meeting starts (hh:mm)
activeDate E Ends Person Name (Last,First) Time th meeting ends (hh:mm)
appointment.text_id -> text.text E Topic Topic Topic for the meeting.
person.lastname,
person.firstname,
person.middleName
C Owner Owner Name of the person that called the meeting
person.lastname,
person.firstname,
person.middleName
C
Participants
Participants
Comma separated list of the names of the participants
appointment_id, mother_id C
Resource
Resource
The resource that was reserved for this meeting. Usually this will be a meeting room.
appointment_id, mother_id C Nr. of participants Nr. of participants An integer holding the number of participants (including the person that called the meeting).
appointment_id, mother_id, associate_id C
ResourceId
ResourceId
Associate_id of the resource that has been reserved for this meeting.
activeDate C
Status
Status

activeDate is compared to time of day and a message is output on that basis. Possible values:

-Upcoming
-Started
-Completed