Student Teacher Sections

This category captures section teachers and student section enrollments. The Student Teacher Sections category includes the following data views and resources:

Note: Student Teacher Sections resources are only published for public schools.

Staff Sections

This data view represents the class sections to which a teacher is assigned and is required for all teachers. The published view layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Term, Section Number, Last Publish Date, and Publishing ID.

Note: The Staff Section resource will publish data only when at least one student is enrolled.

staffSectionAssociations

Primary PowerSchool Source Data

[Period]
[Sections]
[Courses]
[Terms]

Selection Criteria

Records are published if the following criteria are met:

The teacher's school must not be excluded from state reporting.
The teacher's school must have an Ed-Fi State School number.
The staffUniqueId must be populated in PowerSchool.
The teacher must not be excluded from state reporting.
The teacher's section must not be excluded from state reporting.

Resource Output

A separate staffSectionAssociations record is published for each course section in which the teacher is scheduled based on the year and the Term selected in the PowerSchool UI.
A teacher with classes at multiple schools will have a record for each section at each school.
The staffSectionAssociations resource is dependent on the prior publishing of the following resources: sections.
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	[Table]Data Type	Stored in [Table]Field	Req’d
sectionReference A reference to the related section resource.				R
/schoolID	The school associated with the session.	Integer	SchoolOrgID	R
/schoolYear	The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018.	Integer	[CourseTranscripts]SchoolYear	R
/localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.	String	[CourseTranscripts]LocalCourseCode	R
sectionIdentifier		String	UniqueSectionCode
sessionName		String	SessionName
staffReference A reference to the related Staff resource.				R
/staffUniqueId	The staff associated with the section.	String	StaffUID	R
classroomPositionDescriptor	The type of position the staff member holds in the specific class/section, for example, Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher, etc.	String	ClassroomPosition_DX	R
beginDate	The month, day, and year of the first day of a teacher's assignment to the Section.	Date	[StaffCohortAssociationTbl]BeginDate	O
endDate	The month, day, and year of the last day of a teacher's assignment to the Section.	Date	[StaffCohortAssociationTbl]EndDate	O
_ext/GADOE
chwCertFieldCodeDescriptor		String	chwCertFieldCode_DX
attendance90Percent	In the Georgia State Information page, under the Course Enrollment - Course Data tab, if the value of the Student 90% Attendance Override value field is Yes, then true is published for this element. If the field is No, then false is published for this element. If the field is blank, then the value in the Student 90% Attendance field is checked. If the value is greater than 90%, then true is published for this element. If the value is less than 90%, then false is published for this element.	Boolean	Attendance90Percent

Student Sections

This data view represents the course sections to which a student is assigned. The published view layout provides the School Name, Student Number, Student Name, Grade Level, Course Number, Course Name, Section Number, Term, State Student Number, Last Publish Date, and Publishing ID.

studentSectionAssociations

Primary PowerSchool Source Data

[Period]
[Sections]
[Courses]
[Terms]
[Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

The student's school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
The section must not be excluded from state reporting.
The section must be taught during the Term selected in the PowerSchool UI.
The student must have corresponding school enrollment for the section enrollment.

Resource Output

A separate studentSectionAssociations record is published for each course section in each school in which a student is or was enrolled based on the year for the Term selected in the PowerSchool UI.
The studentSectionAssociations resource is dependent on the prior publishing of the following resources: sections.
StudentSectionAssociations for sections taken at a different school from the primary enrolled school are not published at this time.
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	[Table]Data Type	Stored in [Table]Field	Req’d
sectionReference A reference to the related section resource.				R
/schoolID	The school for which the section is defined.	Integer	SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number	R
/schoolYear	The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018.	Integer	[Terms]YearID	R
/localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.	String	[Courses]Course_Number	R
sectionIdentifier		String	UniqueSectionCode
sessionName		String	SessionName
studentReference A reference to the related Student resource.				R
/studentUniqueID	The student enrolled in the section.	String	[Students]State_StudentNumber	R
beginDate	The month, day, and year of the student's entry or assignment to the section.	Date	Minimum [Calendar_Day]Date_Value Where [Calendar_Day]InSession = 1 and [Calendar_Day]Date_Value is between the first and last day of the term and [Calendar_Day]Date_Value is greater than or equal to [CC]DateEnrolled Format: 'YYYY-MM-DD'	R
endDate	The month, day, and year of the withdrawal or exit of the student from the section.This element is required if applicable; otherwise it is excluded from publishing.	Date	Maximum [Calendar_Day]Date_Value Where [Calendar_Day]InSession = 1 and [Calendar_Day]Date_Value is between the first and last day of the term and [Calendar_Day]Date_Value is less than [CC]DateLeft Format: 'YYYY-MM-DD'	O
creditRecovery		Boolean	CreditRecovery
workBasedLearningProgramDescriptor		String	WorkBasedLearning_DX
eipDeliveryModelDescriptor		String	EIPDeliveryModel_DX
esolDeliveryModelDescriptor		String	ESOLDeliveryModel_DX
giftedDeliveryModelDescriptor		String	GiftedDeliveryModel_DX
specialEducationDeliveryModelDescriptor		String	SPEDDeliveryModel_DX
iepInclusionTypeDescriptor		String	IepInclusionType_DX
numberParapros		Number	NumberParaPros
attendance90Percent	In the Georgia State Information page, under the Course Enrollment - Course Data tab, if the value of the Student 90% Attendance Override value field is Yes, then true is published for this element. If the field is No, then false is published for this element. If the field is blank, then the value in the Student 90% Attendance field is checked. If the value is greater than 90%, then true is published for this element. If the value is less than 90%, then false is published for this element.	Boolean	Attendance90Percent
enrollmentLocationDescriptor		String	EnrollmentLocation_DX
_ext/additionalTeacher/staffReference - Array
staffUniqueId	The SSN of the additional teachers whose role is Co Teacher, ESOL Addl Teacher, and EIP Addl Teacher is published. The ESOL additional teacher SSN is published only if: There is an ESOL record created for the student. The ESOL additional teacher enrollment date is less than or equal to the student class date left -1, or the section teacher end date. The ESOL additional teacher end date is greater than or equal to the student class date left -1, or the section teacher end date. The EIP additional teacher SSN is published only if: There is an EIP record created for the student. The EIP additional teacher enrollment date is less than or equal to the student enrollment end date. The EIP additional teacher exit date is greater than or equal to the student enrollment entry date, or the exit date specified in EIP record. Note: Additional teachers, identified as P024, P025, and P026, are now included in the studentSectionAssociation record and published.		StaffUID	O