| Import/Export > Exporting data using built-in templates

Exporting data using built-in templates

Built-in templates are available for exporting data into HealthOffice and SETS.

Exporting data to HealthOffice\SETS

Exports to both HealthOffice and SETS are performed the same way, using scheduled jobs. The job can occur once - immediately or at a later time - or the job can occur repeatedly.

You can create multiple export jobs where each job has its own name and timing. Multiple jobs can use the same template, but they must export to a file with a unique file name. All exports are placed in the following location on the PowerSchool SMS web server: C://csl/opendistrictclient/ascii/exportfiles.

Note: Exports for SETS/HealthOffice are scheduled as "db server" tasks. That means if you changed the Task Manager settings for your servers so database server tasks are run on other servers, the location of the exports will change accordingly.

For each job, you choose the scope of the export - either all students or only the ones who enrolled in the last 30 days. This enables you to do a comprehensive export at the beginning of the year or whenever you want to update all students, as well as smaller exports that cover only new students.

For further details on what information is exported to SETS or HealthOffice, refer to SETS Export Data [>>] and HealthOffice Export Data [>>].

To export data to HealthOffice/SETS:[DA][SA]

Figure 389: General

SETS Export Data

The data in [Table 94] is exported to SETS:

Table 94: SETS export data

4GL Field

Description

PowerSchool SMS Schema.Property

Table.Field

Student Demographic Data

Student Ident

The student's internal ID.

DistrictStudent.DistrictStudentID

CSL_STD_DEMO_DISTRICT. ID_STD_DEMO_DISTRICT

Last Name

The student's last name.

DistrictStudent.Last Name

CSL_STD_DEMO_DISTRICT.LAST_NAME

First Name

The student's first name.

DistrictStudent.FirstName

CSL_STD_DEMO_DISTRICT. FIRST_NAME

DOB

The student's date of birth.

DistrictStudent.BirthDate

CSL_STD_DEMO_DISTRICT. BIRTH_DATE

Current Attending School

The student's home school.

SchoolName.SchoolNameID

CSL_SET_SCHOOL_NAME. ID_SET_SCHOOL_NAME

Note: For Tennessee, this maps to the student's school of enrollment, if "Instr Services Period of Service" is set to "Primary School assigned for the student".

Current Grade Level

The student's current grade.

Grade.Code

CSL_SET_GRADE.GRADE_CODE

Ethnic Code

The student's ethnic category.

EthnicCategory.Code

CSL_SET_ETHNIC_CATEGORY. ETHNIC_CATEGORY_CODE

Gender

The student's gender, either Male or Female.

DistrictStudent.Gender

CSL_STD_DEMO_DISTRICT.GENDER

Middle Name/ Initial

The student's middle name or middle initial.

DistrictStudent.MiddleName

CSL_STD_DEMO_DISTRICT. MIDDLE_NAME

Suffix

The generation of the same name (e.g., John Smith III).

DistrictStudent.Generation

CSL_STD_DEMO_DISTRICT.LINEAGE

SSN

The student's Social Security Number.

DistrictStudent.SSN

CSL_STD_DEMO_DISTRICT. SOCIAL_SECURITY_NUMBER

Current School of Residence

The school where the student resides.

Not supported.

Home Language

The language spoken in the student's home.

Language.Code

CSL_SET_LANGUAGE. LANGUAGE_CODE

Next School

The student's projected school.

School.SchoolID

CSL_VW_SCHOOL_INFO. ID_VW_SCHOOL_INFO

Residence Address

Address lines 1 and 2 of the student's physical address.

Address.AddressLine1 and AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_1 and ADDRESS_LINE_2

Residence City

The city indicated in the student's physical address.

City.Code

CSL_SET_CITY.CITY_CODE

Residence State

The state indicated in the student's physical address.

State.Code

CSL_SET_STATE.STATE_CODE

Residence Zip Code

The zip code indicated in the student's physical address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Mailing Address

Address lines 1 and 2 of the student's mailing address.

Address.AddressLine1 and AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_1 and ADDRESS_LINE_2

Mailing City

The city indicated in the student's mailing address.

