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