District Setup

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Attendance Tracking and Notification

Define Tracking Methods

Attendance: Attendance Tracking and Notification > Tracking Methods > Edit/New Attendance Tracking Methods

Note: Verify that attendance tracking methods are set up with the following values for Washington. Washington-specific values are loaded with the Washington installer. These “seeded” values should not be edited. If different values are needed, create new tracking methods. This setup is required for CEDARS Student Absence File (N).

For additional information about setting up attendance Tracking Methods, review the Attendance Tracking and Notification cheat sheet. Attendance tracking and notification functionality requires PowerSchool 6.1.0.6 or later.

Name

Verify that the Percent tracking method is set up. Each tracking method must be set up separately with a different threshold.

Valid values:

• Consecutive

• Semester

• Year

• Period/Interval

• Calendar Month

• Calendar Week

• Trimester

• Quarter

[Gen]Name=UEAT_Percent

[Gen]Cat=Unexcused

N/A

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Threshold

Ensure 50 is the threshold for the Percent tracking method.

This setup indicates that a student who misses more than 50% of a school day due to unexcused absence will be reported as unexcused.

[Gen]ValueLi=50

[Gen]Cat=Unexcused

N/A

CEDARS N

Refresh Attendance Tracking Data

Unexcused Absences

Edit Attendance Calculations

Attendance: Attendance Tracking and Notification > Update Calculation Year > Edit Calculation for [school name]

1. Click a school, select the current school year, and click Submit.

2. On the Update Calculation Year page, click Submit. This will direct ATN to use the Term (school year) set at the top right of the page.

Note: The school name does not appear on the Update Calculation Year page when ATN is not defined at the school.

Define Years & Terms

Calendar: Years & Terms > Edit/New School Year

Name of School Year

Enter the name of the school year.

[Terms]Name

N/A

All Reports

Abbreviation

Enter an abbreviation for the school year.

CEDARS “Term” element.

Note: The conversion to match the abbreviation to the CEDARS terms values is done within the reports. See Appendix P of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Terms]Abbreviation

12

CEDARS E08, G07, H19

First Day of School

Enter the first day of the school year.

Note: The day must be the earliest date for all schools in the district. Schools with start dates earlier than this first day of school may not be included in district-wide CEDARS reports.

[Terms]FirstDay

N/A

All Reports

Last Day of School

Enter the last day of the school year.

CEDARS “School Year” element.

Note: The day must be the latest date for all schools in the district. Schools with end dates later than this last day of school may not be included in district-wide CEDARS reports.

[Terms]LastDay

N/A

All Reports

CEDARS A01, B01, C01, D01, E01, F01, G01, H01, I01, J01, K01, L01, M01, N01, P01

Define District Courses

Courses: Courses > Edit/New Course

Course Name

Enter the course name assigned by the district.

CEDARS “Course Title” element.

[Courses]Course_Name

50

CEDARS D05, H08

Course Number

Enter the unique course number assigned by the district.

CEDARS “Course ID” element.

[Courses]Course_Number

20

CEDARS D04, E06, G05, H07

P223

Alternate Course Number

Enter the alternate course number.

[Courses]Alt_Course_Number

N/A

Not Required

Credit Hours

Enter the number of potential credit hours for the course – the number of hours that could be awarded for completing the course.

CEDARS “Credits Attempted” element.

CEDARS: The Student Grade History File (H) only includes courses that offer credit.

[Courses]Credit_Hours

N/A

CEDARS B29, H11

CIP Code

Enter the CIP code assigned by the OSPI to approved CTE courses.

CEDARS “CIP Code” element.

See Appendix S of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Courses]Code

6

CEDARS D10, H17

Vocational Class

Select the checkbox if this is a vocational course.

[Courses]Vocational

N/A

P223

Credit Type

Enter the appropriate credit type for this course.

[Courses]CreditType

N/A

Not Required

Exclude On Report Cards/Transcripts

Select the checkbox if the course should be excluded from the Transcript.

[Courses]Sched_Do_Not_Print

N/A

Transcript

Exclude this course from CEDARS reporting

Select the checkbox if the course should be excluded from CEDARS reporting.

Note: Available only for the CEDARS Courses Catalog (D), Student Schedule (E), Staff (F), Staff Schedule (G) files.

[Courses]State_ExcludeFromReporting

N/A

CEDARS D, E, F, G

State Course Code

Enter the unique course code assigned by the state.

CEDARS “State Course Code” element.

See Appendix V of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]StateCourseCd

6

CEDARS D08, H15

Course Level

Add a new field to the Course/Sections/Historical Grades new/edit screens under State Course Code, allowing users to select a course's Course Level. Valid Values: 

• Blank 

