SB3 PowerSchool SIS Texas
Breadcrumbs

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