Student Teacher Sections
This data category carries the sections scheduled for each teacher and student as published in the StaffSectionAssociation resource within the Staff Association and Student Enrollment categories. The Student Teacher Sections category includes the following data views and resources:
Staff Sections
This view captures a detailed list of Staff Sections successfully published to AzEDS in the StaffSectionAssociation entity within the Staff Association interchange. The layout includes the Teacher Number, Staff Name, Course Number, Course Name, Term, Section Number, Last Publish Date, and the Publishing ID.
StaffSectionAssociation
This association indicates the class sections to which a teacher is assigned. This entity is required for all teachers.
Primary PowerSchool Source Data
- [SectionTeacher]
- [Sections]
Selection Criteria
Records are published if the following criteria are met:
- The teacher was published in the Staff entity.
- The section was published in the Master Schedule interchange.
- StaffUniqueId must be populated in PowerSchool.
- The teacher must not be excluded from state reporting.
- The section's school must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- The course must have a valid state course code.
- The course, the section, and the section teacher must not be excluded from STC reporting ("AZ_ExcludeSTC").
Note: If AZ_ExcludesSTC is set to exclude the course, section, or teacher, the StaffSectionAssociation will still be published if both of the following are true:
- The Provider Last Name (AZ_ProviderT1LastName) is populated for the section.
- Include both External Provider and Internal Teacher is selected in School Setup > Sections.
Entity Output
- A separate StaffSectionAssociation record is published for each course section in which the Teacher is scheduled based on the year for the Term selected in the PowerSchool UI.
- A teacher with classes at multiple schools will have a record for each section at each school.
- A section with multiple teachers will have a record for each teacher associated with the section.
- The StaffSectionAssociation entity is dependent on the prior publishing of the following entities: Staff and Section.
- 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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
StaffReference/StaffIdentity | StaffUniqueId - The staff member assigned to the section. | Integer | [S_AZ_USR_X]STATE_UNIQUEID Derived from: [SectionTeacher]TeacherId [SchoolStaff]Users_DCID | M |
SectionReference/SectionIdentity The section the staff member is assigned to. | M | |||
/LocationReference/LocationIdentity The location, typically a classroom, where the section meets. | R | |||
//ClassroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room Default: 'OPEN' | M |
//SchoolReference/SchoolIdentity | SchoolId - The school for the section's classroom. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
/ClassPeriodReference/ClassPeriodIdentity The class period during which the section meets. | M | |||
//ClassPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Abbreviation If blank, Period_Number is used. Derived from: [Section_Meeting]Period_Number | M |
//SchoolReference/SchoolIdentity | SchoolId - The school for which the period is defined. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
/CourseOfferingReference/CourseOfferingIdentity | M | |||
//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. This must match LocalCourseCode in corresponding CourseOffering. | Varchar(60) | [Courses]Course_Number + '-' + [Courses]DCID Post-secondary schools [Courses]Course_Number + '-' + [Sections]DCID | M |
//Term | TermType - The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | if [S_AZ_StuTchCrsConnection_S]TermTypeCode is not empty:
Otherwise: Note: The 2017-18 year term is still reported as 'Year Round'. | M |
//SchoolYear | SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
//SchoolReference/SchoolIdentity | SchoolId – The school offering the course. This must match SchoolId in corresponding CourseOffering. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
ClassroomPosition | 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. | Descriptor | [SectionTeacher]RoleID [RoleProperty]PropValue derived from [SectionTeacher]RoleId Default: 'R' (Regular Class) | R |
BeginDate | Month, day, and year of a teacher's assignment to the section. If blank, defaults to the first day of the first grading period for the section. | Date | Override: [SectionTeacher]Notes Else: [SectionTeacher]Start_Date | R |
EndDate | Month, day, and year of the last day of a teacher's assignment to the section. | Date | Override: [Sections]AZ_STC_CourseEndDate Else: [SectionTeacher]End_Date | R |
Student Sections
This view captures detailed list of student sections successfully published to AzEDS in the StudentSectionAssociation entity within the Student Enrollment interchange. The layout includes the School Name, Student Number, Student Name, Gender, Grade Level, Course Number, Course Name, Term, Section Number, SAIS Number, Last Publish Date, and the Publishing ID.
StudentSectionAssociation
This association indicates the course sections to which a student is assigned.
Primary PowerSchool Source Data
- [CC]
- [Sections]
Selection Criteria
Records are published if the following criteria are met:
- The student was published in the Student Parent interchange.
- The section was published in the Master Schedule interchange.
- 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 section must not be excluded from state reporting.
- The course must have a valid state course code.
- The section enrollment ExitDate is greater than the EntryDate.
- The student was enrolled in the section for at least ten days or the section exit date is the same as the student's school enrollment exit date.
- The student was not exited as a 'No-Show'.
- The course, the course section, the section teacher, and the student's CC record must not be excluded from STC reporting ("AZ_ExcludeSTC").
Note: If AZ_ExcludesSTC is set to exclude the course, section, or teacher, the StudentSectionAssociation will still be published if both of the following are true:
- The Provider Last Name (AZ_ProviderT1LastName) is populated for the section.
- Include both External Provider and Internal Teacher is selected in School Setup > Sections.
Entity Output
- A separate StudentSectionAssociation 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 StudentSectionAssociation entity is dependent on the prior publishing of the following entities: Section, Student, and StudentSchoolAssociation.
- 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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
StudentReference/StudentIdentity | StudentUniqueId – The student enrolled in the section. | Integer | [Students]State_StudentNumber Derived from: [CC]StudentID | M |
SectionReference/SectionIdentity The section in which the student is enrolled. | M | |||
/LocationReference/LocationIdentity The location, typically a classroom, where the section meets. | M | |||
//ClassroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room Default: 'OPEN' | M |
//SchoolReference/SchoolIdentity | SchoolId - The school for the section's classroom. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
/ClassPeriodReference/ClassPeriodIdentity | M | |||
//ClassPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Abbreviation If blank, Period_Number is used. Derived from: [Section_Meeting]Period_Number | M |
//SchoolReference/SchoolIdentity | SchoolId - The school for which the period is defined. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
/CourseOfferingReference/CourseOfferingIdentity The course offering taught in the section. | M | |||
//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. This must match LocalCourseCode in corresponding CourseOffering. | Varchar(60) | [Courses]Course_Number + '-' + [Courses]DCID Post-secondary schools [Courses]Course_Number + '-' + [Sections]DCID | M |
//Term | TermType - The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | if [S_AZ_StuTchCrsConnection_S]TermTypeCode is not empty:
Otherwise: Note: The 2017-18 year term is still reported as 'Year Round'. | M |
//SchoolYear | SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
//SchoolReference/SchoolIdentity | SchoolId – The school offering the course. This must match SchoolId in corresponding CourseOffering. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
BeginDate | Month, day, and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period. | Date | [CC]DateEnrolled | R |
CourseEntryType | CourseEntryDescriptor - The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school. | Descriptor | [CC]AZ_EntryType If blank, calculated values:
| R |
EndDate | Month, day, and year of the withdrawal or exit of the student from the section. | Date | [CC]DateLeft | C |
CourseExitType | CourseExitDescriptor - The type of exit the student had from this course section. Required if the exit date is not empty. | Descriptor | [CC]AZ_ExitType
Note: CF is reported at course completion for students in grade levels below grade 9. | C |
Note | Any clarifying information for this student section enrollment record. | Varchar(250) | [CC]AZ_Notes | R |
DualCredit | An indication if the student is earning Dual Credit in a Dual Credit course. | Boolean | Override: [CC]AZ_DualCredit 'False' if CC value is false but Sections/Course value is true If no override: [Sections]AZ_DualCredit [Courses]AZ_DualCredit 'True' if Sections/Courses value is true; else, 'False' | R |
ConcurrentEnrollment | An indication whether the student is concurrently enrolled in a course that offers concurrent enrollment. | Boolean | Override: [CC]AZ_ConcurrentlyEnrolled 'False' if CC value is false but Sections/Course value is true: If no override: [Sections]AZ_ConcurEnroll [Courses]AZ_ConcurEnroll 'True' if Sections/Courses value is true; else, 'False' | R |