Tool Search: SIRS Extracts
The Course extract reports course information for active courses.
Course Extract Editor
Report Logic
The Course extract reports courses where the Course > State Code is not null and is Active. This extract does not report inactive courses. All school year data is reported.
Extract Editor Fields
To generate the SIRS Extracts, use the following field descriptions to make the proper selections.
| Field | Description |
|---|---|
| Extract Type | The SIRS Extract to generate. |
| Format | The format in which the report should generate. Options are State Format (CSV) and HTML. Use State Format for reporting information to the state and the other types for data review and verification. |
| Ad Hoc Filter | Selecting a filter limits the results to only those included in the filter. |
| Column Headers | Indicates whether Column Headers should be included in the report. This dropdown list applies to State Format (CSV). |
Generate Extract/ Submit to Batch | Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
| Select Calendars | Identifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year. |
Course Report Layout
Element Name | Description | Campus Application |
|---|---|---|
District Code | The code that identifies the district and its schools for reporting purposes. The prefix "NY" is added to the district number. For example, if the district number is 662001, the District Code is NY662001. Alphanumeric, 8 characters | System Administration > Resources > District Information > State District Number District.number |
Location Code | The code that identifies the location for reporting purposes. Numeric, 4 digits | System Administration > Resources > School > School > Location Code CustomSchool.value |
School Year Date | Default date is June 30 of the reporting school year. For example, if the 1011 Calendar is selected, the School Year Date is 2011-06-30. Date field, 10 characters, YYYY-MM-DD | System Administration > Calendar > Calendar > Calendar > End Date Calendar.endDate |
Filler | This field reports blank. | N/A |
Course Name | The name of the course. Alphanumeric, 30 characters | Scheduling > Courses > Course > Course Editor > Name Course.name |
Course Department | The department to which the course belongs. Alphanumeric, 24 characters | Scheduling > Courses > Course > Course Editor > Department Department.name |
Filler | Fields 7-26 report blank. | N/A |
Supplementary Course Differentiator | This field reports as NA. | N/A |
Course Code Long | This number is used for identification, searching, and making requests. It appears on student schedules and transcripts. Numeric, 13 digits | Scheduling > Courses > Course > Course Number Course.number |
Filler | This field reports blank. | N/A |
Alternate Course Code | A code given a course to be used in state reporting. Alphanumeric, 15 characters | Scheduling > Courses > Course > State Code Course.stateCode |
Filler | Fields 30-61 report blank. | N/A |
| Curriculum Framework Type Code | This field reports blank. | N/A |
| End of Course Exam Required Code | This field reports blank. | N/A |
| Course Sequence Code | This field reports blank. | N/A |
| Number of Parts | This field reports blank. | N/A |
| Organization Defining Course | This field reports blank. | N/A |
| Minimum Number of Credits | This field reports blank. | N/A |
| Maximum Number of Credits | This field reports blank. | N/A |
| General Indicator | This field reports blank. | N/A |
| College Level Indicator | This field reports blank. | N/A |
| Untracked Indicator | This field reports blank. | N/A |
| HS Equivalent Indicator | This field reports blank. | N/A |
| Correspondence Indicator | This field reports blank. | N/A |
| Distance Learning Indicator | This field reports blank. | N/A |
| Graduation Credit Indicator | This field reports blank. | N/A |
| Magnet Indicator | This field reports blank. | N/A |
| Pre-Advanced Placement Indicator | This field reports blank. | N/A |
| Pre-International Baccalaureate Indicator | This field reports blank. | N/A |
| Other Characteristic Indicator | This field reports blank. | N/A |
| NCAA Eligibility Indicator | This field reports blank. | N/A |
| Career Cluster Code | This field reports blank. | N/A |
| Ability Grouping Indicator | This field reports blank. | N/A |
| Primary Fund Source Code | This field reports blank. | N/A |
Time Required for Completion | This field reports blank. | N/A |
| Additional Credit Type Code | This field reports blank. | N/A |
| Academic Indicator | This field reports blank. | N/A |
