SPARCRequest Wiki

SPARCFulfillment Step-by-Step Guide (v3.5.1)

Completed

Leila Forney 4 (1068 days ago), Kyle Hutson (Unlicensed) 4 (1091 days ago), Brigette White 4 (134 days ago), Wenjun He (Unlicensed) 5 (1068 days ago), harikrip 7 (147 days ago)

SPARCFulfillment can be accessed directly from the navigation bar on the top of SPARCRequest, via SPARCDashboard Admin Edit section within a request, or directly through the URL: sparc-fulfillment.musc.edu

SPARCRequest Navigation Bar

SPARCRequest Navigation Bar

SPARCDashboard Admin Edit Section

SPARCFulfillment Navigation

The Navigation Bar across the top of SPARCFulfillment has five buttons:  Home, Tasks, Reports, Imports, and Patient Registry.

1.  Home Page

Your default landing view is your “Home” page, which contains many useful features

1A) Below the Navigation bar, Fulfillment Users will see the "Requests Received from SPARCRequest" these are the requests they have access to as a clinical provider, or super user. All columns in the header (SRID, RMID, Status, Short Title, etc.) are sortable.

You may search by any attribute of the request in the Search Bar. This includes SPARC Protocol ID, any part of a title, PI, IRB approval dates, RMID, etc. Simply begin typing and your list of requests will auto-update based on your search criteria.

1B) On the left side of "Requests Received from SPARCRequest" table there is the ability to toggle between the default "Requests" view and a "Financial" view. In addition, a status dropdown allows user to search by any given request status if a more narrowed search is necessary.

1C) Below the "Requests Received from SPARCRequest" table you will see a series of icons next to the search bar, see descriptions below:

         

   

Click to switch back to the study management view (the default view) of your requests.

Click to switch to a financial view of your requests.

Click to select and filter requests by a given status.

Refresh your page for the most recent updates (note: the application will auto-update as protocol-level (PI, Title, etc.) changes are made).

Switch your view to vertical card format.

Select which columns you would like to display. The most recent selection on your current computer will preserve as the default view

Click to export the records listed in your current table view (JSON, XML, CSV, TXT, SQL). All data on the screen (SRID, RMID, Status, Short Title, PI, Coordinators, IRB  Approval, IRB Expiration, Provider/Program/Core, etc.) will be exported.

 

2.  Tasks Page

Second on the Navigation bar you will see an icon for “Tasks.”

 A system-generated email is sent to your institution email box when a task has been assigned to you.

 

Tasks represent those “chores” that have been assigned to you.

For example, Kyle may create a task for Sarah asking to review documents recently added. Kyle can create the task, assign it to Sarah with a due date.

Your default task view is a list of those open tasks that have been assigned to you or by you. To view all tasks for your organizations, toggle from “My Tasks” to “All Tasks.” In order to view completed tasks, toggle from “Incomplete” to “Complete.”

To create a new task, click “Create New Task.” Here you will be able to define the task, assign it to someone and attach a due date. New tasks can also be created from a follow-up service fulfillment event, inside a chosen visit/arm of a participant on a specific protocol.

 

3.  Reports Page

Listed third on the navigation bar is the “Reports” page. Click on the icon to access the various canned reports available in SPARCFulfillment. Please refer to the report data dictionaries for more details about each report.

Choose the desired Fulfillment report from the “All Reports” section (see Invoice Report example below), then set the filters and click “Request Report” to generate a report. Once in “Request Report,” the new report will appear in the list of existing reports in a “Pending” status until “Completed” – at which time you can download the requested export by clicking on the “attached file.” Previously generated reports can be organized and Sorted or Searched by fields such as Title, Date, etc.

 

 

 

 

 

 

 

 

 

4.  Imports Page

This page is where data from other systems can be imported into SPARCFulfillment. For example, XML formatted reports with fulfillment data from Klok application (mobile app) with mapped data can be imported into SPARCFulfillment for record keeping and reporting purposes.

 

 A “Proof Report” generates a test report without importing data; “Klok Report” imports data into SPARCFulfillment and generates a report.

 

