Events

events: A distinct happening defined by title, date/s and venue; typically, a performance or series of performances at a Venue. This is the core table of Ausstage. Multiple presentations of the same production at different Venues (eg touring productions) are recorded as separate Events.

event_name: The title or name of an Event. Free text. Using preceding capitals except for articles, prepositions and pronouns. Mandatory.

umbrella: The festival or series in which an Event is presented. Enter only if applicable. Free text.

venueid: The unique number identifying the Venue at which the Event occurred. Displayed as Venue name, suburb, state (if Australia) or country (if overseas). Unique.

ddfirst_date: The day of the Event's first public presentation even if a preview. Enter as numerals. Display as numerals.

mmfirst_date: The month of the Event's first public presentation, even if a preview. Enter as numerals. Display as text.

yyyyfirst_date: The year of the Event's first public presentation even if a preview. Enter as numerals. Displayed as numerals. Mandatory.

sndfirst_date: The date of the Event's first public showing, even if preview. Automatically generated.

ddopening_night: The day of the Event's opening public showing - not a preview. Enter as numerals. Displayed as numeric.

mmopening_night: The month of the Event's opening public showing - not a preview. Enter as numerals. Display as text.

yyyyopening_night: The year of the Event's opening public showing - not a preview. Enter as numerals. Displayed as numeric.

sndopening_night: The date of the Event's opening public showing - not a preview. Automatically generated.

ddlast_date: The day of the Event's last public presentation. Enter as numerals. Displayed as numerals.

mmlast_date: The month of the Event's first public presentation. Enter as numerals. Display as text.

yyyylast_date: The year of the Event's first public showing. Enter as numerals. Displayed as numerals.

sndlast_date: The date of the Event's last public showing. Automatically generated.

estimated_dates: Are the Event's dates are estimated? Binary selection: either yes or no.

status: The socio-economic status of the production of an Event. Encompasses a range from professional to amateur. Select from the controlled list. Mandatory.

world_premier: Is the Event a world premiere (being presented for the very first time)? Binary selection: either yes or no.

part_of_a_tour: Is the Event is part of a touring production? Binary selection: either yes or no.

description: A short description of the content or significance of the Event. Free text. Preferably derived from an existing resource and referenced in Description Source. Add referenced resource to the Resource table.

description_source: Denoting the source of the Event description entered in the free text field above. To be chosen from controlled list.

primary_genre: A category indicating the kind of Event, as defined by its main mode of performance. Select from the controlled list, noting associations between primary and secondary genres. 'Other' is to be used only as a last resort. Mandatory.

further_information: Any additional relevant information about the Event not already covered by the available fields. Not to be confused with Event description, which aims to summarise the content of the Event. Free text.

event status: Dropdown selection of Cancelled, Completed, Partially Cancelled or Postponed. This field was introduced during the COVID-19 pandemic to cater for changing Event scheduling.

review: Is the record reviewed? Binary selection: either yes or no. If yes, displayed as username of reviewer (from updated_by_user) and date.

eventid: A unique number identifying an Event. Automatically generated. Unique.

entered_by_user: The username of the user entering the data. Entered automatically.

dddate_entered,mmdate_entered, yyyydate_entered, snddate_entered: Dates of entering by the user. Entered automatically.

updated_by_user: The username of the user updating the data. Entered automatically.

dddate_updated, mmdate_updated, yyyydate_updated, snddate_updated: Dates of update by the user. Entered automatically.

Contributor

contributor: An individual who contributes in some capacity to the conception, production or presentation of an event. Contributors are distinguished by their name and date of birth. A new record is created when a Contributor changes name; former and subsequent names are recorded in the Other_Names field. Multiple Contributors with the same name should be distinguished by date of birth and function. Care should be taken to avoid unnecessary duplicates, with particular attention being paid to variations in spellings of the same Contributor. Contributors must be an individual, and may be human or non-human (eg animal, machine).

prefix: A Contributor's title. Mr, Mrs, Prof, Dr etc.

first_name: The Contributor's first name or initial. Free text, with capitalised initial letter. Use a hyphen if there is no first name. Mandatory.

middle_name: A Contributor's middle name/s or initial/s. Free text, with capitalised initial letter.

