Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.