Complete Field List
The following default record types are provided:
LoanM (Museums) (and LoanA
for Archives which is no longer used). For Archive loans, see the
ArchiveLoans database. The
LoanM sample shows the default fields supplied with Calm in the default order.
Please note: the sample records will open in a new window, when you have
finished and wish to return to this page, use the cross in the top right corner
to close the window.
There are several ways in which you may customise the default Calm record types.
For example, you can
add or remove fields
from the record types or
change the order in which
fields are displayed
in the templates using the Admin program.
The following is a list of all fields available for the LoanHist database; this
includes the fields that are provided as part of the default templates plus a
pool of additional fields which you may use to customise the record types.
LOANHIST DATABASE
Field name Attributes
| AuthorisationDate | Date field |
| Authoriser | Line of text field |
| BookingId | Text field |
| Borrower |
Line of text field This is a read only field. You will receive an error message if you try to save a loan record with more than one Borrower field, if the One-per-record validation option is set in the Record drop down menu. |
| BorrowersContact | Text field |
| Complete | Date field |
| Cost | Currency field |
| CostNote | Wrapped text field |
| Created | DO NOT DELETE Date field Hidden You will receive an error message if you try to save a loan record with more than one Created field, if the One-per-record validation option is set in the Record drop down menu. |
| Creator | DO NOT DELETE Identifier field Hidden You will receive an error message if you try to save a loan record with more than one Creator field, if the One-per-record validation option is set in the Record drop down menu. |
| Date | Date field |
| DateBack | Date field |
| DateDue | Date field |
| DateIssued | Date field |
| DateOut | Date field |
| DateReturned | Date field |
| DespatchDate | DO NOT DELETE Date field |
| DespatchReference | Line of text field |
| EndDate | DO NOT DELETE Date field |
| FindDate | Date field |
| Issued |
Line of text field This field has default content |
| ItemAlt | Text field |
| ItemId | Identifier field |
| ItemLoc | Text field |
| ItemRef | Text field |
| ITEMS | This field is displayed as a section heading and cannot have content typed into it. |
| ItemTitle | Text field |
| ItemType | Text field |
| LoanGroup | Line of text field |
| LoanId |
Text field This field will automatically be filled with a number, when a new record is created. |
| LoanOutNote | Wrapped text field |
| LoanOutReferenceNumber | Line of text field |
| LoanType | Text field |
| LoanUse |
Identifier field You will receive an error message if you try to save a loan record with more than one LoanUse field, if the One-per-record validation option is set in the Record drop down menu. |
| Location | Text field |
| Logged |
Time field This is a read only field. |
| Modified | DO NOT DELETE Date field Hidden You will receive an error message if you try to save a loan record with more than one Modified field, if the One-per-record validation option is set in the Record drop down menu. |
| Modifier | DO NOT DELETE Identifier field Hidden You will receive an error message if you try to save a loan record with more than one Modifier field, if the One-per-record validation option is set in the Record drop down menu. |
| Multimedia | Multimedia field |
| Note | Wrapped text field |
| NOTES | This field is displayed as a section heading and cannot have content typed into it. |
| Object | This field is displayed as a section heading and cannot have content typed into it. |
| ObjectNumber | Identifier field |
| ObjectReturnBy | Line of text field |
| ObjectReturnDate | Date field |
| ProductionId | Identifier field A serial number (prefixed by 'P' as a default), the next available number is automatically assigned from the Admin program. This field will automatically be filled with a number, when a new record is created. |
| Reason | Text field |
| RecordId |
DO NOT DELETE Unique identifier for this record This is a read only field. Hidden |
| RecordName | DO NOT DELETE Line of text field Hidden |
| RecordStandard |
DO NOT DELETE Identifier field The standard this record adheres to, regarding EAD format. Hidden |
| RecordType | DO NOT DELETE Line of text field Hidden |
| RequestDate | Date field |
| Resource | Line of text field |
| RESOURCES | This field is displayed as a section heading and cannot have content typed into it. |
| ResourceType | Line of text field |
| Returned | Date field |
| ReturnedBy | Line of text field |
| SpecialConditions | Wrapped text field |
| StartDate | DO NOT DELETE Date field |
| SubLocation | Text field |
| Text | Wrapped text field |
| TimeDue | Time field |
| TimeIssued | Time field |
| TimeReturned | Time field |
| UOI_Added | Line of text field |
| UOI_Scheme | Line of text field |
| UserId | DO NOT DELETE Identifier field |
| UserType | Line of text field |