MBA P-EBT Attendance Report

Students	Dates	Att Codes	Att Mode	Address	Excluded Days	Minimum Records Per Day
All Students Current Selection (~[x:studsinset])	-	~[tlist_sql; SELECT distinct att_code FROM attendance_code WHERE yearid = ~(curyearid) AND schoolid = ~(curschoolid) OR ~(curschoolid) = 0 ORDER BY att_code ;] ~(cd) [/tlist_sql]	Meeting Daily	Home Mailing	~[tlist_sql; SELECT value, name FROM gen WHERE cat = 'dailymembtypes' ORDER BY name ;] ~(name) [/tlist_sql]	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

~[if.~(gpv.startDate)<>] Make Current Selection Export [/if] Search

~[if#outer.~(gpv.startDate)<>] ~[tlist_sql; SELECT students.dcid, students.student_number, students.state_studentnumber, students.first_name, students.middle_name, students.last_name, students.grade_level, ~[if#add1.~(gpv.address)=mailing] students.mailing_street, students.mailing_city, students.mailing_state, students.mailing_zip, [else#add1] students.street, students.city, students.state, students.zip, [/if#add1] to_char(students.dob,'~[dateformat]'), students.schoolid, to_char(students.entrydate,'~[dateformat]'), to_char(students.exitdate,'~[dateformat]'), students.id, count(distinct attendance.att_date) FROM attendance JOIN attendance_code ON attendance_code.id = attendance.attendance_codeid JOIN students ON students.id = attendance.studentid JOIN calendar_day ON calendar_day.date_value =attendance.att_date AND calendar_day.schoolid = students.schoolid WHERE (students.schoolid = ~(curschoolid) OR ~(curschoolid) = 0) AND attendance.att_date BETWEEN to_date('~(gpv.startDate)','MM/DD/YYYY') AND to_date('~(gpv.endDate)','MM/DD/YYYY') AND attendance_code.att_code IN (~(gpv.attCodes)) ~[if#inner.~(gpv.students)=cur] AND students.dcid IN (SELECT dcid FROM ~[temp.table.current.selection:students]) [/if#inner] ~[if.~(gpv.excludedDays)<>] AND calendar_day.type NOT IN (~(gpv.excludedDays)) [/if] AND( attendance.att_mode_code = '~(gpv.attMode)' OR '~(gpv.attMode)' IS NULL ) AND ( SELECT count(*) FROM attendance att2 JOIN attendance_code ac2 ON ac2.id = att2.attendance_codeid WHERE ac2.att_code IN (~(gpv.attCodes)) AND att2.studentid = students.id AND att2.att_date = attendance.att_date AND( att2.att_mode_code = '~(gpv.attMode)' OR '~(gpv.attMode)' IS NULL ) ) >= ~(gpv.recCount) GROUP BY students.dcid, students.student_number, students.first_name, students.last_name, students.last_name, students.middle_name, students.state_studentnumber, students.grade_level, students.dob, ~[if#add2.~(gpv.address)=mailing] students.mailing_street, students.mailing_city, students.mailing_state, students.mailing_zip, [else#add2] students.street, students.city, students.state, students.zip, [/if#add2] students.schoolid, students.entrydate, students.exitdate, students.id ORDER BY students.last_name, students.first_name ;] [/tlist_sql]

Student Num	State Stu Num	First	Middle	Last	Grade Level	Street	Street 2	City	State	Zip	DOB	Schoolid	Entry Date	Exit Date	Total Days
~(studentnumber)	~(state_studentnumber)	~(first_name)	~(middle_name)	~(last_name)	~(grade_level)	~(street)		~(city)	~(state)	~(zip)	~(dob)	~(schoolid)	~(entrydate)	~(exitdate)	~(count)

[/if#outer]