Verification Needed with Powerteacher 1.5?

We didn't like having to tell our building reps who verify grades to have to use a beta product - one that wasn't working properly for us. So we just customized the teacher grade verification page available through powerdatasolutions... the tlist is below. Of course, probably not the cleanest but it provided them with a term selection and the ability to select either verified or unverified sections in their building. Teachers just clicked the button in the gradebook and then the office verified. Worked for us - if it helps someone else, here you go. More info available upon request.

~[tlist_sql;
WITH VERIFY AS (SELECT psmsr.verifiedstatus verstatus, psmsr.verifieddate verdate, psmsr.sectionid sectionid, psmsr.verifiedcomment vcomment FROM TERMBINS INNER JOIN SYNC_REPORTINGTERMMAP srtm ON srtm.termbinsdcid = termbins.dcid INNER JOIN PSM_REPORTINGTERM psmrt ON psmrt.id = srtm.reportingtermid INNER JOIN PSM_SECTIONREADINESS psmsr ON psmsr.reportingtermid = psmrt.id WHERE termbins.schoolid = ~(schoolid) AND termbins.storecode = to_char('~[gpv:fg]'))

SELECT t.LastFirst Teacher, sec.Expression, sec.SchoolID, sec.ID SectionID, Terms.Abbreviation Term, sec.Course_Number, c.Course_Name, sec.Section_Number, sec.Room, sec.no_of_students Class_Size, CASE WHEN verify.verstatus = 1 THEN 'Verified' ELSE 'Unverified' END Verify_On, CASE WHEN to_char(verify.verdate) is not null THEN to_char(verify.verdate) ELSE 'N/A' END Verify_Date, CASE WHEN to_char(verify.vcomment) is not null THEN to_char(verify.vcomment) ELSE 'N/A' END Verify_Comment
FROM Sections sec
INNER JOIN Teachers t ON sec.Teacher = t.ID
INNER JOIN Courses c ON sec.course_number = c.course_number
INNER JOIN Terms ON sec.termid = Terms.id
INNER JOIN SYNC_SECTIONMAP ssm ON ssm.sectionsdcid = sec.dcid
INNER JOIN PSM_SECTION psms ON psms.id = ssm.sectionid
LEFT OUTER JOIN VERIFY ON psms.id = verify.sectionid
WHERE Terms.schoolid = ~(schoolid) AND sec.SchoolID = ~(schoolid) AND sec.excludefromstoredgrades = 0 AND sec.no_of_students > 0 AND sec.termid IN (SELECT id FROM terms WHERE firstday <= (SELECT lastday from terms where id=~[gpv:tid] AND schoolid=~(schoolid)) AND lastday >= (SELECT firstday from terms where id=~[gpv:tid] AND schoolid=~(schoolid)) AND terms.schoolid = ~(schoolid)) AND sec.excludefromstoredgrades <> 1 AND ( ((to_char(~[gpv:vtype]) = '0') AND (verify.verstatus <> 1 OR verify.verstatus is null)) OR ((to_char(~[gpv:vtype]) = '1') AND (verify.verstatus = 1)) OR (to_char(~[gpv:vtype]) = '2') ) ORDER BY t.LastFirst, sec.Expression ;alternatecolor][/tlist_sql]