PowerSchool SIS Integration

This guide provides information for data elements written between your PowerSchool Student Information System (SIS) and PowerSchool Special Programs to mitigate the dual data entry.

The intent is to provide a single entry for student demographic data and migrate defined special education data through PowerSchool Special Programs and PowerSchool SIS.

Data Imports

PowerSchool SIS owns student demographic data (for example, student name, gender, contacts, etc.).  These data fields are imported into PowerSchool Special Programs using the Student Demographics import that can be generated manually or configured to run on a scheduled basis using an API Integration Tool.

This and other Import Layouts can be found by navigating to Administration, Configuration, Integration, and then Import Layouts using the PowerSchool SIS Rest API data source type.

The following is a list of Import Layouts available within the AL Model.

Export Reports

Administrators can access the export data through Reporting, Standard Reports, and PowerSchool SIS Export. Several reports select student data that will display in or pass through to PowerSchool SIS. 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 or through PowerSchool SIS, comparing the data in PowerSchool SIS with the data in the export reports. If the data does not exist, the data will be added to PowerSchool SIS. If the data exists, it will be updated. Data fields not existing in the PowerSchool SIS will flow to the ODS for state reporting and other data collections.

Menu Path

Choose Reporting from the main navigation menu, then choose Standard Reports, then select PowerSchool SIS Export.

Types of Report

The AL state model generates the following reports:

• PowerSchool Alert Export 
  This report includes the following information for the students listed in the table below:

  Field Name	Field Locations	Description
  IntegrationIDT	Student Record	The number assigned to students integrated with PowerSchool SIS.
  IS_504	Section 504 profile	Alert on student records when 504 Eligible is not NO and Section 504 Exit Date is empty.
  IS_EL	English Learners (EL) Profile	Alert on student records when EL Program Entry Date is not empty and EL Program Entry Date less than the current date and EL Program Exit Date is empty or EL Program Exit Date is greater than the current date.
  IS_GT	Gifted Profile	Alert on student records when Gifted Eligibility =True.
  IS_IEP	Special Education Profile	Alert on student records when Special Education Determined Eligible for Services (EligServices) is Yes AND IEP From Date (CurrentIEPStartDate) is less than the current date AND current date is less than the IEP To Date (CurrentIEPEndDate).
  IS_RTI	RTI Profile	Alert on student records when Date of Group Instructional Plan (GroupInstrPlanStartDate) is less than the current date OR Date of Individual Instructional Plan (IndividualInstrPlanDate) is less than the current date OR Date of Tier 3 Plan (Tier3InstrPlanDate) is less than the current date AND Intervention Exit Date (ParentLetIntExitLetDate) Is EMPTY.

  This data upload from Special Programs into PowerSchool SIS will show the applicable alert icon on student records.

• PS English Learner Export
  This report includes the following information for the students listed in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  StudentsDCID	N/A	The number assigned to students in PowerSchool SIS.
  StudentID	ID	The ID is assigned to student records.
  FirstName	Student's Name	Student's First Name
  LastName	Student's Name	Student's Last Name
  EL_TF	Alert flag	IS_EL
  CountryOfOrigin	County of Origin	Student's Country of Origin
  EL_Status	EL Status	Student's EL Status
  EL_PRO_ENTRY_DATE	EL Program Entry Date	This is the date the student entered the EL program.
  EL_PRO_EXIT_DATE	EL Program Exit Date	This is the date the student exited the EL program.
  EL_NO_FORMAL_SCH	Students with Interrupted Formal Education (SIFE)	This indicates the student had no formal schooling.
  EL_LIMITED_FORMAL_SCH	Students with Limited and Interrupted Formal Education (SLIFE)	This indicates the student has limited formal schooling.
  EL_Long_Term_Learner	Long-Term English Learner	This indicates the student is a long-term English Learner
  EL_WAVE_TITLE_III_SER_TF	EL Title III services waived	This indicates EL Title III services have been waived.

  This data will be uploaded from the Special Programs into the PowerSchool SIS table S_AL_STU_FEDERAL_X TABLE. Data in this report is extracted from the English Learner (EL) profile. This data will be displayed in the PowerSchool SIS fields in the EL area on the Federal Programs screen.

• PS Special Education Exports
  This report pulls data for students with an integration ID and a case manager that is not blank. This data will populate fields in the PowerSchool SIS, State/Province - AL menu, and Special Programs tab.

