Reports - Rostered Participants

This report is intended for branches and organizations, it allows you to generate the list of members that are rostered to a team.

Filter Options

Using the filter options allows you to narrow your search results. By leaving a filter blank, your report will include all options in that field.

Fields marked with an * are mandatory

* Organization: You can use the drop down or the tree to select an organization. (Selecting another MHA is permission based).

* Period: By default it will be set to the current season. Use the drop down to select a different season if needed.

* Division: Use the drop down to select all, or target the divisions you want to report on.

Team Category: You can filter by the team category.

With Registration: You can use the drop down to filter by all the options, yes with registration or no registrations.

Gender Identity: Use drop down to filter by male, female, prefer to to say or prefer to self describe.

Position Group: You can use the drop down to filter by player, coach or staff.

Position: Use the drop down to filter by positions the members have on a team.

Team Member Status: You can filter by all status, or select from the list.

Date of Birth - Start & End: You can use the birth date range to narrow your search.

 

Action Button

  • New custom report - You can create your own custom appeals report that will allow you to choose the columns that are generated.

  • Export excel - click to export your report

Custom Reports

You can create a custom report using any combination of the default columns listed below.

To create this report, click New custom report from the Action button, or the New custom report button located at the top of the search result display.

 

Give the report a name, and a description (optional but is useful if you want to save the custom report and use it again later). Click the box Save Filter Values if you want to save this custom report. Next, select all, or choose from the column options, then click Save.

 

Rostered Participants Report Default Columns

  1. HCR Number

  2. First Name

  3. Last Name

  4. Email

  5. Birthdate

  6. Gender Identity

  7. Gender Identity Description

  8. Unit Number

  9. Street Number

  10. PO box

  11. Street

  12. City

  13. Province

  14. Postal Code

  15. Jersey Number

  16. Status

  17. Status

  18. Tryout

  19. Import

  20. Overage

  21. Underage

  22. Team Number

  23. Team Name

  24. Team Sponsor

  25. Team Short Name

  26. Team Home Color

  27. Team Away Color

  28. Team Fee

  29. Team Status

  30. Team Category Name

  31. Team Gender Identity

  32. Division Name

  33. Registration's Class Name

  34. Position

  35. Position Group

  36. Team Member Status

  37. Period

  38. Organization Name

  39. Organization Path

  40. Primary Organization Name

  41. Criminal Record Check is Expired

  42. Registration Date

  43. Release Date

  44. Team (One Year Ago)

  45. Team (Two Years Ago)

  46. Parent 1 - First Name

  47. Parent 1 - Last Name

  48. Parent 1 - Email

  49. Parent 1 - Phone

  50. Parent 2 - First Name

  51. Parent 2 - Last Name

  52. Parent 2 - Email

  53. Parent 2 - Phone

  54. Primary Team Name

 

Search Results

In each of the columns, you will find a sort option with a directional arrow letting you know which way the sort is going in.

The blue arrows allow you to move from left to right when viewing the columns of your report.

Click on the Show box to change the amount of lines visible in your search results.

 

Exports

You can export your reports by clicking on the Action button and selecting Export Excel, or from the export button located at the top of the search display results. Using the export button, you can export to CSV or Excel.

A history of your exported reports can be retrieved from the Exports menu.

Tips

When using any of the filters for your search, the system will save your most recent options. to clear your search history, either click Clear, or click on Reset filters.

There will be times that your report is too large to display on the screen. A message will appear - Your report is too heavy, click here to download the complete report. Click on it, and you can view the full report from the export.

Â