last_name: The Contributor's last name/s. Free text, with capitalised initial letter. Use a hyphen if there is no last name. Mandatory.

suffix: A Contributor's suffix. OAM, PhD, AM etc.

display_name: The Contributor's first name and last name. Auto generated by concatenating the First Name and Last Name, but editable.

other_names: Other names by which the Contributor is known. May include stage names, former or subsequent names, or alternative spellings of the First and Last Names. Free text, in natural order, with capitalised initial letter. Separate multiple names with ;.

gender: The Contributor's gender. Select either female or male.

nationality: The Contributor's nationality, whether by origin or adoption. Free text, with capitalised initial letter. Prefer self-identified nationality; consult Contributor if possible; otherwise nationality of origin. Hyphenated nationalities are acceptable.

place_of_birth: A Contributor's place of birth. Select from venue table.

place_of_death: A Contributor's place of death. Select from venue table.

dddate_of_birth: The day of the Contributor's birth. Enter as numerals. Display as numeric. Not visible to users on the public side, unless date of death is complete.

mmdate_of_birth: The month of the Contributor's birth. Enter as numerals. Display as text. Not visible to users on the public side, unless date of death is complete.

yyyydate_of_birth: The year of the Contributor's birth. Enter as numerals. Display as numerals. Not visible to users on the public side, unless date of death is complete.

dddate_of_death: The day of the Contributor's death. Enter as numerals. Display as numerals. Source from published obituaries or research publications.

mmdate_of_death: The month of the Contributor's death. Enter as numerals. Display as text. Source from published obituaries or research publications.

yyyydate_of_death: The year of the Contributor's death. Enter as numerals. Display as numerals. Source from published obituaries or research publications.

