Скачать презентацию October 2010 CEDARS in SKYWARD Acronyms Used Скачать презентацию October 2010 CEDARS in SKYWARD Acronyms Used

2325169d6e2fea294309b9c4471cb106.ppt

  • Количество слайдов: 125

October, 2010 CEDARS in SKYWARD October, 2010 CEDARS in SKYWARD

Acronyms Used in this Presentation CEDARS The Comprehensive Education Data and Research System OSPI Acronyms Used in this Presentation CEDARS The Comprehensive Education Data and Research System OSPI The Washington Office of Superintendent of Public Instruction EDS Education Data System WSIPC The Washington School Information Processing Cooperative FTP File Transfer Process EOC End of Course

What is CEDARS? CEDARS is a data system that allows OSPI to collect, store What is CEDARS? CEDARS is a data system that allows OSPI to collect, store and report information related to students, courses and teachers. • Course data includes standardized state course codes and content areas. • Student data includes demographics, enrollment information, schedules, grades, and program participation. • Teacher data includes demographics, certifications, and schedules. WSIPC has developed a data extract process that creates and populates 13 specific CEDARS files using data from district Skyward databases. These files are then sent to the OSPI secure FTP site using an automated process. Files are created and sent automatically on a weekly basis. This Power. Point presentation is designed be used in conjunction with the OSPI CEDARS Data Manual and provides Skyward users a lookup tool to quickly determine the Skyward data field(s) used to populate the fields in the CEDARS files. It is designed to provide information that will assist in the data analysis as a function of the CEDARS error correction process.

Today’s Agenda – – – Locating Your Exceptions in CEDARS (EDS) Handling Logical Deletes Today’s Agenda – – – Locating Your Exceptions in CEDARS (EDS) Handling Logical Deletes in CEDARS Skyward Data on your District Xport Drive SSID Export and SSID Import Skyward to CEDARS Data Cross-Reference – Q and A

Locating Your Exceptions in CEDARS Locating Your Exceptions in CEDARS

Locating Your Exceptions in CEDARS View Error Types is a summary of your error Locating Your Exceptions in CEDARS View Error Types is a summary of your error types. View Details is a list of the records in error. Error Records are the number of errors you have in the Table.

Locating Your Exceptions in CEDARS When using View Error Types, you can quickly see Locating Your Exceptions in CEDARS When using View Error Types, you can quickly see a summary of the types of errors occurring.

Locating Your Exceptions in CEDARS When using Error Details, you can export your errors Locating Your Exceptions in CEDARS When using Error Details, you can export your errors to Excel. This makes locating information easier.

CEDARS Logical Delete Process Click on the Submission List at the bottom left side CEDARS Logical Delete Process Click on the Submission List at the bottom left side of the screen

CEDARS Logical Delete Process In this example, Student Schedule and Staff Schedule reached the CEDARS Logical Delete Process In this example, Student Schedule and Staff Schedule reached the threshold

CEDARS Logical Delete Process Select one of the tables to view CEDARS Logical Delete Process Select one of the tables to view

CEDARS Logical Delete Process The records pending logical delete will be displayed CEDARS Logical Delete Process The records pending logical delete will be displayed

CEDARS Logical Delete Process CEDARS Logical Delete Process

Skyward Data on your district Export drive 1. Thirteen files are created from Skyward Skyward Data on your district Export drive 1. Thirteen files are created from Skyward for CEDARS. These "source" files are stored on your Export drive in Citrix. 2. On your Citrix desktop, double click on the ESD 101 -MF-## icon. Double click on your Export (X) drive.

Skyward Data on your district Export drive 3. In your export drive, look for Skyward Data on your district Export drive 3. In your export drive, look for folders with little zippers on them. The folders are named: District. Number_0000_CEDARS_Year. Month. Day_School. Year. ZIP Right click on that file and choose Extract All from the resulting menu. An Extraction Wizard will walk you through the few steps necessary to unzip the files and will save them into a new folder that will be created in your Export drive. The name of this folder will include the date of the extract from WSIPC. 4. After clicking Finish on the Wizard, you will see 13 text files listed on your screen. Find the file that has your errors, Staff, Location, etc.

Skyward Data on your district Export drive 5. To open a file to review Skyward Data on your district Export drive 5. To open a file to review the data, right click on it and choose Open With/Choose Program from the resulting menu. Within the box that appears, choose Microsoft Excel. Locate your errors. 6. Errors cannot be corrected on EDS or in the source files; errors must corrected in Skyward. 7. CEDARS data will be sent to OSPI every Thursday night at midnight. Remember: The goal is for all of us to maintain as accurate data as possible.

SSID extracts and imports This is a two part process: 1. Create an Extract SSID extracts and imports This is a two part process: 1. Create an Extract file with the new SSIDs from EDS 2. Import the new SSIDs into Skyward

SSID extracts and imports Part 1 – Create The Extract File There are two SSID extracts and imports Part 1 – Create The Extract File There are two ways to Create the Extract File: A. Use the CEDARS Match Process and Export (see the CEDARS FAQ instructions) B. Use the two step process in Skyward, Import them into EDS, Use the CEDARS Match Process and Export Both processes conclude with a file of student names and SSID numbers.

SSID extracts and imports Part 1 – Create The Import file If you choose SSID extracts and imports Part 1 – Create The Import file If you choose Step B to create the Export file: WS/State Reports/WA/SSID (Entity 000) • Run the Export Students without State IDs choosing to ‘Create an SSID Extract File and Report’ • Run the View/Save Locally for State Transfer, selecting the correct file. This places the file in the Export drive. This creates the file in your district’s Export Drive. • Import the SSIDReport. txt file into EDS, use the EDS Match process and Export the file to your Export Drive.

SSID extracts and imports Part 2 –Import SSIDs Into Skyward WS/State Reports/WA/SSID (Entity 000) SSID extracts and imports Part 2 –Import SSIDs Into Skyward WS/State Reports/WA/SSID (Entity 000) Run the Import Student State IDs Browse for the SSIDReport. txt Import the SSIDs

Skyward Data Cross Reference Skyward Data Cross Reference

CEDARS Location File (A) This file contains information about each district with an OSPI CEDARS Location File (A) This file contains information about each district with an OSPI assigned County -District Code and each school within the district. Each of the District’s schools with enrolled students will be reported in this file using the OSPI assigned school code. Additional district and school information will continue to be collected through the Education Data System (EDS) Profile. This CEDARS file is necessary to link data between the thirteen (13) CEDARS files. Placeholder records that districts may use for programs or sub-sets of schools should not be reported in this file.

