Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'class'

Class (CL)


ID Element Name Type Size Values Cycle



Fiscal Year - The fiscal year that this reporting represents:
For the 2021-2022 reporting year fy must be = 32

fy Num 2 Table 2,6,7

Cycle - The reporting cycle for which the data is submitted:

2 = October 15th
6 = April 15th
7 = June 15th* (*ALE Courses Only)
cycle Num 2 Table 2,6,7

LEA, School -Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, schools, cooperatives, and vocational institutions. The first two digits represent the county, the second two digits represent the district, and the last three digits represent the individual school, for example:

60 = Pulaski County
01 = Little Rock School District
002 = Hall High School

lea Alpha 7 Appendix C 2,6,7

Course Number - The ADE assigned number designated to a course for identification purposes.

course_num Alpha 6 Appendix I 2,6,7

Course Section - The district assigned number given to a unique class of a particular course.

section_num Alpha 10 2,6,7



Course Description - The name given to the course from the Master Schedule.

course_desc Alpha 30 2,6,7

Course Credit - The credit given to the course from the Master Schedule

course_credit Dec 6 ###.## 2,6,7

Digital Learning - If a class is conducted primarily through the utilization of digital learning technology, indicate the type of technology used from the following codes:

CV = Compressed/ Interactive Videdo
WB = Web Based
NA = Not Applicable
digital_learn Alpha 2 Table 2,6,7

Special Education - This course is taught in a special education environment.

spec_edu Alpha 1 Y/N 2,6,7

College Credit - Credit or hours, which can be applied toward an institution of higher education's graduation or degree requirements.

coll_credit Alpha 1 Y/N 2,6,7

Institution - Any of the graduate schools or divisions of a university offering courses and granting degrees in a specific field.

001090 Arkansas State University
001089 Arkansas Tech University
001098 Henderson State University
001107 Southern Arkansas University
001108 University of Arkansas, Fayetteville
001101 University of Arkansas at Little Rock
001109 University of Arkansas for Medical Sciences
001110 University of Arkansas at Fort Smith
001085 University of Arkansas at Monticello
001086 University of Arkansas at Pine Bluff
001092 University of Central Arkansas

Two-Year Colleges
012860 Arkansas Northeastern College
001091 Arkansas State University-Beebe Campus
011949 Arkansas State University-Newport Campus
023482 Arkansas State University-Mid-South
901090 Arkansas State University-Mountain Home Campus
009976 Arkansas State University-Three Rivers
020522 Black River Technical College
022209 Cossatot Community Collge of U of A
012260 East Arkansas Community College
012105 National Park Community College
012261 North Arkansas College
030633 Northwest Arkansas Community College
020870 Ozarka College
001104 Phillips Community College of UA
020753 Pulaski Technical College
020746 South Arkansas Community College
005707 Southeast Arkansas College
007738 Southern Arkansas University Tech Station
020735 University of Arkansas Community College at Batesville
005732 University of Arkansas Community College-Hope
005245 University of Arkansas Community College at Morrilton
021111 U of A Rich Mountain

Private Colleges
001087 Arkansas Baptist College
001093 Central Baptist College
001095 Crowley’s Ridge College
001099 Hendrix College
001097 Harding University
001100 John Brown University
001088 Lyon College
001102 Ouachita Baptist University
001103 Philander Smith College
001094 University of the Ozarks
001106 Williams Baptist College
888888 Other Arkansas Institutions
999999 Out-of-State Institutions

course_inst Alpha 6 Table 2,6,7

SSN, Staff - The nine-digit Social Security number of the staff member that teaches the class.

ssn Alpha 9 ######### 2,6,7

State Reporting ID, Primary Staff - The unique 10-digit Triand identifier generated for the teacher by the state.

uniq_emp_id Alpha 10 2,6,7

Primary Teacher Email - Email of primary teacher for class.

This email is only collected for ADE and DESE sponsored studies and surveys. This email will not be shared with any outside vendors or external agencies.

pri_email Alphanum 40 2,6,7

SSN, Secondary Staff - The nine-digit Social Security number of the secondary staff member (includes co-teachers and inclusions) assigned in addition to the primary teacher for the class.

sec_ssn Alpha 9 ######### 2,6,7

State Reporting ID, Secondary Staff - The unique 10-digit Triand identifier generated for the secondary teacher (includes co-teachers and inclusions) by the state.

sec_uniq_emp_id Alpha 10 2,6,7

Secondary Teacher Email - Email of second teacher for class.

This email is only collected for ADE and DESE sponsored studies and surveys.  This email will not be shared with any outside vendors or external agencies.

sec_email Alphanum 40 2,6,7

