S_IN_REMOTE_SUBMISSION_S (ver 15.7.0)
This table is a standalone table used to track e-Transcript submissions and the response sent back from the remote server for each submission.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 15.7.0 | Number(11,0) | System generated Primary Key. |
| Connection_Name | 15.7.0 | VarChar2(50) | Name from the S_IN_REMOTE_CONNECTION_S table identifying the connection that is made. |
| Destination_ID | 15.7.0 | VarChar2(50) | Used to identify the destination for the submission. |
| Destination_Name | 15.7.0 | VarChar2(200) | Used to identify the destination name for the submission. |
Entity_ID | 15.7.0 | VarChar2(50) | Used to identify the student for the submission (Students.student_number). |
Entity_Name | 15.7.0 | VarChar2(200) | Used to identify the student name for this submission (Students.lastfirst). |
| Response_Content | 15.7.0 | Clob | The detailed response information sent back from the remote server for this submission. |
| Status_Code | 15.7.0 | VarChar2(10) | The connection status code sent back from the remote server for this submission. |
| Status_Message | 15.7.0 | VarChar2(50) | The connection status message sent back from the remote server for this submission |
| Submission_Content | 15.7.0 | Clob | The content from the XML file that is to be submitted. |
Submit_Timestamp | 15.7.0 | Date | The timestamp for this submission. |
| URI | 15.7.0 | VarChar2(500) | The URI from the S_IN_REMOTE_CONNECTION_S table used for this submission. |