code View

id 36
Title From Diaria to D_Events and D_Events_att
Type Migration 5 to 6
Highlight group
Description
Code

DIARIA in D_EVENTS

Diaria in DREAM 5 d_events in DREAM 6
iddiaria id_event
 idAnagrafica id_person
  
  domain =  'APPOINTMENT' 
 Data date_event
 Data date_apt
  event_type = 'VISIT'
 Data as dataexec date_apt_exe
  apt_status =  'APE-002'
Note ev_vm1
 usr_INS usr_ins
 usr_MOD usr_mod
 usr_DATAMOD usr_datamod

 

DIARIA to D_EVENTS_ATT    A_VISIT

Diaria in DREAM 5D_Events_att in DREAM 6
iddiariaid_event
idanagraficaid_person
  
 domain = 'A_VISIT'
Dataatt_date
[Sida stadio]vt1
Ped_Edemavt2
Ped_PercSTDvt3
Terapia_ARVvt5
Terapia_TBCvt6
Alturavn1
BMIvn2
breast_feedingvb1
Circonf_bracciovn3
CirconfCranicavn4
Circ_vitavn5
CondGivenvn6
CPTGivenvn7
DepoGivenvn8
DosesMissedvn9
DUMvd1
FCvn10
FRvn11
MoArtvn12
NextAppvd2
Ped_PERCHAvn13
Ped_PERCWAvn14
Ped_PERCWHvn15
Ped_ZSHAvn16
Ped_ZSWAvn17
Ped_ZSWHvn18
PERC_ADAvn19
PERC_ADFvn20
Pesovn21
PillCountvn22
Plica_subscapvn23
Plica_tricipitalevn24
PED_Measuredvb3
pregnantvb4
SideEffects_Novb2
SideEffects_Hpvb5
SideEffects_Livb6
SideEffects_Otvb7
SideEffects_Pnvb8
SideEffects_Skvb9
SideEffects_notevt4
TA_maxvn25
TA_minvn26
TCvn27
TBStatus_RxNovb10
TBStatus_RxYesvb11
TBStatus_Suspvb12
TBStatus_Novb13
Verifica_TBCvb14
VLsampletakenvb15
VLValuevn28

 

DIARIA to D_EVENTS_ATT  A_MOTORM

Diaria in DREAM 5D_Events_att in DREAM 6
iddiariaid_event
idanagraficaid_person
  
 domain = 'A_MOTORM'
Datadate_event 
usrMM_INSvt1
usrMM_MODvt2
usrMM_DATAMODvd1
MM1Assvb1
MM1Obsvb2
MM2Assvb3
MM2Obsvb4
MM3Assvb5
MM3Obsvb6
MM4Assvb7
MM4Obsvb8
MM5Assvb9
MM5Obsvb10
MM6Assvb11
MM6Obsvb12 

 

 

 

 

 
Ordine