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.

4Jun2010

NHL

HEE and GEM had incorrect sexes listed in babase. HEE is male, GEM is female. These were corrected and HEE's female ranks reassigned to GEM.

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.

10Mar2010

NHL

While censoring animals, census records were compared with wounds and pathologies reports (now in babase_pending) to check for animals that likely died but were not previously declared dead. The following individuals were declared dead: Vipi, Adriano, Zidi, Khan, Nugu, and Ole. Additionally, demography notes indicated that Nod's deathdate should be changed from 21 Oct to 24 Oct 1997. These changes were all made with the 09B demographic update.

23Mar2010

LKR

All rankdates and all male maturedates were rolled back to the first of the month such that older rankdates and maturedates would be brought in line with current protocols.

5May2010

NHL & LKR

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.

4Jun2010

LKR

Rankdates for WEU and DEA were corrected. VIP was moved below all adult males for Weaver's group in Mar and Apr 2000. ARS was added to the ADM ranks in Viola's group at the bottom of the list in Feb 2004.

13Jul2010

NHL

Adjustments were made to cycpoints to include 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.

22Sep2010

LKR

The following changes had to be made to their neighbors table to correct for Males being neighbors after their statdates. All ID numbers correspond to NGHID in the neighbors table. All changes confirmed by SCA. 559484 - MAN was changed to MAH as per surrounding samples. 561996 - VER was changed to VEX as per surrounding samples. 622978 - NEL was changed to NER as per surrounding samples. 657856 - DAN was changed to DAM as per surrounding samples. 693529 - ZAI was changed to ZAN as per surrounding samples. The following neighbor rows were changed to 998 for WYL as an alternative could not be easily discerned; 630098 630101 630104 582684 582686 582688 582690. The following neighbor rows were changed to 998 for DIG as an alternative could not easily be discerned; 647713 643715 647717 645070 645071 645072 645073 645074 645019 642802 642804 642780 610064 610062 554224 554225 554227 554229

15Nov2010

NHL

Birth estimates and bstatuses for MOZ and TOR were originally entered in reverse (i.e., with TOR instead of MOZ as the older animal). The birth and bstatus columns were corrected.

13Dec2010

NHL

Maturedate for LEC revised from 1 Nov 2009 to 1 Feb 2010 when he first consistently was marked as "E".

5Jan2011

NHL & LKR

Several errors in the early 1994 census data for Hook's, and consequently in the male ranks for Hook's, were discovered. Felix and Alex were present in Hook's beginning in Jan 1994, not March. Orlon was present beginning in February, not April. None appeared in the male ranks for those months. Dennis was also present in February though he was not listed as such in Babase; he was, however, ranked. Census data for Felix, Alex, Orlon, and Dennis were added. Kitok was not present in Hook's in February as previously indicated in Babase; his census and rank data for Feb 1994 were deleted. Male ranks for Jan - Mar were adjusted accordingly. Maturedates for Felix and Alex were adjusted from 1 Feb 1994 to 1 Jan 1994.

5Jan2011

NHL

30 Mar 1994 census data for Dotty's group was previously entered into Babase as being for 30 Apr 1994, which was not a census day. This has been corrected. Ajabu was incorrectly deleted from the Alto's census on 5 Mar 1994 in Nov 1994 per a somewhat unclear and belated note from the team about him, Orange, and Villa. Ajabu was present per census, demog notes, and the wounds report for his broken leg. Since he is absent from ranks and was following the group at a distance on the only census day he was live in March, I have left him marked absent but created a demography note (to be uploaded with the other 1993-1996 Alto's demog notes soon) stating that he was alone and following the group and updated his deathdate from 21 Feb to 7 Mar 1994. Orange was similarly deleted from the census in April per the same corrections note but was also really present for the first two census days per the census and a grooming event and was noted as absent on the 27th in demog notes. He showed up in April ranks anyway (perhaps due to the 30 April census error) so ranks is okay. His census data was restored and his deathdate was changed from 12 Sep 1994 (where did that date come from???) to 25 Apr 1994. The assigned dcauses were correct.

06 Jan 2011

LKR

ZEN had incorrectly assigned matured and ranked dates. ZEN's ranked by and matured by dates were backed up to the time at which he entered a study group, 1993-08-01. No rankings were affected by this change.

06 Jan 2011

LKR

LUD was never assigned a matured date. Somehow, the team allowed him to fall off of the scrotal enlargement sheets. At last observation in Nov 07, He had been almost E for 5 months. Susan felt it was safe to assume that 2 months after his last monitored month at Almost E was a safe Matured BY date. So, he was assigned a BY date of 2008-01-01

06 Jan 2011

LKR

COO and DEF were both missed for ranked by dates when they entered or reenetered study groups. DEF was also missing a matured date as a result of being missed. For COO, a ranked on of 2008-12-01 was added. For DEF, mat and ranked by dates of 2008-09-01 were added.

21 Jan 2011

NHL

ORI3 was added to biograph. This fetus was missed when Orion died in 2007.

21 Jan 2011

NHL

Lenga's dcause was changed from 3 to 2 due to evidence of conspecific origin of the wounds in notes.

21 Jan 2011

NHL