5.  Patient Registry Page

The single Patient Registry is a registry of all research participants that can be searched to associate a participant to a study.  The Patient Registry can only be accessed by those who are granted Patient Registrar rights in SPARCCatalog

New patients can also be added into the Patient Registry if they have not been a participant in a SPARC before.  This allows participants to be associated to multiple studies, if necessary, rather than having separate participant records for each study they are a participant. 

*Note: once a patient has fulfillment data they cannot be removed.

 

When a Patient Registrar creates a new participant, they will enter the required information to add that patient to the Patient Registry. 

De-identified patients can be marked when creating or editing a participant. De-identified patients can only be associated to 1 study and after association will be hidden from patient search/association. Participants who are not de-identified can be searched and associated to multiple studies.

6. Inside a Request Page

6A). Header

Identify the request you want to fulfill by clicking on any part of the request row from SPARCFulfillment homepage. You will then see the service request that you selected, SRID 5730-001 for example, identified on the top of the page and correlating options below that. At this point you can begin tracking your work activity.

6B). Clinical Services Tab

Within the Clinical Services tab, you have the ability to manage arms, visits, and services.

When adding arms, enter the arm name, subject count, visit count, and select any services you need from the list of services that appear on other arms. If you need to make changes to the visit calendar, you may do so by selecting the edit option under “Manage Visits.” 

Before sending your request via “Admin Edit” within SPARCDashboard to SPARCFulfillment, be certain that you have reviewed your request in its entirety. This can only be done one time for Clinical Services. *After the initial push from SPARCRequest “Admin Edit,” changes made in one module will not be reflected in the other, all changes must be manually made in both modules in order to match consistently.*

If visits need to be added to a specific arm, click on the add button, select which arm you wish to add this visit, then proceed to enter the visit name, visit day and where you wish to place this visit via the drop down, and also enter your before and after window. If additional services need to be added, you may do so in the “Manage Services” section. Select which services need to be added from the manage service dropdown, and which arm(s) the services should be added to, and click the submit button.

There is the ability to export the study schedule (from the primary Study Schedule default tab) as it currently exists. 

 

 

On the Quantity/Billing tab, there is the ability to change the quantity and type of billing for each individual service. *Please note that you are not able to change existing visit days or windows on this tab.

 To change the quantity, simply change the number listed in the box to the desired number. To change the intended payer, simply enter the appropriate number into either the “R” box for research, or the “T” box for Third party payer or patients insurance.

 

6C). Participant Tracker Tab

In the participant tracker tab, you have the ability to search for participants within the Patient Registry by clicking the "Search Patient Registry” button.  Participants can only be added in the Patient Registry by user(s) with Patient Registrar rights. 

 

Fulfillment users have the ability to refresh the page within the participant tracker, toggle the view, add/remove columns, and export patient list or Participant Report conveniently from this page.

Tracking patient activity can be completed within the participant tracker tab. Once a new study participant is entered into the Patient Registry they can be added to the study under the Search Patient Registry tab.

 

 

 

To begin tracking patient activity, first associate the patient to the study and next assign the patient to an arm by clicking the associate button.

 

You are able to edit the patient information (i.e.: External ID, Current Arm, Status, Recruitment Source, etc) from within the Participant Tracker tab for a given participant.

Next, click on the patient’s calendar. Your patient header contains vital patient information.

 

 

Next, select the intended visit for which you are performing activity.

Before you are able to mark a service as complete, incomplete, or follow up you must click the start visit button to begin.

Once the visit has started, mark each service as complete, incomplete, or follow up.

 

You have the ability to complete or incomplete multiple procedures within each particular grouping of services (lab, nursing, etc.) by selecting the service(s) from the dropdown then clicking the Complete/Incomplete buttons

 

 

If you choose “complete all”, then the completed procedures will default to a date of today.

In addition, you will need to select who the services were performed by from a dropdown list.

If you are marking a service as incomplete, please indicate the reason and leave any pertinent notes.

 

 

