MessageStaging (ver7.0.0)
This table contains records received from another district using Record and Transcript Exchange.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AttachmentCount | 7.0.0 | Number(10,0) | Number of attachments expected for an exchange record. Zero if no attachments sent with the record. Required. |
ID | 7.0.0 | Number(10,0) | Unique sequential number generated by the application. Required. |
ImportStatus | 7.0.0 | Number(3,0) | 0 - = Pending, 1 = Import Failed, 2 = Unrequested, 3 = Imported, 4 = Unrequested record has been read. Required. |
MessageData | 7.0.0 | CLOB | XML version of the data. Used for import into a student's record. Required. |
MessageInPDF | 7.0.0 | BLOB | PDF version of the record. |
ProviderSchoolName | 7.0.0 | Varchar2(64) | Name of the school from which the data originated. Extracted from the MessageData only for solicited requests. |
SolicitFlag | 7.0.0 | Number(3,0) | 1 indicates the record was requested by the receiving district. Required. |
StudentID | 7.0.0 | Number(10,0) | Internal number for the associated Student record. |
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. |