Database Handicapping Software- JCapper Schema: JCapper StarterHistory Table
file: c:\JCapper\exe\JCapper2.mdb
last updated: 10/26/2017

Below is a list of field names, data types, and a brief description of the data stored in each of the columns in the JCapper StarterHistory Table:

Field Name		Data Type	Description
---------------------   -------------   ----------------------------------------------
horsename		text 60		name of horse
track			text 3		track code today’s race
tracklast		text 3		track code most recent start
date			date/time	today’s race date (mo/day/year)
month			number integer	month from date of today’s race
year			number integer	year from date of today’s race
race	                number byte     race number
dist			number single	distance in yards today’s race
distlastout		number single	distance in yards most recent start
surface			text 1		surface type (D, d, O, T, t)
intsurface		number integer	surface type (1=D, 2=d, 3=O, 4=T, 5=t)
tkcond			text 3		track condition (FT, GD, SY, MY,  FM, SF, YL, etc.)
classdescriptor		text 2		class descriptor (C=claiming, M=mdn claiming, etc.)
classdescrlast		text 2		class descriptor most recent start (C=claiming, M=mdn claiming, etc.)
odds			number single	post time odds today’s race
rankodds		number integer	rank for odds today’s race (1=post time favorite)
vulnerablefav		number integer	vulnerable favorite indicator (0=legit 1=vulnerable)

officialfinishposition	number integer	official finish position today’s race
finPosFav1		number integer	finish position favorite today’s race
finPosFav2		number integer	finish position 2nd favorite today’s race
finPosFav3		number integer	finish position 3rd favorite today’s race
finPosFav4		number integer	finish position 4th favorite today’s race
finPosFav5		number integer	finish position 5th favorite today’s race
finPosFav6		number integer	finish position 6th favorite today’s race
finPosFav7		number integer	finish position 7th favorite today’s race
finPosFav8		number integer	finish position 8th favorite today’s race
finPosUPR1		number integer	finish position UPR rank = 1 horse today’s race
finPosUPR2		number integer	finish position UPR rank = 2 horse today’s race
finPosUPR3		number integer	finish position UPR rank = 3 horse today’s race
finPosUPR4		number integer	finish position UPR rank = 4 horse today’s race
finPosUPR5		number integer	finish position UPR rank = 5 horse today’s race
finPosUPR6		number integer	finish position UPR rank = 6 horse today’s race
finPosUPR7		number integer	finish position UPR rank = 7 horse today’s race
finPosUPR8		number integer	finish position UPR rank = 8 horse today’s race

winpayoff		number single	win mutuel $2.00 base
placepayoff		number single	place mutuel $2.00 base
showpayoff		number single	show mutuel $2.00 base
exoticWagerType		text 3		description of exotic wager type ("EXA")
exoticWagerPayoff	number single	exotic wager payoff $2.00 base
mvp                     number long     indicates (1=true 0=false) horse in the race with the highest combined parimutuel payoffs

fieldsize		number integer	number of starters today’s race
fieldsizelastout	number integer	number of starters most recent start
rgn			number integer	randomly generated number (1-100 for stat analysis)
racevolatility		number single	Race Volatility
espraceshape		number integer	race shape based on run styles of starters in current race
paceindex		number single	Pace Index
pacepressure		number integer	Pace Pressure from Race Shape
pctdirty		number single	Percent of field DIRTY
purse			number single	purse value today’s race
railposition		number integer	position in starting gate (1=closest to inside rail)
pscore			number single	PScore
runstyle		number integer	running style (1=E, 2=EP, 3=P, 4=S, 5=NA)
qspeedpoints		number integer  quirin style speed points (between 0 and 8)
racedays		number integer	number of days since most recent start
wodays			number integer	number of days since most recent work

cantrunxformattrib	number integer	0=CLEAN, 1=XFORM, 2=CANTRUN
wosince			number integer	WOSINCE (0=worked since last, 1=no works since last)
stagereadiness		number integer	Stage Readiness (0=none, 1=type 1, 2=type 2)
sprintcycle		number integer	Sprint Cycle (0=no, 1=yes)
routecycle		number integer	Route Cycle (0=no, 1=yes)
fcycle			number integer	Form Cycle (1-9)
scycle			number integer	Speed Cycle (1-9)
dcycle			number integer	Distance Cycle (1-9)
sub			number integer	sprints under belt after layoff
rub			number integer	routes under belt after layoff

clshift			number integer	class shift using purse value
clshift2		number integer	class shift using par and race strength
dtshift			number single	distance shift (in furlongs)
sfshift			number integer	surface shift
wtshift			number integer	weight shift

ftscount		number integer	first time starter count today’s race
routedebut		number integer	route debut today (0=false, 1=true)
routedebutcount		number integer	route debut starter count today’s race
turfdebut		number integer	turf debut today (0=false, 1=true)
turfdebutcount		number integer	turf debut starter count today’s race	
foreign			number integer	foreign horse making North American debut today (0=no, 1=yes)
figimprov		number integer	(reserved for future use)
layoffhorsecount	number integer	layoff starter count today’s race
pacelow			number integer	new pace low
pacetop			number integer	new pace top
drivetype		number integer	Drive Type (0=none, 1=type 1, 2=type 2)
horsetype		number integer	Horse Type

