StateTransactionQueue, 103 (ver3.6.1)
Parses transactions info from StateEventQueue to send to other (right now state) systems. Used to build the XML file for transmission to the state's SAIS database at this time.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Filename | 4.0.0 | Varchar(79) | The StateTransactionQueue.FileName is the XML filename that the transaction (record) is associated to. PowerSchool creates an XML file with one or more transactions inside. The filename represents the XML filename and each record in the StateTransactionQueue represents a transaction within that file. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ModificationDate | 3.6.1 | Date | Date this transaction record (mainly transaction data) was modified. |
ModificationTime | 3.6.1 | Time | Time this transaction record (mainly transaction data) was modified. |
Operation | 3.6.1 | Varchar(8) | Passed from StateEventQueue - Action column, such as D=Delete. |
ResponseCode | 3.6.1 | Varchar(20) | Response codes returned by Engine. 1 - being processed, 2 - rejected due to validation errors, 3 - processed successfully,4 - pending, 5 - dead letter queue, 6 - failed validation, but will be retried, 7 - failed due to SAIS system error, but will be retried, 8 - failed validation, retry period expired, 9 - failed due to SAIS system error, retry period expired,10 - requires student matching. |
ResponseDate | 3.6.1 | Date | Date the response was received by Engine. |
ResponseText | 3.6.1 | CLOB | Any error text returned by Engine corresponding or with the Response code. |
ResponseTime | 3.6.1 | Date | Time the response was received by Engine. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record.. |
Status | 3.6.1 | Number(10,0) | Status of this transaction process.0=not processed, 2=manual, 3=active, 5=auto submit. 6=Year-end process. Indexed. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
SubmissionDate | 3.6.1 | Date | Date this transaction record was submitted to SAIS. |
TransactionData | 3.6.1 | BLOB | BLOB holding one or more key-pair values for different information such as student number, enrollment date, etc. |
TransactionID | 3.6.1 | Varchar(30) | Application generated number to identify this transaction. Once a transaction has an ID assigned, it is considered. |
TransactionType | 3.6.1 | Number(10,0) | Type of Transaction for this submission record. 1=a new student or new school year enrollment, 2= re-enrollment if previously enrolled this school year, 3=any type of withdrawal from school, 4=attendance sent as absences, 5=demographics, 6=change of membership status, 7=change of residency district, 8=change of FTE or membership share, 9=change of grade level, 10=change in tuition payer, also 10-19 at this time. |
YearID | 4.0.0 | Number(10,0) | This will be the year ID from the Terms table to indicate the term year that each record in the StateTransactionQueue is related to. |