view: performer_salesforce_combined {
  derived_table: {
    sql:
      SELECT
          -- --- CONTRIBUTOR TABLE (Prefix: CONTRIBUTOR_) ---
          contributor.ID AS CONTRIBUTOR_ID,
          contributor.OWNER_ID AS CONTRIBUTOR_OWNER_ID,
          contributor.IS_DELETED AS CONTRIBUTOR_IS_DELETED,
          contributor.NAME AS CONTRIBUTOR_NAME,
          contributor.CREATED_DATE AS CONTRIBUTOR_CREATED_DATE,
          contributor.CREATED_BY_ID AS CONTRIBUTOR_CREATED_BY_ID,
          contributor.LAST_MODIFIED_DATE AS CONTRIBUTOR_LAST_MODIFIED_DATE,
          contributor.LAST_MODIFIED_BY_ID AS CONTRIBUTOR_LAST_MODIFIED_BY_ID,
          contributor.SYSTEM_MODSTAMP AS CONTRIBUTOR_SYSTEM_MODSTAMP,
          contributor.LAST_VIEWED_DATE AS CONTRIBUTOR_LAST_VIEWED_DATE,
          contributor.LAST_REFERENCED_DATE AS CONTRIBUTOR_LAST_REFERENCED_DATE,
          contributor.ACCOUNT_PRIORITY_C AS CONTRIBUTOR_ACCOUNT_PRIORITY_C,
          contributor.ADDRESS_TYPE_C AS CONTRIBUTOR_ADDRESS_TYPE_C,
          contributor.ARTIST_NAME_TYPE_C AS CONTRIBUTOR_ARTIST_NAME_TYPE_C,
          contributor.BANK_CURRENCY_C AS CONTRIBUTOR_BANK_CURRENCY_C,
          contributor.BANK_DETAILS_FORMAT_C AS CONTRIBUTOR_BANK_DETAILS_FORMAT_C,
          contributor.BANK_STATUS_C AS CONTRIBUTOR_BANK_STATUS_C,
          contributor.CITIZENSHIP_TERRITORY_2_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_C,
          contributor.CITIZENSHIP_TERRITORY_3_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_C,
          contributor.CITIZENSHIP_TERRITORY_4_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_C,
          contributor.CITIZENSHIP_TERRITORY_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_C,
          contributor.CONTRIBUTOR_TYPE_C AS CONTRIBUTOR_CONTRIBUTOR_TYPE_C,
          contributor.COUNTRY_TAX_C AS CONTRIBUTOR_COUNTRY_TAX_C,
          contributor.COUNTRY_C AS CONTRIBUTOR_COUNTRY_C,
          contributor.COUNTRY_OF_BIRTH_C AS CONTRIBUTOR_COUNTRY_OF_BIRTH_C,
          contributor.COUNTRY_OF_RESIDENCE_C AS CONTRIBUTOR_COUNTRY_OF_RESIDENCE_C,
          contributor.EU_PAYEE_VAT_COUNTRY_C AS CONTRIBUTOR_EU_PAYEE_VAT_COUNTRY_C,
          contributor.EU_PAYEE_VAT_REGISTERED_C AS CONTRIBUTOR_EU_PAYEE_VAT_REGISTERED_C,
          contributor.ENTITY_C AS CONTRIBUTOR_ENTITY_C,
          contributor.GENDER_C AS CONTRIBUTOR_GENDER_C,
          contributor.PAYEE_TYPE_C AS CONTRIBUTOR_PAYEE_TYPE_C,
          contributor.RELATIONSHIP_TYPE_C AS CONTRIBUTOR_RELATIONSHIP_TYPE_C,
          contributor.RESIDENCY_TERRITORY_2_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_2_C,
          contributor.RESIDENCY_TERRITORY_3_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_3_C,
          contributor.RESIDENCY_TERRITORY_4_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_4_C,
          contributor.RESIDENCY_TERRITORY_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_C,
          contributor.STATUS_C AS CONTRIBUTOR_STATUS_C,
          contributor.US_BANK_ACCOUNT_TYPE_C AS CONTRIBUTOR_US_BANK_ACCOUNT_TYPE_C,
          contributor.US_PAYEE_TIN_TYPE_C AS CONTRIBUTOR_US_PAYEE_TIN_TYPE_C,
          contributor.US_PAYEE_TAX_CLASSIFICATION_C AS CONTRIBUTOR_US_PAYEE_TAX_CLASSIFICATION_C,
          contributor.US_PAYEE_TAX_FORM_TYPE_C AS CONTRIBUTOR_US_PAYEE_TAX_FORM_TYPE_C,
          contributor.US_WHT_REPORTING_REQUIREMENT_C AS CONTRIBUTOR_US_WHT_REPORTING_REQUIREMENT_C,
          contributor.AUD_BSB_C AS CONTRIBUTOR_AUD_BSB_C,
          contributor.ADDITIONAL_DETAILS_ADDRESS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_ADDRESS_C,
          contributor.ADDITIONAL_DETAILS_BANK_DETAILS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_BANK_DETAILS_C,
          contributor.ADDITIONAL_DETAILS_INSTRUCTIONS_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_INSTRUCTIONS_C,
          contributor.ADDITIONAL_DETAILS_NAME_C AS CONTRIBUTOR_ADDITIONAL_DETAILS_NAME_C,
          contributor.ADDRESS_DESCRIPTION_C AS CONTRIBUTOR_ADDRESS_DESCRIPTION_C,
          contributor.ADDRESS_LINE_1_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_1_TAX_C,
          contributor.ADDRESS_LINE_2_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_2_TAX_C,
          contributor.ADDRESS_LINE_3_TAX_C AS CONTRIBUTOR_ADDRESS_LINE_3_TAX_C,
          contributor.ADDRESS_TYPE_TEXT_C AS CONTRIBUTOR_ADDRESS_TYPE_TEXT_C,
          contributor.AGREEMENT_START_DATE_C AS CONTRIBUTOR_AGREEMENT_START_DATE_C,
          contributor.ALIASES_C AS CONTRIBUTOR_ALIASES_C,
          contributor.ARTIST_MUSIC_BRAINZ_ID_C AS CONTRIBUTOR_ARTIST_MUSIC_BRAINZ_ID_C,
          contributor.ARTIST_NAME_C AS CONTRIBUTOR_ARTIST_NAME_C,
          contributor.BAND_NAME_C AS CONTRIBUTOR_BAND_NAME_C,
          contributor.BANK_ACCOUNT_DESCRIPTION_C AS CONTRIBUTOR_BANK_ACCOUNT_DESCRIPTION_C,
          contributor.BANK_ACCOUNT_NAME_C AS CONTRIBUTOR_BANK_ACCOUNT_NAME_C,
          contributor.BANK_ACCOUNT_NUMBER_C AS CONTRIBUTOR_BANK_ACCOUNT_NUMBER_C,
          contributor.BANK_ADDRESS_C AS CONTRIBUTOR_BANK_ADDRESS_C,
          contributor.BANK_IBAN_C AS CONTRIBUTOR_BANK_IBAN_C,
          contributor.BANK_NAME_C AS CONTRIBUTOR_BANK_NAME_C,
          contributor.BANK_SORT_CODE_C AS CONTRIBUTOR_BANK_SORT_CODE_C,
          contributor.BANK_SWIFT_BIC_C AS CONTRIBUTOR_BANK_SWIFT_BIC_C,
          contributor.BENEFICIARY_ADDRESS_C AS CONTRIBUTOR_BENEFICIARY_ADDRESS_C,
          contributor.BENEFICIARY_NAME_C AS CONTRIBUTOR_BENEFICIARY_NAME_C,
          contributor.BIRTH_NAME_C AS CONTRIBUTOR_BIRTH_NAME_C,
          contributor.CITIZENSHIP_END_DATE_2_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_2_C,
          contributor.CITIZENSHIP_END_DATE_3_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_3_C,
          contributor.CITIZENSHIP_END_DATE_4_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_4_C,
          contributor.CITIZENSHIP_END_DATE_C AS CONTRIBUTOR_CITIZENSHIP_END_DATE_C,
          contributor.CITIZENSHIP_NOTES_2_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_2_C,
          contributor.CITIZENSHIP_NOTES_3_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_3_C,
          contributor.CITIZENSHIP_NOTES_4_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_4_C,
          contributor.CITIZENSHIP_NOTES_C AS CONTRIBUTOR_CITIZENSHIP_NOTES_C,
          contributor.CITIZENSHIP_START_DATE_2_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_2_C,
          contributor.CITIZENSHIP_START_DATE_3_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_3_C,
          contributor.CITIZENSHIP_START_DATE_4_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_4_C,
          contributor.CITIZENSHIP_START_DATE_C AS CONTRIBUTOR_CITIZENSHIP_START_DATE_C,
          contributor.CITIZENSHIP_TERRITORY_2_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_TEXT_C,
          contributor.CITIZENSHIP_TERRITORY_3_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_TEXT_C,
          contributor.CITIZENSHIP_TERRITORY_4_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_TEXT_C,
          contributor.CITIZENSHIP_TERRITORY_TEXT_C AS CONTRIBUTOR_CITIZENSHIP_TERRITORY_TEXT_C,
          contributor.CITY_TAX_C AS CONTRIBUTOR_CITY_TAX_C,
          contributor.CLIENT_OWNER_C AS CONTRIBUTOR_CLIENT_OWNER_C,
          contributor.COLLECTION_PERIOD_END_DATE_C AS CONTRIBUTOR_COLLECTION_PERIOD_END_DATE_C,
          contributor.CONTRIBUTOR_TYPE_TEXT_C AS CONTRIBUTOR_CONTRIBUTOR_TYPE_TEXT_C,
          contributor.CONTRIBUTOR_UUID_C AS CONTRIBUTOR_CONTRIBUTOR_UUID_C,
          contributor.COUNTRY_TAX_TEXT_C AS CONTRIBUTOR_COUNTRY_TAX_TEXT_C,
          contributor.COUNTRY_OF_BIRTH_TEXT_C AS CONTRIBUTOR_COUNTRY_OF_BIRTH_TEXT_C,
          contributor.EU_PAYEE_NI_NUMBER_C AS CONTRIBUTOR_EU_PAYEE_NI_NUMBER_C,
          contributor.EU_PAYEE_VAT_NUMBER_C AS CONTRIBUTOR_EU_PAYEE_VAT_NUMBER_C,
          contributor.EU_TAX_ID_C AS CONTRIBUTOR_EU_TAX_ID_C,
          contributor.EARLIEST_TERM_END_DATE_RAL_C AS CONTRIBUTOR_EARLIEST_TERM_END_DATE_RAL_C,
          contributor.EMAIL_ADDRESS_C AS CONTRIBUTOR_EMAIL_ADDRESS_C,
          contributor.ENTITY_TEXT_C AS CONTRIBUTOR_ENTITY_TEXT_C,
          contributor.FAX_NUMBER_C AS CONTRIBUTOR_FAX_NUMBER_C,
          contributor.FOREIGN_PAYEE_TAX_IDENTIFICATION_NUMBER_C AS CONTRIBUTOR_FOREIGN_PAYEE_TAX_IDENTIFICATION_NUMBER_C,
          contributor.FORENAME_C AS CONTRIBUTOR_FORENAME_C,
          contributor.IPDA_IPN_C AS CONTRIBUTOR_IPDA_IPN_C,
          contributor.IN_COLLECTION_C AS CONTRIBUTOR_IN_COLLECTION_C,
          contributor.INSTRUMENTS_C AS CONTRIBUTOR_INSTRUMENTS_C,
          contributor.KNR_ACCOUNT_ID_C AS CONTRIBUTOR_KNR_ACCOUNT_ID_C,
          contributor.MAIDEN_NAME_C AS CONTRIBUTOR_MAIDEN_NAME_C,
          contributor.MAIN_MUSIC_GENRE_C AS CONTRIBUTOR_MAIN_MUSIC_GENRE_C,
          contributor.MAIN_OCCUPATION_C AS CONTRIBUTOR_MAIN_OCCUPATION_C,
          contributor.MIDDLE_NAME_1_C AS CONTRIBUTOR_MIDDLE_NAME_1_C,
          contributor.MIDDLE_NAME_2_C AS CONTRIBUTOR_MIDDLE_NAME_2_C,
          contributor.NAME_SUFFICE_C AS CONTRIBUTOR_NAME_SUFFICE_C,
          contributor.NAME_C AS CONTRIBUTOR_NAME_C,
          contributor.NOTICE_SERVE_DATE_C AS CONTRIBUTOR_NOTICE_SERVE_DATE_C,
          contributor.OA_ACCOUNT_ID_C AS CONTRIBUTOR_OA_ACCOUNT_ID_C,
          contributor.PAYEE_NAME_C AS CONTRIBUTOR_PAYEE_NAME_C,
          contributor.PHONE_NUMBER_C AS CONTRIBUTOR_PHONE_NUMBER_C,
          contributor.POST_COLLECTION_NOTES_C AS CONTRIBUTOR_POST_COLLECTION_NOTES_C,
          contributor.PREFIX_C AS CONTRIBUTOR_PREFIX_C,
          contributor.PRIMARY_ADDRESS_C AS CONTRIBUTOR_PRIMARY_ADDRESS_C,
          contributor.RELATIONSHIP_DESCRIPTION_C AS CONTRIBUTOR_RELATIONSHIP_DESCRIPTION_C,
          contributor.REPERTOIRE_OWNER_C AS CONTRIBUTOR_REPERTOIRE_OWNER_C,
          contributor.RESIDENCY_END_DATE_2_C AS CONTRIBUTOR_RESIDENCY_END_DATE_2_C,
          contributor.RESIDENCY_END_DATE_3_C AS CONTRIBUTOR_RESIDENCY_END_DATE_3_C,
          contributor.RESIDENCY_END_DATE_4_C AS CONTRIBUTOR_RESIDENCY_END_DATE_4_C,
          contributor.RESIDENCY_END_DATE_C AS CONTRIBUTOR_RESIDENCY_END_DATE_C,
          contributor.RESIDENCY_NOTES_2_C AS CONTRIBUTOR_RESIDENCY_NOTES_2_C,
          contributor.RESIDENCY_NOTES_3_C AS CONTRIBUTOR_RESIDENCY_NOTES_3_C,
          contributor.RESIDENCY_NOTES_4_C AS CONTRIBUTOR_RESIDENCY_NOTES_4_C,
          contributor.RESIDENCY_NOTES_C AS CONTRIBUTOR_RESIDENCY_NOTES_C,
          contributor.RESIDENCY_START_DATE_2_C AS CONTRIBUTOR_RESIDENCY_START_DATE_2_C,
          contributor.RESIDENCY_START_DATE_3_C AS CONTRIBUTOR_RESIDENCY_START_DATE_3_C,
          contributor.RESIDENCY_START_DATE_4_C AS CONTRIBUTOR_RESIDENCY_START_DATE_4_C,
          contributor.RESIDENCY_START_DATE_C AS CONTRIBUTOR_RESIDENCY_START_DATE_C,
          contributor.RESIDENCY_TERRITORY_2_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_2_TEXT_C,
          contributor.RESIDENCY_TERRITORY_3_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_3_TEXT_C,
          contributor.RESIDENCY_TERRITORY_4_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_4_TEXT_C,
          contributor.RESIDENCY_TERRITORY_TEXT_C AS CONTRIBUTOR_RESIDENCY_TERRITORY_TEXT_C,
          contributor.RIGHTS_START_DATE_C AS CONTRIBUTOR_RIGHTS_START_DATE_C,
          contributor.SOCIETY_C AS CONTRIBUTOR_SOCIETY_C,
          contributor.STATE_TAX_C AS CONTRIBUTOR_STATE_TAX_C,
          contributor.SUFFIX_C AS CONTRIBUTOR_SUFFIX_C,
          contributor.SURNAME_C AS CONTRIBUTOR_SURNAME_C,
          contributor.TAX_ADDRESS_C AS CONTRIBUTOR_TAX_ADDRESS_C,
          contributor.TAX_FORM_EXPIRY_DATE_C AS CONTRIBUTOR_TAX_FORM_EXPIRY_DATE_C,
          contributor.TERM_END_DATE_C AS CONTRIBUTOR_TERM_END_DATE_C,
          contributor.TERM_END_NOTE_C AS CONTRIBUTOR_TERM_END_NOTE_C,
          contributor.TERM_NOTE_C AS CONTRIBUTOR_TERM_NOTE_C,
          contributor.TERMINATED_C AS CONTRIBUTOR_TERMINATED_C,
          contributor.TERRITORY_OF_REPRESENTATION_C AS CONTRIBUTOR_TERRITORY_OF_REPRESENTATION_C,
          contributor.US_PAYEE_TAX_IDENTIFICATION_NUMBER_C AS CONTRIBUTOR_US_PAYEE_TAX_IDENTIFICATION_NUMBER_C,
          contributor.US_PAYEE_TAX_NAME_C AS CONTRIBUTOR_US_PAYEE_TAX_NAME_C,
          contributor.WEB_ADDRESS_C AS CONTRIBUTOR_WEB_ADDRESS_C,
          contributor.ZIP_POST_CODE_TAX_C AS CONTRIBUTOR_ZIP_POST_CODE_TAX_C,
          contributor._FIVETRAN_DELETED AS CONTRIBUTOR_FIVETRAN_DELETED,
          contributor._FIVETRAN_SYNCED AS CONTRIBUTOR_FIVETRAN_SYNCED,

      -- --- SOCIETY REGISTRATION TABLE (Prefix: SOCIETY_) ---
      society.ID AS SOCIETY_ID,
      society.IS_DELETED AS SOCIETY_IS_DELETED,
      society.NAME AS SOCIETY_NAME,
      society.CREATED_DATE AS SOCIETY_CREATED_DATE,
      society.CREATED_BY_ID AS SOCIETY_CREATED_BY_ID,
      society.LAST_MODIFIED_DATE AS SOCIETY_LAST_MODIFIED_DATE,
      society.LAST_MODIFIED_BY_ID AS SOCIETY_LAST_MODIFIED_BY_ID,
      society.SYSTEM_MODSTAMP AS SOCIETY_SYSTEM_MODSTAMP,
      society.LAST_VIEWED_DATE AS SOCIETY_LAST_VIEWED_DATE,
      society.LAST_REFERENCED_DATE AS SOCIETY_LAST_REFERENCED_DATE,
      society.CONTRIBUTOR_C AS SOCIETY_CONTRIBUTOR_C,
      society.STATUS_C AS SOCIETY_STATUS_C,
      society.DATE_C AS SOCIETY_DATE_C,
      society.NOTES_C AS SOCIETY_NOTES_C,
      society.SOCIETY_PERFORMER_ID_C AS SOCIETY_SOCIETY_PERFORMER_ID_C,
      society.CMM_ID_TEXT_C AS SOCIETY_CMM_ID_TEXT_C,
      society._FIVETRAN_DELETED AS SOCIETY_FIVETRAN_DELETED,
      society._FIVETRAN_SYNCED AS SOCIETY_FIVETRAN_SYNCED

      FROM
      BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.CONTRIBUTOR_C AS contributor
      LEFT JOIN
      BUSINESS_SYSTEMS_SALESFORCE_DATA.NR.SOCIETY_C AS society
      ON contributor.ID = society.CONTRIBUTOR_C
      ;;
  }

  # --- CONTRIBUTOR DIMENSIONS ---

  dimension: contributor_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ID ;;
    label: "ID"
    group_label: "Contributor Data"
    primary_key: yes
  }

  dimension: contributor_owner_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_OWNER_ID ;;
    label: "Owner ID"
    group_label: "Contributor Data"
  }

  dimension: contributor_is_deleted {
    type: yesno
    sql: ${TABLE}.CONTRIBUTOR_IS_DELETED ;;
    label: "Is Deleted"
    group_label: "Contributor Data"
  }

  dimension: contributor_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_NAME ;;
    label: "Contributor Name"
    group_label: "Contributor Data"
    link: {
      label: "Go to Salesforce"
      url: "https://na1.salesforce.com/${contributor_id}"
    }
  }

  dimension_group: contributor_created {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_CREATED_DATE ;;
    label: "Created Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_created_by_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CREATED_BY_ID ;;
    label: "Created By ID"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_last_modified {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_LAST_MODIFIED_DATE ;;
    label: "Last Modified Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_last_modified_by_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_LAST_MODIFIED_BY_ID ;;
    label: "Last Modified By ID"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_system_modstamp {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_SYSTEM_MODSTAMP ;;
    label: "System Modstamp"
    group_label: "Contributor Data"
    hidden: yes
  }

  dimension_group: contributor_last_viewed {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_LAST_VIEWED_DATE ;;
    label: "Last Viewed Date"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_last_referenced {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_LAST_REFERENCED_DATE ;;
    label: "Last Referenced Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_account_priority {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ACCOUNT_PRIORITY_C ;;
    label: "Account Priority"
    group_label: "Contributor Data"
  }

  dimension: contributor_address_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_TYPE_C ;;
    label: "Address Type"
    group_label: "Contributor Address"
  }

  dimension: contributor_artist_name_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ARTIST_NAME_TYPE_C ;;
    label: "Artist Name Type"
    group_label: "Contributor Data"
  }

  dimension: contributor_bank_currency {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_CURRENCY_C ;;
    label: "Bank Currency"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_details_format {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_DETAILS_FORMAT_C ;;
    label: "Bank Details Format"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_status {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_STATUS_C ;;
    label: "Bank Status"
    group_label: "Contributor Banking"
  }

  dimension: contributor_citizenship_territory_2 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_C ;;
    label: "Citizenship Territory 2"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_3 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_C ;;
    label: "Citizenship Territory 3"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_4 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_C ;;
    label: "Citizenship Territory 4"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_C ;;
    label: "Citizenship Territory"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_contributor_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CONTRIBUTOR_TYPE_C ;;
    label: "Contributor Type"
    group_label: "Contributor Data"
  }

  dimension: contributor_country_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_TAX_C ;;
    label: "Country Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_country {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_C ;;
    label: "Country"
    group_label: "Contributor Address"
  }

  dimension: contributor_country_of_birth {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_OF_BIRTH_C ;;
    label: "Country Of Birth"
    group_label: "Contributor Data"
  }

  dimension: contributor_country_of_residence {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_OF_RESIDENCE_C ;;
    label: "Country Of Residence"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_eu_payee_vat_country {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EU_PAYEE_VAT_COUNTRY_C ;;
    label: "EU Payee VAT Country"
    group_label: "Contributor Address"
  }

  dimension: contributor_eu_payee_vat_registered {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EU_PAYEE_VAT_REGISTERED_C ;;
    label: "EU Payee VAT Registered"
    group_label: "Contributor Address"
  }

  dimension: contributor_entity {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ENTITY_C ;;
    label: "Entity"
    group_label: "Contributor Data"
  }

  dimension: contributor_gender {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_GENDER_C ;;
    label: "Gender"
    group_label: "Contributor Data"
  }

  dimension: contributor_payee_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_PAYEE_TYPE_C ;;
    label: "Payee Type"
    group_label: "Contributor Data"
  }

  dimension: contributor_relationship_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RELATIONSHIP_TYPE_C ;;
    label: "Relationship Type"
    group_label: "Contributor Data"
  }

  dimension: contributor_residency_territory_2 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_2_C ;;
    label: "Residency Territory 2"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_3 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_3_C ;;
    label: "Residency Territory 3"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_4 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_4_C ;;
    label: "Residency Territory 4"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_C ;;
    label: "Residency Territory"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_status {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_STATUS_C ;;
    label: "Status"
    group_label: "Contributor Data"
  }

  dimension: contributor_us_bank_account_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_BANK_ACCOUNT_TYPE_C ;;
    label: "US Bank Account Type"
    group_label: "Contributor Banking"
  }

  dimension: contributor_us_payee_tin_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_PAYEE_TIN_TYPE_C ;;
    label: "US Payee TIN Type"
    group_label: "Contributor Banking"
  }

  dimension: contributor_us_payee_tax_classification {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_PAYEE_TAX_CLASSIFICATION_C ;;
    label: "US Payee Tax Classification"
    group_label: "Contributor Banking"
  }

  dimension: contributor_us_payee_tax_form_type {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_PAYEE_TAX_FORM_TYPE_C ;;
    label: "US Payee Tax Form Type"
    group_label: "Contributor Banking"
  }

  dimension: contributor_us_wht_reporting_requirement {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_WHT_REPORTING_REQUIREMENT_C ;;
    label: "US WHT Reporting Requirement"
    group_label: "Contributor Banking"
  }

  dimension: contributor_aud_bsb {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_AUD_BSB_C ;;
    label: "AUD BSB"
    group_label: "Contributor Banking"
  }

  dimension: contributor_additional_details_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDITIONAL_DETAILS_ADDRESS_C ;;
    label: "Additional Details Address"
    group_label: "Contributor Data"
  }

  dimension: contributor_additional_details_bank_details {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDITIONAL_DETAILS_BANK_DETAILS_C ;;
    label: "Additional Details Bank Details"
    group_label: "Contributor Data"
  }

  dimension: contributor_additional_details_instructions {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDITIONAL_DETAILS_INSTRUCTIONS_C ;;
    label: "Additional Details Instructions"
    group_label: "Contributor Data"
  }

  dimension: contributor_additional_details_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDITIONAL_DETAILS_NAME_C ;;
    label: "Additional Details Name"
    group_label: "Contributor Data"
  }

  dimension: contributor_address_description {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_DESCRIPTION_C ;;
    label: "Address Description"
    group_label: "Contributor Address"
  }

  dimension: contributor_address_line_1_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_LINE_1_TAX_C ;;
    label: "Address Line 1 Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_address_line_2_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_LINE_2_TAX_C ;;
    label: "Address Line 2 Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_address_line_3_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_LINE_3_TAX_C ;;
    label: "Address Line 3 Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_address_type_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ADDRESS_TYPE_TEXT_C ;;
    label: "Address Type Text"
    group_label: "Contributor Address"
  }

  dimension_group: contributor_agreement_start {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_AGREEMENT_START_DATE_C ;;
    label: "Agreement Start Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_aliases {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ALIASES_C ;;
    label: "Aliases"
    group_label: "Contributor Data"
  }

  dimension: contributor_artist_music_brainz_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ARTIST_MUSIC_BRAINZ_ID_C ;;
    label: "Artist Music Brainz ID"
    group_label: "Contributor Data"
  }

  dimension: contributor_artist_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ARTIST_NAME_C ;;
    label: "Artist Name"
    group_label: "Contributor Data"
  }

  dimension: contributor_band_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BAND_NAME_C ;;
    label: "Band Name"
    group_label: "Contributor Data"
  }

  dimension: contributor_bank_account_description {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_ACCOUNT_DESCRIPTION_C ;;
    label: "Bank Account Description"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_account_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_ACCOUNT_NAME_C ;;
    label: "Bank Account Name"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_account_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_ACCOUNT_NUMBER_C ;;
    label: "Bank Account Number"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_ADDRESS_C ;;
    label: "Bank Address"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_iban {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_IBAN_C ;;
    label: "Bank IBAN"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_NAME_C ;;
    label: "Bank Name"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_sort_code {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_SORT_CODE_C ;;
    label: "Bank Sort Code"
    group_label: "Contributor Banking"
  }

  dimension: contributor_bank_swift_bic {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BANK_SWIFT_BIC_C ;;
    label: "Bank Swift BIC"
    group_label: "Contributor Banking"
  }

  dimension: contributor_beneficiary_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BENEFICIARY_ADDRESS_C ;;
    label: "Beneficiary Address"
    group_label: "Beneficiary"
  }

  dimension: contributor_beneficiary_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BENEFICIARY_NAME_C ;;
    label: "Beneficiary Name"
    group_label: "Beneficiary"
  }

  dimension: contributor_birth_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_BIRTH_NAME_C ;;
    label: "Birth Name"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_citizenship_end_date_2 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_END_DATE_2_C ;;
    label: "Citizenship End Date 2"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_end_date_3 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_END_DATE_3_C ;;
    label: "Citizenship End Date 3"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_end_date_4 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_END_DATE_4_C ;;
    label: "Citizenship End Date 4"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_end {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_END_DATE_C ;;
    label: "Citizenship End Date"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_notes_2 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_NOTES_2_C ;;
    label: "Citizenship Notes 2"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_notes_3 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_NOTES_3_C ;;
    label: "Citizenship Notes 3"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_notes_4 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_NOTES_4_C ;;
    label: "Citizenship Notes 4"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_notes {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_NOTES_C ;;
    label: "Citizenship Notes"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_start_date_2 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_START_DATE_2_C ;;
    label: "Citizenship Start Date 2"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_start_date_3 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_START_DATE_3_C ;;
    label: "Citizenship Start Date 3"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_start_date_4 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_START_DATE_4_C ;;
    label: "Citizenship Start Date 4"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_citizenship_start {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_START_DATE_C ;;
    label: "Citizenship Start Date"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_2_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_2_TEXT_C ;;
    label: "Citizenship Territory 2 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_3_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_3_TEXT_C ;;
    label: "Citizenship Territory 3 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_4_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_4_TEXT_C ;;
    label: "Citizenship Territory 4 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_citizenship_territory_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITIZENSHIP_TERRITORY_TEXT_C ;;
    label: "Citizenship Territory Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_city_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CITY_TAX_C ;;
    label: "City Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_client_owner {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CLIENT_OWNER_C ;;
    label: "Client Owner"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_collection_period_end {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_COLLECTION_PERIOD_END_DATE_C ;;
    label: "Collection Period End Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_contributor_type_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CONTRIBUTOR_TYPE_TEXT_C ;;
    label: "Contributor Type Text"
    group_label: "Contributor Data"
  }

  dimension: contributor_contributor_uuid {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_CONTRIBUTOR_UUID_C ;;
    label: "Contributor UUID"
    group_label: "Contributor Data"
  }

  dimension: contributor_country_tax_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_TAX_TEXT_C ;;
    label: "Country Tax Text"
    group_label: "Contributor Address"
  }

  dimension: contributor_country_of_birth_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_COUNTRY_OF_BIRTH_TEXT_C ;;
    label: "Country Of Birth Text"
    group_label: "Contributor Data"
  }

  dimension: contributor_eu_payee_ni_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EU_PAYEE_NI_NUMBER_C ;;
    label: "EU Payee NI Number"
    group_label: "Contributor Address"
  }

  dimension: contributor_eu_payee_vat_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EU_PAYEE_VAT_NUMBER_C ;;
    label: "EU Payee VAT Number"
    group_label: "Contributor Address"
  }

  dimension: contributor_eu_tax_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EU_TAX_ID_C ;;
    label: "EU Tax ID"
    group_label: "Contributor Address"
  }

  dimension_group: contributor_earliest_term_end_date_ral {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_EARLIEST_TERM_END_DATE_RAL_C ;;
    label: "Earliest Term End Date RAL"
    group_label: "Contributor Data"
  }

  dimension: contributor_email_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_EMAIL_ADDRESS_C ;;
    label: "Email Address"
    group_label: "Contributor Data"
  }

  dimension: contributor_entity_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ENTITY_TEXT_C ;;
    label: "Entity Text"
    group_label: "Contributor Data"
  }

  dimension: contributor_fax_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_FAX_NUMBER_C ;;
    label: "Fax Number"
    group_label: "Contributor Data"
  }

  dimension: contributor_foreign_payee_tax_identification_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_FOREIGN_PAYEE_TAX_IDENTIFICATION_NUMBER_C ;;
    label: "Foreign Payee Tax Identification Number"
    group_label: "Contributor Address"
  }

  dimension: contributor_forename {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_FORENAME_C ;;
    label: "Forename"
    group_label: "Contributor Data"
  }

  dimension: contributor_ipda_ipn {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_IPDA_IPN_C ;;
    label: "IPDA IPN"
    group_label: "Contributor Data"
  }

  dimension: contributor_in_collection {
    type: yesno
    sql: ${TABLE}.CONTRIBUTOR_IN_COLLECTION_C ;;
    label: "In Collection"
    group_label: "Contributor Data"
  }

  dimension: contributor_instruments {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_INSTRUMENTS_C ;;
    label: "Instruments"
    group_label: "Contributor Data"
  }

  dimension: contributor_knr_account_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_KNR_ACCOUNT_ID_C ;;
    label: "KNR Account ID"
    group_label: "Contributor Data"
  }

  dimension: contributor_maiden_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_MAIDEN_NAME_C ;;
    label: "Maiden Name"
    group_label: "Contributor Data"
  }

  dimension: contributor_main_music_genre {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_MAIN_MUSIC_GENRE_C ;;
    label: "Main Music Genre"
    group_label: "Contributor Data"
  }

  dimension: contributor_main_occupation {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_MAIN_OCCUPATION_C ;;
    label: "Main Occupation"
    group_label: "Contributor Data"
  }

  dimension: contributor_middle_name_1 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_MIDDLE_NAME_1_C ;;
    label: "Middle Name 1"
    group_label: "Contributor Data"
  }

  dimension: contributor_middle_name_2 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_MIDDLE_NAME_2_C ;;
    label: "Middle Name 2"
    group_label: "Contributor Data"
  }

  dimension: contributor_name_suffice {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_NAME_SUFFICE_C ;;
    label: "Name Suffice"
    group_label: "Contributor Data"
  }

  dimension: contributor_name_c {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_NAME_C ;;
    label: "Name C"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_notice_serve {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_NOTICE_SERVE_DATE_C ;;
    label: "Notice Serve Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_oa_account_id {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_OA_ACCOUNT_ID_C ;;
    label: "OA Account ID"
    group_label: "Contributor Data"
  }

  dimension: contributor_payee_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_PAYEE_NAME_C ;;
    label: "Payee Name"
    group_label: "Contributor Data"
  }

  dimension: contributor_phone_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_PHONE_NUMBER_C ;;
    label: "Phone Number"
    group_label: "Contributor Data"
  }

  dimension: contributor_post_collection_notes {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_POST_COLLECTION_NOTES_C ;;
    label: "Post Collection Notes"
    group_label: "Contributor Data"
  }

  dimension: contributor_prefix {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_PREFIX_C ;;
    label: "Prefix"
    group_label: "Contributor Data"
  }

  dimension: contributor_primary_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_PRIMARY_ADDRESS_C ;;
    label: "Primary Address"
    group_label: "Contributor Address"
  }

  dimension: contributor_relationship_description {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RELATIONSHIP_DESCRIPTION_C ;;
    label: "Relationship Description"
    group_label: "Contributor Data"
  }

  dimension: contributor_repertoire_owner {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_REPERTOIRE_OWNER_C ;;
    label: "Repertoire Owner"
    group_label: "Contributor Data"
  }

  dimension_group: contributor_residency_end_date_2 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_END_DATE_2_C ;;
    label: "Residency End Date 2"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_end_date_3 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_END_DATE_3_C ;;
    label: "Residency End Date 3"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_end_date_4 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_END_DATE_4_C ;;
    label: "Residency End Date 4"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_end {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_END_DATE_C ;;
    label: "Residency End Date"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_notes_2 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_NOTES_2_C ;;
    label: "Residency Notes 2"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_notes_3 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_NOTES_3_C ;;
    label: "Residency Notes 3"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_notes_4 {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_NOTES_4_C ;;
    label: "Residency Notes 4"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_notes {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_NOTES_C ;;
    label: "Residency Notes"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_start_date_2 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_START_DATE_2_C ;;
    label: "Residency Start Date 2"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_start_date_3 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_START_DATE_3_C ;;
    label: "Residency Start Date 3"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_start_date_4 {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_START_DATE_4_C ;;
    label: "Residency Start Date 4"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_residency_start {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_START_DATE_C ;;
    label: "Residency Start Date"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_2_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_2_TEXT_C ;;
    label: "Residency Territory 2 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_3_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_3_TEXT_C ;;
    label: "Residency Territory 3 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_4_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_4_TEXT_C ;;
    label: "Residency Territory 4 Text"
    group_label: "Residency & Citizenship"
  }

  dimension: contributor_residency_territory_text {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_RESIDENCY_TERRITORY_TEXT_C ;;
    label: "Residency Territory Text"
    group_label: "Residency & Citizenship"
  }

  dimension_group: contributor_rights_start {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_RIGHTS_START_DATE_C ;;
    label: "Rights Start Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_society {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_SOCIETY_C ;;
    label: "Society"
    group_label: "Contributor Data"
  }

  dimension: contributor_state_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_STATE_TAX_C ;;
    label: "State Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_suffix {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_SUFFIX_C ;;
    label: "Suffix"
    group_label: "Contributor Data"
  }

  dimension: contributor_surname {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_SURNAME_C ;;
    label: "Surname"
    group_label: "Contributor Data"
  }

  dimension: contributor_tax_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_TAX_ADDRESS_C ;;
    label: "Tax Address"
    group_label: "Contributor Address"
  }

  dimension_group: contributor_tax_form_expiry {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_TAX_FORM_EXPIRY_DATE_C ;;
    label: "Tax Form Expiry Date"
    group_label: "Contributor Address"
  }

  dimension_group: contributor_term_end {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.CONTRIBUTOR_TERM_END_DATE_C ;;
    label: "Term End Date"
    group_label: "Contributor Data"
  }

  dimension: contributor_term_end_note {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_TERM_END_NOTE_C ;;
    label: "Term End Note"
    group_label: "Contributor Data"
  }

  dimension: contributor_term_note {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_TERM_NOTE_C ;;
    label: "Term Note"
    group_label: "Contributor Data"
  }

  dimension: contributor_terminated {
    type: yesno
    sql: ${TABLE}.CONTRIBUTOR_TERMINATED_C ;;
    label: "Terminated"
    group_label: "Contributor Data"
  }

  dimension: contributor_territory_of_representation {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_TERRITORY_OF_REPRESENTATION_C ;;
    label: "Territory Of Representation"
    group_label: "Contributor Data"
  }

  dimension: contributor_us_payee_tax_identification_number {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_PAYEE_TAX_IDENTIFICATION_NUMBER_C ;;
    label: "US Payee Tax Identification Number"
    group_label: "Contributor Banking"
  }

  dimension: contributor_us_payee_tax_name {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_US_PAYEE_TAX_NAME_C ;;
    label: "US Payee Tax Name"
    group_label: "Contributor Banking"
  }

  dimension: contributor_web_address {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_WEB_ADDRESS_C ;;
    label: "Web Address"
    group_label: "Contributor Data"
  }

  dimension: contributor_zip_post_code_tax {
    type: string
    sql: ${TABLE}.CONTRIBUTOR_ZIP_POST_CODE_TAX_C ;;
    label: "ZIP Post Code Tax"
    group_label: "Contributor Address"
  }

  dimension: contributor_fivetran_deleted {
    type: yesno
    sql: ${TABLE}.CONTRIBUTOR_FIVETRAN_DELETED ;;
    label: "Fivetran Deleted"
    group_label: "Contributor Data"
    hidden: yes
  }

  dimension_group: contributor_fivetran_synced {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.CONTRIBUTOR_FIVETRAN_SYNCED ;;
    label: "Fivetran Synced"
    group_label: "Contributor Data"
    hidden: yes
  }

  # --- SOCIETY REGISTRATION DIMENSIONS ---

  dimension: society_id {
    type: string
    sql: ${TABLE}.SOCIETY_ID ;;
    label: "ID"
    group_label: "Society Registration"
  }

  dimension: society_is_deleted {
    type: yesno
    sql: ${TABLE}.SOCIETY_IS_DELETED ;;
    label: "Is Deleted"
    group_label: "Society Registration"
    hidden: yes
  }

  dimension: society_name {
    type: string
    sql: ${TABLE}.SOCIETY_NAME ;;
    label: "Society"
    group_label: "Society Registration"
  }

  dimension_group: society_created {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_CREATED_DATE ;;
    label: "Created Date"
    group_label: "Society Registration"
  }

  dimension: society_created_by_id {
    type: string
    sql: ${TABLE}.SOCIETY_CREATED_BY_ID ;;
    label: "Created By ID"
    group_label: "Society Registration"
  }

  dimension_group: society_last_modified {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_LAST_MODIFIED_DATE ;;
    label: "Last Modified Date"
    group_label: "Society Registration"
  }

  dimension: society_last_modified_by_id {
    type: string
    sql: ${TABLE}.SOCIETY_LAST_MODIFIED_BY_ID ;;
    label: "Last Modified By ID"
    group_label: "Society Registration"
  }

  dimension_group: society_system_modstamp {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_SYSTEM_MODSTAMP ;;
    label: "System Modstamp"
    group_label: "Society Registration"
    hidden: yes
  }

  dimension_group: society_last_viewed {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_LAST_VIEWED_DATE ;;
    label: "Last Viewed Date"
    group_label: "Society Registration"
  }

  dimension_group: society_last_referenced {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_LAST_REFERENCED_DATE ;;
    label: "Last Referenced Date"
    group_label: "Society Registration"
  }

  dimension: society_contributor_c {
    type: string
    sql: ${TABLE}.SOCIETY_CONTRIBUTOR_C ;;
    label: "Contributor Link"
    group_label: "Society Registration"
  }

  dimension: society_status {
    type: string
    sql: ${TABLE}.SOCIETY_STATUS_C ;;
    label: "Status"
    group_label: "Society Registration"
  }

  dimension_group: society_date {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.SOCIETY_DATE_C ;;
    label: "Date"
    group_label: "Society Registration"
  }

  dimension: society_notes {
    type: string
    sql: ${TABLE}.SOCIETY_NOTES_C ;;
    label: "Notes"
    group_label: "Society Registration"
  }

  dimension: society_performer_id {
    type: string
    sql: ${TABLE}.SOCIETY_SOCIETY_PERFORMER_ID_C ;;
    label: "Society Performer ID"
    group_label: "Society Registration"
  }

  dimension: society_cmm_id_text {
    type: string
    sql: ${TABLE}.SOCIETY_CMM_ID_TEXT_C ;;
    label: "CMM ID Text"
    group_label: "Society Registration"
  }

  dimension: society_fivetran_deleted {
    type: yesno
    sql: ${TABLE}.SOCIETY_FIVETRAN_DELETED ;;
    label: "Fivetran Deleted"
    group_label: "Society Registration"
    hidden: yes
  }

  dimension_group: society_fivetran_synced {
    type: time
    timeframes: [raw, date, week, month, year]
    convert_tz: no
    datatype: timestamp
    sql: ${TABLE}.SOCIETY_FIVETRAN_SYNCED ;;
    label: "Fivetran Synced"
    group_label: "Society Registration"
    hidden: yes
  }
}