• S_AL_SpecEdPersonnel_S
  This is a district-level report and not a student-level report. It pulls Special Education Personnel data entered on the district document (Special Education Personnel Data Summary) that flows to the district profile and then to the report. The extract is created from an approved snapshot for state reporting. This report pulls the district-entered information as mentioned in the following table.

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  Audiologists	Audiologists	District count entered for this personnel category.
  CounselorsRehab	Counselors / Rehab	District count entered for this personnel category.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  Interpreters	Interpreters	District count entered for this personnel category.
  MedicalNursing	Medical Nursing	District count entered for this personnel category.
  Mobility	Mobility	District count entered for this personnel category.
  OccupaTherap	Occupational Therapists	District count entered for this personnel category.
  Orientation	Orientation	District count entered for this personnel category.
  Para3to5NotQual	Paraprofessionals Ages 3-5 Not Qualified	District count entered for this personnel category.
  Para3to5Qual	Paraprofessionals Ages 3-5 Qualified	District count entered for this personnel category.
  Para6to21NotQual	Paraprofessionals Ages 6-21 Not Qualified	District count entered for this personnel category.
  Para6to21Qual	Paraprofessionals Ages 6-21 Qualified	District count entered for this personnel category.
  PhysEdRecTeachers	Physical Education / Rec Teachers	District count entered for this personnel category.
  PhysicalTherap	Physical Therapists	District count entered for this personnel category.
  ProjectionYear	Projection School Year	The school year for the projected personnel counts.
  Psychologists	Psychologists	District count entered for this personnel category.
  SocialWorkers	Social Workers	District count entered for this personnel category.
  SpEd3to5Cert	Spec Ed Teachers Ages 3-5 who meet the applicable State certification and licensure requirements	The number of Special Education teachers for ages 3-5, ages 6-21, or both meets the applicable State certification and licensure requirements.
  SpEd3to5NotCert	Spec Ed Teachers Ages 3-5 who do not meet the applicable State certification and licensure requirements	The number of Special Education teachers for ages 3-5, 6-21, or both does not meet the applicable State certification and licensure requirements.
  SpEd6to21Cert	Spec Ed Teachers Ages 6-21 who meet the applicable State certification and licensure requirements	District count entered for this personnel category.
  SpEd6to21NotCert	Spec Ed Teachers Ages 6-21 who do not meet the applicable State certification and licensure requirements	District count entered for this personnel category.
  SpeechLangPath	Speech-Language Pathologists	District count entered for this personnel category.
  ApprovalDate	Approval Date	Date of approval for this report submission.

  This data will be uploaded from the Special Education Personnel Snapshot profile into the PowerSchool SIS table S_AL_SpecEdPersonnel_S.  A snapshot must be created and approved to create this table.

• S_AL_SpecEdSuppData_S
  This is a district-level report and not a student-level report. It pulls Supplemental Special Education data entered on the district document (Projected Special Education Supplemental Data) that flows to the district profile and then to the report. The extract is created from an approved snapshot for state reporting. This report includes the following information for the students listed in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  ProjectionYear	Projection School Year	The school year for the projected personnel counts.
  CollabSpecialEd	Collaborative Special Education	District count entered for Teachers - Projected Need.
  VisualImpairment	Visual Impairment	District count entered for Teachers - Projected Need.
  SpeechLangImpair	Speech / Language Impaired	District count entered for Teachers - Projected Need.
  HearingImpaired	Hearing Impaired	District count entered for Teachers - Projected Need.
  EarlyChildSpecialEd	Early Child Special Education	District count entered for Teachers - Projected Need.
  GiftedCertTea	Certified Gifted Teachers	District count entered for Teachers - Projected Need.
  PsychomPsycholo	Psychometrist/Psychologist	District count entered for Support Staff - Projected Need.
  OccupationalTher	Occupational Therapist	District count entered for Support Staff - Projected Need.
  CertOccupTherAssist	Certified Occupational Therapist Assistant	District count entered for Support Staff - Projected Need.
  Interpreter	Interpreter	District count entered for Support Staff - Projected Need.
  Audiologist	Audiologist	District count entered for Support Staff - Projected Need.
  Paraprofessional	Paraprofessional	District count entered for Support Staff - Projected Need.
  NonCertGiftedTea	Non-Certified Gifted Teachers	District count entered for Support Staff - Projected Need.
  PhysicalTherapist	Physical Therapist	District count entered for Support Staff - Projected Need.
  ApprovalDate	Approval Date	Date of approval for this report submission

  This data will be uploaded from the Special Education Supplemental Snapshot profile into the PowerSchool SIS table S_AL_SpecEdSuppData_S. A snapshot must be created and approved to create this table.

• S_AL_STU_ExitingStuData_X
  This report pulls the Student Exiting Special Education Information data for state reporting. This report pulls the State Reporting child profile and the Student Exiting Special Education Information area for students as mentioned in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  SchoolNumber	School Number	School number as assigned by the state.
  School	School Name	School name as assigned by the state.
  StudentDCID	Student DCID	The number assigned to students in PowerSchool SIS.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  Generation	Generation	Student's Generation
  BirthDate	Date of Birth	Student's date of birth
  Age	Age	Student's Age
  Race_A	Race - Asian	Student's race entered in SIS field - Race field.
  Race_B	Race - Black or African American	Student's race entered in SIS field - Race field.
  Race_H	Race - Hispanic	Student's race entered in SIS field - Race field.
  Race_I	Race - American Indian or Alaskan Native	Student's race entered in SIS field - Race field.
  Race_M	Race - Two or More Races	Student's race entered in SIS field - Race field.
  Race_P	Race - Native Hawaiian or Pacific Islander	Student's race entered in SIS field - Race field.
  Race_W	Race - White	Student's race entered in SIS field - Race field.
  Gender	Gender	Student's Gender
  IS_ELL	If the student is EL	Indicates if the student is currently EL.
  SpecialEducationExitDate	Special Education Exit Date	The date the student exited Special Education.
  SpecialEducationExitReason	Special Education Exit Reason	The reason the student exited Special Education.
  ExitExceptionality	Special Education Exiting Exceptionality	The student's Exceptionality at the time they exited Special Education.
  ReportStartDate	Report Start Date	The report start date.
  ReportEndDate	Report End Date	The report end date.
  ApprovalDate	Approval Date	Date of approval for this report submission.

  This data will be uploaded from the Special Education Exiting Student Snapshot profile into the PowerSchool SIS table S_AL_STU_ExitingStuData_X. A snapshot must be created and approved to create this table.

