Database Schema for Handbook 2024-2025

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 2024-2025 reporting year fy must be = 35

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
GR0100

Diploma Type – To accurately capture diplomas earned through Alternate Pathway or Regular Pathway and to distinguish these from students who exited high school based on receiving a certificate (IEP or local diploma)

AL - Alternate Diploma
C - Certificate
NA - Not Applicable
RG - Regular Diploma

diploma_type Alphanum 1 # 9
GR0101

Pathway Diploma Distinction - Indicates the type of diploma distinction that a student earned for the career pathway in which the student demonstrated readiness.

D01 - Accounting
D02 - Advanced Manufacturing
D03 - Agriculture, Power, Structural and Technical Systems
D04 - Animal Systems
D05 - Automotive Service Technology
D06 - Banking
D07 - Business Finance
D08 - Computer Science-Programming
D09 - Computer Science-Networking
D10 - Construction
D11 - Criminal Justice
D12 - Management
D13 - Nursing Services
D14 - Plant Systems
D15 - Pre-Educator
D16 - Pre-Engineering
D17 - Retail Management
D18 - Welding
D19 - General Bachelor's Degree Preparation
D20 - AP Scholar
D21 - AP Scholar with Honors
D22 - AP Scholar with Distinction
D23 - AP Capstone Distinction
D24 - International Baccalaureate Diploma
D25 - Cambridge AICE Diploma
D26 - Associate Degree
D27 - Youth Apprenticeship Leading to Registered Apprenticeship
D28 - Verified Military Enlistment
 NA - Not Applicable

path_dist Alpha 3 9
No change Added Modified Deleted

Back to List