D - Course Catalog File 2019-2020

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: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: 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: The Selected [Number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
School Year	Choose the year for which to run the report.
Scheduling	Default is Run Now. Select Schedule to run the report on a specific date and time.

Back to Top

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	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	Unique course number assigned by the school and district.	[Courses]Course_Number	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. Notes: A single course can have multiple designation codes. There are rules regarding which can go together. See OSPI rules.	[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	Cond	VarChar	10
D08	State Course Code	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: Blank 1 – One-way Dual Language Program 2 – Two-way Dual Language Program	[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

Back to Top