 	);
 
 	alter table pre_new_collection add use_license_id number;
+	alter table pre_new_collection add final_message VARCHAR2(4000);
+	alter table pre_new_collection add contact_email VARCHAR2(4000);
+
 
 	create public synonym pre_new_collection for pre_new_collection;
 

			</ul>
		</p>
		<p>
			Make sure to save if you change anything!
		</p>

		<form name="f" id="f" action="new_collection.cfm" method="post">

			<br><input type="submit" class="savBtn" value="save changes">

			<input type="hidden" name="action" value="saveEdits">
			<input type="hidden" name="user_pwd" value="#d.user_pwd#">
			<!----
			<div class="infoDiv">
				This password is NOT secure and comes with no restrictions. DO NOT re-use your password to any site, including Arctos.

				<label for="admin_username">admin_username</label>
				<input type="text" name="admin_username" id="admin_username"  value="#d.admin_username#" size="80">
			</div>
			<div class="infoDiv">
				Once everything in this form is to your satisfaction, you may finalize this request. This message will be included
				in that notification.

				<label for="final_message">Message to include</label>
				<textarea class="hugetextarea reqdClr" name="final_message" id="final_message" required >#d.final_message#</textarea>
			</div>


			<div class="infoDiv">
				Once everything in this form is to your satisfaction, you may finalize this request. Choosing "finalize" in this control will
				<ul>
					<li>LOCK existing data</li>
					<li>Notify Arctos staff of the request</li>
				</ul>

				<label for="sfs">Request Finalization</label>
				<select name="sfs" id="sfs" >
					<option value="">not yet</option>
					<option value="yes_plz">Finalize these data; alert Arctos staff</option>
				</select>
			</div>

			<cfif isdefined("session.roles") and session.roles contains "global_admin">
				<div class="infoDiv">
					You have global_admin; you can change the status of this request.
					<ul>
						<li>new: unreviewed request</li>
						<li>submit for review: request is ready for consideration by Arctos staff</li>
						<li>ready to create: request is approved by Arctos staff and ready for DBA action</li>
						<li>created: collection is created and ready for use</li>
					</ul>
					The save and request will fail if mentor_contact does not contain an email address.
					<label for="status">status</label>
						<select name="status" id="status" class="reqdClr" required >
							<option <cfif d.status is "new">selected="selected" </cfif>value="new">new</option>
							<option <cfif d.status is "submit for review">selected="selected" </cfif>value="submit for review">submit for review</option>
							<option <cfif d.status is "ready to create">selected="selected" </cfif>value="ready to create">ready to create</option>
							<option <cfif d.status is "created">selected="selected" </cfif>value="created">created</option>
					</select>
				</div>
			</cfif>


			<br><input type="submit" class="savBtn" value="save changes">
		</form>

	</cfoutput>
</cfif>
<cfif action is "saveEdits">
	<cfoutput>
		<cfif not isdefined("session.roles") or session.roles does not contain "global_admin">
			<cfif old_status is not "new">
				You may not edit this request.<cfabort>
			</cfif>
		</cfif>
		<!--- pre-check this ---->



		<cfquery name="u" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
			update pre_new_collection set
				GUID_PREFIX='#GUID_PREFIX#',
				COLLECTION_CDE='#COLLECTION_CDE#',
				INSTITUTION_ACRONYM='#INSTITUTION_ACRONYM#',
				DESCR='#escapeQuotes(DESCR)#',
