Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updated the select statement for contact method, Appt status, appt reason and appt outcome

Intelligent Communication Reports

...

This report provides a summary of academic advisor appointments. The report consists of two panels: the left panel allows you to filter the data by elements, such as appointment outcome or date range; the right panel displays the appointment data in different visual formats with charts, graphs, and tables.

Filter Panel

The left panel allows you to filter the data that displays in the data panel. Select to filter by one or more of the following options:

...

Contact Method: displays how contact is made with the student. Options include:

  • Walk-In
  • Phone
  • Office
  • Skype
  • Microsoft Teams
  • Other
  • Not Available

Appointment Outcome: displays the result of the appointment (includes "In Progress" if yet to occur. Options include:

...

Contact Method: displays how contact is made with the student. Options include:

  • Walk-inIn
  • Phone
  • Office
  • Skype
  • Microsoft Teams
  • Other
  • Not Available

Appointment Outcome: displays the result of the appointment (includes "In Progress" if yet to occur. Options include:

...

Filters

11885511520

11885511520

Appointment Major

Appointments Outcome

11885511520

...

Total Appts

11885511520

11885511520

Contact Method11885511520

Appointment Outcome

Reasons for Appointments

Student Appointment Distribution

...

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 

11885511520

11885511520

Appointment Major

...

Element

Source

(System->Table->Column)

DescriptionFrequency of Update

Advisor Appointments

Anchor
Advisor Appointments
Advisor Appointments

appiandb.AS_appointment ->appointmentid

Calculated

The number of appointments for the advisor in the selected date range.

Daily

Anchor
Advisor College
Advisor College
Advisor College

appiandb.AS_unitBookingTreeLogic->levelOneDescThe advisor's home college.Daily
Advisor Email(SID.HUB_CIMS_CURR_ID_V_Staging -> NETID) + "@usf.edu"The email address of the advisor.Daily

Advisor Name

Anchor
Advisor Name
Advisor Name

Crete.FIF_SPRIDEN_Staging -> SPRIDEN_LAST_NAME] + Crete.FIF_SPRIDEN_Staging -> SPRIDEN_FIRST_NAME

The name of the advisor.Daily

Advisor UID

Anchor
Advisor UID
Advisor UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 17The advisor's university identification number.Daily

Appointment Outcome

Anchor
Appointments by Outcome
Appointments by Outcome

appiandb.AS_reference  -> displayValue in

 (20,21,22,23,24Select DISTINCT outcomeRefId)

The result of the advisor appointment. Available values for this field are:

  • Attended
  • No Show
  • SSP Canceled
  • Student Canceled – Fault
  • Student Canceled – No fault
  • Walk-In
Daily

Appointment Reason OR Drop In Reason

Anchor
Appointment Reason
Appointment Reason

appiandb.AS_reference -> displayValue in

(6,7,8,9,10,11,12,13,14,15Select Distinct reasonRefID)

The reason the student requested the appointment. Available values for this field are:

  • Academic Dismissal/Reinstatement
  • ACR Petitions
  • Career Advising
  • Change of Major/Major Re-selection
  • Form Completion
  • General Advising
  • Holds
  • Minor & Certificates
  • Not Available
  • Pre-Orientation/Transfer Advising
  • Scheduling/Course Planning/Degree Progression
Daily

Appointment Status

Anchor
Appointment Status
Appointment Status

appiandb.AS_reference -> displayValue in (18,19,25,26,28,29Select DISTINCT statusID)

The status of the appointment. Available values for this field are:

  • Canceled
  • Completed
  • Confirmed
  • Scheduled
  • Walk-In

The Appointment Status pie chart displays numbers for each of the above appointment statuses based on the filters selected.

Daily

Appointment Type

Anchor
Appointment Type
Appointment Type

appiandb.AS_reference -> displayValue in

(typeRefId=1)
Need values (displays in table)Daily

# Appts

Anchor
Advisor Appts
Advisor Appts

Count of (appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 17The total number of appointments for this advisor.Daily

Attendee UID

Anchor
Attendee UID
Attendee UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16The appointment attendee is the student attending the appointment with the advisor.Daily

Average Wait Time

Anchor
Average Wait Time
Average Wait Time

CalculatedThe average wait time for the filtered results show in minutes. Daily

Avg Daily Appts for Advisor

Anchor
Avg Daily Appts Advisor
Avg Daily Appts Advisor

Calculated:

AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment  -> appointmentId)) per day
The average number of appointments for all advisors per advisor working day in the selected time period.Daily

Avg Daily Appts for College

Anchor
Avg Daily Appts College
Avg Daily Appts College

Calculated:
AVERAGE(DISTINCTCOUNT (appiandb.AS_appointment  -> appointmentId)) per College per day

The average number of appointments for advisors within the college. The calculation averages the number of appointments per advisor divided by that advisor's number of working days.Daily

Campus

Anchor
Campus
Campus

SID.IC_StudentList_Vw -> CampusTitle

The student's or advisor's home campus.Daily

Capacity

Anchor
Capacity
Capacity

CalculatedCalculated as a percentage, this value represents the average number of appointments divided by the selected Daily Appointment Capacity target. The Daily Appointment Capacity is set by the user with a maximum of 200.Daily

College

Anchor
College
College

SID. IC_StudentList_Vw -> CollegeTitleThe student's home college.Daily

Contact Method

Anchor
Contact Method
Contact Method

appiandb.AS_appointment ->formatRefId in (2,3,4,5select DISTINCT formatRefId)The method used to set up the appointment, such as Phone or Office.Daily

Count of Appts

