PowerSchool Special Programs to PowerSchool SIS Fields

PowerSchool Special Programs own the following data elements and will be written back to PowerSchool SIS for state reporting.

Understanding the Mapping Table

Each setup table may include some or all of the following elements. Reports will not display elements that are not pertinent to that report.

PowerSchool Special Programs Page – Navigation aid used to show the path to the data entry page as listed on the page in PowerSchool Special Programs. Each ">" indicates a new page or link. Example: Student > Profile.
Data Element – The name of the field as it appears in the state report.
PowerSchool SIS Page – The name of the field where the data is stored. {PrimaryDisability}
Reports – The name of each report that uses the data element. This field may be populated with "Required Setup" or "Not Required" to indicate whether the data element should be configured for Ohio state reporting not specific to a report.

PowerSchool Special Programs Page and Data Flow

Data Element

PowerSchool Page

Special Logic

Record Field Number

PowerSchool SIS Export\PS SIS Export FD Attribute (S_OH_STU_FD_X)

EMIS Element (FD) Student Attributes

Student>Profile > Special Education Information > Disability

Dataflow: Transfer Form and ETR Eligibility section or Transfer Notification Form

{Disability}

[S_OH_Stu_FD_X]

Disability

PowerSchool SIS does not store disability information historically. This field will upload the most recent primary disability in PowerSchool Special Programs to PowerSchool SIS as of "today." This API PS SIS Export report does NOT maintain history in PS SIS. The integration from PSSP will override the Disability value in this SIS screen.

FD130

Student>Profile > Section 504

Dataflow: Section 504 Eligibility - Eligibility Determination

{Five04Eligibility}

[S_OH_Stu_FD_X]

Section_504

PowerSchool SIS does not store 504 data historically. This field will upload the most recent primary disability in PowerSchool Special Programs to PowerSchool SIS as of "today". This API PS SIS Export report does NOT maintain history in PS SIS. The integration from PSSP will override the Section 504 value in this SIS screen.

FD140

PowerSchool SIS Export\PS SIS Export GE SE Record (S_OH_SEN_X) and (SpEnrollments)

EMIS (GE) Student Special Education Record

Student>Profile > EMIS > Event Type (Prompt says “Date Type”)

Keyword Table = EventTypes

Dataflow: ETR > Meeting Type or IEP > Cover Page> Meeting Type

{EventType}

[SpEnrollments]

SpecialEd_Date_Type

NA

GE100

Student>Profile > EMIS > Event Date

Dataflow: ETR > Meeting Date or IEP > Cover Page>Meeting Type

or Student Transfer Form>Date of Transfer Meeting

{EventDate}

[SpEnrollments]

Enter_Date

The {EventDate} is the trigger to create a new SPEnrollment record in PowerSchool Special Programs and PowerSchool SIS. NOTE: If the EventDate is corrected in PowerSchool Special Education, it will update the same record in the SPEnrollment in SIS.

GE110

Student>Profile > EMIS>Outcome

Keyword=EMISOutcomes

Dataflow: ETR > Eligibility > Disability or IEP > LRE

or Student Transfer Form > Student's LRE

{Outcome}

[S_OH_SEN_X]

SpecialEd_Outcome_ID

NA

GE120

Student>Profile > EMIS > Non-Compliance

Keyword = NonComplianceReasons

Dataflow: IEP > Cover Page drop-down appears based on logic

{NonCompliance}

[S_OH_SEN_X]

SpecialEd_NonCompliance_ID

NA

GE130

Student>Profile >EMIS > Begin Date

Dataflow: IEP > Cover Page > IEP Start Date or Student Transfer Form > Date of Transfer Meeting

{BeginDate}

[S_OH_SEN_X]

Outcome_Begin_Date

This field contains the date on which the outcome of

The event became effective. The format is YYYYMMDD. If the

GE140

Student>Profile > EMIS > End Date

Dataflow: IEP > Cover Page > IEP End Date or Student Transfer Form > Eligibility Review Due Date

{EndDate}

[S_OH_SEN_X]

Outcome_Exit_Date

SpEnrollments]Enter_Date when Outcome ID is IEDP,

IENS or IEPR else [SPENROLLMENTS.S_OH_SPENROLLMENTS_X] Outcome_End_Date when Date Type is IIEP,RIEP, AIEP, TIEP, IETR, RETR, CIEP, or TETR

GE150

Student > Profile > EMIS > Test Types

Keyword=EMISTestTypes

Dataflow: IEP > Exemptions > Graduation Tests

{TestType}

[S_OH_SEN_X]

Test_Type

if Date type is IIEP, RIEP, AIEP or

TIEP, AND the Outcome ID is not IEDP, IEEX, IENS

Or IEPR.

GE160

Student>Profile > EMIS > Secondary Plan

Keyword = SecondaryPlanStatuses

Dataflow: IEP > PostSecondary > Secondary Planning

{SecondaryPlan}

[S_OH_SEN_X]

Secondary_Planning

This field contains the result of transition planning on

the IEP for students age 14 and above. This field value

is extracted from the Secondary Planning field on the

Edit Special Program Enrollment page, Start Page

> Student Selection > special Programs > [New/Edit]Special Program Enrollment.

GE170

	PowerSchool Special Programs Page and Data Flow	Data Element	PowerSchool Page	Special Logic	Record Field Number
	PowerSchool SIS Export\PS SIS Export FE Grad -S_OH_STU_ED_GRAD_REQ_C
	EMIS Element (FE) Student Special Ed Graduation Requirement
FE-B	Student > Profile\EMIS\Student Special Education Graduation Requirement Record > IEP Date Type Keyword=Meetings Dataflow: IEP \ Exemptions \ Graduation Tests	{IEPType}	[S_OH_Stu_Spec_Ed_Grad_Req] IEP_Date_Type		FE060
FE-C	Student > Profile\EMIS\Student Special Education Graduation Requirement Record > IEP Date Type Date Dataflow: IEP \ Cover Page \ Meeting Type	{AnualReviewDate}	[S_OH_Stu_Spec_Ed_Grad_Req] IEP_Date		FE070
FE-A	Student > Profile\EMIS\Student Special Education Graduation Requirement Record > Assessment Type Code Dataflow: N/A	GX or GE (Right now hard-coded to “GX”)	[S_OH_Stu_Spec_Ed_Grad_Req] Test_Type		FE080
FE-D	Student > Profile\EMIS\Student Special Education Graduation Requirement Record > Assessment Area Code Keyword=GradAssessmentAreas Dataflow: IEP \ Exemptions \ Graduation Tests	{GradAssessmentArea}	[S_OH_Stu_Spec_Ed_Grad_Req] Test_Area		FE090
FE-E	Student > Profile\EMIS\Student Special Education Graduation Requirement Record > Exemption Flag Dataflow: N/A	{GraduationExempt}	[S_OH_Stu_Spec_Ed_Grad_Req] Exempt_YN		FE100