CEDARS Location File (A) Element A 01 – School Year CEDARS Field Name: School. CEDARS Location File (A) Element A 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Location File (A) Element A 02 – County District Code CEDARS Field Name: CEDARS Location File (A) Element A 02 – County District Code CEDARS Field Name: County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element A 03– District Name CEDARS Field Name: District. Name Web Access Path: PS/CA/DS/CF/DI/District Name WESPa. C Path: SA/SY/DC/DI/District Name

CEDARS Location File (A) Element A 04 – Location ID Web Access Path: Entity CEDARS Location File (A) Element A 04 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location. ID

CEDARS Location File (A) Element A 05 – School Code CEDARS Field Name: School. CEDARS Location File (A) Element A 05 – School Code CEDARS Field Name: School. Code Web Access Path: WS/OF/PS/CO/SC/School Number WESPa. C Path: SM/EN/Edit Entity/Edit School/School # Element A 06 – School Name CEDARS Field Name: School. Name Web Access Path: WS/OF/PS/CO/SC/School Name WESPa. C Path: SM/EN/Edit Entity/Entity. School/School

CEDARS District Student File (B) This file consists of a record(s) for each student CEDARS District Student File (B) This file consists of a record(s) for each student served in the district during the current school year along with the basic demographic data associated with the student. A student should have a record for each enrollment. Multiple enrollment records within one district will be necessary if the student enters, exits, and reenters a district. Entry and exit dates may not overlap for individual students.

CEDARS District Student File (B) In some cases a student may need to be CEDARS District Student File (B) In some cases a student may need to be excluded from CEDARS

CEDARS District Student File (B) Element B 01 – School Year CEDARS Field Name: CEDARS District Student File (B) Element B 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS District Student File (B) Element B 02 – Serving County District Code CEDARS CEDARS District Student File (B) Element B 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: : PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element B 03 – Resident County District Code CEDARS Field Name: Resident. County. District. Code Web Access Path: WS/ST/PR/Entry-With/Edit/Res Dist WESPa. C Path: SM/ST/Entry-With/Edit/Res Dis Element B 04 – District Student ID CEDARS Field Name: Distric. Student. ID Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID

CEDARS District Student File (B) Element B 06 – Legal Last Name CEDARS Field CEDARS District Student File (B) Element B 06 – Legal Last Name CEDARS Field Name: Legal. Last. Name Web Access Path: WS/ST/PR/General/Profile/Edit/Last WESPa. C Path: SM/ST/General 1 tab/Edit/Last Name Element B 07 – Legal First Name CEDARS Field Name: Legal. First. Name Web Access Path: WS/ST/PR/General/Profile/Edit/First WESPa. C Path: SM/ST/General 1 tab/Edit/First Name Element B 08 – Legal Middle Name CEDARS Field Name: Legal. Middle. Name Web Access Path: WS/ST/PR/General/Profile/Edit/Middle WESPa. C Path: SM/ST/General 1 tab/Edit/Middle Name Element B 09 – Birth Date CEDARS Field Name: Birthdate Web Access Path: WS/ST/PR/General/ Birth Hist/Edit/Date of Birth WESPa. C Path: SM/ST/General 1 tab/Edit/Date of Birth

CEDARS District Student File (B) Element B 10 – Birth Country CEDARS Field Name: CEDARS District Student File (B) Element B 10 – Birth Country CEDARS Field Name: Birth. Country Web Access Path: WS/ST/PR/General/Birth Hist/Edit/Birth Country WESPa. C Path: N/A

CEDARS District Student File (B) Element B 11 – Ethnicity Code This is no CEDARS District Student File (B) Element B 11 – Ethnicity Code This is no longer an Active Data Element B 12 – Gender CEDARS Field Name: Gender Web Access Path: WS/ST/PR/General/Profile/Edit/Gender WESPa. C Path: SM/ST/General 1 tab/Edit/Gender

CEDARS District Student File (B) Element B 13 – Grade Level Web Access Path: CEDARS District Student File (B) Element B 13 – Grade Level Web Access Path: N/A CEDARS Field Name: Grade. Level. Code WESPa. C Path: N/A • Grade Level is calculated as: (SCHOOLYEAR – SKYWARD. STUDENT. GRAD-YR) + 12. • If the grade level is greater than 12, GD is reported. This is not a valid value for this element. Therefore, an error will be received and the student status must be reviewed in the database. (For active students only), • If the grade level is less than zero, PK is reported. • If the grade level is equal to zero, K is reported and the GLO Grade Level Override field (STUDENT-ECP) is checked for a K 1 or K 3. If the GLO is a K 1 or K 3, student is reported as a K 1 grade level; otherwise, the student is reported as a K 2 grade level. • Use the following chart to determine the correct values for entry in the GLO field for Kindergarten students (note that the P 223 Reporting Requirement is different but is based on the same values that are entered in the GLO field in Skyward):

CEDARS District Student File (B) Element B 14 – Date Enrolled in District CEDARS CEDARS District Student File (B) Element B 14 – Date Enrolled in District CEDARS Field Name: District. Enrollment. Date Web Access Path: WS/ST/PR/Entry-With/Edit/Most Recent District Entry Date, if C 08 is blank - or - WS/ST/PR/Entry-With/Edit/ District Enrollment Date as of Withdrawal Date , if Element C 08 is not blank WESPa. C Path: SM/ST/Entry-With/Edit/Most Recent District Entry Date - if Element C 08 is blank - or - SM/ST/Entry-With/Edit/District Enrollment Date as of Withdrawal Date, if Element C 08 is not blank Element B 15 – Date Exited from District CEDARS Field Name: District. Exit. Date Web Access Path: WS/ST/PR/Entry-With/Edit/Withdrawal Date WESPa. C Path: SM/ST/Entry-With tab/Edit/Withdrawal Date

CEDARS District Student File (B) Element B 16 – Disability Code CEDARS Field Name CEDARS District Student File (B) Element B 16 – Disability Code CEDARS Field Name Disability. Code Web Access Path: WS/SS/SE/PR/Disabilities/Edit/Disability/State Report Code WESPa. C Path: SM/SS/SE/Disability(s) tab/Disability Code/State Report Code

