Class Roster File Layout

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.
marking_period and using start_date

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.
primary_staff_id or schd_ms_staff.staff_id

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.
date_added 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 within schd_stu_crs_dates date_added and 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.
marking_period and using start_date

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

Marking period dates are found here: Administration > Registration Setup > Calendars > Marking Periods, Marking Period Dates p

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.
marking_period and using end_date

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