PowerSchool SIS Oregon
PowerSchool SIS Oregon
Breadcrumbs

Oregon Dual Language Program Export

Overview

The Dual Language Program Export lists every Student Program Enrollment whose Oregon Program Type is Dual Language. Each record includes the Program Model Type Code and Partner Language values set up on the Program Setup screen.

Use this export to:

  • Review Dual Language program enrollments before you submit the Dual Language File

  • Check that Program Model Type Code and Partner Language are filled in on each student's enrollment

  • Check State Start Dates, District Start Dates and Program Exit Dates

Dual Language Program Export at the district level

From the District Office, you can open the export from either of these menus:

  • Start Page > Data and Reporting > Exports > Dual Language Program Export

  • Start Page > Courses and Programs > Dual Language Program Export

Tip: Run the Dual Language Enrollment Check as well. It finds students whose Dual Language program enrollments don't match their Dual Language class enrollments.


Dual Language Program Export at the school level

Beginning with SR_26.11.1.0, you can run the Dual Language Program Export from a school. When you run the export at the school level, the results include only Dual Language program records for the school selected at the top of the page.

School-level navigation

At a school, open the export from:

  • Start Page > Courses and Programs > Dual Language Program Export

How school and district results differ

Where you run it

Records returned

District Office

Dual Language program records for every school in the district

School

Only Dual Language program records for the school selected at the top of the page

At the school level, users cannot view or export another school's records from this export. The current-school limit applies to student selections, date filters, column filters, sorting, pagination, and both CSV export options.

Run the export at a school

  1. Switch to the school at the top of the page.

  2. Open Dual Language Program Export from the school-level menu.

  3. (Optional) Enter a District Start Date and/or a Program Exit Date.

  4. Under Students to Include, choose one of these options:

    • The Selected n Students Only: Includes only students in the current student selection who also have qualifying Dual Language program records for the selected school.

    • All Students: Includes all students with qualifying Dual Language program records for the selected school.

  5. Click Submit. The results open on the results screen.

Work with school-level results

  • Sort: Click a column heading to sort the results. Date columns sort in date order.

  • Filter: Use the filter on any column to narrow the results. If no records match the filters, a message appears.

  • Page through results: Use the rows-per-page setting and navigation buttons. The record count appears with the table.

  • Export to CSV: Use Export Filtered Records to export every row that matches your filters, including rows on all pages. Use Export All Records to export every returned row, regardless of filters.

Note: At the school level, both CSV options include only records for the current school.

Selection Criteria

A program enrollment is included in the export when all of these are true:

  • Dual Language program: The enrollment is for a special program with the Oregon Program Type Dual Language (Gen.Cat = 'specprog' and Gen.Value = 'DUAL').

  • Current school year: The enrollment's dates overlap the year term of the current school year (Terms.IsYearRec = 1).

  • District Start Date filter (optional): If you enter a date, the export keeps enrollments that exit on or after that date, plus enrollments with no exit date.

  • Program Exit Date filter (optional): If you enter a date, the export keeps enrollments that start on or before that date.

  • Students to Include: The export uses either your current student selection or all students.

If you leave both date filters blank, the export returns every Dual Language enrollment in the current term year. If you enter both dates, it returns enrollments whose program dates overlap the range.

Report Input

Parameter

Description

District Start Date

The start of the date range (MM/DD/YYYY). Keeps programs that are still active on or after this date.

Program Exit Date

The end of the date range (MM/DD/YYYY). Keeps programs that started on or before this date.

Students to Include

Choose one: The Selected n Students Only (your current student selection; click the count link to see the students) or All Students (every student with a qualifying enrollment).

To run the export

  1. Open Dual Language Program Export from one of the menus above.

  2. (Optional) Enter a District Start Date and/or a Program Exit Date.

  3. Under Students to Include, choose The Selected n Students Only or All Students.

  4. Click Submit. The results open on the results screen.

Report Output

#

Column

Description

Table.Field

Format

1

SchoolID

School number on the program enrollment

SPEnrollments.SchoolID

Number

2

Student Number

The student's number. Click it to open the student's page in a new tab.

Students.Student_Number (link uses Students.DCID)

Hyperlink

3

Student Name

The student's name

Students.LastFirst

Last, First

4

Program Name

Name of the Dual Language program

Gen.Name

Text

5

Program Model Type Code

The Dual Language program model. Values: 01 Dual Language, 02 Transitional Bilingual, 03 Other Bilingual.

S_OR_SEN_X.DualLangPrgMdlTypCd

Code

6

Partner Language

The partner language taught in the program

S_OR_SEN_X.PrtnrLangCd

Language code

7

State Start Date

The date the student first entered a Dual Language program, as reported to the state

S_OR_SEN_X.DualLangStateStrtDt

MM/DD/YYYY. Blank if not entered.

8

District Start Date

The date the student entered this program in the district

SPEnrollments.Enter_Date

MM/DD/YYYY

9

Program Exit Date

The date the student left the program

SPEnrollments.Exit_Date

MM/DD/YYYY. Blank if the student is still enrolled.

Validation

  • Student appears in the results: Validate that the program's Oregon Program Type is Dual Language, the enrollment overlaps the current school year and selected date filters, and, when using The Selected n Students Only, the student is included in the current selection.

  • Program Model Type Code and Partner Language are populated: Validate that both values are set on the program in Program Setup. Then open the student's enrollment and save it again so the values are copied over.

  • State Start Date is populated: Validate that a State Start Date is entered on the student's enrollment. The export does not use the District Start Date as a substitute.