Skip to main content
Skip table of contents

Student Enrollments

This category carries information about student school enrollments and withdrawal information. The Student Enrollments category includes the following data views and resources:

Student School

This view captures student enrollments in schools in the current year as published in the StudentSchoolAssociation resource in Student Enrollments. The layout includes the School Name, School ID, Student Number, Student Name, Grade Level, Entry Date, Exit Date, and State Student Number.

studentSchoolAssociations

This association represents the school in which a student is enrolled.

Primary PowerSchool Source Data

  • [Students]

  • [ReEnrollments]

  • [S_STU_X]

  • [S_REN_X]

  • [GPSTUDENTPLAN]

  • [GPVERSION]

  • [GRADPLAN]

Selection Criteria

Records are published if the following criteria are met:

  • A Student record has been published for the student.

  • StudentUniqueId must be populated in PowerSchool.

  • Summer graduates are published in the subsequent year.

  • The student must not be excluded from state reporting.

  • The school must not be excluded from state reporting.

  • The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.

  • The enrollment ExitDate is on or after the EntryDate.

  • The student must have an active enrollment.

Noshow and Summer graduates are published.

Resource Output

  • A separate StudentSchoolAssociation record is published for each student and school enrollment reflected in the [Students] and [Reenrollments] tables based on the year for the Term selected in the PowerSchool UI.

    • If the student is or was enrolled in a single school, one record is published.

    • If the student was enrolled in a single school, withdrew, and later re-enrolled in the same school, two records are published.

    • If the student was enrolled in multiple schools, a record is published for each enrollment.

  • The StudentSchoolAssociation resource is dependent on the prior publishing of the following: Student.
    Note: After a Student record is uploaded, it cannot be modified until a StudentSchoolAssociation record has also been uploaded for the same student.

    • This establishes a relationship between the school, the associated LEA, and the student.

    • The LEA then has permission to modify the previously uploaded Student record.

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

schoolId

State-assigned value to the school.

Integer

Derived from:
[Students]schoolid, [Students]enrollments_schoolid
[ReEnrollments]schoolid

R

studentUniqueId

Student enrolled in the school.

String

[Students]state_studentnumber

R

entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.


[Students]entrydate or [ReEnrollments]entrydate


calendarReference

/calendarCode

The calendar associated with the school and the student.


[S_SCH_CALENDARS_C]calendarcode if unavailable

composite based on enrolled school and [Students]track, [ReEnrollments]track

R

/schoolId

State-assigned value based on STUDENTS.schoolid or


[Students]schoolid if available

[Students]enrollment_schoolid or

[ReEnrollments]schoolid

R

/schoolYear

The school year associated with the student's enrollment.

String


R

graduationPlanReference





/educationOrganizationId

State-assigned value for the EducationOrganization associated with the student.


[Students]schoolid or [Students]enrollment_schoolid

R

/graduationSchoolYear

The graduation school year associated with the graduation plan.


[Students]sched_yearofgraduation or [studentcorefield]Graduation_year

R

/graduationPlanTypeDescriptor

The graduation plan associated with the student enrolled in the school.

String

[GPSTUDENTPLAN]

R

entryGradeLevelDescriptor

The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.


based on [Students]grade_level, [ReEnrollments]grade_level


entryGradeLevelReasonDescriptor

Description of the reason for retaining a student in the same grade.

Descriptor Reported Value
Poor grades1
Low test score2
Teacher judgment3
Poor grades & Low test score4
Poor grades & Teacher judgment5
Low test score & Teacher judgment6
Poor grades & Low test scores & Teacher7
Mandatory 3rd Grade Retention8
OtherO



Fixed mapping


entryTypeDescriptor

The process by which a student enters a school during a given academic session.

DescriptorReported Value
Student is eligible for state fundingE
Student is not eligible for state fundingEEI


Descriptor

Fixed mapping

O

schoolYearTypeReference

/schoolYear





classOfSchoolYearTypeReference





/SchoolYear

A reference to the related SchoolYearType resource.


[S_SC_STU_X]graddate


