code View

id 68
Title Patient's Status
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, or the status of a particular condition
Code

d_status table

Column NameTypeDescription
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) 
statusNVARCHAR(20) status
status_typeNVARCHAR(20) status type
status_reasonNVARCHAR(15) reason for starting or ending state 
status_treatmentNVARCHAR(15) 
status_treat_typeNVARCHAR(15) 
status_diagNVARCHAR(15) 
date_startedDATE state start date
st_vn1FLOAT float field
st_vn2FLOAT float field
st_vd1DATETIME datetime field
st_vd2DATETIME datetime field
st_vt1NVARCHAR(255) text field
st_vt2NVARCHAR(255) text field
st_vt3NVARCHAR(255) text field
st_vt4NVARCHAR(255) text field
st_vt5NVARCHAR(255) text field
st_vb1BIT boolean field
st_vb2BIT boolean field
st_vm1NVARCHAR(max) note field
st_vm2NVARCHAR(max) note field
usr_INSNVARCHAR(20) user who entered
usr_MODNVARCHAR(20) user who edited
usr_DATAMODDATETIME modification date
usr_DELNVARCHAR(20) user who deleted
usr_DATADELDATETIME date of elimination
firstBIT true if first record
restartBIT true if restarted 
activeBIT true if last status
deletedBIT true if deleted
Time_StampDATETIME 

 

Assistance status

domaindomain descriptionstatus_typestatusstatus description
ASSISAssistance regimeNULLDAYHOSP Day Hospital
ASSISNULLRICOVERO Admission to hospital
ASSISNULLHOMECARE Home Care
ASSISNULLRICOVEROHC Home Care for hospital patients

 

Service status

domaindomain descriptionstatus_typestatusstatus description
SERVICEservice offeredNULLVCTVoluntary Counselling and Testing
SERVICENULLENDASSEnd of assistance
SERVICENULLMCPC_CPTV for for Children
SERVICENULLMCPCPTV for Mothers
SERVICENULLTRANSITTransit
SERVICENULLCCHC HAART
SERVICENULLTBCARE TB care
SERVICENULLPEP Post Exposition Prevention
SERVICENULLNODREAM General Medicine

 

Breastfeeding women status

domaindomain descriptionstatus_typestatusstatus description
BFEEDbreastfeedingANAG_EVENTYES Yes, is breastfeeding
BFEEDANAG_EVENTNO No

 

Children: breastfeeding status

domaindomain descriptionstatus_typestatusstatus description
FEEDbreastfeeding that the baby is followingNULLTA_ARTIFIC artificial feeding
FEEDNULLTA_ALSENO breastfeeding
FEEDNULLTA_MISTO mixed breastfeeding
FEEDNULLNULL not specified

 

ARV Therapy Status

domaindomain descriptionstatus_typestatusstatus reasonstatus_treat_typest_vt1description
TARV ARV Therapyid reason of startTARV_SIid reason of status LIN07 = 1st line
LIN08 = 2nd line
LINT3 = 3d line
Line description ARV Therapy started
TARVid reason of stopTARV_NO    ARV Therapy Stopped

 

TB Therapy Status

domaindomain descriptionstatus_typestatusstatus description
TBSTA TB Therapyid reason of startTBC_PRE_COT
TBC_SI
TBC_SI_2
Prev. with Cotr.
Therapy started
Therapy started 2
TBSTAid reason of stopTBC_NOTherapy Stopped
 

 

  status_reason 
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
   
  status_type 
TBC_DIATBC_SOSPETTASuspected TB
TBC_DIATBC_PULMPulmonary TB
TBC_DIATBC_XPULMExtrapulmonary TB
TBC_DIATBC_NODIAGNo Diagnosys
   
  status_treat_type 
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

 

Food supplement status

domaindomain descriptionstatus_typestatusstatus description
FOODIfood supplementFAL_1_1SETTFOOD_INT_YESonce a week
FOODIFAL_2_1SETTFOOD_INT_YEStwice a week
FOODIFAL_3_1SETTFOOD_INT_YESthree times a week
FOODIFAL_4_1SETTFOOD_INT_YESfour times a week
FOODIFAL_5_1SETTFOOD_INT_YESfive times a week
FOODIFAL_6_1SETTFOOD_INT_YESsix times a week
FOODIFAL_7_1SETTFOOD_INT_YESeveryday
FOODIFAL_1_1MESEFOOD_INT_YESOnce a month
FOODIFAL_3_1MESEFOOD_INT_YESthree times per month
FOODIFAL_1_2SETTFOOD_INT_YESonce every two weeks
FOODIFAL_SOSFOOD_INT_YESas needed
FOODI - FOOD_INT_NO Not in food integration

 

HIV Status

domaindomain descriptionstatus_typestatusstatus description
HIVST HIV status VCT type *HIV_TEST In testing
HIVST HIV_INSEC Insecure result
HIVST HIV_NO HIV Negative
HIVST HIV_YES HIV Positive
HIVST HIV_STBY In standby
HIVST*    VCT_MCPC  VCT in pregnancy
HIVST*    VCT_CCHC  VCT

 

Pregnancy status

domaindomain descriptionstatus_typestatusstatus description
ST_PREGN pregnancyNULLYES in pregnancy
ST_PREGNNULLNO not in pregnancy

 

Adherent Patient Programs

domaindomain descriptionstatus_typestatusstatus description
PAR_3MDELIVERYquarterly drug deliveryANAG_EVENTNO No
PAR_3MDELIVERY ANAG_EVENTYESYes
PAR_6MDELIVERYsix-monthly drug deliveryANAG_EVENTYESYes
PAR_6MDELIVERY ANAG_EVENTNO No
PAR_FASTFLOWfast flow programANAG_EVENTNO No
PAR_FASTFLOW ANAG_EVENTYESYes
PAR_GAACself help groupANAG_EVENTNO No
PAR_GAAC ANAG_EVENTYESYes

 

Prevention with Isoniazide status

domaindomain descriptionstatus_typestatusstatus description
TBC_PRE_TPIPrevention with isoniazideANAG_EVENTNO No
TBC_PRE_TPIANAG_EVENTYES Yes

 

Prevention with Cotrimoxazolo status

domaindomain descriptionstatus_typestatusstatus description
TER_COTPrevention with CotrimoxazoloANAG_EVENTNO No
TER_COTANAG_EVENTYES Yes

 

Prevention with Fluconazole status

domaindomain descriptionstatus_typestatusstatus description
TER_FLUPrevention with FluconazoleANAG_EVENTNO No
TER_FLUANAG_EVENTYES Yes

 

 

Ordine 20