SPARCRequest Wiki

Notifications Report Data Dictionary (SPARCRequest v3.12.1)

No.

Column Name

Description

Database Name

Source

Type

No.

Column Name

Description

Database Name

Source

Type

1

SRID

System generated from SPARCRequest

protocols.id - sub_service_requests.ssr_id

Automatically generated by SPARC application.

BIGINT(20)

2

Request Organization

The service provider receiving the notification

sub_service_requests.organization_id

SPARCDashboard Protocol Page Requests Table

BIGINT(20)

3

From

Sender of the notification

notifications.originator_id

SPARCDashboard messages page

BIGINT(20)

4

To

Receiver of the notification

notifications.other_user_id

SPARCDashboard messages page

BIGINT(20)

5

Date

The date the notification was sent

notifications.created_at

SPARCDashboard messages page

DATETIME

6

Subject

The title of the notification being sent

notifications.subject

SPARCDashboard messages page

VARCHAR(255)

7

Content

The body of the notification being sent

messages.body

SPARCDashboard messages page

TEXT

 

Sample Report

Excel: spreadsheet preview is finally here!

You can now display this file as a spreadsheet, instead of a PDF. Re-upload 2020-11-16...ons sample.xlsx to display the new preview. You can access the file here.

Copyright © 2011-2020 MUSC Foundation for Research Development