6. Issues

This is a list of issues that appear after project's implementation.

------------------------------------------------------------------------------------------------------------------------
The problem occured with gathering information from external bodystat device: the NicolaID unique identifiers were dissapearing after new data upload from device. I had to design another table and write a query to copy data from original table to duplicated table so the data written by nurses in duplicated table would remain:
 [code]
insert into nicola_clinical.BodyStatEdit(SUBJID,LASTNAME,DOB,ADDR1,ADDR2,ADDR3,ADDR4,ZIP,HOMETEL,WORKTEL,MOBILETEL,EMAIL,SPORTCAT,OCCUPATION,EMPLOYER,DOCTOR,DOCTORTEL,REFERRED,MEDCON,TESTNO,EQUIPNO,EQUIPTYPE,EXAMINER,TESTDATE,TESTHOURS,TESTMINS,TESTSECS,LOCATION,GENDER,ACTIV,AGE,HEIGHT,WEIGHT,MINWT,MAXWT,MEANWT,FATPC,FATPCMIN,FATPCMAX,FAT,FATMIN,FATMAX,LEANPC,LEANPCMIN,LEANPCMAX,LEAN,LEANMIN,LEANMAX,WATERPC,WATERPCMIN,WATERPCMAX,WATER,WATERMIN,WATERMAX,DRY,BMR,EAR,BMI,IMPED50K,IMPED5K,RESIST50K,REACT50K,PHASEA50K,WAIST,HIP,WHRATIO,HEART,SYSBP,DIABP,CHOLTOT,CHOLHDL,CHOLLDL,CHOLRATIO,AERO,ELBOW,FRAMESIZE,FVC,FEV1,PEF,FLEX,GRIP,HAND,DENSITY,RE)
select distinct SUBJID,FIRSTNAME,DOB,ADDR1,ADDR2,ADDR3,ADDR4,ZIP,HOMETEL,WORKTEL,MOBILETEL,EMAIL,SPORTCAT,OCCUPATION,EMPLOYER,DOCTOR,DOCTORTEL,REFERRED,MEDCON,TESTNO,EQUIPNO,EQUIPTYPE,EXAMINER,TESTDATE,TESTHOURS,TESTMINS,TESTSECS,LOCATION,GENDER,ACTIV,AGE,HEIGHT,WEIGHT,MINWT,MAXWT,MEANWT,FATPC,FATPCMIN,FATPCMAX,FAT,FATMIN,FATMAX,LEANPC,LEANPCMIN,LEANPCMAX,LEAN,LEANMIN,LEANMAX,WATERPC,WATERPCMIN,WATERPCMAX,WATER,WATERMIN,WATERMAX,DRY,BMR,EAR,BMI,IMPED50K,IMPED5K,RESIST50K,REACT50K,PHASEA50K,WAIST,HIP,WHRATIO,HEART,SYSBP,DIABP,CHOLTOT,CHOLHDL,CHOLLDL,CHOLRATIO,AERO,ELBOW,FRAMESIZE,FVC,FEV1,PEF,FLEX,GRIP,HAND,DENSITY,RE
from nicola_clinical.BodyStat BodyStat where NOT EXISTS(select SUBJID,FIRSTNAME,DOB,ADDR1,ADDR2,ADDR3,ADDR4,ZIP,HOMETEL,WORKTEL,MOBILETEL,EMAIL,SPORTCAT,OCCUPATION,EMPLOYER,DOCTOR,DOCTORTEL,REFERRED,MEDCON,TESTNO,EQUIPNO,EQUIPTYPE,EXAMINER,TESTDATE,TESTHOURS,TESTMINS,TESTSECS,LOCATION,GENDER,ACTIV,AGE,HEIGHT,WEIGHT,MINWT,MAXWT,MEANWT,FATPC,FATPCMIN,FATPCMAX,FAT,FATMIN,FATMAX,LEANPC,LEANPCMIN,LEANPCMAX,LEAN,LEANMIN,LEANMAX,WATERPC,WATERPCMIN,WATERPCMAX,WATER,WATERMIN,WATERMAX,DRY,BMR,EAR,BMI,IMPED50K,IMPED5K,RESIST50K,REACT50K,PHASEA50K,WAIST,HIP,WHRATIO,HEART,SYSBP,DIABP,CHOLTOT,CHOLHDL,CHOLLDL,CHOLRATIO,AERO,ELBOW,FRAMESIZE,FVC,FEV1,PEF,FLEX,GRIP,HAND,DENSITY,RE from nicola_clinical.BodyStatEdit BodyStatEdit where BodyStat.TESTNO=BodyStatEdit.TESTNO AND BodyStat.EQUIPNO=BodyStatEdit.EQUIPNO AND BodyStat.TESTDATE=BodyStatEdit.TESTDATE AND BodyStat.TESTHOURS=BodyStatEdit.TESTHOURS AND BodyStat.TESTMINS=BodyStatEdit.TESTMINS AND BodyStat.TESTSECS=BodyStatEdit.TESTSECS AND BodyStat.GENDER=BodyStatEdit.GENDER AND BodyStat.AGE=BodyStatEdit.AGE AND BodyStat.HEIGHT=BodyStatEdit.HEIGHT AND BodyStat.WEIGHT=BodyStatEdit.WEIGHT AND BodyStat.WEIGHT=BodyStatEdit.WEIGHT);
[/code]


 this way the data in target table is not replaced any more, only new records are appended.

-----------------------------------------------------------------------------------------------------------------------