(C) Copyright Bloodstock Research Information Services, Inc. All Rights Reserved Data structure for the "Early Track Data File (ETD) MAX. FIELD# DESCRIPTION TYPE FORMAT LENGTH COMMENTS 1 Track CHARACTER XXX 3 2 Date CHARACTER XXXXXXXX 8 CCYYMMDD 19960821 3 Race Number NUMERIC 99 2 4 Distance (in yards) NUMERIC 9999 4 5 About Indicator CHARACTER X 1 A-About 6 Course Id (Surface) CHARACTER X 1 D-Dirt T-Turf 7 Purse NUMERIC 99999999 8 8 Race Type CHARACTER XXX 3 ALW - Allowance AOC - Alw Opt. Clm CAN - Cancelled Race CLH - Clmg Handicap CLM - Claiming CST - Claiming Stake HCP - Handicap HST - Stakes Hcp MAT - Match Race MCL - Maiden Clmg MOC - Maiden Optional Claiming MSW - Maiden Special Weight OCH - Optional Claiming Handicap OCL - Optional Claiming OCS - Optional Claiming Stakes OTH - Other Breed SHP - Starter Handicap SIM - Simulcast STK - Stakes STR - Starter Allowance TR - Training Race 9 Maximum Claiming Price NUMERIC 9999999 7 10 Early Post Position NUMERIC 99 2 11 Track Program Post Pos NUMERIC 99 2 12 Horse Name CHARACTER 25 13 Year of Birth NUMERIC 99 2 14 Official Program Number CHARACTER XXX 3 15 Medication NUMERIC 9 1 (0=None, 1=Lasix, see field #69 2=Bute, 3=Bute & Lasix, 9=Medication info unavailable) 16 Equipment NUMERIC 9 1 (0=No change, 1=Blinkers on, 2=Blinkers off, 9=Equipment info unavailable) 17-25 Wager Types CHARACTER 80 26 Morning Line Odds NUMERIC 999.99 6 27 Race Name CHARACTER 50 28 Owner Name CHARACTER 40 29 Owner Silks CHARACTER 100 30 Added Name CHARACTER 50 31-45 Race Conditions CHARACTER 250 46 "Live Track" Track Code CHARACTER 3 47 "Live Track" Race # NUMERIC 2 48 "Live Track" Race Date CHARACTER 8 CCYYMMDD 49 Horse where bred CHARACTER 5 50 Horse weight NUMERIC 999 3 51 Program Selections CHARACTER 10 ex. 12-7-5 52 Trainer Last Name CHARACTER 20 53 Trainer First Name CHARACTER 20 54 Trainer Middle Initial CHARACTER 1 55 Trainer Sts Cur Meet NUMERIC 9999 4 56 Trainer Wins Cur Meet NUMERIC 999 3 57 Trainer Plcs Cur Meet NUMERIC 999 3 58 Trainer Shws Cur Meet NUMERIC 999 3 59 Jockey Last Name CHARACTER 20 60 Jockey First Name CHARACTER 20 61 Jockey Middle Initial CHARACTER 1 62 Apprentice Code CHARACTER 1 1- 5 lbs off 2- 7 lbs off 3- 10 lbs off C- Contract rider with 3 lbs off 63 Apprentice Weight Allow NUMERIC 99 2 64 Jockey Sts Cur Meet NUMERIC 9999 4 65 Jockey Wins Cur Meet NUMERIC 999 3 66 Jockey Plcs Cur Meet NUMERIC 999 3 67 Jockey Shws Cur Meet NUMERIC 999 3 68 Advance Weather Forecast 69 Medication w/ 1st Time NUMERIC 9 1 (0=None, 1=Lasix, 2=Bute, 3=Bute & Lasix, 4=First Lasix, 5=First Lasix & Bute, 9=Medication info unavailable) 70 Post Time (Local) CHARACTER 15 eg. 10:59pm (ET) 71 Post Times (by region) CHARACTER 50 eg. 1:15/(12:15)/11:15/10:15 72 Post Time (Pacific military) CHARACTER 4 eg. 1959 73 MainTrackOnly indicator 1 "M" if MTO 74 Breed Type 3 SOME of the types: AP-Appaloosa AR-Arabian PT-Paint/Pinto QH-Quarter Horse TB-Thoroughbred NB-Non-tbred in TJC registry 75-99 Reserved Fields ETD structure as of 03/07/2008 [ Sign-up ] [ Products & Prices ] [ Bookstore ] [ Track Info ] [ Library ] [ Tech Support ] [ F.A.Q. ] [ Member Services ] [ Contact Us ]