mline			number single	morning line odds
rankmline		number integer	rank morning line odds
mlor			number single	MLOR - morning line odds ratio
mlor2			number single	MLOR2 – morning line odds ratio 2
mlor3			number single	MLOR3 – morning line odds ratio 3

bettorstoteprob		number single 	BettorsToteProb - prob based on proprietary algorithm and post time odds
rankBettorsToteProb	number integer	rank BettorsToteProb

jprtoteprob		number single 	JPRToteProb - prob based on JPR and post time odds
uprtoteprob		number single 	UPRToteProb - prob based on UPR and post time odds
uprzscoreprob		number single 	UPRZScoreProb - prob based on normalized ZScore distribution of UPR
upropinionprob		number single	UPROpinionProb - prob based on rank and gap of UPR

aprob			number single 	AProb (JRating enabled users only)
rankaprob		number integer	rank AProb
gapaprob		number single	gap AProb

jprmlprob		number single 	JPRMLProb
rankjprmlprob		number integer	rank JPRMLProb
gapjprmlprob		number single	gap JPRMLProb

uprmlprob		number single 	UPRMLProb
rankuprmlprob		number integer	rank UPRMLProb
gapuprmlprob		number single	gap UPRMLProb

or3			number single	OR3 Odds Ratio 3
ebettorstoteprob	number single	Expected Value BettorsToteProb
euprzscoreprob		number single	Expected Value UPRZScoreProb	
ejprtoteprob		number single	Expected Value JPRToteProb	
euprtoteprob		number single	Expected Value UPRToteProb

rider			text 60		name of rider
trainer			text 60		name of trainer
owner			text 60		name of owner
sire			text 60		name of sire
siressire		text 60		name of sire’s sire
dam			text 60		name of dam
damssire		text 60		name of dam’s sire

ageofhorse		number integer	age of horse in years
sex			number integer	sex of horse (1=f, 2=m, 3=c, 4=h, 5=g, 6=r)	
claimraces		number integer	claim races (0=not claimed, 1=claimed last start, 2=claimed 2 back, etc.)
claimdays		number integer	days since claim (0=not claimed, 19=claimed 19 days ago)
med			number integer	medication (0=none, 1=lasix, 2=bute, 3=lasix & bute, 4=1st time lasix, etc.)
equip			number integer	equipment change (0=none, 1=blinkers on, 2=blinkers off)
startslifetime		number integer	number of lifetime starts

xthstartrider		number integer	xth start for rider
xthstarttrainer		number integer	xth start for trainer
xthstartlasix		number integer	xth start after lasix
xthstartlayoff		number integer	xth start after layoff
xthstartmeet		number integer	xth start of current meet	

len2call		number single	beaten lengths at second call last start
pos2call		number integer	position at second call last start
lenstrcall		number single	beaten lengths at stretch call last start
posstrcall		number integer	position at stretch call last start
lenfincall		number single	beaten lengths at finish call last start
posfincall		number integer	position at finish call last start

rankjpr			number integer	rank JPR
jpr			number single	JPR numeric value
gapjpr			number single	gap JPR

rankupr			number integer	rank UPR
upr			number single	UPR numeric value
gapupr			number single	gap UPR

rankalchemy		number integer	rank Alchemy
alchemy			number single	Alchemy numeric value
gapalchemy		number single	gap Alchemy

rankprating		number integer	rank PRating
prating			number single	Prating numeric value
gapprating		number single	gap Prating

rankqrating		number integer	rank QRating
qrating			number single	Qrating numeric value
gapqrating		number single	gap Qrating

rankF01			number integer	rank of factor placed by user into slot 01
valF01			number single	numeric value of factor placed by user into slot 01
gapF01			number single	gap of factor placed by user into slot 01

rankF02			number integer	rank of factor placed by user into slot 02
valF02			number single	numeric value of factor placed by user into slot 02
gapF02			number single	gap of factor placed by user into slot 02

rankF03			number integer	rank of factor placed by user into slot 03
valF03			number single	numeric value of factor placed by user into slot 03
gapF03			number single	gap of factor placed by user into slot 03

rankF04			number integer	rank of factor placed by user into slot 04
valF04 			number single	numeric value of factor placed by user into slot 04
gapF04			number single	gap of factor placed by user into slot 04

rankF05			number integer	rank of factor placed by user into slot 05
valF05			number single	numeric value of factor placed by user into slot 05
gapF05			number single	gap of factor placed by user into slot 05

rankF06			number integer	rank of factor placed by user into slot 06
valF06			number single	numeric value of factor placed by user into slot 06
gapF06			number single	gap of factor placed by user into slot 06
		
rankF07			number integer	rank of factor placed by user into slot 07
valF07			number single	numeric value of factor placed by user into slot 07
gapF07			number single	gap of factor placed by user into slot 07

