Database Schema for Handbook 2023-2024

Back to List
View Source Document for Table 'student_grade'

Student Grades (SG)


ID Element Name Type Size Values Cycle



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

fy Num 2 Table 7

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

7 = June 15th
cycle Num 2 Table 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 7

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

course_num Alpha 6 Appendix I 7

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

section_num Alpha 15 7

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

course_desc Alpha 15 7

SSN, Student - The nine-digit Social Security number of the student. If a student's SSN cannot be obtained, then the ADE assigned number as required by Arkansas Code Ann. 6-18-208 should be used. This number should remain the same throughout the student's school career.

ssn Alpha 9 7

General - SIS is pulling all courses grades 09 thru 12 and high school credit earning courses for grades 05 thru 08.


State Reporting ID - The unique 10-digit Triand identifier generated for the student by the state.

uniq_stu_id Alpha 10 ########## 7

1st Semester Grade - he academic grade achieved in this course for the first semester.

sem_grade_1 Alpha 3 7

2nd Semester Grade - The academic grade achieved in this course for the second semester.

sem_grade_2 Alpha 3 7

3rd Semester Grade - The academic grade achieved in this course for the third semester.

sem_grade_3 Alpha 3 7

4th Semester Grade - The academic grade achieved in this course for the fourth semester.

sem_grade_4 Alpha 3 7

Course Credit Earned - The credit the student earned for the course.

credit_earned Dec 6,4 ##.#### 7
No change Added Modified Deleted

Back to List