code View

id

45

Title

From Esami to d_events_att

Type

Migration 5 to 6

Highlight group

Description

Code

Hemogramma exams

DREAM 5	DREAM 6
idEsami	id_event
idanagrafica	id_person
	domain = A_EXAMS_HEMOG

Data	att_date (do not use !)
FLDEX6 - BAS2 %	vn1
FLDEX3 - BAS	vn2
CHGM	vn3
FLDEX5 - EOS2 %	vn4
FLDEX2 - MON2 %	vn5
Eritro	vn6
Hema	vn7
Hemo	vn8
HGM	vn9
Leuco	vn10
LYM2	vn11
LYM	vn12
FLDEX4 -MON2 %	vn13
FLDEX1 - MON	vn14
mpv	vn15
MXD2	vn16
MXD	vn17
NEUT2	vn18
NEUT	vn19
PCT	vn20
pdw	vn21
Plaq	vn22
plrc	vn23
rdwcv	vn24
rdwsd	vn25
VGM	vn26

Biochimica

DREAM 5	DREAM 6
idEsami	id_event
idanagrafica	id_person
-
-	domain = 'A_EXAMS_BIOCH'
Data	date_event
Albu	vn1
AlfaAmilasi	vn2
ALP	vn3
Bild	vn4
Blt	vn5
Ca	vn6
Cl	vn7
ColHDL	vn8
ColTot	vn9
Creat	vn10
Ferritina	vn11
Ferro	vn12
--- (error FLDEX8)	vn13
Glic	vn14
GOT	vn15
GTP	vn16
K	vn17
N2	vn18
Na	vn19
FLDEX7 (proteinuria)	vn20
PT	vn21
Trig	vn22
Urea	vn23
Uric	vn24
FLDEX9 (GGT Gamma-glutamyltransferase gamma-gt)	vn25
FLDEX10 (LDH Lactate dehydrogenase)	vn26
FLDEX11 (HBA1C Glycated Haemoglobin)	vn27

VLOAD

DREAM 5	DREAM 6
idEsami	id_event
idanagrafica	id_person

	domain = 'A_EXAMS_VLOAD'
Data	date_event
Deter	vt1
HIV DNA test PCR	vt3
Oraquick	vt2
UNIG	vt4
CViral	vn1
PCRq	vn2
CViral_date	vd1

FLDEX8 (VL Method)

vn3

other exams

DREAM 5	DREAM 6
idEsami	id_event
idanagrafica	id_person

	domain = 'A_EXAMS_OTHER'
Data	date_event
BK	vt1

Plasmodium	vt3

CD4

DREAM 5	DREAM 6
idEsami	id_event
idanagrafica	id_person

	domain = 'A_EXAMS_CD4CD'
Data	date_event
CD4	vn1
CD4_CD8	vn2
[CD4%]	vn3
CD8	vn4
[CD8%]	vn5

Ordine