Arkansas Public School Computer Network

Statewide Information System Report Descriptions and Field Mapping Table

Click underlined words in the index to view coding information

Index

Reports Descriptions

RPT000	This report prints a summary of the fields on the District Screen.
RPT012	This report prints data from the District Maintenance Misc Fund Screen.
RPT020	This report lists the general information on a bus.
RPT021	The report lists Fiscal Year End information on accidents.
RPT022	This report lists each bus, including the bus number, capacity, sticker number and other data.
RPT023	This data is used on the Supplemental Transportation section of the Transportation Aid.
RPT040	This report prints the technical contacts for each District.
RPT100	This report prints a summary of the fields on the School Screen.
RPT117	This report list private school information.
RPT300	This report includes students both received from and sent to other districts with a tuition agreement. They are coded as resident or non resident tuition agreement students and have an LEA number on the Entry/Withdrawal screen or Facility name on screen 102 in Student Registration Maintenance. These students will be coded with a Resident Code of T, W, D, P, or S on the Student Registration Entry/Withdrawal screen in Pentamation.
RPT301	This report includes the ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the current quarter only.
RPT302	This report breaks down the ADM, ADA, and ADT by grade.
RPT303	This report includes the average ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the number of quarters completed.
RPT305	This report lists all students’ attendance by detail whether they are counted in the ADM or not.
RPT308	This report lists transportation counts in detail.
RPT333	This report includes active students who are coded with a valid Homeless code.
RPT334	This report calculates a total for the fields indicated on the SIS Student Status screen, for active students only.
RPT337	The report lists by LEA the race/gender counts for pre-school students enrolled in ABC program.
RPT383	Lists students with vision test dates for this school year.
RPT384	This report will list unduplicated counts of students who were screened.
RPT400	This report includes students both received from and sent to other districts with a tuition agreement. They are coded as resident or non-resident tuition agreement students and have an LEA number on the Entry/Withdrawal screen or facility name on screen 102 in Student Registration Maintenance.
RPT401	This report includes the ADE (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the current quarter only.
RPT402	This report breaks down the ADM and ADA by grade.
RPT403	This report includes the average ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the number of quarters completed.
RPT433	This report includes active students who are coded with a valid Homeless code on screen 102.
RPT434	This report calculates a total for the fields indicated on the SIS Student Status screen for active students only.
RPT435	This report calculates student mobility counts for Spring and Fall.
RPT437	This report lists number of students by race/gender enrolled in ABC preschool program by LEA.
RPT438	The report lists the students with parental waivers to the Smart Core curriculum.
RPT439	This report lists LEA number of the consolidated/annexed district the student attended prior to consolidation/annexation.
RPT441	This report lists students by ID and the number of days student are in ALE for the quarter.
RPT465	This report will print a list of students who have had a SSN change in Cycle 5 and that change was indicated onscreen 999 in Student Registration Maintenance.
RPT585	This checks against Detail Expenditure Status reports
RPT600	This report will list the date, time, and evacuation time of your school’s monthly fire drills.
RPT610	This report will list a verification or non-verification of your school’s compliance to the facility inspection by your local fire department as required by Ark. Code Ann. 6-21-106.

RPT000 Return to Index

District General Information

This report lists general district information.

Column	Table	Field	Where to enter data
Superintendent	district_c	admin_name	District Screen
Superintendent E-Mail	district_c	emailsupt_addr	District Screen
Phone	district_c	phone_office	District Screen
Fax	district_c	phone_fax	District Screen
Cell	district_c	cell_area cell_prefix cell_suffix	District Screen
Pager	district_c	pager_area pager_prefix pager_suffix	District Screen
Home	district_c	home_area home_prefix home_suffix	District Screen
E-Mail	district_c	email_addr	District Screen
Mail Address	district_c	mail_addr mail_city mail_state mail_zip	District Screen
Ship Address	district_c	ship_addr ship_city ship_state ship_zip	District Screen
State Reporting Coordinator	district_c	strep_name	District Screen
Test Coordinator	district_c	test_name	District Screen
Bus Inspector	district_c	bus_name	District Screen
AFR Reporting Coordinator	district_c	afrrep_name	District Screen
Treasurer	district_c	treas_name	District Screen
Homeless Liaison	district_c	homeless_name	District Screen
Ale Director	district_c	ale_fname ale_mname[1] ale_lname	District Screen
Address	district_c	alemail_addr alemail_city alemail_state alemail_zip	District Screen
Phone	district_c	alephon_area alephon_prefix alephon_suffix	District Screen
Ext	district_c	alephon_ext	District Screen
Column	Table	Field	District Screen
Assigned Cooperatives	district_c	coop_lea	District Screen
School Board Count	district_c	schbd_count	District Screen
School Choice	district_c	school_choice	District Screen
Bus Safety	district_c	bus_safety	District Screen
Insurance Carrier (Transportation)	district_c	insur_com	District Screen
District Improvement (NCLB)	district_c	dist_imp	District Screen
District Square Miles	district	di_squ_miles	District Screen
District Sub Salary for Professional Dev	district	di_sub_sal	District Screen
Transfer Agreement	district_c	transfer_agreement	District Screen
Number of Schools	district_c	school_count	District Screen
Congressional District	district_c	congress_district	District Screen
Private School	district_c	dist_privsch	District Screen
Employee Health Insurance	district_c	insur_prem	District Screen

RPT012 Return to Index

Report Title=REVENUES FROM FED TAX (MISC FUNDS)

This report lists data from the District Maintenance

Miscellaneous Funds Screen

Column	Table	Field	Where to Enter Data
Wildlife Refuge	district_c	wildlife_refuge	District Maintenance Miscellaneous Funds Screen
Federal Grazing Rights	district_c	fed_graze_rights	District Maintenance Miscellaneous Funds Screen
Revenue in Lieu of Taxes	district_c	pymt_lieu_taxes	District Maintenance Miscellaneous Funds Screen
Severance Tax	district_c	severance_tax	District Maintenance Miscellaneous Funds Screen
Forest Reserve	district_c	forest_reserve	District Maintenance Miscellaneous Funds Screen
Federal Flood Control	district_c	flood_control	District Maintenance Miscellaneous Funds Screen
Federal Mineral Leasing	district_c	mineral_leasing	District Maintenance Miscellaneous Funds Screen
Federal IMPACT Aid	district_c	fed_impaid	District Maintenance Miscellaneous Funds Screen

RPT020 Return to Index

Business Information

This report lists general information on bus.

Column	Table	Field	Where to Enter Data
Permit Number	bus	permit_num	Bus Maint Screen
BUS INSPECTION
State Inspection	bus	state_inspect	Bus Maint Screen
Summer Inspection	bus	mid_year_inspect	Bus Maint Screen
Sticker Number	bus	sticker_num	Bus Maint Screen
Vin Number	bus	vin_num	Bus Maint Screen
BUS DESCRIPTION
Body Make	bus	body_make	Bus Maint Screen
Body Model Year	bus	body_year	Bus Maint Screen
Primary Usage	bus	primary_use	Bus Maint Screen
Capacity	bus	capacity	Bus Maint Screen
Fuel Type	bus	fuel_type	Bus Maint Screen
Primary for Handicapped	bus	prim_handicap	Bus Maint Screen
Wheelchair Lift	bus	wheelchair_lift	Bus Maint Screen
PURCHASE DETAILS
Purchase Method	bus	purch_method	Bus Maint Screen
Purchase Amount	bus	purch_amt	Bus Maint Screen
Date, Purchase	bus	purch_date	Bus Maint Screen
FISCAL YEAR INFORMATION
Daily Route Mileage	bus	route_mileage	FY INFRO Bus Accidents Screen
Bus Damage Amount	bus	bus_damage_amt	FY INFRO Bus Accidents Screen
Destroyed	bus	destroyed	FY INFRO Bus Accidents Screen
Property Damage Amount	bus	prop_damage_amt	FY INFRO Bus Accidents Screen
Out-of-service date	bus	outserv_date	FY INFRO Bus Accidents Screen
Total Accidents	bus	accidents_fy	FY INFRO Bus Accidents Screen
FATALITIES
Students	bus	fatal_student	FY INFRO Bus Accidents Screen
Drivers	bus	fatal_driver	FY INFRO Bus Accidents Screen
Teachers	bus	fatal_teacher	FY INFRO Bus Accidents Screen
Other	bus	fatal_other	FY INFRO Bus Accidents Screen
INJURIES
Students	bus	injury_student	FY INFRO Bus Accidents Screen
Drivers	bus	injury_driver	FY INFRO Bus Accidents Screen
Teachers	bus	injury_teacher	FY INFRO Bus Accidents Screen
Other	bus	injury_other	FY INFRO Bus Accidents Screen

RPT021 Return to Index

Bus Pupil Transportation (PG. 35AFR)

This report list Fiscal Year End information on accidents

Column		Table	Field	Where to enter data
Line No.	FUNCTION 255-OPERATING FUND	No. of VEHICLES
Buses owned by District and Operated Regularly on an Assigned Route:		XXXX	XXXX	Transportation (pg 35 AFR) Report
1)	Large-Over 15 Passenger	busfy
2)	Small-less than 16 Passenger	busfy
3)	Other Transportation Service Vehicles Owned and Operated by the District Including Spare Buses	busfy
4)	Contract Buses (Object 33)	busfy
	Contract Buses (Object 55)	XXXX
