extracting and loading of various cilnical related data