SPARCFulfillment Participant Report Data Dictionary and Sample Report (v3.6.1)

1

Participant ID

System generated unique ID for a research participant in SPARCFulfillment.

participants.id

System (SPARCFulfillment) generated identifier; Patient registry page

INT(11)

2

De-Identified 

A participant from which all personal health information has been removed.

participants.deidentified

Patient registry page "De-identified Patient" checkbox when creating a new participant.

TINYINT(1)

3

First Name

Given name of the participant that precedes the participant’s family name.

participants.first_name

Patient registry page "First Name" text field when creating a new participant.

VARCHAR(255)

4

Middle Initial 

The first letter of a participants middle name.

participants.middle_initial

Patient registry page "Middle Initial" text field when creating a new participant.

VARCHAR(1)

5

Last Name

Family name of the participant.

participants.last_name

Patient registry page "Last Name" text field when creating a new participant.

VARCHAR(255)

6

MRN

Medical Record Number from the source Electronic Health System of the participant.

participants.mrn

Patient registry page "MRN" text field when creating a new participant.

VARCHAR(255)

7

Date of Birth

Participant's date of birth

participants.date_of_birth

Patient registry page "Date of Birth" date field when creating a new participant.

VARCHAR(255)

8

Gender

What the Participant is identified at birth or self-identifies for themselves

participants.gender

Patient registry page "Gender" dropdown menu when creating a new participant.

VARCHAR(255)

9

Ethnicity

The social and cultural traditions that a participant identifies with

participants.ethnicity

Patient registry page "Ethnicity" dropdown menu when creating a new participant.

VARCHAR(255)

10

Race

Physical/biological characteristics that a participant associates with or defined by

participants.race

Patient registry page "Race" dropdown menu when creating a new participant.

VARCHAR(255)

11

Address

The place where the participant resides or where items/documentation are sent (i.e mailing address).

participants.address

Patient registry page "Address" text field when creating a new participant.

VARCHAR(255)

12

Phone

Telephone number by which a participant uses to communicate with the research team.

participants.phone

Patient registry page "Phone" field when creating a new participant.

VARCHAR(255)

13

City

Government defined entity where a participant resides.

participants.city

Patient registry page "City" text field when creating a new participant.

VARCHAR(255)

14

State

A territory defined by the government in which one resides (i.e. residential state)

participants.state

Patient registry page "State" dropdown menu when creating a new participant.

VARCHAR(255)

15

ZIP

Participant's postal code with the corresponding address.

participants.zipcode

Patient registry page "Zip Code" text field when creating a new participant.

VARCHAR(255)

16

Protocols

List of protocols which a research participant have been associated to.

protocols_participants.protocol_id (protocols.sparc_id)

Protocol page, Participant Tracker tab, Search and Associate

BIGINT(20)