| Contributors | ||||||
|---|---|---|---|---|---|---|
|
...
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 | ||
|---|---|---|
|
...