| View Name: | employee_appt |
| View Number: | 395 |
| Group: | Resource Mgr |
| Description: | Gets appointments for employees |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| employee_objid | employee | objid | Internal record number | |
| appt_objid | appointment | objid | Internal record number | 3 (UNIQUE) |
| start_time | appointment | start_time | Appointment start time | 29 |
| end_time | appointment | end_time | Appointment end time | 30 |
| duration | appointment | duration | Length of the appointment in seconds | 6 |
| cell_text | appointment | cell_text | Contains a concatination of locally-selected fields for display by Schedule Tracker. Default is appointment sub_type with start time and end time |
| Join From | Join To |
|---|---|
| (schedule).schedule2employee | (employee).employee2schedule |
| (appointment).appt2schedule | (schedule).schedule2appt |
| employee_appt | |||