Click on the magnifying glass to the right. Starting typing a topic you wish to learn about

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Identifiers
The goal of this article is to assist users in understanding the different types of identifiers:  unique identifier, optional secondary unique field, and the redcap_survey_identifer 

Initial Considerations

  • The first variable listed in your project is the unique identifier which links all your data.
    • Do not use Protected Health Information (PHI) identifiers such as medical record number or date of birth or initials as the unique identifier, as it could be accidently displayed if a URL is created. The medical record number or date of birth, if required, can be added as another field.
    • In Data Entry projects, you must define the unique identifier field. For projects where a survey is the first data collection instrument, it is automatically defined as the Participant ID. The Participant ID value is numeric and auto-increments starting with the highest value in the project. If no records exist, it will begin with '1'.
    • Users can define the unique ID for projects with surveys instead of using the participant_id by having the first data collection instrument as a data entry form (do NOT enable it as a survey).
  • The optional secondary unique field may be defined as any field on the data collection instruments. The value for the field you specify will be displayed next to the Participant ID (for surveys) or next to your unique identifier when choosing an existing record/response. It will also appear at the top of the data entry page when viewing a record/response. Unlike the value of the primary unique identifier field, it will not be potentially visible in a URL.
    • The data values entered into the secondary unique field must also be unique. The system will not allow for duplicate entries and checks values entered in real time. If a duplicate value is entered, an error message will appear and the value must be changed to save/submit data entered on the data entry instrument.
    • Common secondary unique identifiers are medical record numbers, subject name, and subject birthdate.
  • The redcap_survey_identifier is the identifier defined for surveys when utilizing the Participant Email Contact List and sending survey invitations from the system. The "Participant Identifier" is an optional field you can use to identify individual survey responses so that the participant doesn't have to enter any identifying information into the actual survey. This field is exported in the data set; the email address of the participant is not.


The unique identifier must be a 'text' field. In addition, please note that unique identifier values will be visible at the end of the URL – and likely cached in web browsers – as individual records are viewed or entered.
(Example URL: https://xxx.xxx.xxx/redcap/redcap_vx.x.x/data_entry.php?pid=xxx&p age=xxx&id=ID_VARIABLE_VALUE.)
Again, do not use Protected Health Information (PHI) Identifiers such as MRN or DOB+initials as the unique identifier. This is an additional precaution to preserve research participant confidentiality from displaying in the URL and becoming cached. 

Additional Considerations

Q: If the unique identifier is arbitrary to me, can the system auto-assign a unique value to each of my records? Yes. You can enable auto-numbering for naming new project records on the Project Setup > Enable optional modules and customizations page. This option will remove the ability for users to name new records manually and will instead provide a link that will auto-generate a new unique record value. The value is numeric and increments from the highest numeric record value in the project. If no records exist, it will begin with '1'.

Q: How can I set the default auto-numbering to start at a particular number such as 2000? You can disable auto-numbering and add the first record using the ID number as the start value. Once this record is saved, you can enable the auto-numbering customization.

Q: What's the difference between the unique identifier, secondary unique identifier and the redcap_survey_identifier?
The first variable listed in your project is the unique identifier which links all your data.
The secondary unique field may be defined as any field on the data collection instruments. The value of the field you specify as the secondary unique field will be displayed next to the Participant ID (for surveys) or next to your unique identifier when choosing an existing record/response. It will also appear at the top of the data entry page when viewing a record/response. Unlike the value of the primary unique identifier field, it will not be visible in the URL.
The data values entered into the secondary unique field must also be unique. The system will not allow for duplicate entries and checks values entered in real time. If a duplicate value is entered, an error message will appear and the value must be changed to save/submit data entered on the data entry instrument.
To initiate a secondary unique field, enter your projects setup, in the menu " Enable optional modules and customizations ", click on additional customizations, check on " Designate a Secondary Unique Field " and choose the field you want to be unique.
The redcap_survey_identifier is the identifier defined for surveys when utilizing the Participant Email Contact List and sending survey invitations from the system. The "Participant Identifier" is an optional field you can use to identify individual survey responses so that the participant doesn't have to enter any identifying information into the actual survey. This field is exported in the data set; the email address of the participant is not.

Q: If we wanted to get rid of our own IDs and just use auto-numbering, could we start at, say, 3000? And is there any way to make the participant's number appear on screen so the RA can document it? Using a calc field, perhaps?
 If you wanted to start the auto-numbering record ID at 3000, you would have to go in to an existing record it is best to create a fake record to do this) and manually change the record number to 2999 so that the next assigned record # would be 3000. You will need to have "Rename Records" ability under your User Rights in order to do this. 
 To get this ID# to show in the survey, you would create a calculated field that equals the REDCap record ID field.
The hard stop rule for auto numbering is that it can't be done if you have a public survey. If the project has a public survey it has to have auto numbering.

Q: Is Auto-numbering for records enabled?
Auto-numbering will automatically be enabled. If you would want to create your own record identification, you may disable this feature and manually assign a record identifier. When using auto-numbering you can have your sequence begin with a number other than 1 using the following strategy:
1. With record auto-numbering disabled, create a dummy record with an identifier one less than your desired start number
2. Enable record auto-numbering
3. Create a new record – this will become your firstrecord
4. Delete the dummy record For example, if you want your first record to be numbered 1001, disable record auto-numbering, add a record with id=1000, enable record auto-numbering, create another new record (id=1001 will be assigned), then delete record 1000.

Q: How can I designate a secondary unique field

  • A field in addition to the primary record identifier for which REDCap will ensure the uniqueness of all values
  • • Values will also be included alongside the primary record identifier in the record selection lists

You may designate a text field to serve as a unique constraint whose value cannot be duplicated or shared by any other record in the project. When a value is entered or imported for the secondary unique field, it will be checked in real time to ensure it is not shared by another record, and if so, will ask the user to enter another value. This means that if a participant is completing a survey for a second time in which this feature is enabled, they will see the following pop-up box:

Note: this feature should be enabled before you start collecting real data. That is because if you are already collecting real data and there are duplicates in your project, you cannot enable this feature.
It is not possible to specify that the combination of two or more fields be unique.

  • No labels