<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Jaime,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’m not the right person to answer your questions re: the differences between the various User Defined Fields, but since you are looking for a solution to recording
funding information in accession records, I thought I would point you to a plugin that we at Yale have developed with Hudson Molonglo. It’s called our “Payments Module”. With it you will be able to create payment subrecords in accession records. Our financial
recording needs are probably more complicated than yours, but you will certainly be able to record how much was paid and who you paid it to. See
<a href="https://github.com/hudmol/payments_module">https://github.com/hudmol/payments_module</a> if you want to give it a spin.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Mike<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> archivesspace_users_group-bounces@lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org]
<b>On Behalf Of </b>Jaime Margalotti<br>
<b>Sent:</b> Thursday, September 18, 2014 10:35 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] User Defined Fields and Money<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Folks,<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I'm working on mapping our existing accessions information (currently in an Access database) to ArchivesSpace. It's relatively simple and most things map clearly. Since there isn't any place to put funding
information (yet), I need to utilize User Defined fields for two pieces of information: where something was purchased and how much was paid. It would seem like "purchase source" could map to "Text 1," but what about the dollar amount?
<br>
<br>
I'm not a SQL programmer, so I would like a clear explanation about what the differences between "real," "string," "integer," and "text" are before I determine where a monetary amount would go. As far as I can tell, the ArchivesSpace documentation just lists
the types of fields available, but doesn't give any advice/examples. Decimals (money) are not integers as I understand them to be defined.<o:p></o:p></p>
</div>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
</div>
<p class="MsoNormal">Jaime<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<pre>Jaime L. Margalotti<o:p></o:p></pre>
<pre>Senior Assistant Librarian<o:p></o:p></pre>
<pre>Manuscripts and Archives Department University of Delaware Library<o:p></o:p></pre>
<pre>Newark, DE 19717-5267<o:p></o:p></pre>
<pre>302-831-0554<o:p></o:p></pre>
<pre><a href="mailto:jmargalo@udel.edu" target="_blank">jmargalo@udel.edu</a><o:p></o:p></pre>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>