The document outlines the data fields for horse racing records, detailing the type, format, and length for each field. Key fields include track information, race details, horse specifics, and participant statistics. It covers various race types, medication and equipment codes, and includes trainer and jockey performance metrics. The data also encompasses race conditions, weather forecasts, and post times in different formats. Additionally, it specifies codes for surfaces, race types, and breed types, with some fields reserved for future use.
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