• B – Basic or remedial 

• G – General or regular 

• E – Enriched or Advanced 

• H – Honors 

• C – College 

• X – No specified level of rigor 

[S_WA_CRS_X]CourseLevel

1

CEDARS D16, T18

Course Sequence

Identifies where a course lies when it is part of a consecutive sequence of courses

[S_WA_CRS_X]CrsSequence

2

CEDARS D18, T19

Sequence Group

Identifies the sequence grouping of the course sequence reported in Element T19  

[S_WA_CRS_X]CrsSequenceGroup

20

CEDARS D19, T20

CEDARS Course Designation Code is comprised of letter values associated with the following checkbox indicators and used in these reports:

• CEDARS Course Catalog File element D07

• CEDARS Student Grade History File element H13

• Transcript 2008 and Beyond

International Baccalaureate (I)

Select the checkbox to indicate this is an International Baccalaureate course.

CEDARS Designation I

[S_WA_CRS_X]Desig_IB

1

CEDARS D07, H13

Transcript

College in High School (C)

Select the checkbox to indicate this is a College in High School course.

CEDARS Designation C

[S_WA_CRS_X]Desig_CollegeInHS

1

CEDARS D07, H13

Transcript

CTE Dual Credit (Tech Prep) (T)

Select the checkbox to indicate this is a Tech Prep course.

CEDARS Designation T

[S_WA_CRS_X]Desig_TechPrep

1

CEDARS D07, H13

Transcript

Honors (H)

Select the checkbox to indicate this is an Honors course.

CEDARS Designation H

[S_WA_CRS_X]Desig_Honors

1

CEDARS D07, H13

Transcript

Advanced Placement (A)

Select the checkbox to indicate this is an Advanced Placement course.

CEDARS Designation A

[S_WA_CRS_X]Desig_AP

1

CEDARS D07, H13

Transcript

Running Start (R)

Select the checkbox to indicate this is a Running Start course.

CEDARS Designation R

[S_WA_CRS_X]Desig_RunningStart

1

CEDARS D07, H13

Transcript

P223

College Academic Distribution Requirements (CADR) (B)

Select the checkbox to indicate this is a CADR course.

CEDARS Designation B

[S_WA_CRS_X]Desig_CADR

1

CEDARS D07, H13

Transcript

Cambridge Program (K)

Select the checkbox to indicate this is a Cambridge Program Course.

CEDARS Designation K

[S_WA_CRS_X]Desig_Cambridge

1

CEDARS D07, H13

Transcript

Online (O)

Select the checkbox to indicate this is an Online course.

CEDARS Designation O

[S_WA_CRS_X]Desig_Online

1

CEDARS D07, H13

Transcript

Local Competency Test (L)

Select the checkbox to indicate this is a Local Competency Test course.

CEDARS Designation L

[S_WA_CRS_X]Desig_LocalTest

1

CEDARS D07, H13

Transcript

National Competency Test (N)

Select the checkbox to indicate this is a National Competency Test course.

CEDARS Designation N

[S_WA_CRS_X]Desig_NationalTest

1

CEDARS D07, H13

Transcript

Quantitative (Q)

Select the checkbox to indicate this is a Quantitative course.

CEDARS Designation Q

[S_WA_CRS_X]Desig_Quantitative

1

CEDARS D07, H13

Transcript

Science Lab (S)

Select the checkbox to indicate this is a Science Lab course.

CEDARS Designation S

[S_WA_CRS_X]Desig_SciLab

1

CEDARS D07, H13

Transcript

Non-Instructional (Z)

Select the checkbox to indicate this is a non-instructional course.

CEDARS Designation Z

[S_WA_CRS_X]crsDesig_NonInstructional

1

CEDARS D07, H13

1418 Youth reengagement dual credit (Y)

Select the checkbox to indicate this is a Youth Reengagement course.

CEDARS Designation Y

[S_WA_CRS_X]Desig_YouthReengagement

1

CEDARS D07, H13

District or other local dual credit program (D)

Select the checkbox to indicate this is a District Dual Credit course.

CEDARS Designation D

[S_WA_CRS_X]Desig_DistrictOrLocal

1

CEDARS D07, H13

Locally Determined Course - Locally Administered Assessment (X)

Select the checkbox to indicate this is a Locally determined course with a locally administered assessment.

CEDARS Designation X

[S_WA_CRS_X]Desig_locCrsAssessment

1

CEDARS D07, H13

Local Transition (E)

Select the checkbox to indicate this is a Local Transition course.

CEDARS Designation E

[S_WA_CRS_X]Desig_locTransition

1

CEDARS D07, H13

CTE Core Plus – Advanced Manufacturing (G)

