IUID File Layout

1

Instructional Unit Identifier
(IUID)

10

N

Y

1-10

If available pull from schd_ms_user, if not available here check from schd_course_user, If not available here then can be blank.

OR_IUID_DOWN. IUID

Scheduling > Courses > Course Sections > OR OPTE Information: IUID

Or,

 Scheduling > Courses > Building Courses > OR OPTE Information

 Or,

 Blank

2

District Institution Identifier

10

Y

Y

11-20

Reg_district.
state_code_equiv

OR_IUID_DOWN.DISTRICT_STATE_CODE

Administration > General Setup > District > District: State Equivalency Code In Other section of Preferences panel

3

School Institution Identifier

10

Y

Y

21-30

Reg_building.
state_code_equiv from schd_ms.building

OR_IUID_DOWN.BUILDING_STATE_CODE

Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code

4

Local Master Schedule Identifier

15

N

Y

31 - 45

schd_ms.section_key

OR_IUID_DOWN.SECTION_KEY

Cannot be seen in eSchoolPlus

5

School Section Identifier

15

Y

Y

46 -60

schd_ms.course_section

OR_IUID_DOWN.COURSE_SECTION

Scheduling > Courses > Course Sections > Master Schedule: Course Section

6

School Course Identifier

15

Y

Y

61-75

schd_ms.course

OR_IUID_DOWN.COURSE

Scheduling > Courses > Course Sections > Master Schedule: Course

7

Course Code

6

Y

Y

76 -81

mr_crsequ_det.state_id

OR_IUID_DOWN.COURSE_CODE

Scheduling > Courses > Building Courses > Building Course Catalog: State Course

8

Course Begin Date
Format (MMDDYYYY)

8

Y

Y

82-89

reg_mp_dates.start date

OR_IUID_DOWN.COURSE_START_DATE

Start Date of First Marking Period for Course

9

Course End Date
Format (MMDDYYYY)

8

Y

Y

90-97

reg_mp_dates.end_ date

OR_IUID_DOWN.COURSE_END_DATE

End Date of Last Marking Period for Course

10

Scheduled Instructional
Minutes Count

6

N

Y

98-103

Average (SCHD_TIMETABLE. END_TIME and SCHD_TIMETABLE. START_TIME) if the time duration varies otherwise the period duration

OR_IUID_DOWN.COURSE_MIN_SCHD

The scheduled instructional minutes count is the Timetable value unless an override is entered. The extract uses the calculated Timetable value if there is no override for the course-section.

You can enter the Instructional Minute Override value on the OR OPTE Information page.

Scheduling > Courses > Building Courses > OR Course OPTE Defaults

Scheduling > Courses > Course Sections > OR OPTE Information

11

Distance Learning Flag

1

Y

N

104-104

schd__ms_user.field_value for the field number 16 and screen_number =700

OR_IUID_DOWN.DISTANCE_LEARNING

Scheduling Center>Master Schedule>OR OPTE Information: Distance Learning

12

Alternative Education Setting Flag

1

Y

N

105-105

schd_ms_user.field_value for the field number 7 and screen_number =700

OR_IUID_DOWN.ALT_EDUCATION

Scheduling > Courses > Course Sections > OR OPTE Information: Alternative Education

13

Special Education Setting Flag

20

Y

N

106-106

schd_ms_user.field_value for the field_number = 21 and screen_number = 700

OR_IUID_DOWN.SPECIAL_EDUCATION

Scheduling > Courses > Course Sections > OR OPTE Information: Special Education

14

Low Grade Responsibility Code

2

N

N

107-108

schd_ms_user.screen_number = 700 and schd_ms_user.FIELD_NUMBER = 25

If there is no value, then defaulting to 00

OR_IUID_DOWN.LOW_GRADE

Scheduling > Courses > Course Sections > OR OPTE Information: Low Grade Override

15

High Grade Responsibility Code

2

N

N

109-110

schd_ms_user.screen_number = 700 and schd_ms_user.FIELD_NUMBER = 26

If there is no value, then defaulting to 00

OR_IUID_DOWN.HIGH_GRADE

Scheduling > Courses > Course Sections > OR OPTE Information: High Grade Override

16

Instructional Unit Identifier Filler

19

N

N

111-129

N/A

INST_UNIT_FILLER

N/A