Data lineage example

In this example, multiple data items in several data models contribute to the calculation of each subject's Body Mass Index (BMI).

Figure 8-1 Body Mass Index Calculation Example

Description of "Figure 8-1 Body Mass Index Calculation Example"

The calculations shown above result in the following data in table BMI in the Analysis model:

Table 8-6 Data in Table BMI

Study	Subject	Visit	Site	Gender	Age	BMI	BMIU
BMI	1005	4	McLean	MALE	29	24.6	KG/M**2
BMI	1006	4	McLean	MALE	54	28.8	KG/M**2
BMI	1007	4	McLean	FEMALE	42	33.1	KG/M**2

A BMI value over 30 is outside the normal range. To investigate the source data for Subject 1007, a female aged 42 with a BMI of 33.1, the reviewer selects the BMI data value 33.1 for Subject 1007 in the Listings page and clicks View Source Data.

Figure 8-2 Source Data Lineage Display

The Trace Data Lineage window displays the selected data item in the top row, with its sources displayed below. Expand any source to see its source. Columns are displayed in the format data_model.table.column.

The user can see downstream data by clicking View Target Data. The display shows the selected item at the top and the downstream data below.

Note:

If the system cannot display the entire lineage, it displays an asterisk (*) with a message about possible reasons.