IUID File Layout
Field No | Data Element Name | Field Length | Req'd | Zero Padded | Field position | eSchoolPlus Table.Column | Download Table.Column | Where in eSchoolPlus? |
---|---|---|---|---|---|---|---|---|
1 | Instructional Unit Identifier | 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. | 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. | 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 | 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 | 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 | 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 |