rankF08			number integer	rank of factor placed by user into slot 08
valF08 			number single	numeric value of factor placed by user into slot 08
gapF08			number single	gap of factor placed by user into slot 08

rankF09			number integer	rank of factor placed by user into slot 09
valF09 			number single	numeric value of factor placed by user into slot 09
gapF09			number single	gap of factor placed by user into slot 09

rankF10			number integer	rank of factor placed by user into slot 10
valF10			number single	numeric value of factor placed by user into slot 10
gapF10			number single	gap of factor placed by user into slot 10

rankF11			number integer	rank of factor placed by user into slot 11
valF11			number single	numeric value of factor placed by user into slot 11
gapF11			number single	gap of factor placed by user into slot 11

rankF12			number integer	rank of factor placed by user into slot 12
valF12			number single	numeric value of factor placed by user into slot 12
gapF12			number single	gap of factor placed by user into slot 12

rankF13			number integer	rank of factor placed by user into slot 13
valF13			number single	numeric value of factor placed by user into slot 13
gapF13			number single	gap of factor placed by user into slot 13

rankF14			number integer	rank of factor placed by user into slot 14
valF14 			number single	numeric value of factor placed by user into slot 14
gapF14			number single	gap of factor placed by user into slot 14

rankF15			number integer	rank of factor placed by user into slot 15
valF25			number single	numeric value of factor placed by user into slot 15
gapF15			number single	gap of factor placed by user into slot 15

rankF16			number integer	rank of factor placed by user into slot 16
valF16			number single	numeric value of factor placed by user into slot 16
gapF16			number single	gap of factor placed by user into slot 16
		
rankF17			number integer	rank of factor placed by user into slot 17
valF17			number single	numeric value of factor placed by user into slot 17
gapF17			number single	gap of factor placed by user into slot 17

rankF18			number integer	rank of factor placed by user into slot 18
valF18 			number single	numeric value of factor placed by user into slot 18
gapF18			number single	gap of factor placed by user into slot 18

rankF19			number integer	rank of factor placed by user into slot 19
valF19 			number single	numeric value of factor placed by user into slot 19
gapF19			number single	gap of factor placed by user into slot 19

rankF20			number integer	rank of factor placed by user into slot 20
valF20			number single	numeric value of factor placed by user into slot 20
gapF20			number single	gap of factor placed by user into slot 20

rankF21			number integer	rank of factor placed by user into slot 21
valF21			number single	numeric value of factor placed by user into slot 21
gapF21			number single	gap of factor placed by user into slot 21

rankF22			number integer	rank of factor placed by user into slot 22
valF22			number single	numeric value of factor placed by user into slot 22
gapF22			number single	gap of factor placed by user into slot 22

rankF23			number integer	rank of factor placed by user into slot 23
valF23			number single	numeric value of factor placed by user into slot 23
gapF23			number single	gap of factor placed by user into slot 23

rankF24			number integer	rank of factor placed by user into slot 24
valF24 			number single	numeric value of factor placed by user into slot 24
gapF24			number single	gap of factor placed by user into slot 24

rankF25			number integer	rank of factor placed by user into slot 25
valF25			number single	numeric value of factor placed by user into slot 25
gapF25			number single	gap of factor placed by user into slot 25

rankF26			number integer	rank of factor placed by user into slot 26
valF26			number single	numeric value of factor placed by user into slot 26
gapF26			number single	gap of factor placed by user into slot 26
		
rankF27			number integer	rank of factor placed by user into slot 27
valF27			number single	numeric value of factor placed by user into slot 27
gapF27			number single	gap of factor placed by user into slot 27

rankF28			number integer	rank of factor placed by user into slot 28
valF28 			number single	numeric value of factor placed by user into slot 28
gapF28			number single	gap of factor placed by user into slot 28

rankF29			number integer	rank of factor placed by user into slot 29
valF29 			number single	numeric value of factor placed by user into slot 29
gapF29			number single	gap of factor placed by user into slot 29

rankF30			number integer	rank of factor placed by user into slot 30
valF30			number single	numeric value of factor placed by user into slot 30
gapF30			number single	gap of factor placed by user into slot 30

rankF31			number integer	rank of factor placed by user into slot 31
valF31			number single	numeric value of factor placed by user into slot 31
gapF31			number single	gap of factor placed by user into slot 31

rankF32			number integer	rank of factor placed by user into slot 32
valF32			number single	numeric value of factor placed by user into slot 32
gapF32			number single	gap of factor placed by user into slot 32

rankF33			number integer	rank of factor placed by user into slot 33
valF33			number single	numeric value of factor placed by user into slot 33
gapF33			number single	gap of factor placed by user into slot 33

rankF34			number integer	rank of factor placed by user into slot 34
valF34 			number single	numeric value of factor placed by user into slot 34
gapF34			number single	gap of factor placed by user into slot 34

rankF35			number integer	rank of factor placed by user into slot 35
valF35			number single	numeric value of factor placed by user into slot 35
gapF35			number single	gap of factor placed by user into slot 35


Copyright © 2017 JCapper Software