Data Extract Context

To create a structure more conducive to data analysis, the Data Extract facility allows data to be accessed or extracted via Oracle or SAS views.

De-normalized Oracle views, termed data extract views, are created with SQL statements; these views join together and organize the study data so that responses to DCM questions are presented in the context of study, Investigator, patient, and RDCM.

For every Oracle view created, a corresponding SAS view is also created. Data extract views correspond to DCMs, and there is at least one view for every DCM; a DCM with repeating questions may have several.

See the following topics:

• Default View Creation Algorithm
  
• View Types
  
• Rollsnaps
  
• Access Accounts
  
• Table-Based Views
  
• Creating Extract Tables and Indexes