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 Advisor Appointments
| appiandb.AS_ unitBookingTreeLogicappointment - >levelOneDesc | College served by advisor>appointmentid Calculated | The number of appointments for the selected advisor compared to the average of all advisor appointments. | Daily | |||||||||
Department Advisor Name
Department | | appiandb.AS_unitBookingTreeLogic->levelTwoDesc | Department served by
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | |||||||
| Select Date Advisor UID | |||||||||||||
Appointment Outcome
| Select Date | ||||||||||||
| appiandb.AS_ | Time range of appointments. | Daily | Daily Appointment Capacity||||||||||
| Anchor | Daily Appointment Capacity | 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||||||||
| Anchor | Advisor Name | Advisor Name | [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor. | Daily | Total Appointments||||||||
| Anchor | Appointments by Hour | Appointments by Hour | Calculated | Total number of appointments. | Daily | Total Appts for College | Average Appointments|||||||
| Anchor | Average Appointments | Average Appointments | Calculated | Average number of appointments per day (Historic). | Daily | FIF Cohort | SRKALL Cohort | Contact Method||||||
| Anchor | Contact Method | Contact Method | appiandb.AS_appointment ->formatRefId in (2,3,4,5) | The method used to set up the appointment, such as Phone or Office. | Daily | Advisor Appointments||||||||
| Anchor | Advisor Appointments | Advisor Appointments | appiandb.AS_appointment ->appointmentid Calculated | The ||||||||||
| 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 | |||||||||||
| Appointment Reason | |||||||||||||
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 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 | ||||||||||||
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 | ||||||||||||
Average Appointments
| Calculated | Average number of appointments per day. | Daily | ||||||||||
Average Appointments
| Avg Appts for Advisor | Avg Appts for Advisor | |||||||||||
| 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 | |||||||||||||
Avg Daily Appts for | |||||||||||||
Advisor
| Daily Appointment Capacity | Daily Appointment Capacity | Calculated | Operating capacity of the selected filters. | Daily | Capacity | |||||||
| Anchor | All Appointments | All Appointments||||||||||||
| 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 | ||||||||||
| Avg Daily Appts for College | |||||||||||||
| Campus | |||||||||||||
| Capacity | |||||||||||||
College
| appiandb.AS_ | ||||||||||||
| unitBookingTreeLogic- | The total number of appointments for all advisors. | Daily | Appointment Reason | Daily Appointment Capacity All ||||||||||
| Anchor | Daily Appointment Capacity All | Daily Appointment Capacity All | Calculated | Operating capacity of all advisors||||||||||
| >levelOneDesc | College served by advisor. | Daily | |||||||||||
Contact Method
| Appointment Status | ||||||||||||
| appiandb.AS_appointment - | ||||||||||||
| >formatRefId in (2,3,4,5) | The method used to set up the appointment, such as | ||||||||||||
| Phone or | Daily | Appointment Outcome||||||||||||
| Anchor | Appointments by Outcome | 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 | ||||||||
| Anchor | Number of Appts | ||||||||||||
| Office. | Daily | ||||||||||||
| Count of Appts | |||||||||||||
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. Operating capacity of all advisors. | Daily | ||||||||||
Daily Appointment Capacity All
| Calculated | ||||||||||||
| Date Recent Appt | |||||||||||||
Department | appiandb.AS_unitBookingTreeLogic->levelTwoDesc | Department served by advisor. | Daily | ||||||||||
| FIF Cohort | |||||||||||||
| Full Name | |||||||||||||
| Major | |||||||||||||
Number of Appts
| appiandb.AS_appointment - | ||||||||||||
| >appointmentid | Number of appointments for the advisor. | Daily | Working days | Working days||||||||||
Select Date
| Working days | ||||||||||||
| appiandb.AS_ | ||||||||||||
| appointment- | |||||||||||||
| >startDate | |||||||||||||
| Time range of | |||||||||||||
| appointments. | Daily | Average||||||||||||
SRKALL Cohort | |||||||||||||
| Student Appointment Distribution | |||||||||||||
Student UID | |||||||||||||
Total Appointments
| |||||||||||||
| |||||||||||||
| Number of Appts/Total number of Working days in the selected time period | The average||||||||||||
| Calculated | Total number of appointments. | Daily | ||||||||||
| Total Appts for College | |||||||||||||
Total Appts for College
| appiandb.AS_appointment ->appointmentid | The total number of appointments for all advisors | |||||||||||
| . | Daily | Student UID | Count of Appts | Date Recent Appt | Campus | Major | Full Name | Student Appointment Distribution | Advisor UID | #Working Days||||
# Working Days
| appiandb.AS_appointment ->startDateTime | Number of days advisor had appointments. | Daily |
...