Skip to main content
Skip table of contents

Student Sections

Student sections refer to the specific classes or instructional units that students are enrolled in.

  • Student Information: Details about the student, including unique identifiers and demographic information.

  • Section Information: Information about the section, such as the course it belongs to, the teacher, and the schedule.

  • Enrollment Details: Specifics about the student’s enrollment in the section, including start and end dates, and any special considerations or accommodations.

studentSectionAssociations

Primary PowerSchool Source Data

Tables: CC, SECTIONS (sec), STUDENTS (s), TERMS (t), COURSES (crs)

Selection Criteria

One record published for each student enrollment in a section during the current school year where:

  • Student, Section, School not excluded from Ed-Fi or state reporting

  • Section included in CourseOfferings

  • Includes sections taken at a different school from enrollment school

  • Includes sections derived from hand-entered StoredGrades records

Resource Output

  • A student record is published for each student enrolled in the district in the year for the Term selected in the PowerSchool UI.

  • The student resource is not dependent on the prior publishing of other Ed-Fi resources.
    Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in the Student Enrollment category 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 ODS in real-time or on-demand ("Run Now" button).

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

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

State-assigned number for student  (STUDENTS.state_studentnumber)

Y

sectionReference

Y

localCourseCode

sec.course_number

Y

schoolId

State-assigned number based on SECTIONS.schoolId

Y

schoolYear

TERMS.yearid + 1991

Y

sectionIdentifier

E1056

CLASS-ID-NUMBER

Sections: S_TX_SEC_X.E1056_SectionIden_Calc
Sections generated from manually-entered Stored Grades: S_TX_SGR_X.E1056_SectionIden_Calc
Use calc fields in every case
For now, publish only the first 14 chars of the calculated section identifier.

Y

sessionName

Composite using TERMS.schoolid, TERMS.abbreviation, TERMS.dcid

Y

beginDate

E1069

STUDENT-BEGIN-DATE

CC.dateenrolled - also need manual entry stored grades records added here

Y

endDate

E1070

STUDENT-END-DATE

CC.dateleft

N

homeroomIndicator

E1440

HOME-ROOM-INDICATOR

S_TX_CRS_X.E1440_Homeroom_Section
S_TX_SEC_X.E1440_Homeroom_Section (override)

Flag above must be 1 (true) and Service Id for section must be in list at right.
Note updated KG Service ID's (3 removed, 2 added)                     

TX

TX Extensions

 

 

TX

courseCompletionIndicator

E1068

COURSE-COMPLETION-INDICATOR

true if student has final grade in Storedgrades or if student was enrolled through end of course or course part, otherwise false.  Override in S_TX_SGR_X.E1068.

TX

additional fields for display only

 

 

 

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

crs.course_name

sec.section_number

t.abbreviation

JavaScript errors detected

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

If this problem persists, please contact our support.