code View

id 68
Title Patient treatments
Type Database 6.1
Highlight group
Description The d_status table records the status of a patient's membership in a particular program or service (treatment), or the the state of a particular condition that has a start and end date and can repeat over time
Code

(d_status the table definition is at the end of this page)

 

Assistance status

domain status_type status  date_started status description
ASSIS NULL DAYHOSP  datetime  Day Hospital
ASSIS NULL RICOVERO  datetime  Admission to hospital
ASSIS NULL HOMECARE  datetime  Home Care
ASSIS NULL RICOVEROHC  datetime  Home Care for hospital patients

 

Service status

domain status_type status  date_started status description
SERVICE NULL VCT  datetime Voluntary Counselling and Testing
SERVICE NULL ENDASS  datetime End of assistance
SERVICE NULL MCPC_C  datetime PTV for for Children
SERVICE NULL MCPC  datetime PTV for Mothers
SERVICE NULL TRANSIT  datetime Transit
SERVICE NULL CCHC  datetime  HAART
SERVICE NULL TBCARE  datetime  TB care
SERVICE NULL PEP  datetime  Post Exposition Prevention
SERVICE NULL NODREAM  datetime  General Medicine
SERVICE NULL PREP datetime  Pre-Exposure Prophylaxis

 

Breastfeeding women status (actually NOT USED!) 

domain status_type status  date_started status description
BFEED ANAG_EVENT YES  datetime  Yes, is breastfeeding
BFEED ANAG_EVENT NO  datetime  No

use instead:  vb1 field in d_events_att, domain 'A_VISIT'

 

Children: breastfeeding status

domain status_type status  date_started status description
FEED NULL TA_ARTIFIC  datetime  artificial feeding
FEED NULL TA_ALSENO  datetime  breastfeeding
FEED NULL TA_MISTO  datetime  mixed breastfeeding
FEED NULL NULL  datetime  not specified

 

ARV Therapy Status

domain status_type status  date_started  status reason status_treat_type st_vt1 description
TARV idLineaTarv
in LineeTarv table		 TARV_SI  datetime id reason of start  LIN07 = 1st line
LIN08 = 2nd line
LINT3 = 3d line		 Line description  ARV Therapy started
TARV idLineaTarv
in LineeTarv table		 TARV_NO  datetime id reason of start      ARV Therapy Stopped

 

TB Therapy Status

domain status_type status  date_started status description
TBSTA id reason of start TBC_SI
TBC_SI_2		  datetime Therapy started
Therapy started 2 line (NOT LONGER USED!)
TBSTA id reason of stop TBC_NO  datetime Therapy Stopped

 

other informations about TB Therapy

Reference  status_reason  description
TBC_MOTIVE_Y TBC_Y_NEW New
TBC_MOTIVE_Y TBC_Y_REL Relapse
TBC_MOTIVE_Y TBC_Y_TAF Treatment after failure
TBC_MOTIVE_Y TBC_Y_TALTF Treatment after lost to follow
TBC_MOTIVE_Y TBC_Y_TRI Transfer in
TBC_MOTIVE_Y TBC_Y_OPT Other previously treated
TBC_MOTIVE_N TBC_N_CUR Cured
TBC_MOTIVE_N TBC_N_COM Treatment completed
TBC_MOTIVE_N TBC_N_FAI Treatment failure
TBC_MOTIVE_N TBC_N_DIE Death
TBC_MOTIVE_N TBC_N_LTFU Lost to Follow-Up
TBC_MOTIVE_N TBC_N_NEV Not evalued

 

Reference  status_type  description
TBC_DIA TBC_SOSPETTA Suspected TB
TBC_DIA TBC_PULM Pulmonary TB
TBC_DIA TBC_XPULM Extrapulmonary TB
TBC_DIA TBC_NODIAG No Diagnosys

 

