Skip to main content
Skip table of contents

Course File Layout

The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Course file.

* = Required for all students

+ = Required only for specified students

Field #

FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name

Positions

NYS or Local Purpose

eSchoolPlus Table.Column

Where in eSchoolPlus?

1

*DISTRICT CODE

(DISTRICT OF RESPONSIBILITY CODE)

1 – 8

NYS Reporting

reg_district.state_code_equiv

Administration > General Setup > District > District: State Equivalency Code

2

*LOCATION CODE

BUILDING OF ENROLLMENT CODE)

9 – 14

NYS Reporting

schd_course.building

Scheduling > Courses > Building Courses > Building Course Catalog

3

*SCHOOL YEAR DATE

15 – 24

NYS Reporting

schd_ms.school_year. Use June 30 of the reported school year. Ex: For 2011-12, use 2012-06-30.

School Year from Master Schedule

4

COURSE CODE

25 – 32


Leave blank – use field #27

N/A

5

COURSE NAME

33 – 62

Local use only

schd_course.description

Scheduling > Courses > Building Courses > Building Course Catalog

6

COURSE DEPARTMENT

63 – 86

Local use only

schd_course.department

Scheduling > Courses > Building Courses > Building Course Catalog

7

SUBJECT AREA CODE

87 – 101

Local use only

schd_course_subj.subject_area

Scheduling > Courses > Building Courses > Building Course Catalog

8

COURSE LENGTH

102 – 104


schd_ms.Duration_Type

Leave blank

Scheduling > Courses > Course Sections > Master Schedule: Duration Type

N/A

9

NUMBER OF CREDITS

105 – 111


schd_ms_session.Credit

Leave blank

Scheduling > Courses > Course Sections > Master Schedule: Credit

N/A

10

NUMBER OF CLASS SECTIONS

112 – 114


Leave blank

N/A

11

HONORS INDICATOR

115 – 115


Leave blank

N/A

12

MINIMUM SEATS

116 – 120


Leave blank

N/A

13

PRIMARY COURSE TYPE CODE

121 – 140


Leave blank

N/A

14

OBSOLETE

141 – 160


Leave blank

N/A

15

COURSE GRADE TYPE CODE

161 – 180


Leave blank

N/A

16

OBSOLETE

181 – 192


Leave blank

N/A

17

NUMBER OF GRADES

193 – 197


Leave blank

N/A

18

COURSE WEIGHT

198 – 202


schd_course.semester_weight

Leave blank

Scheduling > Courses > Building Courses > Building Course Catalog

N/A

19

ADDITIONAL DATA

203 – 217


Leave blank

N/A

20

SPECIAL PROGRAM INDICATOR

218 – 218


Leave blank

N/A

21

COURSE SPECIAL PROGRAM CODE

219 – 221


Leave blank

N/A

22

OBSOLETE

222 – 241


Leave blank

N/A

23

COURSE SHORT NAME

242 – 253


schd_course.description

Leave blank

Scheduling > Courses > Building Courses > Building Course Catalog: Course Name

N/A

24

ALLOWABLE COURSE GENDER

254 – 273


schd_course.gender_restriction

Leave blank

Scheduling > Courses > Building Courses > Building Course Catalog

N/A

25

GPA APPLICABILITY CODE

274 – 276


Leave blank

N/A

26

*SUPPLEMENTARY COURSE DIFFERENTIATOR

277 – 278

NYS Reporting

Default to 'NA'

N/A

27

*COURSE CODE LONG

(LOCAL COURSE CODE)

279 – 290

NYS Reporting

schd_course_user.field_value where screen_number = '2000' and field_number = '5'

or,

schd_course.course

The override comes from Scheduling > Courses > Course Sections > NY Course Information: Override Local Course Number

Otherwise, if there is no override,

Scheduling > Courses > Building Courses > Building Course Catalog

28

COURSE DELIVERY MODEL CODE

291 – 310


Leave blank

N/A

29

*ALTERNATE COURSE CODE

(STATE COURSE CODE)

311 – 322

NYS Reporting

schd_course_user.field_value where screen_number='2000' and field_number='2'

or,

mr_crsequ_det.state_id

Scheduling > Courses > Course Sections > NY Course Information: Override State Course Number

or,

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

30

REQUIREMENTS INDICATOR CODE

323 – 328


Leave blank

N/A

31

COURSE DESCRIPTION

329 – 828


schd_course.description

Leave blank

Scheduling > Courses > Building Courses > Building Course Catalog

N/A

32

DUAL CREDIT INDICATOR

829 – 831


Leave blank

N/A

33

ADVANCED PLACEMENT INDICATOR

832 – 834


Leave blank

N/A

34

CAREER AND TECHNICAL INDICATOR

835 – 837


Leave blank

N/A

35

GIFTED INDICATOR

838 – 840


Leave blank

N/A

