Import Fields

Players

Teams

Contacts

Officials

IDNumber: (Required) Unique number to identify the player.

TeamID: (Required) Unique Team Number. Will be used to relate Players to Teams

IDNumber:  Unique ID number identifying a Contact.

OfficialID: (Required) Unique number to identify an Official.

Salutation: (one of blank, Mr, Ms, Mrs, Miss, Dr)

FirstName: (Required)

Middle Name

TeamName: (Required)

ContactType:  Required - Type of Contact (Secretary, Parent, Scheduler, etc)

OfficialType: Required - (Maintenance Table) Will add entries to the Official Types maintenance table and link to officials.

LastName: (Required)

TeamNameShort: Short form of the team name.

ONE OF:

ProgramName:

PlayerName:

TeamName:

LeagueName:

These fields relate a contact record to a particular Program Concept, Player, team or Leagues

Salutation: (one of blank, Mr, Ms, Mrs, Miss, Dr)

FirstName: (Required)

Middle Name

PlayerType: This is an important field.  A value of "Player" indicates that the person to be entered into the players table is a player.  Other types such as "Coach", "Trainer", "Manager", etc can be added.

AddressLine1:

AddressLine2:

City:

StateOrProvinceCode: (Maintenance Table) Will add entries to the StateOrProvinceCode (or the name you gave this field) maintenance table and link to the Player.

CountryCode: (Maintenance Table) Will add entries to the CountryCode maintenance table and link to the Player.

PostalCode:

EmailAddress:

HomePhoneNumber:

WorkPhoneNumber:

WorkPhoneExt: (max 5 numbers)

CellPhoneNumber:

FaxNumber:

Gender: Valid Values (‘M’,’F’,’ ‘) Will convert anything starting ‘M’ or ‘F’ to appropriate values.

Fees Due & Fees Paid: Numeric values of current fees owed and paid. Will not create invoice records.

Player Level: (Maintenance Table) Will add entries to the Player Level maintenance table and link to the Player.

PositionName: (Maintenance Table) Will add entries to the Positions maintenance table and link to the Team Contact.

WaiverSign, Physical Provided, Captain, Assistant: Valid Values ‘Y’, ‘N’.

Registration Date: Date format (spreadsheet date format). Will default to todays date if not entered.

DOB: Date of Birth must be a Date form (spreadsheet date format).

YearsExperience, Grade JerseyNumber: Must be Numeric.

DoctorName, DoctorPhoneNumber, DoctorPhoneExt, DoctorNotes, InsuranceCompany, InsuranceNumber, Height, Weight, SchoolName, TeacherName: AlphaNumeric. Can contain any data within the database size restrictions (typically 50 characters).

Comments:

Keywords:

XImportTeamID: This is a link to the TeamID of a Team being Imported into the XImportTeams Table (Optionally, This field can be omitted and TeamName can be used).

TeamID: Not Used.

TeamName: The exact name of a Team either being imported or currently in the software that this Player plays on.

Primary Contact Info:

Salutation:

First Name:

Middle Name:

Last Name:

AddressLine1:

AddressLine2:

City:

StateOrProvinceCode: (Maintenance Table) Will add entries to the StateOrProvinceCode (or the name you gave this field) maintenance table and link to the Team Contact.

CountryCode: (Maintenance Table) Will add entries to the CountryCode maintenance table and link to the Team Contact.

PostalCode:

HomePhoneNumber:

WorkPhoneNumber:

WorkPhoneExt: (max 5 numbers)

CellPhoneNumber:

FaxNumber:

EmailAddress:

WebSiteURL:

Fees Due & Fees Paid: Numeric values of current fees owed and paid. Will not create invoice records.

Salutation: (one of blank, Mr, Ms, Mrs, Miss, Dr)

FirstName: (Required)

Middle Name

LastName: (Required)

AddressLine1:

AddressLine2:

City:

StateOrProvinceCode: (Maintenance Table) Will add entries to the StateOrProvinceCode (or the name you gave this field) maintenance table and link to the Official.

CountryCode: (Maintenance Table) Will add entries to the CountryCode maintenance table and link to the Official.

PostalCode:

EmailAddress:

HomePhoneNumber:

WorkPhoneNumber:

WorkPhoneExt: (max 5 numbers)

CellPhoneNumber:

FaxNumber:

Gender: Valid Values (‘M’,’F’,’ ‘ ) Will convert anything starting ‘M’ or ‘F’ to appropriate values.

Comments:

Keywords:

LastName: (Required)

AddressLine1:

AddressLine2:

City:

StateOrProvinceCode: (Maintenance Table) Will add entries to the StateOrProvinceCode (or the name you gave this field) maintenance table and link to the Official.

CountryCode: (Maintenance Table) Will add entries to the CountryCode maintenance table and link to the Official.

PostalCode:

EmailAddress:

HomePhoneNumber:

WorkPhoneNumber:

WorkPhoneExt: (max 5 numbers)

CellPhoneNumber:

FaxNumber:

Gender: Valid Values (‘M’,’F’,’ ‘ ) Will convert anything starting ‘M’ or ‘F’ to appropriate values.

Comments:

Keywords:

Jersey Number: Numeric

EmployeeID: