Complete Field List
The Works database is part of the Performances module. Only customers who
have purchased this add-on module will be able to access this database.
The following default record type is provided:
Work. 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 Works 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.
WORKS DATABASE
Field name Attributes
| ADMIN_DATA | This field is displayed as a section heading and cannot have content typed into it. |
| ADMIN_DETAILS | This field is displayed as a section heading and cannot have content typed into it. |
| AltTitle | Wrapped text field |
| Awards | Wrapped text field |
| BOX_OFFICE | This field is displayed as a section heading and cannot have content typed into it. |
| CatalogueItemA | Hidden |
| CatalogueItemM | Hidden |
| Company |
Line of text field This is an authority controlled field which displays entries from the PersonName field in the Persons database. |
| Country |
Line of text field This is an authority controlled field. |
| CountryOfOrigin | Line of text field |
| Created | Date field |
| CreativeRole | Hidden |
| Creator | Identifier |
| FirstPerformed | Period field |
| GENERAL_DETAILS | This field is displayed as a section heading and cannot have content typed into it. |
| GenNotes | Wrapped text field |
| HeaderNote | Wrapped text field |
| IDENTIFICATION |
This field is displayed as a section heading and cannot have content
typed into it. You will receive an error message if you try to save a Work record with more than one identification field, if the One-per-record validation option is set in the Record drop down menu. |
| IDENTITY |
This field is displayed as a section heading and cannot have content
typed into it. You will receive an error message if you try to save a Work record with more than one identity field, if the One-per-record validation option is set in the Record drop down menu. |
| LastPerformed | Date field |
| Modified | Date field |
| Modifier | Identifier |
| NameCode | Hidden |
| NoPerformances | Integer field |
| Notes | Wrapped text field |
| OpeningNight | Date field |
| Orchestra |
Line of text field This is an authority controlled field which displays entries from the PersonName field in the Persons database. |
| OriginalDate | Period field |
| Originator | Line of text field |
| OriginatorTree |
Line of text field This is a unique field. This is a Tree field. Use '/' as a separator if more than one tree level is used. Press the button next to the field to view the tree. |
| PerformanceLength | Line of text field |
| PerformanceNote | Wrapped text field |
| PerformanceType | |
| PerformerRole | Hidden |
| PlaceCode | Hidden |
| PMoney | Number field |
| PressNight | Date field |
| Pseats | Number field |
| Reference |
Line of text field This is a unique field. You will receive an error message if you try to save a Work record with more than one Reference field, if the One-per-record validation option is set in the Record drop down menu. This is a Tree field. Use '/' as a separator if more than one tree level is used. |
| SeatsSold | Integer field |
| SeatValue | Currency field |
| SHOW_DETAILS | This field is displayed as a section heading and cannot have content typed into it. |
| Sponsors | Wrapped text field |
| Subject |
Line of text field Press the button next to the field to insert a term from the Subject thesaurus. |
| Time | Text field |
| Title |
Wrapped text field This is an authority controlled field. |
| TitleTree |
Line of text field This is a unique field. You will receive an error message if you try to save a Work record with more than one TitleTree field, if the One-per-record validation option is set in the Record drop down menu. This is a Tree field. Use '/' as a separator if more than one tree level is used. Press the button next to the field to view the tree. |
| Town |
Line of text field This is an authority controlled field. |
| UserDate1 to UserDate9 | Date field |
| UserInteger1 to UserInteger9 | Integer field |
| UserNumber1 to UserNumber9 | Number field |
| UserPeriod1 to UserPeriod9 | Period field |
| UserText1 to UserText9 | Line of text field |
| UserText01 to UserText99 | Wrapped text field |
| UserUnique1 to UserUnique9 |
Line of text field This is a unique field. |
| Venue |
Line of text field This is an authority controlled field which displays entries from the Set field in the Places database. |
| VenueNote | Wrapped text field |
| VenueTree |
Line of text field You will receive an error message if you try to save a Work record with more than one VenueTree field, if the One-per-record validation option is set in the Record drop down menu. This is a Tree field. Use '/' as a separator if more than one tree level is used. Press the button next to the field to view the tree. This is a unique field. |
| WorkCode |
DO NOT DELETE Line of text field Hidden This is a unique field. You will receive an error message if you try to save a Work record with more than one WorkCode field, if the One-per-record validation option is set in the Record drop down menu. This is a Tree field. Use '/' as a separator if more than one tree level is used. This is a mandatory field. A serial number (prefixed by 'Work' 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. |