SPARCRequest Wiki
Coverage Analysis Report (SPARCRequest v3.12.1)
- Evan Martinez
- Kyle Hutson (Unlicensed)
- Brigette White
This report provides information related to CPT coded services and billing compliance information.
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
Study Information | |||||
1 | Study ID | System generated from SPARCRequest | protocols.id | Automatically generated by SPARC application. | BIGINT(20) |
2 | 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) |
3 | 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 |
4 | 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) |
Authorized Users | |||||
5 | 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) |
6 | Role | Study team user defined role | project_roles.role | SPARCRequest Step 2 Authorized Users; SPARCDashboard Authorized Users | VARCHAR(255) |
7 | Study team user defined access to protocol | project_roles.project_rights | SPARCRequest Step 2 Authorized Users; SPARCDashboard Authorized Users | VARCHAR(255) | |
Document Uploads | |||||
8 | Name | Name of the document | documents.document_file_name | SPARCRequest Step 4 Documents; SPARCDashboard Documents | VARCHAR(255) |
9 | Type | Type of document (i.e. Manual) | documents.doc_type | SPARCRequest Step 4 Documents; SPARCDashboard Documents | VARCHAR(255) |
10 | Uploaded Date | Date of document upload | documents.created_at | SPARCRequest Step 4 Documents SPARCDashboard Documents | DATETIME |
Clinical Services | |||||
11 | Selected Services | Name of the selected clinical services | services.name | SPARCCatalog Service Form, Service Name | VARCHAR(255) |
12 | Arm Name | The name of the group or subgroup of participants in a clinical trial. | arms.name | SPARCRequest Step 3 Service Details | VARCHAR(255) |
13 | 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) |
14 | Order Code | Order code associated with specific service | services.order_code | SPARCCatalog Service Form, Epic section, Order Code | INT(11) |
15 | 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 |
Non-Clinical Services (Other Services) | |||||
16 | Selected Services | Name of the selected non-clinical services | services.name | SPARCCatalog Service Form, Service Name | VARCHAR(255) |
17 | 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) |
Agreement Language | |||||
Signatures | |||||
Excel: spreadsheet preview is finally here!
You can now display this file as a spreadsheet, instead of a PDF. Re-upload Coverage A...ort_200414.xlsx to display the new preview. You can access the file here.
Copyright © 2011-2020 MUSC Foundation for Research Development