code View

id 26
Title From TBC to D_Status
Type Migration 5 to 6
Highlight group
Description
Code

TBC to D_Status

TBC in DREAM 5

D_Status in DREAM 6Note
idTBCid_status 
idAnagraficaid_person 
   
 domain = 'TBSTA' 
DataIniziodate_started 
StatoTerapiastatus *
Motivostatus_reason 
TBTypestatus_type 
TBTraTypestatus_treat_type 
F2status_diag 
F1st_vt2 
FData_C1st_vt3 
usr_INSusr_ins 
usr_MODusr_mod 
usr_DATAMODusr_datamod 
 active1 if last

 

TBSTA * STATUS
TBC_PRE_COT
TBC_SI
TBC_SI_2
TBC_NO
 

 

ReferenceidKeyDescription (english)
TBC_EXAMSTBC_EX_RXXRay
 - -0 = not selected, 1 = No, 2 = Neg, 3 = Pos
TBC_DRUG_CLASSTBC_DC_TB12HRZE/4HR
TBC_DRUG_CLASSTBC_DC_TB1B2HRZE/4HRE
TBC_DRUG_CLASSTBC_DC_TB22HRZES/1HRZE/5HRE
TBC_DRUG_CLASSTBC_DC_MDRMDR TB
TBC_DRUG_CLASSTBC_DC_XDRXDR TB
 - - -
TBC_MOTIVE_YTBC_Y_NEWNew
TBC_MOTIVE_YTBC_Y_RELRelapse
TBC_MOTIVE_YTBC_Y_TAFTreatment after failure
TBC_MOTIVE_YTBC_Y_TALTFTreatment after lost to follow
TBC_MOTIVE_YTBC_Y_TRITransfer in
TBC_MOTIVE_YTBC_Y_OPTOther previously treated
 - - -
TBC_MOTIVE_NTBC_N_CURCured
TBC_MOTIVE_NTBC_N_COMTreatment completed
TBC_MOTIVE_NTBC_N_FAITreatment failure
TBC_MOTIVE_NTBC_N_DIEDeath
TBC_MOTIVE_NTBC_N_LTFULost to Follow-Up
TBC_MOTIVE_NTBC_N_NEVNot evalued
 - - -
TBC_DIATBC_SOSPETTASuspected TB
TBC_DIATBC_PULMPulmonary TB
TBC_DIATBC_XPULMExtrapulmonary TB
 - - -
TBC_PULMRMCD00000000014Respiratory TB bacter. and histol. confirmation
TBC_PULMRMCD00000000015Respiratory TB not confirmed bact. or hist.
TBC_PULMRMCD00000000018Miliary tuberculosis
 - - -
TBC_XPULMRMCD00000000016Tuberculosis of nervous system
TBC_XPULMRMCD00000002410Tuberculosis of bones and joints
TBC_XPULMRMCD00000002411Tuberculosis of genitourinary system
TBC_XPULMRMCD00000002412Tuberculous peripheral lymphadenopathy
TBC_XPULMRMCD00000002413TB of intestines, peritoneum and mesenteric glands
TBC_XPULMRMCD00000002414Tuberculosis of skin and subcutaneous tissue
TBC_XPULMRMCD00000002415Tuberculosis of eye
TBC_XPULMRMCD00000002416Tuberculosis of ear
TBC_XPULMRMCD00000002417Tuberculosis of adrenal glands
TBC_XPULMRMCD00000002418Tuberculosis of other specified organs

 

Ordine