 				getPreferredAgentName(encumbrance.encumbering_agent_id) encumberer,
 				encumbrance.made_date as encumbered_date,
 				expiration_date,
-				expiration_event,
 				remarks
 				from
 					cataloged_item


delete from specimen_part_attribute where COLLECTION_OBJECT_ID IN
		(
			select 
				specimen_part.COLLECTION_OBJECT_ID 
			FROM
				coll_object_encumbrance,
				specimen_part

<cfquery name="spcolattr" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
	delete from specimen_part_attribute where COLLECTION_OBJECT_ID IN
		(
			select
				specimen_part.COLLECTION_OBJECT_ID
			FROM
				coll_object_encumbrance,
				specimen_part
