|
Field name
|
Description
|
|
[IDEsame]
|
Unique ID
|
|
[IDPaziente]
|
patient ID , reference of DAT_Pazienti table
|
|
[IDPrescrizione]
|
Prescription ID
|
|
[IDFirma]
|
Signature ID of who has responsability to check and validate the exam, reference to Dat_Responsabili table
|
|
[IDCentro]
|
IDcenter of Exam, reference on DAT_CentroRifer table
|
|
[NID]
|
NID of the exam
|
|
[Data]
|
Data of the exam or when has been imported
|
|
[DataGeneralPR]
|
Date when has been printed with all details (general print)
|
|
[DataCViralPR]
|
Date when CV has been printed
|
|
[DataGeneralEmail]
|
|
|
[BoolCViralPR]
|
if CV has been prescribed
|
|
[BoolHemogramma]
|
If hemo has been prescribed
|
|
[Leuco]
|
Leuco value
|
|
[Eritro]
|
Eritro value
|
|
[Hemo]
|
Hemo value
|
|
[Hema]
|
Hema value
|
|
[VGM]
|
VGM value
|
|
[HGM]
|
HGM value
|
|
[CHGM]
|
CHGM value
|
|
[Plaq]
|
PLAQ value
|
|
[LYM]
|
LYM value
|
|
[MXD]
|
MXD value
|
|
[NEUT]
|
NEUT value
|
|
[LYM2]
|
LYM2 value
|
|
[MXD2]
|
MXD2 vaue
|
|
[NEUT2]
|
NEUT 2 value
|
|
[MON]
|
Mon value
|
|
[MON2]
|
|
|
[EOS]
|
|
|
[EOS2]
|
|
|
[BAS]
|
|
|
[BAS2]
|
|
|
[BoolCreat]
|
if creatine has been prescribed
|
|
[Creat]
|
creat value
|
|
[BoolGlic]
|
if Glic has been prescribed
|
|
[Glic]
|
Glic value
|
|
[BoolBlTot]
|
IF BlTot has been prescribed
|
|
[BlTot]
|
BlTot value
|
|
[BoolBlDir]
|
if blDir has been prescribed
|
|
[BlDir]
|
|
|
[BoolGOT]
|
|
|
[GOT]
|
|
|
[BoolGPT]
|
|
|
[GPT]
|
|
|
[BoolAlbu]
|
|
|
[Albu]
|
|
|
[BoolFerro]
|
|
|
[Ferro]
|
|
|
[BoolFerritina]
|
|
|
[Ferritina]
|
|
|
[BoolElettroliti]
|
|
|
[Na]
|
|
|
[K]
|
|
|
[Cl]
|
|
|
[BoolHIV]
|
|
|
[HIV]
|
|
|
[TestHIV1]
|
|
|
[TestHIV2]
|
|
|
[TestHIV3]
|
|
|
[BoolCD4_CD8]
|
|
|
[CD4]
|
|
|
[CD4proc]
|
|
|
[CD8]
|
|
|
[CD8proc]
|
|
|
[CD4_CD8]
|
|
|
[BoolCViral]
|
|
|
[CViral]
|
|
|
[BoolOKCviral]
|
|
|
[BoolPlasmodium]
|
|
|
[Plasmodium]
|
|
|
[BoolAlfaAmilasi]
|
|
|
[AlfaAmilasi]
|
|
|
[BoolColTot]
|
|
|
[ColTot]
|
|
|
[BoolColHDL]
|
|
|
[ColHDL]
|
|
|
[BoolTrig]
|
|
|
[Trig]
|
|
|
[BoolEsame1]
|
|
|
[Esame1]
|
|
|
[BoolEsame2]
|
|
|
[NotReceived]
|
|
|
[SampleRejected]
|
|
|
[Esame2]
|
|
|
[LogVLvalue]
|
|
|
[BoolEsame3]
|
|
|
[EmoSymexVal]
|
|
|
[BoolEsame4]
|
|
|
[Esame4]
|
|
|
[HivDnaMetodo2]
|
|
|
[Note]
|
|
|
[BoolInviato]
|
|
|
[DataInviato]
|
|
|
[BoolCompletato]
|
|
|
[DataCompletato]
|
|
|
[BoolRichiesto]
|
|
|
[BoolDaRipetere]
|
|
|
[ProtocolloCD4]
|
|
|
[GateA]
|
not used but has references in the DreamLab code
|
|
[GateB]
|
not used but has references in the DreamLab code
|
|
[GateC]
|
not used but has references in the DreamLab code
|
|
[GateI]
|
not used but has references in the DreamLab code
|
|
[ReceptionType]
|
|
|
[BoolEsame11]
|
Resistance test Requested
|
|
[Esame11]
|
|
|
[BoolEsame21]
|
|
|
[Esame21]
|
|
|
[BoolEsame31]
|
|
|
[Esame31]
|
|
|
[BoolEsame41]
|
|
|
[Esame41]
|
|
|
[BoolEsame12]
|
|
|
[Esame12]
|
|
|
[BoolEsame22]
|
|
|
[Esame22]
|
|
|
[BoolEsame32]
|
|
|
[Esame32]
|
|
|
[BoolEsame42]
|
|
|
[Esame42]
|
|
|
[BoolHIVDNA]
|
|
|
[HivDnaMetodo]
|
|
|
[HIVDNADataStampa]
|
|
|
[HIVDNADataOK]
|
|
|
[CoVidMetodo]
|
|
|
[CoVidDataStampa]
|
|
|
[CoVidDataOK]
|
|
|
[IDFirmaCoVid]
|
|
|
[BoolAllegatiResistenze]
|
|
|
[Resistenza]
|
not used
|
|
[BoolTubercolosi]
|
|
|
[ChCLDataOK]
|
|
|
[ChCLDatastampa]
|
|
|
[HemoCd4DataOK]
|
|
|
[HemoCd4Datastampa]
|
|
|
[TestMolecolariDataOK]
|
|
|
[TestMolecolariDatastampa]
|
|
|
[HivGenotipoDataOK]
|
|
|
[HivGenotipoDatastampa]
|
|
|
[TBCDataOK]
|
|
|
[TBCDatastampa]
|
|
|
[BoolBK]
|
|
|
[BK]
|
|
|
[IDFirmaEmatochimica]
|
|
|
[IDFirmaVL]
|
|
|
[IDFirmaHivDna]
|
|
|
[IDFirmaTBC]
|
|
|
[IDFirmaHIVGenotipo]
|
|
|
[DoctorPrescription]
|
|
|
[CollectSampleOP]
|
|
|
[MotivazioinePrescr]
|
|
|
[PregnantMilk]
|
if patient is giving milk and is pregnant
|
|
[OPModificatoValuesCHCL]
|
|
|
[OPodificatoValuesHemo]
|
|
|
[OPModificatoValuesCd4]
|
|
|
[OPModificatoValuesVL]
|
|
|
[OPModificatoValuesHIVDNA]
|
|
|
[OPModificatoValuesCoVid]
|
|
|
[OPlModificatoValuesTB]
|
|
|
[OPModificatoValuesCHCLDate]
|
|
|
[OPodificatoValuesHemoDate]
|
|
|
[OPModificatoValuesCd4Date]
|
|
|
[OPModificatoValuesVLDate]
|
|
|
[OPModificatoValuesHIVDNADate]
|
|
|
[OPModificatoValuesCoVidDate]
|
|
|
[OPlModificatoValuesTBDate]
|
|
|
[ReceptionDate]
|
date reception
|
|
[F_NumOrdine]
|
external reference for order number
|
|
[F_LuogoRaccolta]
|
the place sample has been taken
|
|
[F_consulta]
|
can be internal or external
|
|
[F_TipoCampione]
|
Sample type , can be: BLOOD,DBS,primary,serum
|
|
[F_TarvDettaglio]
|
|
|
[F_InizioTARV]
|
start TARV
|
|
[F_PrimaCaricaVirale]
|
if this is the first CV test
|
|
[F_DataUltimotestCV]
|
date of last CV test
|
|
[F_ResCV]
|
result of the last CV
|
|
[F_ResLogVL]
|
|
|
[F_DataArrivoLab]
|
date time when the exam arrived in lab, it appears in formulary form
|
|
[LastUpdate]
|
autogenerated from SqlServer, declares last update of record
|
|
[RefRequest]
|
reference who requested
|
|
[Time_Stamp]
|
autogenerated from SqlServer, declares date time creation of record
|
|
[ExtReference]
|
external reference ID, to declare other related
|
