IUID File (Instructional Unit Identifier)

Contents

Introduction

The Instructional Unit Identifier report generates the IUID collection with the ODE file format. This collection gives ODE the ability to link teachers to students. It includes both the instructional unit and participating educators. The report scans for currently active class sections or for sections active on a date specified at run time. One row is exported for each section. The report can be run at the school level or district-wide.

The Instructional Unit Identifier field for the section is expected to be blank when the report is first submitted to ODE. ODE returns section-level IUID values to the district for data entry or import in PowerSchool.

The Average Daily Minutes Scheduled for the course and the Alternative Education Setting Flag for the section are required to be populated to prevent the following ODE error: “Missing value in a required field for this collection.”

Complete the following data entry in order to prevent the ODE error, “Missing value in a required field for this collection”:

On the Edit Course District Information page, select the course and enter the Average Daily Minutes Scheduled. (Start Page > School Setup > Courses > select course)
On the Edit Section page, select each section that qualifies and select Alternative Education Setting Flag checkbox. (State Page > School Setup > Sections > select course > Edit Section)

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Sections Selection

The report selects records from the [Sections] table based on the following criteria:

The sections active in the date range specified at run-time are included.
The school must not be excluded from state reporting.
The course must not be excluded from state reporting.

Back to Top

Report Input

To generate the IUID File, do the following:

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
File Name	OR_<schoolnumber>_IUID.csv
Destination	The report defaults to the Reporting Queue.
Processing Options	The report defaults to Run Now.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Column #	Data Element	Description	[Table]FieldName	Data Type	Field Length
A	ChkDigitInstrctUnitID	ODE assigned Instructional Unit Identifier (IUID) with a trailing check digit.	[S_OR_SEC_X]InstrctUnitID	int	10
B	DistInstID	ODE Institution Identification number for the ESD or District administering the program or school in which the class being reported is situated. Institution ID numbers can be found at: <http://www.ode.state.or.us/instid/>.	[Prefs]Value [Prefs]Name=DistrictNumber	int	10
C	SchlInstID	ODE Institution Identification number for the program or school where the class being reported is conducted. Institution ID numbers can be found at: <http://www.ode.state.or.us/instid/>.	[Schools]Alternate_School_Number [Schools]School_Number	int	10
D	LcMstrSchdID	Master schedule identifier for local student information systems.	[Sections]ID	Int	10
E	SchlSectID	Identifier that distinguishes the specific instance of a class being reported. This identifier can be any convention used by the institution.	[Sections]Section_Number	varchar	15
F	SchlCrsID	Local identifier, assigned by the district, used to uniquely identify the course.	[Sections]Course_Number	varchar	15
G	CrsCd	National Center for Education Statistics (NCES) or Non-NCES code for the course that is being taught in the location identified by the combination of class Room ID and Class Period.	[Courses]Alt_Course_Number [Courses]Course_Number	varchar	6
H	CrsBeginDtTxt	Date the course started.	[Sections]TermID = [Terms]FirstDay	varchar	8
I	CrsEndDtTxt	Date the course ended.	[Sections]TermID = [Terms]LastDay	varchar	8
J	SchdldInstrctMinCnt	Number of average daily minutes scheduled for the Instructional Unit.	[S_OR_CRS_X]SchdldInstrctMinCnt	int	5
K	OnlineCrsFg	Flag indicating a online course that is taught via the internet or similar virtual network.	[S_OR_SEC_X]OnlineCrsFg [S_OR_SEC_X]OnlineCrsFg	char	1
L	AltEdSettingFg	Flag Indicating the class is taught in an alternative education setting consistent with OAR 581-022-1350 (5).	[S_OR_SEC_X]AltEdSettingFg	char	1
M	SpEdSettingFg	Flag indicating the class is taught in a special education setting where the instruction is specifically designed to the unique needs of students with disabilities.	[S_OR_SEC_X]SpEdSettingFg	char	1
N	LoGrdCd	Code indicating the lowest grade level of content that is being taught in the course.	[S_OR_SEC_X]LoGrdCd [S_OR_CRS_X]LoGrdCd [S_OR_SEC_X]HiGrdCd [S_OR_CRS_X]HiGrdCd [SECTIONS]grade_level	char	2
O	HiGrdCd	Code indicating the highest grade level of content that is being taught in the course.	[S_OR_SEC_X]HiGrdCd [S_OR_CRS_X]HiGrdCd [S_OR_SEC_X]LoGrdCd [S_OR_CRS_X]LoGrdCd [SECTIONS]grade_level	varchar	2
P	IUIDFill	Reserved for future use.	Filler	varchar	20

Back to Top