Database Schema for Handbook 2024-2025

Back to List
View Source Document for Table 'calendar'

Calendar (CA)

[calendar]

ID Element Name Type Size Values Cycle

Key
CA0010

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

 fy Num 2 Table 1,2,3,4,5,6,7
CA0020

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

1 = September 30th
2 = October 15th
3 = November 15th
4 = December 15th
5 = February 15th
6 = April 15th
7 = June 15th
 cycle Num 2 Table 1,2,3,4,5,6,7
CA0030

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 1,2,3,4,5,6,7

Calendar – The building calendar for the current school year that includes all dates, quarter and semester designations.
CA0040

Calendar Date - The date from the school calendar.

 cal_date Date 8 MMDDYYYY 1,2,3,4,5,6,7
CA0050

Membership Day - Indicates if the calendar date is included in membership.

 mem_day Alpha 1 Y/N 1,2,3,4,5,6,7
CA0055

Calendar Number - Indicates the calendar day number for the calendar date.

 cal_no Num 3 ### 1,2,3,4,5,6,7
CA0060

Membership Number - Indicates the membership day number for the calendar date.

 mem_no Num 3 ### 1,2,3,4,5,6,7
CA0065

Quarter - Indicates the quarter in which the calendar day is located.

 quarter Num 2 ## 1,2,3,4,5,6,7
CA0070

Semester - Indicates the semester, which the calendar day is located.

 sem Num 1 # 1,2,3,4,5,6,7
CA0080

Day Type - Indicates the reason a calendar date is not included in membership.

9DY -     Act 1220 Exempt Event Days
AMI -     Act 862 Alternative Method of Instruction
DLD -     Digital Learning Day
HOL -     Holiday
INS -     Inservice
NON -     Non- Attendance
PD -     Professional Development
PTC -     Parent/ Teacher Conference
RL -     Remote Learning
SAT -     Saturday
WAV -     Waiver Day
WEA -     Weather
XDY -     Act 1469 Ext Day

 day_typ Alpha 3 ### 1,2,3,4,5,6,7
CA0090

Membership Value - Indicates the membership value for the calendar date.

 member_value Dec 3 #.## 1,2,3,4,5,6,7
CA0100

Instructional Minutes - Indicates the number of instructional minutes for the school day.

 inst_min Num 3 ### 1,2,3,4,5,6,7
No change Added Modified Deleted

Back to List