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 | Status2 | |||||||||||||||||||||||||||||||
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) | ||||||||||||||||||||||||||||
38 | Provider | The entity providing the service (Level 2) | 4SPARCCatalog, provider to which the service belongs to | VARCHAR(255) | ||||||||||||||||||||||||||||
9 | Program | The level of organization in which the service belongs (Level 3)5 | 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) | 6 | Service | Description of service being provided | 7 | Service Request Status | Description of current state of a request | 8 | Service Request Owner | Proprietor for a service request | 9 | Consult Arranged Date | Date for appointment | 10 | First Fulfillment Date | Initial date for request execution | 11 | Last Fulfillment Date | Last date for request execution | 12 | Total Admin Time (minutes) | Total time spent to fulfill the service in minutes | 13 | Total Admin Time (hours) | Total time spent to fulfill the service in hours | 14 | Total Admin Time (each) | Total time spent to fulfill the service in quantity of each | ||
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 |