...
Report : Intelligent Communication |
---|
Tab 1: Intelligent Communication |
---|
This report provides a summary view of the appointments of all advisors in the department/college and can be filtered.
...
Tab |
---|
...
1: Advisors |
---|
This report provides the ability to compare one advisor's appointment activity against others in the department/college
...
Element | Source (System->Table->Column) | Description | Frequency of Update | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
College
| appiandb.AS_unitBookingTreeLogic->levelOneDesc | College served by advisor. | Daily | ||||||||
Department | appiandb.AS_unitBookingTreeLogic->levelTwoDesc | Department served by advisor. | Daily | ||||||||
Select Date
| appiandb.AS_appointment->startDate | Time range of appointments. | Daily | ||||||||
Daily Appointment Capacity
| Calculated Upper limit is hard coded to 200 | Target/capacity of Capacity for the number of appointments targeted per day set , established by department /and college. | Daily | ||||||||
Advisor Name
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | ||||||||
Future Appointments
| Calculated | Number of future appointments by day. | Daily | ||||||||
Total Future Appointments Total Future Appointments | Total Future Appointments | The o | Calculated | Total number of future appointments. | Daily | ||||||
Average Future Appointments
| Calculated | Average of the number of future appointments. | Daily | ||||||||
Future Daily Appointment Capacity
| Calculated | Operating Capacity (Future) | Daily | ||||||||
Appointments by Day of Week
| Calculated | Number Calculated number of appointments per by day of the week. | Daily | ||||||||
Appointments by Hour
| Calculated appiandb.AS_appointment ->startDateTime | Number Calculated number of appointments every by hour of the day | Daily | ||||||||
Total Appointments
| Calculated | Total appoinmtments number of appointments (Historic). | Daily | ||||||||
Average Appointments
| Calculated | Average number of appointments /per day (Historic). | Daily | ||||||||
Daily Appointment Capacity All
| Calculated | Operating Capacity (historically) | Daily | ||||||||
Contact Method
| appiandb.AS_appointment ->formatRefId in (2,3,4,5) | Method The method used to set up the appointment, such as Phone or Office. | Daily | ||||||||
Appointment Status
| appiandb.AS_appointment ->statusId in (18,19,25,26,28,29) | Status The status of the appointment, such as Completed or Canceled. Two calculations display for each status: historic number of appointments for the selected advisor and the average for all advisors in the selected filter. | Daily | ||||||||
Appointments by Outcome
| appiandb.AS_appointment ->outcomeRefId in (20,21,22,23,24) | Outcomes of appointmentsThe outcome of the appointment. | Daily | ||||||||
Advisor Appointments
| appiandb.AS_appointment ->appointmentid Calculated | Number The number of appts appointments for the selected advisor in comparison compared to avg the average of all advisors advisor appointments. | Daily | ||||||||
Appts for Advisor
| appiandb.AS_appointment ->appointmentid | Total The total number of appointments for the advisor. When an advisor is not selected, this value is null. | Daily | ||||||||
| Calculated Number of Appts/Total number of Working days in the selected time period | Average The average number of appointments for the advisor per working day in the selected time period. | Daily | ||||||||
Daily Appointment Capacity
| Calculated | Operating Capacity capacity of the selected filters. | Daily | ||||||||
All Appointments
| appiandb.AS_appointment ->appointmentid | Total The total number of appointments for all advisors. | Daily | ||||||||
Average Appointments
| Calculated | Average The average number of appointments for all advisors per working day in day in the selected time period | Daily | ||||||||
Daily Appointment Capacity All
| Calculated | Operating Capacity capacity of all advisors. | Daily | ||||||||
Appointment Status
| appiandb.AS_appointment ->statusId in (18,19,25,26,28,29) | Appointment status of selected advisor in comparison to average appointment status of dept/college. Advisor: Number of appointments for the advisor for a particular appointment status Avg: Total Number of appointments for a particular appointment status/ Total number of advisors | Daily | ||||||||
Appointments by Outcome
| appiandb.AS_appointment ->outcomeRefId in (20,21,22,23,24) | Outcomes appointments of advisor in comparison to all other advisors Advisor: Number of appointments for the advisor for a particular outcome Avg: Total Number of appointments for a particular outcome/ Total number of advisors | Daily | ||||||||
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | ||||||||
| appiandb.AS_appointment ->appointmentid | Number of appointments for the advisor. | Daily | ||||||||
| appiandb.AS_appointment ->startDateTime | Number of days advisor had appointments. | Daily | ||||||||
Average Appointments
| Number of Appts/Total number of Working days in the selected time period | Average appointments per working day for the advisor. | Daily |
...