Alternative Environment - Indicates the course is taught in an Alternative Learning Environment (ALE) and is held in an ADE approved ALE program..

alt_envir Alpha 1 Y/N 2,6,7

Course Minutes - Indicates the average number of minutes a course meets in a day.

crs_minutes Num 3 2,6,7

Kindergarten Overage Flag - A flag indicating a kindergarten class has more students than the standards allow but are acceptable because there is a teacher aide assigned to the class.

k_overage Alpha 1 Y/N 2,6,7

Digital Learning Program Course - counts towards class size

Y - Count in class size
N - Do NOT Count in class size
dig_course_flag Alpha 1 Y/N 2,6,7

LEA, Out of District - If the class is provided out of district, enter the seven-digit LEA or assigned number of the district, vocational school, or special out of district instructional institution where the out of district class is being taught.

out_district_lea Alpha 7 Appendix E 2,6,7

Marking Period (Active/Inactive) - Any job code active during the October 1 marking period will be flagged with an A for active. Job codes not active for the October 1 marking period will have an "I" for inactive. For the February 15th submission cycle, job codes active during this marking period will be flagged with an "A" for active and job codes not active will have an "I" for inactive.

marking_prd Alpha 1 A/I 2,6,7

Digital Learning Providers (DLP) - If a course is conducted primarily through the utilization of distance learning technology, indicate the organization providing the instruction.

digital_prov Alpha 4 Appendix K 2,6,7

Type of Digital Learning Providers - The type of digital learning provider organization supplying the instruction.

 CN = Content only
 FL  = Full service
 HG = Homegrown
 NO = No 

digital_type Alpha 2 Table 2,6,7

Case ID - The Case ID corresponds to the Applicant ID from Arkansas Educator Licensure System.

case_id Num 10 2,6,7

Licensure Exception - Indicates the reason that a teacher is assigned to a course that he/she is not licensed to teach.  An unlicensed teacher in a core academic area must meet AQT.

 ALP  = Approved Additional Licensure Plan
 AWL  = Act 1240 Approval to Waive Licensure
 CWL  = Charter School Approval to Waive Licensure  
 ETL  = Effective Teacher Licensure
 ETP  = Emergency Teaching Perm
 LTS  = Approved Long-term Substitute
 SOI  = Schools of Innovation
 DLP  = Digital Learning Provider
 NA   = Not Applicable

license_exception Alpha 4 2,6,7

Coding Block 7/8 - Indicates the Computer Science Coding Block for Grades 7 or 8 curriculum is taught as part of this course.

cb_flag Alpha 1 Y/N 2,6,7

Personal Finance - Does this course include the personal finance standards as required in Act 480 of 2017.

person_finance Alpha 1 Y/N 2,6,7

SPED Overage Flag - A flag indicating a SPCED class has more students than the standards allow but are acceptable because there is a teacher aide assigned to the class.

spced_overage Alpha 1 Y/N 2,6,7

Regular Education Self-Contained Flag - A flag indicating a series of classes will add up to more students assigned to one teacher than the standards allow but is acceptable because the class is self-contained and should not count against the 150 class load.

reg_ed_selfcontained Alpha 1 Y/N 2,6,7

Arkansas Activities Association Coaching Certification - A flag indicating an athletics class (For example: Code 999810…) has a teacher not certified (For example:  Licensure code 082,083,085,087,227,228,271,293,8010) but is acceptable because the school district has the Arkansas Activities Association documentation which allows the teacher to be assigned to the class.

aaa_coachcert Alpha 1 Y/N 2,6,7

Pre-AP or Advanced Placement Course Training Expiration Date - Advanced Placement Summer Institute or other approved training expiration date (five years from when the training was obtained) or expiration date as indicated on the additional training plan (three years from when the plan is initially filed). 

This should be required for all course codes that are Pre-AP or AP classes.

ap_lic_exp_date Date 8 MMDDYYYY 2,6,7

Transition Vendor - Indicates which transition vendor is providing employment training and services to high school special education or 504 students participating in the specific transition courses.

1 - Abilities Unlimited Hot Springs
2 - ASN
3 - Boone ILS
4 - Building Bridges Arkansas
5 - Career Development Training Institute
6 - Central Ark Disability Services
7 - Friendship Community Care
8 - Marva
9 - Pathfinders
10 - TEEM Academy
11 - Easter Seals
12 - Access
13 - ACCD
14 - Career Links
15 - Myers-Davis
16 - Polk County
17 - Superior Success
18 - Not Applicable
19 - District

trans_vendor Alpha 2 # 2,6,7
No change Added Modified Deleted

Back to List