• S_AL_STU_GiftedReferralTrk_X
  This report pulls the Gifted Referral data for state reporting. This report pulls from the State Reporting child profile and the Gifted Referral Tracking area for students as mentioned in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  StudentsDCID	Student SSID	The number assigned to students in PowerSchool SIS.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  LastName	Student's Name	Student's Last Name
  FirstName	Student's Name	Student's First Name
  MiddleInt	Middle Initials	Student's Middle Initial
  SchoolID	School ID	This is the School ID number assigned by the state within the LEA.
  School	School Name	School name as assigned by the state.
  BirthDate	Date of Birth	Student's date of birth
  Race_A	Race - Asian	Student's race entered in SIS field - Race field.
  Race_B	Race - Black or African American	Student's race entered in SIS field - Race field.
  Race_H	Race - Hispanic	Student's race entered in SIS field - Race field.
  Race_I	Race - American Indian or Alaskan Native	Student's race entered in SIS field - Race field.
  Race_M	Race - Two or More Races	Student's race entered in SIS field - Race field.
  Race_P	Race - Native Hawaiian or Pacific Islander	Student's race entered in SIS field - Race field.
  Race_W	Race - White	Student's race entered in SIS field - Race field.
  Gender	Gender	Student's Gender
  Grade	Grade	Student's Grade
  GRefDate	Gifted Referral Date	Gifted Referral Date
  GRefSource	Gifted Referral Source	Gifted Referral Source
  GPassScreen	Gifted Passed Screening	Gifted Passed Screening Y or N checkboxes
  ATTest	Aptitudes - Test Administered	This is the Aptitude test administered in the first row.
  ATScore_S1	Aptitudes - Test Scores (S1)	This is the Aptitude test score entered in S1 in the first row.
  ATScore_S2	Aptitudes - Test Scores (S2)	This is the Aptitude test score entered in S2 in the first row.
  ATScore_S3	Aptitudes - Test Scores (S3)	This is the Aptitude test score entered in S3 in the first row.
  ATScore_S4	Aptitudes - Test Scores (S4)	This is the Aptitude test score entered in S4 in the first row.
  ATScore_S5	Aptitudes - Test Scores (S5)	This is the Aptitude test score entered in S5 in the first row.
  ATScore_S6	Aptitudes - Test Scores (S6)	This is the Aptitude test score entered in S6 in the first row.
  ATScore_S7	Aptitudes - Test Scores (S7)	This is the Aptitude test score entered in S7 in the first row.
  ATScore_S8	Aptitudes - Test Scores (S8)	This is the Aptitude test score entered in S8 in the first row.
  ATScore_S9	Aptitudes - Test Scores (S9)	This is the Aptitude test score entered in S9 in the first row.
  ATScore_S10	Aptitudes - Test Scores (S10)	This is the Aptitude test score entered in S10 in the first row.
  ATEligibleTest	Aptitudes - Eligible Test	This is the Aptitude Eligible test in the first row.
  GAptitudeTest2	Aptitudes - Test Administered (row 2)	This is the Aptitude test administered in the second row.
  GAptitudeTest2Score_S1	Aptitudes - Test Scores (S1) (row 2)	This is the Aptitude test score entered in S1 in the second row.
  GAptitudeTest2Score_S2	Aptitudes - Test Scores (S2) (row 2)	This is the Aptitude test score entered in S2 in the second row.
  GAptitudeTest2Score_S3	Aptitudes - Test Scores (S3) (row 2)	This is the Aptitude test score entered in S3 in the second row.
  GAptitudeTest2Score_S4	Aptitudes - Test Scores (S4) (row 2)	This is the Aptitude test score entered in S4 in the second row.
  GAptitudeTest2Score_S5	Aptitudes - Test Scores (S5) (row 2)	This is the Aptitude test score entered in S5 in the second row.
  GAptitudeTest2Score_S6	Aptitudes - Test Scores (S6) (row 2)	This is the Aptitude test score entered in S6 in the second row.
  GAptitudeTest2Score_S7	Aptitudes - Test Scores (S7) (row 2)	This is the Aptitude test score entered in S7 in the second row.
  GAptitudeTest2Score_S8	Aptitudes - Test Scores (S8) (row 2)	This is the Aptitude test score entered in S8 in the second row.
  GAptitudeTest2Score_S9	Aptitudes - Test Scores (S9) (row 2)	This is the Aptitude test score entered in S9 in the second row.
  GAptitudeTest2Score_S10	Aptitudes - Test Scores (S10) (row 2)	This is the Aptitude test score entered in S10 in the second row.
  GiftedAptitudeTest2Eligible	Aptitudes - Eligibility Test 2	This is the Aptitude Eligible test in the second row.
  GAptitudeTest3	Aptitudes - Test Administered (row 3)	This is the Aptitude test administered in the third row.
  GAptitudeTest3Score_S1	Aptitudes - Test Scores (S1) (row 3)	This is the Aptitude test score entered in S1 in the third row.
  GAptitudeTest3Score_S2	Aptitudes - Test Scores (S2) (row 3)	This is the Aptitude test score entered in S2 in the third row.
  GAptitudeTest3Score_S3	Aptitudes - Test Scores (S3) (row 3)	This is the Aptitude test score entered in S3 in the third row.
  GAptitudeTest3Score_S4	Aptitudes - Test Scores (S4) (row 3)	This is the Aptitude test score entered in S4 in the third row.
  GAptitudeTest3Score_S5	Aptitudes - Test Scores (S5) (row 3)	This is the Aptitude test score entered in S5 in the third row.
  GAptitudeTest3Score_S6	Aptitudes - Test Scores (S6) (row 3)	This is the Aptitude test score entered in S6 in the third row.
  GAptitudeTest3Score_S7	Aptitudes - Test Scores (S7) (row 3)	This is the Aptitude test score entered in S7 in the third row.
  GAptitudeTest3Score_S8	Aptitudes - Test Scores (S8) (row 3)	This is the Aptitude test score entered in S8 in the third row.
  GAptitudeTest3Score_S9	Aptitudes - Test Scores (S9) (row 3)	This is the Aptitude test score entered in S9 in the third row.
  GAptitudeTest3Score_S10	Aptitudes - Test Scores (S10) (row 3)	This is the Aptitude test score entered in S10 in the second row.
  GiftedAptitudeTest3Eligible	Aptitudes - Eligibility Test 3	This is the Aptitude Eligible test in the third row.
  GCharInstrument	Characteristics RS	This is the Characteristics test entered.
  GCharSubscale	Characteristics A	This is the Characteristic Sub-scale entered.
  GCharPoints	Characteristics PE	These are the Characteristic Points entered.
  GiftedIndicator1	Performance P1	This is the Performance Indicator test entered in row 1.
  GiftedIndicatorPoints1	Performance S1	These are the Performance Indicator points entered in row 1.
  GiftedIndicator2	Performance P2	This is the Performance Indicator test entered in row 2.
  GiftedIndicatorPoints2	Performance S2	These are the Performance Indicator points entered in row 2.
  GiftedIndicator3	Performance P3	This is the Performance Indicator test entered in row 3.
  GiftedIndicatorPoints3	Performance S3	These are the Performance Indicator points entered in row 3.
  GNumDays	Number of days fr Ref. to Elig	This is the number of days from the Gifted Referral date to the Gifted Eligibility date.
  GEligibility	Gifted Eligibility	This is a Yes, No, NA entered for Gifted Eligible.
  GEligDate	Gifted Eligibility Date	This is the date of Gifted Eligibility.
  GTrackCom	Tracking Log Comments	This the comments entered for the tracking log.
  GTimeDelays	Timeline Delays	This is the reason for the timeline delays that have been entered.
  StartDate	Start Date	This is the report start date.
  EndDate	End Date	This is the report's end date.
  ApprovalDate	Approval Date	Date of approval for this report submission

  This data will be uploaded from the Special Programs Gifted Referral Snapshot profile into the PowerSchool SIS table S_AL_STU_GiftedReferralTrk_X. A snapshot must be created and approved to create this table.

