Class Roster 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 (IUID) | 10 | Y | Y | 1-10 | schd_ms_user.field_value where screen_number = '700' and field_number = '19' | OR_CLASS_ROSTER.IUID | Scheduling > Courses > Course Sections > OR OPTE Information: IUID field |
2 | District Institution Identifier | 10 | Y | Y | 11-20 | reg_district.state_code_equivalent | OR_CLASS_ROSTER.DISTRICT | Administration > General Setup > District > District: State Equivalency Code field |
3 | School Institution Identifier | 10 | Y | Y | 21-30 | reg_building.state_code_equiv where building = schd_ms. Building | OR_CLASS_ROSTER.BUILDING | Administration > System Setup > Building > Building, Preferences panel: State Equivalency Code field |
4 | School Section Identifier | 15 | Y | Y | 31-45 | schd_ms.section_key | OR_CLASS_ROSTER.SECTION_KEY | This field does not display in the eSchoolPlus software. |
5 | School Course Identifier | 15 | Y | Y | 46-60 | schd_ms.course | OR_CLASS_ROSTER.COURSE_ID | Scheduling > Courses > Course Sections > Master Schedule: Course field |
6 | Course Code | 6 | Y | Y | 61-66 | mr_crsequ_det.state_code or schd_ms.nces Note that schd_ms.nces is available only for eSchoolPlus v. 2.4 and above. | OR_CLASS_ROSTER.STATE_COURSE_ID | Administration > Mark Reporting Setup > Calculation Setup > Course Equivalency Definitions: State Course field or, Scheduling > Courses > Course Sections > Master Schedule: NCES Code field |
7 | Course Start Date | 8 | Y | Y | 67-74 | Determined by looking at schd_ms_mp.marking_period, then joining to reg_mp_dates. | OR_CLASS_ROSTER.COURSE_START_DATE | The earliest marking period associated with the course section is found here: Scheduling > Courses > Course Sections > Master Schedule: Session Information section: Marking Periods field on the Session Information panel Marking period dates are found here: Administration > Registration Setup > Calendars > Marking Periods: > Marking Period Dates panel |
8 | Secure Student Identifier (SSID) | 10 | Y | Y | 75-84 | reg_personal.state_report_id | OR_CLASS_ROSTER.STUDENT_SSID | Registration > Entry & Reports > Student Demographic > Personal: SSID field |
9 | District/Local Student Identifier | 10 | N | N | 85-94 | reg.student_id | OR_CLASS_ROSTER.STUDENT_ID | Student Information Bar (displays on all student pages just below the Home icon and Menu button): ID field |
10 | Student Partial Social Security Number | 4 | N | Y | 95-98 | reg_personal.ssn (last 4 digits) | OR_CLASS_ROSTER.STUDENT_SSN | Registration > Entry & Reports > Student Demographic > Personal: Social Security Number field (last 4 digits) |
11 | Student Legal Last Name | 50 | Y | N | 99-148 | reg.last_name | OR_CLASS_ROSTER.STUDENT_LAST_NAME | Registration > Entry & Reports > Student Demographic > Registration: Last Name field |
12 | Student Date of Birth | 8 | Y | Y | 149-156 | reg.birthdate | OR_CLASS_ROSTER.BIRTHDATE | Registration > Entry & Reports > Student Demographic > Registration: Birthdate field |
13 | Student Gender Code | 1 | Y | N | 157-157 | reg.gender | OR_CLASS_ROSTER.GENDER | Registration > Entry & Reports > Student Demographic > Registration: Gender field |
14 | Unique Staff Identifier | 10 | Y | Y | 158-167 | N/A | OR_CLASS_ROSTER.ODEID | Not found in eSchoolPlus. You load USIDs into the download table following the procedure Uploading Staff USIDs Using a File. |
15 | Employer Staff Identifier | 10 | N | N | 168-177 | schd_ms_staff_dates.staff_id or schd_ms_session. | OR_CLASS_ROSTER.STAFF_ID | Scheduling > Courses > Course Sections > Master Schedule, then click Primary Staff or Secondary Staff link: Staff field in the Staff Date Tracking window or, Scheduling > Courses > Course Sections > Master Schedule: Primary Staff or Secondary Staff field |
16 | Teacher Partial Social Security Number | 4 | N | Y | 178-181 | reg_staff.ssn (last four digits) | OR_CLASS_ROSTER.STAFF_SSN | Scheduling > Courses > Resources > Staff: Social Security Number field (last four digits) |
17 | Teacher Legal Last Name | 50 | Y | N | 182-231 | reg_staff.last_name | OR_CLASS_ROSTER.STAFF_LNAME | Scheduling > Courses > Resources > Staff: Last Name field |
18 | Teacher Date of Birth | 8 | Y | Y | 232-239 | reg_staff.birthdate | OR_CLASS_ROSTER.STAFF_BIRTH_DATE | Scheduling > Courses > Resources > Staff: Birthdate field |
19 | Teacher Gender Code | 1 | Y | N | 240-240 | reg_staff.gender | OR_CLASS_ROSTER.STAFF_GENDER | Scheduling > Courses > Resources > Staff: Gender field |
20 | Position Code | 2 | Y | Y | 241-242 | schd_ms_staff_user.field_number = '1' or reg_user_staff where screen_number = '700' and field_number = '1' If no data in either field, default value of '08'. | OR_CLASS_ROSTER.POSITION_CD | Scheduling > Courses > Course Sections > Master Schedule > Primary or Secondary Staff link: Position Code field or, Administration > Registration Setup > Building > Staff > District-Defined panel > OR Staff Information > Position Code field |
21 | Instructional Minutes Count | 6 | N | Y | 243-248 | Average (SCHD_TIMETABLE. END_TIME and SCHD_TIMETABLE. START_TIME) if the time duration varies otherwise the period duration | OR_CLASS_ROSTER.INSTRUCT_MINS | 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 Course Sections OR OPTE Information: Instructional Minute Override |
22 | Student Start Date | 8 | Y | Y | 249-256 | Compare schd_stu_crs_dates. If the student does not have schd_stu_crs_dates data, determine this field by looking at schd_ms_mp.marking_period, then joining to reg_mp_dates. | OR_CLASS_ROSTER.STUDENT_START_DATE` | For schd_stu_crs_dates information: Scheduling > Student Schedules > Student > Schedule Entry , then click appropriate course Description link: Date Added on Date Range Detail panel. For entry/withdrawal information: Registration > Entry & Reports > Student Demographic > Entry/Withdrawal The earliest marking period associated with the course section is found here: Scheduling > Courses > Course Sections > Master Schedule, Session Information panel, Marking Periods field |
23 | Student End Date | 8 | Y | Y | 257-264 | Compare schd_stu_crs_dates.date_dropped to the student's entry_date and withdrawal_date information in reg_entry_with for the school year. The first valid enrollment date is used that also falls on or nearest to schd_stu_crs_dates. date_dropped. If the student does not have schd_stu_crs_dates data, determine this field by looking at schd_ms_mp.marking_period, then joining to reg_mp_dates. | OR_CLASS_ROSTER.STUDENT_END_DATE | For schd_stu_crs_dates information: Scheduling > Student Schedules > Student > Schedule Entry , then click appropriate course Description link: Date Added on Date Range Detail panel. For entry/withdrawal information: Registration > Entry & Reports > Student Demographic > Entry/Withdrawal Marking periods associated with the course section are found here: Scheduling > Courses > Course Sections > Master Schedule, Session Information panel, Marking Periods field Marking period dates are found here: Administration > Registration Setup > Calendars > Marking Periods, Marking Period Dates panel |
24 | Teacher Start Date | 8 | Y | Y | 265-272 | schd_ms_staff_date.start_date or, Determined by looking at schd_ms_mp.marking_period, then joining to reg_mp_dates.marking_period and using start_date | OR_CLASS_ROSTER.STAFF_START_DATE | Scheduling > Courses > Course Sections > Master Schedule, then click Primary Staff or Secondary Staff link: Start Date field Marking periods associated with the course section are found here: Scheduling > Courses > Course Sections > Master Schedule, Session Information panel, Marking Periods field. Marking period dates are found here: Administration > Registration Setup > Calendars > Marking Periods, Marking Period Dates panel |
25 | Teacher End Date | 8 | Y | Y | 273-280 | schd_ms_staff_date.end_date or, Determined by looking at schd_ms_mp.marking_period, then joining to reg_mp_dates.marking_period and using end_date | OR_CLASS_ROSTER.STAFF_END_DATE | Scheduling > Courses > Course Sections > Master Schedule, then click Primary Staff or Secondary Staff link: Start Date field Marking periods associated with the course section are found here: Scheduling > Courses > Course Sections > Master Schedule, Session Information panel, Marking Periods field. Marking period dates are found here: Administration > Registration Setup > Calendars > Marking Periods, Marking Period Dates panel |
26 | Classroom Identifier | 20 | Y | Y | 281-300 | schd_ms_session.room_id | OR_CLASS_ROSTER.CLASS_ROOM_ID | Scheduling > Courses > Course Sections > Master Schedule, Session Information panel: Room field |
27 | Class Period | 20 | Y | Y | 301-320 | schd_ms_session.start_period ? schd_ms_session.end_period (Note that "?" is a separator) | OR_CLASS_ROSTER.CLASS_PERIOD | Scheduling > Courses > Course Sections > Master Schedule, Session Information panel: Periods fields |
28 | Low Grade Responsibility Code | 2 | N | N | 321-322 | schd_ms_user.screen_number = 700 and schd_ms_user.FIELD_NUMBER = 25 If there is no value, then defaulting to 00 | OR_CLASS_ROSTER.LOW_GRADE | Scheduling > Courses > Course Sections > OR OPTE Information: Low Grade Override |
29 | High Grade Responsibility Code | 2 | N | N | 323-324 | schd_ms_user.screen_number = 700 and schd_ms_user.FIELD_NUMBER = 26 If there is no value, then defaulting to 00 | OR_CLASS_ROSTER.HIGH_GRADE | Scheduling > Courses > Course Sections > OR OPTE Information: High Grade Override |
30 | Class Roster Filler | 20 | N | N | 325-344 | Filler | Leave blank | N/A |