Field layout for comma delimited charts. File naming convention: trkYYYYMMDDitch.csv trk = Track code YYYYMMDD = Numeric year, month and date i = Omitted if day card, "e" if evening card tch = TrackMaster chart product indicator csv = Comma delimited format indicator 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 FIELD1 Char(1) Record Indicator FIELD2 Char(2) Race Breed Type FIELD3 Char(3) 3 Char Track Code FIELD4 Num(8) Date (YYYYMMDD) FIELD5 Num(2) Race Number FIELD6 Char(1) D=Day Card E=Evening FIELD7 Char(25) Race Type FIELD8 Num(10) Purse Value FIELD9 Char(128) Race Text(1) FIELD10 Char(128) Race Text(2) FIELD11 Char(128) Race Text(3) FIELD12 Char(128) Race Text(4) FIELD13 Char(12) Abbrev. Conditions FIELD14 Num(6) Distance FIELD15 Char(1) Distance Unit FIELD16 Char(1) A= About Distance FIELD17 Char(1) Surface FIELD18 Num(3) Class Rating FIELD19 Char(2) Track Condition FIELD20 Char(10) Weather FIELD21 Char(10) Start (Post who broke) FIELD22 Char(8) Post Time FIELD23 Num(3) Daily Track Variant FIELD24 Char(8) First Fraction Time FIELD25 Char(8) Second Fraction Time FIELD26 Char(8) Third Fraction Time FIELD27 Char(8) Fourth Fraction Time FIELD28 Char(8) Fifth Fraction Time FIELD29 Char(8) Winning Time FIELD30 Num(4) Lead 1st Call Pace FIELD31 Num(4) Lead 2nd Call Pace FIELD32 Num(4) Winners Speed Rating FIELD33 Char(8) Par Time FIELD34 Num(12) Purse Split FIELD35 Num(12) Purse Split FIELD36 Num(12) Purse Split FIELD37 Num(12) Purse Split FIELD38 Num(12) Purse Split FIELD39 Num(12) Purse Split FIELD40 Num(12) Purse Split FIELD41 Num(12) Purse Split FIELD42 Num(12) Purse Split FIELD43 Num(12) Purse Split FIELD44 Char(15) Exotic Wager FIELD45 Char(12) Exotic Paid Numbers FIELD46 Num(12) Exotic Pay Out FIELD47 Num(12) Exotic Wager Pool FIELD48 Char(15) Exotic Wager FIELD49 Char(12) Exotic Paid Numbers FIELD50 Num(12) Exotic Pay Out FIELD51 Num(12) Exotic Wager Pool FIELD52 Char(15) Exotic Wager FIELD53 Char(12) Exotic Paid Numbers FIELD54 Num(12) Exotic Pay Out FIELD55 Num(12) Exotic Wager Pool FIELD56 Char(15) Exotic Wager FIELD57 Char(12) Exotic Paid Numbers FIELD58 Num(12) Exotic Pay Out FIELD59 Num(12) Exotic Wager Pool FIELD60 Char(15) Exotic Wager FIELD61 Char(12) Exotic Paid Numbers FIELD62 Num(12) Exotic Pay Out FIELD63 Num(12) Exotic Wager Pool FIELD64 Char(15) Exotic Wager FIELD65 Char(12) Exotic Paid Numbers FIELD66 Num(12) Exotic Pay Out FIELD67 Num(12) Exotic Wager Pool FIELD68 Char(15) Exotic Wager FIELD69 Char(12) Exotic Paid Numbers FIELD70 Num(12) Exotic Pay Out FIELD71 Num(12) Exotic Wager Pool FIELD72 Char(15) Exotic Wager FIELD73 Char(12) Exotic Paid Numbers FIELD74 Num(12) Exotic Pay Out FIELD75 Num(12) Exotic Wager Pool FIELD76 Char(15) Exotic Wager FIELD77 Char(12) Exotic Paid Numbers FIELD78 Num(12) Exotic Pay Out FIELD79 Num(12) Exotic Wager Pool FIELD80 Char(15) Exotic Wager FIELD81 Char(12) Exotic Paid Numbers FIELD82 Num(12) Exotic Pay Out FIELD83 Num(12) Exotic Wager Pool FIELD84 Char(128) Claims(Horse;$;Owner;) FIELD85 Char(2) Wind Direction FIELD86 Num(2) Wind Speed Structure for horse record # Type Name FIELD1 Char(1) Record Indicator FIELD2 Char(3) 3 Char Track Code FIELD3 Num(8) Date (YYYYMMDD) FIELD4 Num(2) Race Number FIELD5 Char(1) D=Day Card E=Evening FIELD6 Char(20) Last Race FIELD7 Char(2) Breed Type FIELD8 Char(25) Horse Name FIELD9 Num(3) Horse Weight FIELD10 Num(2) Horse Age FIELD11 Char(1) Sex (M,C,F,G,H) FIELD12 Char(7) Med / Equip FIELD13 Char(30) Jockey Name FIELD14 Num(7,2) Odds / $ FIELD15 Char(3) Program # FIELD16 Num(2) Post Position FIELD17 Num(12) Claim Value FIELD18 Num(4) Start Call FIELD19 Num(4) 1st Call Position FIELD20 Num(6,2) 1st Call Lengths FIELD21 Num(4) 2nd Call Position FIELD22 Num(6,2) 2nd Call Lengths FIELD23 Num(4) 3rd Call Position FIELD24 Num(6,2) 3rd Call Lengths FIELD25 Num(4) 4th Call Position FIELD26 Num(6,2) 4th Call Lengths FIELD27 Num(4) Stretch Call Position FIELD28 Num(6,2) Stretch Call Lengths FIELD29 Num(4) Original Finish FIELD30 Num(6,2) Lengths Behind Leader FIELD31 Num(4) Official Finish FIELD32 Num(7,4) Individual Horse Time(QH Only) FIELD33 Num(3) Speed Rating FIELD34 Char(30) Trainer FIELD35 Char(30) Owner FIELD36 Char(128) Race Comments FIELD37 Char(128) Winners Information FIELD38 Num(7,2) Pay Win FIELD39 Num(7,2) Pay Place FIELD40 Num(7,2) Pay Show FIELD41 Num(7,2) Pay Show(DeadHeat) The following are the definitions of abbreviations used in the TrackMaster charts BREED AP Appaloosa AR Arabian MX Mixed Breed PT Paint QH Quarter Horse TB Thoroughbred DISTANCE UNIT F Furlongs M Meters Y Yards SURFACE D D-Dirt E D-Equitrack F D-Dirt training N D-Inner track B T-Timber C T-Downhill turf course G T-Turf training I T-Inner turf J T-Jump race M T-Hurdle S T-Steeplechase T T-Turf U T-Hunt on turf V T-Hunt Flat (Weatherbys only) RACE TYPE / CLASS ALW Allowance CL claiming CLH Claiming Handicap CLM Claiming CST Claiming stake G1 grade 1 G2 grade 2 G3 grade 3 HCP Handicap HST Stakes handicap MDN Maiden MAT Match race MCL Maiden Claiming MSW Maiden special weight OCH Optional claiming handicap OCL Optional claiming SHP Starter handicap STK Stakes STR Starters allowance TR Training race AGE 02 2 yo 03 3 yo 04 4 yo 05 5 yo 06 6 yo 07 7 yo 08 8 yo 09 9 yo 23 2 & 3 yo's 2U 2 yo's & up 34 3 & 4 yo's 35 3, 4, & 5 yo's 36 3, 4, 5 & 6 yo's 3U 3 yo's & up 45 4 & 5 yo's 46 4, 5 & 6 yo's 47 4, 5, 6 & 7 yo's 4U 4 yo's & up 56 5 & 6 yo's 57 5, 6 & 7 yo's 58 5, 6, 7 & 8 yo's 59 5, 6, 7, 8 & 9 yo's 5U 5 yo's & up 67 6 & 7 yo's 68 6, 7 & 8 yo's 69 6, 7, 8 & 9 yo's 6U 6 yo's & up 78 7 & 8 yo's 79 7, 8 & 9 yo's 7U 7 yo's & up 8U 8 yo's & up 9U 9 yo's & up MEDICATION / EQUIPMENT A Aluminum pads B Blinkers C Mud calks D Glued shoes E Inner Rims F Front bandgages G Goggles H Outer Rims I Inserts J Aluminum pad L Bar shoes M Blocks N No whip O Blinkers off R Bar shoe S Steel shoes T Turndowns U Spurs W Queen's Plates Y No shoes Z Tongue tie B Bute SEX C Colt F Filly G Gelding H Horse M Mare R Ridgling Lasix Change from last race N Lasix last and lasix this race L Lasix X No lasix last, no lasix this 1 No lasix last, lasix this race 2 No lasix two races back, lasix last and this race TRACK CONDITION FT D-fast FZ D-frozen HY D-heavy MY D-muddy SL D-slow SY D-sloppy WF D-wet fast FM T-firm HD T-hard SF T-soft UN Unknown YL T-yielding Restrictions of race C C (colts) F F (fillies) H H (horses only) M M (mares only) R Restricted S State WIND DIRECTION (generally displayed only in Quarter Horse races) C Cross H Head N No Wind T Tail This field layout and the field contents are copyrighted by AXCIS Information Network Inc. This designed is owned by AXCIS and may not be reprinted, distributed or incorporated into any other usage unless given expressed permission in writing by AXCIS Information Network, Inc.