5)	New Buses_Large_Over 15 Passenger	busfy
6)	New Buses_Small_Less than 16 Passenger	busfy
7)	Used Buses	busfy
8)	Chassis Only	XXXX
9)	Bus Body Only	XXXX
10)	Total Daily route Mileage of School Buses *	busfy
11)	No. of Non-Public School Pupils Transported at Public School Expense	district_c
SCHOOL BUS ACCIDENTS DURING SCHOOL YEAR
12)	No. Accidents	busfy	tot_acdnt
13)	No. Buses Destroyed	busfy	tot_destroyed
No. Injured
14)	School Children	busfy	tot_stud_inj
15)	Bus Drivers	busfy	tot_driv_inj
16)	Teachers	busfy	tot_tchr_inj
17)	Others	busfy	tot_othr_inj
No. Deaths
18)	School Children	busfy	tot_stud_fatal
19)	Bus Drivers	busfy	tot_driv_fatal
20)	Teachers	busfy	tot_tchr_fatal
21)	Others	busfy	tot_othr_fatal
Approximate Damage
22)	To School Buses	busfy	tot_bus_damage
23)	To Other Property	busfy	tot_prop_damage

RPT022  Return to Index

School Bus Inspection

This report lists each bus, including the bus number, capacity, sticker number and other data. Table – bus, district_c, bus_c.

Column	Table	Field	Where to enter data
Bus #	bus	permit_num	Bus Report Screen
BODY
Make	bus	WHEN body_make = 1 bmake = “AmTran”	Bus Report Screen
		WHEN body_make = 2 bmake = “Ward”
		WHEN body_make = 3 bmake = “BB”
		WHEN body_make = 4 bmake = “Wayne”
		WHEN body_make = 5 bmake = “Carptr”
		WHEN body_make = 6 bmake = “Superi”
		WHEN body_make = 7 bmake = “Thomas”
		WHEN body_make = 8 bmake = “Couche”
		WHEN body_make = 9 bmake = “Collin”
		WHEN body_make = 10 bmake = “Other”
		WHEN body_make = 11 bmake = “Intl”
Model	bus	body_year
CHASSIS
Make			Bus Report Screen
Model
Seating Capacity	bus	capacity
USAGE
Route	bus	WHEN primary_use = ‘1’ prim_use1 = X	Bus Report Screen
Spare	bus	WHEN primary_use = ‘2’ prim_use2 = X
INSPECTION
Pass	bus	WHEN state_inspect = ‘P’ inspect 1 = X	Bus Report Screen
Fail	bus	WHEN state_inspect = ‘F’ inspect2 = X
Sticker #	bus	sticker_num	Bus Report Screen
SUPERINTENDENT’S SUMMARY OF BUSES
Capacity of Buses		89 83 77 71 65 59 53 47 41 35 23 16 TOTAL	Bus Report Screen
Number of Route Buses	bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c	route_89 route_83 route_77 route_71 route_65 route_59 route_53 route_47 route_41 route_35 route_23 (route_15 + route_16) route_tot	Bus Report Screen
Number of Spare Buses	bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c bus_c	spare_89 spare _83 spare _77 spare _71 spare _65 spare _59 spare _53 spare _47 spare _41 spare _35 spare _23 ( spare _15 + spare _16) spare _tot	Bus Report Screen

RPT023  Return to Index

Business Transportation Aid

This report lists data used on the Supplemental Transportation section of the Transportation Aid. Table – district_c, bus_c, supptransp.

Column	Table	Field	Where to enter data
1. List below the number of buses, by capacity, operated on regular routes by this school district five months or more this year. Route buses used to transport physically handicapped students are counted here also DO NOT INCLUDE SPARE BUSES OR ACTIVITY BUSES. This number shall agree with the number of route buses submitted on the MID-YEAR inspection report.
Capacity of Buses	act214_transp	89	Bus Maintenance Menu
		83
		77
		71
		65
		59
		53
		47
		41
		35
		23
		16
		TOTAL
Number of Route Buses	bus_c	route_89	Bus Maintenance Menu
		route_83
		route_77
		route_71
		route_65
		route_59
		route_53
		route_47
		route_41
		route_35
		route_23
		(route_15 + route_16)
		route_tot
2. Resident Sending District only:
a) Number of Act 609 of 1989 students attending a school outside their resident district and the resident district provides partial or full transportation to Act 609 students.	act214_transp	act609_transp	Bus Maintenance Menu
b) Number of Act 214 of 1991 students attending a school outside their resident district and the resident district provides partial or full transportation to Act 214 students.	district_c	act214_transp	Bus Maintenance Menu
3. Handicapped (If you transport physically handicapped students, fill out below):
a) No. of buses used on route primarily for physically handicapped students	bus_c	hndcap_buses	Bus Maintenance Menu
b) No. of buses equipped with a wheelchair lift	bus_c	lift_buses	Bus Maintenance Menu
c) No. of physically handicapped students requiring special transportation and transported on these buses. (IEP shall reflect specialized transportation.)	district_c	sped_transp	Bus Maintenance Menu
4. Supplemental Transportation: NOTE: List all Special Education and Handicapped students you are transporting to approved centers. This includes the Arkansas School for the Blind and/or the Arkansas School for the Deaf in Little Rock.
Sending District	lift_buses	lea	Bus Maintenance Menu
Receiving Center / City	sped_transp	rec_center
# Students Transp	supptransp	stud_transp
Distance One-Way	supptransp	dist_1_way
Type Transp Provided	supptransp	type_transp
5. Number of Route Buses On:
Diesel	bus_c		Bus Maintenance Menu
Propane	bus_c
Gasoline	bus_c
CNG	bus_c
6. a) Arkansas State Board of Education Regulation effective July 1, 1973, states that “All pupils who are transported in a school bus shall be instructed in safe riding practices and shall participate in emergency evacuation procedures at least twice each school year.”
Has this school district complied with the above regulation?		WHEN bus_safety = “Y” safety1 = X
		WHEN bus_safety = “N” safety2 = X

RPT040 Return to Index

Contacts Information

This report lists contact person information.

Column	Table	Field	Where to enter data
Name	contactper	lname fname	Contacts Screen
Work Number	contactper	work_area work_prefix work_suffix	Contacts Screen
Mobile Number	contactper	mobile_area mobile_prefix mobile_suffix	Contacts Screen
Pager Number	contactper	pager_area pager_prefix pager_suffix	Contacts Screen
Home Number	contactper	home_area home_prefix home_suffix	Contacts Screen
Email	contactper	tech_email	Contacts Screen
Coordinator Title	contactper	sdfs_title	Contacts Screen
Name	contactper	sdfs_lname sdfs_fname sdfs_mname	Contacts Screen
Mailing Address	contactper	mail_addr	Contacts Screen
City	contactper	mail_city	Contacts Screen
State	contactper	mail_state	Contacts Screen
Zip	contactper	mail_zip mail_zip4	Contacts Screen
Phone Number	contactper	phone_area phone_prefix phone_suffix	Contacts Screen
Ext	contactper	phone_ext	Contacts Screen
Email	contactper	email_sdfs	Contacts Screen

