...
Report Elements Glossary Table
...
Report : Intelligent Communication |
|---|
Tab 1: Intelligent Communication
...
The table below lists all the elements used in the Reports.
| 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 number of appointments per day set by department/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
| Calculated | Total number of future appointments | Daily | ||||||
Average Future Appointments
| Calculated | Average | Daily | ||||||
Future Daily Appointment Capacity
| Calculated | Operating Capacity(Future) | Daily | ||||||
Appointments by Day of Week
| Calculated | Number of appointments per day | Daily | ||||||
Appointments by Hour
| Calculated appiandb.AS_appointment ->startDateTime | Number of appointments every hour of the day | Daily | ||||||
Total Appointments
| Calculated | Total appoinmtments (Historic) | Daily | ||||||
Average Appointments
| Calculated | Average appointments/day (Historic) | Daily | ||||||
Daily Appointment Capacity All
| Calculated | Operating Capacity(historically) | Daily | ||||||
Contact Method
| appiandb.AS_appointment ->formatRefId in (2,3,4,5) | Method used to set up the appointment | Daily | ||||||
Appointment Status
| appiandb.AS_appointment ->statusId in (18,19,25,26,28,29) | Status of the appointment | Daily | ||||||
Appointments by Outcome
| appiandb.AS_appointment ->outcomeRefId in (20,21,22,23,24) | Outcomes of appointments | Daily | ||||||
Advisor Appointments
| appiandb.AS_appointment ->appointmentid Calculated | Number of appts for selected advisor in comparison to avg of all advisors appointments | Daily | ||||||
Appts for Advisor
| appiandb.AS_appointment ->appointmentid | Total number of appointments for the advisor | Daily | ||||||
| Calculated Number of Appts/Total number of Working days in the selected time period | Average number of appointments for the advisor per working day in the selected time period | Daily | ||||||
Daily Appointment Capacity
| Calculated | Operating Capacity of | |||||||
| selected filters | Daily | ||||||||
All Appointments
| appiandb.AS_appointment ->appointmentid | Total number of appointments for all advisors | Daily | ||||||
Average Appointments
| Calculated | Average number of appointments for all advisors per working day in the selected time period | 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
| [SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME | Name of advisor | Daily | ||||||
Number of Appts
| appiandb.AS_appointment ->appointmentid | Number of appointments for the advisor | Daily | ||||||
Working days
| 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 |
...