PowerSchool SIS Georgia
PowerSchool SIS Georgia
Breadcrumbs

Student Programs

Information describing student participation in various programs including special education, gifted, ESOL, homeless, and food service

Special Education

Special Education program(s) that a student participates in or receives services from.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [SPEnrollments]

  • [S_GA_SEN_X]

  • [S_GA_STU_Speced_X]

  • [S_GA_STU_Speced_Service]

  • [S_GA_STU_Speced_Disability]

Selection Criteria

Business logic for publishing this resource:

  • Student must be enrolled in special education (SpEnrollments record)

  • Enrollment must be within reporting term or overlap with it

  • IEP (Individualized Education Program) begin date must be within fiscal year (4/1 to 3/31)

  • May have multiple service types and disabilities

  • Includes PAE (Primary At-Risk Education) indicator

Resource Output

Expected output from the selection criteria:

  • educationOrganizationReference - Reference to school

  • programReference - Reference to Special Education program

  • studentReference - Reference to student

  • beginDate - Program enrollment date

  • endDate - Program exit date (optional)

  • specialEducationSettingDescriptor - Placement setting

  • specialEducationProgramServices - Array of service types

  • disabilities - Array of disability categories with order

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the school providing special education services

customobject

SchoolOrgID from [SPEnrollments]SchoolID

programReference

Reference to the Special Education program

customobject

[Gen]ID where cat='specprog' and ALTEDPROGRAM IN ('1','2','3','4')

studentReference

Reference to the student enrolled in special education

customobject

[Students]State_StudentNumber

beginDate

Date student enrolled in special education program

datetime

[SPEnrollments]Enter_Date

endDate

Date student exited special education program (optional)

datetime

[SPEnrollments]Exit_Date

iepBeginDate

Date of IEP (Individualized Education Program) start (optional)

datetime

[S_GA_STU_Speced_X]IEPBeginDate (optional)

specialEducationSettingDescriptor

Ed-Fi descriptor for special education service setting (e.g., General Ed Classroom, Resource Room, Self-Contained, Separate Facility, Homebound/Hospital, Correctional Facility)

string

SpecialEducationSetting from [S_GA_STU_Speced_X (optional)

specialEducationProgramServices

Array of special education services provided to student

array

[S_GA_STU_Speced_Service] Joined by student SPED enrollment

specialEducationProgramServiceDescriptor

Ed-Fi descriptor for specific special education service type (e.g., Special Education, Related Services) (nested in specialEducationProgramServices)

string

ProgramService_DX from [S_GA_STU_Speced_Service]

disabilities

Array of disability categories for this student's special education

array

[S_GA_STU_Speced_Disability] Joined by student SPED Enrollment

disabilityDescriptor

Ed-Fi descriptor for disability type (e.g., Autism, Deaf-Blindness, Hearing Impairment, Intellectual Disability, Multiple Disabilities, Orthopedic Impairment, Other Health Impairment, Specific Learning Disability, Speech/Language Impairment, Traumatic Brain Injury, Visual Impairment) (nested in disabilities)

string

Disability_DX from [S_GA_STU_Speced_Disability]

orderOfDisability

Priority order of disability categories for this student (1=primary, 2=secondary, etc.) (nested in disabilities)

number

[S_GA_STU_Speced_Disability]OrderOfDisability

Gifted and Talented

Gifted and Talented program(s) that a student participates in.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [s_ga_stu_gifted_c]

  • [students]

  • [cst_pubenrollment_tmp]

Selection Criteria

Business logic for publishing this resource:

  • Student must have gifted enrollment record with non-null enrollment date

  • Enrollment date must be within the reporting year

  • Prioritizes Students (S) records over ReEnrollments (R)

  • One record per student's gifted record

Resource Output

Expected output from the selection criteria:

  • educationOrganizationReference - Reference to school

  • programReference - Reference to Gifted & Talented program

  • studentReference - Reference to student

  • beginDate - Enrollment date

  • endDate - Exit date (optional)

  • eligibilityCode and referralCode in runtime properties

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the school providing gifted services

customobject

[Schools]DCID from enrollment

programReference

Reference to the Gifted and Talented program

customobject

ProgramID from [S_GA_STU_Gifted_C]ID

studentReference

Reference to the student

customobject

[Students]State_StudentNumber

beginDate

Date student enrolled in gifted program

string

[S_GA_STU_Gifted_C]EnrollmentDate

endDate

Date student exited gifted program (optional)

string

S_GA_STU_Gifted_C]ExitDate

giftedEligibilityDate

GA extension: Date of gifted eligibility determination (nested in _ext.Gadoe, optional)

string

[S_GA_STU_Gifted_C]GiftedEligibilityDate (optional)

programReferredByDescriptor

GA extension: Descriptor indicating who referred student to gifted program (nested in _ext.Gadoe, optional)

string

ProgramReferredBy_DX from [S_GA_STU_Gifted_C]ReferralCode (optional)

numberofDailyGNETSSegments

GA extension: Number of daily GNETS (Georgia Network for Educational and Therapeutic Support) segments (nested in _ext.Gadoe, optional)

number

[S_GA_STU_Gifted_C]NumberofDailyGNETS (optional)

Language Instruction Program

The Title III Language Instruction for Limited English Proficient and Immigrant Students program(s) that a student participates in.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [s_ga_stu_esol_c]

  • [students]

  • [s_ga_stu_x]

Selection Criteria

