SIF_Message, 179 (ver4.2.0)
This table will contain the Schools Interoperability Framework (SIF) message information.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Agent_Ident | 4.2.0 | CLOB | Agent identification value. Indexed. |
Created_TS | 4.2.0 | Number(10,0) | Timestamp related to when this entry was created. |
DCID | 4.2.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.2.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Msg_Content | 4.2.0 | CLOB | Actual content of the SIF message (the message itself). |
Msg_guid | 4.2.0 | Varchar(32) | Global SIF Group/User identifier for SIF compliancy. |
Msg_Type | 4.2.0 | Varchar(40) | SIF Message type. |
Queue_Ident | 4.2.0 | Number(10,0) | Message Queue identifier. Indexed. |
Server_InstanceID | 4.2.0 | Number(10,0) | Identifier for the PowerSchool Server Instance. Indexed. |