AdminAlert (ver7.0.0)
This table contains status information about administrator alerts notifications when registering with the National Transcript Center (NTC). An activated registration directs the user to the Institution Mapping page. Rejected directs the user to the registration page. Either action is when the alert is considered read.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 7.0.0 | Number(10,0) | Unique sequential number generated by the application. Required. |
ReadDate | 7.0.0 | Timestamp(6) | Date and time the alert message was read. |
ReadFlag | 7.0.0 | Number(3,0) | 1 indicates the alert message was read by at least one PS admin user. Always 0 initially. Required. |
ReturnComment | 7.0.0 | Varchar2(200) | Optional comment sent from notification source. Current source is NTC. |
ReturnStatus | 7.0.0 | Varchar2(30) | Valid values: activated, no action, rejected. Required. |
WhenCreated | 7.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |