Import Pennsylvania Data Files - Special Programs
Introduction
The Pennsylvania Data Files Import function provides users the functionality to import Special Education information into the Special Programs [SpEnrollments] table. From the start page in PowerSchool, access the function by selecting Special Functions on the left navigation of the start page. The import file must be tab delimited and have pre-defined format described below.
Special Programs [SpEnrollments] Table
Special Education Student Snapshot-Import Template
Data Element | Header Field Name | DDE:[Table]Field | Comments |
Student Number | Student_Number | [Students]Student_Number | Required-Unique number assigned to the student in PowerSchool |
Program ID | ProgramID | [SpEnrollments]ProgramID | Required |
Grade Level | Gradelevel | [SpEnrollments]gradelevel | Optional |
Enter Date | Enter_Date | [SpEnrollments]enter_date | Required |
Exit Date | Exit_Date | [SpEnrollments]exit_date | Optional- Exit code the student exited the special program with if applicable. |
Exit Code | ExitCode | [SpEnrollments]ExitCode | Optional |
School ID | SchoolID | [SpEnrollments]SchoolID | Required |
Include in Special Education Snapshot | PA_Include_State_Report | [S_PA_SEN_SPED_X]Include_State_Report_YN | 1 = True Indicates that the special program enrollment is to be included in the Special Education Snapshot |
Special Education Teacher Name | PA_Spec_Ed_Teach | [S_PA_SEN_SPED_X]SPED_Teacher_Name | Required- Last name of Special Education Teacher |
Secondary Disability | PA_Chall_Type | [S_PA_SEN_SPED_X]Secondary_Disability_Code | Secondary disability code for this special education enrollment. See the Disability Codes for valid values. |
Amount of Special Education Services | PA_Amount_Sp_Ser | [S_PA_SEN_SPED_X] Amount_SPED_Services_Code | See Amount of Special Education Services for valid values |
Service Provider Location | PA_Receive_Schl_Cd | [S_PA_SEN_SPED_X]Location_SPED_Services | Service Provider Location 4 chars max |
Type of Support | PA_Type_Support | [S_PA_SEN_SPED_X]Type_Support_Code | See Type of Support Codes for valid values |
Planned Participation in PASA | PA_PASA | [S_PA_SEN_SPED_X]PASA_YN | Planned Participation in PASA Y/N |
Residency | PA_Residency | [S_PA_SEN_SPED_X]Residency_Code | Residency
|
Neighborhood School | PA_Neigh_Sch | [SpEnrollments]PA_Neigh_Sch | Y/N |
Educational Environment | PA_LRE_Cat | [S_PA_SEN_SPED_X] Educational_Environment_Code | See Educational Environment for valid values. |
Service Provider (AUN) | PA_Serv_Prov | [S_PA_SEN_SPED_X]Service_Provider | 20 chars max |
Educational Environment Percentage | PA_Edu_Envir_Per | [S_PA_SEN_SPED_X] EDU_Environment_Percent | Numeric, 3 digits max |
Reason for Exiting Special Education | PA_Rea_Exit | [S_PA_SEN_SPED_X] Reason_Exited_SPED_Code | See Reason for Exiting Special Education Codes for valid values |
Date Exited Special Education | PA_Date_Exited_SpED | [S_PA_SEN_SPED_X]SPED_Exit_Date | format: mm/dd/yyyy |