~[wc:meritstore/meritLabelPoints] – ~(yearname)

~[tlist_sql; SELECT balance, CASE WHEN balance = 1 THEN '~[wc:meritstore/meritPointsSingular]' ELSE '~[wc:meritstore/meritPointsPlural]' END AS balword FROM (SELECT NVL((SELECT SUM(points) FROM u_nt_merit_points WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1')),0) - NVL((SELECT SUM(points_spent) FROM u_nt_merit_redemption WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1')),0) AS balance FROM dual)]

~[text:nicktech.merit.label.available_balance] ~(balance) ~(balword)

[/tlist_sql]

~[wc:meritstore/meritLabelEarned]

~[tlist_sql; SELECT TO_CHAR(date_recorded,'MM/DD/YYYY') AS edate, points AS epts, description AS edesc, usersname AS euser, note AS enote FROM u_nt_merit_points WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1') ORDER BY date_recorded DESC, id DESC] [/tlist_sql]

~[text:nicktech.merit.th.date]	~[wc:meritstore/meritPointsPlural]	~[text:nicktech.merit.th.behavior]	~[text:nicktech.merit.th.awarded_by]	~[text:nicktech.merit.th.note]
~(edate)	~(epts)	~(edesc)	~(euser)	~(enote)

~[text:nicktech.merit.heading.redemptions]

~[tlist_sql; SELECT TO_CHAR(redeemed_date,'MM/DD/YYYY') AS rdate, item_name AS ritem, points_spent AS rpts, usersname AS ruser FROM u_nt_merit_redemption WHERE studentsdcid = ~(rn) AND (yearid = ~(curyearid) OR '~[wc:meritstore/meritPrefCarryOver]' = '1') ORDER BY redeemed_date DESC, id DESC] [/tlist_sql]

~[text:nicktech.merit.th.date]	~[text:nicktech.merit.th.item]	~[wc:meritstore/meritLabelSpent]	~[text:nicktech.merit.th.processed_by]
~(rdate)	~(ritem)	~(rpts)	~(ruser)