[Archivesspace_Users_Group] User Defined Fields and Money

[Jaime Margalotti]

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.

Thanks!
Jaime
-- 

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>