eSchoolPlus SIS Integration
This guide provides information for data elements that are written between eSchoolPlus SIS and PowerSchool Special Programs in order to mitigate dual data entry.
Data Imports
eSchoolPlus SIS owns student demographic data (e.g., student name, gender, contacts, etc.). The data is imported into Special Programs using the Student Demographics import that can be generated manually or configured to run on a scheduled basis using an API process. This and other Import Layouts can be found by navigating to Administration, Configuration, Integration, then Import Layouts using data source type "eSP SIS Rest API.”
eSchoolPlus Data to PowerSchool Special Programs
ESchoolPlus own the following data elements and will integrate to PowerSchool Special Programs.
Student | Locations | District | Staff | Admin Users |
|---|---|---|---|---|
Student ID | ID | ID | ID | ID |
First / Middle / Last Name / Lineage | Name | Name | First / Middle / Last Name | First / Last Name |
Grade | Address / City / State / Zip | NA | Works At | |
Birth Date | District | NA | Work Email | Works At |
Address / City / State / Zip | NA | NA | Salutation | NA |
Gender | NA | NA | Position | NA |
Race | NA | NA | Work Phone | NA |
Ethnicity | NA | NA | NA | NA |
Residency Type | NA | NA | NA | NA |
Primary Language | NA | NA | NA | NA |
Home Phone | NA | NA | NA | NA |
Home School | NA | NA | NA | NA |
County of Residence | NA | NA | NA | NA |
Building of service | NA | NA | NA | NA |
Parent/Contact (1-4) Name | NA | NA | NA | NA |
Parent/Contact (1-4) Street/City/State/Zip | NA | NA | NA | NA |
Parent/Contact (1-4) Receives Letters | NA | NA | NA | NA |
Parent/Contact (1-4 Home Phone | NA | NA | NA | NA |
Parent/Contact (1-4) Work Phone | NA | NA | NA | NA |
Parent/Contact (1-4) Cell Phone | NA | NA | NA | NA |
Parent/Contact (1-4) Email | NA | NA | NA | NA |
Parent/Contact (1-4) Relationship | NA | NA | NA | NA |
Enrollment Start Date | NA | NA | NA | NA |
Enrollment Exit Date | NA | NA | NA | NA |
Discipline Data (see chart for details) | NA | NA | NA | NA |
Discipline Data
eSchoolPlus Screen/Field | Special Programs Discipline Profile | Logic |
|---|---|---|
Disc_incident.Incident_code | Reason {Reason} | NA |
Disc_incident.Incident_date | Suspension Start Date {SuspensionStartDate} | DISC_INCIDENT.INCIDENT_DATE and INCIDENT_TIME. |
Disc_Off_Action.End_Date | Suspension End Date {SuspensionEndDate} | When the Scheduled Duration of the incident is 1.00 or the Actual Duration is 1.00, then use the Incident Date from DISC_INCIDENT. |
Checks Yes if Disc_Off_Action.Action_Code has a state_code_equiv of S3 | In School Suspension {InSchoolSuspension} | NA |
Checks Yes if Disc_Off_Action.Action_Code has a state_code_equiv of S4 | Out of School Suspension {OutofSchoolSuspension} | NA |
Expulsion: Checks Yes if Disc_Off_Action.Action_Code has a state_code_equiv of S5, S6 or S7 | Expulsion {Expulsion} | NA |
Received Educational Services: Checks Yes if Disc_Off_Action.Action_Code has a state_code_equiv of S8 or S9 | Received Educational Services {ReceivedEdServ} | NA |
Unilateral: Checks Yes if Disc_Off_Action.Action_Code has a state_code_equiv starting with "R" other than R1 | Unilateral Removal by School Personnel {UnilateralRemoval} | If DISCTB_OFF_ACTION.STATE_CODE_EQUIV is S5, S6, or S7 and there is a Weapon Code or a Drug Code or a Bodily Injury Code, then this is true; otherwise this is false. |
HearingOfficer: N/A | Removal by Hearing Officer {RemovOfficer} | NA |
weapons: Checks Yes if Disc_Off_Weapon by incident_ID and offender to Disc_Offender. Any records linked will report a Yes | Weapon Offense {WeaponRemoval} | NA |
Drug: Checks Yes if Disc_Off_Drug by incident_ID and offender to Disc_Offender. Any records linked will report a Yes | Drug Offense {DrugRemoval} | NA |
Likely injury: Checks Yes if Disc_Off_Weapon by incident_ID and offender to Disc_Offender. Any records linked will report a Yes NOT applicable. | Likely Injury {HearingRemoval} | Not done by Integration |
Bodily Injury: Checks Yes if Disc_Off_Weapon by incident_ID and offender to Disc_Offender. Any records linked will report a Yes | Serious Bodily Injury {InjuryRemoval} | NA |
PowerSchool Special Programs Data to eSchoolPlus
PowerSchool Special Programs on the following data elements and will integrate them into eSchoolPlus. Administrators can access the export data via Reporting, Standard Reports, and eSPExport. Several reports select student data to submit to eSchoolPlus. Upon saving student Profile data, the data is written to the applicable report in real time. A scheduled task is run to upload the data to eSchoolPlus, comparing the data in eSchoolPlus to the data in the export reports. If the data does not exist, the data will be added to eSchoolPlus. If the data exists, data will be updated.
eSchoolPlus Screen / Field | Special Programs Profile / Field | Logic |
|---|---|---|
Emergency / Disability / Reg_Disability | Eligibility / Primary Exceptionality (Secondary / Third) {PrimaryDisability} {SecondaryDisability} {TertiaryDisability} | Creates a disability record if there is no active disability of the same Disability type when the student is Eligible (Found Eligible at Last Evaluation) check box is checked. Uses the latest of the two dates for the start date (Evaluation Report Date or Latest Reevaluation Date). |
Programs / IEP Indicator / Reg_Program | Eligibility / Special Ed Start Date {SpecialEdStartDate} | Creates an SPEC Program record where Found Eligible at last Evaluation is True and SpecialEdStartDate is not empty |
Personal / Special Education Summary / IEP Integration / IEPIntegration (IEP integration) | NA | Always reports a true (box is checked) to eSP. |
Personal / Special Education Summary / IEP / HasIEP (checkbox) | Eligibility / Found Eligible at Last Evaluation {FoundEligible} | True where Profile / Eligibility / Found Eligible at Last Evaluation is true. |
IEP Status (e.g., ASE, ISE) | Eligibility Profile | Uploads ASE where Found Eligible at last Evaluation is true (box checked) and Special Ed Start Date and Special Ed End Date are active as of "today". |
Gifted Profile | Uploads AGT if Student is eligible for Gifted and GWR date is less than or = today. | |
Section 504 Profile | Uploads 504 where Eligible is True and 504 Exit Date is blank. | |
Personal / Special Education Summary / IEP Status | Special Education Status | Creates a Status Description = Special Education with Special Ed, Start Date. |
NA | 504 Status | Creates a Status Description=504 where Student is Eligible Under Section 504 is True (check box is checked). Start Date = Date of 504 Eligibility Meeting. |
NA | Gifted Status | Creates a Status Description=Gifted where Student is Eligible for Gifted True (check box is checked). Start Date = GWR date. |
Personal | Eligibility / Planned Participation in PASA | Reports a Y value where Participation in PASA is true (box is checked) |
Programs / 504 Program | Section 504 / Student is Eligible under Section 504 {Determ_DB1} | Creates 504 Program if there is no active eSP 504 Program where Student is eligible is True (box checked) and Date of Section 504 Eligibility Meeting is populated. Date of Section 504 Eligibility Meeting is used for the Program Start Date. |
Personal | Section 504 / Student is Eligible under Section 504 {Determ_DB1} | Reports a Y value when student is eligible for 504 and Date of Section 504 Eligibility Meeting Date is populated. |
Programs / Gifted Reg_Program (ProgramID=Gift) with a Program_Value=GY Gifted IEP only | NA | Includes the student in the Export report where the student has a Gifted IEP Team Meeting date (GIEPTeamMeetingDate). Creates an eSP GY record with a start date = GIEPTeamMeetingDate and uses the Gifted Exit Date (GiftedExitDate) if populated. |
(ProgramID=Gift) with a Program_Value=GX Gifted, Does Not Receive Services | NA | Includes students where the Gifted NORA date is not blank and the GX Gifted value is checked (true). Uses the NORA date for the Program start date. The end date will always be blank. If the student ever ends the GX record, it will need to be manually updated in eSchoolPlus. |
(ProgramID=Gift) with a Program_Value=GS Student Receives Gifted Services through IEP | NA | Includes the student in the Export report where the Special Education Start Date (SpecialEdStartDate) is not blank and the Gifted Receiving Services through IEP checkbox on the Eligibility profile is checked (true) OR the Previous GS Receiving Services checkbox on the Eligibility profile is checked. Creates a GS eSchoolPlus record where the IS_IEP IEP tag is true, the GX-Gifted (GXGifted) checkbox on the Gifted profile is not checked and the Gifted Receiving Services through IEP is checked (true). The Special Education Start Date is the eSchoolPlus GS start date. The eSchoolPlus GS end date will report either the Special Education Exit Date or the Latest ReEvaluation Date if Gifted Receiving Services through the IEP is unchecked. |