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_SD_A	character: see coding of date precision	precision of date "Initiation of Treatment"
ART_ED	yyyy-mm-dd	date of stopping treatment
ART_ED_A	character: see coding of date precision	precision of date "Stopping of 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_RS2	character. see coding table for valid codings.	Second reason for stopping treatment
ART_RS3	character. see coding table for valid codings.	Third reason for stopping treatment
ART_RS4	character. see coding table for valid codings.	Fourth reason for stopping treatment
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
GENERIC	numeric: 1 = Branded 2 = Generic 9 = Unknown	Was this a branded or generic drug?
ART_FORM	numeric: 1 = Tablet/capsule 2 = Syrup/Suspension 3 = Combination of 1 and 2 4 = Powder 5 = Subcutaneous 6 = Intravenous 7 = Intramuscular 9 = Unknown	What formulations of the drug was given?
ART_COMB	numeric: 0 = Individual drug 1 = Part of a fixed-dose combination 9 = Unknown	Was the drug given as part of a fixed-dose combination?
ART_START_RS	numeric: see coding table for valid codings	Reason for starting/receiving ART

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	Is HICDEP
AllTables	CrossTable	ATC001	any date in database after DEATH_D in tblLTFU		Yes
AllTables	CrossTable	ATC002	any date in database after DROP_D in tblLTFU		Yes
AllTables	CrossTable	ATC003	any date in database before BIRTH_D in tblBAS		Yes
AllTables	CrossTable	ATC004	any date in database in the future		Yes
AllTables	CrossTable	ATC005	patients submitted previously who have been missed out		Yes
AllTables	CrossTable	ATC006	Any fields not coded as coding lists on table definition		Yes
tblART	WithinTable	AW001	ART_RS not null, but end date NULL		Yes
tblART	WithinTable	AW002	ART_RS null but end-date non NULL		Yes
tblART	WithinTable	AW003	ART_RS=98 yet ART_OTH is null	EPPICC	No
tblART	WithinTable	AW004	Duplicate records for same cohort, patient, art_id and art_sd		Yes
tblART	WithinTable	AW005	Dose out of range for those dose units and frequency	PaediatricOnly	Yes
tblART	WithinTable	AW006	Missing art_fr	PaediatricOnly	Yes
tblART	WithinTable	AW007	Missing art_do	PaediatricOnly	Yes
tblART	WithinTable	AW008	Missing patient		Yes
tblART	WithinTable	AW009	Missing art_id		Yes
tblART	WithinTable	AW010	Missing art_sd		Yes
tblART	WithinTable	AW011	Overlapping periods of same drug		Yes
tblART	WithinTable	AW012	Double reporting - records reported for both combination drugs and their components		Yes
tblART	WithinTable	AW013	Periods of overlap of contra-indicated drugs		Yes
tblART	WithinTable	AW014	Restart of same drug without a stop		Yes
tblART	WithinTable	AW015	ART_SD greater than or equal to ART_ED		Yes
tblART	CrossTable	AC001	Patient has no record in table BAS		Yes
tblART	CrossTable	AC002	Records exist in tblART yet RECART_Y=0 in tblBAS		Yes