Select the checkbox to indicate this is an Advanced Manufacturing course.

CEDARS Designation G

[S_WA_CRS_X]Desig_CTE_CP_Adv_Manuf

1

CEDARS D07, H13

CTE Core Plus – Maritime (U)

Select the checkbox to indicate this is a Maritime course.

CEDARS Designation U 

[S_WA_CRS_X]Desig_CTE_CP_Maritime

1

CEDARS D07, H13

CTE Core Plus – Aerospace  (V)

Select the checkbox to indicate this is an Aerospace course.

CEDARS Designation V

[S_WA_CRS_X]Desig_CTE_CP_Aerospace

1

CEDARS D07, H13

CTE Core Plus – Construction (W)

Select the checkbox to indicate this is a Construction course.

CEDARS Designation W

[S_WA_CRS_X]Desig_CTE_CP_Constr

1

CEDARS D07, H13

Tribal Language Competency Test (J)

Select the checkbox to indicate this is a Tribal Language Competency course.

[S_WA_CRS_X]Tribal_Lang_Competency

1

CEDARS D07, H13

Recruiting Washington Teachers (p)

Select the checkbox to indicate this is a Recruitment course.

[S_WA_CRS_X]Recruiting_WA_Teachers

1

CEDARS D07, H13

CTE Course Equivalency Identification

Course identification for which districts authorize course equivalency to each CTE course offered within the course catalog collection file.

Required for CTE courses.

Valid Values:

• A - Statewide Equivalency Course

• B - Local Equivalency Course

• C - No Course Equivalency

[S_WA_CRS_X]CourseEquivalencyIdent

1

CEDARS D12

CTE Course Equivalency

Choose the course equivalency designation for Career and Technical Education (CTE) courses.

Valid values:

• 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 of Lab Science
  

• 19 - Physics or Lab Science
  

[S_WA_CRS_X]CTECourseEquivalency

2

CEDARS D13

CTE Credit Equivalency

Choose the credit equivalency designation for Career and Technical Education (CTE) courses.

[S_WA_CRS_X]CTECreditEquivalency

2

CTE Industry Recognized Certifications Offered

Select which, if any, state or nationally industry recognized certifications are available through this CTE course.

CEDARS D File Defaults to '1 – No Industry Certification Offered' if 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

100

CEDARS D17

Advanced Placement Course

Required if Advanced Placement is checked under Course Designations above.

Choose the subject from the pop-up menu, if applicable.

CEDARS “AP/IB Course Code” element.

Refer to Appendix Q of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]APCode

5

CEDARS D09, H16

International Baccalaureate Course

Required if International Baccalaureate is checked under Course Designations above.

Choose the subject from the pop-up menu, if applicable.

CEDARS “AP/IB Course Code” element.

Refer to Appendix Q of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]IBCode

5

CEDARS D09, H16

Direct Transcription Available

(Invalid beginning 2011-2012)

Choose Yes or No from the pop-up menu to indicate if direct transcription is available for the vocational course.

Note: No longer used for state reporting; was CEDARS D11, H22.

[Courses]DirectTranscription

N/A

Not Required

Skills Program Course

Choose the appropriate value from the pop-up menu.

Valid values:

• (1) Skills Courses

• (2) Basic Courses offered at Skills Program

[S_WA_CRS_X]SkillsProgram

N/A

P223

Work Based Course

Select the checkbox if this is a work based course.

[S_WA_CRS_X]WorkBased

N/A

P223

Homeroom Course (Used in K-3 Class Size Report)

Select the checkbox if this is a homeroom course.

[S_WA_CRS_X]IsHomeroom

K-3 Class Size

Non-FTE Course

Choose the appropriate value, or leave the pop-up menu blank.

Valid values:

• Blank

• (1) Course not considered in FTE calculations

[S_WA_CRS_X]Non_FTE_Credit

N/A

P223

Content Area Code

Choose the primary content area for the course.

Required if International Baccalaureate is selected under Course Designations above 

CEDARS “Content Area Code” element.

See Appendix O of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]ContentAreaCd

3

CEDARS D06, H14

ALE Course Type

Choose the ALE type for this course, or leave the pop-up menu blank for non-ALE courses.

Valid values:

• Blank

• (N) No, course was not taught through ALE

• (O) Online

• (R) Remote

• (T) Site Based - Requires regular weekly in-person instructional contact time

• (U) Site Based - Requires regular less than weekly in-person instructional contact time

• (S) Site based (Obsolete as of 2017-2018. Change to T or U)

[S_WA_CRS_X]ALEFunded

N/A

CEDARS E09, H27

Dual Language Instruction Type

Choose the appropriate value, or leave the pop-up menu blank.

Valid values:

• Blank

