[Babase] CYCSTATS Proofing

Catherine Markham amarkham at princeton.edu
Fri Jun 30 09:25:59 EDT 2006


Hi Karl,

Here's a bit more regarding CYCSTATS proofing.  This email includes both 
documentation of the checks I'm running (sorry if this repeats details 
I've already mentioned) as well as a couple questions.

1.  There are no rows in CYCSTATS after an animal's statdate.  There are 
rows on an animal's statdate.  Good.

2.  There are no rows in CYCSTATS before an animal's matured date. 
There are rows on an animal's statdate.  Good.

3.  Only females are in CYCSTATS.  Really good.  :)

4.  For all observed mdates, the female is either in state "M" or "S". 
  Good.  This ignores females for whom we do have cycle data but 
currently do not have a matured date (they don't have any REPSTATS or 
CYCSTATS rows).

5.  I did a check similar to the one above but with the automated 
mdates.  On all observed mdates, if the female was in CYCSTATS, she was 
either in state "M" or "S".  That part is good.  However, there were 
several females that were matured but had no CYCSTATS record on an 
mdate.  For all of these, the mdate in question was the "dangling" auto 
mdate we've been talking about recently (the auto mdate is calculated 
from the last observed ddate and has no corresponding tdate or ddate). 
In these cases, the last CYCSTATS rows was on the female's statdate 
(state was always "D" - good).

Questions for Karl:  (1) Does the logic of how this is working match 
your expectations?  If so, I think we need to specify what is going on 
in the documentation (it took me a while querying to figure out what the 
rules are).  Let me know if it is already there - perhaps I missed it 
any maybe we just need to make it more explicit?  (2) Is it going to be 
an issue that there are dates in MTDCYCLES (and also CYCPOINTS) that are 
after a female's statdate?

More to come on additional CYCSTATS tests later...
Catherine


More information about the Babase mailing list