Skip to main content
Skip table of contents

AutoComm, 47 (ver3.6.1)

This table tracks AutoComm/AutoSend profiles. AutoComm is used for importing or exporting data files such as student and section info into or from PowerSchool or Legacy system on a scheduled basis.

Column NameInitial VersionData TypeDescription

Charset

4.2.1

Varchar(20)

Supported character sets.

Date1

3.6.1

Date

Used with auto send attendance between two dates. This is the start date.

Date2

3.6.1

Date

Used with auto send attendance between two dates. This is the end date.

Days

3.6.1

Varchar(20)

The day of the week AutoComm automatically goes off.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

Disabled

3.6.1

Number(10,0)

Flag to indicate you want the AutoComm process not run regardless of the schedule.

FTPAcctName

3.6.1

Varchar(20)

The users name to access the FTP site.

FTPFlag

3.6.1

Number(10,0)

Flag saying if FTP is to be used.

FTPHost

3.6.1

Varchar(60)

The address of the FTP server.

FTPPassword

3.6.1

Varchar(20)

The password for the FTP account.

FieldDeli m

3.6.1

Varchar(20)

The field delimiter in the file coming back.

Fields

3.6.1

CLOB

The fields being imported.

FileNum

3.6.1

Number(10,0)

Indicates the type of file for either import(autocomm) or export(autosend). <0: custom autosend, >0: download-autocomm, -100:attendance data, >-100 and 1 or -1: data from Student table, 2 or -2: from Courses for current school, 3 or -3: Sections for current year, 4 or -4: from CC for current year in current school, 5 or -5: teachers.

Hour

3.6.1

Number(10,0)

The time when AutoComm automatically goes off.

ID

3.6.1

Number(10,0)

Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.

ImportExport

3.6.1

Varchar(20)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

Minutes

3.6.1

Number(10,0)

The minutes past the hour the AutoComm runs.

Name

3.6.1

Varchar(60)

The name of the AutoComm operation.

PassiveMode

3.6.1

Number(10,0)

Flag to indicate the usage of passive FTP mode.

Path

3.6.1

CLOB

The path to the files on the remote system.

RecDelim

3.6.1

Varchar(20)

The separator between records.

ReportEm ail

3.6.1

CLOB

The email address of the person to notify when the AutoComm process runs.

SchoolID

3.6.1

Number(10,0)

The School_Number of the associated Schools record.

Search

3.6.1

CLOB

No longer used by the application. This field may still be referenced on reports and/or custom pages.

SortOrder

3.6.1

Number(10,0)

The order the AutoComm items show on lists.

StudentEnrollStatus

3.6.1

Number(10,0)

Flag to allow blanks to be written.

Surround

3.6.1

Number(10,0)

Surround text with quotes.

SynchMode

3.6.1

Number(10,0)

This is used to delete info, such as student, not in the file (default). Otherwise, it will just update or insert (1 IUD, 0 IU). Files other than Teacher and Courses need to be in Synch mode (1).

Timeout

3.6.1

Number(10,0)

Seconds before a failed connection should time out.

TransferMeth

3.6.1

Varchar(20)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

UpdateRecsMode

3.6.1

Number(10,0)

Flag to indicate update duplicate records.

UseNumberOfRecs

3.6.1

Number(10,0)

Flag to indicate you want to use the first line of the file containing the number of records as a check.

UseUploadType

3.6.1

Number(10,0)

Used with auto send attendance so blanks can be sent as an attendance character.

WhichAtt

3.6.1

Number(10,0)

Used with auto send attendance to indicate if you are sending all the attendance. `0=last 24 hrs; -1=send all; -2=since last upload; -3=date range.



 

JavaScript errors detected

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

If this problem persists, please contact our support.