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(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(25) Race Type FIELD7 Num(10) Purse Value FIELD8 Char(128) Race Text(1) FIELD9 Char(128) Race Text(2) FIELD10 Char(128) Race Text(3) FIELD11 Char(128) Race Text(4) FIELD12 Char(12) Abbrev. Conditions FIELD13 Num(6) Distance FIELD14 Char(1) A= About Distance FIELD15 Char(1) Surface FIELD16 Num(3) Class Rating FIELD17 Char(2) Track Condition FIELD18 Char(10) Weather FIELD19 Char(10) Start (Post who broke) FIELD20 Char(8) Post Time FIELD21 Num(3) Daily Track Variant FIELD22 Char(8) First Fraction Time FIELD23 Char(8) Second Fraction Time FIELD24 Char(8) Third Fraction Time FIELD25 Char(8) Fourth Fraction Time FIELD26 Char(8) Fifth Fraction Time FIELD27 Char(8) Winning Time FIELD28 Num(4) Lead 1st Call Pace FIELD29 Num(4) Lead 2nd Call Pace FIELD30 Num(4) Winners Speed Rating FIELD31 Char(8) Par Time FIELD32 Num(12) Purse Split FIELD33 Num(12) Purse Split 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 Char(15) Exotic Wager FIELD43 Char(12) Exotic Paid Numbers FIELD44 Num(12) Exotic Pay Out FIELD45 Num(12) Exotic Wager Pool FIELD46 Char(15) Exotic Wager FIELD47 Char(12) Exotic Paid Numbers FIELD48 Num(12) Exotic Pay Out FIELD49 Num(12) Exotic Wager Pool FIELD50 Char(15) Exotic Wager FIELD51 Char(12) Exotic Paid Numbers FIELD52 Num(12) Exotic Pay Out FIELD53 Num(12) Exotic Wager Pool FIELD54 Char(15) Exotic Wager FIELD55 Char(12) Exotic Paid Numbers FIELD56 Num(12) Exotic Pay Out FIELD57 Num(12) Exotic Wager Pool FIELD58 Char(15) Exotic Wager FIELD59 Char(12) Exotic Paid Numbers FIELD60 Num(12) Exotic Pay Out FIELD61 Num(12) Exotic Wager Pool FIELD62 Char(15) Exotic Wager FIELD63 Char(12) Exotic Paid Numbers FIELD64 Num(12) Exotic Pay Out FIELD65 Num(12) Exotic Wager Pool FIELD66 Char(15) Exotic Wager FIELD67 Char(12) Exotic Paid Numbers FIELD68 Num(12) Exotic Pay Out FIELD69 Num(12) Exotic Wager Pool FIELD70 Char(15) Exotic Wager FIELD71 Char(12) Exotic Paid Numbers FIELD72 Num(12) Exotic Pay Out FIELD73 Num(12) Exotic Wager Pool FIELD74 Char(15) Exotic Wager FIELD75 Char(12) Exotic Paid Numbers FIELD76 Num(12) Exotic Pay Out FIELD77 Num(12) Exotic Wager Pool FIELD78 Char(15) Exotic Wager FIELD79 Char(12) Exotic Paid Numbers FIELD80 Num(12) Exotic Pay Out FIELD81 Num(12) Exotic Wager Pool FIELD82 Char(128) Claims(Horse;$;Owner;) 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(25) Horse Name FIELD8 Num(3) Horse Weight FIELD9 Num(2) Horse Age FIELD10 Char(1) Sex (M,C,F,G,H) FIELD11 Char(7) Med / Equip FIELD12 Char(30) Jockey Name FIELD13 Num(7,2) Odds / $ FIELD14 Char(3) Program # FIELD15 Num(2) Post Position FIELD16 Num(12) Claim Value FIELD17 Num(4) Start Call FIELD18 Num(4) 1st Call Position FIELD19 Num(6,2) 1st Call Lengths FIELD20 Num(4) 2nd Call Position FIELD21 Num(6,2) 2nd Call Lengths FIELD22 Num(4) 3rd Call Position FIELD23 Num(6,2) 3rd Call Lengths FIELD24 Num(4) 4th Call Position FIELD25 Num(6,2) 4th Call Lengths FIELD26 Num(4) Stretch Call Position FIELD27 Num(6,2) Stretch Call Lengths FIELD28 Num(4) Original Finish FIELD29 Num(6,2) Lengths Behind Leader FIELD30 Num(4) Official Finish FIELD31 Num(3) Speed Rating FIELD32 Char(30) Trainer FIELD33 Char(30) Owner FIELD34 Char(128) Race Comments FIELD35 Char(128) Winners Information FIELD36 Num(7,2) Pay Win FIELD37 Num(7,2) Pay Place FIELD38 Num(7,2) Pay Show FIELD39 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.