Budget Template Report Data Dictionary and Sample Report (SPARCRequest v3.15.0)

1

SPARC Study ID

System generated from SPARCRequest

protocols.id

Automatically generated by SPARC application.

BIGINT(20)

2

RMID

A unique numeric identifier that links a research study across multiple MUSC electronic research systems

protocols.research_master_id

SPARCRequest Step 2: Study Information; Required field when Human Subjects checkbox is selected; System-generated in RMID application.

SPARCDashboard Study Information

INT(11)

3

Short Title

An abbreviated form of the title used to identify your study/project

protocols.short_title

SPARCRequest Step 2: Study Information (Required field); This field is auto-updated when RMID is used via the SPARC/RMID API.

SPARCDashboard Study Information

VARCHAR(255)

4

Protocol Title

Full (unabbreviated) form of the title used to identify your study/project

protocols.title

SPARCRequest Step 2: Study Information (Required field); This field is auto-updated when RMID is used via the SPARC/RMID API.

SPARCDashboard Study Information

TEXT

5

Sponsor

Name of the entity funding the project/study

protocols.sponsor_name

SPARCRequest Step 2: Study Information (Required field);

SPARCDashboard Study Information

VARCHAR(255)

6

Primary PI Name

Principal Investigator First and Last Name

project_roles.role = 'primary-pi'

SPARCRequest Step2 and SPARCDashboard Authorized Users Table

VARCHAR(255)

7

Business Manager

Person responsible for reviewing and paying invoices

project_roles.role = 'business-grants-manager'

SPARCRequest Step 2 and SPARCDashboard Authorized Users Table

VARCHAR(255)

8

Funding Source

Funding source which drives research pricing for your study/project

protocols.funding_source,

protocols.potential_funding_source

SPARCRequest Step 2 and SPARCDashboard, Protocol Information view.

VARCHAR(255)

9

Indirect Cost Rate

Indirect costs — often called facilities-and-administrative costs — are expenses that are not directly associated with any one research project.

N/A

N/A

N/A

10

Staff Fringe Rate

Percent that results from dividing the cost of an employee's fringe benefits by the wages paid to the employee for the hours actually worked.

N/A

N/A

N/A

11

Name

Authorized Users First and Last Name

identities.first_name identities.last_name

SPARCRequest Step 2 and SPARCDashboard Authorized Users Table

VARCHAR(255)

12

Role

Role of the user within the study

project_roles.role

SPARCRequest Step 2 and SPARCDashboard Authorized Users Table

VARCHAR(255)

13

Institutional Base Salary

Annual compensation paid by the institution, excluding bonuses/incentives.

N/A

N/A

N/A

14

% Effort

The effort (amount of time) PI(s), faculty, and other senior personnel devote to a specific project

N/A

N/A

N/A

15

Project Period (in months)

The number of months in which study personnel are assigned to a given project. These months are taken into account for personnel total Full Time Equivalent(FTE).

N/A

N/A

N/A

16

Salary Requested

The salary costs anticipated for the study project period, for budgeting

N/A

N/A

N/A

17

Fringe

The cost of an employee's Salary Requested multiplied by an institutional Fringe Rate.

calculated field

calculated field

calculated field

18

Total

The total cost after adding salary requested and fringe costs

calculated field

calculated field

calculated field

19

Arm

The name of the group or subgroup of participants in a clinical trial.

arms.name

SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab

VARCHAR(255)

20

'#' of Subjects

Total number of participants per Arm

arms.subject_count

SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab

INT(11)

21

'#' of Visits

Total number of scheduled patient visits per Arm

arms.visit_count

SPARCRequest Step 3 and SPARCDashboard Admin Edit Clinical Services Tab

INT(11)

22

Study Level Services (Pass Through)

Name of the requested Non-clinical services on the protocol

services.name

SPARCCatalog Service form

VARCHAR(255)

23

Status

Communication indicator which displays progress, determined by service provider workflow.

sub_service_requests.status

SPARCDashboard Requests table

VARCHAR(255)

24

Service Rate

The fee (full rate) associated to the procedure or study level activity.

pricing_maps.full_rate

SPARCCatalog Service Pricing Map

DECIMAL(12,4)

25

Research Cost (Your Cost)

The proposed amount that your study will be charged including any research discounts or service provider determined cost (override pricing).

pricing_maps.federal_rate

or

pricing_maps.corporate_rate

or

pricing_maps.member_rate

or

pricing_maps.other_rate

or

(admin_rates.admin_cost)/100

SPARCCatalog Service Pricing Map

or

rate modified in ‘Your Cost’ on SPARCDashboard Admin Edit Non-Clinical Services Tab

DECIMAL(12,4)

26

Procedure Occurrence (N)

Quantity of service requested

line_items.quantity

SPARCRequest Step 3 and SPARCDashboard Admin Edit Non-clinical Services Tab

INT(11)

27

Study Level Services: Total Cost

The total cost of the one-time-fee (non-clinical) services

calculated field

calculated field

calculated field

28

Total Budget

The total cost of the research study (including Personnel, Clinical Services, and Non-clinical services)

calculated field

calculated field

calculated field