Complete Field List
The following default record type is provided:
User. This sample shows the default fields supplied with Calm in the default order.
Please
note: the sample record will open 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 type.
For example, you can
add or remove fields
from the record type or
change the order in which
fields are displayed
in the template using the Admin program.
The following is a list of all fields available for the Users database; this
includes the fields that are provided as part of the default template plus a
pool of additional fields which you may use to customise the record type.
USERS DATABASE
Field name Attributes
| Account |
Line of text field You will receive an error message if you try to save a User record with more than one Account field, if the One-per-record validation option is set in the Record drop down menu. |
| Address | Text field |
| ADMIN_DETAILS |
This field is displayed as a section heading and cannot have content
typed into it. Hidden |
| AmountCharged | Currency field |
| AmountPaid | Currency field |
| Arrangements | Wrapped text field |
| CARN |
Text field This is a unique field. You will receive an error message if you try to save a User record with more than one CARN field, if the One-per-record validation option is set in the Record drop down menu. |
| ContactName |
Line of text field This is an authority controlled field You will receive an error message if you try to save a User record with more than one ContactName field, if the One-per-record validation option is set in the Record drop down menu. |
| Created | DO NOT DELETE Date field You will receive an error message if you try to save a User record with more than one Created field, if the One-per-record validation option is set in the Record drop down menu. Hidden |
| Creator | DO NOT DELETE Identifier field You will receive an error message if you try to save a User record with more than one Creator field, if the One-per-record validation option is set in the Record drop down menu. Hidden |
| DeleteFlag | Integer field |
| Department |
Line of text field This is an authority controlled field |
| Designation | Line of text field |
| Line of text field | |
| EnqId | Identifier field |
| ExhibitionEndDate | Date field |
| ExhibitionReference | See also UserID |
| ExhibitionStartDate | Date field (see also StartDate) |
| Expertise | Wrapped text field |
| Expiry | Date field Ticket expiry date, checked when issuing a loan or production. You will receive an error message if you try to save a User record with more than one Expiry field, if the One-per-record validation option is set in the Record drop down menu. |
| Fax | Line of text field |
| FinishDate |
Date field You will receive an error message if you try to save a User record with more than one FinishDate field, if the One-per-record validation option is set in the Record drop down menu. |
| FirstReg | Date field |
| GroupTicket | Line of text field |
| IDExpires | Date field |
| IDProduced | Line of text field |
| IDType | Line of text field |
| Image | Graphics field |
| LastIDCheck | Date field |
| LoansToDate |
Integer field You will receive an error message if you try to save a User record with more than one LoansToDate field, if the One-per-record validation option is set in the Record drop down menu. |
| Message | Line of text field |
| Modified | DO NOT DELETE Date field You will receive an error message if you try to save a User record with more than one Modified field, if the One-per-record validation option is set in the Record drop down menu. Hidden |
| Modifier | DO NOT DELETE Identifier field You will receive an error message if you try to save a User record with more than one Modifier field, if the One-per-record validation option is set in the Record drop down menu. Hidden |
| Multimedia | Multimedia field |
| Note | Wrapped text field |
| OnLoan |
Integer field You will receive an error message if you try to save a User record with more than one OnLoan field, if the One-per-record validation option is set in the Record drop down menu. |
| Organisation |
Line of text field This is an authority controlled field |
| Password | Line of text field |
| PIN | Identifier field |
| PostRef | Line of 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 |
| Salutation | Line of text field |
| SDI | Text field |
| StartDate |
Date field You will receive an error message if you try to save a User record with more than one StartDate field, if the One-per-record validation option is set in the Record drop down menu. |
| Tel | Line of text field |
| Text | Text field |
| Thumbnail | Graphics field |
| TicketExpires | Date field |
| TicketNumber |
Line of text field This is a unique field. |
| TicketType |
Line of text field Hidden |
| UserAlert |
Line of text field Use this field to enter a user-related note or message which will appear on screen when a transaction involving this user takes place. |
| UserDate1 to UserDate9 | Date field |
| UserId |
DO NOT DELETE Identifier field A serial number (prefixed by 'U' 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. This is an authority controlled field This is a unique field. If you have /barcode on your shortcut line when you run Calm, the UserId field will expect a barcode to be scanned in, for example from a user's ticket. |
| UserInteger1 to UserInteger9 | Integer field |
| UserName |
Line of text field Usually entered as SURNAME, First name(s) e.g. SMITH, John This is an authority controlled field You will receive an error message if you try to save a User record with more than one UserName field, if the One-per-record validation option is set in the Record drop down menu. |
| UserNumber1 to UserNumber9 | Number field |
| UserPeriod1 to UserPeriod9 | Period field |
| UserStatus |
Line of text field A number representing status for loans and productions: A status of less than 3 is OK, 3-5 a warning is displayed but you can continue with the transaction, more than 5 (or 5 followed by a message) a loan or booking cannot be made to this user This field has a picklist, which is displayed as a popup. You will receive an error message if you try to save a User record with more than one UserStatus field, if the One-per-record validation option is set in the Record drop down menu. |
| UserText1 to UserText9 | Line of text field |
| UserType |
Line of text field For example, Staff, Guest or Temp. Items that have an AccessStatus of "Closed" can only be issued to users with "Staff" UserType. This field has a picklist, which is displayed as a popup. You will receive an error message if you try to save a User record with more than one UserType field, if the One-per-record validation option is set in the Record drop down menu. |
| UserWrapped1 to UserWrapped9 | Wrapped text field |