| 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 (ID2 in the patient's FORM) |
| id_usr2 |
other ID (ID3 in the patient's FORM) |
| 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 |
