select a.univ_id,n.first_name,n.last_name,e1.email_addr,e1.campus_email,c.comm_dttm as offerDate,c1.comm_dttm as acceptDate,c2.comm_dttm as processDate,listagg(e2.name,',') within group (order by e2.start_date) as events from application_data@GEMINI a left join GEMINI.communications c on c.univ_id = a.univ_id and c.comm_type = 'HXOFFER' left join GEMINI.communications c1 on c1.univ_id = a.univ_id and c1.comm_type = 'HXWANT' left join GEMINI.communications c2 on c2.univ_id = a.univ_id and c2.comm_type = 'HXCERT' join EXPERIENCE_STUDENTS_EVENTS e on a.univ_id = e.univ_id join names@GEMINI n on n.univ_id = e.univ_id join email@GEMINI e1 on e1.univ_id = e.univ_id join experience_events e2 on e2.id = e.event_id where UPPER(e1.network_id) = UPPER('#session.casUser#') group by a.univ_id,n.first_name,n.last_name,e1.email_addr,e1.campus_email,c.comm_dttm,c1.comm_dttm,c2.comm_dttm

You have attended the following events:

1. #i#

Congratulations! Your First Year Hoosier Experience Achievement Award is available. Click here to view it.

#session.messages[message]#

Congratulations! You have already accepted the First Year Hoosier Experience Achievement Award.

Congratulations! You have already accepted the First Year Hoosier Experience Achievement Award.

Congratulations! You have been offered the First Year Hoosier Experience Achievement Award. Please click below to accept.

It doesn't look like you have attended any events. Please allow a few days for recent events to get loaded into the system.