status_type  status_treat_type  description
TBC_PULM RMCD00000000014 Respiratory TB bacter. and histol. confirmation
TBC_PULM RMCD00000000015 Respiratory TB not confirmed bact. or hist.
TBC_PULM RMCD00000000018 Miliary tuberculosis
TBC_XPULM RMCD00000000016 Tuberculosis of nervous system
TBC_XPULM RMCD00000002410 Tuberculosis of bones and joints
TBC_XPULM RMCD00000002411 Tuberculosis of genitourinary system
TBC_XPULM RMCD00000002412 Tuberculous peripheral lymphadenopathy
TBC_XPULM RMCD00000002413 TB of intestines, peritoneum and mesenteric glands
TBC_XPULM RMCD00000002414 Tuberculosis of skin and subcutaneous tissue
TBC_XPULM RMCD00000002415 Tuberculosis of eye
TBC_XPULM RMCD00000002416 Tuberculosis of ear
TBC_XPULM RMCD00000002417 Tuberculosis of adrenal glands
TBC_XPULM RMCD00000002418 Tuberculosis of other specified organs

 

 domain  st_vt2  description
TBSTA RX0;BK0;XP0;LM0  not evalued
TBSTA RX0;BK0;XP0;LM2  LAM evalued and negative
TBSTA RX0;BK0;XP0;LM3  LAM evalued and positive
TBSTA RX0;BK0;XP0;LM4  LAM evalued and indeterminate
     For XRay:  0 = not selected, 1 = No, 2 = Neg, 3 = Pos

 

domain Reference st_vt3 Description
TBSTA TBC_DRUG_CLASS TBC_DC_TB1 2HRZE/4HR
TBSTA TBC_DRUG_CLASS TBC_DC_TB1B 2HRZE/4HRE
TBSTA TBC_DRUG_CLASS TBC_DC_TB2 2HRZES/1HRZE/5HRE
TBSTA TBC_DRUG_CLASS TBC_DC_MDR MDR TB
TBSTA TBC_DRUG_CLASS TBC_DC_XDR XDR TB

 

3HP/3RH TB Therapy Status

domain status_type status  date_started status description
TBC_3HP3RH   YES  datetime  3HP/3RH Therapy started
TBC_3HP3RH   NO  datetime  3HP/3RH Therapy stopped

 

Food supplement status

domain status_type status  date_started st_vd1 st_vt1 status description
FOODI FAL_1_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 once a week
FOODI FAL_2_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 twice a week
FOODI FAL_3_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 three times a week
FOODI FAL_4_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 four times a week
FOODI FAL_5_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 five times a week
FOODI FAL_6_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 six times a week
FOODI FAL_7_1SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 everyday
FOODI FAL_1_1MESE FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 Once a month
FOODI FAL_3_1MESE FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 three times per month
FOODI FAL_1_2SETT FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 once every two weeks
FOODI FAL_SOS FOOD_INT_YES  datetime end date
of treatment		 duration
of treatment		 as needed
FOODI  -  FOOD_INT_NO  datetime      Not in food integration

 

HIV Status

domain status_type status status_diag date_started status description
HIVST  VCT type * HIV_TEST    datetime  In testing
HIVST   HIV_INSEC    datetime  Insecure result
HIVST   HIV_NO    datetime  HIV Negative
HIVST   HIV_YES

HIV01 = 1
HIV02 = 2
HIV03 = 1+2
HIV04 = N.D.

  datetime  HIV Positive
HIVST   HIV_STBY    datetime  In standby
HIVST   HIV_NOTEVAL    datetime  Not evalued
HIVST *    VCT_MCPC      datetime  VCT in pregnancy
HIVST *    VCT_CCHC      datetime  VCT

 

Pregnancy status

domain status_type status  date_started status description
ST_PREGN NULL YES  datetime  in pregnancy
ST_PREGN NULL NO  datetime  not in pregnancy

 

Adherent Patient Programs

domain domain description status_type status  date_started status description
PAR_1MDELIVERY montly drug delivery ANAG_EVENT NO or YES  datetime  NO or YES
PAR_3MDELIVERY quarterly drug delivery ANAG_EVENT NO or YES  datetime  NO or YES
PAR_6MDELIVERY six-monthly drug delivery ANAG_EVENT NO or YES  datetime  NO or YES
PAR_FASTFLOW fast flow program ANAG_EVENT NO or YES  datetime  NO or YES
PAR_GAAC self help group ANAG_EVENT NO or YES  datetime  NO or YES
PAR_FAM_APRCH family approach ANAG_EVENT NO or YES  datetime  NO or YES

 

