PowerSchool SIS Georgia
PowerSchool SIS Georgia
Breadcrumbs

Student Enrollments

Information describing student enrollment at schools with detailed FTE segments and demographic data.

StudentSchoolAssociations

Students and the schools where they are enrolled. Includes FTE segments and special indicators.

Primary PowerSchool Source Data

Core tables used in this resource:

  • [Students]

  • [Reenrollments]

  • [S_GA_STU_X]

  • [S_GA_STU_FTE_X]

  • [S_GA_STU_ESOL_C]

  • [SPEnrollments]

Selection Criteria

Business logic for publishing this resource:

  • Student must have valid enrollment record (Students or ReEnrollments)

  • Enrollment must be within the reporting term dates

  • Student must not be excluded from reporting

  • Prioritizes Students (S) records over ReEnrollments (R) when multiple exist

  • Applies school number override logic when present and valid

  • One record per student per school

Resource Output

Expected output from the selection criteria:

  • entryDate - Date student entered school

  • exitWithdrawDate - Date student withdrew (optional)

  • schoolReference - Reference to the school

  • schoolYearTypeReference - Academic year

  • studentReference - Reference to the student

  • GA extensions: FTE segments, program indicators, dates, flags

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

entryDate

Date when student entered the school

datetime

[Enrollment]EntryDate

schoolReference

Reference to the school where student is enrolled

customobject

[Schools]School_Number

schoolId

School ID reference identifier

number

[Students]SchoolId or via override logic

schoolYearTypeReference

Academic school year for enrollment

customobject

SchoolYear - p_yearid + 1991

studentReference

Reference to the student

customobject

[Students]State_StudentNumber

entryGradeLevelDescriptor

Ed-Fi descriptor for the grade level at entry

string

GradeLevel descriptor from [Students]Grade_Level

entryTypeDescriptor

Ed-Fi descriptor for type of entry (e.g., New to District, New to School, Promotion, Enrollment)

string

EntryType_DX from [Students]EntryCode

exitWithdrawDate

Date when student withdrew from school (optional)

datetime

[Students]ExitDate (optional)

exitWithdrawTypeDescriptor

Ed-Fi descriptor for type of exit (e.g., Graduated, Transferred, Dropped Out)

string

ExitType_DX from [Students]ExitCode (optional)

repeatGradeIndicator

Boolean indicator of whether student repeated a grade

boolean

[S_GA_STU_X]StudentStatus = 'R' (optional)

residencyStatusDescriptor

Ed-Fi descriptor for residency status (optional)

string

ResidencyStatus_DX from [S_GA_STU_X]ResStatusCode (optional)

giftedServedDescriptor

GA extension: Descriptor indicating if student is served in gifted program (nested in _ext.Gadoe, optional)

string

GiftedServed_DX from [S_GA_STU_Gifted_C]

dateEntered9thGrade

GA extension: Date student entered 9th grade (nested in _ext.Gadoe, optional)

datetime

[S_GA_STU_X]DateEntered9thGrade

priorTenDays

GA extension: Boolean for prior 10 days indicator (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]PriorTenDays

summerImmigrantProgramParticipation

GA extension: Boolean for summer immigrant program participation (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]SummerImmigrantPart

summerTitleIIIServed

GA extension: Boolean for summer Title III service (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]SummerTitleIII

asvabScore

GA extension: ASVAB (Armed Services Vocational Aptitude Battery) score (nested in _ext.Gadoe, optional)

number

[S_GA_STU_X]AsvabScore

esolSegments

GA extension: Count of ESOL segments student is receiving (nested in _ext.Gadoe, optional)

number

[S_GA_STU_X]EsolSegments

ccaNonTraditional

GA extension: Boolean for CCA (Career, College, and Armed Forces Pathway) non-traditional status (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]CCANonTraditional

studentSupportTeamParticipant

GA extension: Boolean for participation in student support team (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]StudentSupportTeamParticipant

dualImmersion

GA extension: Boolean for dual immersion program participation (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]DualImmersion

immigrantProgramParticipant

GA extension: Boolean for immigrant program participation (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]ImmigrantProgramParticipant

sbDualEnrollment

GA extension: Boolean for system-based dual enrollment (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]SBDualEnrollment

titleITargetedAssistanceParticipation

GA extension: Boolean for Title I targeted assistance participation (nested in _ext.Gadoe, optional)

boolean

[S_GA_STU_X]TitleTargetedAssistance

fteSegments

GA extension: Array of FTE (Full-Time Equivalent) segments for student (nested in _ext.Gadoe, optional). Up to 6 segments possible.

array

[S_GA_STU_FTE_X] joined by StudentsDCID

segmentNumber

GA extension: Sequence number of FTE segment (1-6) within student's enrollment (nested in fteSegments)

number

[S_GA_STU_FTE_X]SegmentNumber

fteProgramCodeDescriptor

GA extension: Descriptor for FTE program code (e.g., Regular Education, Resource, Self-Contained) (nested in fteSegments)

string

ProgramCode_DX from [S_GA_STU_FTE_X]

inclusionPersonnelDescriptor

GA extension: Descriptor for inclusion personnel type (nested in fteSegments)

string

InclusionCode_DX from [S_GA_STU_FTE_X]

itinerantTeacherSpecialEducationServices

GA extension: Boolean for itinerant teacher special education services (nested in fteSegments, optional)

boolean

[S_GA_STU_FTE_X]ItinerantTchFlag

receivedSupplementalSpeechServices

GA extension: Boolean for supplemental speech/language services (nested in fteSegments, optional)

boolean

[S_GA_STU_FTE_X]SupplSpeechFlag

transportedForSection

GA extension: Boolean for transportation provided for this segment (nested in fteSegments, optional)

boolean

[S_GA_STU_FTE_X]TransportedFlag

enrollmentLocationDescriptor

GA extension: Location descriptor for enrollment (nested in fteSegments, optional)

string

LocationEnrollment_DX from [S_GA_STU_FTE_X]