All datasets have several required fields (a.k.a. system columns) pre-defined:

System ColumnData TypeDescription
DatasetIdintA number that corresponds to a defined dataset.
ParticipantIdstringA user-assigned string that uniquely identifies each participant throughout the Study.
VisitDatedate/timeThe date that a visit occurred (only defined in visit-based study datasets).
Createddate/timeA date/time value that indicates when a record was first created. If this time is not explicitly specified in the imported dataset, LabKey will set it to the date/time that the data file was last modified.
CreatedByintAn integer representing the user who created the record.
Modifieddate/timeA date/time value that indicates when a record was last modified. If this time is not explicitly specified in the imported dataset, LabKey will set it to the date/time that the data file was last modified.
ModifiedByintAn integer representing the user who last modified the record.
SequenceNumfloatA number that corresponds to a defined visit within a Study. This is a floating-point number. In general, you can use a visit ID here, but keep in mind that it is possible for a single visit to correspond to a range of sequence numbers.
Datedate/timeThe date associated with the record. Note this field is included in datasets for both timepoint and visit based studies.

Related Topics

discussion

Discussion

Search 

Pages 

previousnext
 
expand all collapse all