code View

id 71
Title DREAM 6 Tables
Type Database 6.1
Highlight group
Description description of the main tables used by the dream software
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

 
Ordine 0