notes: Additional biographical information about the Contributor. Recommended use is to draw biographical information from published sources (Australian Dictionary of Biography, Parson's Companion to Theatre in Australia, and so on) or invite Contributor to provide information. Note source at end of field. Free text.

nla: The Contributor's Persistent Identifier at the National Library of Australia. Source from the National Library of Australia.

contributorid: A unique number identifying a Contributor. Automatically generated. Unique.

entered_by_user: The username of the user creating the record. Entered automatically on creation.

entered_date: The date when the record is created. Entered automatically on creation.

updated_by_user: The username of the user updating the data. Entered automatically on update.

updated_date: The date when the record is last updated. Entered automatically on update.

address: The Contributor's house and street address of residency. Free text. Use only when provided by Contributor. Not visible to users on public side.

suburb: The Contributor's suburb address of residency. Free text. Use only when provided by Contributor. Not visible to users on the public side.

state: The Contributor's state address of residency. Select from controlled list. Use only when provided by Contributor. Not visible to users on the public side.

email: The Contributor's email address. Free text. Use only when provided by Contributor. Not visible to users on the public side.

postcode: The Contributor's postcode of residency. Four-digit numeral. Use only when provided by Contributor. Not visible to users on the public side.

countryid: A unique number identifying the Contributor's country of residence. Select from Country table. Use only when provided by Contributor. Unique.

Venue

venue: A place where an Event happens. Venues are distinguished by their name and location. A new record is created when a Venue changes name.

venueid: A unique number identifying a Venue. Different venues with the same name are given different IDs. Unique.

venue_name: The name of a Venue. To be typed as free text. Care must be taken to prevent unnecessary duplicates, especially as some duplicates are justified by Venues with the same name in different locations. Where a Venue is located within a larger 'parent' venue it is given its own Venue record with the name of the Venue it is located within in the Other Names field.

other_names1: An additional or alternative name by which the Venue is known. Free text. Used for former or subsequent names of Venue, or names of related Venues either smaller 'child' Venues within, or larger 'parent' venues.

other_names2: An additional or alternative name by which the Venue is known. Free text. Used for former or subsequent names of Venue, or names of related Venues either smaller 'child' Venues within, or larger 'parent' venues.

other_names3: An additional or alternative name by which the Venue is known. Free text. Used for former or subsequent names of Venue, or names of related Venues either smaller 'child' Venues within, or larger 'parent' venues.

street: The number and street of the Venue’s address. Free text.

suburb: The suburb of the Venue's address. Free text.

state: The state of the Venue's address. Select from controlled list.

postcode: The postcode of the Venue's address. Free text.

capacity: The number of spectators to which the Venue can present an Event. Prefer the highest number of the most common configuration. To be typed as a number.

contact: The name of a contact person for the Venue. Free text, with capitalised initials. Not visible on the public side.

phone: A contact telephone number for the Venue. Free text, numerically, including area codes. Format +xx x xxxx xxxx. Not visible on the public side.

fax: A contact fax number for the Venue. Free text, numerically, including area codes. Format +xx x xxxx xxxx. Not visible on the public side.

email: A contact email address for the Venue. Free text. Not visible on the public side.

web_links: A website address or URL for the Venue. Free text. 'http://' is required.

notes: Any other relevant information about the Venue not covered by other fields. Free text.

country: The country in which the Venue is located. Select from controlled list.

countryid: The identifier for the country in which the Venue is located.

longitude: The longitudinal geographic coordinate of the Venue. Free text, numerically, in decimals to five decimal points.

latitude: The latitudinal geographic coordinates of the Venue. Free text, numerically, in decimals to five decimal points.

regional_or_metro: Indicates whether the location of the Venue is within a specified type of area. Select from controlled list, eg regional, suburban, metroplitan.

elevation: The geographic measurement of elevation of the Venue.

radius: The measurement surrounding the longitude and latitude fields to which the Venue is accurate.

ddfirst_date: A two-digit number denoting the first day of existence of the Venue using the title denoted in name. Free text. Use leading zeros for single digit days.

mmfirst_date: A two-digit number denoting the first month of existence of the Venue using the title denoted in name. Free text. Use leading zeros for single digit months.

yyyyfirst_date: A four-digit number denoting the first year of existence of the Venue using the title denoted in name. Free text.

ddlast_date: A two-digit number denoting the last day of existence of the Venue using the title denoted in name. Free text. Use leading zeros for single digit days.

mmlast_date: A two-digit number denoting the last month of existence of the Venue using the title denoted in name. Free text. Use leading zeros for single digit months.

yyyylast_date: A four-digit number denoting the last year of existence of the Venue using the title denoted in name. Free text.

Organisation

organisation: A group or company involved in the conception, production or presentation of an event. Organisations are distinguished by their name and location. A new record is created when an Organisation changes name.

organisationid: A unique number identifying an Organisation. Organisations that share the same name are given different IDs. Unique.

name: The name of the Organisation. Free text. Care must be taken to prevent unnecessary duplicates.

other_names1: Other names by which the Organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.

other_names2: Other names by which the Organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.

other_names3: Other names by which the Organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.

address: The number and street of the Organisation's address. Free text.

suburb: The suburb, town or locality of the Organisation's address. Free text.

state: The state of the Organisation's address. Select from controlled list.

postcode: The postcode of the Organisation's address. Free text.

contact: The name of a contact person for the Organisation. Free text, with capitalised initials. Not visible on the public side.

phone1: A contact telephone number for the Organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, eg box office, administration.

phone2: A contact telephone number for the Organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, eg box office, administration.

phone3: A contact telephone number for the Organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, eg box office, administration.

fax: A contact fax number for the Organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx.

email: A contact email address for the Organisation. Free text. Not visible on the public side.

web_links: A website address for the Organisation. Free text. 'http://' is required.

notes: Any other relevant information about the Organisation not covered by other fields. Free text.

countryid: A unique number identifying a country. Select from controlled list. Unique.

ddfirst_date: A two-digit number denoting the first day of existence of the Organisation using the title denoted in name. Free text. Use leading zeros for single digit days.

mmfirst_date: A two-digit number denoting the first month of existence of the Organisation using the title denoted in name. Free text. Use leading zeros for single digit months.

yyyyfirst_date: A four-digit number denoting the first year of existence of the Organisation using the title denoted in name. Free text.

ddlast_date: A two-digit number denoting the last day of existence of the Organisation using the title denoted in name. Free text. Use leading zeros for single digit days.

mmlast_date: A two-digit number denoting the last month of existence of the Organisation using the title denoted in name. Free text. Use leading zeros for single digit months.

yyyylast_date: A four-digit number denoting the last year of existence of the Organisation using the title denoted in name. Free text.

place_of_origin: An Organisation place of origin. Select from Venue table.

place_of_demise: An Organisations place of demise. Select from Venue table.

Work

work: A Work is the abstract conception of an Event, typically (though not always) expressed as a material resource, such as a script or score.

workid: A unique number identifying a Work. Unique.

work_title: A name identifying a Work. Prefer the original name, as conceived by creator.

alternative_work_title: Alternative names for a Work. Use for alternative names, translations of name and variant spellings.

Resource

item: A Resource is a text, image, object, recording or the like which relates to an Event, or to a Contributor, Organisation or Venue, or to a Work, genre, content indicator or other Resource. Some resources exist as individual items stored in collections (like programs, posters, photographs and so on). Other Resources exist as multiple copies in libraries (books, journals, articles and so on). The fields for the Resource table augment the existing AusStage Item table with fields drawn from the Dublin Core Metadata Element set. Not all fields will be relevant to each type of Resource.

itemid: A unique number identifying a Resource (Item). Unique.

resource type: The type of Resource. Controlled list, based on the Dublin Core Metadata Initiative Type.

vocabulary: Collection, Dataset, Event, Image, InteractiveResource, MovingImage, PhysicalObject, Service, Software, Sound, StillImage and Text.

resource sub type: A more specific designation of the type of Resource. Chosen from a set of sub types associated with each main Resource Type. The set of sub types is expandable. Changes made on request; prefer existing terms.
title: A name given to a Resource. For example, the title of a book, a chapter or an article; a caption for a photograph or illustration. To be entered as free text. Use leading capitals except for articles, prepositions and pronouns.
title alternative: An alternative name given to a Resource. Multiple names separated by ; .

resource contributor: An agent responsible for contributing to the Resource. To include a mandatory Resource Creator (ResourceCreator [ContributorID/s]). This is the agent primarily responsible for creating the resource. For example, the author of an article, chapter or book; the photographer of a photo; the designer for a set design. Each creator or contributor will be listed as either Individual or Organisation, with a list of numerically ordered functions to choose from.

contributor id: A Contributor (or Contributors) to which the Resource refers. Contributor associations are created where a Resource depicts or describes a contributor. Use ResourceCreator or ResourceContributor where a Contributor creates or contributes to a Resource.

abstract/description: A description or abstract of the content of the Resource.

comments: Notes or comments on the content of the Resource.

source: The Resource from which the described Resource is derived. Used for Resources which are included within or part of other Resources. For example, the newspaper is the source for a newspaper article; the journal is the source for a journal article; an anthology is the source for a chapter; a collection is the source for an item within that collection.

resource id: Another Resource (or resources) related in some way to the current Resource. The relation is qualified according to type using the Dublin Core relation qualifiers.

publisher: An agent or organisation responsible for making the Resource available. For example, the publisher of a book.

publisher location: The location of the agent or organisation responsible for making the Resource available.

volume: The volume number identifying the part of a Source in which a Resource is located. For example, the volume number of the journal in which an article is published.

issue: The issue number identifying the part of a Source in which a Resource is located. For example, the issue number of the journal in which an article is published.

page: The page number or page range indicating where a Resource is located in a Source. For example, the page number of a newspaper article, or the page range of a journal article or chapter in a book.

citation: A text string unambiguously identifying the Resource, for example a bibliographic citation for an article, chapter of book. This is automatically generated from information provided in other fields. It will include ResourceCreator, Title, Source, Date, Publisher and other identifying and finding information appropriate to the Resource type.

date created – day: Date when the record is created. Automatically generated.

date created - month

date created - year

date of issue – day: Date of publication of the Resource.

date of issue - month

date of issue - year

date of copyright – day: Date of a statement of copyright in the Resource.

date of copyright - month

date of copyright - year

date accessioned – day: Date of the accessioning of the Resource. Used for material items stored in collections.

date accessioned - month

date accessioned - year

date notes: Notes or comments on date information. For example, if dates are estimated.

catalogue id: A unique identifier given to a Resource which is part of a collection. Used for material items stored in collections. Unique.

holding institution: The name of the organisation which holds the Resource. Used for material items stored in collections.

storage: A description of how and where the Resource is stored. Used for material items, stored in collections.

donated/purchased: Indicate whether Resource is donated to or purchased. Used for material items stored in collections.

from: Person or organisation from whom the Resource was obtained. Used for material items stored in collections.

provenance: Statement of the provenance of the Resource. Used for material items stored in collections.

significance: Statement of the significance of the Resource. Used for material items stored in collections.

resource condition: An indication of the physical condition of the Resource. Used for material items, stored in collections.

detail comments: Comments on the physical condition of the Resource. Used for material items, stored in collections.

rights: A statement of copyright in the Resource.

rights holder: An agent (or agents) asserting copyright in the Resource.

access rights: Conditions regarding rights or restrictions to access the Resource.

resource language: The language/s of the Resource is in, where the Resource has language content.

medium: The physical medium of the Resource. Used for material items, stored in collections.

extent: The physical dimensions of the Resource. Used for material items, stored in collections.

mimetype: The file format of the Resource designated by Multipurpose Internet Mail Extensions (MIME). Used for digital items.

format: Other information relating to the file format, physical medium or dimensions of the Resource.

resource url: A unique Uniform Resource Locator for the resource. Used for digital resources which are publicly and persistently accessible. Unique.

international standard book number: Unique identifier assigned to a book. Unique.

international standard music number: Unique identifier assigned to a piece of music. Unique.

international standard serial number: Unique identifier assigned to a serial (journal, magazine, newspaper). Unique.

serial resource and contribution number: Unique identifier assigned to an article published as part of a serial. Unique.

event id: An Event (or Events) associated with or referred to by the Resource. Event associations will be created where a Resource is created in the process of making or responding to an Event.

contributor id: A Contributor (or Contributors) to which the Resource refers. Contributor associations are created where a resource depicts or describes a Contributor. Use ResourceCreator or ResourceContributor where a Contributor creates or contributes to a Resource.

organisation id: An Organisation (or Organisations) to which the Resource refers. Organisation associations are created where a Resource depicts or describes an Organisation. Not to be mistaken with the Resource Contributor of Creator.

venue id: A Venue (or Venues) to which the Resource refers. Venue associations will be created where a Resource depicts or describes a Venue.

work id: A Work (or Works) to which the Resource refers. Work associations will be created where a Resource relates, for example, to a dramatic Work, than to an actual production.

genre id: A Genre (or Genres) to which the Resource refers or relates. Genre associations will be created where a Resource relates, for example, to a performance Genre, rather than particular productions.

content indicator id: A Content Indicator (or Content Indicators) to which the Resource refers or relates. Content Indicator associations will be created where a Resource relates to a particular Subject, rather than actual productions.

resource id: Another Resource (or Resources) related in some way to the current Resource. The relation is qualified according to type using the Dublin Core relation qualifiers.

created by user: User who created the record. Automatically generated.

date created – day: Date when the record is created. Automatically generated.

date created - month:

date created - year:

update by user: User who last updated the record. Automatically generated.

date updated – day: Date when the record is last updated. Automatically generated.

date updated - month:

date updated - year:

Financial

financial record: An AusStage Financial Record is monetary information collated in a financial format in relation to a Contributor or an Organisation.

1 General Information

financial_id: Automatically generated ID number for the record (populates on record saving).

2 Associated Contributor or Organisation*

*Selection of either a Contributor of Organisation is Mandatory.

contributorid: A unique number identifying a Contributor. Automatically generated. Unique.

first_name: The Contributor's first name or initial. Free text, with capitalised initial letter.

last_name: The Contributor's last name/s. Free text, with capitalised initial letter. Use a hyphen if there is no last name.

OR

organisationid: A unique number identifying an Organisation. Organisations that share the same name are given different IDs. Unique.

name: The name of the Organisation. Free text. Care must be taken to prevent unnecessary duplicates.

3 Financial Period

financial_period: Select either a Calendar or Financial Year from the dropdown list.

NOTE: Items 2 Associated Contributor or Organisation and 3 Financial Period will automatically appear at the top of each Financial Record data entry screen.

4 Income

total_income: Only enter a figure in this field if it approximates to the TOTAL income for the Contributor or Organisation for the time period.

actual or estimated: Select either actual or estimated based on the source data accuracy/exact specification.

notes: Add notes relevant to this income field.

NOTE: the above actual or estimated and notes fields appear with all Income and Expenditure fields. These are always relevant to the field they are associated with.

4(a) Federal Government Income

total_income: If using a data source that is from a federal grant body and there are no other figures provided for this Organisation or Contributor, place the one figure available in this field. Duplicate it below if there is another appropriate field.

australia_council: Data entered in this field or sub fields is from Australia Council sources such as financial reports or grant acquittal data.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

tour_–_national: If figures for more than one national tour are provided add a new line for each and use notes to specify tour details.

tour_–_international: If figures for more than one international tour are provided add a new line for each and use notes to specify tour details.

department_of_foreign_affairs: Data entered in this field may come from any number of funding programs covered by the Department of Foreign Affairs eg Bilateral councils.

department_of_education: Data entered in this field may come from any number of funding programs covered by the Department of Education.

department_of_tourism: Data entered in this field may come from any number of funding programs covered by the Department of Tourism.

department_of_social_services: Data entered in this field may come from any number of funding programs covered by the Department of Social Services. NDIS grants are included in this field.

other_federal: Data entered in this field may come from any other number of federal funding programs not covered in other categories.

4(b) State, Local & Overseas Government Income

total_state: If using a data source that is from a state grant body and there are no other figures provided for this Organisation or Contributor, place the one figure available in this field. Duplicate it below if there is another appropriate field.

NSW: Only record entries for New South Wales in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

SA: Only record entries for South Australia in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

VIC: Only record entries for Victoria in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

QLD: Only record entries for Queensland in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

TAS: Only record entries for Tasmania in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

WA: Only record entries for Western Australia in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

ACT: Only record entries for the Australian Capital Territory in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

NT: Only record entries for the Northern Territory in this field.

recurrent_funding: This is the annual amount from the Recurrent Operating Budget for the 12 month period of this Financial Record.

project_funding: This field is for everything other than recurrent or touring grants. Add a new line for each figure and provide notes regarding grant category.

other_funding: This field is for touring grants, regional grants and everything else.

income_local: Record all local government/council funding in this field.

income_overseas: Record all funding sources received from overseas sources in this field.

4(c) Non Government Income

total_ngi: This field is for all Non-Government income. If there is information about the source record it in the notes field.

commercial_investment: This field is for the total investment from commercial sources. Only use this field if there is a total, otherwise break it down separately in the fields below. If there is information about the source record it in the notes field.

national: Record all Australian Non-Government commercial investment in this field.

national_individual: If there are figures of investment by Australian individuals record it in this field with details in the notes.

national_corporate: If there are figures of investment by Australian corporations record it in this field with details in the notes.

international: If there are figures of investment by international individuals and/or corporations record it in this field with details in the notes. Add a new line to separate individuals and corporations.

sponsorship: Record the total of sponsorship received in this field if no further breakdown is available.

cash: Record the total of sponsorship cash in this field.

contra: Record the total of sponsorship contra (indicative value) in this field.

voluntary_contributions: Record the total amount received for voluntary contributions (indicative value) in this field.

foundations: Record the total amount received for trusts and foundations in this field. Use a new line for each entry and provide notes if available.

individual_donors: Record the total amount of donations in this field.

crowd_sourcing: Record income from crowd sourcing in this field.

memberships: Record income from membership fees in this field.

events: Record income fundraised from special events in this field.

fundraising: Record all other forms of fundraising income in this field.

4(d) Earned Income

total_earned: If there is a figure cited as total earned income enter it in this field.

box_office: Record only the figure for total box office or ticket sales in this field. If the figures are broken down into the sub-categories below list them separately with information in the notes field.

annual: Record an annual general ticket sales figure in this field. This could include over the counter ticket sales and ticketing agencies.

subscriptions: Record subscription purchases in this field.

seasons_of_performance: Record purchases to season passes in this field.

single_performance: Only enter a figure in this field if the category represents what is contained in the data source.

touring_performance: If you have a figure indicating income from touring performances enter it in this field.

co-production: Show income received through co-productions in this field.

performance_fees: Record the total income paid directly to the contributor or organisation for performance fees in this field.

education_programs: Record amounts received for education and workshop programs in this field.

merchandise: Record amounts received for goods in this field.

other_earned: Show amounts received for services not listed above such as car-parking, venue hire etc in this field.

4(e) In Kind

total_in_kind: Record the value of goods or services provided for no payment in this field (indicative value).

artistic: Record any in-kind services supplied by artists for no payment in this field (indicative value).

administrative: Record any in-kind services supplied by administration for no payment in this field (indicative value).

volunteers: Record any in-kind services supplies by volunteers for no payment in this field (indicative value).

goods_&_services: Record any in-kind goods & services provided for free in this field (indicative value).

performance_space: Record any in-kind space provided for free in this field (indicative value).

4(f) Any Other Income

other_income: Record amounts listed as Sundry or Other Income in this field.

5 Expenses

total_expenditure Only enter a figure here it approximates to the TOTAL expense for the Contributor or Organisation for the time period.

actual or estimated: Select either actual or estimated based on the source data accuracy/exact specification.

notes: Add notes relevant to this expense field.

NOTE: the above actual or estimated and notes fields appear with all Income and Expenditure fields. These are always relevant to the field they are associated with.

5(a) Salaries and fees

total salaries/fees: If there is a figure cited as total salaries/fees enter it in this field.

office/admin: Record the amount paid to office/admin personnel in this field.

technical: Record the amount paid to technical/production staff in this field. If the financial data refers to this amount as creatives use the creatives field below instead.

artists: Record all salaries/fees paid to artists in this field. If Artists Fees appear to be listed separately to other Salaries/Fees provide notes in the note field.

creatives: Record any salaries or fees paid to creatives (eg Designers, Choreographers etc) in this field.

musicians: Record salaries/fees paid to musicians in this field.

dancers: Record salaries/fees paid to dancers in this field.

actors: Record salaries/fees paid to actors in this field.

5(b) Production Costs

total_production: Record the total of all production costs in this field.

physical: Record physical production costs in this field.

tech_hires: Record technical hire charges in this field.

vnue_charges: Record Venue charges in this field.

online/stream: Record online or streaming related charges in this field.

administration: Record administration costs in this field.

pr/marketing: Record expenses relating to public relations, marketing and advertising in this field.

touring_costs: Record total expenses relating to touring costs in this field. If the financial data specifies travel costs use the travel field below instead.

national: Record the total costs for touring nationally in this field.

travel: Record travel costs relating to national touring in this field. Use the international field for travel overseas.

accommodation/living: Record accommodation and living expenses/per diems within Australia in this field.

freight: Record the total cost of freight within Australia in this field.

other_national_cost: Record any other national touring costs not specified elsewhere in this field.

international: Record costs relating to all international touring in this field.

5(c) All Other Expenses

capital_expenditure: Record any expenses purchasing plant/equipment as assets in this field.

intellectual_property: Record any costs relating to payments to securing intellectual property or copyright permission in this field.

research_&_development: Record all costs relating to research and development for new works in this field.

other_expenditure: Record the amount listed as other expenditure or sundry expenses in this field. Do not attempt to add up any other figures.

6 Resources

itemid: A unique number identifying a Resource.

title: A name given to a Financial Resource. For example, the title of a digitally and publicly available annual report or financial report to be associated with the Financial Record. To be entered as free text. Use leading capitals except for articles, prepositions and pronouns.

7 Further Financial Data Information

further_information: Enter any further information relevant to the whole Financial Record in this field.

8 Data Entry Information

financial ID: Automatically generated ID number for the record (populates on record saving).

created_by: User who entered the record. Automatically generated.

date_created: Date when the record was created. Automatically generated.

updated_by_user: User who last updated the record. Automatically generated.

date_updated: Date when the record was last updated. Automatically generated.

Data Models

Events

Contributor

Venue

Organisation

Work

Resource

Financial

Controlled vocabularies

Genres

Functions

Subjects

Resource Types