Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | SRID | System generated protocol ID and request ID from SPARCRequest | |||
2 | RMID | ||||
3 | Date Submission | ||||
4 | Status | ||||
2 | Institution | The institution where the service is being provided (Level 1) | |||
3 | Provider | The entity providing the service (Level 2) | |||
4 | Program | The level of organization in which the service belongs (Level 3) | |||
5 | Core | The level of organization in which the service belongs (Level 4) | |||
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 |