• S_AL_STU_PostSchoolSurvey_X
  This report pulls student data from the Post-School Student Survey data for state reporting. This report pulls the State Reporting child profile and the Post-School Student Survey Output area for students as mentioned in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  StudentsDCID	Student SSID	The number assigned to students in PowerSchool SIS.
  StudentID	ID	The ID is assigned to student records.
  LastName	Student's Name	Student's Last Name
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  Race_A	Race - Asian	Student's race entered in SIS field - Race field.
  Race_B	Race - Black or African American	Student's race entered in SIS field - Race field.
  Race_H	Race - Hispanic	Student's race entered in SIS field - Race field.
  Race_I	Race - American Indian or Alaskan Native	Student's race entered in SIS field - Race field.
  Race_M	Race - Two or More Races	Student's race entered in SIS field - Race field.
  Race_P	Race - Native Hawaiian or Pacific Islander	Student's race entered in SIS field - Race field.
  Race_W	Race - White	Student's race entered in SIS field - Race field.
  Gender	Gender	Student's Gender
  BirthDate	Date of Birth	Student's date of birth
  HomePhone	Telephone	Student's Home Phone number
  Exceptionality	Exceptionality	Student's Exceptionality
  LRECode	LRE Code	Least Restricted Environment (LRE) code.
  PostSchGoalSchool	Post-School Goals	Post-School goals entered for the student.
  PostSchGoalEmployment	Post-School Goals Employment	Post-School goals Employment entered for the student.
  PostSchGoalOther	Post-School Goals Other	Post-School goals Other entered for the student.
  PostSchExit	Post-School Exit	Post-School Exit date
  PostSchServiceFrmGenEdTea	Post School Service from Gen. Ed. Teacher	The former student’s high school program included instruction/services from - Gen Ed Teacher.
  PostSchServFrmSpecEdTea	Post-School Service from Special Ed Teacher	The former student’s high school program included instruction/services from - Special Ed Teacher.
  PostSchServFrmCarTechTea	Post-School Service from Career Tech Teacher	The former student’s high school program included instruction/services from - Career Tech Teacher.
  PostSchSrvFrmJobCoach	Post-School Service from Job Coach	The former student’s high school program included instruction/services from - Job Coach.
  PostSchSrvFrmRehabCounsel	Post School Service from Rehab Counselor	The former student’s high school program included instruction/services from - Rehab Counselor.
  PostSchPersInv	Person Interviewed / Contacted	Person Interviewed or Contacted
  PostSchPersInvOther	Person Interviewed / Contacted: Other: Explain	Person Interviewed or Contacted: Other: Explain
  PostSchInterviewer	Post School Interviewer	A person who interviewed or contacted the student.
  PostSchIntCompDt	Interview Completed Date	Interview Completed Date
  PostSchIntWasAble	Post-School Interview Attempt	If the Interviewer was able or not able to reach the student.
  PostSchFirstAttDt	Date and Time of the First attempt	Date and Time of the First attempt
  PostSchFirstAttReason	Post School First Attempt Reason	Post School First Attempt Reason
  PostSchSecondAttDt	Date and Time of the Second attempt	Date and Time of the Second attempt
  PostSchSecondReason	Post School Second Attempt Reason	Post School Second Attempt Reason
  PostSchThirdAttDt	Date and Time of the Third Attempt	Date and Time of the Third Attempt
  PostSchThirdAttReason	Post-School Third Attempt Reason	Post-School Third Attempt Reason
  PostSchPayingJob	Post-School Paying Job	Survey response to question 1. Did you have a paying job at the time you left high school?
  PostSchEverWorked	Post-School Ever Worked	Survey response to question 2. At any time after leaving high school, have you ever worked?
  PostSchNotWorked	Post-School Not Worked	Survey response to question 3. If you have NOT worked at any time since leaving high school, is it mainly because of you…
  PostSchWorkedLongIn	After leaving high school, have you worked longest in . . .	Survey response to question 4. After leaving high school, have you worked longest in . . .
  PostSchDaysWorked	Post-School Days Worked	Survey response to question 5. After leaving high school, how many days have you worked at your job (or jobs)?
  PostSchDaysWorkedAt	Post-School Days Worked At	Survey response to question 5 part two, If you worked 90 days or more, where did you work?
  PostSchPaid	Post-School Paid	Survey response to question 6. How much are you/were you usually paid for your job?
  PostSchPaidTips	Post-School Paid Tips	If less than minimum wage, did you receive tips at your job?
  PostSchJobBenf_Insurance	Post-School Job Benefits - Insurance	Survey response to question 7. Does/Did the job provide the following benefits?
  PostSchJobBenf_Leave	Post-School Job Benefits - Leave	Survey response to question 7. Does/Did the job provide the following benefits?
  PostSchJobBenf_Other	Post-School Job Benefits - Others	Survey response to question 7. Does/Did the job provide the following benefits?
  PostSchJobBenf_NoReply	Post-School Job Benefits - No Response	Survey response to question 7. Does/Did the job provide the following benefits?
  PostSchEmpHelp	Post-School Employment Help	Survey response to question 8. To assist you in your employment after leaving high school, have you asked for help because you have a disability?
  PostSchRecdHelp	Post-School Received Help	Survey response to question 9. Have you received the help requested for your employment since leaving high school?
  PostSchEnrEdTraining	Post-School enrolled in education or training	Survey response to the question, 10. At any time since leaving high school, have you ever been enrolled in any type of education or training program?
  PostSchDescrEdTrain	Post-School description of education or training	Survey response to question 11. Describe the kind of postsecondary education or training program.
  PostSchSemEdTrain	Post-School semesters enrolled in education or training	Survey response to question 12. After leaving high school, how many semesters have you been continuously enrolled in postsecondary education or training?
  PostSchPrepForJob	Post-School prepare you for a job	Survey response to question 13. After leaving high school, have you been, or are you currently, enrolled in an education or training program to prepare you for a job?
  PostSchReqFrProgOffice	Post School Request for accommodation from the program office	Survey response to question 14. To assist you in your education or training program after leaving high school, have you requested any accommodation from the program office that is supposed to help persons with disabilities?
  PostSchRecAccReg	Post School received accommodation requested	Survey response to question 15. Have you received the accommodation requested for your education or training program attended since leaving high school?
  PostSchNoTrainEdBecause	Post School No training or education	Survey response to question 16. If you have NOT received any type of training or education at any time since leaving high school, is it mainly because you?
  StartDate	Start Date	This is the report start date.
  EndDate	End Date	This is the report's end date.
  ApprovalDate	Approval Date	Date of approval for this report submission

  This data will be uploaded from the Special Programs Post School Snapshot profile into the PowerSchool SIS table S_AL_STU_PostSchoolSurvey_X. A snapshot must be created and approved to create this table.

