Teacher Class Extract (TEAMS)-Co-Teacher Inclusion Report
Contents
Introduction
For each section of an active school course in the current school year, this report extracts records for the lead teacher, co-teachers, instructional paraprofessionals, and support staff when the teacher's section assignment is associated with a properly configured lead or co-teaching role. The report can be run for the fall or for the spring and pulls records for all courses that are scheduled during the current school year.
For the Teacher Class Extract (TEAMS) - Co-Teacher Inclusion report to extract the correct records, Co-Teaching Roles must be set up in PowerSchool. See the following section for details.
Configuring Roles for the Teacher Class Extract (TEAMS) - Co-Teacher Inclusion Report
The Teacher Class Extract uses the values on the Co-Teaching Roles page to determine whether a record should be extracted. Codes entered on this page also define the Support Staff Type and Co-Teacher and Instructional Paraprofessional type.
On the Co-Teaching Roles page, the Reference Code for a role must contain "MT" to be included in the extract. The extract uses the values in the Co-Teaching Roles Alt 1 code field to determine whether the role is Lead Teacher, Co-Teacher, or Instructional Paraprofessional and uses the values in the Alt 2 code field to set the values in the Co-Teacher Type Code or Instructional Para Type Code columns in the extract.
Note: Records with no Alt 1 code defined default to Teacher of Record.
- To configure roles for the Teacher Class Extract - Co-Teacher Inclusion report: On the Start Page, click the School link at the top of the page. The school list appears.
- Choose District Office from the pop-up menu. The district Start Page appears.
- Click System. The System Administrator page appears.
- Click Roles Administration. The Roles Administration page appears.
- Click Co-Teaching. The Co-Teaching Roles page appears.
- Click New. The Edit Co-Teaching Role appears.
- Complete the Name and Description fields, select the Enabled checkbox, and then select the applicable access/view/edit/display checkboxes for the role.
- In the Reference Code field, enter MT.
In the Alt Code 1 field, enter one of the following codes. This code sets the Support Staff Type Code in the report:
Role
Code
Lead Teacher
NA
Co-Teacher
TE
Instructional ParaProfessional
IP
Facilitator
FA
In the Alt Code 2 field, enter one of the following codes. This sets the values for the Co-Teacher or Instructional Paraprofessional Type Code field:
Role | Code |
Not a Co-Teacher / Instructional Paraprofessional | NA |
Special Education Co-Teacher / Instructional Paraprofessional | SE |
Title I Co-Teacher / Instructional Paraprofessional | TI |
General Education Co-Teacher / Instructional Paraprofessional | GE |
Alternative Education Co-Teacher / Instructional Paraprofessional | AE |
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Teacher Course/Section Selection
The report selects teacher assignment records from the [SectionTeacher] table for any section that is active in the school for the selected school year and has students enrolled in the course on the count date of the report.
- The Section Teacher record must not be excluded from state reporting – [S_MT_STC_X]State_ExcludeFromReporting = 1 indicates an excluded record.
- The Reference Code for the teacher role must equal "MT".
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Process Current School Only* | Select "Yes" to include only records from the currently selected school or select "No" to include records from all schools that meet the selection criteria. |
Collection Type* | Fall Count (First Monday of October) Spring Count (February First) |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
1 | Fiscal Year | The school calendar year. This value is reported from the last day of the full year term on the Years & Terms page. | Year portion of [Terms]LastDay where [Terms]IsYear = 1 | String | 4 |
2 | Owner Legal Entity Code | Legal entity code (LE) owner of the teacher | [Prefs]Value where [Prefs]Name = district number or [S_MT_USR_X] OwnerLegalEntityCode | String | 4 |
3 | Owner School Code | School code (SC) owner of the teacher | [S_MT_SCH_X]OPISchoolNumber or [S_MT_USR_X]OwnerSchoolCode | String | 4 |
4 | Location Legal Entity Code | Legal entity code (LE) Location of the class | [Prefs]Value where [Prefs]Name = district number or [S_MT_SEC_X]LocationLegalEntityCode | String | 4 |
5 | Location School Code | School code (SC) location of the class | [Schools]School_Number or [S_MT_SCH_X]OPISchoolNumber or [S_MT_SEC_X]LocationSchoolCode | String | 4 |
6 | SEID | State Employee Identifier | [S_MT_USR_X]SEID | Number | 10 |
7 | Course Code | Montana K-12 course code (NCES aligned) | [S_MT_CRS_X]NCESCode | String | 5 |
8 | Session Type Code | Defines the term for course credit | [S_MT_TRM_X]TermSessionTypeCode | String | 2 |
9 | Session Number | Session number of the Session Type Code | [S_MT_SEC_SectionInfo_X] Session_Number | Number | 2 |
10 | Section Code | Identifies a unique section of the course | [Sections]Section_Number | String | 20 |
11 | Teacher of Record Flag | Is this teacher of record (Y/N) |
| String | 1 |
12 | Support Staff Type Code | Is this a co-teacher or paraprofessional? Note: This is the value from the Alt Code 1 field on the Co-Teaching Roles page. | [S_MT_SEC_SectionInfo_X] Support_Staff_Type_Code | String | 2 |
13 | Co-Teacher Type Code | If a co-teacher, what type? Note: This is the value from the Alt Code 2 field on the Co-Teaching Roles page. | [S_MT_SEC_SectionInfo_X] Co_Teacher_Type_Code | String | 2 |
14 | Instructional Para Type Code | If a paraprofessional, what type? Note: This is the value from the Alt Code 2 field on the Co-Teaching Roles page. | [S_MT_SEC_SectionInfo_X] Instructional_Para_Type_Code | String | 2 |
15 | Academic Level Code | Defines the academic level of the course | [S_MT_SEC_X]AcademicLevelCode | String | 2 |
16 | Credit Amount | Credits earned by the student for the course | [Courses]Credit_Hours | Number | 4 |
17 | Course Sequence | Number of this course in terms of the course sequence | [S_MT_CRS_CourseInfo_X] Course_Sequence | Number | 2 |
18 | Course Sequence Total | Total number of courses in the course sequence | [S_MT_CRS_CourseInfo_X] Course_Sequence_Total | Number | 2 |
19 | District Course Name | District description of the course | [Courses]Course_Name | String | 50 |
20 | District Course Number | District code for the course | [Courses]Course_Number | String | 10 |
21 | Grade Low Code | Defines the low grade of the course | [S_MT_SEC_SectionInfo_X] Grade_Low_Code | String | 2 |
22 | Grade High Code | Defines the high grade of the course | [S_MT_SEC_SectionInfo_X] Grade_High_Code | String | 2 |
23 | Class Start Date | Date when the section starts | [Terms]FirstDay | Date | 10 |
24 | Class End Date | Date when the section ends | [Terms]LastDay | Date | 10 |
25 | Class Enrollment | Number of students enrolled in the section | [Sections]No_of_Students | Number | 3 |
26 | Class Minutes | Instruction time in minutes for this section | Calculated based on bell schedule or [S_MT_SEC_X]ClassMinutesOverride | Number | 5 |
27 | Distance Learning | Is the class delivered via distance learning? (Y/N) | [S_MT_SEC_X]DistanceLearningInd | String | 1 |
28 | Dual Enrollment Credit | Is dual enrollment or dual credit offered for this course? (Y/N) | [S_MT_SEC_X]DualEnrollmentCreditInd | String | 1 |
29 | Alternative Education Program | Is this section part of an Alternative Ed Program? (Y/N) | [S_MT_SEC_X]AltEdProgamInd | String | 1 |