exitWithdrawDate

The month, day, and year of the first day after the date of an individual's last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.

Date

[Students]exitdate (current)
[ReEnrollments]exitdate (historical)

O*

exitWithdrawTypeDescriptor

Describes the circumstances which a student exited from membership in an educational institution.

  • This element is required if applicable; otherwise, it is excluded from publishing.

The value in the Code column of the Exit Codes page is reported.

Descriptor

Fixed mapping

O*

repeatGradeIndicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or by an agreement to hold the student back.

This element is required if applicable; otherwise it is excluded from publishing.

Boolean

[S_STU_X]repeatgradeindicator

[S_REN_X]repeatgradeindicator


residencyStatusDescriptor

An indication of the location of a person's legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit.

Descriptor

[S_STU_X]residencystatus

[S_REN_X]residencystatus

O

schoolChoiceTransfer

Indicates the student was transferred to this school as allowed by a School Choice initiative.


[S_STU_X]schoolchoicetransfer

[S_REN_X]schoolchoicetransfer


primarySchool





Student DOR

This view captures a detailed list of students' District of Residence (DOR). The layout includes the School Name, School ID, Student Number, Student Name, Grade Level, DOR, Entry Date, Entry Code, Exit Date, Exit Code, DOR Exit Date, and State Student Number.

studentEducationOrganizationAssociations

This association indicates any relationship between a student and an education organization other than how the state views enrollment. The enrollment relationship semantics are covered by StudentSchoolAssociation.

Primary PowerSchool Source Data

  • [Students]

  • [S_SC_STU_X]

  • [ReEnrollments]

Selection Criteria

Records are published if the following criteria are met:

  • A Student record has been published for the student.

  • StudentUniqueId must be populated in PowerSchool.

  • The student must not be excluded from state reporting.

  • The school must not be excluded from state reporting.

  • The student must have a District of Residence specified. The school must not be excluded from state reporting.

  • The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.

  • The enrollment ExitDate is on or after the EntryDate.

  • The student must have an active enrollment.

    Noshow and Summer graduates are published.


Resource Output

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

studentReference

/studentUniqueId

A unique alpha-numeric code assigned to a student.

String

[Students]State_StudentNumber

R

educationOrganizationReference

/educationOrganizationId

The EducationOrganization associated with the student.

Integer

[Students]DistrictofResidence
[ReEnrollments]DistrictofResidence (Historical)

R

addresses

/addressTypeDescriptor

The type address whether home or mailing address.


'Home' and 'Mailing'


/apartmentRoomSuiteNumber

The apartment or suite number.


[Students]street

[Students]mailing_street


/streetNumberName

The street name and number.


[Students]street

[Students]mailing_street


/city

The city of home or mailing address.


[Students]city

[Students]mailing_city


/stateAbbreviationDescriptor

The abbreviation of the state.


[Students]state

[Students]mailing_state


/postalCode

The postal code of the home or mailing address.


[Students]zip

[Students]mailing_zip


/nameOfCounty

The county of the home or mailing address.


[S_SC_STU_X]county


cohortYears - Ninth Grade

/cohortYearTypeDescriptor





/schoolYear



[ S_SC_STU_X]ninthGradeCode


disability

/disabilityDescriptor

Type of disability.


when stu.Plan504Code='HR' then disabilityDescriptor='Hearing Impairment, including Deafness';
when stu.Plan504Code='THK' then disabilityDescriptor='Mental impairment';
when stu.Plan504Code='WK' then disabilityDescriptor='Motor impairment';
when stu.Plan504Code='IWO', 'OTH' or 'CFO' then disabilityDescriptor='Other';
when stu.Plan504Code='BH', 'ET', 'LT', 'PMT', or 'WOK' then disabilityDescriptor='Physical Disability';
when stu.Plan504Code='SK' then disabilityDescriptor='Speech or Language Impairment';
when stu.Plan504Code='LN' then disabilityDescriptor='Specific Learning Disability';
when stu.Plan504Code='SE' then disabilityDescriptor='Visual Impairment, including Blindness'


