Course Instructor Extract

Introduction

This extract generates a comma-delimited file containing the instructor(s) of each course or section offering. This extract provides snapshot data active on the STARS reporting dates.

The values for Semester, Course Code Long and Section Code Long must match the corresponding values in the Student Course Enrollment Template and Course Template. Also, the combination of Course Code Long and Section Code Long must be unique for each section.

Selection Criteria

Selection criteria determine which database records are used in the report.

Course Section Selection

The report selects course section records from the [Sections] table based on the following criteria:

The section must be associated with the appropriate term.

The first day of the term must occur on or before the report date.
The last day of the term must occur on or after the report date.

The section must be associated with a school included in the report.
The section must have had an enrollment of one or greater, even when there are no current enrollments.
The section must not be excluded from state reporting.
The section must be active on the reporting date.
The section must have an enrollment of 1 or more students on the reporting date.

Back to Top

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet the selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all records on the PowerSchool server that meet the selection criteria.
Reporting Period	Choose a reporting period from the pop-up menu: 40D 80D 120D EOY
The field in the Courses table used to track State Course Number	Choose Course Number or Alternate Course Number from the drop-down list to indicate which field is used to store the state course number.
Snapshot Date	Enter the snapshot date. If you are scheduling these reports to run on a set schedule (for the Year-Round reporting period), the Snapshot Date should be left blank. The report will then use the current system date.

