Study datasets reserve the following field names. Each field has a special role to play within the study container.

FieldData TypeReserved in     Visit-based?Reserved in   Date-based?Description
 ParticipantId Text (String) Yes Yes The default subject identifier, used to hold the unique id for each subject in the study. This default field name can be changed on study creation to a more appropriate value to reflect the nature of the organisms being studied, for example "MouseId".  
 Participant Text (String) Yes Yes A reserved field name (but not currently used by the system).
 Visit Integer, Number, or String Yes Yes

 Provide special display and import behavior in Visit-based studies. When integer or number data is imported under the field name "Visit", the data will automatically be inserted into the dataset's "SequenceNum" field. Matching values will be loaded into any pre-existing visits; non-matching values will result in the creation of new visits. When string data is imported under this field name, LabKey will try to match the string value to an existing visit label. If a match is found, the data will be imported into the matching visit. If no match is found, no data will be imported and an error will be returned.

 SequenceNum  Number (Double) Yes Yes A decimal number used to define the relative order of visits in the study.
 StartDate (in Demographic datasets) DateTime Yes Yes When present in Date-based studies, StartDate is used as a participant-specific start date, overriding the study's generic start date. Relevant calculations, such as time charts and visit events, are calculated using each participant's StartDate, instead of the generic start date. StartDate must be included in a demographic dataset. For details see [todo].
 Date DateTime  No Yes Reserved field only in Date-based studies.
 Day Integer No Yes Reserved field only in Date-based studies. In Date-based studies, "Day" is a calculated field, showing the number of days since the start date, either the study's general start date, or the participant-specific start date (if defined).

 VisitDate DateTime No Yes Records the date of the visit. In Date-based studies, when importing data, this field can be used as a synonym for the Date field.

 Specimen Reserved Fields

For details on specimen reserved fields, see the following topics:

 Related Topics








expand all collapse all