Database Schema for Handbook 2021-2022

Back to List
View Source Document for Table 'register'

Register (RG)

[register]

ID Element Name Type Size Values Cycle

Key

RG0010

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

fy Num 2 Table 2,6,7
RG0020

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

2 = October 15th
6 = April 15th
7 = June 15th
cycle Num 2 Table 2,6,7
RG0030

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 2,6,7
RG0040

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

course_num Alpha 6 Appendix I 2,6,7
RG0050

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

section_num Alpha 10 2,6,7
RG0060

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 2,6,7
RG0070

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

uniq_stu_id Alpha 10 ########## 2,6,7
No change Added Modified Deleted

Back to List