Back to Top

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The PED assigned three-digit school number. The alternate school number is used if specified in the report input. For the summer submission location code field at the staff level will be looked, on the summer school staff record first, then the staff record flagged as the primary record. If the field is blank on both records, the school number (and alternate school number if one exists) for the primary record will be extracted.	[Sections]SchoolID [Schools]Alternate_School_Number For the Summer reporting period: [S_NM_SSF_X]LocationCode_SumSch [Schools]Alternate_School_Number [Schools]School_Number	9/14
3	School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. To change terms, click Terms and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Course Code	Not collected.	N/A	25/32
5	Section Number	Not collected.	N/A	33/36
6	Room	Not collected.	N/A	37/42
7	Class Period	Not collected	N/A	43/44
8	Primary Instructor ID	The staff ID for the record is the teacher’s social security number. This value must match the Staff ID from the Staff extract. The value is extracted without dashes. Alternate values: Distance Learning – 888888888 Concurrent Enrollment or Dual Credit – 777777777 Religious Instruction – 555555555	[Users]SSN	45/56
9	Other Instructor 1	Staff ID is the teacher’s social security number. The value is extracted without dashes.	[S_NM_SEC_X]TeamTeacher1ID	57/68
10	Other Instructor 2	Staff ID is the teacher’s social security number. The value is extracted without dashes.	[S_NM_SEC_X]TeamTeacher2ID	69/80
11	Other Instructor 3	Not collected.	N/A	81/92
12	Other Instructor 4	Not collected.	N/A	93/104
13	Other Instructor 5	Not collected.	N/A	105/116
14	Assistant	Not collected.	N/A	117/128
15	Permanent Substitute Instructor	Not collected.	N/A	129/140
16	Staff Name	The name of the Primary Instructor.	[Users]Last_Name	141/164
17	Semester	Reporting period selected in the report input. Valid values: 1 – 40D 2 – 80D 3 – 120D 4 – EOY	N/A	165/166
18	Class Period Long	The number of class periods for all reporting periods. If the section, course, or school level Class Period fields are all blank, the Class Period value will be derived based on section term. For example: If the section is set to the full-year term, the Class Period will report as YR. If the section is set to a semester term, the Class period will report as SEM. If the section is set to a trimester term, the Class Period will report as TRI. If the section is set to a quarter term, the Class Period will report as QTR.	[S_NM_CRS_X]ClassPeriod [S_NM_SEC_X]ClassPeriod	167/174
19	Course Code Long	The state assigned eight-digit course code. The report extracts the state course code from the Course Number or Alternate Course Number field, based on the report input selection. The first four digits represent the Course Classification, the fifth digit represents the Common Field and the sixth through eighth digits represent the Subject Fields (C, D, and E respectively).	[Sections]Course_Number=[Courses]Course_Number or [Courses]alt_course_number	175/186
20	Not used	Not collected.	N/A	187/202
21	Alternate Instruction Language Code	Required when a course is taught in a language other than English. See the list of language codes. Navigation: Start page > School setup > Sections > [Select course] >[Select section]> Alternate Instruction Language.	[S_NM_SEC_X]AltInstructionLang	203/218
22	Section Code Long	The local section number. The report extracts the course number and the section number, separated by a dash, e.g. MT100-20.	[Sections]Course_Number [Sections]Section_Number	219/243
23	Not Used	Not Collected	N/A	244/246
24	Snapshot Date	The report date. Valid values: 40D – YYYY-10-01 80D – YYYY-12-15 120D – YYYY-03-01 EOY – YYYY-06-01 Summer Submission – YYYY-06-29 2019-06-29 for the 18-19 year Year-Round - YYYY-07-15 For 40D and 80D reporting periods, the year value of the FirstDay field is used. For the 120D and EOY reporting periods, the year value of the LastDay field is used. The value must coincide with the corresponding Semester value.	[Terms]Firstday (year value is used [Terms]LastDay (year value is used)	247/256
25	N/A	Not Collected	N/A	257/276
26	N/A	Not Collected	N/A	277/296
27	N/A	Not Collected	N/A	297/316
28	N/A	Not Collected	N/A	317/336
29	N/A	Not Collected	N/A	337/356
30	N/A	Not Collected	N/A	357/376
31	N/A	Not Collected	N/A	377/396
32	N/A	Not Collected	N/A	397/416
33	N/A	Not Collected	N/A	417/436
34	N/A	Not Collected	N/A	437/456
35	N/A	Not Collected	N/A	457/476
36	N/A	Not Collected	N/A	477/480
37	N/A	Not Collected	N/A	481/484
38	N/A	Not Collected	N/A	485/488
39	N/A	Not Collected	N/A	489/492
40	N/A	Not Collected	N/A	493/512
41	N/A	Not Collected	N/A	513/532
42	N/A	Not Collected	N/A	533/552
43	N/A	Not Collected	N/A	553/555
44	N/A	Not Collected	N/A	556/558
45	N/A	Not Collected	N/A	559/561
46	N/A	Not Collected	N/A	562/567
47	N/A	Not Collected	N/A	568/587
48	N/A	Not Collected	N/A	588/607
49	N/A	Not Collected	N/A	608/627
50	N/A	Not Collected	N/A	628/647
51	N/A	Not Collected	N/A	648/667
52	N/A	Not Collected	N/A	668/687
53	N/A	Not Collected	N/A	688/693
54	N/A	Not Collected	N/A	694/699
55	N/A	Not Collected	N/A	700/705
56	N/A	Not Collected	N/A	706/711
57	N/A	Not Collected	N/A	712/717
58	N/A	Not Collected	N/A	718/723
59	N/A	Not Collected	N/A	724/731
60	Course Special Program Code	Specify BEP to identify classes that are part of the state’s BEP (funded program).	[S_NM_CRS_X]BEPCrs [S_NM_SEC_X]BEPCrs	732/734
61	N/A	Not Collected	N/A	735/735
62	N/A	Not Collected	N/A	736/741
63	N/A	Not Collected	N/A	742/761
64	Honors Indicator	A secondary indicator indicating the class is an Honors Class.	[S_NM_CRS_X]Honors_TF [S_NM_SEC_X]Honors_YN	762/764
65	Advanced Placement Indicator	A secondary indicator indicating the class is an Advanced Placement Class.	[S_NM_CRS_X]AP_TF [S_NM_SEC_X]AP_YN	765/767
66	Career and Technical Indicator	A secondary indicator indicating the class is a Career and Technical Class.	[S_NM_CRS_X]CarandTech_TF [S_NM_SEC_X]CarandTech_YN	768/770
67	Gifted Indicator	A secondary indicator indicating the class is a Gifted Class.	[S_NM_CRS_X]Gifted_TF [S_NM_SEC_X]Gifted_YN	771/773
68	N/A	Not Collected	N/A	774/776
69	Remedial Indicator	A secondary indicator indicating the class is a Remedial Class.	[S_NM_CRS_X]Remedial_TF [S_NM_SEC_X]Remedial_YN	777/779
70	Basic Indicator	A secondary indicator indicating the class is a Basic Class.	[S_NM_CRS_X]Basic_TF [S_NM_SEC_X]Basic_YN	780/782
71	Special Education Indicator	A secondary indicator indicating the class is a Special Education Class.	[S_NM_CRS_X]SPED_TF [S_NM_SEC_X]SPED_YN	783/785
72	International Baccalaureate Indicator	A secondary indicator indicating the class is an International Baccalaureate Class.	[S_NM_CRS_X]IB_TF [S_NM_SEC_X]IB_YN	786/788
73	N/A	Not Collected	N/A	789/791
74	Elective Indicator	A secondary indicator indicating the class is an Elective Class.	[S_NM_CRS_X]Elect_TF [S_NM_SEC_X]Elect_YN	792/794
75	N/A	Not Collected	N/A	795/797
76	N/A	Not Collected	N/A	798/801
77	N/A	Not Collected	N/A	802/805
78	Lab Component Indicator	A secondary indicator indicating the class has a Lab Component.	[S_NM_CRS_X]LabComp_TF [S_NM_SEC_X]LabComp_YN	806/808
79	N/A	Not Collected	N/A	809/813
80	N/A	Not Collected	N/A	814/818
81	N/A	Not Collected	N/A	819/823
82	N/A	Not Collected	N/A	824/829
83	Advanced Indicator	A secondary indicator indicating the class is an Advanced Class	[S_NM_CRS_X]Advanced_TF [S_NM_SEC_X]Advanced_YN	830/832

Back to Top