RPT100 Return to Index

School General Information

This report lists a summary of the fields on the School Screen.

Column	Table	Field
Administrator	school_c	admin_name
Address	school_c	mail_addr mail_city mail_state mail_zip mail_zip4 (optional)
Ship Address	school_c	ship_addr ship_city ship_state ship_zip ship_zip4 (optional)
Phone	school_c	phone_office
Fax	school_c	phone_fax
Email	school_c	prin_email
Web Address	school_c	web_addr
Low Grade Level
High Grade Level
Site Use Code
Staff Development Hours	school_c	staffdev_hous
Volumes	school_c	lib_volumes
NORTH CENTRAL ACCREDITATION – Indicates whether the school participates in the North Central Accreditation Program.	school_c	accred_ncentral
MAGNET SCHOOL – Elementary or secondary school program within the public education system that offers exemplary learning environments or courses that are not available within the regular school curriculum. They are designed to attract students on a voluntary basis from all parts of a school district without reference to the usual attendance zone rules.	school_c	magnet
ALTERNATIVE SCHOOL – Educational program at all levels within or outside the formal education system that provides innovative and flexible instruction, curriculums, grading systems, learning environment, degree requirements, or other alternatives to the ordinary system of instruction.	school_c	alternative
SCHOOL IMPROVEMENT
BLOCK SCHEDULE	school_c	block_schedule
MINUTES PER DAY	school_c	minutes_day
PERIODS PER DAY	xx_a_period_perday	name
IF cycle = 2
OUT OF SCHOOL PROGRAM
Before School – Scheduled academic/tutoring period prior to the beginning of a school day.	school_c	before_sch
After School – Scheduled academic/tutoring period following dismissal of the regular school day.	school_c	after_sch_prg
Weekends – Scheduled academic/tutoring/enrichment time on Saturday or Sunday.	school_c	wk_end_prg
Summer Program – Scheduled academic/tutoring time following or prior to the academic school year.	school_c	sum_sch_prg
SAFE SCHOOLS – Safe schools are those where students , staff members and visitors feel safe and welcome and have the opportunity to learn, teach, work and engage in activities without being threatened intimidated, bullied, harassed, or made the victim of crime.	school_c	safe_sch
IF cycle = 3 or 5 or 6 or 7
Quarter Begin Date End Date Number of Days	school_c school_c school_c	Quarter = 1 qtr1_beg qtr1_end qtr1_days
Quarter Begin Date End Date Number of Days	school_c school_c school_c	Quarter = 2 qtr2_beg qtr2_end qtr2_days
Quarter Begin Date End Date Number of Days	school_c school_c school_c	Quarter = 3 qtr3_beg qtr3_end qtr3_days
Quarter Begin Date End Date Number of Days	school_c school_c school_c	Quarter = 4 qtr4_beg qtr4_end qtr4_days
IF cycle = 4
Service Learning Project	school_c	serv_learn
Service Learning Course	school_c	serv_proj
School_Wide Character Education Program	school_c	sch_wide

RPT117  Return to Index

Private School Report

This report lists private school information.

Table - private_school, xx_a_lea_school

Column	Table	Field	Where to enter data
School Year	sisyear	fy_clc	Private School Maintenance Screen
School Name	private_school	school_name
Administrator Name	private_school	admin_prefix
	private_school	admin_fname
	private_school	admin_mname
	private_school	admin_lname
	private_school	admin_suffix
Private School Address	private_school	mail_addr
	private_school	mail_city
	private_school	mail_state
	private_school	mail_zip
	private_school	mail_zip4
Grade level, Low:	private_school/grade_low
When “P”	grade_low = Pre-School		Private School Maintenance Screen
When “K”	grade_low = Kindergarten
When “01”	grade_low = 1^st Grade
When “02”	grade_low = 2^nd Grade
When “03”	grade_low = 3^rd Grade
When “04”	grade_low = 4^th Grade
When “05”	grade_low = 5^th Grade
When “06”	grade_low = 6^th Grade
When “07”	grade_low = 7^th Grade
When “08”	grade_low = 8^th Grade
When “09”	grade_low = 9^th Grade
When “10”	grade_low = 10^th Grade
When “11”	grade_low = 11^th Grade
When “12”	grade_low = 12^th Grade
Grade level, High:	private_school/grade_high
When “P”	grade_high = Pre-School		Private School Maintenance Screen
When “K”	grade_high = Kindergarten
When “01”	grade_high = 1^st Grade
When “02”	grade_high = 2^nd Grade
When “03”	grade_high = 3^rd Grade
When “04”	grade_high = 4^th Grade
When “05”	grade_high = 5^th Grade
When “06”	grade_high = 6^th Grade
When “07”	grade_high = 7^th Grade
When “08”	grade_high = 8^th Grade
When “09”	grade_high = 9^th Grade
When “10”	grade_high = 10^th Grade
When “11”	grade_high = 11^th Grade
When “12”	grade_high = 12^th Grade
Total Student Enrollment	private_school
Federal Programs Participation
Title I:	private_school		Private School Title 1 Maintenance Screen
Title II:	private_school	part_titleII
Title IV:	private_school	part_titleIV
Title V:	private_school	part_titleVI

RPT300 Return to Index

District Crossover Students Information

This report includes students both received from and sent to other districts with a tuition agreement. They are coded as resident or non resident tuition agreement students and have an LEA number on the Entry/Withdrawal screen or Facility name on screen 102 in Student Registration Maintenance. These students will be coded with a Resident Code of T, W, D, P, or S on the Student Registration Entry/Withdrawal screen in Pentamation.

Column		Table	Field	Where to enter data
	IF sent_rec = ‘R’	distcrsovr_c		Student Registration Entry/Withdrawal screen
NON-RESIDENT STUDENTS RECEIVED FROM OTHER DISTRICTS UNDER TUITION AGREEMENTS
LEA		distcrsovr_c	related_lea	Student Registration Entry/Withdrawal screen
DISTRICT / SCHOOL NAME		distcrsovr_c	related_agency	Student Registration Entry/Withdrawal screen
STUDENT SSN		distcrsovr_c	ssn	Student Registration Entry/Withdrawal screen
	IF sent_rec = ‘S’	distcrsovr_c		Student Registration Entry/Withdrawal screen
RESIDENT STUDENTS SENT TO SPECIAL ED AGENCIES, NON-PUBLIC SCHOOLS OR OTHER DISTRICTS UNDER TUITION AGREEMENTS
LEA		distcrsovr_c	related_lea	Student Registration Entry/Withdrawal screen
AGENCY NAME		distcrsovr_c	related_agency	Student Registration Entry/Withdrawal screen
STUDENT SSN		distcrsovr_c	ssn	Student Registration Entry/Withdrawal screen

RPT301 Return to Index

Quarterly Superintendent’s Attendance

This report includes the ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the current quarter only.

Column	Table	Field	Pulled From Custom Calculate Attendance Totals table in Pentamation
Days Present Transported	distqatt_c	res_tran_attend	“ “
Days Present Non-Transported	distqatt_c	res_ntran_attend	“ “
Days Absent	distqatt_c	res_absent	“ “
ADT	distqatt_c	adt	“ “
ADA	distqatt_c	ada	“ “
ADM	distqatt_c	adm	“ “

RPT302 Return to Index

Quarterly Superintendent’s Attendance by grade

This report includes the ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the current quarter only, by grade.

