PATH: WA State Reporting > Course Catalog File (D)
The Course Catalog (File D) is a catalog of all courses for all grades in the current school year offered at each school in the district. There should be one record for each course offered at each school within the district.
Course Catalog File (D) Extract Editor
Report Logic
- To report, the section MUST
- Be active at least one day on or between the calendar start date and the As-of Date selected on the extract editor, and
- Have at least one student mapped to stateGrade (PK, K1, K2, 01-12) enrolled/actively rostered at least one day on or between the calendar start date and the As of Date selected on the extract editor.
- To report, the course MUST have a State Course Code.
- Records report regardless of schedule placement (instructional or non-instructional) or attendance flag (attendance taking or non-attendance taking).
Only the header row will report if there are no records reported in the extract.
Report Editor Field Descriptions
Field | Description |
---|---|
As-of Date | To report, the section MUST be active at least one day on or between the calendar start date and the As-of Date selected in this field. |
Ad Hoc Filter | Select an Ad hoc Filter to limit the information reported to staff within the selected filter. |
Format | The format in which the report will generate. Options include Tab Delimited, CSV, and HTML. |
Calendars | The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Generate Report | Use this button to immediately display the report in a separate window. |
Submit to Batch | Use this button to submit the report request to the batch queue. This 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. |
Report Example
Course Catalog File (D) Extract (HTML) Example
Report Layout
Element | Description | Type, Format, and Length | Campus Database | Campus Location |
---|---|---|---|---|
SchoolYear | The ending year of the current school year. | Date Field, 4 characters | Calendar.endDate | System Administration > Calendar > Calendar > End Date |
ServingCounty DistrictCode | The county-district code for the district in which the student receives instruction. If Serving County District Code is null, the State District Number is reported. | Alphanumeric, 5 characters | Enrollmnent.servingDistrict District.number | Student Information > General > Enrollment > Serving County District Code System Administration > Resources> District Information > State District Number |
LocationId | The State School Number of the school. | Alphanumeric, 4 characters | School.number | System Administration > Resources > School > State School Number |
CourseId | Course ID used by the district or school to represent the unique course number. This field reports the Course Number + (hyphen) + Section Number.
| Alphanumeric, 20 characters | Course.number Section.number | Scheduling > Courses > Course > Course Editor > Number Scheduling > Courses > Section > Section Number |
CourseTitle | Course title given to the course in this school and district. If the Advanced Placement (AP) course code or International Baccalaureate (IB) code is blank, this field reports from Scheduling > Courses > Course > Course Editor > Name. | Alphanumeric, 50 characters | Course.honorsCode Course.name | Scheduling > Courses > AP/IB Code Scheduling > Courses > Course > Course Editor > Name |
ContentAreaCode | Primary content area of the course. Used to to identify & pre-populate OSPI’s Teacher Quality Data Collection tool to make Highly Qualified Teacher determinations. This field will only report a value of Content Area Code = 123 or ZZZ. | Varchar, 3 digits | Course.contentAreaCode | Scheduling > Course/Section > Course > Course editor > Content Area Code |
CourseDesignation Code | Reports the Course Designation Code. If multiple codes are selected, the codes are strung together. For example, if I: International Baccalaureate, H: Honors, and T: Tech Prep are selected, a value of IHT is reported. | Alphanumeric, 10 characters | Course.programType | Scheduling > Courses > Course Designation Code |
StateCourseCode | An identifying number, usually determined by the State, for a course and its subject matter. | Alphanumeric, 6 characters | Course.stateCode | Scheduling > Courses > State Code |
APIBCourseCode | Advanced Placement (AP) course code or International Baccalaureate (IB) course code associated with this course. | Numeric, 7 digits 1234.56 | Course.honorsCode | Scheduling > Courses > AP/IB Code |
CIPCode | CIP Code Number assigned by OSPI to the approved CTE course. This field is required for CTE courses. | Alphanumeric, 6 characters | Course.vocationalCode | Scheduling > Courses > CIP code |
IsDirectTranscription Available | N/A | N/A | N/A | N/A |
CourseEquivalencyIdent | Reports the CTE Equivalency Determination
| N/A | Course.subjectArea | Scheduling > Courses > CTE Equivalency Determination |
CTEEquivalency | Reports the CTE Equivalency for the class of record.
| N/A | N/A | Scheduling > Courses > CTE Equivalency |
DualLanguage InstructionType | Reports the Dual Language Instruction Type of the reporting course. | N/A | Course.program | Scheduling > Course/Section > Course > Course Editor > Dual Language Instruction Type |
DualLanguage InstructionLanguage | Reports the Instruction Language of the reporting course section. This field only reports if the DualLanguageInstructionType field above is populated. If Instruction Language on the section is blank, logic will report the Instruction Language value on the course. If this field is also blank, the field reports null. | N/A | Course.program Course.language Section.language | Scheduling > Course/Section > Course > Course Editor > Dual Language Instruction Type Scheduling > Course/Section > Course > Section Editor >Instruction Language Scheduling > Course/Section > Course > Course Editor > Instruction Language |