Prevention with Isoniazide status

domain status_type status status description  Linked Form ?
TBC_PRE_TPI ANAG_EVENT NO  No  FRM_TPT
TBC_PRE_TPI ANAG_EVENT YES  Yes, in treatment  FRM_TPT

 

Prevention with Cotrimoxazolo status

domain status_type status status description
TER_COT ANAG_EVENT NO  No
TER_COT ANAG_EVENT YES  Yes, in treatment

 

Prevention with Fluconazole status

domain status_type status status description
TER_FLU ANAG_EVENT NO  No
TER_FLU ANAG_EVENT YES  Yes, in treatment

 

Treatment with Fluconazole status

domain status_type status status description
TREAT_FLU ANAG_EVENT NO  No
TREAT_FLU ANAG_EVENT YES  Yes, in treatment

 

Treatment for diabetes mellitus

domain status_type status status description
TREAT_DM ANAG_EVENT NO  No
TREAT_DM ANAG_EVENT YES  Yes, in treatment

 

Treatment for Essential Arterial Hypertension (HTA)

domain status_type status status description
TREAT_HTA ANAG_EVENT NO  No
TREAT_HTA ANAG_EVENT YES  Yes, in treatment

 

Optometry Treatment

domain status_type status status description
TREAT_OPTOMETRY  ANAG_EVENT NO  No
TREAT_OPTOMETRY ANAG_EVENT YES  Yes, in treatment

 

CACUM treatment

domain status_type status status description
TREAT_CACUM  ANAG_EVENT NO  No
TREAT_CACUM ANAG_EVENT YES  Yes, in treatment

 

Epilepsy treatment

domain status_type status status description  Linked FORM ?
TREAT_EPILEPSY  ANAG_EVENT NO  No  FRM_EPI_THER
TREAT_EPILEPSY ANAG_EVENT YES  Yes, in treatment  FRM_EPI_THER

 

Asthma treatment

domain status_type status status description
TREAT_ASTHMA  ANAG_EVENT NO  No
TREAT_ASTHMA ANAG_EVENT YES  Yes, in treatment

 

Prenatal treatment 

domain status_type status status description
TREAT_PRENATAL  ANAG_EVENT NO  No
TREAT_PRENATAL ANAG_EVENT YES  Yes, in treatment

 

HIV Advanced patients

domain status_type status status description
TREAT_HIVADVAN  ANAG_EVENT NO  No
TREAT_HIVADVAN  ANAG_EVENT YES  Yes, in treatment

 

 

d_status table

Column Name Type Description
id_status (PK) (not null) CHAR (15)  Primary Key 
id_person (not null) CHAR (15)  id of the patient 
domain (not null) NVARCHAR(15)  domain (see below) 
status NVARCHAR(20)  status
status_type NVARCHAR(20)  status type
status_reason NVARCHAR(15)  reason for starting or ending state 
status_treatment NVARCHAR(15)  
status_treat_type NVARCHAR(15)  
status_diag NVARCHAR(15)  
date_started DATE  state start date
id_evaluation NVARCHAR(15)  id_evaluation in D_evaluation table
st_vn1 FLOAT  float field
st_vn2 FLOAT  float field
st_vd1 DATETIME  datetime field
st_vd2 DATETIME  datetime field
st_vt1 NVARCHAR(255)  text field
st_vt2 NVARCHAR(255)  text field
st_vt3 NVARCHAR(255)  text field
st_vt4 NVARCHAR(255)  text field
st_vt5 NVARCHAR(255)  text field
st_vb1 BIT  boolean field
st_vb2 BIT  boolean field
st_vm1 NVARCHAR(max)  note field
st_vm2 NVARCHAR(max)  note field
usr_INS NVARCHAR(20)  user who entered
usr_MOD NVARCHAR(20)  user who edited
usr_DATAMOD DATETIME  modification date
usr_DEL NVARCHAR(20)  user who deleted
usr_DATADEL DATETIME  date of elimination
first BIT  true if first record
restart BIT  true if restarted 
active BIT  true if last status
deleted BIT  true if deleted
Time_Stamp DATETIME  

 
Ordine 20