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 ID (software ID)
 id_dream  patient ID Folder (DreamCen ID)
 id_national  national ID
 id_usr1  other ID
 id_usr2  other ID 2
 pe_surname  surname
 pe_name  name
 pe_dob  date of birth
 pe_birth_place  birth place
 pe_sex  sex (M / F)
 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_ABANDON Abandon
MF_ALTRO Other
MF_DECESSO Death
MF_ENDTREAT End of treatment
MF_FINEMCPC End of PMTCT
MF_HIVNEG HIV Negative
MF_PEP_END End of PEP
MF_PREP_CONUNVL Undetectable viral load
MF_PREP_LOWRISK Low risk of exposure
MF_PREP_NOADH Poor adherence
MF_PREP_RENDISF Renal dysfunction
MF_RIFIUTA Refusal of assistance
MF_TRASFER Transferred
MF_UNCONF Unconfirmed 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  TARV STATUS (saved but not used)
vt2  destination center when transfered
vt3  destination center ID
vt4  children increment (system)
vt5  Preferred doctor id (EX Food Integration Freq )
vt6  not used (Ex HIV type)
vt7  id_person of consort
vt8  Last ASSISTANCE  (saved but not used)
vt9  Last FOODINT  (saved but not used)
vt10  Last idTARV (saved but not used)
vt11  Last SERVICE  (saved but not used)
vt12  Last HIV  (saved but not used)
vt13  center of origin
vt14  center of origin ID
vt15  smoker ?
vt16  email address
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