Coverage Analysis Report (SPARCRequest v3.12.1)

Study ID

System generated from SPARCRequest

protocols.id

Automatically generated by SPARC application.

BIGINT(20)

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)

Study 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 form.

TEXT

Funding Source

Funding source which drives research pricing for your study/project

protocols.funding_source

SPARCRequest Step 2: Study Information (Required field when choosing funded).

SPARCDashboard Study Information form.

VARCHAR(255)

Name

Name of the study team users

identities.first_name identities.last_name

SPARCRequest Step 2 Authorized Users; Email automatically loads from LDAP.

SPARCDashboard Authorized Users

VARCHAR(255)

Role

Study team user defined role

project_roles.role

SPARCRequest Step 2 Authorized Users;

SPARCDashboard Authorized Users

VARCHAR(255)

Proxy Rights

Study team user defined access to protocol

project_roles.project_rights

SPARCRequest Step 2 Authorized Users;

SPARCDashboard Authorized Users

VARCHAR(255)

Name

Name of the document

documents.document_file_name

SPARCRequest Step 4 Documents;

SPARCDashboard Documents

VARCHAR(255)

Type

Type of document (i.e. Manual)

documents.doc_type

SPARCRequest Step 4 Documents;

SPARCDashboard Documents

VARCHAR(255)

Uploaded Date

Date of document upload

documents.created_at

SPARCRequest Step 4 Documents

SPARCDashboard Documents

DATETIME

Selected Services

Name of the selected clinical services

services.name

SPARCCatalog Service Form, Service Name

VARCHAR(255)

Arm Name

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

arms.name

SPARCRequest Step 3 Service Details

VARCHAR(255)

CPT Code

Current Procedural Terminology code; standardized alphanumeric procedure codes used to report services and bill

services.cpt_code

SPARCCatalog Service Form, Epic section, CPT Code

VARCHAR(255)

Order Code

Order code associated with specific service 

services.order_code

SPARCCatalog Service Form, Epic section, Order Code

INT(11)

Notes

Line item notes on services that are entered by study team users and service providers

notes.body

SPARCRequest Step 3 Service Details Line Item Notes;

SPARCDashboard Admin Edit, Clinical Services Tab, Line Item Notes.

TEXT

Selected Services

Name of the selected non-clinical services

services.name

SPARCCatalog Service Form, Service Name

VARCHAR(255)

CPT Code

Current Procedural Terminology code; standardized alphanumeric procedure codes used to report services and bill

services.cpt_code

SPARCCatalog Service Form, Epic section, CPT Code

VARCHAR(255)