36

BILINGUAL INDICATOR

842 – 844


Leave blank

N/A

37

REMEDIAL INDICATOR

845 – 847


Leave blank

N/A

38

BASIC INDICATOR

848 – 850


Leave blank

N/A

39

SPECIAL EDUCATION INDICATOR

851 – 853


Leave blank

N/A

40

INTERNATIONAL BACCALAUREATE INDICATOR

854 – 856


Leave blank

N/A

41

CORE INDICATOR

857 – 859


Leave blank

N/A

42

ELECTIVE INDICATOR

860 – 862


Leave blank

N/A

43

NON TRADITIONAL GENDER CODE

863 – 868


Leave blank

N/A

44

MINIMUM GRADE LEVEL

869 – 893


Leave blank

N/A

45

MAXIMUM GRADE LEVEL

894 – 918


Leave blank

N/A

46

COURSE DESCRIPTION LONG

919 – 1942


schd_course.long_description

Leave blank

Scheduling > Courses > Building Courses > Building Course Catalog

N/A

47

MAXIMUM SEATS

1943 – 1947


Leave blank

N/A

48

COURSE GROUP CODE

1948 – 1967


Leave blank

N/A

49

ALTERNATE COURSE CODE 2

1968 – 1992


Leave blank

N/A

50

ALTERNATE COURSE CODE 3

1993 – 2017


Leave blank

N/A

51

COURSE SESSION TYPE CODE

2018 – 2037


Leave blank

N/A

52

COURSE CREDIT TYPE CODE

2038 – 2057


Leave blank

N/A

53

LAB COMPONENT INDICATOR

2058 – 2060


Leave blank

N/A

54

OPTIMUM NUMBER OF SEATS

2061 – 2065


Leave blank

N/A

55

ADVANCED INDICATOR

2066 – 2068


Leave blank

N/A

56

PRIMARY INSTRUCTION TYPE CODE

2069 – 2088


Leave blank

N/A

57

PRIMARY INSTRUCTION DELIVERY METHOD CODE

2089 – 2108


Leave blank

N/A

58

PRIMARY INSTRUCTION MEDIUM TYPE CODE

2109 – 2128


Leave blank

N/A

59

COURSE LEVEL CODE

2129 – 2148


Leave blank

N/A

60

CATALOG COURSE CODE

2149 – 2178


Leave blank

N/A

61

STATE STANDARDS ALIGNED INDICATOR

2179 – 2181


Leave blank

N/A

62

CURRICULUM FRAMEWORK TYPE CODE

2182 – 2201


Leave blank

N/A

63

END OF COURSE EXAM REQUIRED CODE

2202 – 2221


Leave blank

N/A

64

COURSE SEQUENCE CODE

2222 – 2241


Leave blank

N/A

65

NUMBER OF PARTS

2242 – 2244


Leave blank

N/A

66

ORGANIZATION DEFINING COURSE

2245 – 2344


Leave blank

N/A

67

MINIMUM NUMBER OF CREDITS

2345 – 2352


Leave blank

N/A

68

MAXIMUM NUMBER OF CREDITS

2353 – 2361


Leave blank

N/A

69

GENERAL INDICATOR

2362 – 2364


Leave blank

N/A

70

COLLEGE LEVEL INDICATOR

2365 – 2367


Leave blank

N/A

71

UNTRACKED INDICATOR

2368 – 2370


Leave blank

N/A

72

HS EQUIVALENT INDICATOR

2371 – 2373


Leave blank

N/A

73

CORRESPONDENCE INDICATOR

2374 – 2376


Leave blank

N/A

74

DISTANCE LEARNING INDICATOR

2377 – 2379


Leave blank

N/A

75

GRADUATION CREDIT INDICATOR

2380 – 2382


Leave blank

N/A

76

MAGNET INDICATOR

2383 – 2385


Leave blank

N/A

77

PRE-ADVANCED PLACEMENT INDICATOR

2386 – 2388


Leave blank

N/A

78

PRE-INTERNATIONAL BACCALAUREATE INDICATOR

2380 – 2382


Leave blank

N/A

79

OTHER CHARACTERISTIC INDICATOR

2383 – 2385


Leave blank

N/A

80

NCAA ELIGIBILITY INDICATOR

2386 – 2388


Leave blank

N/A

81

CAREER CLUSTER CODE

2389 – 2408


Leave blank

N/A

82

ABILITY GROUPING INDICATOR

2409 – 2411


Leave blank

N/A

83

PRIMARY FUND SOURCE CODE

2412 – 2435


Leave blank

N/A

84

TIME REQUIRED FOR COMPLETION

2436 – 2440


Leave blank

N/A

85

ADDITIONAL CREDIT TYPE CODE

2441 – 2470


Leave blank

N/A

86

ACADEMIC INDICATOR

2471 - 2473


Leave blank

N/A


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.