code View

id 81
Title Patient data
Type Database 6.1
Highlight group
Description Patient data is stored in d_person and d_person_att tables
Code

D_PERSON

 Column name Description
 id_person patient unique software ID
 id_dream patient ID Folder
 id_national national ID
 id_usr1 other ID
 id_usr2 other ID
 pe_surname surname
 pe_name name
 pe_dob date of birth
 pe_birth_place birth place
 pe_sex sex
 pe_address address
 pe_phone phone
 pe_marital_status marital status
 date_started assistance start date (in absolute)
 date_stopped end of assistance
 reason_stopped reason of end of assistance
  
MF_ABANDONAbandon
MF_ALTROOther
MF_DECESSODeath
MF_ENDTREATEnd of treatment
MF_FINEMCPCEnd of PMTCT
MF_HIVNEGHIV Negative
MF_PEP_ENDEnd of PEP
MF_PREP_CONUNVLUndetectable viral load
MF_PREP_LOWRISKLow risk of exposure
MF_PREP_NOADHPoor adherence
MF_PREP_RENDISFRenal dysfunction
MF_RIFIUTARefusal of assistance
MF_TRASFERTransferred
MF_UNCONFUnconfirmed HIV status
 note_stopped note for end of assistance
 date_assistance_start assistance start date in the current center
 pe_note general notes
 pe_medical_note medical notes
 pe_district district
 pe_province province
 pe_town town
 pe_area area
 pe_father_name father name
 pe_mother_name mother name
 pe_center_ref center of reference
 pe_document document
 pe_guardianname guardian name
 pe_guardianphon guardian phone
 pe_guardianrela guardian relationship
 pe_id_person_mo mother unique ID (software)
 pe_born_program PMTCT_C for children born in vertical prevention
 PMTCT_E for exposed children
 usr_ins user who inserted
 usr_mod user who modified
 usr_datamod date of last modify
 deleted = true if deleted

 

D_PERSON_ATT ( domain =  'A_PEOPL')

 Column name Description
id_person 
domain =  'A_PEOPL' 
vt1 not used
vt2 destination center when transfered
vt3destination center ID
vt4 
vt5 not used
vt6 not used (Ex HIV type)
vt7 id_person of consort
vt8 not used
vt9 not used
vt10 not used
vt11 not used
vt12 not used
vt13 center of origin
vt14 center of origin ID
vt15 smoker ?
vn1 Abortos
vn2 live children
vn3 ID of assistant
vn4 children
vn5 times she has given birth
vd1 
vd2 not used
vd3 water filter first
vd4 water filter last
vd5 water filter change in date
vb1 Agree to FUP
vb2  not used
vb3  not used
vb4 Water filter given

 

D_PERSON_ATT ( domain =  'A_PEDIATRIC')

 Column name Description
id_person 
domain =  'A_PEDIATRIC' 
vt1 ID Father
vt2 Pregnancy ID
vn1 height at birth
vn2 APGAR
vn3 APGAR 2
vn4 birth weight
vd1 time of birth
vd2 nevirapine date
vd3 nevirapine time

 

 

 

 

 

 

 

Ordine 1