File Spec for Export HX7 UPDATED OCT 2004 44 DATA FIELDS FILE NAMING ----------- Files will be named as follows _HX7.TXT BEL = BEL_HX7.TXT If the ALL file is used ALL_HX7.TXT Field Header Item ---------------------------------------------------------------------------- 01 "tTRK" Name of track 02 "tDATE" Date in format 00/00/0000 ex: 12/13/2001 03 "nRACE" Race number 04 "nDIST" Distance of race in furlongs ex: 6.5, 10.0 05 "nSURF" 1=fast dirt; 2=turf; 3=wet dirt 06 "nDS" 1=dirt sprint; 2=dirt route; 3=turf sprt; 4=turf rte the 'scheduled' distance/surface type (actual may change) note: track condition not considered in this field 07 "nCLA" Class Type 1=Alw/Stk; 2=Clm; 3=Msw; 4=Mcl 08 "nSEX" Gender of race 1=males; 2=females 09 "nAGE" Age restriction on race 1= 3up or 4up 2= 2yr only 3= 3yr only 10 "nSTB" State Bred 1=State Bred restriction; 0= open race 11 "nPURS" Purse x 1000 eg: 38 = purse value = $38,000 12 "nCLM" Claiming Price x 1000 eg: 20 = $20000 claimer 0 = not a claiming race 13 "nEPR" Estimated Performance Rating (EPR) for the race. 14 "nFLD" Field Size Actual field size if results are in 15 "tPGM" Program Number of this horse 16 "tHOR" Full Equibase name of horse 17 "nPPO" Post Position (actual if results are in) 18 "nMLO" Morning Line Odds eg: 3.5 = 7/2 2.5 = 5/2 19 "nHAGE" Horse Age eg: 8 = 8 years old 20 "tHSEX" Horse Sex: h= Horse (older male, not gelded) g= Gelding, c= Colt; m= Mare; f= Filly; r= Ridgling 21 "nLAY" Layoff Days since last race. 0 = FTS 22 "nCHG" Changes 1= First Time Lasix 2= Blinkers On 3= Blinkers OFF 4= 2nd Time Lasix 5= 1st Lasix and Blinkers On 6= 2nd Lasix and Blinkers On 23 "tTrainer" Full Equibase Trainer Name 24 "nTRN" Trainer rating 25 "rTRN" Trainer rank 26 "tJockey" Full Equibase Jockey Name 27 "nJKY" Jockey Rating 28 "rJKY" Jockey rank 29 "tSire" Full Equibase Sire Name 30 "tSireSire" Full Equibase Sire of Sire Name 31 "tDam" Full Equibase Dam Name 32 "tDamSire" Full Equibase Dam Sire Name 33 "tSTATE" State where horse was bred (2 char);(KY= Kentucky) If Canadian = Province (ON= Ontario) If Foreign Bred, code for country (FR= France) 34 "nPED" Pedigree Rating 35 "rPED" Pedigree Rank 36 "tRACECOND" Text of race conditions: ie: "3up Nw1" 37 "nPL_AGO" Days Ago the most recent Selected Paceline took place. 38 "tPL_TRACK" Track name of most recent selected paceline. 39 "nPL_DIST" Distance in furlongs of chosen PL; 0 = no line 40 "nPL_SURF" Surface code of chosen PL; 0 = no line (ie: FTS) 1= fast dirt; 2= turf; 3= wet dirt 41 "tPL_CLASS" Text Class description of chosen PL; ie: "3up C50" 42 "nPL_SOR" Strenth of Race rating for chosen Paceline 43 "nFIN" Finish position If Chart available, shows finish for all horses If Chart not avail: 1-2-3 finishers only, 0= out 44 "nODDS" Final odds If Chart available, odds for all horses If no chart, winner's odds only