Course Extract
Introduction
This extract generates a comma-delimited file containing all courses offered in the year currently selected. This extract provides snapshot data active on the STARS reporting dates.
Selection Criteria
Selection criteria determine which database records are used in the report.
Course Selection
The report course section records from the [Sections] table based on the following criteria:
- The section must be associated with a school included in the report.
- The section must not be excluded from state reporting.
- The section must have an enrollment of 1 or more students on the reporting date.
- The section must be associated to a valid course; e.g. [Sections]Course_Number = [Courses]Course_Number.
- The section must be active on the reporting date.
For the K5P reporting period:
- At least one student enrolled in the class must have an active Programs Fact enrollment into the K5P or SS programs.
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:
|
Reporting Period | Choose a reporting period from the pop-up menu:
|
Field in Courses table used to track State Course Number | Choose Course Number or Alternate Course Number from the pop-up menu to indicate which field is used to store the state course number. |
Snapshot Date | Enter the snapshot date. Note: 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. |
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 | 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. Note: 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 Date | This value is automatically extracted as June 30th. The report determines the year by referencing the school year selected for the report input. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD. | [Terms]LastDay | 15/24 |
4 | N/A | Not collected. | N/A | 25/32 |
5 | Course Name | The name of the course. | [Courses]Course_Name | 33/62 |
6 | Department | Not collected. | N/A | 63/86 |
7 | Subject Area | Not collected. | N/A | 87/101 |
8 | Course Length | Not collected. | N/A | 102/104 |
9 | Number of Credits | Not collected. | N/A | 105/111 |
10 | Number of Class Sessions | Not collected. | N/A | 112/114 |
11 | Hours Indicator | Not collected. | N/A | 115/115 |
12 | Minimum Seats | Not collected. | N/A | 116/120 |
13 | Course Type Code | Not collected. | N/A | 121/132 |
14 | Course Type Description | Not collected. | N/A | 133/152 |
15 | Grade Type Code | Not collected. | N/A | 153/153 |
16 | Grade Type Description | Not collected. | N/A | 154/165 |
17 | Number of Grades | Not collected. | N/A | 166/170 |
18 | Course Weight | Not collected. | N/A | 171/175 |
19 | Additional Data | Not collected. | N/A | 176/190 |
20 | Special Program Indicator | Not collected. | N/A | 191/191 |
21 | Special Program Code | Not collected. | N/A | 192/194 |
22 | Special Program Description | Not collected. | N/A | 195/214 |
23 | Course Short Name | Not collected. | N/A | 215/226 |
24 | Gender | Not collected. | N/A | 227/227 |
25 | GPA Indicator | Not collected. | N/A | 228/230 |
26 | Semester | The report extracts the reporting period selected for the report input. Valid values:
| N/A | 231/232 |
27 | 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). | [Courses]alt_course_number or [Courses]Course_Number | 233/244 |
28 | Course Delivery Model Code | Not collected. | N/A | 245/250 |
29 | Alternate Course Code | The local district course number. The report extracts the local course number from the Course Number or Alternate Course Number field, whichever was not used to track the state number, based on the report input. | [Courses]alt_course_number or [Courses]Course_Number | 251/262 |
30 | Not used | Not collected. | N/A | 263/268 |
31 | Not used | Not collected. | N/A | 269/368 |
32 | Dual Credit | Not collected. | N/A | 369/371 |
| 33 | Not used | Not collected. | ||
| 34 | Not used | Not collected. | ||
| 35 | Not used | Not collected. | ||
| 36 | Not used | Not collected. | ||
37 | Not used | Not collected. | ||
| 38 | Not used | Not collected. | ||
| 39 | Not used | Not collected. | ||
| 40 | Not used | Not collected. | ||
| 41 | Not used | Not collected. | ||
| 42 | Not used | Not collected. | ||
| 43 | Not used | Not collected. | ||
| 44 | Not used | Not collected. | ||
| 45 | Not used | Not collected. | ||
| 46 | Not used | Not collected. | ||
| 47 | Not used | Not collected. | ||
| 48 | Not used | Not collected. | ||
| 49 | Not used | Not collected. | ||
| 50 | Not used | Not collected. | ||
| 51 | Not used | Not collected. | ||
| 52 | Not used | Not collected. | ||
| 53 | Not used | Not collected. | ||
| 54 | Not used | Not collected. | ||
| 55 | Not used | Not collected. | ||
| 56 | Not used | Not collected. | ||
| 57 | Not used | Not collected. | ||
| 58 | Not used | Not collected. | ||
| 59 | Not used | Not collected. | ||
| 60 | Not used | Not collected. | ||
| 61 | Not used | Not collected. | ||
| 62 | Not used | Not collected. | ||
| 63 | Not used | Not collected. | ||
| 64 | Not used | Not collected. | ||
| 65 | Not used | Not collected. | ||
| 66 | Not used | Not collected. | ||
| 67 | Not used | Not collected. | ||
| 68 | Not used | Not collected. | ||
| 69 | Not used | Not collected. | ||
| 70 | Not used | Not collected. | ||
| 71 | Not used | Not collected. | ||
| 72 | Not used | Not collected. | ||
| 73 | Not used | Not collected. | ||
| 74 | Not used | Not collected. | ||
| 75 | Not used | Not collected. | ||
| 76 | Not used | Not collected. | ||
| 77 | Pre-Advanced Placement Indicator | Not collected. |