Column	Table	Field
AVG DAILY MEMBERSHIP
TRANS	distaatt_c	trans_adm
NON-TRANS	distaatt_c	nontrans_adm
TOTAL	distaatt_c	total_adm
AVG DAILY ATTENDANCE
TRANS	distaatt_c	trans_ada
NON-TRANS	distaatt_c	nontrans_ada
TOTAL	distaatt_c	total_ada
CASE for row_text for grade	distaatt_c	grade
WHEN “P”	row_text = 1 PRE-K
WHEN “K”	row_text = 2 KINDERGARTEN
WHEN “EE”	row_text = 3 AND SPECIAL ED
WHEN “01”	row_text = 4 GRADE 1
WHEN “02”	row_text = 5 GRADE 2
WHEN “03”	row_text = 6 GRADE 3
WHEN “04”	row_text = 7 GRADE 4
WHEN “05”	row_text = 8 GRADE 5
WHEN “06”	row_text = 9 GRADE 6
WHEN “SM”	row_text = 11 GRADE & SPEC ED
WHEN “07”	row_text = 12 GRADE 7
WHEN “08”	row_text = 13 GRADE 8
WHEN “09”	row_text = 14 GRADE 9
WHEN “SS”	row_text = 16 GRADE & SPEC ED
WHEN “10”	row_text = 17 GRADE 10
WHEN “11”	row_text = 18 GRADE 11
WHEN “12”	row_text = 19 GRADE 12
WHEN “13”	row_text = 20 GRADE 13
CASE for grp_hdr for grade	distaatt_c	grade
WHEN “EE”	grp_hdr = ELEM NON-GRADED
WHEN “SM”	grp_hdr = MID/JR HIGH NON
WHEN “SS”	grp_hdr = HIGH SCHOOL NON
CASE for grade_range	distaatt_c	grade
Grade = K, EE, 01, 02, 03, 04, 05, 06	grade_range = 0006
Grade = SM, 07, 08, 09	grade_range = 1114
Grade = SS, 10, 11, 12, 13	grade_range = 1620
OTHERWISE	grade_range = 0000
CASE for rpt_text for grade_range
WHEN grade_range = 0006	rpt_text = 10 LINES 2 – 9
WHEN grade_range = 1114	rpt_text = 15 LINES 11 – 14
WHEN grade_range = 1620	rpt_text = 21 LINES 16 – 20
WHEN grade_range = 0000	rpt_text = NULL
IF grade_range = 0006 or 1114, or 1620
AVG DAILY MEMBERSHIP
TRANS	distaatt_c	GROUP SUM(trans_adm)
NON-TRANS	distaatt_c	GROUP SUM(nontrans_adm)
TOTAL	distaatt_c	GROUP SUM(total_adm)
AVG DAILY ATTENDANCE
TRANS	distaatt_c	GROUP SUM(trans_ada)
NON-TRANS	distaatt_c	GROUP SUM(nontrans_ada)
TOTAL	distaatt_c	GROUP SUM(total_ada)
22 LINES 3+11+16 (grade = EE, SM and SS)
AVG DAILY MEMBERSHIP
TRANS	distaatt_c	GROUP SUM(trans_adm) IF grade = EE, SM or SS
NON-TRANS	distaatt_c	GROUP SUM(nontrans_adm) IF grade = EE, SM or SS
TOTAL	distaatt_c	GROUP SUM(total_adm) IF grade = EE, SM or SS
AVG DAILY ATTENDANCE
TRANS	distaatt_c	GROUP SUM(trans_ada) IF grade = EE, SM or SS
NON-TRANS	distaatt_c	GROUP SUM(nontrans_ada) IF grade = EE, SM or SS
TOTAL	distaatt_c	GROUP SUM(total_ada) IF grade = EE, SM or SS
23 LINES 10+15+21 (10 LINES 2-9 + 15 LINES 11-14 + 21 LINES 16-20)
AVG DAILY MEMBERSHIP
TRANS	distaatt_c	GROUP SUM(trans_adm)
NON-TRANS	distaatt_c	GROUP SUM(nontrans_adm)
TOTAL	distaatt_c	GROUP SUM(total_adm)
AVG DAILY ATTENDANCE
TRANS	distaatt_c	GROUP SUM(trans_ada)
NON-TRANS	distaatt_c	GROUP SUM(nontrans_ada)
TOTAL	distaatt_c	GROUP SUM(total_ada)

RPT303 Return to Index

Quarterly Average Superintendent’s Attendance

This report includes the average quarterly superintendent’s attendance.

Column	Table	Field
WHEN cycle = 3	distqa1_c
QUARTER AVERAGE		qtr
Days Present Transported	distqa1_c	trans_att
Days Present Non-Transported	distqa1_c	ntrans_att
Days Absent	distqa1_c	absent
ADT	distqa1_c	qatt_adt
ADA	distqa1_c	qatt_ada
ADM	distqa1_c	qatt_adm
WHEN cycle = 5	distqa2_c
QUARTER AVERAGE		qtr
Days Present Transported	distqa2_c	trans_att
Days Present Non-Transported	distqa2_c	ntrans_att
Days Absent	distqa2_c	absent
ADT	distqa2_c	qatt_adt
ADA	distqa2_c	qatt_ada
ADM	distqa2_c	qatt_adm
WHEN cycle = 6	distqa3_c
QUARTER AVERAGE		qtr
Days Present Transported	distqa3_c	trans_att
Days Present Non-Transported	distqa3_c	ntrans_att
Days Absent	distqa3_c	absent
ADT	distqa3_c	qatt_adt
ADA	distqa3_c	qatt_ada
ADM	distqa3_c	qatt_adm
WHEN cycle = 7	distqa4_c
QUARTER AVERAGE		qtr
Days Present Transported	distqa4_c	trans_att
Days Present Non-Transported	distqa4_c	ntrans_att
Days Absent	distqa4_c	absent
ADT	distqa4_c	qatt_adt
ADA	distqa4_c	qatt_ada
ADM	distqa4_c	qatt_adm

RPT305 Return to Index

District Detail List of Student Attendance

This report list all students’ attendance by detail whether they are they are counted in ADM or not.