CEDARS District Student File (B) Element B 17 – Student Primary Language Code CEDARS CEDARS District Student File (B) Element B 17 – Student Primary Language Code CEDARS Field Name: Primary. Language. Code Web Access Path: WS/ST/PR/General/Profile/Edit/Native Language/Edit/Type WS/ST/PR/General/Profile/Edit/Language/Edit/Type Element B 18 – Student Language Spoken at Home CEDARS Field Name: Language. Spoken. At. Home Web Access Path: WS/ST/PR/General/Profile/Edit/Home Language/Edit/Type or WS/ST/PR/Family tab/Edit/Home Language/Edit/Type

CEDARS District Student File (B) Element B 19 – Social Security Number (SSN) Web CEDARS District Student File (B) Element B 19 – Social Security Number (SSN) Web Access Path: WS/ST/PR/WA-NCLB)/SSN WESPa. C Path: SM/ST/WA-NCLB tab/Edit/SSN CEDARS Field Name: SSN

CEDARS District Student File (B) Element 20 – Residential Zip Code + 4 CEDARS CEDARS District Student File (B) Element 20 – Residential Zip Code + 4 CEDARS Field Name: Zip. Code Web Access Path: WS/ST/PR/General/Address/Edit Home/Zip Code WESPa. C Path: SM/ST/Family tab/Edit/Zip Code

CEDARS District Student File (B) Element B 21 – Is Student Homeless? CEDARS Field CEDARS District Student File (B) Element B 21 – Is Student Homeless? CEDARS Field Name: Is. Homeless Web Access Path: WS/ST/PR/NCLB-2/Homeless WESPa. C Path: SM/ST/NCLB-2 tab/Homeless

CEDARS District Student File (B) Element B 22 – Is Student an Approved Private CEDARS District Student File (B) Element B 22 – Is Student an Approved Private School Student Attending Class Part-Time? CEDARS Field Name: Is. Approved. Private. School. Student. Attending. Part. Time Web Access Path: WS/ST/PR/Categories/District/Edit Catg WESPa. C Path: SM/ST/General 2 tab/Edit Catg - or - SM/ST/Entity tab/Edit Catg 7

CEDARS District Student File (B) Element B 23 – Is Student a Home-Schooled Student CEDARS District Student File (B) Element B 23 – Is Student a Home-Schooled Student Attending Class Part-Time? CEDARS Field Name: Is. Home. Based. Student. Attending. Part. Time Web Access Path: WS/ST/PR/Categories/District/Edit Catg WESPa. C Path: SM/ST/General 2 tab/Edit Catg - or - SM/ST/Entity tab/Edit Catg

CEDARS District Student File (B) Element B 24 – Is Student from a Foreign CEDARS District Student File (B) Element B 24 – Is Student from a Foreign Country with an F-1 Visa? CEDARS Field Name: Is. F 1 Visa. Foreign. Exchange. Student Web Access Path: WS/ST/PR/Categories/District/Edit Catg WESPa. C Path: SM/ST/General 2 tab/Edit Catg - or - SM/ST/Entity tab/Edit Catg

CEDARS District Student File (B) Element B 25 – Is Student In Foster Care? CEDARS District Student File (B) Element B 25 – Is Student In Foster Care? CEDARS Field Name: Is. Student. In. Foster. Care Web Access Path: WS/ST/PR/Categories/District/Edit Catg WESPa. C Path: SM/ST/General 2 tab/Edit Catg - or - SM/ST/Entity tab/Edit Catg

CEDARS District Student File (B) Element B 26 – Graduation Requirements Year CEDARS Field CEDARS District Student File (B) Element B 26 – Graduation Requirements Year CEDARS Field Name: Grad. Requirements. Year Web Access Path: WS/ST/PR/General/Profile/Grad Req Base Yr WESPa. C Path: SM/ST/General 1 tab/Edit/Grad Req Base Yr

CEDARS District Student File (B) Element B 27 – Student Expected Year of Graduation CEDARS District Student File (B) Element B 27 – Student Expected Year of Graduation CEDARS Field Name: Expected. Grad. Year Web Access Path: WS/ST/PR/General/Profile/WA Grad Yr WESPa. C Path: SM/ST/General 1 tab/Edit/WA Grad Yr Element B 28 – Cumulative Grade Point Average Web Access Path: WS/ST/PR/GPA/WA GPA/GPA CEDARS Field Name: GPA WESPa. C Path: N/A Element B 29 – Credits Attempted CEDARS Field Name: Credits. Attempted Web Access Path: WS/ST/PR/GPA/WA GPA/Credits Attemped WESPa. C Path: N/A Element B 30 – Credits Earned CEDARS Field Name: Credits. Earned Web Access Path: WS/ST/PR/GPA/WA GPA/Credits Earned WESPa. C Path: N/A

CEDARS School Student File (C) This file consists of a record(s) for each student CEDARS School Student File (C) This file consists of a record(s) for each student of the enrollment data associated with each entry and exit for every school that served the student within the current school year. A student should have a record for each enrollment. Multiple enrollment records within one school will be necessary if the student enters exits and reenters a school. Entry and exit dates may not overlap for individual students.

CEDARS School Student File (C) Element C 01 – School Year CEDARS Field Name: CEDARS School Student File (C) Element C 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS School Student File (C) Element C 02 – Serving County District Code CEDARS CEDARS School Student File (C) Element C 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element C 03 – District Student ID Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID CEDARS Field Name: Distric. Student. ID

CEDARS School Student File (C) Element C 04 – State Student ID (SSID) CEDARS CEDARS School Student File (C) Element C 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/State SSID Number

CEDARS School Student File (C) Element C 05 – Location ID Web Access Path: CEDARS School Student File (C) Element C 05 – Location ID Web Access Path: Entity selected CEDARS Field Name: Location. ID WESPa. C Path: Entity selected Element C 06 – Date Student Enrolled in School Web Access Path: WS/ST/PR/Entry-With/Edit/Entry CEDARS Field Name: School. Enrollment. Date WESPa. C Path: SM/ST/Entry-With tab/Edit/Entry Date Element C 07 –School Entry Code CEDARS Field Name: School. Entry. Code Web Access Path: WS/ST/PR/Entry-With/Edit/Entry Code WESPa. C Path: SM/ST/Entry-With tab/Edit/Entry Code

