Intelligent Communication Reports
...
The report on this tab lists all students in a table format with the Report Elements shown below. You can change the results by selecting filters in the Filter Panel, and you can sort by selecting a column label in the Header row of the table.
Filters
Campus
Appointments Outcome
...
| 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 | Capacity for the number of appointments targeted per day, established by department and college. | Daily | ||||||
Advisor Name
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | ||||||
Future Total Appointments
| Calculated | Number of future appointments by day. | Daily | Total Future Appointments | |||||
| Calculated | Total number of | |||||||
| appointments (Historic). | Daily | ||||||||
Average | |||||||||
Appointments
| |||||||||
| |||||||||
| Calculated | Average | |||||||
| number of | |||||||||
| appointments per day (Historic). | Daily | ||||||||
| Anchor | Contact Method | Contact Method | appiandb.AS_appointment -|||||||
Future Daily Appointment Capacity Contact Method
| Calculated | Operating Capacity (Future) | Daily | ||||||
| Anchor | Future Daily Appointment Capacity | Future Daily Appointment Capacity | Calculated | Calculated number of appointments by day of the week. | Daily | Appointments by Hour||||
| Anchor | Appointments by Hour | Appointments by Hour | Calculated appiandb.AS_appointment ->startDateTime | Calculated number of appointments by hour of the day | Daily | Total Appointments||||
| Anchor | Appointments by Hour | Appointments by Hour | Calculated | Total number of appointments (Historic). | Daily | Average Appointments||||
| Anchor | Average Appointments | Average Appointments | Calculated | Average number of appointments per day (Historic). | Daily | Daily Appointment Capacity All||||
| Anchor | Daily Appointment Capacity All | Daily Appointment Capacity All | Calculated | Operating Capacity (historically) | Daily | ||||
| appiandb.AS_appointment ->formatRefId in (2,3,4,5) | 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) | 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 | ||||||
| Anchor | |||||||||
| Appointments by Outcome | appiandb.AS_appointment ->outcomeRefId in (20,21,22,23,24) | The outcome of the appointment. | Daily | ||||||
Advisor Appointments
| appiandb.AS_appointment ->appointmentid Calculated | The number of appointments for the selected advisor compared to the average of all advisor appointments. | Daily | ||||||
Appts for Advisor
| appiandb.AS_appointment ->appointmentid | 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 | The average number of appointments for the advisor per working day in the selected time period. | Daily | ||||||
Daily Appointment Capacity
| Calculated | Operating capacity of the selected filters. | Daily | ||||||
| Anchor | Average Appointments | Average Appointments | Calculated | The average||||||
All Appointments
| appiandb.AS_appointment -> | The total number of appointments for all advisors. | Daily | ||||||
| appointmentid | The total number of appointments for all advisors | ||||||||
| . | Daily | ||||||||
Daily Appointment Capacity All
| Calculated | Operating 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 | ||||||
| Advisor Name | Advisor Name||||||||
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | |||||||
| Anchor | |||||||||
| 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 | ||||||||
| The average number of appointments for all advisors per working | |||||||||
| day in the selected time period | Daily |
...