Column	Table	Field	Where to enter data
DURING CYCLE = 3	student	cycle
SSN	student	ssn	Student Registration Entry/Withdrawal screen
RACE	student	race	Student Registration Entry/Withdrawal screen
GENDER	student	gender	Student Registration Entry/Withdrawal screen
RES. CODE	student	resident_code	Student Registration Entry/Withdrawal screen
GRADE	student	grade_level	Student Registration Entry/Withdrawal screen
ENTRY CODE	student	entry_code	Student Registration Entry/Withdrawal screen
T/N	student_att	bus	Student Registration Entry/Withdrawal screen
DAYS PRS.	student_att	days_prs_qtr1	Student Registration Entry/Withdrawal screen
DAYS ABS.	student_att	days_abs_qtr1	Student Registration Entry/Withdrawal screen
TOTAL DAYS	student_att	(days_prs_qtr1 + days_abs_qtr1)	Student Registration Entry/Withdrawal screen
TOTAL FOR GRADE LEVEL	student student_att student_att student_att	grade_level GROUP SUM(days_prs_qtr1) GROUP SUM(days_abs_qtr1) GROUP SUM(days_prs_qtr1 + days_abs_qtr1)	Student Registration Entry/Withdrawal screen
TOTAL FOR SCHOOL LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr1) GROUP SUM(days_abs_qtr1) GROUP SUM(days_prs_qtr1 + days_abs_qtr1)	Student Registration Entry/Withdrawal screen
TOTAL FOR DISTRICT LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr1) GROUP SUM(days_abs_qtr1) GROUP SUM(days_prs_qtr1 + days_abs_qtr1)	Student Registration Entry/Withdrawal screen
DURING CYCLE = 5	student	cycle
SSN	student	ssn	Student Registration Entry/Withdrawal screen
RACE	student	race	Student Registration Entry/Withdrawal screen
GENDER	student	gender	Student Registration Entry/Withdrawal screen
RES. CODE	student	resident_code	Student Registration Entry/Withdrawal screen
GRADE	student	grade_level	Student Registration Entry/Withdrawal screen
ENTRY CODE	student	entry_code	Student Registration Entry/Withdrawal screen
T/N	student_att	bus	Student Registration Entry/Withdrawal screen
DAYS PRS.	student_att	days_prs_qtr2	Student Registration Entry/Withdrawal screen
DAYS ABS.	student_att	days_abs_qtr2	Student Registration Entry/Withdrawal screen
TOTAL DAYS	student_att	(days_prs_qtr2 + days_abs_qtr2)	Student Registration Entry/Withdrawal screen
TOTAL FOR GRADE LEVEL	student student_att student_att student_att	grade_level GROUP SUM(days_prs_qtr2) GROUP SUM(days_abs_qtr2) GROUP SUM(days_prs_qtr2 + days_abs_qtr2)	Student Registration Entry/Withdrawal screen
TOTAL FOR SCHOOL LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr2) GROUP SUM(days_abs_qtr2) GROUP SUM(days_prs_qtr2 + days_abs_qtr2)	Student Registration Entry/Withdrawal screen
TOTAL FOR DISTRICT LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr2) GROUP SUM(days_abs_qtr2) GROUP SUM(days_prs_qtr2 + days_abs_qtr2)	Student Registration Entry/Withdrawal screen
DURING CYCLE = 6	student	cycle
SSN	student	ssn	Student Registration Entry/Withdrawal screen
RACE	student	race	Student Registration Entry/Withdrawal screen
GENDER	student	gender	Student Registration Entry/Withdrawal screen
RES. CODE	student	resident_code	Student Registration Entry/Withdrawal screen
GRADE	student	grade_level	Student Registration Entry/Withdrawal screen
ENTRY CODE	student	entry_code	Student Registration Entry/Withdrawal screen
T/N	student_att	bus	Student Registration Entry/Withdrawal screen
DAYS PRS.	student_att	days_prs_qtr3	Student Registration Entry/Withdrawal screen
DAYS ABS.	student_att	days_abs_qtr3	Student Registration Entry/Withdrawal screen
TOTAL DAYS	student_att	(days_prs_qtr3 + days_abs_qtr3)	Student Registration Entry/Withdrawal screen
TOTAL FOR GRADE LEVEL	student student_att student_att student_att	grade_level GROUP SUM(days_prs_qtr3) GROUP SUM(days_abs_qtr3) GROUP SUM(days_prs_qtr3 + days_abs_qtr3)	Student Registration Entry/Withdrawal screen
TOTAL FOR SCHOOL LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr3) GROUP SUM(days_abs_qtr3) GROUP SUM(days_prs_qtr3 + days_abs_qtr3)	Student Registration Entry/Withdrawal screen
TOTAL FOR DISTRICT LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr3) GROUP SUM(days_abs_qtr3) GROUP SUM(days_prs_qtr3 + days_abs_qtr3)	Student Registration Entry/Withdrawal screen
DURING CYCLE = 7	student	cycle
SSN	student	ssn	Student Registration Entry/Withdrawal screen
RACE	student	race	Student Registration Entry/Withdrawal screen
GENDER	student	gender	Student Registration Entry/Withdrawal screen
RES. CODE	student	resident_code	Student Registration Entry/Withdrawal screen
GRADE	student	grade_level	Student Registration Entry/Withdrawal screen
ENTRY CODE	student	entry_code	Student Registration Entry/Withdrawal screen
T/N	student_att	bus	Student Registration Entry/Withdrawal screen
DAYS PRS.	student_att	days_prs_qtr4	Student Registration Entry/Withdrawal screen
DAYS ABS.	student_att	days_abs_qtr4	Student Registration Entry/Withdrawal screen
TOTAL DAYS	student_att	(days_prs_qtr4 + days_abs_qtr4)	Student Registration Entry/Withdrawal screen
TOTAL FOR GRADE LEVEL	student student_att student_att student_att	grade_level GROUP SUM(days_prs_qtr4) GROUP SUM(days_abs_qtr4) GROUP SUM(days_prs_qtr4 + days_abs_qtr4)	Student Registration Entry/Withdrawal screen
TOTAL FOR SCHOOL LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr4) GROUP SUM(days_abs_qtr4) GROUP SUM(days_prs_qtr4 + days_abs_qtr4)	Student Registration Entry/Withdrawal screen
TOTAL FOR DISTRICT LEVEL	student_att student_att student_att student_att	lea GROUP SUM(days_prs_qtr4) GROUP SUM(days_abs_qtr4) GROUP SUM(days_prs_qtr4 + days_abs_qtr4)	Student Registration Entry/Withdrawal screen

RPT308 Return to Index

Transportation Counts

This report lists transportation counts in detail.

Tables – Student_att, district_c

Column	Table	Field	Where to enter data
BUS	School_att	Count distinct ssn for trans_code = B	Student Attendance
DRIVES SELF	School_att	Count distinct ssn	Student Attendance
		for trans_code = D	Student Attendance
PARENT/GUARDIAN	School_att	Count distinct ssn for trans_code =G	Student Attendance
DISTRICT PAID TRANSPORTATION	School_att	Count distinct ssn for trans_code = P	Student Attendance
GRAND TOTAL	COUNT(*)	COUNT(*)	Summed in Report

RPT333 Return to Index

District Homeless Students

This report lists active students who are coded with a valid Homeless code on screen 102.

Column	Table	Field	Where to Enter Data
STUDENT HOMELESS COUNTS
Shelter	diststhomeless_c	shel_ct	Dist Maintenance Menu
Doubled Up	diststhomeless_c	doub_ct	Dist Maintenance Menu
Hotels/Motels	diststhomeless_c	hotel_ct	Dist Maintenance Menu
Unsheltered	diststhomeless_c	unshel_ct	Dist Maintenance Menu
Unaccompanied Youth	diststhomeless_c	unaccmp_ct	Dist Maintenance Menu
Substandard Housing	diststhomeless_c	substan_ct	Dist Maintenance Menu
Other	diststhomeless_c	other_ct	Dist Maintenance Menu
Oct 1st	diststhomeless_c	tot_homeless	Dist Maintenance Menu
Q1	diststhomeless_c	tot_homeless1	Dist Maintenance Menu
Q2	diststhomeless_c	tot_homeless2	Dist Maintenance Menu
Q3	diststhomeless_c	tot_homeless3	Dist Maintenance Menu
Q4	diststhomeless_c	tot_homeless4	Dist Maintenance Menu

RPT334 Return to Index

Student Status Report

This report calculates a total for the fields indicated on the SIS Student Status screen, for active students only.

Column	Table	Field	Where to Enter Data
STUDENT STATUS COUNTS
Gifted/Talented	diststst_c	tot_gt_count	Student Status Screen
Special Education	diststst_c	tot_sped_count	Student Status Screen
Handicapped	diststst_c	tot_handicap_count	Student Status Screen
Migrant	diststst_c	tot_migrant_count	Student Status Screen
Married	diststst_c	tot_married_count	Student Status Screen
Single	diststst_c	tot_single_count	Student Status Screen
Orphans	diststst_c	tot_orphan_count	Student Status Screen
Foster Children	diststst_c	tot_foster_count	Student Status Screen
Limited English Proficiency	diststst_c	tot_lep_count	Student Status Screen
Supplemental Services	diststst_c	tot_supsrv_count	Student Status Screen
Smart Core Waiver	diststst_c	tot_smtcor_count	Student Status Screen
IF cycle = 2
Title I	diststst_c	tot_title1_count	Student Status Screen

RPT337 Return to Index

ABC Preschool Count

The report list, by LEA, the race/gender counts for pre-school students enrolled in ABC program.

Column	Table	Field	Where to Enter Data
BM	distabc_c	bm_count	Student Registration Screen
BF	distabc_c	bf_count	Student Registration Screen
WM	distabc_c	wm_count	Student Registration Screen
WF	distabc_c	wf_count	Student Registration Screen
AM	distabc_c	am_count	Student Registration Screen
AF	distabc_c	af_count	Student Registration Screen
NM	distabc_c	nm_count	Student Registration Screen
NF	distabc_c	nf_count	Student Registration Screen
HM	distabc_c	hm_count	Student Registration Screen
HF	distabc_c	hf_count	Student Registration Screen
TOTAL COUNT	distabc_c	tot_count	Student Registration Screen
GRANDTOTAL COUNT	distabc_c	SUM(tot_count)	Student Registration Screen

RPT383 Return to Index

District Student Vision Listing

This report lists students with vision test dates for current school year.