City.Code

CSL_SET_CITY.CITY_CODE

Mailing State

The state indicated in the student's mailing address.

State.Code

CSL_SET_STATE.STATE_CODE

Mailing Zip Code

The zip code indicated in the student's mailing address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Status

The student's active status.

Not supported.

Graduation Date

The student's date of graduation.

Not supported.

Home Phone

The student's phone number.

StudentPhone.BasicNumber

CSL_STD_PHONE_NUMBER. BASIC_NUMBER

Contact Data

Student Ident

The student's internal ID.

DistrictStudent.DistrictStudentID

CSL_STD_DEMO_DISTRICT. ID_STD_DEMO_DISTRICT

Relationship

The relationship of the contact to the student.

Relationship.Description

CSL_SET_RELATION.RELATION_DESC

First Name

The contact's first name.

StudentContactOrdered.FirstName

CSL_VW_STUDENT_CONTACT. FIRST_NAME

Last Name

The contact's last name.

StudentContactOrdered.LastName

CSL_VW_STUDENT_CONTACT. LAST_NAME

Address

Address lines 1 and 2 of the contact's address.

Address.AddressLine1 and AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_1 and ADDRESS_LINE_2

City

The city indicated in the contact's address.

City.Code

CSL_SET_CITY.CITY_CODE

State

The state indicated in the contact's address.

State.Code

CSL_SET_STATE.STATE_CODE

Zip Code

The zip code indicated in the contact's address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Phone Number (Home)

The contact's home phone number.

ContactPhone.BasicNumber

CSL_CNT_PHONE_NUMBER. BASIC_NUMBER

Alternate Phone

An alternate phone number for the contact.

Not supported.

Alternate Phone Extension

The extension of the alternate phone number.

Not supported.

Phone Number (Work)

The contact's work phone number.

ContactPhone.BasicNumber

CSL_CNT_PHONE_NUMBER. BASIC_NUMBER

Work Phone Extension

The extension of the work phone number.

ContactPhone.Extension

CSL_CNT_PHONE_NUMBER. EXTENSION

Student resides with

Whether the student lives with the contact.

StudentContactOrder.LivesWith

CSL_VW_STUDENT_CONTACT. STUDENT_LIVES_WITH_CONTACT

Email

The contact's email address.

StudentContactOrdered.EmailAddress

CSL_VW_STUDENT_CONTACT. EMAIL_ADDRESS

4GL Status Info Data

Student Ident

The student's internal ID.

DistrictStudent.DistrictStudentID

CSL_STD_DEMO_DISTRICT.

School

The school to which the status record applies.

SchoolName.SchoolNameID

CSL_SET_SCHOOL_NAME. ID_SET_SCHOOL_NAME

Effective Date

The effective date for the status record.

StudentStatus.StartDate

CSL_STD_STATUS.STATUS_CODE_DATE

Enrollment Code

The entry or return status code.

Status.Code

CSL_SET_STATUS.STATUS_CODE

Withdrawal Code

The withdrawal status code.

Status.Code

CSL_SET_STATUS.STATUS_CODE

HealthOffice Export Data

The data in [Table 95] is exported to HealthOffice:

Table 95: HealthOffice export data

HealthOffice Field

Description

PowerSchool SMS Schema.Property

Table.Field

Student Demographic Data

Birth Date

The student's date of birth.

DistrictStudent.BirthDate

CSL_STD_DEMO_DISTRICT. BIRTH_DATE

Gender

The student's gender, either Male or Female.

DistrictStudent.Gender

CSL_STD_DEMO_DISTRICT.GENDER

First Name

The student's first name.

DistrictStudent.FirstName

CSL_STD_DEMO_DISTRICT. FIRST_NAME

Last Name

The student's last name.

DistrictStudent.Last Name

CSL_STD_DEMO_DISTRICT.LAST_NAME

Middle Name

The student's middle name.

DistrictStudent.MiddleName

CSL_STD_DEMO_DISTRICT. MIDDLE_NAME

Grade

The student's current grade.

Grade.Code

CSL_SET_GRADE.GRADE_CODE

Address Line 1

