Report - Semester Comparison

Introduction

This will display a list of all semesters run for a student in a course. This can be filtered using clubs and/or activity categories within a date range.

Before you start 

To access this report, please add the following employee permissions to the suitable employee roles in PGM -> Clubs -> Employee permissions.

• Reports
  • Courses
    • Semester Comparison

Instruction / Feature description

To access the report, go to PGM -> Reports -> All.

You can use the search filter and find Semester Comparison or select Courses tab and find the report.

In the report filters, the below filters are present.

• Clubs - Select which club this report will generate. If left blank this will generate a report for all clubs your employee profile can view.
• Activity Categories - Select which category to be viewed in the report. If left blank this will generate a report for all activity categories
• From / To - Select a date range to show the semesters within the date range.
• Use Parent Agreement - The report will display the club member user agreements, by selected this option this will replace with the parents user agreement if the club member has a parent profile attached.

Report Extract

The report will generate into a single tab SemesterComparison

This will display the following columns

As this report is dynamic, most column names will be based on the values of the agreements or term names.

• Club - Name of the club the group is located in.
• User number - The user number of the student.
• Full name - The full name of the student.
• ParentUserNumber - The user number of the parent.
• ParentFullName - The full name of the parent.
• Email - The email address on the parent profile, if this is blank it will use the email address of the student.
• Phone Nr Mobile - The phone number on the parent profile, if this is blank it will use the phone number of the student.
• Agreement Name - The name of the agreement and if the member has agreed to the agreement.
  • If the “Use Parent For Agreement“ is ticked, this will do the following:
    • Any agreement shown here will be the values used on the parent. If the member has no parent profile attached it will use their agreements.
    • The name used in the title of the report extract will display “using Parent agreements“
    • 
  • If the “Use Parent For Agreement“ is NOT ticked, this will do the following:
    • Any agreement shown here will be the values used on the student.
    • The name used in the title of the report extract will display “using Student agreements“
  • The following values are used in the agreement
    • TRUE - The club member has agreed to the agreement.
    • FALSE - The club member has not agreed to the agreement, they have either disagreed or revoked the agreement after originally agreeing to it.
    • BLANK - The club member has not agreed or disagreed to the agreement.
• Semester Name - This will show the name of the semester, the value next to this is the unique id of that semester.
  • The values used in the cells are the highest level of the group the member was in.
  • If the value DNC is shown in front of the group name, the member ended the contract before the semester end date.

Hints

• This report will only show members who were in a semester where the semester is linked to the group.