• 1 – One-way Dual Language Program

• 2 – Two-way Dual Language Program

[S_WA_CRS_X]DualLangInstructionType

1

CEDARS D14

Dual Language Instruction Language

Choose 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

CEDARS D15

Approved Online Provider

Identifies the online provider offering the course.

See Appendix AA, of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]ApprovedOnlineProvider

2

CEDARS E10

Approved Online Program

Identifies the online program offering the course.

See Appendix AB, of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CRS_X]ApprovedOnlineProgram

3

CEDARS E11

Civil Rights Data Collection (CRDC)

Use this link to access CRDC data entry for the course.

Civil Rights Data Collection (CRDC)

Set up Incident Management

Configuring Codes and Subcodes

Discipline and Log Entries: Incident Management > Incident Management Setup > Code & Subcode Setup link > Incident Management Code & Subcode Configuration

To add a new code to a code type, click the green plus ("+") sign. For detailed information about setting up Incident Types, and Incident Codes and Subcodes, see Incident Management Quick Setup.

See the Appendix for information on the expected Incident Management codes and subcodes.

Code Type

The type of incident management code.

Valid values:

• Action Codes

• Attribute Codes

• Behavior Codes

• Participant Attribute Codes

• Location Codes

• Object Codes

• Time Codes

• Duration Codes

• Action Change Codes

[Incident_Lu_Code]Code_Type

N/A

CEDARS P

Weapons

SpSuspExpel

Category

Enter the high level incident code.

[Incident_Lu_Code]Incident_Category

N/A

CEDARS P

Weapons

SpSuspExpel

State Aggregate Report Code

Enter the reportable code for this code category.

[Incident_Lu_Code]State_Aggregate_RPT_Code

N/A

CEDARS P

Weapons

SpSuspExpel

Subcode

If applicable, enter a subcode related to the category above.

Sub categories are optional.

[Incident_Lu_Sub_Code]Sub_Category

N/A

Not Required

Short Description

Enter a short description of this subcode

[Incident_Lu_Sub_Code]Short_Desc

N/A

Not Required

Full Description

Enter a detailed description of this subcode.

[Incident_Lu_Sub_Code]Long_Desc

N/A

Not Required

State Detail Report Code

Enter the state code associated with this subcode.

[Incident_Lu_Sub_Code]State_Detail_Report_Code

N/A

Not Required

State Reportable

Select the checkbox if this code is reportable to the state.

[Incident_Lu_Sub_Code]Is_State_Reportable_Flag

N/A

Not Required

Police Reportable

Select the checkbox if this code is reportable to the police.

[Incident_Lu_Sub_Code]Is_Police_Reportable_Flag

N/A

Not Required

Allow Comment

Select the checkbox if the user can comment on this code when entering an incident.

[Incident_Lu_Sub_Code]Comment_Enable_State

N/A

Not Required

Make Comment Mandatory

Select the checkbox if the user is required to comment on this code when entering an incident.

[Incident_Lu_Sub_Code]Comment_Enable_State

N/A

Not Required

Types of Incidents

Incident Management > Incident Management Setup > Incident Types link > Incident Types

Name

Enter the name of the incident type.

Note: CEDARS P expects the name ‘Discipline’.

[Incident_Lu_Code]Incident_Category

[Incident_Lu_Code]Code_Type=incidenttypecode

N/A

CEDARS P

Weapons

SpSuspExpel

Enter District Info

District Information: District Info

Name of District

Enter the district name.

CEDARS “District Name” element.

[Prefs]Value

[Prefs]Name=districtname

250

CEDARS A03

P223

P223H

Transcript

SpTimeline

SpPartC

District Number

Enter the district number.

CEDARS “Serving County District Code” element.

[Prefs]Value

[Prefs]Name=districtnumber

5

CEDARS B02, C02, D02, E02, F02, G02, H02, I02, J02, K02, L02, M02, N02, P02

P223

P223H

SSID Request

Entering State Info

Civil Rights Data Collection (CRDC)

Use this link to access CRDC data entry.

See the Washington CRDC section for further assistance.

N/A

N/A

N/A

Serving District County

The name of the county that is served by the district.

See http://www.k12.wa.us/maps/countymap.aspx for a map of the Washington counties.

[Prefs]Value

[Prefs]Name=ServeDistCounty

N/A

P223

P223H

Serving District ESD

The district’s Educational Service District (ESD) number.

There are several ESDs that make up the state of Washington. ESDs are a larger grouping of districts than the counties.

See http://www.k12.wa.us/maps/ESDmap.aspx for a map of the ESDs.

[Prefs]Value

[Prefs]Name=ESD

N/A

P223

P223H

Use Tabs on Student Information Pages

