~[if#meetingAtt.~(gpv.attType)=Meeting] ~[tlist_sql; select cc.id, period.id, bell_schedule_items.start_time, bell_schedule_items.end_time, cc.course_number, section_meeting.period_number from cc join students on cc.studentid = students.id join sections on cc.sectionid = sections.id join terms on sections.termid = terms.id and sections.schoolid = terms.schoolid and terms.yearid = ~(curyearid) join section_meeting on sections.id = section_meeting.sectionid join cycle_day on section_meeting.cycle_day_letter = cycle_day.letter and sections.schoolid = cycle_day.schoolid and cycle_day.year_id = ~(curyearid) join period on section_meeting.period_number = period.period_number and section_meeting.schoolid = period.schoolid and period.year_id = ~(curyearid) join calendar_day on terms.schoolid = calendar_day.schoolid and calendar_day.insession = 1 and cycle_day.id = calendar_day.cycle_day_id and calendar_day.date_value between cc.dateenrolled and cc.dateleft-1 join bell_schedule_items on bell_schedule_items.bell_schedule_id = calendar_day.bell_schedule_id and bell_schedule_items.period_id = period.id where '~(gpv.attType)' = 'Meeting' and cc.studentid = '~(gpv.studentid)' and calendar_day.date_value = to_date('~(gpv.att_date)', 'YYYY-MM-DD') and (~(gpv.submitHour24)*60*60 + ~(gpv.submitMinute)*60) between bell_schedule_items.start_time and bell_schedule_items.end_time and cc.schoolid = ~(curschoolid) and cc.id = ~(gpv.ccid) ;] [/tlist_sql] [/if#meetingAtt] ~[if#printTardySlip.~(gpv.printTardySlip)=1] [/if#printTardySlip] ~[if#dailyAtt.~(gpv.attType)=Daily] ~[if#CICO.~(gpv.dailyCICO)=1] ~[if#attendance_timedcid.~(gpv.attendance_timedcid)#] ~[if#attendance_timedcidNEW.~(gpv.attendance_timedcid)=-1] [else#attendance_timedcidNEW] [/if#attendance_timedcidNEW] [else#attendance_timedcid] ~[if#att_Time_In.~(gpv.att_Time_In)=][else#att_Time_in] [/if#att_Time_In] ~[if#att_Time_Out.~(gpv.att_Time_Out)=][else#att_Time_Out] [/if#att_Time_Out] [/if#attendance_timedcid] [/if#CICO] [/if#dailyAtt] ~[if#OH.~[sr-version]$USA-OH] ~[if#meetingAttOH.~(gpv.attType)=Meeting] ~[tlist_sql; select nvl(max(S_OH_Stu_Truancy_Meeting_C.id), -1) id from cc join students on cc.studentid = students.id join sections on cc.sectionid = sections.id join terms on sections.termid = terms.id and sections.schoolid = terms.schoolid and terms.yearid = ~(curyearid) join section_meeting on sections.id = section_meeting.sectionid join cycle_day on section_meeting.cycle_day_letter = cycle_day.letter and sections.schoolid = cycle_day.schoolid and cycle_day.year_id = ~(curyearid) join period on section_meeting.period_number = period.period_number and section_meeting.schoolid = period.schoolid and period.year_id = ~(curyearid) join calendar_day on terms.schoolid = calendar_day.schoolid and calendar_day.insession = 1 and cycle_day.id = calendar_day.cycle_day_id and calendar_day.date_value between cc.dateenrolled and cc.dateleft-1 join bell_schedule_items on bell_schedule_items.bell_schedule_id = calendar_day.bell_schedule_id and bell_schedule_items.period_id = period.id left join S_OH_Stu_Truancy_Meeting_C on cc.course_number = S_OH_Stu_Truancy_Meeting_C.course_absent and section_meeting.period_number = S_OH_Stu_Truancy_Meeting_C.class_absent and students.dcid = S_OH_Stu_Truancy_Meeting_C.studentsdcid and calendar_day.date_value = S_OH_Stu_Truancy_Meeting_C.date_absent where '~(gpv.attType)' = 'Meeting' and cc.studentid = '~(gpv.studentid)' and calendar_day.date_value = to_date('~(gpv.att_date)', 'YYYY-MM-DD') and (~(gpv.submitHour24)*60*60 + ~(gpv.submitMinute)*60) between bell_schedule_items.start_time and bell_schedule_items.end_time and cc.schoolid = ~(curschoolid) and cc.id = ~(gpv.ccid) ;] [/tlist_sql] [/if#meetingAttOH] [/if#OH]