The clinical data model called Source is an input model with raw data from InForm including the following tables:
Table Demography includes the columns Height and Height Unit and has data for all subjects.
Table Site A Visits includes the columns Weight and Weight Units and has data for subjects at Site A.
Table Site B Visits includes the columns Weight and Weight Units and has data for subjects at Site B.
The model All Sites has a table called Visits that is a union of source tables Site A Visits and Site B Visits. It stores the Weight and Weight Unit for all subjects at both sites.
The model Review has a table called Milestone Visits created as a direct map with a source filter that copies only data for the milestone visits 1, 4, 7, and 10. The table has Weight and Weight Unit for all subjects at both sites, now all converted to kilograms.
The model Analysis has a table called BMI whose BMI column value is the computation for Body Mass Index using the height from Demography and the weight from Milestone Visits.