The SQLDataBits Field
The SQLDataBits field was added to SQL Mode with the release of Build 198 for both JCapper Silver and JCapper Platinum.
The SQLDataBits field is a shorter abbreviated version of the Angles String found in Playlist File Mode - and is designed to be used in SQL Mode.
The SQLDataBits field contains text characters that enable you to make evaluations in your sql expressions for a number of data points -- such as Rider Change True or False, Trainer Change True or False, Wide Trip (including how many paths wide according to the chart caller) in each of the last three starts, Apprentice Weight Allowance in number of pounds off today, Equipment used in past running lines (according to the chart caller) such as wore Blinkers or wore Front Wraps, State or Country where the horse was bred, positional calls info as read from the HDW Text Chart Results File, and an indicator for AngleB – which, imo, turned out to be the lone angle to actually generate a modest degree of statistical relevance from among the many angles presented in that old many pages long at least a decade old angles thread at Paceadvantage.com.
It’s important to note that I didn’t add the new SQLDataBits field to the StarterHistory table. Nor have I changed the table schema for the StarterHistory table in any material way.
What I did was make the following text name fields in the StarterHistory and StartersToday tables longer – increasing the max number of characters that can be stored in each of the following fields to 60 characters: Horsename, Rider, Trainer, Owner, Sire, Siressire, Dam, and Damssire.
I also added a new screen to the SQL Factor Setup Tool called the Factor Reassignment Screen.
To use the new SQLDataBits field: You have to go into the SQL Factor Setup Tool, pick one of the name/text fields you aren’t really using -- for example the Owner, Siressire, or Dam field, etc. -- reassign SQLDataBits to that field, and persist the change by clicking the SAVE button.
From there, after you rebuild databases from scratch: The field that you reassigned SQLDataBits to in your StarterHistory table will contain SQLDataBits data instead of data for the original field (such as Owner, Siressire, or Dam, etc.)
--Link to Help Doc - with example showing how to use the Factor Reassignament Screen to assign SQLDataBits to the SIRESSIRE field:
http://www.jcapper.com/Article_FactorReassignmentScreen.html
After making the reassignment to the SIRESSIRE field (or another name field) as shown in the Help Doc, and after rebuilding databases from scratch, when you look in the StarterHistory table - you will see values for SQLDataBits in the name field where SQLDataBits has been assigned.
Meaning that if you wanted to create SQL UDMs based on SQLDataBits values, you could now do that.
--Example: After assigning SQLDataBits to the SIRESSIRE field in your SQL Factor Setup and after populating the StarerHistory Table by rebuilding databases from scratch, you could use something like the following line in a SQL UDM to flag starters with a rider change today:
AND INSTR(SIRESSIRE, ‘R1-’) > 0
--Another: Suppose you wanted to make an existing UDM exclude starters ridden by an inexperienced rider? One who still has a 10 pound or a 7 pound 'bug?'
You could do that using something like the following two lines:
AND NOT INSTR(SIRESSIRE, '7LB-') > 0
AND NOT INSTR(SIRESSIRE, '10LB-') > 0
--Another: Suppose you wanted to make a UDM flag starters on the turf bred in Ireland?
You could do that using something like the following two lines:
AND INSTR(SIRESSIRE, '[IRE]') > 0
AND INTSURFACE >= 4
SQLDataBits Field Mapping:
SQLDataBits field --
Max characters: 60 (same as the name field where SQLDataBits has been assigned)
DATA POINT INDICATOR EXPLANATION
-------------------- ------- --------------------------------------------------------------
ANGLE B AB- Angle B pattern exists in past running lines
CHARTCALLER NOTES:
-------------------- ------- --------------------------------------------------------------
BORE In/Out Last Start BR- Horse bore in or out last start
WIDE TRIP --
Last Start (X) 5X- 5 Wide Last Start (X character denotes last start)
Second Start Back (Y) 3Y- 3 Wide Second Start Back (Y character denotes 2nd start back)
Second Start Back (Z) 4Z- 4 Wide Third Start Back (Z character denotes 3rd start back)
Changes:
-------------------- ------- --------------------------------------------------------------
BARN/TRAINER CHANGE T1- Trainer name change for this race
RIDER CHANGE R1- Rider name change for this race
-------------------- ------- --------------------------------------------------------------
APPRENTICE WT ALLOWANCE:
-------------------- ------- --------------------------------------------------------------
TEN POUNDS 10LB- 10 pound apprentice weight allowance
SEVEN POUNDS 7LB- 7 pound apprentice weight allowance
FIVE POUNDS 5LB- 5 pound apprentice weight allowance
Equipment worn:
-------------------- ------- --------------------------------------------------------------
BLINKERS WORN BL- Horse wore blinkers this running line
--Note: Generally available in .jcp data file.
As noted by chartcaller during post parade/warmups
FRONT WRAPS WORN F- Horse wore front wraps this running line
--Note: Not available in the data or .jcp file on race day
Exists in HDW chart file only as noted by chartcaller
during post parade and pre-race warmups.
Other:
-------------------- ------- --------------------------------------------------------------
WHERE BRED [KY] Horse was bred in KY (wrapped in brackets)
SADDLECLOTH {1A} Horse was the 1A (wrapped in curly brackets)
Positional Calls Info:
-------------------- ------- --------------------------------------------------------------
Positional Calls Info Positional calls info is 17 characters in length, with
individual positional calls wrapped inside of pipe characters
followed by a dash character.
--Example: |08`06`05`04`02|-
Starting with the pipe character, from left to right:
The first pipe indicates start of positional calls info
1st and 2nd chars 08 indicate position at start call 8th
4th and 5th chars 06 indicate position at first call 6th
7th and 8th chars 05 indicate position at second call 5th
10th and 11th chars 04 indicate position at stretch call 4th
13th and 14th chars 02 indicate position at finish call 2nd
The second pipe and dash indicate end of positional calls info
-------------------- ------- ------------------------------------------------
-jp
.
|
