Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'graduate'

Graduate (GR)


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 9

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

9 = August 31st
cycle Num 2 Table 9

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 9

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

ssn Alpha 9 9



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

uniq_stu_id Alpha 10 ########## 9

Student Name


First Name - The student's first name.

fname Alpha 20 9

Middle Name - The student's middle name.

mname Alpha 15 9

Last Name - The student's middle name.

lname Alpha 25 9

Race - The general racial or ethnic heritage with which the individual most identifies from the following codes:

YNNNNN = Hispanic
NYNNNN = Native American/Alaskan Native
NNYNNN = Asian
NNNYNN = Black/African American
NNNNYN = Native Hawaiian/Pacific Islander
NNNNNY = White

Y in more than one combination will be considered 2 or more races.

race_ethnic Alpha 6 NNNNNN 9

Gender - The sexual classification of the student.

M = Male
F = Female
gender Alpha 1 Table 9

Date, Birth - The student's date of birth.

birth_date Date 8 MMDDYYYY 9

Date, Graduation - The date that the district determines that requirements have been met for graduation. (Must be valid date greater than 0801 of the previous year.)


grad_date Date 8 MMDDYYYY 9

Class Rank - The student's class ranking at the time of graduation based on the number of students in the class.

class_rank Num 3 9

Age, Graduation - he actual age of the student at the time of graduation.

age_grad Num 2 9

Student Data - Enter the appropriate code designating student status at the time of graduation.

RG = Regular Student
SP = Special Education Student

stu_data Alpha 2 Table 9
No change Added Modified Deleted

Back to List