CEDARS School Student File (C) Element C 08 – Date Student Exited From School CEDARS School Student File (C) Element C 08 – Date Student Exited From School CEDARS Field Name: School. Exit. Date Web Access Path: WS/ST/PR/Entry-With/Edit/Entry WESPa. C Path: SM/ST/Entry-With tab/Edit/Entry Date Element C 09 – School Withdrawal Code CEDARS Field Name: School. Withdrawal. Code WS/ST/PR/Entry-With/Edit/Withdrawal Information/Code WESPa. C Path: SM/ST/Entry-With tab/Edit/Withdrawal Information/Code

CEDARS School Student File (C) Element C 10 – Is this the School that CEDARS School Student File (C) Element C 10 – Is this the School that is Primarily Responsible for the Student? CEDARS Field Name: Is. Primary. School Web Access Path: WS/ST/Entity Info/Edit/WA Primary School or WS/ST/Entity Info/Edit/Default Entity or WS/ST/PR/Entry-With/Edit/Withdrawal Information/Default Entity WESPa. C Path: SM/ST/Entity tab/Edit/WA Primary School or SM/ST/Entity tab/Edit/ Default Entity

CEDARS School Student File (C) Element C 11– School Choice Code CEDARS Field Name: CEDARS School Student File (C) Element C 11– School Choice Code CEDARS Field Name: Is. School. Choice. Code Web Access Path: WS/ST/PR/NCLB-2/Non-Res In/Edit/Enrolled In Type WESPa. C Path: SM/ST/NCLB-2 tab/Non-Res Enrl In/Edit/Enrolled In Type

CEDARS School Student File (C) Element C 12 – Cumulative Days Present this Enrollment CEDARS School Student File (C) Element C 12 – Cumulative Days Present this Enrollment Period CEDARS Field Name: Cumulative. Days. Present Web Access Path: N/A WESPa. C Path: N/A Element C 13 – Cumulative Number of Unexcused Absences Enrollment Period CEDARS Field Name: Num. Unexcused. Absences Web Access Path: N/A WESPa. C Path: N/A

CEDARS Course Catalogue File (D) This file is a catalog of all courses for CEDARS Course Catalogue File (D) This file 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. For example, if Eng 101 is offered at two schools, there would be two records in this file for Eng 101, one for each school in the district offering the course.

CEDARS Course Catalogue File (D) Element D 01 – School Year CEDARS Field Name: CEDARS Course Catalogue File (D) Element D 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Course Catalog File (D) Element D 02 – Serving County District Code CEDARS CEDARS Course Catalog File (D) Element D 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element D 03 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location. ID

CEDARS Course Catalogue File (D) Element D 04 – Course ID CEDARS Field Name: CEDARS Course Catalogue File (D) Element D 04 – Course ID CEDARS Field Name: Course. ID Web Access Path: WS/OF/SC/BC/CM/Edit Course/Course Key WESPa. C Path: SM/OF/CS/MA/Edit Course/Course Key Element D 05 – Course Title CEDARS Field Name: Course. Title Web Access Path: WS/OF/SC/BC/CM/Edit Course/Long Description WESPa. C Path: SM/OF/CS/MA/Edit Course/Long Description

CEDARS Course Catalogue File (D) Element D 06 – Content Area Code CEDARS Field CEDARS Course Catalogue File (D) Element D 06 – Content Area Code CEDARS Field Name: Content. Area. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/State Details/Content Area Code WESPa. C Path: N/A

CEDARS Course Catalogue File (D) Element D 07 – Course Designation Code CEDARS Field CEDARS Course Catalogue File (D) Element D 07 – Course Designation Code CEDARS Field Name: Course. Designation. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/Washington State Specific WESPa. C Path: SM/OF/CS/MA/Edit Course/More button – Online Course and Cambridge Program Not Available

CEDARS Course Catalogue File (D) Element D 08 – State Course Code CEDARS Field CEDARS Course Catalogue File (D) Element D 08 – State Course Code CEDARS Field Name: State. Course. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/State Details/State Course Code WESPa. C Path: N/A CEDARS State Course Codes for Mathematics EOC Testing:

CEDARS Course Catalogue File (D) Element D 09 – Advanced Placement (AP) and International CEDARS Course Catalogue File (D) Element D 09 – Advanced Placement (AP) and International Baccalaureate (IB) Code CEDARS Field Name: APIBCourse. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/Washington State Specific/Advanced Placement WESPa. C Path: SM/OF/CS/MA/Edit Course/More button/Adv Placement

CEDARS Course Catalogue File (D) Element D 10 – Classification of Instructional Program (CIP) CEDARS Course Catalogue File (D) Element D 10 – Classification of Instructional Program (CIP) Code Number CEDARS Field Name: CIPCode Web Access Path: WS/OF/SC/BC/CM/Edit Course/General Properties/CIP Code WESPa. C Path: SM/OF/CS/MA/Edit Course/CIP Code Element D 11 – Is Career and Technical Education (CTE) Direct Transcription Available? CEDARS Field Name: Is. Direct. Transcription. Available Web Access Path: WS/OF/SC/BC/CM/Edit Course/Washington State Specific/Direct Transcription Available WESPa. C Path: SM/OF/CS/MA/Edit Course/More button/Direct Transcription Available

CEDARS Student Schedule File (E) Schedules for each student in grade PK through grade CEDARS Student Schedule File (E) Schedules for each student in grade PK through grade 12 will be provided in this file. Only include those courses the student is currently taking during the term effective at the time of submission.

CEDARS Student Schedule File (E) Element E 01 – School Year CEDARS Field Name: CEDARS Student Schedule File (E) Element E 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Student Schedule File (E) Element E 02 – Serving County District Code CEDARS CEDARS Student Schedule File (E) Element E 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element E 03 – District Student ID CEDARS Field Name: District. Student. Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID Element E 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number

CEDARS Student Schedule File (E) Element E 05 – Location ID Web Access Path: CEDARS Student Schedule File (E) Element E 05 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location. ID

CEDARS Student Schedule File (E) Element E 06 – Course ID CEDARS Field Name: CEDARS Student Schedule File (E) Element E 06 – Course ID CEDARS Field Name: Course. Id Web Access Path: WS/OF/SC/BC/CM/Edit Course/Course Key WESPa. C Path: SM/OF/CS/MA/Edit Course/Course Key Element E 07 – Section ID CEDARS Field Name: Section. ID Web Access Path: WS/ST/PR/ Scheduling/Current/Edit/Course and Class Information/Section WESPa. C Path: SM/ST/ Scheduling tab/Edit/Course and Class Information/Section Element E 08 – Term CEDARS Field Name: Term Web Access Path: WS/ST/PR/Scheduling/Current/Edit/Course and Class Information/Term WESPa. C Path: SM/ST/Scheduling tab/Edit/Course and Class Information/Term

