TMT-Tracing Microbacteria Transimission - 2012

TMT vaccination form. Discontinued use in round 2 from Dec 2013 when TMTC form introduced: Unique identifier STID

tmt_tmtv links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
gp_skintest stid

Information from TMT1 form on households stayed at overnight: Unique identifier STID+RECNO

tmt_tmtcnightvisits links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmtc stid

Information from TMT1 form on households stayed at during the day: Unique identifier STID+RECNO

tmt_tmtcdayvisits links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmtc stid

Main body of information from TMTC form. Only the STID is required as the unique identifier because a child only gets a TMTC form in round 2 from Dec 2013: Unique identifier STID

tmt_tmtc links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmtcdayvisits stid
tmt_tmtcnightvisits stid
tmt_tmt1 stid
tmt_tmtconsent1 stid

Information from TMT1 form on households stayed at overnight: Unique identifier STID+RECNO

tmt_tmt1nightvisits links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmt1 stid

Information from TMT1 form on households stayed at during the day: Unique identifier STID+RECNO

tmt_tmt1dayvisits links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmt1 stid

Information from TMT1 form on contacts: Unique identifier STID+IDCONTAC

tmt_tmt1contacts links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmt1 stid

Main body of information from TMT1 form. Only the STID is required as the unique identifier because a child identified as “recently infected” in Round 1 will not be rescreened in Round 2: Unique identifier STID

tmt_tmt1 links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmtc stid
ser_specimen stid+cno
tmt_contactlist stid+cno
tmt_tmtconcent2 stid
gp_inh stid
tmt_tmt1contacts stid
tmt_tmt1nightvisits stid
tmt_tmt1dayvisits stid

Contacts listing produced by program: Unique identifier STID

tmt_tmtcontactlist links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmt1 indet

Information from consent form for adult, consent to TB screening.Uniquely identified by stid+cno as we may end up screening people more than once e.g. if an individual is identified as a potential source of
infection in more than one child's listing of potential sources then we would rescreen people if screened more than 3 months ago: Unique identifier STID

Information from consent form for child - consent to be bled and contacts followed up. Only the STID is required as the unique identifier because a child identified as “recently infected” in Round 1 will not be rescreened in Round 2 :Unique identifier STID

tmt_consent2 links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
tmt_tmt1 stid
tmt_tmtconsent1 stid
gen_identity ident

Information from consent form 3 for babies under-one in TMT study who have a negative skin test : Unique identifier STID+CNO

tmt_consent3 links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
gp_skinntest stid+cno
ser_specimen stid+cno
tmt_tmtconcent1 stid

Information from consent form for child -consent to skintest. Children may have repeat skin tests in Round 2, thus the table is Unique identifier STID stid+cno

tmt_consent1 links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
gp_skinntest stid+cno
tmt_tmtc stid
tmt_tmtconsent3 stid
gen_identity ident
tmt_tmtconcent2 stid