MCESA Student Teacher Course Report

Start Date

Enter the Start Date of the Report.

• Typically the earliest schools start date for the school year.

End Date

Enter the End Date of the Report.

• Defaults to today's date.

LEA Entity ID*

Enter the District LEA Entity ID (Required).

School Year

(SchoolYear)

The school year for this course section in '2012' format.

Calculated.

Pulls the 4 digit year number of the last day of the full year term of the term year set at the top of the page at run-time.

AZ LEA Entity ID

(LEAID)

The state assigned unique LEA entity identifier

N/A

Entered at report run-time.

AZ School Entity ID

(SchoolId)

The state assigned public or charter school entity identifier

[Schools]AZ_EntityID

Course Identifier

(CourseId)

The identifying code for the course content.

If the Course Identifier Section field is blank, report pulls from the Alternate Course Number Course field.  If the Alternate Course Number field is blank, report pulls from the Course Number field.

[Courses]Course_Number

[Courses]alt_course_number

[Sections]AZ_CourseID

Course Title

(CourseTitle)

The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).

If the Course Name Section field is blank, report pulls from the Courses Course name field.

[Courses]Course_Name

[Sections]AZ_CourseName

Session

(Session)

A description for the term or session for the course section, for example 'Fall semester' or '2nd Trimester'

[Terms]Name

Pulls term name of term associated with the section.

Section Identifier

(SectionIdentifier)

Unique identifier for a section.

[Sections]Id

Session Type

(SessionType)

The type of term or session this is.

Note:  Use the Student Course Enrollment / Final Grade mapping page to populate Session Type.

[Sections]termid

[StuTchCrsConnection]user_defined_integer (termid)

[StuTchCrsConnection]user_defined_text (session type)

Course Begin Date

(CourseBegin)

The date of the first day of instruction

Report pulls the first in-session day of the term.

[Sections]termid

[Terms]firstday

Course End Date

(CourseEnd)

The date of the last day of instruction

Report pulls the last in-session day of the term.

[Sections]termid

[Terms]lastday

Course Duration

(CourseDuration)

The total number of minutes of instructional time for the course.

If the Section ‘Course Duration’ field is blank, the report pulls from the Course ‘Course Duration field.

If both Course and Section fields are blank, the report calculates the number of instructional minutes based on the total number of minutes in the Bell Schedule for the period(s) the section meets.

** If the Section’s Period is not in the Bell Schedule or the Bell Schedule minutes do not accurately reflect the correct Instructional Minutes, the Course Duration field must be entered at either the Course or Section level.

Calculated.

[Courses]CourseDuration

[Sections]CourseDuration

Instructional Setting

(InstructionalSetting)

The instructional setting for the course

Defaults to ‘Regular Departmentalized Classroom’ if course or section are blank

[Sections]AZ_InstSet

[Courses]AZ_InstSet

Course Level Characteristic

(CourseLevel)

An indication of the level of rigor in a course

Defaults to ‘General or Regular’ if course or section are blank)

[Sections]AZ_CourseLevel

[Courses]AZ_CourseLevel

School Year

(SchoolYear)

The school year for this course section in '2012' format.

Calculated.

Pulls the 4 digit year number of the last day of the full year term of the term year set at the top of the page at run-time.

AZ LEA Entity ID

(LEAID)

The state assigned unique LEA entity identifier

N/A

Entered at report run-time.

AZ School Entity ID

(SchoolId)

The state assigned public or charter school entity identifier

[Schools]AZ_EntityID

Section Identifier

(SectionIdentifier)

Unique identifier for a section.

[Sections]Id

Teacher Last Name

(LastName)

The last, family or surname for the primary teacher for the course section as reported in the HQT system

PS 7.5 and higher:

The most recent active Section Lead Teacher within the collection period is always reported as Teacher 1.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher First Name

(FirstName)

The first or given name for the primary teacher for the course section as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher Middle Initial

(MiddleInitial)

The middle initial for the primary teacher for the course section as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher Birthdate

(Birthdate)

The primary teacher's birthdate as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher Role

(Role)

The role of the primary teacher for this course section

PS 7.5 and higher:

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract for more information.

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See Appendix for a list of valid Role Code values.

PS 7.2.3 and previous:

Report pulls a Role Code of R for all teachers.

Calculated.

Teacher Begin Date

(BeginDate)

The date when Teacher 1 begins being associated with this section

PS 7.5 and higher:

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

PS 7.2.3 and previous:

Report pulls the first in-session day of the term.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher End Date

(EndDate)

The Date upon which the primary teacher is no longer associated with this section

PS 7.5 and higher:

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

PS 7.2.3 and previous:

Report pulls the last in-session day of the term.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Educator Stakeholder ID

(EDSHID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[Teachers]SIF_StatePrid

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

School Year

(SchoolYear)

The school year for this course section in '2012' format.

Calculated.

Pulls the 4 digit year number of the last day of the full year term of the term year set at the top of the page at run-time.

AZ LEA Entity ID

(LEAID)

The state assigned unique LEA entity identifier

N/A

Entered at report run-time.

AZ School Entity ID

(SchoolId)

The state assigned public or charter school entity identifier

[Schools]AZ_EntityID

Section Identifier

(SectionIdentifier)

Unique identifier for a section.

[Sections]Id

SAIS Student ID

SAISID

The state assigned student ID in SAIS

[Students]State_StudentNumber

Student Last Name

(LastName)

The last, family, or sur name for the student as reported in SAIS

[Students]Last_Name

Student First Name

(FirstName)

The first or given name for the student as reported in SAIS

[Students]First_Name

Student Middle Initial

(MI)

The middle initial of the student as reported in SAIS

[Students]middle_name

Pulls first character.

Student Birthdate

(Birthdate)

The student's birthdate

[Students]dob

Course Entry Date

(CourseEntryDate)

The date of the first day the student received instruction in this course. Or, in the case of reentry, the date this particular membership segment began.

[CC]DateEnrolled

Course Exit Date

(CourseExitDate)

The date of the last day the student received instruction in this course. Leave blank if the student is still enrolled at the time of reporting. If a student exits and re-enrolls, each enrollment segment should have its own record with its own entry and exit date.

A value will be reported if the Exit occurs within the report date range.

[CC]DateLeft

Reports the last in session date before the exit date.

Course Entry Type

(EntryType)

The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school

Calculated

Reported Values:

N – New course enrollment

R – Student reenrolls in the same section (same sectionid) after an exit.

T – Student transfers from one class section to another class section of the same course at a school (same course number, different sectionid) within the school year.

Course Exit Type

(ExitType)

The type of exit the student had from this course. Required if the exit date is not empty.

Valid Values:

• CF – Content Complete (Full Credit)
• CP – Content Complete (Partial Credit)
• CN – Content Complete (No Credit)
• SC – Schedule Change
• LS – Left the School
• OE – Open Ended Course

The value entered on the student’s Section Enrollment page (All Enrollments) will be reported. If blank, Course Exit Type will be calculated (see next column).

Calculated Values:

LS – Student does not complete class because he left school (class exit date equals school exit date and school exit date is less than the end of the year)

SC – Student drops class before class completes and student has not left school on the drop date.

CN – Student completed the course, but received no credit where credit was offered (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit for stored grades associated with the section equals 0.

CP – Student completed the course, but received partial credit where credit was offered (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit hours for stored grades associated with the section is greater than 0 but less than the sum of the potential credit).

CF – Student completed the course with full credit (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit hours for stored grades associated with the section is greater than or equal to the sum of the potential credit).

Note: CF is reported at course completion for students in grade levels below grade 9.