Referee Assistant--Professional Edition User Guide

Jeffrey Wigal

This document is available on the web as 1) a one page HTML document, 2) a Windows Help File, 3) a multiple-page HTML website. and 4) a Adobe Acrobat document.

"Referee Assistant," and the Referee Assistant three-square logo are copyright ©1998-2006 Jeffrey A. Wigal. Access is a trademark of the Microsoft corporation. Referee Assistant is a trademark of Jeffrey A. Wigal. Referee Assistant is not affiliated with or endorsed by the United States Soccer Federation (USSF), National Federation (NF), American Youth Soccer Organization (AYSO), or the National Interscholastic Soccer Officials Association (NISOA)

Except as otherwise indicated, you may view and print this user guide subject to the following terms and conditions: 1) The user guide may be used solely for informational, personal, non-commercial purposes; 2) Any copy of the document or portion thereof must include all copyright and proprietary notices in the same form and manner as on the original; 3) The document may not be modified in any way; 4) The owner reserves the right to revoke such authorization at any time, and any such use shall be discontinued immediately upon notice. Logos, graphics, sounds or images within the user guide may not be reproduced or distributed unless expressly permitted by the publisher.

Revision History
Revision 137August 17, 2006

Initial Draft


Table of Contents

1. Introduction
1. What is Referee Assistant?
1.1. What are the limitations of Referee Assistant
1.2. What is a relational database?
2. Versions
3. System Requirements
3.1. Minimum System Requirements
3.2. Recommended System Requirements
4. What's New in the Professional Edition?
4.1. Assigning
4.2. E-mail and Web support
4.3. Systems of Control
4.4. Reporting
4.5. Enhanced screens
4.6. Referee Ability Levels
4.7. Billing/Payroll
4.8. Import/Export
4.9. Internationalization
4.10. Database Structure
2. Installation
1. Download Referee Assistant
2. Install Referee Assistant
3. Configuration
1. Definitions
2. Navigation
2.1. Games
2.2. People
2.3. Assignments
2.4. Availability
2.5. Database
2.6. Maintenance
3. Set Default Values
4. Define Systems of Control
4.1. Definition
4.2. Examples
5. Define Age Groups
5.1. Define Age Groups
6. Define Game Types
4. Quick Start Guide
1. Add Referees
2. Add Teams
3. Add Games
4. Assign Referees
4.1. Manual Assignments
4.2. Automatic Assignments
5. Inform Referees of Assignments
6. Billing
6.1. Game Fees
6.2. Assignor Fees
6.3. Methods
7. Generate Payroll Reports for Referees
5. Import/Export
1. Importing Games
2. Importing Referees
3. Exporting Referees, Games, Assignments, or other information.
6. People
1. Administrators
2. Coaches
3. Referees
3.1. General Information
3.2. Assignments Tab
3.3. Ability Tab
3.4. Notes Tab
3.5. Custom Fields Tab
3.6. Day/Time Conflicts Tab
3.7. League Conflicts Tab
3.8. Zone Conflicts Tab
3.9. Team Conflict (1) Tab
3.10. Team Conflict (2) Tab
7. Maintenance
1. Game Types
2. Leagues
3. Teams
4. Cities
5. Fields
6. Referee Grades
7. Age Groups
7.1. Define Age Groups
7.2. Age Groups & Difficulty Levels Setup
7.3. Age Groups & Difficulty Levels--Examples
8. Assigning Referees
1. General Concepts
2. Conflict Types
2.1. Type A: Official is working elsewhere OR is working this match
2.2. Type B: Official is not qualified to work this match or position
2.3. Type C: Official has a conflict with the home/away team
2.4. Type D: Official cannot work any games when the team is playing
2.5. Type E: Official cannot work in this league
2.6. Type F: Official is not available to work during this time
2.7. Type G: Official cannot exceed his/her maximum number of games per day
2.8. Type H: Official not allowed to work games in this zone
3. Manual Assignments
4. Automatic Assignment Screen
5. Automatic Assignment Process
6. Linked (Back-to-Back) Assignments
6.1. Linking Games
6.2. Manual-Assign Linked Games
6.3. Auto-Assign Linked Games
9. Referee Fees, Expenses, Billing, and Payroll
1. Fees
1.1. Game Fees
1.2. Assignor Fees
1.3. Referee Expenses
2. Billing
2.1. Administrators
2.2. Pre Season/Post Season
2.3. Formula Used for Billing
3. Payroll
10. Database
1. GameData files
1.1. Information held in a GameData file
1.2. New GameData file
1.3. Duplicate GameData File
1.4. Change GameData File
2. Archive Games
3. Referential Integrity
11. Web Services
1. Setup Web Services
2. Step-by-Step Process
3. Web Services Menu Commands
4. System-Generated E-mails
5. Referee Website Functions
5.1. Current News
5.2. My Contact Information
5.3. My Availability
5.4. My Upcoming Assignments
5.5. View Games
5.6. Accept/Decline
6. Administrator Website Functions
6.1. Current News
6.2. My Information
6.3. Administrative Options
6.4. Upcoming Games
6.5. View Games & Referees
6.6. Accept/Decline Status
12. Other Features
1. Referee Availability
2. Team Administrators
3. Referee-Team Conflicts
3.1. Type 1 Conflicts (Conflict between Referee and Team)
3.2. Type 2 Conflicts (Conflict between Referee and Time a Team Plays)
13. Report Reference
1. Game Reports
1.1. Games by Date
1.2. Games-Group By
1.3. Games-Change Log
1.4. Game Assignment Status
1.5. Game Links
2. Billing Reports
2.1. Billing by Admin
2.2. Billing by Admin (Pre-Season)
2.3. Billing by Teams
2.4. Billing by Teams (Pre-Season)
3. Assignments
3.1. Referee Assignments
3.2. Referee Data Wallet Report (Legal)
4. Payroll Reports
4.1. Payroll
4.2. Payroll Detail
4.3. Payroll Summary
5. Mailing Labels
5.1. Active Coaches
5.2. All Referees
5.3. Billing
5.4. Payroll
6. Crosstab Queries
6.1. Games-Teams
6.2. Referee Assignments
6.3. Referee Game Count
6.4. Referee-Team
7. Age Groups and Abilities
7.1. Age Groups
7.2. Referee Ability Ratings by Position/by Person
8. Referees
8.1. Referee Availability
8.2. Referee Notes
8.3. Referees-All Information
8.4. Referees-Basic
9. Utility
9.1. Error Log
14. Customizing Referee Assistant
1. Customizing
2. Reporting Module
15. Support
A. License Agreement

List of Figures

7.1. Age Group/Difficulty Ratings Example

List of Tables

3.1. Date Formats
3.2. Address Formats
3.3. Input Masks
3.4. System: Soccer Diagonal + 4th
3.5. System: College Basketball
3.6. System: High School Baseball
3.7. System: College Football
5.1. Import Games Field Layout
5.2. Import Referees Field Layout
7.1. Sample Referees & Ability Levels
8.1. Back to Back Games (Example 1)
8.2. Back to Back Games (Example 2)
13.1. Sample of Crosstab Query

List of Examples

7.1. Age Groups & Game Difficulty
7.2. Game Difficulty & Difficulty Adjustments