Diff for "BabaseChangelog"

Date

Initials

Details

07AUG2007

LKM

one psion file was double entered so the associated rows had to be deleted using 'delete from where between ;' These deletions removed the following id's from babase. SID's 38529 to 38546, IID's 602800 to 602810, pntid's 416895 to 417063, the tables affected are parts, interact_data, neighbors, point_data, fpoints, samples. These id numbers will not be 'query-able' as the have been removed from the database. I just thought it important to note where these numbers disappeared to.

08OCT2007

LKM

"ISO's name was initially OXF, so OXF showed up in Psion data but wasn't in biograph. The neighbors entries were originally changed to 998's but I changed them to ISO after figuring this out (For reference, the associated pntid in neighbors was 428168)

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A'. This cenid was 1910452. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 28/10/86 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid=1927725.

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A' This cenid was 1899540. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 31/10/85 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid 1927724.

07DEC2007

LKM

It was brought to my attention by T. Fenn that OBR was missed in ALM ranks for 01/2004 and 02/2004. I had to delete the ranks for these two months, which meant deleting rnkid 13969 through 14026. I re-uploaded the ranks for these two months after having added in OBR at rank 13 (end of ADM) as per SCA. The new data are represented in rnkid no's 57590 through 57649

22JAN2007

LKM

The upload program found an error corresponding to a sample in which RWA was sampled as a 'FEM' more than 1 year before her Maturedate (which Tabby was trying to enter). In checking this sample, sid 31893 , it became clear that it should have been a 'JUV' sample, and was thus deleted. As RWA was out of sight for the whole sample, there were no rows in any tables except for samples, from which I deleted all information tied to sid 31893. This sample came from raw Psion file 050924P4.The deleted data is as follows: 31893 24/09/2005 \N JKW F 1.22 RWA 5 0 1 3 4

01MAR2008

LKM

There were a number of individuals in the database with status = 3, or missing. These individuals were all rechecked, and there is no evidence that they are dead, so their status was changed to 0, alive, in an effort to remove the missing code from babase. Affected Individuals are Ivan, Sinister, Crest, Cowlick, BJ ( BJX ), Chip, Max, Xenos, Peter, Seka, Ben, Baron, Wymouth, Raymond, Harvey, Warlock ( WLK ), Pigtail, Fred, Bristle, Teta, Slik ( SLK ), Dorus, Leroy, Kirk, Isaac, Shomo, Slant, Rasta, Styx, Vor, Peanut ( PNT ), Cymbal, Nami, Osborne, Mike, Omen, Thoth, Huxley, Juba, Spike, Fupi, Putz, Kuza, Fatso, Lemur, Ozzie, Giza, Wang, Manfred, Kobol, Hans ( HNS ), Ndimu, Tiptip, Jewel, Ross, Jomba, Sezna, Refu, Keith, Orlon, Nugu, and Dennis.

01MAR2008

LKM

In order to complete the previous change, a few individuals needed to have their statdates changed from an interpolated date to a real statdate. Those animals and the old and new statdates follow. FRE old = 11/02/1984 and new = 10/02/1984; BRI old = 14/02/1984 and new = 11/02/1984; TET old = 04/08/1984 and new = 03/08/1984; DOR old = 16/10/1985 and new = 15/10/1985; KIR old = 19/04/1986 and new = 18/04/1986; ISA old = 06/06/1986 and new = 05/06/1986; SHO old = 07/06/1986 and new = 05/06/1986; SLA old = 10/12/1986 and new = 05/12/1986; VOR old = 08/08/1987 and new = 05/08/1987; PNT old = 18-09-1987 and new = 16-09-1987; CYM old = 28/10/1987 and new = 22/10/1987; OME old = 03/05/1988 and new = 26/04/1988; THO old = 06/08/1988 and new = 03/08/1988

08MAR2008

KHF

Jeanne noticed a number of males missing their mature and dispersedates that should have been entered during recent updates. This was due to a a maladapted FoxPro query that I was running in the new system. I checked the data for males age 4+ during the 06B and later updates and fixed the syntax of the query. The only male dispersedate I had to add from 06B was for WOL. I had to enter maturedates for the following individuals: NOZ DAS KOR WUA KUT (06B) BUC and SEB (07B).

01AUG2008

LKM

There were a number of individuals in the database with status = 2 (Suspected Dead) All of these individuals had dcause of 8(under review) with the exception of POWELL whose dcause was 2(conspecific). In order to get rid of this code, SCA and LKM reviewed the notebooks and were able to assign individuals to alive, or dead, and to assign d-causes to those who are dead. The following were changed to status 0, dcause 0: JAKE, MSWAKI, ALY, KUKU. FAVAS was changed to status 1, dcause 4; AMIGO to status 1 dcause 4; MOLLOY to dcause 3, status 1; PEPO to status 1, dcause 4; and POWELL to status 1 dcause 2.

01AUG2008

LKM

Other individuals who needed to be changed from suspected dead to alive or dead require their statdates be changed. These individuals and their changes are as follows: DELTA: to status 0 dcause 0, old stat=1996-04-02 new stat=1996-03-23; HAHA to status 0 dcause 0, old stat=1996-04-02, new stat=1996-03-23; TUZO: to status 0, dcause 0, old stat= 1999-05-11, new stat= 1999-5-10.

27AUG2008

LKM

The last of the individuals with status of suspected dead were changed to dead with the following dcauses: NOG to status 1 dcause 1; STU to status 1 dcause 7; EDWARD to status 1 dcause 7; FAREX to status 1 dcause7; HEGEL to status 1 dcause 7; VATICAN to status 1 dcause 7.

18SEP2008

LKM

