Transactions

Transactions are actions that effect the coming and going of Cataloged Items, and parts thereof.  Accessions permanently bring cataloged items into a collection, Loans record movement and usage of cataloged items, and Borrows record items from other collections lent, and in your collection’s temporary custody.  These three types of transactions share several fields in common, and those fields are treated on this page.

Nature of Material

Trans . Nature_of_Material VARCHAR2(4000) not null

is a brief textual description of the accession or loan. Quantities can be approximate if accession material is not being unpacked prior to storage. For example, “About 300 frozen small mammals collected during the summer of 2004 in Denali State Park.”

Public Flag

By default, transactions are internal and only available to the originating collection. Setting this flag to true makes some transaction data publicly available.

Trans Date

Trans date is an ISO8601 date field describing the date the transaction took place (usually began).

Remarks

Trans . Trans_Remarks VARCHAR2(4000) null

is a place for expanding a description of the conditions of acceptance, or for instructions in processing the material. For example, “Take 50 gram subsamples for fatty-acid analysis.”

Transaction Agents

Agents involved in transactions ( Accessions, Loans, and Borrows ) are stored in table trans_agent.

Transaction Agent Role

A Code Table describes the various roles Agents have in Transactions.