Notifications Report Data Dictionary (SPARCRequest 3.8.0)

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