[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