Skip to Content
Student Course Enrollment Template 2019-06-13T13:59:14-06:00

Target Table: COURSE_ENROLL

Data Submission Schedule: K5P, 40 Day, 80 Day, 120 Day, End of Year (EOY), and Summer (Optional)

Grain: One record per district / location / school year / course code / section / student / semester (reporting period/snapshot date)

Load Sequences/Dependencies:

  1. Course template required
  2. Student template required

Template Description –  The Student Course Enrollment Template contains information on student enrollment in each course/section combination. The Student Course Enrollment template must be submitted for all students at each reporting period. Be sure to include all students currently enrolled in the class on a given snapshot date (EOY being an exception).  For students who exited courses between reporting periods and grades need to be submitted, include all ongoing, significant course instruction that occurred anytime between the snapshot dates.

School Year 2019-2020 Changes:

  1. No Changes

Delete Options: 

  1. Delete Student Course Enrollment by District, Location, School Year, Effective Date, Course Code, Section Code, and Student Id
  2. Delete Student Course Enrollment by District, School Year, Effective Date, and Student Id

File Name Format:  DDD_COURSE_ENROLL_YYYYMMDDHHMM.fff
File Name Format Example:  001_COURSE_ENROLL_201907071201.csv

Field NumberField NameData Type, Required, CodeValid Values
 1DISTRICT CODECharacter, Required, Key
 2LOCATION CODECharacter, Required, Key
 3SCHOOL YEAR DATEDate, Required, Key
  •  2019-06-30
 4ENROLLMENT PERIOD NUMBERNumber (0 decimals), Required, Key
  • 501 = 40D
  • 502 = 80D
  • 503 = 120D
  • 901 = EOY
  • 902 = K5P
  • 903 = Summer (optional)
  • 906 = Open Year Round
 5EFFECTIVE DATEDate, Required, Key

  • 2018-10-01 = 40D
  • 2018-12-15 = 80D
  • 2019-03-01 = 120D
  • 2019-06-01 = EOY
  • 2019-06-29 = Summer (Optional)
  • 2018-09-01 = K3P
  • 2018-07-15 = Open-Year-Round

  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
  • 2020-06-29 = Summer (Optional)
  • 2019-09-01 = K5P
  • 2019-07-15 = Open-Year-Round

 6ENROLLMENT CODECharacter, Required, Key
  • CE = Course Enrollment
 7STUDENT IDCharacter, Required, Key 9 digit student ID
 10REQUEST SEQUENCENumber ( 0 decimals), Required, Key
  • 0 = zero
13SEMESTER Character, Required, Key
  • 1 = 40D
  • 2 = 80D
  • 3 = 120D
  • 4 = EOY
  • 5 = K5P
  • 6 = Summer (optional)
  • 9 = Open Year Round
14COURSE CODE LONG Character, Required, Key 8 digit course code

SY19 Course Codes

15COURSE DELIVERY MODEL CODE Character, Required, Updateable
  • FF = Face-to-Face
  • HY = Hybrid (Blended)
  • DL = Distance Learning
  • CB = Computer-based
16COURSE CONTENT CODECharacter, Conditionally Required, Updateable
  • APLUS = APlus
  • BYU = BYU
  • EDCONN = EdConnection
  • EDGENU = Edgenuity
  • EDMENT = Edmentum
  • FUELED = Fuel Ed
  • K-12 = K-12 (Including A+ Instructional Materials)
  • ODYSSE = Odysseyware
  • OTHER = Other Distance Learning Provider
  • PROXIM = Proximity
  • BLB = Blended Learning Bureau
18SPECIAL PROGRAM CODE Character, Conditionally Required, Updateable
  • D = Dual Credit Course
  • C = Concurrent Enrollment Course
19ALTERNATE CREDIT COURSE CODE Character, Optional, UpdateableFor use in High School Only.  If this class is offered for alternative credit, enter the 8-digit course number of the course this course is replacing, otherwise leave blank
20SECTION CODE LONG Character, Required, KeyClass section number assigned by school district to identify district classes.
21COURSE INSTRUCTOR SNAPSHOT DATE Date, Required, Updateable

  • 2018-10-01 = 40D
  • 2018-12-15 = 80D
  • 2019-03-01 = 120D
  • 2019-06-01 = EOY
  • 2019-06-29 = Summer (Optional)
  • 2018-09-01 = K3P
  • 2018-07-15 = Open-Year-Round

  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
  • 2020-06-29 = Summer (Optional)
  • 2019-09-01 = K5P
  • 2019-07-15 = Open-Year-Round

TEMPLATE GUIDANCE

  • The Student Course Enrollment Template contains information on student enrollment in each course/section combination. The Student Course Enrollment template must be submitted for all students at each reporting period. Be sure to include all students currently enrolled in the class on a given snapshot date. (EOY being an exception).
  • Hospitalized students (Location Code = 993), homebound students (Location Code = 998), home schooled students (Location Code = 999), and students enrolled in private school but receiving public special education services (Location Code = 997), should not be submitted in this template.
  • Semester, Course Instructor Snapshot Date, Course Code Long and Section Code Long MUST match the corresponding fields in the COURSE INSTRUCTOR Template and COURSE Template for proper HQT results and to connect a student to a teacher for teacher evaluations.
  • Please note that in order for districts to receive funding for instructional materials purchased for Dual Credit Courses, Field #18 must =  D

Question: What is the difference between concurrent enrollment and dual credit?
Answer: If a high school student is taking a course for credit at an institution of higher education but not receiving high school graduation credit at the primary enrollment high school location, the student is considered to be concurrently enrolled. However, if a student is taking a class for credit at an institution of higher education and the class counts for credit toward high school graduation, the student would be considered to be dually enrolled.

Page last updated June 13, 2019