If you need to complete a service at another time, click the follow up button, assign this task to a person, and select a follow up date.

 

 

Please note that if you have multiple of the same service at one visit it will be listed multiple times.

This is determined by the quantity indicated on the visit calendar.

You must mark each service as complete, incomplete, or follow up, in order to complete a visit.

You are able to add services to an individual subject by selecting the service, and then indicating the quantity and clicking add service

The "Reset Visit" function looks back to the master calendar and to pull in new selected services from the calendar that didn't already exist on this visit. The function will also hide services that have been deleted on the master calendar on that visit.

In order to complete a visit you must either complete, incomplete, or add a follow up date for each procedure. Once you have done so on all procedures click the complete visit button to complete the visit

Notes are created each time a service is either completed, incomplete, or marked as “follow up.”

 

For users with Billing Manager rights, they are able to track services that have been invoiced by using the “Invoiced” Yes/No slider. Once invoiced, the date of the invoice is populated in the “Invoiced Date” field. If “Allow Credit” rights is selected for a user in SPARCCatalog, then a user can credit services by using the “Credited” Yes/No slider.

 

 

To add additional visit level notes click on the notes icon at the top of the visit.

 

 

At the top of each visit, you have the ability to indicate whether the visit is a Lab, Space, or PFT only visit through the drop down box.

 

 

You also have the ability to choose missed visit indications from the drop down and select why a specific visit did not occur.

Clinical Providers have the ability to toggle to a "Custom Order View" that allows the sequence of services to be customized for a participant on a given visit.

 

6D). Non-clinical Service Tab

All entities that offer Non-clinical (i.e. one-time fee) services will have a Non-clinical Services tab. Non-clinical services are designated in SPARCCatalog and provide the option to track work at a protocol level versus at a per-patient per-visit level (i.e. Clinical Services). Here you will see all of the requested services that have been sent to SPARCFulfillment. If a service needs to be added or removed in SPARCFulfillment, then users will need to route back to SPARCDashboard Admin Edit and “Sync to Fulfillment” for them to display. Under the Non-clinical Services tab in SPARCFulfillment, you will see the service name and the quantity requested. To add work performed on a specific service click the “List” button to the left of the requested service to drop down the fulfillment section.

Non-clinical Services in SPARCFulfillment

Sync Non-clinical Services from SPARCDashboard

Non-clinical Services in SPARCFulfillment

Sync Non-clinical Services from SPARCDashboard

 

 

 

 

Once the List is expanded, you will be able to add work performed by clicking the “Add Fulfillment” button.

A pop-up box will appear asking for the date work was performed, quantity performed, performed by (as the user, this section will default to you;

you have the ability to change the person who has performed the work if needed), and all fulfillment components, if available, completed during this instance.

Both Fulfillment users and components can be set up in SPARCCatalog. Click “Save” fulfillment when you are ready to continue.

 

For existing fulfillment items,

Billing Manager Users are able to flag a fulfillment as "Invoiced" with an editable “Invoiced Date” to ensure data integrity after work has been complete, as well as historical invoicing/billing;

Billing Manager Users with “Allow Credit“ rights are able to flag a fulfillment item as “Credited“, so that it won’t show on the invoice report as a chargeable item.

 

 

Users are able to edit or delete an individual fulfillment in the "Fulfillments List" popup window "Actions" dropdown menu, as long as they have not been selected as "Yes" for "Invoiced" or “Credited“.

 

Once a Fulfillment has been entered, the quantity completed will update. When looking at the requested service which was just fulfilled, you will see the quantity remaining was automatically calculated from the quantity performed. In the “Actions” Column, Fulfillment users have the ability to add notes, documents, and edit.

 

 

 

 

 

 

Before Fulfillment Added

 

 

 

 

Adding a New Fulfillment

 

 

 

 

 

 

After Fulfillment Added

 

 

More Details about Fulfillment “Actions” Column

More Details about Fulfillment “Actions” Column

 

Add/Edit/Delete Notes

 

Upload/Remove Documents

 

 

Copyright © 2011-2020 MUSC Foundation for Research Development