[Archivesspace_Users_Group] User Defined Fields and Money

Jaime Margalotti jmargalo at udel.edu
Thu Sep 18 10:35:00 EDT 2014

Hi Folks,

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?

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.


Jaime L. Margalotti
Senior Assistant Librarian
Manuscripts and Archives Department University of Delaware Library
Newark, DE  19717-5267
302-831-0554jmargalo at udel.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20140918/96d8a510/attachment.html>

More information about the Archivesspace_Users_Group mailing list