Oregon Dual Language Program Export | PowerSchool SIS Compliance

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

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.

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

Open Dual Language Program Export from one of the menus above.
(Optional) Enter a District Start Date and/or a Program Exit Date.
Under Students to Include, choose The Selected n Students Only or All Students.
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.