Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
Report Elements Glossary
Report Elements Glossary

Report Elements Glossary Table

 

The table below lists all the elements used in the Advisor Reportsin the Intelligent Communication reports.

Note: To sort the table elements, click the up or down arrow in the column header


Element

Source

(System->Table->Column)

DescriptionFrequency of Update

College

Anchor
College
College

appiandb.AS_unitBookingTreeLogic->levelOneDescCollege served by advisor.Daily

Department

Anchor
Department
Department

appiandb.AS_unitBookingTreeLogic->levelTwoDescDepartment served by advisor.Daily

Select Date

Anchor
Select Date
Select Date

appiandb.AS_appointment->startDateTime 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

Future Appointments

Anchor
Future Appointments
Future Appointments

CalculatedNumber of future appointments by day.Daily

Total Future Appointments The o

CalculatedTotal number of future appointments.Daily

Average Future Appointments

Anchor
Average Future Appointments
Average Future Appointments

CalculatedAverage of the number of future appointments.Daily

Future Daily Appointment Capacity

Anchor
Future Daily Appointment Capacity
Future Daily Appointment Capacity

CalculatedOperating Capacity (Future)Daily

Appointments by Day of Week

Anchor
Future Daily Appointment Capacity
Future Daily Appointment Capacity

CalculatedCalculated 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 dayDaily

Total Appointments

Anchor
Appointments by Hour
Appointments by Hour

CalculatedTotal number of appointments (Historic).Daily

Average Appointments

Anchor
Average Appointments
Average Appointments

CalculatedAverage number of appointments per day (Historic).Daily

Daily Appointment Capacity All

Anchor
Daily Appointment Capacity All
Daily Appointment Capacity All

CalculatedOperating Capacity (historically)Daily

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

Appointment Status

Anchor
Appointment Status
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

Appointments by Outcome

Anchor
Appointments by Outcome
Appointments by Outcome

appiandb.AS_appointment ->outcomeRefId in (20,21,22,23,24)The outcome of the appointment.Daily

Advisor Appointments

Anchor
Advisor Appointments
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

Anchor
Appts for Advisor
Appts for Advisor

appiandb.AS_appointment ->appointmentidThe total number of appointments for the advisor. When an advisor is not selected, this value is null.Daily

Anchor
Avg Appts for Advisor
Avg Appts for Advisor
Avg Appts for Advisor

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

Anchor
Daily Appointment Capacity
Daily Appointment Capacity

CalculatedOperating capacity of the selected filters.Daily

All Appointments

Anchor
All Appointments
All Appointments

appiandb.AS_appointment ->appointmentidThe total number of appointments for all advisors.Daily

Average Appointments

Anchor
Average Appointments
Average Appointments

CalculatedThe average number of appointments for all advisors per working day in the selected time periodDaily

Daily Appointment Capacity All

Anchor
Daily Appointment Capacity All
Daily Appointment Capacity All

CalculatedOperating capacity of all advisors.Daily

Appointment Status

Anchor
Appointment Status
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

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
Advisor Name
Advisor Name
Advisor Name

[SID].[dbo].[FIF_SGRADVR] →Adviser_LAST_NAME, Adviser_FIRST_NAME Name of advisor.Daily

Anchor
Number of Appts
Number of Appts
Number of Appts

appiandb.AS_appointment ->appointmentidNumber of appointments for the advisor.Daily

Anchor
Working days
Working days
Working days

appiandb.AS_appointment ->startDateTimeNumber of days advisor had appointments.Daily

Average Appointments

Anchor
Average Appointments
Average Appointments
Number of Appts/Total number of Working days in the selected time periodAverage appointments per working day for the advisor.Daily

...