The field layout for importing referees is shown below.
Table 5.2. Import Referees Field Layout
| Column Name | Description | Format | Required? |
|---|---|---|---|
| Full Name | Name of Referee | Can be either "FirstName LastName" or "LastName, FirstName" | Yes; either Full Name, or both Last Name AND First Name must both be chosen. |
| Last Name | Name of Referee | Text | Yes, see above |
| First Name | Name of Referee | Text | Yes, see above |
| Address | Street Address | Text | No |
| City | City (for mailing address) | Text | No |
| State | State (for mailing address) | Text, two letters | No |
| Postal Code | Postal Code (for mailing address) | Text | No |
| Home Phone | Home telephone number | See below. | No |
| Work Phone | Work telephone number | See below. | No |
| Cell Phone | Cell phone number | See below. | No |
| SSN | Social Security Number | 123456789 or 123-45-6789 | No |
| Grade | Referee grade | Text (See Below.) | No. |
| Birth Date | Birthdate of referee | Excel-compatible date format | No |
| Registration Date | Registration Date | Date (see below) | No |
| Ability Low: [Position Name] | Ability Level (Low) for specified position | Numeric | No |
| Ability Pref: [Position Name] | Ability Level (Preferred) for specified position | Numeric | No |
| Ability High: [Position Name] | Ability Level (High) for specified position | Numeric | No |
| Custom: [Field Name] | Custom Field. | Text | No |
Phone numbers should be completely numeric (e.g. 5855551212) or should contain necessary punctuation/spaces/dashes/etc. ( (585) 555-1212). Referee grades will be matched to an existing referee grade; ensure that your referee grades are established properly before import, as new grades will not be created automatically. Dates should conform to the Short Date format for your locality (as seen in Start : Control Panel : Regional & Language Options). U.S. format should be m/d/yy or m/d/yyyy.
Systems of Control and Custom Fields (if used) should also be established prior to import; only the positions/custom fields that have already been established in Referee Assistant will be available for import from your spreadsheet.