CEDARS Staff File (F) This file contains information about district staff teaching a course CEDARS Staff File (F) This file contains information about district staff teaching a course or assigned to a homeroom for the current school year in grades PK– 12. There should be one entry for each staff type for each staff member. If a staff member serves more than one school, then that information is captured in the Staff Schedule File G.

CEDARS Staff File (F) Element F 01 – School Year CEDARS Field Name: School. CEDARS Staff File (F) Element F 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Staff File (F) Element F 02 – Serving County District Code CEDARS Field CEDARS Staff File (F) Element F 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element F 03 – Staff ID CEDARS Field Name: Staff. Id Web Access Path: WS/OF/SC/BS/SM/Expand Course/Expand Meet Details/Edit/Tea WESPa. C Path: SM/OF/CS/CM/Edit Meet/Teacher

CEDARS Staff File (F) Element F 04 – Staff Type Code CEDARS Field Name: CEDARS Staff File (F) Element F 04 – Staff Type Code CEDARS Field Name: Staff. Type. Code Web Access Path: WS/SF/SF/WA/Staff Type Code/Edit/WA Staff Type WESPa. C Path: HR/EM/Main tab/Export CEDARS data from this plan HR/EM/Assignments tab/Edit/Assignment Breakdown button/Duty (for combined districts) Element F 05 – Certification Number CEDARS Field Name: Certification. Number Web Access Path: WS/SF/SF/Edit/Cert Number WESPa. C Path: HR module: HR/PR/Credits tab/Edit Certifications/Certification # Student module: SM/SF/Edit Staff/Cert Number

CEDARS Staff File (F) Element F 06 – Last Name CEDARS Field Name: Last. CEDARS Staff File (F) Element F 06 – Last Name CEDARS Field Name: Last. Name Web Access Path: WS/SF/SF/Edit Name/Last Name WESPa. C Path: SM/SF/Edit Name/Last Name Element F 07 – First Name CEDARS Field Name: First. Name Web Access Path: WS/SF/SF/Edit Name/First Name WESPa. C Path: SM/SF/Edit Name/First Name Element F 08 – Middle Name CEDARS Field Name: Middle. Name Web Access Path: WS/SF/SF/Edit Name/Middle Name WESPa. C Path: SM/SF/Edit Name/Middle Name

CEDARS Staff File (F) Element F 09 – Birth Date CEDARS Field Name: Birth. CEDARS Staff File (F) Element F 09 – Birth Date CEDARS Field Name: Birth. Date Web Access Path: WS/SF/SF/Edit Name/Date of Birth WESPa. C Path: SM/SF/Edit Name/Date of Birth

CEDARS Staff Schedule File (G) Schedules for each staff member in all grades PK– CEDARS Staff Schedule File (G) Schedules for each staff member in all grades PK– 12 teaching a course or assigned to a homeroom will be detailed in this file. The Staff Schedule File will include all teachers and the courses currently taught by teachers in the current school year. Only include those courses the teacher is currently instructing during the term effective at the time of submission.

CEDARS Staff Schedule File (G) Element G 01 – School Year CEDARS Field Name: CEDARS Staff Schedule File (G) Element G 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Staff Schedule File (G) Element G 02 – Serving County District Code CEDARS CEDARS Staff Schedule File (G) Element G 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element G 03 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location. ID

CEDARS Staff Schedule File (G) Element G 04 – Staff ID CEDARS Field Name: CEDARS Staff Schedule File (G) Element G 04 – Staff ID CEDARS Field Name: Staff. Id WESPa. C Source: CLASS-MEET. NAME-ID Web Access Path: WS/OF/SC/BC/SM/Expand Course/Expand Meet Details/Edit/Teacher Element G 05 – Course ID CEDARS Field Name: Course. Id Web Access Path: WS/OF/SC/BC/SM/Expand Course/Course Key WESPa. C Path: SM/OF/CS/MA/Edit Course Element G 06 – Section ID CEDARS Field Name: Section. Id Web Access Path: WS/OF/SC/BC/SM/Expand Course/Expand Meet Details/Edit/Class (Section number) WESPa. C Path: SM/OF/CS/MA/Edit Meet/Class (Section Number) Element G 07 – Term CEDARS Field Name: Term Web Access Path: WS/OF/SC/BC/SM/Expand Course/Expand Meet Details/Scheduling Term Start WESPa. C Path: SM/OF/CS/MA/Edit Meet/Scheduling Term Start

CEDARS Grade History File (H) This file contains records for every student’s high school CEDARS Grade History File (H) This file contains records for every student’s high school credit courses where credit was attempted. The final grade for the course must be the same grade that will appear on the student’s transcript. Grade history records for courses the student received from schools outside the serving district should be reported using 9999.

CEDARS Grade History File (H) Element H 01 – School Year CEDARS Field Name: CEDARS Grade History File (H) Element H 01 – School Year CEDARS Field Name: School. Year Web Access Path: SM/PS/PS/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition

CEDARS Grade History File (H) Element H 02 – Serving County District Code CEDARS CEDARS Grade History File (H) Element H 02 – Serving County District Code CEDARS Field Name: Serving. County. District. Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element H 03 – District Student ID CEDARS Field Name: District. Student. ID Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID Element H 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number

CEDARS Grade History File (H) Element H 05 – Location ID Web Access Path: CEDARS Grade History File (H) Element H 05 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location. Id

CEDARS Grade History File (H) Element H 06 – Staff ID CEDARS Field Name: CEDARS Grade History File (H) Element H 06 – Staff ID CEDARS Field Name: Staff. Id Web Access Path: WS/OF/SC/BC/SM/Expand Course/Expand Meet Details/Edit/Teacher WESPa. C Path: SM/OF/CS/CM/Edit Meet/Teacher Element H 07 – Course ID CEDARS Field Name: Course. Id Web Access Path: WS/OF/SC/BC/CM/Edit Course/Course Key WESPa. C Path: SM/OF/CS/MA/Edit Course/Course Key Element H 08 – Course Title CEDARS Field Name: Course. Title Web Access Path: WS/OF/SC/BC/CM/Edit Course /Short Description WESPa. C Path: SM/OF/CS/MA/Edit Course/Short Description

