Version 7 (modified by stels, 6 years ago) (diff)

add changes for 1.50

Change log

Version 1.50

Version 1.30

  • tblART: Updated list of drugs
  • tblAE:
    • added EVENT_ID as unique identifier and link to detailed tables for each event (see 1) – this replaces the optional AE_NO field.
    • added AE_SPEC to further specify an event by coding
    • a series of basic verification fields have been added to allow for tracking of event status for source documentation availability, verification of documentation (through monitoring) and final approval of the event.
    • in AE_R_Y - Relation to treatment: added more detailed codes.
  • tblLAB: added several codes for various biomarker tests.
  • tblLAB_CD4: added CD4_U as optional fields to discriminate between CD4% and CD4 cell count, so that the tblLAB_CD4 table can hold both types of measurements.
  • tblLAB_VIRO: added several codes for various virology and serology tests.
  • CaseDefinitions updated with end stage renal disease, chronic liver disease and non-AIDS defining malignancies

1:Detailed table definitions for the D:A:D events are available at

Version 1.25

  • tblART: Updated list of drugs
  • tblMED: Updated list of drugs
  • tblDIS:
    • Changed wording for CANO to ‘Candidiasis, oesophageal, bronchi, trachea, or lungs’
    • Added COCC - Coccidioidomycosis, disseminated or extrapulmonary
  • tblLAB: Added LAB_ST as additional field to code for type of specimen used for the measurement
  • tblLAB_CD4: Added CD4_U as additional field so the table can hold both percentage and absolute CD4 measurements
  • tblLAB_RNA: Added RNA_UL (upper limit of detection) to the list of additional fields.
  • Added more viral assays to the list of RNA_T codes
  • tblLAB_VIRO: Added unit field to tblLAB_VIRO into the general format and VS_LL (lower limit of detection), VS_UL (upper limit of detection) and VS_T (type of test) and list of tests to the list of additional fields.
  • tblLTFU: Added DEATH_RC# to code for causal relation of the DEATH_R# code to the death in order to comply with CoDe and still maintain a format to be used for cohorts not using CoDe. ICD10_# fields have been moved to the list of additional fields.

Version 1.21

Code Coding for Reason of Stopping Treatment
1.1 Virological failure
1.2 Partial virological failure
1.3 Immunological failure – CD4 drop
1.4 Clinical progression
90 Side effects – any of the above but unspecified
90.1 Comorbidity
92.1 Simplified treatment available
92.2 Treatment to complex
92.3 Drug interaction
93.1 Structured Treatment Interruption (STI) – at high CD4
94.1 Non-compliance
96 Pregnancy
97 Study treatment

Version 1.2

Version 1.1

  • tblBAS:
    • The table was split into tblBAS and tblLTFU. tblLTFU holds data on death and drop-out
    • Renamed LOS_Y to LOSS_Y
    • Renamed GAI_Y to GAIN_Y
  • tblLAB_BLP:
    • Renamed table to tblLAB_BP
    • Renamed BLP_D to BP_D
    • Renamed BLP_SYS to BP_SYS
    • Renamed BLP_DIA to BP_DIA
    • Renamed BLP_U to BP_U

Version 1.00

  • tblBas:
    • Renamed BIRTHDAY to BIRTH_D
    • Renamed FIRSTVIS to FRSVIS_D
    • Renamed REC_ART to RECART_Y
  • tblLAB:
    • LAB_U: has been dropped – please use the “unit codes/strings” as that is a safer way to code/represent the units – prefixing all “unit codes/strings” with a numeric value should however make analysis easier.
  • tblLAB_VIRO:
    • New table added to capture mainly hepatitis measurements/tests
  • tblLAB_RES:
    • SEQ_DT was added to capture the time of sequencing in order to facilitate quality assurance of the data for contamination that might have happened during the sequencing.
  • tblLAB_RES_LVL1:
    • Renamed SEQ_ST to SEQ_STAR
    • SEQ_STOP: Added to the table to specify at which position in the sequence the sequencing was terminated
  • tblLAB_RES_LVL2:
    • The table has been optimised for ease of analysis so that the mutation codes have been split into their components of amino acid position, sub position for insertions and 4 our more fields for mixtures of amino acids found in the sample

Version 0.50 and 0.90

First public versions that incorporated comments and corrections received from attendees at the 7th International Workshop on HIV Observational Databases, March 29th-30th 2003, Fiuggi, Italy and Stephen Hart.

Version 0.38

Version presented at 7th International Workshop on HIV Observational Databases, March 29th-30th 2003, Fiuggi, Italy