Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

 

Sample Report

View file
name2020-08-31 Service Requests.xlsx

Excel
name2020-08-31 Service Requests.xlsxxls