CEDARS Grade History File (H) Element H 09 – Grade Level Code CEDARS Field CEDARS Grade History File (H) Element H 09 – Grade Level Code CEDARS Field Name: Grade. Level. Code Web Access Path: WS/ST/PR/Grades tab/Class History/Edit (Current & Historical) WESPa. C Path: SM/ST/Grades tab/History/Edit/Grade Element H 10 – Letter Grade Web Access Path: WS/OF/GR/GS/ Expand Student/ Classes/Edit (Current & Historical) WESPa. C Path: SM/OF/GR/GE - or SM/ST/Grades tab/History/ Edit/Grade History Entry CEDARS Field Name: Letter. Grade

CEDARS Grade History File (H) Element H 11 – Credits Attempted CEDARS Field Name: CEDARS Grade History File (H) Element H 11 – Credits Attempted CEDARS Field Name: Credits. Attempted Web Access Path: N/A WESPa. C Path: N/A Element H 12 – Credits Earned CEDARS Field Name: Credits. Earned Web Access Path: N/A WESPa. C Path: N/A Element H 13 – Course Designation Code CEDARS Field Name: Course. Designation. Code Web Access Path: WS/OF/SC/BC/MA/Edit Course/Washington State Specific WESPa. C Path: SM/OF/CS/MA/Edit Course/More button

CEDARS Grade History File (H) Element H 14 – Content Area Code CEDARS Field CEDARS Grade History File (H) Element H 14 – Content Area Code CEDARS Field Name: Content. Area. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/State Details/Content Area Code WESPa. C Path: N/A Element H 15 – State Course Code CEDARS Field Name: State. Course. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/State Details/State Course Code WESPa. C Path: N/A

CEDARS Grade History File (H) Element H 16 – Advanced Placement (AP) and International CEDARS Grade History File (H) Element H 16 – Advanced Placement (AP) and International Baccalaureate (IB) Code CEDARS Field Name: APIBCourse. Code Web Access Path: WS/OF/SC/BC/CM/Edit Course/Washington State Specific/Advanced Placement WESPa. C Path: SM/OF/CS/MA/Edit Course/More button/Adv Placement

CEDARS Grade History File (H) Element H 17 – Classification of Instructional Program (CIP) CEDARS Grade History File (H) Element H 17 – Classification of Instructional Program (CIP) Code Number CEDARS Field Name: CIPCode Web Access Path: WS/OF/SC/BC/CM/Edit Course/General Properties/CIP Code WESPa. C Path: SM/OF/CS/MA/Edit Course/CIP Code Element H 18 – Term End Date CEDARS Field Name: Term. End. Date Web Access Path: WS/OF/GR/PS/CF/CL/expand ID/expand Class Control Sets/Edit/Class End Date WESPa. C Path: SM/OF/GR/CO/GR/Course Length Sets tab/Edit Control/Class Stop Date Element H 19 – Term CEDARS Field Name: Term Web Access Path: WS/OF/GR/PS/CF/CL/Class Control Sets/Edit/Scheduling Values/Start Term WESPa. C Path: SM/OF/GR/CO/GR/Course Length Sets tab/Schedule Value/Start Term

CEDARS Grade History File (H) Element H 20 – Is the Student a Career CEDARS Grade History File (H) Element H 20 – Is the Student a Career and Technical Education (CTE) Program Completer? CEDARS Field Name: Is. Vocational. Completer Web Access Path: WS/ST/PR/CTE tab/Add/CTE Completer WESPa. C Path: N/A Element H 21 – Did Student Receive a State or Nationally Recognized Industry Certification? CEDARS Field Name: Has. Industry. Certification Web Access Path: WS/ST/PR/CTE tab/Add/Industry Certificate WESPa. C Path: N/A

CEDARS Grade History File (H) Element H 22 – Is Career and Technical Education CEDARS Grade History File (H) Element H 22 – Is Career and Technical Education (CTE) Direct Transcription Available? CEDARS Field Name: Is. Direct. Transcription. Available Web Access Path: WS/OF/SC/BC/MA/Edit Course/Washington State Specific/Direct Transcription Available WESPa. C Path: SM/OF/CS/MA/Edit Course/More button/Direct Transcription Available Element H 23 – Is Tech Prep Completer? CEDARS Field Name: Is. Tech. Prep. Completer Web Access Path: WS/ST/PR/CTE tab/Add/Tech Prep Completer WESPa. C Path: NA

CEDARS Grade History File (H) Element H 24 – Did the Student Take or CEDARS Grade History File (H) Element H 24 – Did the Student Take or Pass a State or Nationally Recognized Assessment of Technical Skill and Knowledge? Web Access Path: WS/ST/PR/Test Scores/expand CTE Assessment test/expand Scores/Score column WESPa. C Path: SM/ST/Test Scores tab/Edit/Score column of the CTE Assessment test

CEDARS Student Programs File (i) This file details student participation in various programs for CEDARS Student Programs File (i) This file details student participation in various programs for the current school year. There should be one record per student per program for the current school year. For example, if a student enters, exits and re-enters a program, there should be two records to reflect these two separate enrollments into the program. If a student is participating in or received services from more than one program, there should be a record for each program. Information for the State Transitional Bilingual Instruction Program is not included in this file. It is reported separately in the Student Bilingual Programs File J. Information for the Special Education Program is not included in this file. It is reported separately in the Student Special Education Programs File K.

CEDARS Student Programs File (i) Element I 01 – School Year CEDARS Field Name: CEDARS Student Programs File (i) Element I 01 – School Year CEDARS Field Name: School Year Web Access Path: PS/SM/ES/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition Element I 02 – Serving County District Code CEDARS Field Name: Serving County District Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element I 03 – District Student ID CEDARS Field Name: District Student Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID

CEDARS Student Programs File (i) Element I 04 – State Student ID (SSID) CEDARS CEDARS Student Programs File (i) Element I 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number Element I 05 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location Id

CEDARS Student Programs File (i) Element I 06 – Program Code CEDARS Field Name: CEDARS Student Programs File (i) Element I 06 – Program Code CEDARS Field Name: Program Code ALL Program Codes are on WA/NCLB Student Programs with the exception of #16 and #19 Web Access Path: WS/ST/PR/WA-NCLB/Student Programs button/Edit/Funding Source #16 - WS/ST/PR/NCLB-2 tab/Section 504 #19 - WS/ST/PR/Food Service tab/Lunch Code WESPa. C Path: SM/ST/WA-NCLB tab/Student Programs button/Edit/Funding Source #16 - SM/ST/NCLB-2 tab/Section 504 #19 - SM/FS/PM/MP - or- SM/FS/PM/MA - or- SM/FS/PM/MC - or- SM/ST/FS tab