Select the checkbox to format the student State/Province – WA pages to use tabs instead of a list of links.

[Pref]WA_TabFlag

N/A

N/A

Default Course Number for Grade History (CEDARS H)

Enter the default course number to use for the CEDARS Grade History file for grades without an associated course. This will only be used when the school-level default course number is not entered.

[Pref]WA_TransferCrsNumber

N/A

CEDARS H07

Default Store Codes to Print On Transcript

This parameter is used in the WA Transcript 2008 and Beyond. Values may be set by clicking the switches to add or remove codes, or entering codes in the text box.

[Pref]WA_TranscriptSC

N/A

Transcript 2008 and Beyond

Washington State-Discipline Codes and Subcodes Status 

Initially, discipline codes and subcodes are not loaded. Click the Load Codes/Subcodes link to access the the Washington - Discipline Codes and Subcodes Load information.

On the Washington - Discipline Codes and Subcodes Load information page, select the checkbox and click Submit to allow the nightly process to load the codes and subcodes. The script will load the codes as described in the Appendix.

After the initial load the message ‘Incident Management load is complete’ is displayed in the District Information page, with an option to load codes again.

 [Pref]RepoSchemaUpdate_SR_IM_Ready

 1

 CEDARS P

Race/Ethnicity Codes Status

Click the Load Codes/Subcodes link to access the the Race/Ethnicity Codes Load Information page.

On the Race/Ethnicity Codes Load Information page, select the checkbox and click Submit to allow the nightly/hourly process to load the codes. The script will load the codes as described in the Appendix.

After the initial load the message ‘Load is complete’ is displayed in the District Information page.

[Pref]RepoSchemaUpdate_SR_RC_Ready

1

CEDARS L

CEDARS M

Enable/Disable Grade Level LTK Mapping

This option supports the addition of a Transitional Kindergarten (TK) Grade Level in PowerSchool. Any unused grade level less than zero can be translated to use TK by defining the values using the following page: Start Page, System Management, Localization, Localize PowerSchool, Data tab, for PowerSchool Customer Defined Data, display the relevant grade levels and assign TK as a value.

The grade level values are stored as a numeric value (0, -1, -2, 3, 4, and so on) in the database. If a district configures a grade level -1 as TK, and enables this checkbox, then all reports that use the grade level, will display TK in the report output for the grade level -1. Even if a report does not display the grade level, students corresponding to the -1 grade level will be displayed in the report.

Select the checkbox to enable the use of grade-level values mapped using LTK.

[Prefs]Name = EnableSRLTK

1

All reports

Add Districts of Residence

District Information: Districts of Residence: District of Residence > Edit/New District of Residence

District ID

Enter the district ID.

Note: Add district names and IDs only as needed.

[Gen]Value

[Gen]Cat=districts

N/A

P223

P223H

District Name

Enter the district name.

Note: Add district names and IDs only as needed.

[Gen]Name

[Gen]Cat=districts

N/A

P223

P223H

Define District Schools

District Information: Schools/School Info > Edit/New School

School Name

Enter the school name.

CEDARS “School Name” element.

[Schools]Name

250

CEDARS A06

Refresh Attendance Tracking Data

Transcript

LAP

Unexcused Absences

Screening

SpTimeline

SpPartC

School Abbreviation

Enter the school abbreviation.

[Schools]Abbreviation

N/A

Required Setup

School Address

Enter the school address.

[Schools]SchoolAddress

N/A

Transcript

School City

Enter the school city.

[Schools]SchoolCity

N/A

Transcript

School State/Province

Enter the school state/province.

[Schools]SchoolState

N/A

Transcript

School Postal/Zip Code

Enter the school postal/zip code.

[Schools]SchoolZIP

N/A

Transcript

School Phone Number

Enter the school phone number.

[Schools]SchoolPhone

N/A

Transcript

School Number

Enter the state assigned school number.

Note: Review additional information about CEDARS Location ID and School Code Elements.

School Number is CEDARS “Location ID” element.

[Schools]School_Number

4

CEDARS A04/A05, C05, D03, E05, G03, H05, I05, J05, K05, N05, P05

Attendance

SSID Request

Unexcused Absences

Alternate School Number

Enter the alternate school number.

Note: If the [Schools]School_Number is not the four-digit code assigned to the school by OSPI, then enter the OSPI assigned number as the Alternate School Number.

CEDARS “School Code” element.

[Schools]Alternate_School_Number

4

CEDARS A05

Attendance

SSID Request

Unexcused Absences

Exclude From State Reporting?

Select the checkbox to exclude the school from state reporting. This will exclude the school from specific state reports.

[Schools]State_ExcludeFromReporting

N/A

