Admin Time Report Data Dictionary (SPARCRequest v3.12.1)

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