~[tlist_sql;
    select
        max(attendance.dcid)
    from
        attendance
    where
        attendance.att_mode_code = 'ATT_Mode~(gpv.attType)'
        and attendance.att_date = to_date('~(gpv.att_date)', 'YYYY-MM-DD')
        ~[if#studentid.~(gpv.studentid)#]
            and attendance.studentid = '~(gpv.studentid)'
        [/if#studentid]
        ~[if#attendancedcid.~(gpv.attendancedcid)#]
            and attendance.dcid = '~(gpv.attendancedcid)'
        [else#attendancedcid]
            ~[if#ccid.~(gpv.ccid)#]
                and attendance.ccid = '~(gpv.ccid)'
            [/if#ccid]
        [/if#attendancedcid]
;]
    <input type="text" name="attendance.dcid" value="~(dcid)" id="attendancedcid">
    <input type="text" name="CF-[U_IDENTIMETRICS_ATT_FOTM:~(dcid)]SubmittedByFOTM" value="1" id="submittedFOTM">
    ~[if#printTardySlip.gpv.printTardySlip=1]
        <input type="text" name="CF-[U_IDENTIMETRICS_ATT_FOTM:~(dcid)]TardySlip" value="1" id="tardySlipFOTM">
    [/if#printTardySlip]
    ~[if#dailyException.gpv.dailyException=1]
        <input type="text" name="CF-[U_IDENTIMETRICS_ATT_FOTM:~(dcid)]DailyException" value="1" id="dailyException">
    [/if#dailyException]
[/tlist_sql]
<input type="text" name="ac" value="prim" id="ac">