CEDARS A, B, C, E, F, G, H, I, J, K, L, M, P

Attendance

P223

Transcript

Unexcused Absences

LAP

Screening

SpTimeline

SpPartC

Immunizations

Weapons

SpSuspExpel

Grades

Enter the school grades (lowest - highest).

Note: Grade levels must be in the range -10 to 20.

CEDARS: The Student Grade History File (H) only includes schools with grade levels 9 – 12.

[Schools]Low_Grade

[Schools]High_Grade

N/A

CEDARS B13, H09, J19

Attendance

P223

Unexcused Absences

Immunizations

Other Information

Remote and Necessary

Select the checkbox if this is a small school considered “remote and necessary.” The status is determined by a state Board of Education committee that considers such issues as the distance to the nearest school district and the safety of getting there.

[S_WA_SCH_X]RemoteNecessary

Boolean

P223

High Poverty (Only Schools Which Include Grades K-3)

Select the checkbox if this school is considered “High Poverty” for the P223 report. High Poverty is only considered for grades K-3.

[S_WA_SCH_X]HighPoverty

1

P223

Kindergarten Program Enrollments

Choose the Kindergarten enrollment value for all kindergarten students at the school. This may be overridden on the student information page.

Valid values:

• 1) K1 - Full-day Kindergarten (Program with 900 or more instructional hours annually)

• 2) K2 - Part-day Kindergarten (Program with fewer than 900 instructional hours annually)

[S_WA_SCH_X]KinderEnrollment

1

P223

Kindergarten Program State Funding

Choose the state funding level for all kindergarten students at the school. This may be overridden on the student information page.

Valid values:

• 0) No state Kindergarten Funding (0 FTE)

• 1) Full-day state funded Kindergarten (1.0 FTE)

• 2) Part-day state funded Kindergarten (0.5 FTE)

[S_WA_SCH_X]KinderProg_StateFund

1

P223

Default Course Number for Grade History (CEDARS H)

Enter the default course number to use for the CEDARS Grade History file for grades from this school without an associated course. This overrides the district-level default course number.

[S_WA_SCH_X]TransferCrsNumber

20

CEDARS H07

Civil Rights Data Collection (CRDC)

Use this link to access CRDC data entry for the School. For information about entering data for CRDC, see CRDC District Setup (2020 - 2021).

Skills Center

Select this checkbox to designate this school as a Skills Center.

Note: To ensure skills center FTE is not duplicated, only one school should be designated as a skills center.

[S_WA_SCH_X]SkillsCenter

20

P223

Store Codes to be used in the CEDARS B file

Enter the store codes to be include in the selection criteria of the CEDARS B file report.

Note: Values must be in a comma separated list without spaces, for example: Q1,Q2,Q3,Q4

When the field is blank, the CEDARS B file will default to using S1 and S2.

[S_WA_SCH_X]StoreCodesFor_CEDARS_B_File

60

CEDARS B

Set Additional District Requirement

Navigation: Start Page > District Setup > WA Transcript: Additional District Requirement.

• Click New to add an additional district requirement for WA State Transcript.
  

 Code

Enter a brief abbreviation, which is unique to distinguish this requirement from multiple requirements with the same name.

RequirementCode

N/A

N/A

Name

Enter the name of the requirement. This will be displayed in the transcript.

RequirementName

N/A

N/A

First Year Applicable

Choose the graduation year. Only the graduation classes for the selected year or later is applicable.

FirstYearApplicable

N/A

N/A

Last Year Applicable

Choose the last year applicable for graduation (optional).

Last YearApplicable

N/A

N/A

Applies to these schools

Select the list of schools to which this requirement applies and click Submit.

SchoolList

N/A

N/A

Federal Ethnicity and Race Setup

Enrollment: Federal Ethnicity and Race Settings

Ethnicity Decline to Specify

Leave the checkbox and text box blank. Students and staff may not decline to state their ethnicity.

[Prefs]FRE_AllowDeclineEthnicity

[Prefs]FRE_DeclineEthnicityText

N/A

Not Required

Race Decline to Specify

Leave the checkbox and text box blank. Students and staff may not decline to state their race.

[Prefs]FRE_AllowDeclineRace

[Prefs]FRE_DeclineRaceText

N/A

Not Required

Create Federal Race Categories

Enrollment: Federal Ethnicity and Race Settings > Edit/New Federal Race Categories

Code

Enter the federal race category code.

CEDARS “Race Code” element.

See Appendix Z of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Gen]Name

[Gen]Cat=federalrace

3

CEDARS M05

Description

Enter the federal race category description. The value entered here becomes available for selection on the District Race page, in the Federal Race Category pop-up menu.

[Gen]Value

[Gen]Cat=federalrace

