Built-in templates are available for exporting data into HealthOffice and 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 [>>].
The data in [Table 94] is exported to SETS:
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 |
|
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 |
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 |
|
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 |
|
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.