Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'student_grade'

Student Grades (SG)

[student_grade]

ID Element Name Type Size Values Cycle

Key

SG0010

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

fy Num 2 Table 7
SG0020

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

7 = June 15th
cycle Num 2 Table 7
SG0030

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:

6001002
60 = Pulaski County
01 = Little Rock School District
002 = Hall High School
lea Alpha 7 Appendix C 7
SG0050

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

course_num Alpha 6 Appendix I 7
SG0075

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

section_num Alpha 15 7
SG0080

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

course_desc Alpha 15 7
SG0100

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.

SG0125

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

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

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

sem_grade_1 Alpha 3 7
SG0175

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

sem_grade_2 Alpha 3 7
SG0200

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

sem_grade_3 Alpha 3 7
SG0225

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

sem_grade_4 Alpha 3 7
SG0230

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