N/A

Not Required

Sort Order

When you click Submit, the Federal Ethnicity and Race Settings page reappears. Enter a sort order for the federal race category.

[Gen]SortOrder

[Gen]Cat=federalrace

1

Not Required

Add District Race Codes

Enrollment: Federal Ethnicity and Race Settings > Edit/New District Race Code

Note: For additional information about set up of District Race Codes see the Appendix.

Code

Enter the district race code.

CEDARS “Race Code” element.

See Appendix Z of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Gen]Name

[Gen]Cat=race

2-3

CEDARS M05

Description

Enter the district race description.

[Gen]ValueT

[Gen]Cat=race

N/A

Not Required

Federal Category

Choose the associated federal race category from the pop-up menu. These values are from the Federal Race Category page.

CEDARS “Race Code” element.

See Appendix Z of the CEDARS Data Manual Appendices document for valid values: http://www.k12.wa.us/CEDARS/Manuals.aspx.

[Gen]Value

[Gen]Cat=race

3-4

CEDARS M05

Alt Race Code

Enter an alternate, equivalent race code.

Note: This field can be used for SIF.

[Gen]Value2

[Gen]Cat=race

N/A

Not Required

Sort Order

When you click Submit, the Federal Ethnicity and Race Settings page reappears. Enter a sort order for the federal race category.

[Gen]SortOrder

[Gen]Cat=race

1

Not Required

Create Scheduling/Reporting Ethnicity Codes

Enrollment: Scheduling/Reporting Ethnicity Codes > Edit/New Ethnicity Code

Code

Enter the race/ethnicity code.

[Gen]Value

[Gen]Cat=ethnicity

N/A

Attendance

Unexcused Absences

Description

Enter a description of the race/ethnicity code.

[Gen]Name

[Gen]Cat=ethnicity

N/A

Attendance

Unexcused Absences

Add Special Programs

Enrollment: Special Programs > Edit/New Special Programs

Program Name

Enter the special program name.

[Gen]Name

[Gen]Cat=specprog

N/A

Not Required

Qualifies as a special education program

Select the checkbox to indicate a special education program.

[Gen]spedindicator

[Gen]Cat=specprog

N/A

Not Required

Tests

Create a Test

Grading: Tests > Edit/New Test

Name

Enter the name of the test.

Note: For the Transcript, it is optional to have a test named “WASL High School”.

WASL High School test name is used by the Transcript to determine whether students meet the various standards.

Without setting up the WASL High School test name, you can indicate whether a student has met the various standards by using the State/Province-WA > State Graduation Requirements page for the student.

[Test]Name

60

Transcript

Type

Choose the type of test from the pop-up menu.

Valid values:

• (1) National

• (2) State

• (3) Local

• (4) District

• (5) School

• (6) Other

Note: The Transcript does not require a specific Type be defined.

[Test]Test_Type

1

Not Required

Description

Enter a description of the test.

[Test]Description

N/A

Not Required

Enter Test Scores

Grading: Tests > Edit Scores link > Edit/New Test Scores

Name

Enter the name of the test score.

Note: Generally, test score names should include the test name. For example, test ACT would include test score ‘ACT Writing’. Now ACT Writing scores will not be confused with ‘SAT Writing’ scores.

“WASL High School” test scores are an exception to the general rule and should not include a test name prefix of “WASL”.

For the Transcript report, for the test of WASL High School, the following test scores are used. The spelling and spacing of the names must match as seen here:

• Reading

• Writing

• Mathematics

• Mathematics Year 1

• Mathematics Year 2

• Science

• History

[TestScore]Name

N/A

Transcript

Sort Order

Enter the sort order for the test score, which determines in what order the test scores display on the student Tests page.

[TestScore]SortOrder

N/A

Not Required

Description

Enter a description of the test score.

[TestScore]Description

N/A

Not Required

Health/Immunization Setup

Washington State Department of Health

INDIVIDUAL VACCINE REQUIREMENTS SUMMARY (School Year 2022-2023)

Enter Vaccination Requirements

Health: Health Setup > Health (Immunizations tab) > Vaccines link > [vaccine name] > Edit/Add Vaccine

Note: For additional information about set up of Vaccine Codes see the Appendix.

Vaccine Name

Enter the vaccine name.

See vaccine codes for valid values.

[HealthVaccine]VaccineName

N/A

Immunizations

Vaccine Code

Enter the vaccine code.

[HealthVaccine]VaccineCode

N/A

Immunizations

State Report Name

Enter the state report name.

[HealthVaccine]StateReportName

N/A

Not Required

State Report Code

Enter the state report code.

[HealthVaccine]StateReportCode

N/A

Immunizations

Number of Doses

