Queue, 24 (ver3.6.1)
Storage place for automated tasks in PowerSchool. Task server looks in this table for execution.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Cmd | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CountValue | 3.6.1 | Number(10,0) | How many times the email message or other task in queue has been attempted. |
Date_Value | 3.6.1 | Date | The data for the transaction. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
TData1 | 3.6.1 | CLOB | Data for whatever is stored in the queue. |
TData2 | 3.6.1 | CLOB | Data for whatever is stored in the queue. |
TData3 | 3.6.1 | CLOB | Data for whatever is stored in the queue. |
TData4 | 3.6.1 | CLOB | Data for whatever is stored in the queue. |
TData5 | 3.6.1 | CLOB | Data for whatever is stored in the queue. |
Time | 3.6.1 | Number(10,0) | The time the record was created. |
TryAgainIndex | 3.6.1 | Number(10,0) | Timer for trying mail again. It tries to send an unsent message every 30 min or other tasks with minute offset specified. Indexed. |
Type | 3.6.1 | Number(10,0) | The kind of transaction in the queue; 100=email, 700=old portal count, 1200=Parsed XML2 documents that need to be deleted, 1300=Auto SAIS Communications. Communication reports can also be queued for printing. Indexed. |