--------------------------------------------------------------------------------
NRHA Data File Exports - March 29, 2012
Horse and Member Data File Formats and Schema
For any information about these files contact James Gant at NRHA (jgant@nrha.com)

All files are the CSV format, (Comma Separated Values) or SDF (Standard Data
Format). The fields delimiter is a comma "," Ascii 44. The records delimiter
is a two character pair CRLF or Carriage Return Line Feed or Ascii 13 + 10.
Fields of type Text, Character, or String are quoted with (") character Ascii 34.
Embedded (") characters in a Text Field are repeated (escaped).
---------------------
Member.csv Schema
---------------------
 1. Member number
 2. Last Name
 3. First Name
 4. Middle Name
 5. Business Name
 6. City
 7. State
 8. Country
 9. Member Expire Date
10. NonPro                                  True or Blank
11. AgeGroup                                Y=Youth, P=Prime Time

The Member.csv data is split into multiple files at 50000 records for viewing
with older versions of Microsoft Excel.

--------------------
Horse.csv Schema
--------------------
 1. NRHA license number
 2. Horse name
 3. Owner name
 4. Owner member number
 5. Ownership begin date
 6. Ownership end date                     12/31/2999 if current owner
 7. Sex
 8. Foal Date
 9. City
10. State
11. Country

The Horse File is split in two files. Horse1.csv contains Horse records
From A to L, Horse2.csv contain records M to Z. Each of these files can
be viewed with Excel.  These contain multiple records per horse, one for
each current or past owner as determined by the begin and end dates.

These files that are designed for importing to show programs. The file names
begin with the letter "I" for Import to distinguish these from the other files.
These contain Primary Key fields for relating the tables for database
normalization. These files are not split.
---------------------
IMember.csv
---------------------
 1. MemberID                  Integer32    Primary Key
 2. MemberNo                  Integer32    NRHA member number
 3. LastName                  VarChar(30)
 4. FirstName                 VarChar(30)
 5. MiddleName                VarChar(30)
 6. BusinessName              VarChar(100)
 7. City                      VarChar(50)
 8. StateCode                 VarChar(3)
 9. StateName                 VarChar(50)  State or Province Name
10. CountryName               VarChar(50)
11. MemberExpires             Date         mm/dd/yyyy Membership Expire Date
12. NonPro                    Boolean      True or blank
13. AgeGroup                  Char(1)      Y=Youth, P=Prime Time
---------------------
IHorse.csv
---------------------
 1. HorseID                   Integer32    Primary Key
 2. License                   Integer32    NRHA License Number
 3. HorseName                 VarChar(100)
 4. Sex                       Char(1)      S=Stallion G=Gelding M=Mare
 5. FoalDate                  Date         mm/dd/yyyy
 6. Color                     VarChar(80)
 7. BreederID                 Integer32    Relate to MemberID
 8. SireID                    Integer32    Relate to HorseID
 9. DamID                     Integer32    Relate to HorseID
---------------------
IHorseBreed.csv
---------------------
 1. HorseID                   Integer32    Relate to Horse table
 2. HorseName                 VarChar(100) Breed Association Horse Name
 3. BreedID                   Integer32    Relate to Breed table
 4. BreedCertID               VarChar(20)  Breed Association Certificate ID
 5. DefaultBreed              Boolean      Y=Default Breed (Multiple Breeds)
---------------------
IBreed.csv
---------------------
 1. BreedID                   Integer32    Primary Key
 2. BreedName                 VarChar(100) Breed Name
 3. BreedCode                 VarChar(2)   Breed Association Code
 4. AssociationName           VarChar(100) Association Name
---------------------
IOwner.csv
---------------------
 1. HorseID                   Integer32    Relate to Horse table
 2. MemberID                  Integer32    Relate to Member table
 3. StartDate                 Date         mm/dd/yyyy
 4. EndDate                   Date         12/31/2999=current owner(s)
 ---------------------
 IStates.csv (and provinces)
 ---------------------
 1. CountryCode               VarChar(3)
 2. StateCode                 VarChar(3)
 3. StateName                 VarChar(50)
 ---------------------
 ICountry.csv
 ---------------------
 1. CountryCode               VarChar(3)
 2. CountryName               VarChar(50)
--------------------------------------------------------------------------------