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 |