/disabilityDesignationDescriptor



when stu.Plan504Code=* then disabilityDesignationDescriptor='Section 504'


/disabilityDiagnosis



[stu]Plan504Code


electronicMails





/electronicMailTypeDescriptor



when PSM_STUDENTCONTACT.email IS NOT NULL then electronicMailTypeDescriptor='Student'


/electroncMailAddress

The student's contact email address.


[PSM_STUDENTCONTACT]email


hispanicLatinoEthnicity



[STUDENTS]fedethnicity


languages

/languageDescriptor



If S_SC_STU_X.First_Lang_Spoken then languageUseDescriptor='Native Language';
S_SC_STU_X.primarylanguage then languageUseDescriptor='Dominant Language';
S_SC_STU_X.HomeLang then languageUseDescriptor='Home Language';
S_SC_STU_X.Oral_Commun_Lang then languageUseDescriptor='Spoken Language';
S_SC_STU_X.Written_Commun_Lang then languageUseDescriptor='Correspondence Language'


/uses





races

/raceDescriptor



[STUDENTRACE]race_cd


sexDescriptor



[STUDENTS]gender


studentIdentificationCodes

/studentIdentificationSystemDescriptor



State AND District

[STUDENTS]DCID if not null

[STUDENTS]ID if not null


/identificationCode



[STUDENTS]tate_studentnumber AND [STUDENTS]student_number

[STUDENTS]DCID

[STUDENTS]ID


/assigningOrganizationIdentificationCode



1 and state-assigned number for district


studentIndicator

IndicatorName