• S_AL_STU_PreschoolTracking_X
  This report pulls data for EI to Preschool students data for state reporting. This report pulls data from the State Reporting child profile and the EI to Preschool Tracking area for students as mentioned in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  StudentsDCID	Student DC ID	The number assigned to students in PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  Generation	Generation	Student's Generation
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  BirthDate	Date of Birth	Student's date of birth
  EINoticeDate	Date Letter of Notification Received from EL	Date Letter of Notification Received from EL
  EILess90Days	Eligible for EI services (under part C) less than 90 days	Eligible for EI services (under part C) less than 90 days.
  TransitionEIDate	Date of EI Transition Meeting	Date of EI Transition Meeting
  ReferralType	Type of Referral	Type of Referral
  EIIntEligibilityDate	Date of Initial Eligibility Determination	Date of Initial Eligibility Determination.
  PSEligible	Determined Eligible for EI Services	Determined Eligible for EI Services.
  EligBy3	Eligibility Determined Before 3rd Birthday	Eligibility Determined Before 3rd Birthday.
  EIRangeofDays	Range of Days Eligibility Determined After 3rd Birthday	If "No," Range of Days Eligibility Determined After 3rd Birthday.
  EIParentDelay	Parent Delays	Reasons for delay in eligibility determination - Parent Delays.
  EIOtherDelay	Eligibility Determination - Other Delays	Reasons for delay in eligibility determination - Other Delays.
  EIIntIEPDate	Date of Initial IEP Meeting for EL students	Date of Initial IEP Meeting for EL students.
  IEPBy3rdBthday	IEP Developed and Implemented by 3rd Birthday	IEP Developed and Implemented by 3rd Birthday.
  EIIEPRange	EI IEP range	If "No," Range of Days IEP Developed And Implemented After 3rd Birthday.
  EIIEPOtherRsn	EI IEP Other Reason	Reason for Late (or no) IEP Development and Implementation - Other Delay.
  EIIEPParentRsn	EI IEP Parent Reason	Reason for Late (or no) IEP Development and Implementation - Parent Delay.
  SignConsInitEval	Signed Consent received for Initial Evaluation	Date Signed Notice and Consent for Evaluation Received in Public Agency/LEA.
  StartDate	Start Date	This is the report start date.
  EndDate	End Date	This is the report's end date.
  ApprovalDate	Approval Date	Date of approval for this report submission.

  This data will be uploaded from the Special Programs PSTracking Snapshot profile into the PowerSchool SIS table S_AL_STU_PreschoolTracking_X. A snapshot must be created and approved to create this table.

