Database Schema for Handbook 2025-2026

Back to List
View Source Document for Table 'GoodCauseExemption'

Good Cause Exemption (GC)

[GoodCauseExemption]

ID Element Name Type Size Values Cycle

KEY

GC0010

Fiscal Year - The fiscal year that this reporting represents:
For the 2025-2026 reporting year fy must be = 36

fy Num 2 Table 9
GC0020

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

9 = August 15th
cyle Num 2 Table 9
GC0030

LEA, District/Coop - Local Education Agency, the unique seven-digit number assigned by the ADE to identify individual county, district, and cooperative. 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:

6001000
60 = Pulaski County
01 = Little Rock School District
000 = N/A (zeroes for district)
lea Alpha 7 Appendix C 9
GC0040

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 Alphanum 9 ######### 9

General

GC0050

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

uniq_stu_id Alphanum 10 ########## 9
GC0060

First Name - The student's first name.

fname Alpha 25 9
GC0070

Middle Name - The student's middle name.

mname Alpha 25 9
GC0080

Last Name - The student's middle name.

lname Alpha 40 9
GC0090

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
GC0100

Gender - The sexual classification of the staff person.

M - Male
F - Female
gender Alpha 1 Table 9
GC0110

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

birth_date Date 8 MMDDYYYY 9
GC0120

LEA, District of Residence - The seven-digit district number of residency. Used for determining Act 214 situations where county lines may be crossed to transport students.

6001000
60 - Pulaski County
01 - Little Rock School District
000 - N/A (zeroes for district)

residence_lea Alpha 7 Appendix B 9

Student Status

GC0130

Status, Meal - A student who has limited eligibility for federal assistance or by being disadvantaged may qualify for free or reduced breakfast andor lunch as designated.

1 - Free
2 - Reduced 
3 - Full-price Paid
4 - Free SNAP Direct Certification
5 - Free Medicaid Direct Certification
6 - Reduced Medicaid Direct Certification

meal Num 1 Table 9
GC0140

Status, Special Education - A student has been determined to be eligible for special education under the Individuals with Disabilities Education Act and has an individualized education program (IEP). Does not include students determined handicapped under Section 504 of the Rehabilitation Act of 1973.

sped Alpha 1 Y/N 9
GC0150
Homeless – Identify the type of homeless situation describing the primary nighttime residence.

S - Shelter, transitional housing
(Shelter:  public or private accommodations intended for use by homeless individuals and families.  
Transitional Housing: accommodations for homeless and formerly homeless individuals and families where stay is temporary (not permanent housing) and subsidized fully or nearly so.)

D - Doubled-Up/Sharing Housing
(e.g. living with another family. Doubled-up: sharing the housing of others, whether relatives or friends, due to loss of housing, economic hardship, domestic violence or similar reason.)

HM - Hotels/Motels
(Hotel/Motel: temporary commercial accommodations due to loss of housing, economic hardship or similar reason.)

U - Unsheltered
(e.g. cars, parks, campgrounds,  temporary trailer, or abandoned buildings. Unsheltered: living in cars, trailers, parks, public spaces, abandoned buildings, substandard housing, bus or train stations, or similar settings not designed as a regular sleeping accommodation.)

NA - Not Applicable
homeless_type Alpha 2 Table 9
GC0160

Status, English Learner (EL) The student is an individual whose native language is a language other than English or who comes from an environment where a language other than English had a significant impact on the individual’s level of English language proficiency and is not considered proficient yet in English as measured by an approved English language proficiency assessment.

ltd_english_prof Alpha 1 Y/N 9
GC0170

3rd/4th Grade Promotion - Indicate if the student was retained in 3rd grade or promoted to 4th grade under a good cause exemption under Ark Code Ann.  6-17-429.

R - Retained
P - Promoted
G - Good Cause Exemption
NA - Not Applicable

3_4promotion Alpha 2 Table 9
No change Added Modified Deleted

Back to List