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 | 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 |