• S_AL_STU_SpecEdProfile_X_1
  This report pulls all Special Education data fields from the Special Education Profile for students.

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  StudentsDCID	Students DC ID	The number assigned to students in PowerSchool SIS.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  SchoolID	School ID	This is the School ID number assigned by the state within the LEA.
  School	School Name	School name as assigned by the state.
  CaseManager	Case Manager	Case Manager
  Status	Status	Status
  ReferralDate	Referral Date	Referral Date
  ReferralType	Type of Referral	Type of Referral
  ConsInitEval	Notice and Consent for Initial Evaluation	Notice and Consent for Initial Evaluation.
  SignConsInitEval	Date Signed Notice and Consent for Evaluation Received in Public Agency	Date Signed Notice and Consent for Evaluation Received in Public Agency.
  EvalCompleteDate	Final Completion Date of All Evaluations	Final Completion Date of All Evaluations.
  RevIniEvalConsDate	Date of Revocation of Consent/Initial Evaluation	Date of Revocation of Consent/Initial Evaluation.
  InitialEligibilityDate	Initial Eligibility Date	Initial Eligibility Date
  InitExceptionality	Initial Exceptionality	Initial Exceptionality
  EligServices	Eligible Services	Eligible Services - Y or N check box
  Evalin60Days	Evaluations Completed within 60 Days	Evaluations are Completed within 60 Days.
  ExcessDays	If "NO," Range of Days:	Range to days when evaluations are not completed within 60 days.
  EvalDelayRea	Reason for Late Evaluation	Reason for Late Evaluation
  Eligwithin30Days	Eligibility within 30 Days from the Completion Date of All Evaluations	Eligibility within 30 Days from the Completion Date of All Evaluations
  MostRecEligDate	Date of Most Recent Eligibility Determination	Date of Most Recent Eligibility Determination
  WritAgrReevalDueDate	Written Agreement - The next reevaluation for continued eligibility determination is due	Written Agreement - The next reevaluation for continued eligibility determination is due.
  EligMeetDueDate	Next Eligibility Meeting Due Date	Next Eligibility Meeting Due Date
  ConReevalSentDate	Notice of Consent For Reevaluation Date	Notice of Consent For Reevaluation Date
  ConReevalRcdDate	Date Consent for Reevaluation Received	Date Consent for Reevaluation Received
  NotEligibleDate	No Longer Eligible Date	No Longer Eligible Date
  IntIEPDate	Date of Initial IEP	Date of Initial IEP
  IntConServicesRcdDate	Consent for the Provision of Services	Consent for the Provision of Services
  IEPSignDate	IEP Signature Date	IEP Signature Date
  CurrentIEPStartDate	Current IEP Start Date	IEP From Date
  CurrentIEPEndDate	Current IEP End Date	IEP End Date
  ReviewDate	Review Date	Review Date
  AnRevDueDate	Annual Review Due Date	Annual Review Due Date
  LRECode	LRE Code	Least Restrictive Environment (LRE) Code
  ALAltAssPart	Alabama Alternate Assessment Participation	Alabama Alternate Assessment Participation
  StuInv	Student Invited	Student Invited
  OthAgen	Other Agency	Other Agency
  CourOfStudy	Course of Study	Course of Study
  ProgCred	Program Credits to be Earned	Program Credits to be Earned
  TransAsses	Transition Assessment	Transition Assessment
  TransGoals	Transition Goals	Transition Goals
  TransServ	Transition Services	Transition Services
  IEPAnnualReviewDueDate	IEP Annual Review Due Date	This is the date the next IEP Annual Review is due.
  CurrentEvaluationDate	Current Evaluation Date	Current Evaluation Date
  ReevaluationDueDate	Reevaluation Due Date	Reevaluation Due Date
  SpEdRightsDate	Special Education Rights Date	Special Education Rights Date
  InvMeetDate	Notice and Invitation to a Meeting	Notice and Invitation to a Meeting
  Transportation	Transportation Related	Transportation Related
  GraduationMonth	Anticipated Date of Exit - Month	Anticipated Date of Exit - Month
  GraduationYear	Anticipated Date of Exit - Year	Anticipated Date of Exit - Year
  GraduationPath	Graduation Pathway	Graduation Pathway
  TranRightsDate	Transfer of Rights	Transfer of Rights
  SpecialEducationExitDate	Special Education Exit Date	Special Education Exit Date
  SpecialEducationExitReas	Special Education Exit Reason	Special Education Exit Reason
  ExitExceptionality	Exiting Exceptionality	Exiting Exceptionality
  FBABIPDate	FBA/BIP Meeting Date	FBA/BIP Meeting Date
  HearScrDate	Hearing Screening Date	Hearing Screening Date
  HearScrResults	Hearing Screening Results	Hearing Screening Results
  VisScrDate	Vision Screening Date	Vision Screening Date
  VisScrResults	Vision Screening Results	Vision Screening Results
  InStateTransfer	In-State Transfer	In-State Transfer
  OutofStateTransfer	Out-of-State Transfer	Out-of-State Transfer
  MedConDate	Medicaid Consent Date	Medicaid Consent Date
  MedNotDate	Medicaid Notification Date	Medicaid Notification Date

  This data will be uploaded from the Special Programs Special Education profile into the PowerSchool SIS table S_AL_STU_SPECEDPROFILE_X.