Column	Table	Field
Name	student	fname lname
SSN / Student Code	medical_vision	ssn / uniq_stu_id
Grade	medical_vision	grade_level
Screen Date	medical_vision	screen_date
Extern Exam	medical_vision	ext_exam
Right Eye	medical_vision	right_eye
Left Eye	medical_vision	left_eye
Fusion	medical_vision	fusion
Lat MB	medical_vision	lat_mb
Vert MB	medical_vision	ver_mb
Plus2 Lens	medical_vision	plus2_len
Refer	medical_vision	referral
Follow Up	medical_vision	follow_up

RPT384 Return to Index

District Student Vision Counts

This report list unduplicated counts of students who were screened for current school year.

Column	Table	Field	Where to Enter Data
Student Screening Information = Screened
Pre-K	medical_vision	screenedpk	Medical Vision Screen
Kind	medical_vision	screenedkind	Medical Vision Screen
1st	medical_vision	screened1	Medical Vision Screen
2nd	medical_vision	screened2	Medical Vision Screen
3rd	medical_vision	screened3	Medical Vision Screen
4th	medical_vision	screened4	Medical Vision Screen
5th	medical_vision	screened5	Medical Vision Screen
6th	medical_vision	screened6	Medical Vision Screen
7th	medical_vision	screened7	Medical Vision Screen
8th	medical_vision	screened8	Medical Vision Screen
9th	medical_vision	screened9	Medical Vision Screen
10th	medical_vision	screened10	Medical Vision Screen
11th	medical_vision	screened11	Medical Vision Screen
12th	medical_vision	screened12	Medical Vision Screen
TOTAL	medical_vision	screenedtotal = (screenedpk + screenedkind+ screened1 + screened2 + screened3 + screened4 + screened5 + screened6 + screened7 + screened8 + screened9 + screened10 + screened11 + screened12)	Medical Vision Screen
Student Screening Information = Rescreened (Where follow-up = ‘T’ it is considered Rescreened)
Pre-K	medical_vision	rescrpk	Medical Vision Screen
Kind	medical_vision	rescrk	Medical Vision Screen
1st	medical_vision	rescr1	Medical Vision Screen
2nd	medical_vision	rescr2	Medical Vision Screen
3rd	medical_vision	rescr3	Medical Vision Screen
4th	medical_vision	rescr4	Medical Vision Screen
5th	medical_vision	rescr5	Medical Vision Screen
6th	medical_vision	rescr6	Medical Vision Screen
7th	medical_vision	rescr7	Medical Vision Screen
8th	medical_vision	rescr8	Medical Vision Screen
9th	medical_vision	rescr9	Medical Vision Screen
10th	medical_vision	rescr10	Medical Vision Screen
11th	medical_vision	rescr11	Medical Vision Screen
12th	medical_vision	rescr12	Medical Vision Screen
TOTAL	medical_vision	rescrtot = ( rescrpk + rescrk + rescr1 + rescr2 + rescr3 + rescr4 + rescr5 + rescr6 + rescr7 + rescr8 + rescr9 + rescr10 + rescr11 + rescr12)	Medical Vision Screen
Student Screening Information = Referred (Where referral = ‘E’, ‘P’, ‘Y’ it is considered Referred)
Pre-K	medical_vision	referpk	Medical Vision Screen
Kind	medical_vision	referk	Medical Vision Screen
1st	medical_vision	refer1	Medical Vision Screen
2nd	medical_vision	refer2	Medical Vision Screen
3rd	medical_vision	refer3	Medical Vision Screen
4th	medical_vision	refer4	Medical Vision Screen
5th	medical_vision	refer5	Medical Vision Screen
6th	medical_vision	refer6	Medical Vision Screen
7th	medical_vision	refer7	Medical Vision Screen
8th	medical_vision	refer8	Medical Vision Screen
9th	medical_vision	refer9	Medical Vision Screen
10th	medical_vision	refer10	Medical Vision Screen
11th	medical_vision	refer11	Medical Vision Screen
12th	medical_vision	refer12	Medical Vision Screen
TOTAL	medical_vision	refertot = ( referpk + referk + refer1 + refer2 + refer3 + refer4 + refer5 + refer6 + refer7 + refer8 + refer9 + refer10 + refer11 + refer12)	Medical Vision Screen
Student Screening Information = Received Examination (Where follow-up = ‘L’, ‘N’, ‘J’ it is considered Received Examination)
Pre-K	medical_vision	recexampk	Medical Vision Screen
Kind	medical_vision	recexamk	Medical Vision Screen
1st	medical_vision	recexam1	Medical Vision Screen
2nd	medical_vision	recexam2	Medical Vision Screen
3rd	medical_vision	recexam3	Medical Vision Screen
4th	medical_vision	recexam4	Medical Vision Screen
5th	medical_vision	recexam5	Medical Vision Screen
6th	medical_vision	recexam6	Medical Vision Screen
7th	medical_vision	recexam7	Medical Vision Screen
8th	medical_vision	recexam8	Medical Vision Screen
9th	medical_vision	recexam9	Medical Vision Screen
10th	medical_vision	recexam10	Medical Vision Screen
11th	medical_vision	recexam11	Medical Vision Screen
12th	medical_vision	recexam12	Medical Vision Screen
TOTAL	medical_vision	recexamtot = ( recexampk + recexamk + recexam1 + recexam2 + recexam3 + recexam4 + recexam5 + recexam6 + recexam7 + recexam8 + recexam9 + recexam10 + recexam11 + recexam12)	Medical Vision Screen
Student Screening Information = Confirmed Difficulty by Professional (Where follow-up = ‘L’ it is considered Confirmed Difficulty by Professional)
Pre-K	medical_vision	cdiffpk	Medical Vision Screen
Kind	medical_vision	cdiffk	Medical Vision Screen
1st	medical_vision	cdiff1	Medical Vision Screen
2nd	medical_vision	cdiff2	Medical Vision Screen
3rd	medical_vision	cdiff3	Medical Vision Screen
4th	medical_vision	cdiff4	Medical Vision Screen
5th	medical_vision	cdiff5	Medical Vision Screen
6th	medical_vision	cdiff6	Medical Vision Screen
7th	medical_vision	cdiff7	Medical Vision Screen
8th	medical_vision	cdiff8	Medical Vision Screen
9th	medical_vision	cdiff9	Medical Vision Screen
10th	medical_vision	cdiff10	Medical Vision Screen
11th	medical_vision	cdiff11	Medical Vision Screen
12th	medical_vision	cdiff12	Medical Vision Screen
TOTAL	medical_vision	cdifftot = ( cdiffpk + cdiffk + cdiff1 + cdiff2 + cdiff3 + cdiff4 + cdiff5 + cdiff6 + cdiff7 + cdiff8 + cdiff9 + cdiff10 + cdiff11 + cdiff12)	Medical Vision Screen
Student Screening Information = Confirmed Normal Eye/Vision by Professional (Where follow-up = ‘N’ it is considered Confirmed Normal Eye/Vision by Professional)
Pre-K	medical_vision	cnormpk	Medical Vision Screen
Kind	medical_vision	cnormk	Medical Vision Screen
1st	medical_vision	cnorm1	Medical Vision Screen
2nd	medical_vision	cnorm2	Medical Vision Screen
3rd	medical_vision	cnorm3	Medical Vision Screen
4th	medical_vision	cnorm4	Medical Vision Screen
5th	medical_vision	cnorm5	Medical Vision Screen
6th	medical_vision	cnorm6	Medical Vision Screen
7th	medical_vision	cnorm7	Medical Vision Screen
8th	medical_vision	cnorm8	Medical Vision Screen
9th	medical_vision	cnorm9	Medical Vision Screen
10th	medical_vision	cnorm10	Medical Vision Screen
11th	medical_vision	cnorm11	Medical Vision Screen
12th	medical_vision	cnorm12	Medical Vision Screen
TOTAL	medical_vision	cnormtot = ( cnormpk + cnormk + cnorm1 + cnorm2 + cnorm3 + cnorm4 + cnorm5 + cnorm6 + cnorm7 + cnorm8 + cnorm9 + cnorm10 + cnorm11 + cnorm12)	Medical Vision Screen