Enter the number of doses.

[HealthVaccine]NumberOfDoses

N/A

Immunizations

This vaccine is optional

Do not select this checkbox.

[HealthVaccine]IsMandatory

1

Immunizations

Enter Vaccination Exemption Types

Health: Health Setup > Health (Immunizations tab) > Edit/Add Exemption Types

Note: For additional information about set up of Exemption Types see the Appendix.

Exemption Name

Enter the exemption name.

[HealthImmExempt]ImmunizationExemptionName

Immunizations

Exemption Code

Enter the exemption code.

[HealthImmExempt]ImmunizationExemptionCode

Immunizations

State Report Name

Enter the state report name.

[HealthImmExempt]StateReportName

Not Required

State Report Code

Enter the state report code.

[HealthImmExempt]StateReportCode

Immunizations

Special Education Service Model Codes

State Options: Service Model > Edit/New Special Education Service Model Codes

Service Model Value

Enter the code to represent the service model.

[Gen]value

[Gen]Cat=spedsvcmodel

N/A

Not Required

Special Education Service Model Name

Enter the name of the service model.

[Gen]name

[Gen]Cat=spedsvcmodel

N/A

Not Required

Model Valid for Birth-3 Only

Select the checkbox if the service model is specific to students age 0 through 3.

[Gen]valueli

[Gen]Cat=spedsvcmodel

N/A

P223H

Sort

When you click Submit, the Special Education Service Model Codes page reappears. Enter the display order for the service model.

[Gen]SortOrder

[Gen]Cat=spedsvcmodel

N/A

Not Required

Define P223 Exclusion Reasons

State Options: P223 Exclusion Reasons > Edit/New P223 Exclusion Codes

P223 Exclusion Code

Enter the code to represent the P223 exclusion reason.

[Gen]value

[Gen]Cat=p223excl

N/A

Not Required

P223 Exclusion Reason

Enter the name of the P223 exclusion reason.

[Gen]name

[Gen]Cat=p223excl

N/A

Not Required

Sort

When you click Submit, the P223 Exclusion Codes page reappears. Enter the display order for the exclusion codes.

[Gen]SortOrder

[Gen]Cat=p223excl

N/A

Not Required

Student Contact Adoption Status

State Options: Student Contact Adoption Status > Student Contact Adoption Status

Use PowerSchool SIS Student Contacts for State/Provincial Reporting?

Enable reporting from Student Contacts by selecting Yes or No from the drop down.

No - Do not use Student Contacts

Yes - Use Student Contacts in state reports.

[Prefs]PSSR_StuContact_StateFieldsMigrated

N/A

Not Required

Discipline Incident Letters

Discipline Incident Letters > [Edit/New]

The Discipline Incident Letters page at the District Office is used to create Discipline Letter templates for schools. Different templates can be created for different types of incident actions. For instance, a different letter may be needed for a suspension as opposed to an incident or restraint or isolation.

Letter Title

Enter the title of the letter.

[S_IM_Letter_Setup_S]Title

2000

Discipline Incident Letters

School

Choose the name of the school from which the letter is being sent from the pop-up menu.

[S_IM_Letter_Setup_S]SchoolID

11

Discipline Incident Letters

Incident Type

Choose the type of incident from the pop-up menu.

[S_IM_Letter_Setup_S]IncidentType

11

Discipline Incident Letters

Action Code

Choose the action code the letter is in reference to from the pop-up menu.

[S_IM_Letter_Setup_S]ActionCode

11

Discipline Incident Letters

Action Subcode

Choose the action subcode from the pop-up menu.

Note: The options available for the Action Subcode change based on the Action Code selection.

[S_IM_Letter_Setup_S]ActionSubcode

11

Discipline Incident Letters

Opening Paragraph

Enter the text of the opening paragraph of the letter.

[S_IM_Letter_Setup_S]OpeningParagraph

4000

Discipline Incident Letters

Closing Paragraph

Enter the text of the closing paragraph of the letter.

[S_IM_Letter_Setup_S]ClosingParagraph

4000

Discipline Incident Letters

Signature

Enter the signature for the letter.

[S_IM_Letter_Setup_S]Signature

4000

Discipline Incident Letters

Data Element

Description

[Table]FieldName

Length

Code set

Select the Code set type.

[CODESET]CODETYPE=EntryCode

Code

Enter the entry code.

[CODESET]Code

2

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the entry code description.

[CODESET]Description

N/A

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate

8

Data Element

Description

[Table]FieldName

Length

Code set

Select the Code set type.

[CODESET]CODETYPE=ExitCode

Code

Enter the exit code.

[CODESET]Code

2

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the exit code meaning.

[CODESET]Description

N/A

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate8

8