• S_AL_STU_SpecEdProfile_X_2
  This report pulls Special Education data for students. This report pulls student data from the Preschool Profile, Gifted Profile, and Section 504 Profile for students listed in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  StudentsDCID	Students DC ID	The number assigned to students in PowerSchool SIS.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  EIReferralDate	Date of Referral Signature from EI	Date of Referral Signature from EI
  TransitionEIDate	Date of EI Transition Meeting	Date of EI Transition Meeting
  EINoticeDate	Date letter of Notification from EI Received	Date letter of Notification from EI Received
  EIIntEligibilityDate	Date of Initial Eligibility Determination (EI Only)	Date of Initial Eligibility Determination (EI Only)
  PSEligible	Determined Eligible for Services - EI to PS	Determined Eligible for Services - EI to PS
  EligBy3	Eligibility Determined Before 3rd Birthday	Eligibility Determined Before 3rd Birthday
  EIRangeofDays	If NO, Range of Days Eligibility Determined After 3rd Birthday	If NO, Range of Days Eligibility Determined After 3rd Birthday.
  EILess90Days	Eligible for EI services (under part C) less than 90 days	Eligible for EI services (under part C) less than 90 days
  EIParentDelay	Reason for Late (or no) Eligibility Determination - Parent Delays	Reason for Late (or no) Eligibility Determination - Parent Delays
  EIOtherDelay	Reason for Late (or no) Eligibility Determination - Other Delays	Reason for Late (or no) Eligibility Determination - Other Delays
  EIIntIEPDate	Date of Initial IEP Meeting for EI students	Date of Initial IEP Meeting for EI students
  PreServBegDate	Preschool Services Begin Date (3-5 yrs. old)	Preschool Services Begin Date (3-5 yrs. old)
  IEPBy3rdBthday	Eligibility determined before 3rd birthday	Eligibility determined before 3rd birthday
  EIIEPRange	If NO, range of days IEP developed after 3rd birthday	If NO, range of days IEP developed after 3rd birthday
  EIIEPParentRsn	Reason for Late (or no) IEP development - Parent Delays	Reason for Late (or no) IEP development - Parent Delays
  EIIEPOtherRsn	Reason for Late (or no) IEP development - Other Delays	Reason for Late (or no) IEP development - Other Delays
  DateConsentReceived	Date of Section 504 Consent to Evaluate	Date of Section 504 Consent to Evaluate
  Section504EligMeetingDate	Date of Section 504 Eligibility Meeting	Date of Section 504 Eligibility Meeting
  Five04Eligibility	The student is eligible under Section 504	The student is eligible under Section 504
  Section504ReEval	Section 504 Re-evaluation	Section 504 Re-evaluation
  Section504MeetingDate	Section 504 Meeting Date	Section 504 Meeting Date
  Section504StartDate	Section 504 Meeting Date	Section 504 Meeting Date
  Section504AntReview	Section 504 Date of Anticipated Review	Section 504 Date of Anticipated Review
  Section504ToIEPTransition	Section 504 Date Transitioned to IEP	Section 504 Date Transitioned to IEP
  MDRDate	Manifestation Determination Review	Manifestation Determination Review
  Section504ExitDate	Date Exited Section 504	Date Exited Section 504
  Section504ExitReason	Reason Exited Section 504	Reason Exited Section 504
  GiftedTeacher	Gifted Teacher	Gifted Teacher
  GStatus	Gifted Referral Status	Gifted Referral Status
  GStatusOther	Gifted Status Other	Gifted Referral Status - Other
  GConDenied	Gifted Consent Denied	Gifted Consent Denied
  GPartStatus	Gifted Participation Status	Gifted Participation Status
  GPartStatusOther	Gifted Participation Status Other	Gifted Participation Status - Other
  GRefDate	Gifted Referral Date	Gifted Referral Date
  GRefSource	Gifted Referral Source	Gifted Referral Source
  GPassScreen	Gifted Passed Screening	Gifted Passed Screening
  GEligibility	Gifted Eligibility	Gifted Eligibility
  GEligDate	Gifted Eligibility Date	Gifted Eligibility Date
  GPsyTestDate	Psychological Test Date	Psychological Test Date
  GEPToGrade	GEP to Grade	GEP to Grade
  GEPFromGrade	GEP from Grade	GEP from Grade
  GTrackCom	Tracking Log Comments	Tracking Log Comments
  GTimeDelays	Gifted Time Delays	Gifted Time Delays
  ParentLetIntEntrLetDate	Date Parent Letter for Intervention	RTI - Date Parent Letter for Intervention
  ParentLetIntExitLetDate	Intervention Exit Date	RTI - Intervention Exit Date
  GroupInstrPlanStartDate	Date of Group Instructional Plan	RTI - Date of Group Instructional Plan
  GroupInstrPlanReviewDate	Review Date of Group Instruction Plan	RTI - Review Date of Group Instruction Plan
  IndividualInstrPlanDate	Date of Individual Instructional Plan	RTI - Date of Individual Instructional Plan
  Tier3InstrPlanDate	Date of Tier 3 Plan	RTI - Date of Tier 3 Plan
  IS_ELL	If the student is EL	Indicates if the student is currently EL.
  CountryOfOrigin	County of Origin	Student's Country of Origin
  ELStatus	EL Status	EL Status
  ELProgramEntryDate	EL Program Entry Date	EL Program Entry Date
  ELProgramExitDate	EL Program Exit Date	EL Program Exit Date
  ELNoFormalSchooling	Student with Interrupted Formal Education (SIFE)	EL - Student with Interrupted Formal Education (SIFE)
  ELLimitedFormalSchooling	Student with Limited and Interrupted Formal Education (SLIFE)	EL - Student with Limited and Interrupted Formal Education (SLIFE)
  ELLongTermLearner	Long-Term English Learner	EL - Long-Term English Learner
  ELWaivedTitleIIIServices	EL Waived Title III Services	EL Waived Title III Services
  NotifyOfTransfer	Notify OfTransfer	Indicate that the student is transferring between districts

  This data will be uploaded from the Special Programs into the PowerSchool SIS table S_AL_STU_SpecEdProfile_X_2.

