Skip to main content
Skip table of contents

Oregon State Reporting Validation Tables

Menu path: Select Administration from the main menu, select General Setup submenu, select District, and then select Validation Tables. You must select Oregon State Reporting for Applications and <Validation table name> for Validation Table.

You can display any Oregon State Reporting validation table to see a list of all existing codes. The Course Grade and Program Strand tables will be pre-populated by PowerSchool with the State Defined codes.

Table

Description

Career Experience

Used on the OR OPTE page to indicate what type of Career Related Experience a student has had.

Course Grade

This table stores the valid marks for a course. The values in this table are used in the OPTE Submission to translate local marks to State Marks.

Cumulative Enrollment

No longer used

Essential Skills

Used on the OR Essential Skills page.

Federal Placement

Used on the OR Special Education page.

Highly Qualified

Used on the OR OPTE Information page to indicate a teacher's highly-qualified status.

Not Highly Qualified

Used on the OR OPTE Information page to indicate why a teacher is not highly-qualified.

OPTE Withdrawal Code Crosswalk

Because the OPTE Submission has different Withdrawal Code (Year End Status) values than other submissions, you need to translate your local Withdrawal Codes to the OPTE Codes. In the Code field, enter your local Withdrawal Code and enter the OPTE code in the State Code Equiv field. The OPTE Codes are:

  • E - Returning
  • F - Returning Senior
  • A - Graduating
  • D - Left School - Transfer
  • B - Left School - Job
  • C - Left School - Other

Pass Code

Used on the OR OPTE page.

Program Model

Used on the OR LEP page to indicate the Program Model the student is participating in.

Program Strand

The values in this table are used on the OR OPTE Information page on the Course Catalog or Master Schedule.

Program Type

Used for the Cumulative ADM Collection.

Related Services

Used on the OR Special Education page.

Report Period

This table stores the submissions and their start and end dates for the current school year. The start and end dates help control which records are selected for submission to the State. DO NOT use 1/1/1900 as dates for start and end dates in this validation table. You must update the Report Period table each year to contain the correct dates for the current school year.

Serving Agency

Used on the OR Special Education page.

SPED Enroll Type

Used on the OR Special Education page.

SPED Exit Code

Used on the OR Special Education page.

SPED Transition

Used on the OR Special Education page.

Student Leadership

Used on the OR OPTE page to indicate what Student Leadership Organization a student has been involved in.

Subject Code

Used on the OR Assessment page.

Assessment TypeUsed on the OR Assessment page.

Supplemental Services

Used on the OR Special Education page.

Tuition

Used on the OR Demographics page.

Type Code

Used on the OR OPTE page to indicate what type of assessment a student has for the Program Strand.

Withdrawal Category

Used on the OR Early Leavers page and the Entry/Withdrawal page.

Withdrawal Factor

Used on the OR Early Leavers page and the Entry/Withdrawal page.

Withdrawal Modifier

Used on the OR Early Leavers page and the Entry/Withdrawal page.

Work-Based Learning HoursUsed on the OR OPTE page to indicate how many work-based learning hours a student has completed for the CTE program. This will be part of the CTE Student Collection record.
Work-Based Learning TypeUsed on the OR OPTE page to indicate what type of work-based learning experience a student has acquired for the CTE program. This will be part of the CTE Student Collection record.
Industry CredentialsUsed on the OR OPTE page to indicate what type of industry credentials a student has acquired for the CTE program. This will be part of the CTE Student Collection record.
StateTB CIP CodeUsed on the OR OPTE page to indicate what type of CIP Code a student has acquired for the CTE program. This will be part of the CTE Student Collection record.
Disabilities Used on the OR Special Education page and in the Discipline Collection to indicate what type of disability a student has.

Report Period Codes

Report Period

Code

SSID

SS

Cumulative ADM First Period

AM

Cumulative ADM Second Period

SM

Cumulative ADM Third Period

TM

Cumulative ADM Annual ADM

AA

LEP

LE

OPTE

OP

Discipline

DS

Freshman Collection

FR

Kindergarten Readiness

KG

Use the Oregon Department of Education website to get the correct dates for each Reporting Period.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.