Anchor
Count of Appts
Count of Appts

Calculated: DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 16The number of appointment records for this student. This includes all appointment statuses: Confirmed, Scheduled, Walk-In, Completed, and Canceled.Daily

Currently Enrolled Students With No Appointments (count)

Anchor
Currently Enrolled
Currently Enrolled

count(SID. IC_StudentList_Vw->UID ) + Count(appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16) where Adviser College != Student collegeThe number of students who are currently enrolled who do not have a record of an advisor appointment.Daily

Daily Appointment Capacity

Anchor
Daily Appointment Capacity
Daily Appointment Capacity

Calculated

The targeted capacity for the number of appointments an advisor holds per day, established by the department and college.

The default appointment capacity is set to 100 and can be adjusted by using the slider or by typing in a different value in the field. An upper limit of 200 is hard-coded.

Daily

Date

Anchor
Date
Date

Data Refreshed on this dateThe date on which data has been loaded.Daily

Date Recent Appt

Anchor
Date Recent
Date Recent

appiandb.AS_appointment -> startDateThis date represents the most recent appointment recorded for the student.Daily

Department

Anchor
Department
Department

appiandb.AS_unitBookingTreeLogic->levelTwoDesc

SID. IC_StudentList_Vw -> DepartmentTitle

Department to which the student or advisor belongs.Daily

Drop-In

Anchor
Drop In
Drop In

appiandb.AS_v_dropInQueueDetails -> Drop_InThe date and time the student entered the queue.Daily

FIF Cohort

Anchor
FIF Cohort
FIF Cohort

Crete.IC_StudentList_Vw.FIFCohort ->The Finish in Four (FIF) cohort to which the student belongs.Daily

First Name

Anchor
First Name
First Name

SID.IC_StudentList_VwNAME_FIRSTThe first name of the student.Daily

Full Name

Anchor
Full Name
Full Name

SID.IC_StudentList_Vw.NAME_LAST + SID.IC_StudentList_VwNAME_FIRSTThe full name (first name, last name) of the student.Daily

Last Name

Anchor
Last Name
Last Name

SID.IC_StudentList_Vw.NAME_LASTThe last name of the student.Daily

Major 1

Anchor
Major1
Major1

SID.IC_StudentList_Vw -> MAJORTITLEThe student's major or primary major if double-majoring.Daily

Major 2

Anchor
Major2
Major2

SID.IC_StudentList_Vw -> MAJOR2The student's second major, if any.Daily

Queue Name

Anchor
Queue Name
Queue Name

appiandb.AS_v_dropInQueueDetails -> queue_nameThe name of the queue the student chose for his or her advisor drop-in appointment.Daily

Pick Up

Anchor
Pick Up
Pick Up

appiandb.AS_v_dropInQueueDetails -> Pick upThe date and time the advisor made the connection with the student for the appointment.Daily

Relative Date Options

Anchor
Relative Date
Relative Date

appiandb.AS_appointment->startDateOptional method for selecting date ranges in the report. This filter lets you select relative dates, such as Next 2 Months, or Last 1 Year. The filter has three select fields:
  • Relative: Last, This, Next
  • Value: 1, 2, and so on
  • Calendar measurement: Days, Weeks, Months, Years

Select Date

Anchor
Select Date
Select Date

appiandb.AS_appointment->startDate

The date range of appointments, used to filter the number of appointments to display in the data panel.

Daily

SRKALL Cohort

Anchor
SRKALL Cohort
SRKALL Cohort

SID. IC_StudentList_Vw -> SRKALLCohortThe SRKALL cohort to which a student belongs.Daily

Student Appointments # Distribution

Anchor
Student Appt Distribution
Student Appt Distribution

DISTINCTCOUNT(IC[appointmentId])

The distribution of advisor appointments across colleges.Daily

Student College

Anchor
Student College
Student College

appiandb.AS_v_dropInQueueDetails -> collegedescThe student's home collegeDaily

Student Email

Anchor
Student Email
Student Email

SID. IC_StudentList_Vw -> GOREMAL_EMAIL_ADDRESSThe student's email address.Daily

Student Phone #

Anchor
Student Phone
Student Phone

appiandb.AS_v_dropInQueueDetails -> phoneNumberThe student's phone numberDaily

Student UID

Anchor
Student UID
Student UID

appiandb.AS_attendee  -> attendeeUId where attendeeTypeRefId = 16The student's university identification number.Daily

Students in Queue

Anchor
Students in Queue
Students in Queue

CalculatedIndicates the number of students who selected a queue to receive a connection with an advisor via Teams or phone.Daily

Students Left Queue

Anchor
Students left Queue
Students left Queue

CalculatedIndicates the number of students who removed themselves from the queue and did not wait for a connection with the advisor.Daily

Total Appts

Anchor
Total Appts Advisor
Total Appts Advisor

Calculated: DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) where attendeeTypeRefId = 17

The total number of advisor appointments for the selected date range. When selecting more than one advisor on the Supervisor Summary report, this represents a sum of the selected advisors' appointments.Daily

Total Appts for College

Anchor
Total Appts College
Total Appts College

Calculated:
DISTINCTCOUNT(appiandb.AS_appointment  -> appointmentId) per College

The total number of appointments for all advisors in the selected college.Daily

Wait Time

Anchor
Wait Time
Wait Time

CalculatedThe number of minutes between the time the student entered the queue to the time the advisor made the connection for the appointment.Daily

# Working Days

Anchor
Working days
Working days

appiandb.AS_appointment ->startDateTimeNumber of days the advisor held advisor appointments.Daily

...