CEDARS Student Programs File (i) Element I 07 – Program Start Date CEDARS Field CEDARS Student Programs File (i) Element I 07 – Program Start Date CEDARS Field Name: Start Date Web Access Path: WS/ST/PR/WA-NCLB/Student Programs button/Edit/Program Start Date WESPa. C Path: SM/ST/WA-NCLB tab/Student Programs button/Edit/Program Start Date Element I 08 – Program Exit Date CEDARS Field Name: Exit Date Web Access Path: WS/ST/PR/WA-NCLB/Student Programs button/Edit/Program End Date WESPa. C Path: SM/ST/WA-NCLB tab/Student Programs button/Edit/Program End Date

CEDARS Student Programs File (i) Element I 09 – Exit Reason Code CEDARS Field CEDARS Student Programs File (i) Element I 09 – Exit Reason Code CEDARS Field Name: Exit Reason Reporting null due to the fact that the field is optional and is not available in the database. Web Access Path: N/A WESPa. C Path: N/A Element I 10 – Qualification Code CEDARS Field Name: Qualification Code Food Service Washington Reason Code when Program Code = 19 (Free/Reduced Meals) Web Access Path: WS/ST/PR/Food Service WESPa. C Path: SM/FS/PM/MP - or- SM/FS/PM/MA - or- SM/FS/PM/MC - or- SM/ST/Food Service tab

CEDARS Student Bilingual Programs File (J) This file captures program information unique to the CEDARS Student Bilingual Programs File (J) This file captures program information unique to the State Transitional Bilingual Instruction Program. There should be one entry for each student per enrollment into the program for the current school year. For example, if a student enters, exits, and re-enters the State Transitional Bilingual Instruction Program, there should be two entries to reflect these two separate enrollments into the Program. This file also captures students who are eligible for the State Transitional Bilingual Instruction Program, but are not served.

CEDARS Student Bilingual Programs File (J) Element J 01 – School Year CEDARS Field CEDARS Student Bilingual Programs File (J) Element J 01 – School Year CEDARS Field Name: School Year Web Access Path: PS/SM/ES/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition Element J 02 – Serving County District Code CEDARS Field Name: Serving County District Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element J 03 – District Student ID CEDARS Field Name: District Student Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID

CEDARS Student Bilingual Programs File (J) Element J 04 – State Student ID (SSID) CEDARS Student Bilingual Programs File (J) Element J 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number Element J 05 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location Id

CEDARS Student Bilingual Programs File (J) Element J 06 – Instructional Model Code CEDARS CEDARS Student Bilingual Programs File (J) Element J 06 – Instructional Model Code CEDARS Field Name: Instructional Model Code Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Instructional Model WESPa. C Path: N/A

CEDARS Student Bilingual Programs File (J) Element J 07 – Program Start Date CEDARS CEDARS Student Bilingual Programs File (J) Element J 07 – Program Start Date CEDARS Field Name: Start Date Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Start Date WESPa. C Path: SM/ST/NCLB-2 tab/Limited Eng Prof/Edit/Start Date

CEDARS Student Bilingual Programs File (J) Element J 08 – Program Exit Date CEDARS CEDARS Student Bilingual Programs File (J) Element J 08 – Program Exit Date CEDARS Field Name: Exit Date Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/End Date WESPa. C Path: SM/ST/NCLB-2 tab/Limited Eng Prof/Edit/End Date

CEDARS Student Bilingual Programs File (J) Element J 09 – Exit Reason Code CEDARS CEDARS Student Bilingual Programs File (J) Element J 09 – Exit Reason Code CEDARS Field Name: Exit Reason Code Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Exit Reason WESPa. C Path: N/A Valid Reasons: a – Re-designated/Transitioned b – Graduated c – Drop-out d – Left for other Reasons e – Transferred/Moved out of district g – Primary LEP factors attributed to Special Education

CEDARS Student Bilingual Programs File (J) Element J 10 – Placement Test Scale Score CEDARS Student Bilingual Programs File (J) Element J 10 – Placement Test Scale Score CEDARS Field Name: Placement Test Scale Score Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Placement Test/Scale Score WESPa. C Path: N/A Element J 11 – Placement Test Level Score CEDARS Field Name: Placement Test Level Score Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Placement Test/Level Score WESPa. C Path: N/A Element J 12 – Placement Test Date CEDARS Field Name: Placement Test Date Web Access Path: WS/ST/PR/NCLB-2/Ltd Eng Prof/Edit/Placement Test/Test Date WESPa. C Path: N/A

CEDARS Student Bilingual Program File (J) Element J 14 – Initial USA Placement Date CEDARS Student Bilingual Program File (J) Element J 14 – Initial USA Placement Date CEDARS Field Name: Initial USA Placement Date Reporting null due to the fact that the field is optional and is not available in the database. Web Access Path: N/A WESPa. C Path: N/A Element J 15 – Number of Months US Attendance CEDARS Field Name: Num Months US Attendance If using I 06 Program Code 15, Title III Immigrant, report the number of months the student attended school in the US (grades PK-12) prior to enrolling in this district. Web Access Path: WSSTPRWA-NCLBNbr Of Mnths US Attn WESPa. C Path: N/A

CEDARS Student Bilingual Program File (J) Element J 16 – Number of Months Non CEDARS Student Bilingual Program File (J) Element J 16 – Number of Months Non US Formal Education CEDARS Field Name: Num Months Non US Formal Attendance Reporting null due to the fact that the field is optional and is not available in the database. Web Access Path: N/A WESPa. C Path: N/A

CEDARS Special Education Programs File (K) This file captures program information unique to the CEDARS Special Education Programs File (K) This file captures program information unique to the Special Education Program. There should be one entry for each student per enrollment into the program for the current school year. For example, if a student enters, exits and re-enters the Special Education Program, there should be two entries to reflect these two separate enrollments into the Program.

CEDARS Special Education Programs File (K) A student is considered Special Education by CEDARS CEDARS Special Education Programs File (K) A student is considered Special Education by CEDARS if: The student has any data elements required for File K AND The student does NOT have a District Exit Date (B 15) AND The student does NOT have an Exit Reason Date and an Exit Reason Code (K 08 & K 09)

