Skip to Content

Student Course Enrollment Template

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 Number Field Name Data Type, Required, Code Valid Values
 1 DISTRICT CODE Character, Required, Key
 2 LOCATION CODE Character, Required, Key
 3 SCHOOL YEAR DATE Date, Required, Key
  •  2019-06-30
 4 ENROLLMENT PERIOD NUMBER Number (0 decimals), Required, Key
  • 501 = 40D
  • 502 = 80D
  • 503 = 120D
  • 901 = EOY
  • 902 = K5P
  • 903 = Summer (optional)
  • 906 = Open Year Round
 5 EFFECTIVE DATE Date, 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

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

SY19 Course Codes

15 COURSE DELIVERY MODEL CODE  Character, Required, Updateable
  • FF = Face-to-Face
  • HY = Hybrid (Blended)
  • DL = Distance Learning
  • CB = Computer-based
16 COURSE CONTENT CODE Character, 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
18 SPECIAL PROGRAM CODE  Character, Conditionally Required, Updateable
  • D = Dual Credit Course
  • C = Concurrent Enrollment Course
19 ALTERNATE CREDIT COURSE CODE  Character, Optional, Updateable For 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
20 SECTION CODE LONG  Character, Required, Key Class section number assigned by school district to identify district classes.
21 COURSE 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