SPARCRequest Wiki
Admin Time Report Data Dictionary (SPARCRequest v3.12.1)
- Evan Martinez
- Kyle Hutson (Unlicensed)
- Brigette White
Owned by Evan Martinez
Report Filters
Data Dictionary
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | SRID | System generated protocol ID and request ID from SPARCRequest | protocols.id - sub_service_requests.ssr_id | Automatically generated by SPARC application. | BIGINT(20) |
2 | Institution | The institution where the service is being provided (Level 1) | organizations.name | SPARCCatalog, institution to which the service belongs to | VARCHAR(255) |
3 | Provider | The entity providing the service (Level 2) | organizations.name | SPARCCatalog, provider to which the service belongs to | VARCHAR(255) |
4 | Program | The level of organization in which the service belongs (Level 3) | organizations.name | SPARCCatalog, program to which the service belongs to | VARCHAR(255) |
5 | Core | The level of organization in which the service belongs (Level 4) | organizations.name | SPARCCatalog, core to which the service belongs to | VARCHAR(255) |
6 | Service | Description of service being provided | services.name | SPARCCatalog, service form | VARCHAR(255) |
7 | Status | Communication indicator which displays progress, determined by service provider workflow | sub_service_requests.status | SPARCDashboard, Admin Edit, Status dropdown menu | VARCHAR(255) |
8 | Service Request Owner | Proprietor for a service request | sub_service_requests.owner_id | SPARCDashboard, Admin Edit, Owner dropdown menu | VARCHAR(255) |
9 | Consult Arranged Date | Date for appointment | sub_service_requests.consult_arranged_date | SPARCDashboard, Admin Edit, Request Details tab, Consult Arranged Date | DATETIME |
10 | First Fulfillment Date | Initial date for request execution | fulfillments.date | SPARCDashboard, Admin Edit, Non-Clinical Services Tab, Fulfillments List | DATETIME |
11 | Last Fulfillment Date | Last date for request execution | fulfillments.date | SPARCDashboard, Admin Edit, Non-Clinical Services Tab, Fulfillments List | DATETIME |
12 | Total Admin Time (minutes) | Total time spent to fulfill the service in minutes | fulfillments.time (timeframe = Min) | SPARCDashboard, Admin Edit, Non-Clinical Services Tab, Fulfillments List, Quantity column (with Qty Type = Minutes) | Calculated Field |
13 | Total Admin Time (hours) | Total time spent to fulfill the service in hours | fulfillments.time (timeframe = Hours) | SPARCDashboard, Admin Edit, Non-Clinical Services Tab, Fulfillments List, Quantity column (with Qty Type = Hours) | Calculated Field |
14 | Total Admin Time (each) | Total time spent to fulfill the service in quantity of each | fulfillments.time (timeframe = Each) | SPARCDashboard, Admin Edit, Non-Clinical Services Tab, Fulfillments List, Quantity column (with Qty Type = Each) | Calculated Field |
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page { mso-header-data:""; mso-footer-data:""; margin:0.75in 0.25in 0.75in 0.25in; mso-header-margin:0.3in; mso-footer-margin:0.3in; mso-page-orientation:Landscape; }tr {mso-height-source:auto; mso-ruby-visibility:none;}col {mso-width-source:auto; mso-ruby-visibility:none;}br {mso-data-placement:same-cell;}ruby {ruby-align:left;}.style0 { mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;}.font0 { color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; }.font1 { color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; }td {mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-ignore:padding;}.style0 { text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; mso-style-name:"Normal"; }.style1 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style2 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style3 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style4 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style5 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style6 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style7 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style8 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style9 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style10 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style11 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style12 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style13 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style14 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.x15 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }.x16 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:normal;word-wrap:break-word; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }.x17 { mso-style-parent:style0; mso-number-format:"M\/d\/yyyy"; text-align:general; vertical-align:bottom; white-space:normal;word-wrap:break-word; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }--></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Data"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:1262pt"> <colgroup> <col style="mso-width-source:userset;width:127px"></col> <col style="mso-width-source:userset;width:131px"></col> <col style="mso-width-source:userset;width:97px"></col> <col style="mso-width-source:userset;width:88px"></col> <col style="mso-width-source:userset;width:115px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:189px"></col> <col style="mso-width-source:userset;width:159px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:109px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:137px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:107px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:108px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:101px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:112px"></col> <col class="x16" style="mso-width-source:userset;background:none;width:103px"></col> </colgroup> <tbody> <tr style="mso-height-source:userset;height:14pt" id="r0"> <td style="height:14pt;width:95.25pt">Report Generated:</td> <td style="width:98.25pt">2023-08-07</td> <td style="width:72.75pt"></td> <td style="width:66pt"></td> <td style="width:86.25pt"></td> <td class="x16" style="width:141.75pt"></td> <td style="width:119.25pt"></td> <td class="x16" style="width:81.75pt"></td> <td class="x16" style="width:102.75pt"></td> <td class="x16" style="width:80.25pt"></td> <td class="x16" style="width:81pt"></td> <td class="x16" style="width:75.75pt"></td> <td class="x16" style="width:84pt"></td> <td class="x16" style="width:77.25pt"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r1"> <td style="height:14pt"># of Records:</td> <td style="text-align:right">3</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r2"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r3"> <td style="height:14pt">Report Parameters</td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r4"> <td style="height:14pt">Type:</td> <td>Admin Time</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r5"> <td style="height:14pt">Institution:</td> <td>MUSC</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r6"> <td style="height:14pt">Provider:</td> <td>SCTR</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r7"> <td style="height:14pt">Program:</td> <td>SUCCESS</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r8"> <td style="height:14pt">Core:</td> <td>Regulatory</td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r9"> <td style="height:14pt">Service:</td> <td colspan="3" style="mso-ignore:colspan">Human Subjects Regulatory Consultation</td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r10"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r11"> <td style="height:28pt">SRID</td> <td>Institution</td> <td>Provider</td> <td>Program</td> <td>Core</td> <td class="x16">Service</td> <td>Status</td> <td class="x16">Service Request Owner</td> <td class="x16">Consult Arranged Date</td> <td class="x16">First Fulfillment Date</td> <td class="x16">Last Fulfillment Date</td> <td class="x16">Total Admin Time (minutes)</td> <td class="x16">Total Admin Time (hours)</td> <td class="x16">Total Admin Time (each)</td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r12"> <td style="height:28pt">2559-0001</td> <td>MUSC</td> <td>SCTR</td> <td>SUCCESS</td> <td>Regulatory</td> <td class="x16">Human Subjects Regulatory Consultation</td> <td>Complete</td> <td class="x16">Toni Mauney</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16" style="text-align:right">0</td> <td class="x16" style="text-align:right">0</td> <td class="x16" style="text-align:right">0</td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r13"> <td style="height:28pt">2559-0002</td> <td>MUSC</td> <td>SCTR</td> <td>SUCCESS</td> <td>Regulatory</td> <td class="x16">Human Subjects Regulatory Consultation</td> <td>Complete</td> <td class="x16">Brigette White</td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16" style="text-align:right">0</td> <td class="x16" style="text-align:right">0</td> <td class="x16" style="text-align:right">0</td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r14"> <td style="height:28pt">2559-0003</td> <td>MUSC</td> <td>SCTR</td> <td>SUCCESS</td> <td>Regulatory</td> <td class="x16">Human Subjects Regulatory Consultation</td> <td>Complete</td> <td class="x16">Brigette White</td> <td class="x16"></td> <td class="x17" style="text-align:right">12/20/2016</td> <td class="x17" style="text-align:right">12/20/2016</td> <td class="x16" style="text-align:right">90</td> <td class="x16" style="text-align:right">0</td> <td class="x16" style="text-align:right">0</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r15"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x17"></td> <td class="x17"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:28pt;mso-xlrowspan:2" id="r16"> <td style="height:28pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r17"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x16"></td> <td></td> <td class="x16"></td> <td class="x16"></td> <td class="x17"></td> <td class="x17"></td> <td class="x16"></td> <td class="x16"></td> <td class="x16"></td> </tr> <tr style="display:none"> <td style="width:95.25pt"></td> <td style="width:98.25pt"></td> <td style="width:72.75pt"></td> <td style="width:66pt"></td> <td style="width:86.25pt"></td> <td style="width:141.75pt"></td> <td style="width:119.25pt"></td> <td style="width:81.75pt"></td> <td style="width:102.75pt"></td> <td style="width:80.25pt"></td> <td style="width:81pt"></td> <td style="width:75.75pt"></td> <td style="width:84pt"></td> <td style="width:77.25pt"></td> </tr> </tbody></table></div>
Copyright © 2011-2020 MUSC Foundation for Research Development