Apptegy

Modified on Tue, Jun 6, 2023 at 2:11 PM

This task can export the results to:

The file generated is a TAB delimited file using the standard ISO-8859-1 characters.

This file contains a description of the attendance codes that will be found in the attendance.tsv file.

A row is created for each attendance code found on the attendance.setup.codes screen that is flagged for use in auto dialers.

The file generated is a TAB delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

A record is created for each student that has an attendance daily code posted today that is flagged for use in the auto dialer.

Student Data

This task can export the results to:

The file generated is a TAB delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

parents.tsv

All students from selected schools that have an enrollment status of ACTIVE are exported. A row is created for each Guardian Contact.

Column	Description	Sample
schoolID	Student current school code	HS
studentID	Local Studen tId
parentID	Internal Objectid of the guardian contact record
lastName	Contact Last Name
firstName	Contact First Name
middleName	Contact Middle Name
title	Contact Prefix
birthDate	Always blank
gender	Always blank
languageID	Student's Home Language (option for Primary)
address1	Pulled from the first Address on the contact
address2	Pulled from the first Address on the contact
city	Pulled from the first Address on the contact
state	Pulled from the first Address on the contact
zip	Pulled from the first Address on the contact
emailAddress1	First Email Address on the contact
emailAddress2	Second Email Address on the contact
smsNumber	First mobile phone number
smsCarrier	Carrier of first phone mobile number
homePhone1	Primary phone number
homePhone2	Non-Primary/Non-Work phone number of type "Land"
workPhone1	Always blank
workPhone2	Always blank
mobilePhone1	First Non-Primary mobile phone number
mobilePhone2	Second Non-Primary mobile phone number
otherPhone1	Always blank
otherPhone2	Always blank

Students.tsv

Column	Description		Sample
schoolID	Student current school code		HS
studentID	Local Studen tId
lastName	Student Last Name
firstName	Student First Name
middleName	Student Middle Name
birthDate	Student DOB
gender	Always blank
gradeLevel	Student Grade Level
languageID	Student primary language code		eng
address1	Pulled from the first Address on the Student contact
address2	Pulled from the first Address on the Student contact
city	Pulled from the first Address on the Student contact
state	Pulled from the first Address on the Student contact
zip	Pulled from the first Address on the Student contact
emailAddress1	First Email Address on the Student contact
emailAddress2	Always blank
smsNumber	First mobile phone number
smsCarrier	Carrier of first phone mobile number
homePhone1	Primary phone number
homePhone2	Always blank
workPhone1	Always blank
workPhone2	First work phone number
mobilePhone1	First mobile phone number
mobilePhone2	Always blank
otherPhone1	Always blank
otherPhone2	Always blank
staff.tsv
Column		Notes
username		Optional column. Looks for Logon Id's that are checked in Setup -> Security -> Teacher Assignments -> Modify.
staff ID
organizationid
lastName
firstName
title
directoryEmailAddress
directoryPhoneNumber		Home Phone or Voicemail field on staff record
gradeLevel

Files created: course.tsv, section.tsv, schedule.tsv, grades.tsv, busRoute.tsv.