Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'graduate'

Graduate (GR)

[graduate]

ID Element Name Type Size Values Cycle

Key

GR0010

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

fy Num 2 Table 9
GR0020

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

9 = August 31st
cycle Num 2 Table 9
GR0030

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 9
GR0040

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

General

GR0045

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

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

Student Name

GR0046

First Name - The student's first name.

fname Alpha 20 9
GR0047

Middle Name - The student's middle name.

mname Alpha 15 9
GR0048

Last Name - The student's middle name.

lname Alpha 25 9
GR0050

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
GR0060

Gender - The sexual classification of the student.

M = Male
F = Female
gender Alpha 1 Table 9
GR0065

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

birth_date Date 8 MMDDYYYY 9
GR0070

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
GR0080

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
GR0090

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

age_grad Num 2 9
GR0095

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