Version Notes
1.0.0 Intitial version (2 May 2014)
1.0.1 Labels and missing values added to IQs dataset (7 May 2014)
1.0.2 Labels and missing values added to CBCs, HIV Drug Treatments, ARTemis patients and ARTemis Lab results dataset (8 May 2014)
1.0.3 Value labels of ShouldTestWhenRegHowOften in IQs dataset fixed (12 May 2014)
1.1.0 IndividualId in IQs dataset fixed (12 May 2014)
1.1.1 Typo fixed in trial statuses value labels in Individuals dataset (14 May 2014)
2.0.0 Initial release of version 2 (15 July 2014)
--- Generated from a new snapshot of the database, dated 22 May 2014
--- New datasets: HHIs, CHE Adverse events, CHE Action Plans, SCBs SCCs, SCIs, Specimens, Individual Consents, iDART
--- Individuals dataset: AgeGroupAtRegistration has been fixed
--- IQs dataset:
------ Health Care expenditure section has been added
------ Variables CurrentCluster, CurrentClusterType, ClusterAtRegistration, ClusterTypeAtRegistration, FormType added
------ Deprecated value fixed for variables ShouldTestWhenFeelSick to ShouldTestWhenRefused , KnowsPosMyself to KnowsPosCommunity
------ Not applicable value fixed for variables WhyNotHIVTestTodayPos to WhyNotHIVTestTodayRefused
------ Some duplicates removed
--- CBCs dataset: variables CurrentCluster, CurrentClusterType, ClusterAtRegistration, ClusterTypeAtRegistration added
--- CHEs dataset:
------ Variables CurrentCluster, CurrentClusterType, ClusterAtRegistration, ClusterTypeAtRegistration added
------ PrevTB1DateStarted, PrevTB2DateStarted and CurrTBDateStarted variables fixed
--- Lab Test Results dataset: VisitId added
--- ARTemis Patients dataset:
------ DateOfViralLoadNear6m DateOfViralLoadNear24m and DateOfViralLoadNear36m added
------ AreaOfResidenceCode recoded
3.0.0 Initial release of version 3 (25 September 2014)
--- Generated from a new snapshot of the database, dated 19 September 2014
--- End of data collection for phase 1 is now fixed to 31st May 2014 (included)
--- Locations dataset: ConstructionState and MappedOnDevice variables have been removed
--- Individuals dataset:
------ Trial statuses have been removed from that file and are now provided in a separate Trial Statuses dataset
------ 85 new pre-calculated variables have been added, following the TasP definitions document
--- IQs dataset: Issue of missing IQs fixed
--- Lab Tests Reults dataset: Some PIMA CD4 count documented initialy only in CHEs have been added to the dataset
3.1.0 Distance variables added to Locations dataset (30 Sep 2014)
3.2.0 Locations datatset: duplicates bug introduced in version 3.1.0 of the dataset is now fixed (7 Oct 2014)
3.3.0 All datasets have been regenerated (9 Oct 2014)
--- A bug with LocationId and HouseholdId has been fixed
--- Cluster dataset has been added
--- Individuals dataset:
------ BaselineClinicVisitDate and LastClinicVisitDate definition has been updated (see TasP definitions do)
------ 100 new pre-calculated variables added on retention in TasP clinics
--- Trial Statuses dataset: details of Exits have been added
--- Visits dataset: CBCcomputed, CHEcomputed, BaselineClinicVisitDate, onART, NextAppointmentDateComputed and PreviousClinicVisitDate added
--- HHIs dataset: ClusterId, CalendarRound, AssetsScore and AssetsScoreCat added
--- CBCs dataset: EarliestHIVDrugRegStartDate updated (new definition) and ARTInitiationDate removed
3.4.0 (23 Oct 2014)
--- Lab Test Results: duplicates (PIMA CD4 count) removed (23 Oct 2014)
--- 2 new datasets: CFUs and CFU Pill Tests
--- Shapefiles added on the repository
--- Individuals dataset
------ minor fix of variable TasPBaselineARTUse
------ 3 variables added: FirstReferralTS, EverEnteredCareAR and NewlyDiagnosedAtReferral
3.5.0 (19 Jan 2015)
--- New datasets:
------ SAE Initial Notifications, SAE Initial Notifications - Events details, SAE Initial Notifications - Medications, SAE Complementary Notifications & SAE Complementary Notifications - Medications
--- Individuals dataset:
------ AgeAtRegistration has been updated (now exact age and missig if year of birth is unknown)
------ New variables about age:
AgeAtReferral, AgeAtBaselineClinicVisit
------ New variables derived from IQs:
BaselineHighestEducationLevel, BaselineMaritalStatus, BaselineProfessionalStatus, BaselineEmployed & BaselineActiveStatus
------ New variables derived from iDART:
LinkedToIDART, iDARTLastEpisodeStartDateBR, iDARTLastPackageCollectionDateBR, iDARTFirstEpisodeStartDateAR,
iDARTFirstPackageCollectionDateAR, iDARTLastEpisodeStartDateBHSBT, iDARTLastPackageCollectionDateBH, iDARTFirstEpisodeStartDate,
iDARTLastEpisodeStartDate, iDARTFirstPackageCollectionDate, iDARTLastPackageCollectionDate
------ Other new variables:
NbTasPClinicVisits, InCareAtBeginning, TasPLCVDate, TasPLCVAppointmentDate, EverInCare, EverDiagnosedHIVPositive,
InCareAtEndPhase1, InTasPCareAtEndPhase1, ARTemisLastVL, ARTemisLastVLDate, TasPLastVL, TasPLastVLDate,
LastVL, LastVLDate, UndetectableVLAtEndPhase1
------ Variable updated due to changes in TasP definitions document:
SeenInTasPClinic, TasPInitiatedART, CareAtReferral, InCareAtEndPhase1, OnARTAtBeginning, OnARTAtReferral & OnARTAtEndPhase1
--- IQs dataset
------ New variables:
AgeAtIQ, NonEmploymentTypeRecoded, HighestEducationLevel2, CurrentMaritalStatus2, Employed, ProfessionalStatus, ActiveStatus
--- Visits dataset
------ Variable PreviousClinicVisitDate fixed
4.0.0 Initial release of version 4 (02 Sep 2015)
--- Inclusion of data collected up to the 15th of July 2015
--- New datasets:
------ Local Areas, Census Rounds, Exits
--- Exits
------ Introduction of distinction between Population and Clinic Exit.
------ Manual recoding has been performed for phase 1 exit forms. Cf. *Computed variables
--- Individuals dataset:
------ ExitedEndDataCollection and ExitTypeEndDataCollection now refers only to Population exit. (cf. Exits dataset)
------ CR* variables (per calendar round) have been replaced by CC* variables (per data collection cycle). Cf. Census Rounds dataset
------ Retention in TasP Care variables have been extended up to M36
--- Trial Statuses datasets:
------ Exit details have been removed and are now provided in Exits datasets.
------ Duplicated Trial Statuses (same visit date / same trial status) have been removed.
------ Exit Trial Statuses have been re-created from the Exits datasets importing only Population Exits.
------ Logical rounds are not used any more.
------ Introduction of the concepts of Census Rounds and Data Collection Cycles. (cf. Census Rounds dataset)
--- HHIs Dataset:
------ New variable: DataCollectionCycle
--- IQs dataset:
------ New variables in sexual behaviors component: MRPWillShareTheirStatus, MRPPartnerStatus, MRPLocalAreaCode, MRPIntercouseNTimesLast3Months, PP1WillShareTheirStatus, PP1PartnerStatus, PP1LocalAreaCode, PP1IntercouseNTimesLast3Months, PP2WillShareTheirStatus, PP2PartnerStatusPP2LocalAreaCode, PP2LocalAreaCode, PP2IntercouseNTimesLast3Months, HIVStatusWillingToShare, HIVStatusWhatIS
--- DBS results dataset:
------ New variables: DBSRank, ValidDBSRank, CalendarRound, DataCollectionCycle
--- CBCs dataset:
------ New variables: BaselineARTProviderOthSpec, WhyNoLongerOnARTOthSpec, HIVDrugRegimen
--- SCIs dataset:
------ New variables in sexual behaviors component: MRPWillShareTheirStatus, MRPPartnerStatus, MRPLocalAreaCode, MRPIntercouseNTimesLast3Months, PP1WillShareTheirStatus, PP1PartnerStatus, PP1LocalAreaCode, PP1IntercouseNTimesLast3Months, PP2WillShareTheirStatus, PP2PartnerStatusPP2LocalAreaCode, PP2LocalAreaCode, PP2IntercouseNTimesLast3Months
--- Individuals Consents dataset
------ Individual Consents has been reformatted to vertical layout where each consent given is visible as a row on its own and no longer be displayed in one row per individual with different items representing each consent given.
------ New variables includes: FormId, VisitId, VisitDate, IndividualResponse
--- SAEs Initial Notifications dataset:
------ New variables: VisitDate, NotificationDate, LastWeightDate, LastCD4CountDate, LastViralLoadDate, SerCritDateOfDeath, SAEOutcomeRecoverDate
--- SAEs Initial Notifications - Event details dataset:
------ New variables: DateInvestigatorAware, DateOfOnset, DateResolved
--- SAEs Initial Notifications - Medications dataset:
------ New variables: DateStarted, DateStopped
--- SAEs Complementary Notifications dataset:
------ New variables: VisitDate, NotificationDate, DateOfOnset, DateOfNewDiagnosis, DateDiscontinued, DateReintroduced, SAEOutcomeDeathDate, SAEOutcomeRecoverDate
--- SAEs Complementary Notifications - Medications dataset
------ New variables: VisitDate, DateStarted, DateStopped
4.1.0 Updated release of version 4 (16 Oct 2015)
--- Cut off point for datasets is still 15-Jul-2015 as with version 4.0.0
--- Contains changes to data as result of ongoing data cleaning that includes re-entry of EXIT forms
--- Initial release of Sequence Genomics dataset
4.2.0 Updated release of version 4 (25 Nov 2015)
--- Cut off point for datasets is still 15-Jul-2015 as with version 4.0.0
--- Contains changes to data as result of ongoing data cleaning
--- Initial release of Next Generation Sequence (NGS) datasets: NgsGenomics and MinorityVariants
--- All IQP forms are now also exported after a bug was fixed in the Pentaho transfromation
------ New items exported: MRPCondomOccasions, PP1CondomOccasions, PP2CondomOccasions
4.3.0 Updated release of version 4 (10 Dec 2015)
--- Cut off point for datasets is still 15-Jul-2015 as with version 4.0.0
--- Contains changes to data as result of ongoing data cleaning
------ Contains omitted Trial Statuses that has been recaptured from the fieldworker diaries
4.3.1 Updated release of version 4 (10 Dec 2015)
--- Cut off point for datasets is still 15-Jul-2015 as with version 4.0.0
--- Contains changes to data as result of ongoing data cleaning
--- Trial Statuses
------ New variable: Source
--- Trial Statuses
------ New variable: Source
5.0.0 Initial release of version 5 (09 Mar 2016)
--- Inclusion of data collected up to the 30th of December 2015
--- Contains changes to data as result of ongoing data cleaning
--- New datasets:
------ BMQ Survey, Refusals, NgsAssembQuality
---SampleGenomics:
------ New Variable: ResistanceType
6.0.0 Initial release of version 6 (22 Apr 2016)
--- Inclusion of data collected up to the 20th of April 2016
--- Contains changes to data as result of ongoing data cleaning
--- Individuals:
------ New Variables: CC7* variables, TasPBaselinePrevARTuse, TasPBaselineARTStatus
6.1.0 Updated release of version 6 (26 Apr 2016)
--- Inclusion of data collected up to the 26th of April 2016
--- Contains changes to data as result of ongoing data cleaning
6.1.1 Updated release of version 6 (26 Apr 2016)
--- Released new dataset LinkToCareTracker
7.0.0 Initial release of version 7 (27 Jun 2016)
--- Inclusion of data collected up to the 23rd of June 2016
--- Contains changes to data as result of ongoing data cleaning
--- Trial Statuses:
------ New Variables: ClosestID, ClosestIQWithin7Days
7.0.1 Updated release of version 7 data (27 Jun 2016)
--- Correct issues with Trial Status dataset
8.0.0 Initial release of version 8 (05 Jul 2016)
--- Inclusion of data collected up to the 5th of July 2016
--- Contains changes to data as result of ongoing data cleaning
9.0.0 Initial release of version 9 (06 Sep 2016)
--- Inclusion of data collected up to the 6th of September 2016
--- Contains changes to data as result of ongoing data cleaning
--- Changes to datasets:
------ Exits dataset:
--------- Updates to variables:DTHDateComputed,ExitDateComputed, TRODateComputed, LFUDateComputed, NMCDateComputed, OUTDateCompued
--------- New variable added: ExitDateComputedEstimated
------ Individuals dataset:
--------- Updates to variables: DateOfBirth
------ HIV Drug Treatments dataset:
--------- This dataset has been cleaned and treatments re-aligned by Dr Collins Iwuji
------ SampleGenomics dataset:
--------- New variable added: SeqId
9.0.1 Updated release of version 9 (06 Sep 2016)
--- Correction made to Visits dataset
--- Correction was made to the Exits dataset
10.0.0 Initial release of version 9 (06 Sep 2016)
--- Inclusion of data collected from the field and clinics
--- Contains changes to data as result of data cleaning
--- Lab data:
------ All Lab data have been reconcilled
------ All discordant serology results has been resolved
------ Missing ARTemis VL and CD4 from Feb 2016 till end of July 2016 has now been uploaded
10.0.0 Initial release of version 10 (29 Nov 2016)
--- Inclusion of data collected from the field and clinics
--- Contains changes to data as result of data cleaning
--- Lab data:
------ All Lab data have been reconcilled
------ All discordant serology results has been resolved
------ Missing ARTemis VL and CD4 from Feb 2016 till end of July 2016 has now been uploaded
10.1.0 Updated release of version 10 (29 Nov2016)
--- New datasets:
------ ACCDB Encounters, ACCDB Encouter Therapies
10.1.1 Updated release of version 10 (29 Nov2016)
--- Distance measurements updated in Locations dataset
--- Errors fixed on the HIV Drug Treatments dataset
10.2.0 Updated release of version 10 (29 Nov2016)
--- Corrected HIVDrugTreatments dataset
10.2.1 Updated release of version 10 (29 Nov2016)
--- Corrected Date formats for SAE datasets
11.0.0 Initial release of version 11 (27 Jan 2017)
--- Inclusion of data collected from the field and clinics
--- Contains changes to data as result of data cleaning
--- Changes to datasets:
------ Individuals:
--------- Pre-computed variables were removed namely:
------------ End of Phase 1 variables
------------ End of Data collection variables
------------ ART coverage in DoH is estimated only at the beginning of the trial (the estimates at all other dates will be done through the production of the cascade datasets, in order to harmonize all the computation)
------------ The computation of the cascade is not anymore developed in the Definition document (as it is now developed separately).
------------ Variables related to iDART
------------ Includes data clearing by Collins Iwuji
------ ExitFormDetails:
--------- Forms were removed for individuals exiting more than once with no contact visit in-between the exits.
------ iDART
--------- Dataset has been dropped from the list of analytical datasets
--- All data collected after a person was reported as being of No Mental Capacity (NMC) was removed
11.1.0 Updated release of version 11 (02 Feb 2017)
--- Rerun of all transformations
11.2.0 Updated release of version 11 (15 Feb 2017)
--- Updates to Exits dataset
11.3.0 Updated release of version 11 (13 Jun 2017)
--- Excluded under age individuals