wiki:Hicdep_1.80/TableArt

Version 1 (modified by admin, 3 years ago) (diff)

Copy from Hicdep 1.70

tblART - Antiretroviral treatment

holds type of antiretroviral drug, start and stop dates and reason for stopping

Core fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name

Format

Description

PATIENT

character (or numeric if possible)

identifies patient

ART_ID

character. see coding table for valid codings.

represents the antiretroviral treatment

ART_SD

yyyy-mm-dd

date of initiation of treatment

ART_ED

yyyy-mm-dd

date of stopping treatment

ART_RS

character. see coding table for valid codings.

reason for stopping treatment

Additional fields

Depending on the aim of the study it might be needed to gather both the dosage and the frequency of the dosage taken. However many cohorts do not collect this date and thus these fields are optional.

Field name

Format

Description

ART_DO

numeric

Dosage (mg or mL) per intake unless ART_FR=-1

ART_FR

numeric:

  • -1 = Frequency not known. ART_DO contains dosage per day
  • 0.33 = 1 dose every third day
  • 0.5 = 1 dose every second day
  • 1 = 1 daily dose/qd
  • 2 = 2 daily doses/bid
  • 3 = 3 daily doses/tid
  • 4... = code gives number of daily doses

Frequency

It may also be necessary to record the start and end time:

Field name

Format

Description

ART_ST

hh:mm

Start hour and minute of the day

ART_ET

hh:mm

Stop hour and minute of the day

QA Checks

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblARTWithinTableAW001ART_RS not null, but end date NULLYES
tblARTWithinTableAW002ART_RS null but end-date non NULLYES
tblARTWithinTableAW003ART_RS=98 yet ART_OTH is nullEPPICC NO
tblARTWithinTableAW004Duplicate records for same cohort, patient, art_id and art_sdYES
tblARTWithinTableAW005Dose out of range for those dose units and frequencyPaediatricOnlyYES
tblARTWithinTableAW006Missing art_fr PaediatricOnlyYES
tblARTWithinTableAW007Missing art_do PaediatricOnlyYES
tblARTWithinTableAW008Missing patient YES
tblARTWithinTableAW009Missing art_id YES
tblARTWithinTableAW010Missing art_sdYES
tblARTWithinTableAW011Overlapping periods of same drugYES
tblARTWithinTableAW012Double reporting - records reported for both combination drugs and their components YES
tblARTWithinTableAW013Periods of overlap of contra-indicated drugsYES
tblARTWithinTableAW014Restart of same drug without a stop YES
tblARTWithinTableAW015ART_SD greater than or equal to ART_EDYES
tblARTCrossTableAC001Patient has no record in table BASYES
tblARTCrossTableAC002Records exist in tblART yet RECART_Y=0 in tblBASYES