D - Course Catalog File 2023-2024

Field

Description

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet the 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.

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.

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. The default selection is "Run Now."

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.

• Records reported with sequence 1 (1 of 1) are reported as 'course_number.'

• The file reports multiple Course Catalog records for single courses taught in multiple unique 'sessions' or sequences:

  • Example: if an Algebra I course (course number Alg1) is taught in 2 different sessions (terms), Semester 1 and Semester 2, and the two sections have sequence values of '1 of 2' and '2 of 2', then we report two Course Catalog records, appending _12 and _22 to the Local Course Number field (Course ID).

• A file record needs to be created for each unique Sequence Group entered by users, having a unique CourseID for each D file record generated.

• If users specify multiple unique Course Sequence Groups at the section level for a course, we need to report multiple D file records for each unique Course Sequence Group within a course. (See example below).

• To achieve a unique CourseID value in the output when users specify multiple unique Course Sequence Groups at the section level for a course, we report multiple D file records for each unique Course Sequence Group.

  • We create 'CourseID' as follows for courses having multiple users entered Course Sequence Groups for a single PowerSchool Course: 'course_number_sequence_coursesequencegroup' (truncate at 20 characters).

[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.

A single course can have multiple designation codes. Refer to OSPI rules regarding which can go together. The report output does not display the concatenated value of codes.

If the user selects only the B course designation code, the report output displays B.

If the user selects only J or selects J along with other codes, then the report output displays only J.

If the user selects only J and B or selects J and B along with other codes, the report output displays only J B.

If the user selects other codes but does not select J and B, the report output displays only the other selected codes. For example, if the user selects the newly code Paid Work Experience (F) along with Science Lab (S) and Internation Baccalaureate (I), the report will display the value as “FSI”.

[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_CP_Adv_Manuf

[S_WA_CRS_X]Desig_CTE_CP_Maritime

[S_WA_CRS_X]Desig_CTE_CP_Aerospace

[S_WA_CRS_X]Desig_CTE_CP_Constr

[S_WA_CRS_X]Desig_TechPrep

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:

• 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

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.

Refer to Appendix AK of the CEDARS Appendices 23 - 24 document for the complete list of certifications available. http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]IndustryCertOffered

Cond

VarChar

40

D18

Sequence

This is an optional field for the 2021-22 school year. (Required for the school year 2022-23 and forward).

Identifies the order of the course reported in Element D04 – Course ID in a series of courses taken and reported with the same State Course Code in Element D08. The sequence of courses indicates only the order in which a series of courses are taken and does not indicate the length of the course or the amount of credit available to a course taker. This data should be interpreted as part 'n' of 'm', for example, Part 1 of 2 if a course is the first in a sequence of two.

If Section/Course sequence is blank, default to '1 of 1'.

Rule: If the course is not part of a sequence, report 1 – Part 1 of 1. Courses with the same State Course Code in Element D08 may be reported with a valid value of 1 – Part 1 of 1 if those courses are not part of the same sequence. Students do not need to take all parts of a given sequence while enrolled in the district.

[S_WA_CRS_X]Sequence

Yes

Int

2

D19

Sequence Group

This is an optional field for the 2021-22 school year. (Required for the school year 2022-23 and forward).

Identifies the sequence grouping of the course for the sequence reported in Element D18 – Sequence. Each grouping that indicates a specific sequence of courses must have a unique group value reported in Element D19.

If Section/Course sequence group is blank, defaults to the course's course number field.

Rule: Courses with the same sequence group value must have the same State Course
code reported in Element D08 – State Course Code.

[S_WA_CRS_X]SequenceGroup

Yes

varchar

20