i know that OBS_CLIN is considered optional for data load this round but I just wanted to relay Nebraska experience with the new data tables. I followed advice in the CDMV4.1 documentation which suggested that LOINC CLASS = 1 observations should be loaded in LAB_RESULT_CM, CLASS = 2 in OBS_CLIN and CLASS=4 in PRO_CM. Following this protocol, to my surprize, OBS_CLIN table was our largest, greater even that LAB_RESULT_CM. We have had to allocate more disk to do our SAS dataset binding and have changed storage estimates for maintenance of CDM table history. Size of a few of our tables as follows:
OBS_CLIN 228M rows LAB_RESULT_CM 205M MED_ADMIN 28M PRESCRIBING 16M ... PRO_CM 2.4M I left in the blood pressures, weight and height in OBS_CLIN which overlapped with VITAL since they only accounted for 47M facts and the types of data that I extracted into OBS_CLIN from our Epic EHR was as follows: OBSCLIN_CODE//RAW_OBSCLIN_NAME//COUNT(*) 8867-4 Heart rate 41195391 9279-1 Respiratory rate 30020150 8310-5 Body temperature 22551370 8478-0 Mean blood pressure 19685904 8462-4 Diastolic blood pressure 17794069 8480-6 Systolic blood pressure 17794069 39156-5 Body mass index (BMI) [Ra 7574390 38208-5 Pain severity - Reported 7039613 50064-5 Ideal body weight 6583916 8302-2 Body height 6524735 3141-9 Body weight Measured 5922939 9267-6 Glasgow coma score eye op 4270690 9268-4 Glasgow coma score motor 4268539 9270-0 Glasgow coma score verbal 4266029 9269-2 Glasgow coma score total 4262288 3140-1 Body surface area Derived 3301569 38222-6 Sensory perception Braden 2827295 38229-1 Moisture exposure Braden 2827250 38223-4 Physical activity Braden 2827192 38224-2 Physical mobility Braden 2827028 38225-9 Nutrition intake pattern 2826941 38226-7 Friction and shear Braden 2826089 38227-5 Braden scale total score 2824397 9187-6 Urine output 2536706 3151-8 Inhaled oxygen flow rate 2194966 59576-9 Body mass index (BMI) [Pe 334323 11784-6 Cervical canal external os 102323 11867-9 Effacement Cervix 90605 11881-0 Uterus Fundal height Tape 84044 11876-0 Fetal presentation palpation 43333 79991-6 Left ventricular Ejection Fraction 36724 8287-5 Head Occipital-frontal circumference 32128 55283-6 Fetal Heart rate 22784 The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
