This topic lists the field names that are reserved in a study. The properties listed here are in addition to the reserved dataset system fields, present in every study dataset. The reserved fields each have a special role to play within the study container.
Note that there may be additional reserved fields in some circumstances; if you see an error indicating a field name is reserved, try using a variation (such as using "Site_ID" if "SiteID" is reserved). You can use a field label to show the "reserved" name in your grids if desired.
Field |
Data Type |
Reserved 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 can be 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 Timepoints FAQ. |
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. |
Related Topics