JApptAttendee contains information about the attendees in an appointment record. This information includes the user who has been added as an attendee, attendance status, and starting and ending date and time. This table represents the Attendees block on the Attendees tab of an appointment.
Object: JApptAttendee (J_APPT_ATTENDEE)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
attendanceType Before TeamConnect 3.3 SP2: attendanceTypeIID |
ATTENDANCE_TYPE_IID (NUMBER) |
Attendance (Attendees block) |
x |
|
|
int |
Indicates the attendance status of the attendee: 0 - Will Attend (WILL_ATTEND) 1 - Tentative (TENTATIVE) 2 - Will Not Attend (WILL_NOT_ATTEND) 3 - Unknown |
|
x |
endOn |
END_ON (DATE) |
End Time (Attendees block) |
x |
|
|
dateTime |
End date and time until which the user is scheduled to attend. |
|
x |
owner--> |
APPOINTMENT_ID (NUMBER) |
|
|
x |
object |
The appointment which the user is scheduled to attend. |
|
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
Unique ID given to each attendee added to an appointment record. |
|
|
startOn |
START_ON (DATE) |
Start Time (Attendees block) |
x |
|
|
dateTime |
Start date and time when the user is scheduled to attend. |
|
x |
user--> |
USER_ID (NUMBER) |
Attendee (Attendees block) |
x |
x |
object |
8 User who is added as an attendee to the appointment record. --> Links to specific information about the user account. |
x |
x |
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the appointment attendee was updated. |
|
|