CEDARS Special Education Programs File (K) Element K 01 – School Year Current School CEDARS Special Education Programs File (K) Element K 01 – School Year Current School Year on Entity 000 CEDARS Field Name: School Year Web Access Path: PS/SM/ES/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition Element K 02 – Serving County District Code CEDARS Field Name: Serving County District Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element K 03 – District Student ID CEDARS Field Name: District Student Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID

CEDARS Special Education Programs File (K) Element K 04 – State Student ID (SSID) CEDARS Special Education Programs File (K) Element K 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number Element K 05 – Location ID Web Access Path: Entity selected WESPa. C Path: Entity selected CEDARS Field Name: Location Id

CEDARS Special Education Programs File (K) Element K 06 – Least Restrictive Environment (LRE) CEDARS Special Education Programs File (K) Element K 06 – Least Restrictive Environment (LRE) Code CEDARS Field Name: LRE Code Web Access Path: WS/SS/SE/PR/IEP Information/Edit/Least Restrictive Environment WESPa. C Path: SM/SS/SE/IEP Info tab/LRE button/LRE Training Information: The LRE Code is reported from the student’s most current IEP record, even if the IEP has a future date. Element K 07 – Start Date CEDARS Field Name: Start Date Web Access Path: WS/SS/SE/PR/IEP Information/Edit/Start IEP WESPa. C Path: SM/SS/SE/Gen. Info button/Upd Place/Begin Date

CEDARS Special Education Programs File (K) Element K 08 – Exit Date CEDARS Field CEDARS Special Education Programs File (K) Element K 08 – Exit Date CEDARS Field Name: Exit Date Web Access Path: WS/SS/SE/PR/State Reporting/Edit/Exit Date WESPa. C Path: SM/SS/SE/State Rpt button/Exit Date Element K 09 – Exit Reason Code CEDARS Field Name: Exit Reason Code Web Access Path: WS/SS/SE/PR/State Reporting/Edit/Exit Reason/Edit/State Rpt Code WESPa. C Path: SM/SS/SE/State Rpt button/Exit Code 1 = re-evaluated, no longer SPED; 2 = aged out; 3 = grad w/diploma; 4 = parent revokes consent

CEDARS Special Education Programs File (K) Element K 10 – Initial Referral Date CEDARS CEDARS Special Education Programs File (K) Element K 10 – Initial Referral Date CEDARS Field Name: Initial Referral Date This field is optional. Web Access Path: SM/SS/PR/SE/Referrals tab/ Date of Referral WESPa. C Path: N/A Element K 11 – Initial Eligibility Date CEDARS Field Name: Initial Eligibility Date Reporting blank due to the fact that the field is optional and is not available in the database. Web Access Path: N/A WESPa. C Path: N/A

CEDARS Special Education Programs File (K) Element K 12 – Last IEP Review Date CEDARS Special Education Programs File (K) Element K 12 – Last IEP Review Date CEDARS Field Name: Last IEP Review Date Web Access Path: WS/SS/SE/PR/IEP Information/Edit/Last IEP Meeting WESPa. C Path: SM/SS/SE/IEP Info tab/Last IEP Meeting

CEDARS Special Education Programs File (K) Element K 13 – Last Evaluation Date CEDARS CEDARS Special Education Programs File (K) Element K 13 – Last Evaluation Date CEDARS Field Name: Last Evaluation Date This field is optional. Web Access Path: WS/SS/SE/PR/Evaluation Info/Edit/Evaluation Completed WESPa. C Path: SM/SS/SE/Eval Info tab/Eval Compl Date

CEDARS Special Education Ethnicity File (L) This file captures ethnicity information unique to each CEDARS Special Education Ethnicity File (L) This file captures ethnicity information unique to each student. This file consists of at least one record for each student served in the district during the current school year along with ethnicity data associated with the student. If Ethnicity Code equals ‘ 10’ (Non-Hispanic), there cannot be other records in this file for the same student. If Ethnicity Code contains one of the Hispanic ethnicities, there can be multiple records for the student.

CEDARS Special Education Ethnicity File (L) Element L 01 – School Year Current School CEDARS Special Education Ethnicity File (L) Element L 01 – School Year Current School Year on Entity 000 CEDARS Field Name: School Year Web Access Path: PS/SM/ES/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition Element L 02 – Serving County District Code CEDARS Field Name: Serving County District Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element L 03 – District Student ID CEDARS Field Name: District Student Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID Element L 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number

CEDARS Special Education Ethnicity File (L) Element L 05 – Ethnicity Code CEDARS Field CEDARS Special Education Ethnicity File (L) Element L 05 – Ethnicity Code CEDARS Field Name: Ethnicity Code Web Access Path: WS/ST/PR/General Tab/Eth-Race/ Federal/State Ethnicity WESPa. C Path: N/A

CEDARS Special Education Race File (M) This file captures race information unique to each CEDARS Special Education Race File (M) This file captures race information unique to each student. This file consists of at least one record(s) for each student served in the district during the current school year along with race data associated with the student. For students who are multiracial, individual records will be submitted; one for each race selected.

CEDARS Special Education Race File (M) Element M 01 – School Year Current School CEDARS Special Education Race File (M) Element M 01 – School Year Current School Year on Entity 000 CEDARS Field Name: School Year Web Access Path: PS/SM/ES/CF/EY/Entity 000/Current School Year//Scheduling/Term Definitions/Start Date of first term definition WESPa. C Path: SM/EN/Edit Year/Term Def/Start Date of first term definition Element M 02 – Serving County District Code CEDARS Field Name: Serving County District Code Web Access Path: PS/CA/DS/CF/DI/District Code WESPa. C Path: SA/SY/DC/DI/District Code Element M 03 – District Student ID CEDARS Field Name: District Student Id Web Access Path: WS/ST/PR/WA-NCLB/Std. ID WESPa. C Path: SM/ST/WA-NCLB/St. ID Element M 04 – State Student ID (SSID) CEDARS Field Name: SSID Web Access Path: WS/ST/PR/WA-NCLB/Edit/State SSID Number WESPa. C Path: SM/ST/WA-NCLB/Edit/State SSID Number

CEDARS Special Education Race File (M) Element M 05 – Race Code CEDARS Field CEDARS Special Education Race File (M) Element M 05 – Race Code CEDARS Field Name: Race Code Web Access Path: WS/ST/PR/General Tab/Eth-Race/State Race WESPa. C Path: N/A

Questions? Questions?

Thank You for Coming! Email stucoord@esd 101. net Or call 456 -2718 with further Thank You for Coming! Email [email protected] 101. net Or call 456 -2718 with further questions