Business logic for publishing this resource:

  • Student must have ESOL enrollment record

  • ESOL enrollment must be active or overlap with reporting year

  • Exit date must be NULL or within/after reporting year

  • One record per student ESOL enrollment

  • Prioritizes Students (S) over ReEnrollments (R)

Resource Output

Expected output from the selection criteria:

  • educationOrganizationReference - Reference to school

  • programReference - Reference to ESOL program

  • studentReference - Reference to student

  • beginDate - Enrollment date

  • endDate - Exit date (optional)

  • englishLanguageProficiencyAssessments - Proficiency level and year

  • reasonExitedDescriptor - Reason for exiting ESOL

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the school providing ESOL services

customobject

[Schools]DCID from enrollment

programReference

Reference to the ESOL program

customobject

[S_GA_STU_ESOL_C]ID

studentReference

Reference to the student

customobject

[Students]State_StudentNumber

englishLanguageProficiencyAssessments

Array of English language proficiency assessments with proficiency levels and years

array

[S_GA_STU_ESOL_C] with Assessment Data

proficiencyDescriptor

Ed-Fi descriptor for English language proficiency level (e.g., Beginner, Early Intermediate, Intermediate, Early Advanced, Advanced) (nested in englishLanguageProficiencyAssessments, optional)

string

ElProficiency_DX from [S_GA_STU_ESOL_C] (optional)

beginDate

Date student enrolled in ESOL program

string

[S_GA_STU_ESOL_C]DateOfELPScreener or [Students]EntryDate

endDate

Date student exited ESOL program (optional)

string

[S_GA_STU_ESOL_C]ExitDate

englishLearnerParticipation

Boolean indicator of English learner program participation (optional)

boolean

[S_GA_STU_ESOL_C]ElParticipationIndicator (optional)

reasonExitedDescriptor

Ed-Fi descriptor for reason student exited ESOL (e.g., Reached Proficiency, Moved, Graduated) (optional)

string

ReasonExited_DX from [S_GA_STU_ESOL_C] (optional)

dateOfELPScreener

GA extension: Date of English Language Proficiency screener administration (nested in _ext.Gadoe, optional)

string

[S_GA_STU_X]DateOfELPScreener (optional)

Homeless

The homeless program that a student participates in.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [cst_pubenrollment_tmp]

  • [students]

  • [s_ga_stu_x]

Selection Criteria

Business logic for publishing this resource:

  • Student must have homelessPrimaryShelter value in S_GA_STU_X

  • Enrollment record must be of type 'S' (Students) or 'R' (ReEnrollments)

  • One record per student-school enrollment when homeless status exists

Resource Output

Expected output from the selection criteria:

  • programReference - Reference to Homeless program

  • educationOrganizationReference - Reference to school

  • studentReference - Reference to student

  • beginDate - Student entry date

  • endDate - Student exit date (optional)

  • homelessPrimaryNighttimeResidenceDescriptor - Type of shelter/living situation

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the school serving homeless student

customobject

[Schools]DCID from enrollment

programReference

Reference to the Homeless program

customobject

ProgramType_DX = 'Homeless'

studentReference

Reference to the student

customobject

[Students]State_StudentNumber

beginDate

Date student entered the school (entry date)

datetime

[S_GA_STU_X] HomelessPrimaryShelter Date

endDate

Date student exited the school (optional)

datetime

[S_GA_STU_X]HomelessEndDate

homelessPrimaryNighttimeResidenceDescriptor

Ed-Fi descriptor for primary nighttime residence type (e.g., Shelters for homeless families, Shelters for homeless individuals, Hotels/motels, Doubled-up, Unsheltered, Other)

string

[S_GA_STU_X]NomelessPrimaryShelter

Food Service

The school food services program(s), such as the Free or Reduced Lunch Program, that a student participates in.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [cst_pubenrollment_tmp]

  • [students]

Selection Criteria

Business logic for publishing this resource:

  • One record per student enrollment for food service eligibility

  • Creates food service program association per student-school enrollment

Resource Output

Expected output from the selection criteria:

  • educationOrganizationReference - Reference to school

  • programReference - Reference to Food Service program

  • studentReference - Reference to student

  • beginDate - Program begin date

  • endDate - Program end date (optional)

  • directCertification - Boolean for direct certification status

  • schoolFoodServiceProgramServices - Array of service types

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element

Description

[Table]Data Type

Stored in [Table]Field

educationOrganizationReference

Reference to the school providing food services

customobject

[Schools]DCID from enrollment

programReference

Reference to the Food Service program

customobject

ProgramType_DX = 'School Food Service'

studentReference

Reference to the student

customobject

[Students]State_StudentNumber

beginDate

Date student became eligible for food services

datetime

[Enrollment]EntryDate

endDate

Date student is no longer eligible for food services (optional)

datetime

[Enrollment]ExitDate

directCertification

Boolean indicator of whether student was directly certified for free/reduced meals (optional)

boolean

DirectCertification from lunch status logic (optional)

schoolFoodServiceProgramServices

Array of food service program types student is eligible for

array

SchoolFoodService_DX from Lunch Eligibility

schoolFoodServiceProgramServiceDescriptor

Ed-Fi descriptor for food service type (e.g., Free Lunch, Reduced Price Lunch, Full Price Lunch, Breakfast) (nested in schoolFoodServiceProgramServices)

string

[S_GA_STU_X]Lunch_Status mapped to descriptor