Course Catalog File (D) Extract (Washington)

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

FieldDescription
As-of DateTo 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 FilterSelect 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.

CalendarsThe 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 ReportUse this button to immediately display the report in a separate window.
Submit to BatchUse 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

ElementDescriptionType, Format, and LengthCampus DatabaseCampus Location
SchoolYear

The ending year of the current school year.

Date Field, 4 characters

YYYY

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

LocationIdThe State School Number of the school.Alphanumeric, 4 charactersSchool.numberSystem 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.

  • For example, if Course Number = 55555 and Section Number = 1, a value of 55555-1 is reported.
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 digitsCourse.contentAreaCodeScheduling > 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 charactersCourse.programType

Scheduling > Courses > Course Designation Code

StateCourseCodeAn identifying number, usually determined by the State, for a course and its subject matter.Alphanumeric, 6 charactersCourse.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.honorsCodeScheduling > 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 charactersCourse.vocationalCode

Scheduling > Courses > CIP code

IsDirectTranscription
Available
 
N/AN/AN/AN/A
CourseEquivalencyIdent

Reports the CTE Equivalency Determination

  • If a default value is set in the Attribute Dictionary, report the default value.
  • Otherwise, report as null.
 N/ACourse.subjectAreaScheduling > Courses > CTE Equivalency Determination
CTEEquivalency

Reports the CTE Equivalency for the class of record.

  • 01 – Other Local Equivalency not aligned with valid values 02-19
  • 02 – Algebra 1
  • 03 – Algebra 2
  • 04 – Geometry
  • 05 – Statistics
  • 06 – Biology
  • 07 – Physics
  • 08 – Lab Science
  • 09 – Science (Other than Biology, Physics or Lab Science)
  • 10 – 1 Credit Beyond Geometry
  • 11 – 3rd Year Math
  • 12 – 3rd Year Math and Science
  • 13 – Biology or Lab Science
  • 14 – English
  • 15 – English and 3rd Year Math
  • 16 – English and Science
  • 17 – English, 3rd Year Math, and Science
  • 18 – Life Science or Lab Science
  • 19 – Physics or Lab Science
N/AN/AScheduling > Courses > CTE Equivalency
DualLanguage
InstructionType
Reports the Dual Language Instruction Type of the reporting course. N/ACourse.programScheduling > 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