efa.efa_primary; eie.eia_1; ha.highach_1; stu.PIP_Status; stu.TrueGrade;
S_SC_STU_X.AdultEd_EntryDate;
S_SC_STU_X.AdultEd_ExitDate;
S_SC_STU_X.AdultEd_GradDate;
S_SC_STU_X.YRGEDEarned;
S_SC_STU_ESOL_X.Parent_30_Notification;
STUDENTCOREFIELDS.graduation_year;
STUDENTS.classof;
S_SC_STU_CATE_X.CATE_YrCompleted,
S_SC_STU_CATE_X.CATE_YrCompleted2,
S_SC_STU_CATE_X.CTE_ConcntrYr,
S_SC_STU_CATE_X.CTE_ConcntrYr2,
S_SC_STU_CATE_X.PlaceEmployer
S_SC_STU_CATE_X.PlaceHigherEdName
S_SC_STU_CATE_X.PlaceHigherEdProg
S_SC_STU_CATE_X.PlaceJobTitle
S_SC_STU_CATE_X.PlaceLevelCode
S_SC_STU_CATE_X.PlaceMilitaryBranch
S_SC_STU_CATE_X.PlaceMilitaryTrain
S_SC_STU_CATE_X.PlacePhone
S_SC_STU_CATE_X.PlaceStartDate
S_SC_STU_CATE_X.PlaceSupervisorName
S_SC_STU_WBL.WBL_EmpNameCCR;
S_SC_STU_WBL.WBL_EmpName1;
S_SC_STU_WBL.WBL_EmpName2;
S_SC_STU_WBL.WBL_EmpName3;
S_SC_STU_WBL.WBL_EmpName4;
S_SC_STU_WBL.WBL_EmpName5;
S_SC_STU_WBL.WBL_EmpName6;
S_SC_STU_WBL.WBL_EmpName7;
S_SC_STU_WBL.WBL_EmpName8;
S_SC_STU_WBL.WBL_EmpName9;
S_SC_STU_WBL.WBL_EmpName10;
S_SC_STU_X.AltAssessCde;
S_SC_STU_X.AltAssessTA_FirstName;
S_SC_STU_X.AltAssessTA_LastName;
S_SC_STU_X.CR_Grade12;
S_SC_STU_X.ELASortID;
S_SC_STU_X.AP_Participant_Nbr;
S_SC_STU_X.BusInfo1;
S_SC_STU_X.BusInfo2;
S_SC_STU_X.DiplomaOrdCode;
S_SC_STU_X.Dropout_Date;
S_SC_STU_X.Dropout_Reason;
S_SC_STU_X.Elig504_NoPlanInd;
S_SC_STU_X.Foster_Home;
S_SC_STU_X.GridCode;
S_SC_STU_X.IB_Candidate_Nbr;
S_SC_STU_X.Init_TestDate;
S_SC_STU_X.Init_TestScore;
S_SC_STU_X.Init_TestScore_dec_select;
S_SC_STU_X.Init_TestType;
S_SC_STU_X.MathSortID;
S_SC_STU_X.GT_Paper;
S_SC_STU_X.CR_Paper;
S_SC_STU_X.ELP_Paper;
S_SC_STU_X.MedicaidEligible_Date;
S_SC_STU_X.medicaidID;
S_SC_STU_X.Migrant;
S_SC_STU_X.Moved_To_District;
S_SC_STU_X.Moved_To_School;
S_SC_STU_X.MultiDisabInd;
S_SC_STU_X.NeedsBrailleInd;
S_SC_STU_X.Other_AltAssessTest_SchoolID;
S_SC_STU_X.SchoolRes;
S_SC_STU_X.ScienceSortID;
S_SC_STU_X.SocStudiesSortID;
S_SC_STU_X.SEI_Create_Date;
S_SC_STU_X.Trans_Mode_AM;
S_SC_STU_X.Trans_Mode_PM;
students.Home_Room;
S_SC_STU_X.Qualifying_Move;
S_SC_STU_X.Qualifying_Occupation;
When S_SC_STU_X.House_Status="DIS" then || S_SC_STU_X.Disaster;
When S_SC_STU_X.House_Status="OTH" then || S_SC_STU_X.Other (60 characters are published)
S_SC_STU_WBL.WBL_AgreementCCR;
S_SC_STU_WBL.WBL_CreditIndCCR;
S_SC_STU_WBL.WBL_CreditInd1;
S_SC_STU_WBL.WBL_CreditInd2;
S_SC_STU_WBL.WBL_CreditInd3;
S_SC_STU_WBL.WBL_CreditInd4;
S_SC_STU_WBL.WBL_CreditInd5;
S_SC_STU_WBL.WBL_CreditInd6;
S_SC_STU_WBL.WBL_CreditInd7;
S_SC_STU_WBL.WBL_CreditInd8;
S_SC_STU_WBL.WBL_CreditInd9;
S_SC_STU_WBL.WBL_CreditInd10;
S_SC_STU_WBL.WBL_HoursMetCCR;
S_SC_STU_WBL.WBL_PaidInCCR;
S_SC_STU_WBL.WBL_PaidInd1;
S_SC_STU_WBL.WBL_PaidInd2;
S_SC_STU_WBL.WBL_PaidInd3;
S_SC_STU_WBL.WBL_PaidInd4;
S_SC_STU_WBL.WBL_PaidInd5;
S_SC_STU_WBL.WBL_PaidInd6;
S_SC_STU_WBL.WBL_PaidInd7;
S_SC_STU_WBL.WBL_PaidInd8;
S_SC_STU_WBL.WBL_PaidInd9;
S_SC_STU_WBL.WBL_PaidInd10;
S_SC_STU_WBL.WBL_RelateInCCR;
S_SC_STU_X.SEI_Status;
S_SC_STU_CATE_X.CATE_SingleParentInd;
S_SC_STU_CATE_X.CATE_DisplHomeMakerInd;
S_SC_STU_CATE_X.CATE_ExceptionsCode;
S_SC_STU_CATE_X.CATE_Units;
S_SC_STU_CATE_X.CATE_Units2;
S_SC_STU_WBL.WBL_CarCod1;
S_SC_STU_WBL.WBL_CarCod2;
S_SC_STU_WBL.WBL_CarCod3;
S_SC_STU_WBL.WBL_CarCod4;
S_SC_STU_WBL.WBL_CarCod5;
S_SC_STU_WBL.WBL_CarCod6;
S_SC_STU_X.IncludeInReporting;
S_SC_STU_X.InstrSetting;
S_SC_STU_X.KndrgrtnPrevPgm;
S_SC_STU_X.NoShow_Reason;
S_SC_STU_X.OralELA;
S_SC_STU_X.OralMath;
S_SC_STU_X.OralScience;
S_SC_STU_X.OralSocStudies;
S_SC_STU_X.ParentsMilitaryStatus;
S_SC_STU_X.Tier;
S_SC_STU_X.Universal_Screener;
S_SC_STU_WBL.WBL_EvalScoreCCR;
S_SC_STU_WBL.WBL_TypeCCR;
S_SC_STU_EC_X.DaysServed_PerWeek;
S_SC_STU_EC_X.EC_PriorClassType;
S_SC_STU_EC_X.EC_PriorProvider;
S_SC_STU_EC_X.EC_CarePriorToSchCode;
S_SC_STU_EC_X.EC_ClassCurrCode;
S_SC_STU_EC_X.EC_CountDownToKinderInd
S_SC_STU_EC_X.EC_EarlyChildPlaceCode;
S_SC_STU_EC_X.EC_FamilyIncRangeCode;
S_SC_STU_EC_X.EC_FamilyLiteracySrvcs;
S_SC_STU_EC_X.EC_yrsfamilylitsrvcs;
S_SC_STU_EC_X.EC_HeadStartInd;
S_SC_STU_EC_X.EC_LowBirthWeightInd;
S_SC_STU_EC_X.EC_TuitionPayer;
S_SC_STU_EC_X.EdLevel_MomFG;
S_SC_STU_EC_X.YearsED_MomFG;
S_SC_STU_ReadToSucceed_X.504_GCE;
S_SC_STU_ReadToSucceed_X.AltAssessed_GCE;
S_SC_STU_ReadToSucceed_X.Determination_Factor;
S_SC_STU_ReadToSucceed_X.English_Learner_GCE;
S_SC_STU_ReadToSucceed_X.IEP_GCE;
S_SC_STU_ReadToSucceed_X.Invited;
S_SC_STU_ReadToSucceed_X.PostAssessment;
S_SC_STU_ReadToSucceed_X.PostAssessment_Score;
S_SC_STU_ReadToSucceed_X.PreAssessment;
S_SC_STU_ReadToSucceed_X.PreAssessment_Score;
S_SC_STU_ReadToSucceed_X.PreviouslyRetained_GCE;
S_SC_STU_ReadToSucceed_X.Proficiency_Level;
S_SC_STU_ReadToSucceed_X.Promotion_Status;
S_SC_STU_ReadToSucceed_X.ReadingPortfolio_GCE;
S_SC_STU_ReadToSucceed_X.SummerReading_GCE;
S_SC_STU_ReadToSucceed_X.Superintendent_GCE;
S_SC_STU_X.ARP_HCY;
S_SC_STU_X.Precode1;
S_SC_STU_X.Precode2;
S_SC_STU_X.Precode3;
S_SC_STU_X.Precode4;
S_SC_STU_X.Precode5;
S_SC_STU_X.Precode6;
S_SC_STU_X.Precode7;
S_SC_STU_X.Precode8;
S_SC_STU_X.G38PaperEla

[S_SC_STU_X]USSCHENTRYDATE if Date Entered US is not null

If S_SC_STU_GRAD_WRKSHEET_X.Student_In_Denominator is not null then indicatorName="Grad Rate Status - Student in Denominator";


Indicator



S_SC_STU_GRAD_WRKSHEET_X.Student_In_Denominator


/Period

/BeginDate



efa.start_dt, eia.start_dt, ha.start_dt


/EndDate



efa.stop_dt, eia.stop_dt, ha.stop_dt


telephones

/telephoneNumberTypeDescriptor



'Home' AND 'Emergency 1' AND 'Emergency 2'


/telephoneNumber



[STUDENTS]home_phone, [STUDENTS]emerg_phone_1, [STUDENTS]emerg_phone_2



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.