Data Type

Max Size

Explanation

Record_type

char

1

R

Version_string

char

3

1.0 in this release

Track

char

3

Standard track identifier

Race_date

char

10

MM/DD/YYYY

Race_number

number

3

Day_evening

char

1

D or E

Country

char

3

USA or CAN (currently)

Breed_of_race

char

2

currently TB only

Conditions_of_race

char

150

Standard Post Time Daily class string follows Past Performances conventions.  Most of the time this field will be fairly short.  But stakes names will occasionally be very long.  Thus the 150 char designation.

Official_flag

number

1

1 = Yes, 0 = No

Canceled_flag

number

1

1 = Yes, 0 = No (if race was canceled there will be NO horse or exotic records)

Race_type

char

5

See Definitions (1)

Optional_claming_race

number

1

1 = Optional, 0 = Not optional

Starter_conditions

number

1

1 = Starter (alw or Hdcp), 0 = Not Starter

Restrictions

char

1

S = Statebred, R = other Restriction, otherwise blank

Age

char

3

See Definitions (2)

Sex

char

6

Male, Female, Mixed

Grade

number

3

1, 2, or 3

Distance_amount

number

5

TB racing will generally be expressed in feet

Distance_units

char

8

FEET, YARDS, METERS
TB racing will always be expressed in FEET

Inner

number

1

0 = No, 1 = Yes

Turf

number

1

0 = No, 1 = Yes

About

number

1

0 = No, 1 = Yes

Steeplechase

number

1

0 = No, 1 = Yes

Hurdle

number

1

0 = No, 1 = Yes

Hunt

number

1

0 = No, 1 = Yes

Chute_start

number

1

0 = No, 1 = Yes

Purse_local_dollars

number

12

Available Money – Reverted Money (like purse amounts on past performance lines) in local dollars

Full_purse

number

12

As appearing in track program in local dollars

Minimum_claiming_price

number

12

Maximum_claiming_price

number

12

Track_condition

char

10

Standard past performance designations.  See Definitions (3)

Exotic_wager_types_for_race

char

20

Currently not  used.

Fraction1

number

8

All times are seconds and hundreths of seconds.  E.G. 1:10 and 2/5th will appear as 70.40

Fraction2

number

8

Fraction3

number

8

Fraction4

number

8

Fraction5

number

8

Final_time

number

8

Reserved_string_1

char

TBD

To Be Determined

Reserved_string_2

char

TBD

To Be Determined

Reserved_string_3

char

TBD

To Be Determined

Reserved_string_4

char

TBD

To Be Determined

Reserved_string_5

char

TBD

To Be Determined

Reserved_string_6

char

TBD

To Be Determined

Reserved_number_1

number

TBD

To Be Determined

Reserved_number_2

number

TBD

To Be Determined

Reserved_number_3

number

TBD

To Be Determined

Reserved_number_4

number

TBD

To Be Determined

Reserved_number_5

number

TBD

To Be Determined

Reserved_number_6

number

TBD

To Be Determined

 Horse Record

 Exotic Record

 Definitions