Dataset System Fields

All datasets have several required base fields 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.
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.
VisitDatedate/timeThe date that a visit occurred (only defined in visit-based studies).

Hidden Fields

Lists and datasets also have the following hidden fields. To see them, open (Grid Views) > Customize Grid and check the box for Show Hidden Fields.

Hidden Fields in Lists

NameDatatypeDescription
Last Indexeddate/timeWhen this list was last indexed.
KeyintThe key field.
Entity IdtextThe unique identifier for the list itself.
FolderobjectThe container where this list resides.

Hidden Fields in Datasets

NameDatatypeDescription
LsidtextThe unique identifier for the dataset.
Participant Sequence NumtextA concatenation of the participant ID and sequence num
Source LsidtextA unique identifier for this row.
DSRowIdlong intThe row in the current dataset
Sequence NumotherThe sequence number for the visit
DatasettextThe name of the dataset
Containertext/linkThe folder containing the dataset
Visit Row IdintThe id of the visit
FoldertextThe folder containing the dataset

Related Topics

Discussion

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand all collapse all