RPT400 Return to Index

School Crossover Students

This report includes students both received from and sent to other districts with a tuition agreement. They are coded as resident or non-resident tuition agreement students and have an LEA number on the Entry/Withdrawal screen or facility name on screen 102 in Student Registration Maintenance.

Column	Table	Field	Where to Enter Data
IF schcrsovr_c.sent_rec = ‘R’
NON-RESIDENT STUDENTS RECEIVED FROM OTHER DISTRICTS UNDER TUITION AGREEMENTS
LEA	schcrsovr_c	related_lea	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance
DISTRICT / SCHOOL NAME	schcrsovr_c	related_agency	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance
STUDENT SSN	schcrsovr_c	ssn	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance
IF schcrsovr_c.sent_rec = ‘S’
RESIDENT STUDENTS SENT TO SPECIAL ED AGENCIES, NON-PUBLIC SCHOOLS OR OTHER DISTRICTS UNDER TUITION AGREEMENTS
LEA	schcrsovr_c	related_lea	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance
AGENCY NAME	schcrsovr_c	related_agency	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance
STUDENT SSN	schcrsovr_c	ssn	Entry/Withdrawal screen; Facility name on screen 102 in Student Registration Maintenance

RPT401 Return to Index

School Quarterly Superintendent’s Attendance