Address line 1 of the student's mailing address.

Address.AddressLine1

CSL_DIS_ADDRESS.ADDRESS_LINE_1

Address Line 2

Address line 2 of the student's mailing address.

Address.AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_2

City

The city indicated in the student's mailing address.

City.Code

CSL_SET_CITY.CITY_CODE

State

The state indicated in the student's mailing address.

State.Code

CSL_SET_STATE.STATE_CODE

Zip Code

The zip code indicated in the student's mailing address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Country

The country indicated in the student's mailing address.

Country.Code

CSL_SET_COUNTRY.COUNTRY_CODE

Social Security Number

The student's Social Security Number.

DistrictStudent.SSN

CSL_STD_DEMO_DISTRICT. SOCIAL_SECURITY_NUMBER

ID Number

The student's ID number.

DistrictStudent.Number

CSL_STD_DEMO_DISTRICT.NUMBER

Alert

Any medical alert message for the student.

DistrictStudent.MedicalAlert

CSL_STD_DEMO_DISTRICT. MEDICAL_ALERT

Phone Number

The student's phone number.

StudentPhone.BasicNumber

CSL_STD_PHONE_NUMBER. BASIC_NUMBER

Room

The student's homeroom.

HomeRoom.Room

CSL_SMS_HOMEROOM.ROOM_NUMBER

E-mail Home

The student's email address.

DistrictStudent.EmailAddress.

CSL_STD_DEMO_DISTRICT. EMAIL_ADDRESS

School ID

The license number of the student's home school.

School.LicenseNumber

CSL_VW_SCHOOL_INFO. CSL_LICENSE_NUMBER

Doctor Contact Information

Full Name

The doctor's full name.

DistrictStudent.DoctorName

CSL_STD_DEMO_DISTRICT. DOCTOR_NAME

Social Security Number

The doctor's Social Security Number.

Not supported.

Address Line 1

Address line 1 of the doctor's address.

Address.AddressLine1

CSL_DIS_ADDRESS.ADDRESS_LINE_1

Address Line 2

Address line 2 of the doctor's address.

Address.AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_2

City

The city indicated in the doctor's address.

City.Code

CSL_SET_CITY.CITY_CODE

State

The state indicated in the doctor's address.

State.Code

CSL_SET_STATE.STATE_CODE

Zip Code

The zip code indicated in the doctor's address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Phone Number (Home)

The doctor's home phone number.

Not supported.

Phone Number (Work)

The doctor's work phone number.

DoctorPhone.BasicNumber

CSL_STD_DOCTOR_PHONE. BASIC_NUMBER

Email

The doctor's email address.

Not supported.

Student Contact Information

First Name

The contact's first name.

StudentContactOrdered.FirstName

CSL_VW_STUDENT_CONTACT. FIRST_NAME

Last Name

The contact's last name.

StudentContactOrdered.LastName

CSL_VW_STUDENT_CONTACT. LAST_NAME

Social Security Number

The contact's Social Security Number.

Not supported.

Address Line 1

Address line 1 of the contact's address.

Address.AddressLine1

CSL_DIS_ADDRESS.ADDRESS_LINE_1

Address Line 2

Address line 2 of the contact's address.

Address.AddressLine2

CSL_DIS_ADDRESS.ADDRESS_LINE_2

City

The city indicated in the contact's address.

City.Code

CSL_SET_CITY.CITY_CODE

State

The state indicated in the contact's address.

State.Code

CSL_SET_STATE.STATE_CODE

Zip Code

The zip code indicated in the contact's address.

Address.ZipCode

CSL_DIS_ADDRESS.ZIP_CODE

Phone Number (Home)

The contact's home phone number.

ContactPhone.BasicNumber

CSL_CNT_PHONE_NUMBER. BASIC_NUMBER

Phone Number (Work)

The contact's work phone number.

ContactPhone.BasicNumber

CSL_CNT_PHONE_NUMBER. BASIC_NUMBER

Email

The contact's email address.

StudentContactOrdered.EmailAddress

CSL_VW_STUDENT_CONTACT. EMAIL_ADDRESS


www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com

Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.