Horse Record

Dated: June 25, 2001    Version: 1.0

Field Name

Data Type

Max Size

Explanation

Record_type

char

1

H

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

US or CAN (currently)

Breed_of_race

char

2

currently TB only

Horse_name

char

40

Will include foreign codes in parenthesis for foreign born horses following the horse name.  Just like past performances.

Program_number (saddle_cloth)

char

4

Blank if scratched

Scratch_flag

number

1

0 = No, 1 = Yes

Post_position

Number

3

Not valid if scratched (zero)

Non_betting_flag

number

1

0 = No, 1 = Yes

Coupled_type

char

1

Coupling character when applicable (A, B, C) etc;  Note: This has nothing to do with the saddle cloth character that coupled horses use.  This is simply a common letter assigned to all horses which are coupled together.

Position_at_start

number

3

All positions that are not used or not recorded for a particular distance will be 0

Position_at_call_1

number

3

Position_at_call_2

number

3

Position_at_call_3

number

3

Position_at_call_4

number

3

Position_at_call_5

number

3

Position_at_finish

number

3

Official_position

number

3

Dead_heat_flag

number

1

0 = No, 1 = Yes

Disqualification_flag

number

1

0 = No, 1 = Yes

Lengths_at_call_1

number

7

For horse on lead this will be leading margin.  For trailing horses this will be the total lengths behind leader.

Lengths_at_call_2

number

7

Lengths_at_call_3

number

7

Lengths_at_call_4

number

7

Lengths_at_call_5

number

7

Lengths_at_finish

number

7

Off_odds

number

7

Morning_line_string

char

8

Morning line when available

Morning_line_odds

number

7

Morning line converted to decimal

Favorite_indicator

number

1

0 = No, 1 = Yes

Win_payoff

number

8

Coupled horses will both have the appropriate win payoff.

Place_payoff

number

8

Coupled horses will both have the appropriate place payoff.

Show_payoff

number

8

Coupled horses will both have the appropriate show payoff.

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_string_7

char

TBD

To Be Determined

Reserved_string_8

char

TBD

To Be Determined

Reserved_string_9

char

TBD

To Be Determined

Reserved_string_10

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

Reserved_number_7

number

TBD

To Be Determined

Reserved_number_8

number

TBD

To Be Determined

Reserved_number_9

number

TBD

To Be Determined

Reserved_number_10

number

TBD

To Be Determined

 Main

 Race Record

 Exotic Record   

 Definitions