This report includes the ADE (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the current quarter only.

Column	Table	Field	Where to Enter Data
Days In Qtr	school_c		Entered during Student Attendance build.
Days Present Transported	schqatt_c	tran_attend	Entered during Student Attendance build
Days Present Non-Transported	schqatt_c	ntran_attend	Entered during Student Attendance build
Days Absent	schqatt_c	absent	Entered during Student Attendance build
ADT 2/1	schqatt_c	adt	Entered during Student Attendance build
ADA 2+3/1	schqatt_c	ada	Entered during Student Attendance build
ADM 2+3+4/1	schqatt_c	adm	Entered during Student Attendance build

RPT402 Return to Index

School Superintendent’s Attendance by Grade

This report breaks down the ADA (Average Daily Attendance), and the ADM (Average Daily Membership) by grade level.

Column	Table	Field	Where to Enter Data
Days In Qtr	school_c		Entered during Student Attendance build.
Days Present Transported	schqatt_c	tran_attend	Entered during Student Attendance build
Days Present Non-Transported	schqatt_c	ntran_attend	Entered during Student Attendance build
Days Absent	schqatt_c	absent	Entered during Student Attendance build
ADT 2/1	schqatt_c	adt	Entered during Student Attendance build
ADA 2+3/1	schqatt_c	ada	Entered during Student Attendance build
ADM 2+3+4/1	schqatt_c	adm	Entered during Student Attendance build

RPT403 Return to Index

School Qtly Averages Superintendent’s Attendance

This report includes the average ADT (Average Daily Transported), ADA (Average Daily Attendance), and the ADM (Average Daily Membership) for the number of quarters completed.

Column	Table	Field
WHEN cycle = 3, qtr = 1
Days in Qtr		qtr
Days Present Transported		trans_att = trans_att + days_prs_qtr1
Days Present Non-Transported		ntrans_att = ntrans_att + days_prs_qtr1
Days Absent		absent = absent + days_abs_qtr1
ADT		qatt_adt = trans_att / days
ADA		qatt_ada = (trans_att + ntrans_att) / days
ADM		qatt_adm = (trans_att + ntrans_att + absent) / days
WHEN cycle = 5, qtr = 2
Days in Qtr		qtr
Days Present Transported		trans_att = trans_att + days_prs_qtr2
Days Present Non-Transported		ntrans_att = ntrans_att + days_prs_qtr2
Days Absent		absent = absent + days_abs_qtr2
ADT		qatt_adt = trans_att / days
ADA		qatt_ada = (trans_att + ntrans_att) / days
ADM		qatt_adm = (trans_att + ntrans_att + absent) / days
WHEN cycle = 6, qtr = 3
Days in Qtr		qtr
Days Present Transported		trans_att = trans_att + days_prs_qtr3
Days Present Non-Transported		ntrans_att = ntrans_att + days_prs_qtr3
Days Absent		absent = absent + days_abs_qtr3
ADT		qatt_adt = trans_att / days
ADA		qatt_ada = (trans_att + ntrans_att) / days
ADM		qatt_adm = (trans_att + ntrans_att + absent) / days
WHEN cycle = 7, qtr = 4
Days in Qtr		qtr
Days Present Transported		trans_att = trans_att + days_prs_qtr4
Days Present Non-Transported		ntrans_att = ntrans_att + days_prs_qtr4
Days Absent		absent = absent + days_abs_qtr4
ADT		qatt_adt = trans_att / days
ADA		qatt_ada = (trans_att + ntrans_att) / days
ADM		qatt_adm = (trans_att + ntrans_att + absent) / days
QUARTER AVERAGE
Days in Qtr		totdays = GROUP SUM(days)
Days Present Transported		tottdays = GROUP SUM(trans_att)
Days Present Non-Transported		totndays = GROUP SUM(ntrans_att)
Days Absent		totadays = GROUP SUM(absent)
ADT		totavg_adt = (tottdays / totdays)
ADA		totavg_ada = (tottdays + totndays) / totdays
ADM		totavg_adm = (tottdays + totndays + totadays) / totdays

RPT433 Return to Index

School Homeless Student

This report lists active student who are coded with a valid Homeless code on screen 102.

Column	Table	Field	Where to Enter Data
STUDENT HOMELESS COUNTS
Shelter	stdhomeless_c	shel_ct	Screen 102
Doubled_Up	stdhomeless_c	doub_ct	Screen 102
Hotels/Motels	stdhomeless_c	hotel_ct	Screen 102
Unsheltered	stdhomeless_c	unshel_ct	Screen 102
Unaccompanied Youth	stdhomeless_c	unaccmp_ct	Screen 102
Substandard Housing	stdhomeless_c	substan_ct	Screen 102
Other	stdhomeless_c	other_ct	Screen 102
Oct 1st	stdhomeless_c	tot_homeless	Screen 102
Q1	stdhomeless_c	tot_homeless1	Screen 102
Q2	stdhomeless_c	tot_homeless2	Screen 102
Q3	stdhomeless_c	tot_homeless3	Screen 102
Q4	stdhomeless_c	tot_homeless4	Screen 102

RPT434 Return to Index

School Student Status Report

This report calculates a total for the fields indicated on the SIS Student Status screen for active students only.

Column	Table	Field	Where to Enter Data
STUDENT STATUS COUNTS
Gifted/Talented	stdstat_c	tot_gt_count	Student Status Screen
Special Education	stdstat_c	tot_sped_count	Student Status Screen
Handicapped	stdstat_c	tot_handicap_count	Student Status Screen
Migrant	stdstat_c	tot_migrant_count	Student Status Screen
Married	stdstat_c	tot_married_count	Student Status Screen
Single	stdstat_c	tot_single_count	Student Status Screen
Orphans	stdstat_c	tot_orphan_count	Student Status Screen
Foster Children	stdstat_c	tot_foster_count	Student Status Screen
Limited English Proficiency	stdstat_c	tot_lep_count	Student Status Screen
Supplemental Services	stdstat_c	supp_srvs	Student Status Screen
Smart Core Waiver	stdstat_c	smart_core	Student Status Screen
Consolidated LEA	student	consol_lea	Student Status Screen
Displaced District	student	displace_state	Student Status Screen
Displaced State	student	displace_dist	Student Status Screen
Title I	stdstat_c	tot_title1_count	Student Status Screen

RPT435 Return to Index

School Student Mobility

This report calculates student mobility counts for Spring and Fall.

Table - stdmobility_c, school_c, district_c

Column	Table	Field	Where to enter data
STUDENT MOBILITY COUNTS:
Spring (grades 1 – 12 only):	stdmobility_c	spg_count	Student Demographics Entry/ Withdrawal Screen
Fall (grades 2 – 12 only):	stdmobility_c	fall_count

RPT437 Return to Index

School ABC Preschool Count

This report list, by race/gender, the number of students enrolled in ABC preschool program by LEA.

Column	Table	Field	Where to Enter Data
BM	schabc_c	bm_count	Student Registration Screen
BF	schabc_c	bf_count	Student Registration Screen
WM	schabc_c	wm_count	Student Registration Screen
WF	schabc_c	wf_count	Student Registration Screen
AM	schabc_c	am_count	Student Registration Screen
AF	schabc_c	af_count	Student Registration Screen
NM	schabc_c	nm_count	Student Registration Screen
NF	schabc_c	nf_count	Student Registration Screen
HM	schabc_c	hm_count	Student Registration Screen
HF	schabc_c	hf_count	Student Registration Screen
TOTAL COUNT	schabc_c	p_counter	Student Registration Screen
GRANDTOTAL COUNT	schabc_c	SUM(tot_count)	Student Registration Screen

RPT438 Return to Index

Smart Core Waiver Report

The report lists the students with parental waivers to the Smart Core curriculum.

Column	Table	Field	Where to Enter Data
SSN	student	ssn	Student Registration Screen
First Name	student	fname	Student Registration Screen
Last Name	student	lname	Student Registration Screen
Student ID	student	uniq_stu_id	Student Registration Screen
Grade	student	grade_level	Student Registration Screen
TOTAL	student	g_count	Student Registration Screen

RPT439 Return to Index

Consolidated LEA Report

This report lists LEA number of the consolidated/annexed district the student attended prior to consolidation/annexation.

Column	Table	Field	Where to Enter Data
SSN	student	ssn	Student Registration Screen
First Name	student	fname	Student Registration Screen
Last Name	student	lname	Student Registration Screen
Student ID	student	uniq_stu_id	Student Registration Screen
Grade	student	grade_level	Student Registration Screen
TOTAL	student	g_count	Student Registration Screen

RPT441 Return to Index

ALE DAYS

This report lists by student ID, the number of days students are in ALE for the quarter.

Column	Table	Field	Where to Enter Data
SSN	aledays	ssn
QTR1	aledays	qtr1_days	QUARTER CALENDAR Screen
QTR2	aledays	qtr2_days	QUARTER CALENDAR Screen
QTR3	aledays	qtr3_days	QUARTER CALENDAR Screen
QTR4	aledays	qtr4_days	QUARTER CALENDAR Screen
TOTAL
QTR1	aledays	GROUP SUM(qtr1_days)	QUARTER CALENDAR Screen
QTR2	aledays	GROUP SUM(qtr2_days)	QUARTER CALENDAR Screen
QTR3	aledays	GROUP SUM(qtr3_days)	QUARTER CALENDAR Screen
QTR4	aledays	GROUP SUM(qtr4_days)	QUARTER CALENDAR Screen

RPT465 Return to Index

School Student ID Change

This report list students who have had a SSN change in Cycle 5 and that change was indicated on screen 999/Student Registration Maintenance.

Column	Table	Field	Where to Enter Data
Change To SSN Or ID Number	stidchg	change_to_id	Student Registration Screen 999
Change From SSN Or ID Number	stidchg	change_from_id	Student Registration Screen 999
Date Of Change	stidchg	date using “mm/dd/yyyy”	Student Registration Screen 999

RPT585 Return to Index

Finance Special Education

This report checks against Detail Expenditure Status reports.

Column	Table	Field	Where to Enter Data
Fund	financesped	fund	Finance Plus
SOF	financesped	emp_sof	Finance Plus
Function	financesped	emp_func	Finance Plus
Location	financesped	emp_location	Finance Plus
Code	financesped	proj_code	Finance Plus
Account	financesped	emp_object	Finance Plus
IF cycle = 1
AMT EXP (sisyear.prev_year[3,4])	financesped	amt_exp	Finance Plus
AMT BUD (sisyear.cur_year[3,4])	financesped	amt_bud	Finance Plus
ELSE
AMT EXP (sisyear.cur_year[3,4])	financesped	amt_exp	Finance Plus
AMT BUD (sisyear.cur_year[3,4])	financesped	amt_bud	Finance Plus
SUBTOTALS
AMT EXP	financesped	GROUP SUM(amt_exp)	Finance Plus
AMT BUD	financesped	GROUP SUM(amt_bud)	Finance Plus
GRAND TOTALS
AMT EXP	financesped	SUM(amt_exp)	Finance Plus
AMT BUD	financesped	SUM(amt_bud)	Finance Plus

RPT600 Return to Index

School Tri-Annual Fire Drill

This report lists the date, time, and evacuation time of your school’s monthly fire drills.

Column	Table	Field			Where to Enter Data
IF cycle = 1
Cycle 1 – Due September 15
1. Is there a School Fire Marshal Program currently in operation?	school_c	firedr_marshpgm		Y, safety1 = “X” N, safety2 = “X”	Tri-Annual Firedrill Screen
2. Is an adequate evacuation plan with a diagram posted inside each classroom?	school_c	firedr_evplan		Y, evac1 = “X” N, evac2 = “X”	Tri-Annual Firedrill Screen
3. Are all buildings checked for hazards before being locked at the end of the day and at night after activities?	school_c	firedr_blgck		Y, bldg1 = “X” N, bldg2 = “X”	Tri-Annual Firedrill Screen
Please report below the results from your fire drill:
Date of Fire Drill	firedrill_c		firedr_date		Tri-Annual Firedrill Screen
Time of Fire Drill	firedrill_c		firedr_hour, firedr_min, firedr_ampm		Tri-Annual Firedrill Screen
Evacuation Time	firedrill_c		firedr_evmin, firedr_evsec		Tri-Annual Firedrill Screen
IF cycle = 5
Cycle 5 – Due February 15
Please report below the results from your September (if not reported previously), October, November, December, January and February (if conducted before 15th ) fire drills.
Date of Fire Drill	firedrill_c		firedr_date		Tri-Annual Firedrill Screen
Time of Fire Drill	firedrill_c		firedr_hour, firedr_min, firedr_ampm		Tri-Annual Firedrill Screen
Evacuation Time	firedrill_c		firedr_evmin, firedr_evsec		Tri-Annual Firedrill Screen
IF cycle = 7
Cycle 7 – Due June 15
Please report below the results from your February (if not reported previously), March, April, and May fire drills.
Date of Fire Drill	firedrill_c		firedr_date		Tri-Annual Firedrill Screen
Time of Fire Drill	firedrill_c		firedr_hour, firedr_min, firedr_ampm		Tri-Annual Firedrill Screen
Evacuation Time	firedrill_c		firedr_evmin, firedr_evsec		Tri-Annual Firedrill Screen

RPT610 Return to Index

District Tri-Annual Fire Drill

This report lists a verification or non-verification of your school’s compliance to the facility inspection by your local fire department as required by Ark. Code Ann. 6-21-106.

Column	Table	Field		Where to Enter Data
IF cycle = 3
Cycle 3 – Due November 15
Does the district provide a program of safety training essential to the reasonable protection of the lives of students and property from fire and other hazards in each unit of the school district?	district_c	firedr_sfty	Y, safety1 = “X” N, safety2 = “X”	Tri-Annual Firedrill Screen
IF cycle = 5
Cycle 5 – Due February 15
Was each school facility inspected by your local fire department as required by Ark. Code Ann. 6-21-106? (This code requires that the local school district request an inspection of the premises by the fire department providing fire protection to the school premises seven calendar days prior to the beginning of Christmas break.)	district_c	firedr_inspct1	Y, safety1 = “X” N, safety2 = “X”	Tri-Annual Firedrill Screen
IF cycle = 7
Cycle 7 – Due June 15
Was each school facility inspected by your local fire department as required by Ark. Code Ann. 6-21-106? (This code requires that the local school district request an inspection of the premises by the fire department providing fire protection to the school premises seven calendar days prior to the end of school year.)	district_c	firedr_inspct2	Y, safety1 = “X” N, safety2 = “X”	Tri-Annual Firedrill Screen
Evacuation Time	firedrill_c	firedr_evmin, firedr_evsec		Tri-Annual Firedrill Screen