[Babase] Fwd: allmiscs table in babase

lacey.maryott at duke.edu lacey.maryott at duke.edu
Sun Jun 17 21:41:54 EDT 2007


Hello,
  Karl and I have been looking into the ALLMISCS table in biograph. Some errors
are appearing during the updating of 2006B that have brought up some questions
about this table and how much we would like it to be checked and validated.  I
did some work with it and came up with a sloppy list of the types of things
that come up in this table. Karl is talking about potentially working some more
validation into this table, and I was just wondering if there was potential, or
desire to try to standardize some of these things, or if this table is destined
to look the way it does.  I saved a table in the sandbox with the completed
table I made, including each row of all miscs along with its corresponding row
in samples.  Below is the summary.

Lot of C's
O's for Mount
O,ABBPULLINF?
O,ASING HEL.  --- shouldn't this be an agonism???
O,BEING MOUNT  maybe 0, 998, M, WEM
18 lines that just say 0, C   no information about who is consorting the F,J
O's for Present
O for carrying dead infant
213 lines say "O,D"
O,EAG OPHGACA  - should be entered as 2 grooms?
O,FED GROOMED - could be UNK G FED  or no?
O,GRB=GARBAGE(FOOD)
O,GREETING???
O,HIB WITH NOB INF
O, MOUNTED  with no other info
should all mounting rows be standardized, either using just M or using "Mount"
or something, or shall we not standardize? or can't we?
195 rows for "O,N"
O,NOT NYA BUT LIN
O,OMO
O,ORNZ M CAI
O,PAI PPESENT TO EL
O,PResenting, with no other info
O,PULL PENIS
O,RIDING VENTRAL
O,RIGOZO?
O,RUNINIG AWAY
O,S
OS.
OS....  (these should be OS...)
O,WAD AS NAP  should be an agonism?
O,WAS PULL LOV ??
O,XYDAG
tons of U lines for samples not done, why? do we need these?
U lines for other group notes?
U,A for alarmed? (followed by dog and maasai Moran
there are a LOOOOOOOOOT of U lines for samples missed and various reasons why
they were missed.
U,EATING GOAT KIDS.
U,EDW WITH OXY.WHOLE SAM.
U,EEING.
U, Groomed ( should be G's?)
U,NVR=ARMY WORMS.                food codes...
U,OTH=EGGS
U,OTH=BALANITE FRUITS.


This is a fairly comprehensive list, with a lot of non standardized entries... I
guess thats what makes it Misc. Susan, Jeanne, is there any desire to clean this
up and get rid of some of these, or no?

Karl, is it even feasible to put more validation rules on a table that looks
like this?

Thanks all,
take care
Lacey



More information about the Babase mailing list