• S_AL_STU_STATE_ChildCount_X
  This report pulls students that have integrationIDT that is not empty and ApprovalDate is not empty in the Child Count Snapshot report. This report contains the student data when the snapshot data has been Approved by selecting Approve Reporting Snapshot in the Child Count Snapshot report. See data collected in the table below:

  Field Name	Field Label	Description
  Integrationidt	N/A	The number assigned to students integrated with PowerSchool SIS.
  StudentsDCID	Students DCID	The number assigned to students in PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  ID	Student ID	The state ID number assigned to the student in PowerSchool SIS.
  School	School Name	School name as assigned by the state.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  Generation	Generation	Student's Generation
  Grade	Grade	Student's Grade
  BirthDate	Birth Date	Student's date of birth
  Age	Age	Student's Age
  SchoolYear	School Year	School Year
  Race_A	Race - Asian	Student's race entered in SIS field - Race field.
  Race_B	Race - Black or African American	Student's race entered in SIS field - Race field.
  Race_H	Race - Hispanic	Student's race entered in SIS field - Race field.
  Race_I	Race - American Indian or Alaskan Native	Student's race entered in SIS field - Race field.
  Race_M	Race - Two or More Races	Student's race entered in SIS field - Race field.
  Race_P	Race - Native Hawaiian or Pacific Islander	Student's race entered in SIS field - Race field.
  Race_W	Race - White	Student's race entered in SIS field - Race field.
  Gender	Gender	Student's Gender
  IS_ELL	If the student is EL	Indicates if the student is currently EL.
  EnrollmentStartDate	Enrollment Start Date	Enrollment Start Date
  EnrollmentEndDate	Enrollment End Date	Enrollment End Date
  LRECode	LRE Code	LRE Code
  Exceptionality	Exceptionality	Exceptionality
  IsGifted	Is the student gifted	Is the student gifted?
  ReferralDate	Referral Date	Referral Date
  AnRevDueDate	Annual Review Due Date	Annual Review Due Date
  CountDate	Count Date	Count Date
  Status	Status	Status
  CaseManager	Case Manager	Case Manager
  CurrentIEPStartDate	Current IEP Start Date	Current IEP Start Date
  CurrentIEPEndDate	Current IEP End Date	Current IEP End Date
  IEPBy3rdBthday	IEP Developed and Implemented by 3rd Birthday	IEP Developed and Implemented by 3rd Birthday.
  IEPSignDate	IEP Signature Date	IEP Signature Date
  IntIEPDate	Initial IEP Date	Initial IEP Date
  MostRecEligDate	Most Recent Eligibility Date	Most Recent Eligibility Date
  EligMeetDueDate	Next Eligibility Meeting Due Date	Next Eligibility Meeting Due Date
  PreServBegDate	Preschool Services Begin Date (3-5 yrs. old)	Preschool Services Begin Date (3-5 yrs. old)
  SnapShotDate	Snap-Shot Date	Snap-Shot Date
  ApprovalDate	Approval Date	Date of approval for this report submission

  This data will be uploaded from the Special Programs into the PowerSchool SIS table S_AL_STU_STATE_ChildCount_X.

• S_AL_STU_StuEvalWithinTLne_X
  This report pulls students who meet certain criteria in the Students Evaluated Within Timeline (Indicator 11) state reporting. This report pulls student data from the State Reporting child profile and the Students Evaluated Within Timeline area as mentioned in the table below:

  Field Name	Field Label	Description
  IntegrationIDT	N/A	The number assigned to students integrated with PowerSchool SIS.
  DistrictID	District (LEA) Code	LEA district code as assigned by the state.
  District	(LEA) District Name	LEA district name as assigned by the state.
  SchoolNumber	School Number	School number as assigned by the state.
  School	School Name	School name as assigned by the state.
  StudentsDCID	Student DC ID	The number assigned to students in PowerSchool SIS.
  StudentNumber	Student Number	The number assigned to students in PowerSchool SIS.
  StateID	State ID	The state ID number assigned to the student in PowerSchool SIS.
  FirstName	Student's Name	Student's First Name
  MiddleName	Student's Name	Student's Middle Name
  LastName	Student's Name	Student's Last Name
  Generation	Generation	Student's Generation
  BirthDate	Birth Date	Student's date of birth
  ElNoticeDate	Date letter of notification from EI Received	Date letter of notification from EI Received.
  SignConsInitEval	Signed Consent of Initial Evaluation	Signed Consent of Initial Evaluation.
  EvalCompleteDate	Final Completion Date of All Evaluations	Final Completion Date of All Evaluations.
  Evalin60Days	Evaluations Completed within 60 Days	Evaluations Completed within 60 Days.
  ExcessDays	Range of Days in Excess	Range of Days in Excess.
  EvalDelayRea	Reason For Late Evaluation	Reason For Late Evaluation
  StartDate	Start Date	This is the report start date.
  EndDate	End Date	This is the report's end date.
  ApprovalDate	Approval Date	Date of approval for this report submission

  This data will be uploaded from the Special Programs into the PowerSchool SIS table S_AL_STU_StuEvalWithinTLne_X.

• S_AL_STU_TransitionVerific_X

This report pulls students who meet certain criteria in the Students Evaluated Within Timeline (Indicator 13) state reporting. This report pulls student data from the State Reporting child profile and the Transition Verification area as mentioned in the table below:

This data will be uploaded from the Special Programs into the PowerSchool SIS table S_AL_STU_TransitionVerific_X.