[Babase] Rankdate Changes in Babase
Lacey Maryott Roerish
lroerish4 at gmail.com
Fri Mar 19 14:48:28 EDT 2010
Susan, (et al)
Jeanne, Karl, Niki and I just finished discussing how to handle some
recent issues discovered in babase related to Rankdates. It can be
difficult to extract number of males on a given date if some males rankdates
occur in the middle of the month. For this reason, I will be changing all
rankdates (Both BY and ON) to the beginning on the month using a function
Karl had previously developed. This will simply make querying easier, and
will also sync up rankdates data with actual rank data, which are all
recorded on the 1st of the month.
After this is done, Niki will continue to run the queries she was
running and if more errors pop out she will send them to me. I will
backfill with the years she wasn't already querying and identify all
situations in which there seems to have been a rankdate/ranking error and,
with Susan's guidance, fix this errors.
We will also make it a top priority to get the 2008B ranks completed and
those rankdates/maturedates into the database.
Once all of that is done, I Will also be doing checks comparing rank
dates to mature dates to make sure that there aren't any errors related to
this 'date' problem.
This should leave us with cleaned up rankdates and maturedates tables!
Cheers
Lacey
--
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100319/868c41b7/attachment.html
More information about the Babase
mailing list