Complete Field List
The only default fields that appear in the
Performance record template are Creator and Created. It is entirely up to
individual organisations how they wish to use this record type but we would
suggest adding the following fields (headings in capital letters): IDENTITY,
PerfCode, IDENTIFICATION, Title, AltTitle, SHOW DETAILS, Venue, VenueNote,
Company, Orchestra, PerformanceType, PerformanceNote, PerformanceLength,
FirstPerformed, OpeningNight, PressNight, LastPerformed, NoPerformances, GENERAL
DETAILS, Awards, Sponsors, BOX OFFICE, SeatValue, SeatsSold, ADMIN DETAILS,
Modifier and Modified.
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 Performance 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.
PERFORMANCE 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 |
| Creator | Identifier field |
| CreativeRole | Hidden |
| FirstPerformed | Period field |
| GENERAL_DETAILS | This field is displayed as a section heading and cannot have content typed into it. |
| GenNotes | Wrapped text field |
| HeaderCode |
Line of text field Hidden |
| 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 Performance 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 Performance 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 field |
| 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 |
| PerfCode |
Line of text field This is a unique field. You will receive an error message if you try to save a Performance record with more than one PerfCode 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 'PERF' 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. |
| 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 Performance 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 this field to insert a term from the Subject thesaurus |
| Time | Text field |
| Title |
Wrapped text field This is an authority controlled field. |
| Town |
Line of text field This is an authority controlled field. |
| TransferFrom |
Line of text field Press the button next to this field to find the previous performance. |
| TransferTo |
Line of text field Press the button next to this field to find the next performance. |
| 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 Performance 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, press the button next to the field to view the tree. Use '/' as a separator if more than one tree level is used. This is a unique field. |