 	<table border>
 		<tr>
 			<th>KEY</th>
+			<th>GUID</th>
 			<th>USERNAME</th>
 			<th>STATUS</th>
 			<th>ATTRIBUTE</th>

		<cfloop query="cf_temp_specevent">
			<tr>
				<td>#KEY#</td>
				<td>#STATUS#</td>
				<td>#USERNAME#</td>
				<td>#INSERT_DATE#</td>
				<td>#guid#</td>
				<td>#ASSIGNED_BY_AGENT#</td>
				<td>#ASSIGNED_DATE#</td>
				<td>#SPECIMEN_EVENT_REMARK#</td>

	</table>
	<cfquery name="cf_temp_oids" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		select
			cf_temp_oids.KEY,
			cf_temp_oids.USERNAME,
			cf_temp_oids.STATUS,
			cf_temp_oids.NEW_OTHER_ID_TYPE,
			cf_temp_oids.NEW_OTHER_ID_NUMBER,
			cf_temp_oids.NEW_OTHER_ID_REFERENCES,
			flat.guid
		from
			cf_temp_oids,