Susan and I stumbled upon some errors in the way that disperse dates were assigned during the period of 1992-1999. The exact error varies from case to case, but basically the assignment rule wasn't followed. Therefore, the disperse dates for 5 individuals had to be changed to reflect the day that they dispersed, and the disperse dates for 2 individuals were removed as it could not be determined that they did not simply reflect the end of observation or a fission. WAL disperse date was changed from 1993-02-03 to 1999-02-04; TUZ disp date was changed from 1993-07-11 to 1993-06-14; DAV disp date was changed from 1996-03-26 to 1996-02-16; BEA disp date was changed from 1996-09-04 to 1996-01-03; DIV disp date changed from 1999-08-03 to 1999-07-08. DAL and JIK disperse dates were removed as per SCA.

02Oct2008

KHF

Patrick O. discovered that a pid for LAD7 (LAQUER) had not been entered in BIOGRAPH. This was due to the fact that the conception and birth ended up being entered in the same demog update and the pid was omitted initially to allow the BIOGRAPH record to load. I should have updated the pid subsequently but did not for some reason. I used an update statement to enter the pid into BIOGRAPH. I also queried BIOGRAPH for all other pid's that are null. There did not seem to be any other omission errors of known mothers from our 5 study groups. All the other unknown pids came from grps 1,2,3 or 9 in much earlier decades.

12Dec2008

KHF

DIC1 and WIR3 had blanks instead of NULL in the name column of BIOGRAPH. I changed these to NULL and checked for other similar situations, changing all blanks to NULLS. There were only a few others

05Feb2009

LKM

OFR had a row in samples for 9Feb08, a day when she was not in the group. The whole sample was out of sight so, there were no rows in any tables except for samples, from which I deleted all information tied to sid 50688. This sample came from raw Psion file 080209P3.The deleted data is as follows: 50688 09/02/2008 11:21:00 SNS F 1.21 OFR 10 0 2 4 3

05Feb2009

KHF

LKM deleted a row in samples for OFR on 9Feb08, allowing me to updated OFR statdate from 2009-02-09 to 2009-02-08. This was her assigned deathdate, but due to the empty SAMPLES row, her statdate did not correctly input at the time of the last update. Earlier corrections to statdate for ABB and OBO were also made on 9 December 2008. ABB statdate was changed to 2008-02-08 and OBO statdate was changed to 2008-03-04. In each case their statdates had defaulted to the following day because there was a demog note saying that a thorough search was done on the first date that their absence was noted. I deleted these demog notes since they were unnecessary and created false census data. On 9 December 2008 I also searched for and changed any blank names in BIOGRAPH to null values where the sname was also already null.

24Feb2009

KHF

RE: the changes made above for OFR, ABB, OBO. I rebuilt CYCSTATS because OFR had incorrect information for April 2008. She was D almost the entire month even though MTD_CYCLES showed her tdate of 5 April and ddate of 19 April. This error probably had something to do with her incorrect statdate. When I rebuilt the table, (after corrections above to her statdate) her CYCSTATS state for April was altered to correctly show the S and D and O that should have been triggered by the MTD_CYCLES data. I also rebuilt Babase_test CYCSTATS. REPSTATS, MMINTERVALS, MDINTERVALS should also be rebuild but as I am currently working on the 08b update, this will be done shortly. CYCSTATS was rebuilt immediately because P. Onyango needed the data.

25Feb2009

KHF

I added a demog Note for SHOMO for 11 June 1986, per a discovery of the missing note by L.Maryott. I updated his status and dcause to 0 (formerly 3 and 8).

18Jun2009

NHL

I changed JIL's matgrp from 9.00 (unknown) to 6.00 (Ositeti), as she is a member of Ositeti and females do not disperse.

26Aug2009

NHL

Morris' bstatus should not have been 9 and was changed to 2. Investigation also uncovered some anomalies in demography data, which were corrected in babase on 3 Sep. Morris should not have been marked present in Nyayo's group via demography note on 25 July 2001 - he was just visiting the group from Sinya; the male ranks for Nyayo's group for that month were adjusted accordingly. Census entries marking him present in group 9 (unknown group) on 20 Oct 1997 and 28 Jul 2001 were also removed. Corrected demography notes were added.

Winter 2009/2010

NHL

Baboons from groups no longer being monitored and males that have not been seen in at least one update cycle were censored for the first time. They have been given a status of 2 in biograph and dcause 99 so that they appear dead to babase. This will prevent accidental upload of data for these animals while indicating that we have no data on their current status. Males that return to a study group after an absence will be uncensored prior to upload. Some animals that should be censored threw samples errors and will be censored following resolution of those errors.

10Mar2010

NHL

Ositeti group is now officially recognized as two distinct groups. Ositeti census data for Feb - Jun 2009 was adjusted to reflect the split during the 09B census update. Groups 6.1 (Jill's), 6.2 (Ceejay's - initially called Latin's but updated in May 2010 once a marker female was chosen), and 6.9 (unidentified Ositeti group) are now recognized.

5May2010

NHL & LMR

Billy and Amok were determined to be the same baboon. Billy's birth and early census data were added unto Amok and Billy was deleted from babase.

13Jul2010

NHL

Adjustments were made to cycpoints to adjust for a missing cycle (Lizzy) and to better align ddates with consortship data as follows: Lizzy's ddate corresponding to the conceive data for LIZ6 was changed from 20 Jul 2008 to 18 Aug 2008 and the correct end of the prior resume cycle and beginning of this cycle were added; Nap's ddate was moved forward two days to 4 Jan 2002, Wheatear's forward three days to 23 Jul 2002, and Kelly's forward two days to 3 Sep 2006.