Field layout for comma delimited harness charts. File naming convention: trkMMDD.AYY trk = Track code MMDD = Numeric month and date A = ASCII comma delimited format indicator YY = Year of the race The comma delimited files have a "multi-record" format, one record type for the RACE information and the other for HORSE information. The definitions of the fields and types are described at the end of this document. Each "RACE" record begins with an "R" in the first field and precedes the horse related records in the file. Each "HORSE" Record begins with an "H" and follows the race line information. Structure for race record # Type Name Example FIELD1 Char(1) Race Record Indicator R FIELD2 Char(5) 5 Character Track Code CALX FIELD3 Char(5) Track Size 1 1/4 FIELD4 Num(8) Race Date 20030125 FIELD5 Char(1) Card Id *SEE LIST OF CODES FIELD6 Num(2) Race Number 15 FIELD7 Num(11,2) Purse (in Local $) 1000000.00 FIELD8 Char(12) Race Type (of winner) NW7/175CL FIELD9 Char(1) Trot/Pace/Both T,P or B FIELD10 Num(7,4) Race Distance (in decimal) 1.0625 FIELD11 Char(2) Track Condition *SEE LIST OF CONDITIONS FIELD12 Num(3) Temperature 100 FIELD13 Num(2) Number of Starters 10 FIELD14 Num(6,2) 1/4 Mile Time (in seconds) 30.00 (-97.00 if N/A) FIELD15 Num(6,2) 1/2 Mile Time (in seconds) 60.00 (-97.00 if N/A) FIELD16 Num(6,2) 3/4 Mile Time (in seconds) 90.00 (-97.00 if N/A) FIELD17 Num(6,2) Final Time (in seconds) 120.00(-97.00 if N/A) FIELD18 Num(6,2) Inter Track Variant 44.56 FIELD19 Num(6,2) Daily Track Variant -1.23 FIELD20 Num(6,2) Class Rating 82.00 (-99.00 if N/A) FIELD21 Num(4,2) Canadian Exchange Rate 0.74 FIELD22 Char(3) Country Code USA or CAN Structure for horse record # Type Name Example FIELD1 Char(1) Horse Record Indicator H FIELD2 Char(25) Horse Name WASTIN TIME FIELD3 Char(6) Horse Registration # VA1543 FIELD4 Char(1) Trot/Pace T or P FIELD5 Char(5) 5 Character Track Code CALX FIELD6 Num(8) Race Date 20030513 FIELD7 Char(1) Card Id *SEE LIST OF IDS FIELD8 Num(2) Race Number 15 FIELD9 Char(12) Race Type NW7/175CL FIELD10 Num(11,2) Money Earned (in Local $) 33333.33 FIELD11 Char(5) Before Post Position *SEE LIST OF CODES FIELD12 Num(2) Post Position 0,1,2,3... FIELD13 Char(5) After Post Position *SEE LIST OF CODES FIELD14 Char(5) Before 1st Quarter *SEE LIST OF CODES FIELD15 Num(2) 1st Quarter Call 0,1,2,3... FIELD16 Char(5) After 1st Quarter *SEE LIST OF CODES FIELD17 Char(5) Parked Out 1st Quarter < FIELD18 Num(6,2) 1st Quarter Lengths Back 5.50 (.1 HD, .05 NK, .01 NS) FIELD19 Char(5) Before 2nd Quarter *SEE LIST OF CODES FIELD20 Num(2) 2nd Quarter Call 0,1,2,3... FIELD21 Char(5) After 2nd Quarter *SEE LIST OF CODES FIELD22 Char(5) Parked Out 2nd Quarter < FIELD23 Num(6,2) 2nd Quarter Lengths Back 5.50 (.1 HD, .05 NK, .01 NS) FIELD24 Char(5) Before 3rd Quarter *SEE LIST OF CODES FIELD25 Num(2) 3rd Quarter Call 0,1,2,3... FIELD26 Char(5) After 3rd Quarter *SEE LIST OF CODES FIELD27 Char(5) Parked Out 3rd Quarter < FIELD28 Num(6,2) 3rd Quarter Lengths Back 5.50 (.1 HD, .05 NK, .01 NS) FIELD29 Char(5) Before Stretch Call *SEE LIST OF CODES FIELD30 Num(2) Stretch Call 0,1,2,3... FIELD31 Char(5) After Stretch Call *SEE LIST OF CODES FIELD32 Char(5) Parked Out Stretch < FIELD33 Num(6,2) Lengths Back Stretch 5.50 (.1 HD, .05 NK, .01 NS) FIELD34 Char(5) Before Finish *SEE LIST OF CODES FIELD35 Num(2) Original Finish Call 0,1,2,3... FIELD36 Num(2) Official Finish Call 0,1,2,3... FIELD37 Char(5) After Finish *SEE LIST OF CODES FIELD38 Num(6,2) Lengths Back Finish 5.50 (.1 HD, .05 NK, .01 NS) FIELD39 Num(6,2) Horse's 1st Quarter Time 28.70 (-97.00 if N/A) FIELD40 Num(6,2) Horse's 2nd Quarter Time 59.30 (-97.00 if N/A) FIELD41 Num(6,2) Horse's 3rd Quarter Time 88.50 (-97.00 if N/A) FIELD42 Num(6,2) Horse's Final Time 118.20 (-97.00 if N/A) FIELD43 Num(6,2) Horse's Last Fraction Time 31.10 (-97.00 if N/A) FIELD44 Num(6,2) Odds To A Dollar 17.20 FIELD45 Char(1) Favorite F FIELD46 Char(1) Coupled Entry Y FIELD47 Char(6) Driver Registration # P05704 FIELD48 Char(30) Driver Name ED HENSLEY FIELD49 Char(6) Trainer Registration # P05704 FIELD50 Char(30) Trainer Name ED HENSLEY FIELD51 Char(2) Medication B and/or L FIELD52 Char(1) Hoppled/Freelegged H or F FIELD53 Char(15) Comments LOOMED BOLDLY FIELD54 Char(1) Claimed C FIELD55 Num(11,2) Claim Price (In Local $) 50000.00 FIELD56 Num(6,2) Speed Rating Final 99.99 (-99.00 if N/A) FIELD57 Num(6,2) Speed Rating 1st Fraction 99.99 (-99.00 if N/A) FIELD58 Num(6,2) Speed Rating 2nd Fraction 99.99 (-99.00 if N/A) FIELD59 Num(6,2) Speed Rating 3rd Fraction 99.99 (-99.00 if N/A) FIELD60 Num(6,2) Speed Rating 4th Fraction 99.99 (-99.00 if N/A) The following are the definitions of abbreviations used in the TrackMaster charts CARD IDS 1 Qualifier 2 Time Trial 3 Purse (non-betting, baby race, early) 4 Official workout 5 Purse (afternoon, betting) 6 Purse (evening, betting) 7 Matinee 8 Fair (afternoon) 9 Fair (evening) TRACK CONDITIONS FR Freezing FT Fast GD Good HY Heavy MY Muddy NR Not Reported SN Snow SL Slow SY Sloppy CODES AC Accident AX Accident Break BD Broke Down BE Broken Equipment BK Bulked BL Bled BT Bolted CH Choked DA Dangerous DH Dead Heat DNF Did Not Finish DNS Did Not Start DQ Disqualified DR Drawn DX Driver Caused Break EX Equipment Break FBS Fell Before Start FL Fell FLS Fell Before Start FOG Fog I Interference IGB Ineligible Horse IHR Inside Hub Rail IJ Injured IM Impeded IX Interference Break JG Judges LM Lame LST Lost Time Trial NR Not Reported PL Placed PRT Pre-Race Test PU Pulled Up RCL Recall REF Refused RN Rain RO Ruled Out SCR Scratched SK Sick SN Snow SU Sulked UNM Unmanageable UNS Unseated Driver UPL Unplaced VET Vet DIS Distanced