| Code |
| d_person |
personal data |
| d_person_att |
additional records linked via the id_person key |
| |
|
| d_events |
punctual events, which occurred on a specific date, linked via the id_person key.
Such as appointments, tests, screenings, drug delivery, etc
|
| d_events_att |
additional records linked via the id_event key to the d_events record
(for example medicines prescribed or delivered, blood test results, diagnoses or symptoms relating to a particular event) |
| |
|
| d_evaluations |
similar to d_events but designed to record evaluation data and data collection forms |
| d_evaluations_att |
|
| |
|
| d_status |
programs and treatments to which the patient can be enrolled or in any case conditions that have a beginning and a possible end over time
(such as a drug treatment, a special care program or service, a period of pregnancy) |
in the attribute tables the different records are identified by the "domain" and also "event_type" fields .
Below are some examples:
| DATABASE TABLES for patient data |
| Data |
domain |
event_type |
table |
| Personal data |
|
|
d_person |
| Personal data details |
A_PEOPL |
|
d_person_att |
| Pediatric data |
A_PEDIATRIC |
|
d_person_att |
| Family unit detail |
|
|
d_person_fam |
| |
|
|
|
| Visits |
APPOINTMENT |
VISIT |
d_events |
| Posology |
A_DPRES |
|
d_events_att |
|
| Diagnosis |
A_VDIAG |
|
d_events_att |
| Symptoms |
A_VSYMP |
|
d_events_att |
|
| Drug delivery |
APPOINTMENT |
APP_DRUGS |
d_events |
|
| Drug delivery details |
A_DRUGS |
|
d_events_att |
| Pregnancies |
PREGNANCY |
|
d_events |
|
| Various indicators |
|
|
d_events |
|
| Appointments |
APPOINTMENT |
|
|
|
| Exams prescriptions |
A_EXAMS_PRESC |
|
d_events_att |
|
| Exams results |
A_EXAMS_HEMOG,
A_EXAMS_BIOCH,
A_EXAMS_VLOAD,
A_EXAMS_OTHER,
A_EXAMS_CD4CD, |
|
d_events_att |
| Urgent Checks details |
A_VERIFY |
|
d_events_att |
| |
|
|
|
| Type of nutrition |
FEED |
|
d_status |
| TB therapy status |
TBSTA |
|
d_status |
| Food integration status |
FOODI |
|
d_status |
| Assistance regime |
ASSIS |
|
d_status |
| Service |
SERVICE |
|
d_status |
| ARV Therapy status |
TARV |
|
d_status |
| HIV status |
HIVST |
|
d_status |
| Various indicators (TER_COT , TBC_PRE_TPI , TER_FLU , PAR_3MDELIVERY, PAR_FASTFLOW, PAR_GAAC, PAR_6MDELIVERY) |
ANAG_EVENT |
|
d_status |
| |
|
|
|
|
| |
|
|
|
| SIDA Stage |
STAGE |
|
d_evaluations |
| Social data |
SOCIAL |
|
d_evaluations |
| Social data details |
A_SOC_COND |
|
d_evaluations_att |
| |
|
|
|
| assistants |
REF_ASSIST |
|
d_reftables |
| neighborhoods |
REF_NEIGHB |
|
d_reftables |
| centers of reference |
REF_CENTRE |
|
d_reftables |
| festivity |
REF_FESTIV |
|
d_reftables |
other tables (for the storage of medicines and food and for other uses):
| table name |
description |
| _DbCodici |
table of counters used by primary keys |
| _DbInfo |
table used to store the configuration |
| Farmaci |
drugs |
| Composti |
drug compounds |
| Composti_PrincipiAttivi |
active ingredients in drug compounds |
| CentriMovimento |
centers of origin and destination of movements |
| DiagnosiSintomi |
diagnosis and symptoms |
| DiagnosiSintomi_Sinonimi |
diagnosis and symptoms: synonyms |
| dream_roles |
users's roles |
| dream_users |
users |
| events |
awareness events and screening |
| far_consegnabile |
drugs's deliverable forms |
| far_ordini |
warehouse order table , details for drugs |
| far_ordini_Main |
warehouse order table for drugs |
| Farmaci_Blocchi |
blocked drugs |
| farmaci_carico_Main |
warehouse load |
| farmaci_carico |
detail of the warehouse load |
| Farmaci_Confezionamento |
pharmaceutical packaging |
| Farmaci_Consumo |
minimum and optimal quantity of drugs in stock |
| food_carico_Main |
warehouse order table for food |
| food_carico |
warehouse order table , details for food |
| FoodMovement |
warehouse movements for food |
| FoodPack |
food packs |
| FoodStdPack |
predefined food packs |
| FoodType |
kind of food |
| HomeCareEse |
home care executed |
| HomeCarePre |
home care prescriptions |
| HomeCareZone |
home care zone |
| HomeCareZoneBairro |
relations between areas and neighborhoods |
| LineeTarv |
TARV lines |
| LineeTarv_PrincipiAttivi |
TARV lines, active ingredients |
| PrincipiAttivi |
active ingredients |
| profili_prescrizione |
blood test prescription profiles |
| Raggruppamenti |
drug groupings |
| rangevaloriesami |
range limits for exam values |
| UnitaDiMisura |
unit of measure |
| UnitaDiMisura_Rapporti |
unit of measure ratios |
|
