The Lab Project level view will include the standard header information in the Regular and Raw views and will have one column for each datapoint property listed in the table below.
See Related Topics for information on Standard Header information.
|
Datapoint |
description |
|
Lab Name |
The name of the Lab |
|
Numeric Value |
Includes numeric dictionary lookup on characters. For example, 6.01 for >6 |
|
Lab Dictionary |
The data dictionary (if any) assigned to the range |
|
Lab Low |
Low value of range |
|
Lab High |
High value of range |
|
Lab Units |
Units for the range |
|
Lab Comment |
Comment for the range |
|
Lab Flag |
Out of range flag, null, + or - |
|
Std Group |
The name of the standard group |
|
Std Value |
The numeric value in standard units |
|
Std Low |
Low value of range in standard units |
|
Std High |
High value of range in standard units |
|
Std Units |
Standard units |
|
Ref Lab |
Reference lab name, if any |
|
Ref Dictionary |
The data dictionary (if any) for the reference range |
|
Ref Low |
Low value of reference range |
|
Ref High |
High value of reference range |
|
Ref Comment |
Comment for the reference range |
|
Ref Flag |
Out of range flag, null, + or - |
|
Alert Lab |
Alert lab name, if any |
|
Alert Dictionary |
The data dictionary (if any) for the alert lab |
|
Alert Low |
Low value of alert range |
|
Alert High |
High value of alert range |
|
Alert Comment |
Comment for the alert range |
|
Alert Flag |
Out of range flag, null, + or - |
|
Coded Value |
The Coded value from the data dictionary assigned to the range (if any) |
|
Analyte Value |
The value for the analyte (data for the corresponding datapoint) |
|
Analyte Name |
The name of the Analyte |
|
Form |
The OID of the form on which the underlying field resides |
|
Updated |
Update timestamp for the datapoint |
|
Created |
Creation timestamp for the datapoint |
|
Field Ordinal |
Ordinal number for the field on the form (used for sorting) |
|
Form ID |
ID of the form |
|
Field ID |
ID of the field |
|
Analyte ID |
ID of the Analyte |
|
Lab ID |
ID of the lab |
|
Analyte Range ID |
ID of the analyte range |
|
Data Dictionary ID |
ID of the Data Dictionary |
|
Lab Unit ID |
ID of the lab unit |
|
Lab Standard Group ID |
ID of the lab standard group |
|
Lab Unit Conversion ID |
ID of the lab unit conversion |
|
Alert Range ID |
ID of the alert range |
|
Alert Lab ID |
ID of the alert lab |
|
Reference Range ID |
ID of the reference range |
|
Reference Lab ID |
ID of the reference lab |
|
Standard Lab Unit ID |
ID of the standard lab unit |
Note: The units for Reference and Alert are always the same as Standard Units.
Lab Project Level View Sample
To access the data in a lab view, users (or the third-party software) can issue SQL queries as needed. For example, to retrieve all data points referencing lab analytes in StudyA, issue the following query:
Select * from V_STUDYA_Lab where environmentName=’PROD’ and userid=(select userid from users where login=’ jdoe’)
Note: Lab is the default ending text for the lab view name. The user can change it to, for example, MyLabView using the following two SQL statements:
Delete from Configuration where tag='NormalizedLabViewName'
Insert into Configuration (Tag, ConfigValue) values (' NormalizedLabViewName',' MyLabView')
Copyright © 2014 Medidata Solutions, Inc. All rights reserved.