Course Instructor Template (EWS)

Contents

Introduction

The Course Instructor Template is used to identify course offerings, associate instructors to the offering, and identify the teacher of record for each section of courses reported in the Course Template.

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.

Courses and Staff Selection

The report selects records from the [Courses] and [SectionTeacher] table based on the following criteria:

One record per District Code / Location Code / School Year / Course Code / Section Code
The course must not be excluded from EWS reporting.
The section must not be excluded from EWS reporting.
The teacher must not be excluded from EWS reporting.
All active teachers should have course instructor records. Teachers who are terminated during the school year are not reported unless the course they were teaching also ended with their departure. Long-term substitutes are reported only when they are filling a vacancy and become the teacher of record or are granted access to the dashboard application.
The combination of Course Code and Section code should uniquely identify a course section.
Roles Administration must be setup

Report Input

For help with report navigation and generation, see How to Find and Generate a Report.

Field	Description
Schools to Include*	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Report Start Date*	Enter the start date using the format mm/dd/yyyy for the first day of the reporting period.
Report End Date*	Enter the end date using the format mm/dd/yyyy for the last day of the reporting period.
Field Delimiter	Choose the field delimiter for the extract file from the pop-up menu.
Include Header Labels in output file?	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.
Scheduling	Select when to run the report. Run Now – Execute the report immediately. Schedule - Execute the report on the date and time specified. Start Date - Enter a start date to run the report. Start Time – Enter a start time to run the report. Select Run Once or Repeat to schedule how often the report is run.

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	Req’d
1	DISTRICT CODE	The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite.	[Prefs]District_Number If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Numeric	R
2	LOCATION CODE	The PDE-defined, 4-digit code identifying the school. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite.	[Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID	Numeric	R
3	SCHOOL DATE YEAR	A single date indicating the whole school year. June 30, at the end of the standard school year, is used to designate a school year. Thus, the 2014-2015 school year would be indicated by 2015-06-30.	Derived from [TERMS]	Date	R
8	PRIMARY INSTRUCTOR ID	A unique identifier for the instructor, regardless of whether they hold a PA certificate, the 7-digit Professional Personnel ID (PPID). Professional personnel can obtain a PPID from the TIMS system. Helpful information is found at the PDE website under “Teachers and Teacher Certification.” The Primary Instructor ID is considered the teacher of record for the course.	[S_PA_USR_X]State_Staff_ID is based on the section lead teacher. A custom field in sections is used to define the 'Teacher of Record' If populated it is this teacher Instructor ID that will be reported. If not populated then the Section Lead teacher's Id should be extracted. custom field in sections - [S_PA_SEC_X]Primary_Teacher_ID	Numeric	R
9	ADDITIONAL INSTRUCTOR 1 ID	A unique identifier for all instructors, regardless of whether they hold a PA certificate, the 7- digit Professional Personnel ID (PPID).	[S_PA_USR_X]State_Staff_ID [SectionTeacher]	Numeric	O
10	ADDITIONAL INSTRUCTOR 2 ID	A unique identifier for all instructors, regardless of whether they hold a PA certificate, the 7- digit Professional Personnel ID (PPID).	[S_PA_USR_X]State_Staff_ID [SectionTeacher]	Numeric	O
11	ADDITIONAL INSTRUCTOR 3 ID	A unique identifier for all instructors, regardless of whether they hold a PA certificate, the 7-digit Professional Personnel ID (PPID).	[S_PA_USR_X]State_Staff_ID [SectionTeacher]	Numeric	O
12	ADDITIONAL INSTRUCTOR 4 ID	A unique identifier for all instructors, regardless of whether they hold a PA certificate, the 7-digit Professional Personnel ID (PPID).	[S_PA_USR_X]State_Staff_ID [SectionTeacher]	Numeric	O
13	ADDITIONAL INSTRUCTOR 5 ID	A unique identifier for all instructors, regardless of whether they hold a PA certificate, the 7-digit Professional Personnel ID (PPID).	[S_PA_USR_X]State_Staff_ID [SectionTeacher]	Numeric	O
19	COURSE CODE LONG	The unique, local, LEA-specific COURSE CODE. Courses may have multiple sections. Each course should have a single COURSE CODE LONG. Do not assign separate course codes to sections of the same course.	[Courses]Course_Number	AlphaNumeric	R
20	PRIMARY INSTRUCTION LANGUAGE CODE	The primary language in which a course is taught. See Appendix F in Volume 2 of the PIMS User Manual for a complete list of valid values. Use 0000 for U.S. English.	[S_PA_SEC_X]Primary_Instr_Lang_Code	AlphaNumeric	O
22	SECTION CODE LONG	Class section number assigned by LEA to identify distinct classes. This field should be the local section number only.	[Sections]section_number	AlphaNumeric	R
24	SNAPSHOT DATE	For Dashboard Data Submissions this should always be the School Year Date.	static value- Derived	Date	R
25	ADDITIONAL INSTRUCTOR 1 TYPE CODE	A code defining the type of instructor assigned to the course in addition to the primary instructor. Submit if there is an Additional Instructor ID assigned to this course section (field # 9).	[SectionTeacher]RoleID Joined to the RoleDef Table ID field	AlphaNumeric	CR
26	ADDITIONAL INSTRUCTOR 2 TYPE CODE	A code defining the type of instructor assigned to the course in addition to the primary instructor. Submit if there is an Additional Instructor ID assigned to this course section (field # 10).	[SectionTeacher]RoleID Joined to the RoleDef Table ID field	AlphaNumeric	CR
27	ADDITIONAL INSTRUCTOR 3 TYPE CODE	A code defining the type of instructor assigned to the course in addition to the primary instructor. Submit if there is an Additional Instructor ID assigned to this course section (field # 11).	[SectionTeacher]RoleID Joined to the RoleDef Table ID field	AlphaNumeric	CR
28	ADDITIONAL INSTRUCTOR 4 TYPE CODE	A code defining the type of instructor assigned to the course in addition to the primary instructor. Submit if there is an Additional Instructor ID assigned to this course section (field # 12).	[SectionTeacher]RoleID Joined to the RoleDef Table ID field	AlphaNumeric	CR
29	ADDITIONAL INSTRUCTOR 5 TYPE CODE	A code defining the type of instructor assigned to the course in addition to the primary instructor. Submit if there is an Additional Instructor ID assigned to this course section (field # 13).	[SectionTeacher]RoleID Joined to the RoleDef Table ID field	AlphaNumeric	CR
59	NUMBER OF CREDITS	The number of credits students will earn upon completion of this course.	[Courses]CreditHours	AlphaNumeric	O
89	COURSE SEQUENCE CODE	When a section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this section attribute should be 1.	[S_PA_CRS_X]Course_Sequence	AlphaNumeric	R
92	MARKING PERIOD CODE	All Course Instructor records should use N/A as the Marking Period Value.	Static value = N/A	AlphaNumeric	R
93	TERM CODE	The type of the session during the school year in which the course section is offered.	[Terms]Name	AlphaNumeric	R
95	PRIMARY INSTRUCTOR START DATE	The date the primary instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
96	ADDITIONAL INSTRUCTOR 1 START DATE	The date the additional instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
97	ADDITIONAL INSTRUCTOR 2 START DATE	The date the additional instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
98	ADDITIONAL INSTRUCTOR 3 START DATE	The date the additional instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
99	ADDITIONAL INSTRUCTOR 4 START DATE	The date the additional instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
100	ADDITIONAL INSTRUCTOR 5 START DATE	The date the additional instructor began teaching the assigned section.	[SectionTeacher]Start_Date	Date	O
101	PRIMARY INSTRUCTOR END DATE	The date of the primary instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O
102	ADDITIONAL INSTRUCTOR 1 END DATE	The date of the additional instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O
103	ADDITIONAL INSTRUCTOR 2 END DATE	The date of the additional instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O
104	ADDITIONAL INSTRUCTOR 3 END DATE	The date of the additional instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O
105	ADDITIONAL INSTRUCTOR 4 END DATE	The date of the additional instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O
106	ADDITIONAL INSTRUCTOR 5 END DATE	The date of the additional instructor’s last day of assignment to the section.	[SectionTeacher]End_Date	Date	O