D - Course Catalog File 2020-2021
Introduction
The Course Catalog file includes all courses for all grade levels in the current school year at each school in the district. One record should be reported for each course offered at each school within the district. For example, if Eng101 is offered at two schools, there should be two records in the file for Eng101, one for each school in the district offering the course.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.
Course Selection
The report selects records from the [Courses] tables based on the following criteria:
- The course must not be excluded from state reporting.
- The course must be associated with a section taught during the current school year.
- The section must be associated with a school that is not excluded from state reporting.
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
Field | Description |
Select Schools | Choose one of the following:
The All Schools option is only available when running the report from the District Office. |
Current Selection Students | Indicate which students to include in the report by selecting one of the following options:
If you are running the report for a single student, or a group of students, select the students before running the report.
|
| School Year | Choose the year for which to run the report. |
Scheduling | Select Schedule to run the report on a specific date and time. Default is Run Now. |
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 | Reqd | Field Type | Length |
|---|---|---|---|---|---|---|
D01 | School Year | The four-digit year in which the school year ends. | [Terms]LastDay | Yes | Char | 4 |
D02 | Serving County District Code | The county district code for the district providing service to the student. Use leading zeroes where necessary. | [Prefs]Value [Prefs]Name=districtnumber | Yes | Char | 5 |
D03 | Location ID | The Location ID for the school. The school number is reported. | [Schools]School_Number | Yes | VarChar | 4 |
D04 | Course ID | The course ID used by the district or school to represent the unique course number. | [Courses]CourseId | Yes | VarChar | 20 |
D05 | Course Title | Course name assigned by the school and district. | [Courses]Course_Name | Yes | VarChar | 50 |
D06 | Content Area Code | Primary content area. | [S_WA_CRS_X]ContentAreaCd | Yes | VarChar | 3 |
D07 | Course Designation Code | Course designation code outlined in WAC 392-415-070. Include this field for grades 7–12 for all courses that receive high school credit.
A single course can have multiple designation codes. Refer to OSPI rules regarding which can go together.
| [S_WA_CRS_X]Desig_IB [S_WA_CRS_X]Desig_CollegeInHS [S_WA_CRS_X]Desig_TestPrep [S_WA_CRS_X]Desig_Honors [S_WA_CRS_X]Desig_AP [S_WA_CRS_X]Desig_RunningStart [S_WA_CRS_X]Desig_CADR [S_WA_CRS_X]Desig_Online [S_WA_CRS_X]Desig_Cambridge [S_WA_CRS_X]Desig_LocalTest [S_WA_CRS_X]Desig_NationalTest [S_WA_CRS_X]Desig_Quantitative [S_WA_CRS_X]Desig_SciLab [S_WA_CRS_X]crsDesig_NonInstructional [S_WA_CRS_X]Desig_YouthReengagement [S_WA_CRS_X]Desig_DistrictOrLocal [S_WA_CRS_X]Desig_locTransition [S_WA_CRS_X]Desig_CTE_CorePlus | Cond | VarChar | 10 |
D08 | State Course Code | The unique course code assigned by the state. | [S_WA_CRS_X]StateCourseCd | Yes | Char | 6 |
D09 | Advanced Placement (AP) and International Baccalaureate (IB) Code | Code for an AP or IB associated course. | [S_WA_CRS_X]APCode [S_WA_CRS_X]IBCode | Cond | Numeric | 4,2 |
D10 | Classification of Instructional Program (CIP) Code Number | CIP code assigned by OSPI to approved CTE courses. | [Courses]Code | Cond | Char | 6 |
D11 | No longer an active data element. Formerly Is Career and Technical Education (CTE) Direct Transcription Available? | This data element is no longer used in CEDARS Course Catalog File D, but is still needed for historic courses reported in file H, Grade History. This position in the extract is now filler (null). | N/A | N/A | N/A | 1 |
D12 | CTE Course Equivalency Identification | RCW 28A.700.070, RCW 28A.230.097, and RCW 28A.230.010 allow for districts to determine course credit equivalency for Career and Technical Education (CTE) courses. | [Courses]CourseEquivalencyIdent | Cond | Char | 1 |
| D13 | CTE Equivalency | The type of equivalency applied to each CTE course offered within the course catalog for which the district utilizes a course equivalency. | [S_WA_CRS_X]CTECourseEquivalency | Cond | Char | 2 |
| D14 | Dual Language Instruction Type | The dual-language program model being used. Valid values:
| [S_WA_CRS_X]DualLangInstructionType | Y | Char | 1 |
| D15 | Dual Language Instruction Language | The secondary language the course is taught in. Required if Dual Language Instruction Type is not blank. See Appendix K of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx | [S_WA_CRS_X]DualLangInstructionLang | Cond | Char | |
| D16 | Course Level | The course's level of rigor. Defaults to 'General or Regular' if PowerSchool fields are blank. | [S_WA_CRS_X]CourseLevel | Yes | Char | 1 |
| D17 | Industry Recognized Certifications Offered | Indicates which, if any, state or nationally industry-recognized certifications are available through this CTE course. Defaults to '1 – No Industry Certification Offered' if Course/Sections fields are blank for CTE Courses. | [S_WA_CRS_X]IndustryCertOffered | Cond | VarChar | 40 |