Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | SRID | System generated protocol ID and request ID from SPARCRequest | BIGINT(20) | ||
2 | RMID | A unique numeric identifier that links a research study across multiple MUSC electronic research systems | INT(11) | ||
3 | Date Submission | Date service request was submitted | |||
4 | Status | ||||
5 | Protocol Short Title | An abbreviated form of the title used to identify your study/project | VARCHAR(255) | ||
6 | Full Protocol Title | Full (unabbreviated) form of the title used to identify your study/project | TEXT | ||
7 | Institution | The institution where the service is being provided (Level 1) | SPARCCatalog, institution to which the service belongs to | VARCHAR(255) | |
8 | Provider | The entity providing the service (Level 2) | SPARCCatalog, provider to which the service belongs to | VARCHAR(255) | |
9 | Program | The level of organization in which the service belongs (Level 3) | SPARCCatalog, program to which the service belongs to | VARCHAR(255) | |
10 | Core | The level of organization in which the service belongs (Level 4) | SPARCCatalog, program to which the service belongs to | VARCHAR(255) | |
11 | Primary PI Last Name | Principal Investigator Last Name | VARCHAR(255) | ||
12 | Primary PI First Name | Principal Investigator First Name | VARCHAR(255) | ||
13 | Primary PI Institute | Principal Investigator affiliated institution | TEXT | ||
14 | Primary PI College | Principal Investigator affiliated college | TEXT | ||
15 | Primary PI Department | Principal Investigator affiliated department | TEXT | ||
16 | Primary PI Division | Principal Investigator affiliated division | TEXT | ||
17 | Primary Coordinator(s) | Designated study coordinator(s) listed on project/study | VARCHAR(255) | ||
18 | Primary Coordinator Email(s) | Primary coordinator(s) email for a project/study | VARCHAR(255) | ||
19 | Owner |